QuickStart to Power BI for Analysts and Users

Introduction to Self-Service BI Solutions

• Introduction to business intelligence
• Introduction to data analysis
• Introduction to data visualization
• Overview of self-service BI
• Considerations for self-service BI
• Microsoft tools for self-service BI
• Hands-on: Exploring an Enterprise BI solution
• Viewing reports
• Creating a Power BI report
• Creating a Power BI dashboard

Introducing Power BI

• Power BI
• The Power BI service
• Hands-on: Creating a Power BI dashboard
• Connecting to Power BI data
• Create a Power BI dashboard

Power BI Exploration

• Using Excel as a data source for Power BI
• The Power BI data model
• Using databases as a data source for Power BI
• The Power BI service
• Hands-on: Importing data into Power BI
• Importing Excel files into Power BI
• Viewing reports from Excel files

Shaping and Combining Data

• Power BI desktop queries
• Shaping data
• Combining data
• Hands-on: Shaping and combining data
• Shape power BI data
• Combine Power BI data

Modelling data

• Relationships
• DAX queries
• Calculations and measures
• What is DAX (Overview)
• What is DAX (Tabular)
• Creating Calculated Columns (Basics)
• Navigation Functions
• Conditional and Logical Functions
• Creating Calculated Measures
• Time Intelligence (Overview)
• Time Intelligence (Time Intelligence Functions)
• Using X-Functions and A-Functions
• Table Functions
• DAX as a Query Language
• Hands-on: Let’s Model Data
• Create relationships
• Calculations

Interactive Data Visualizations

• Creating Power BI reports
• Managing a Power BI solution
• Hands-on: Creating a Power BI report
• Connecting to Power BI data
• Building Power BI reports
• Creating a Power BI dashboard

Managing Power BI web interface

• Creating reports and referencing data sets
• Managing Power BI web
• Creating dashboards via web
• Creating Basic Reports with the Power BI Desktop
• Creating Interactive Reports (Adding Slicers for Filters)
• Creating Interactive Reports (Visualizing Tabular Data)
• Creating Interactive Reports (Visualizing Categorical Data)
• Creating Interactive Reports (Visualizing Data Trends)
• Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
• Creating Interactive Reports (Visualizing Geographical Data with Maps)
• Creating Interactive Reports (Visualizing Goal Tracking)
• Creating Interactive Reports (Using Custom Visuals)
• Creating Interactive Reports (Digital Storytelling)
• Creating Interactive Reports (Other Features)
• Using the Power BI Service (Deploying to the Power BI Service)
• Using the Power BI Service (Creating and Sharing Dashboards)
• Using the Power BI Service (Using Power BI Q&A)
• Using the Power BI Service (Setting up App Workspaces)
• Using the Power BI Service (Subscriptions and Alerts)
• Using the Power BI Service (Excel Integration)
• Using the Power BI Service (Export and Embed Options)
• Refreshing the Data (Refreshing Data Overview)
• Refreshing the Data (Installing the Data Gateway)
• Refreshing the Data (Scheduling a Data Refresh)
• Mobile BI (Power BI Mobile Overview)
• Mobile BI (Designing Reports and Dashboards for Mobile)
• Mobile BI (Interacting with the Power BI Mobile App)

Join an engaging hands-on learning environment, where you’ll learn:

• Perform Power BI desktop data transformation
• Describe Power BI desktop modeling
• Create a Power BI desktop visualization
• Implement the Power BI service
• Describe how to connect to Excel data
• Describe how to collaborate with Power BI data
• Connect directly to data stores
• Describe the Power BI developer API
• Describe the Power BI mobile app
• Manage Power BI for the web

This course has a 50% hands-on labs to 50% lecture ratio with engaging instruction, demos, group discussions, labs, and project work.

Before attending this course, you should have:

• A general knowledge of database concepts (fields, records, relationships)
• Awareness of key business priorities such as revenue, profitability, and financial accounting
• Comfort when using Excel

Business Analyst, Data Analysts, Data Scientist, or professionals responsible for reporting on your organization's data.