Visualizing and Analyzing Data With Power BI

Discover how to visualize and analyze data using Power BI.

Working knowledge of data concepts and structures as well as a working knowledge of Microsoft Excel is needed for this course.
 

Course length: 2 days, Delivery: Online or In-class.

Please call (475) 328-2227 with questions.

Course Overview

Introducing Power BI

• Using Power BI

• The building blocks of Power

• A quick look at the Power BI service

• Getting data Overview of Power BI Desktop

• Getting started with Power BI Desktop

• Connect to data sources in Power BI Desktop

• Clean and transform your data with the Query Editor

• More advanced data sources and transformation

• Cleaning irregularly formatted data
   

Modeling: Introduction to modeling your data

• How to manage your data relationships

• Create calculated columns

• Optimizing data models

• Create calculated measures

• Create calculated tables

• Explore your time-based data
   

Visualizations: Introduction to visuals in Power BI

• Create and customize simple visualizations

• Combination charts

• Slicers

• Map visualizations

• Matrixes and tables

• Scatter charts

• Waterfall and funnel charts

• Gauges and single-number cards

• Modify colors in charts and visuals

• Shapes, text boxes, and images

• Page layout and formatting

• Group interactions among visualizations

• Duplicate a report page

• Show categories with no data

• Summarization and category options

• Z-order

• Visual hierarchies and drill-down

• R integration in Power BI Desktop
   

Exploring data: Introduction to the Power BI service

• Quick insights in Power BI

• Create and configure a dashboard

• Ask questions of your data with natural language

• Create custom Q&A suggestions

• Share dashboards with your organization

• Display visuals and tiles full-screen

• Edit tile details and add widgets

• Get more space on your dashboard

• Install and configure a personal gateway
   

Power BI and Excel: Introduction to using Excel data in Power BI

• Upload Excel data to Power BI

• Import Power View and Power Pivot to Power BI

• Connect OneDrive for Business to Power BI

• Excel in Power BI - summary
   

Publishing and sharing: Introduction to content packs, security, and groups

• Publish Power BI Desktop reports

• Print and export dashboards and reports

• Manually republish and refresh your data

• Introducing Power BI Mobile

• Create groups in Power BI

• Build content packs

• Use content packs

• Update content packs

• Integrate OneDrive for Business with Power BI

• Publish to web
   

Introduction to DAX

• DAX calculation types

• DAX functions

• Using variables in DAX expressions

• Table relationships and DAX

• DAX tables and filtering