Intro to Power Business Intelligence

Definitions:

• "Business Intelligence" comprises the strategies and technologies used by enterprises for the data analysis of business information. BI technologies provide historical, current, and predictive views of business operations.
  • Structured
  • ETL (Extract, Transform, Load
  • Database / Data warehouse / Data lake
• "Data Analysis" is an approach to data that seeks to find insights and indentify patters or trends (Nuggets of Insight).
• "Data Mining" = Analyzing large amounts of data.
• "Big Data" = High-volume, unstructured, real-world generated data.
  • Volume
  • Variety
  • Velocity
  • Variability
  • Veracity (How reliable?)

5 Stages of BI

1. Collect and store data
2. Transform "Big" data into "BI" data
3. Present Key Metrics
4. Evaluate data to discover patterns, trends, and insights
5. Sharing reports and findings to empower others (Visualizations and Presentations)

Pricing

1. Free (just hit X on logins)
2. $9.99/month/person for sharing
3. Enterprise Level

Row-Level Security

1. Need a subscription (because it's useless without sharing)
2. Service Admin

Import Apps

• Mailchimp
• Twilio (SMS)
• Marketo
• Insightly

Data Analysis Expressions

• Related
• Switch
• SelectedValue
• IsBlank
• and &&
• concat &

Direct Connectivity

• [clustername].azurehdinsight.net
• Power Platform

Importing Data

• Manual Refresh
• Schedule Refresh
• Direct Query (never stale)

Direct Query

• Instead of Importing data into the file, you are connected to a Data Source.
• File -> Options -> Data source settings (also in Transform data dropdown)
• Get Data -> Azure Sql Database
• Options for Authentication (not available on Importing data)
• Creates a Composite Model based on the link to the data (keeps relationships)
• Never goes stale because it updates as you click
• However you do have some control over this if performance on the Database is an issue
• File -> Options -> Options -> Current File -> Query Reduction
• On-prem (non-cloud) data sources require a Gateway (Power Bi -> Download -> Data Gateway)

Visuals / Report Builder

Natural Query Language

Data

Conditional Formatting

Marketplace / Gallery / Links

• Power BI
• Embedding Power BI
• Data Stories Galery
• Direct Query
• Bidirectional Cross Filtering
• Bidirectional Relationships