Introduction to Power BI

16 hours of instruction (Power BI)

This course is designed for students looking to take their data analysis skills to a more advanced level and learn how to communicate effectively with data. By the end of this program, students will be able to build interactive data visualizations, define best practices in data visualization, and manipulate data in Power BI.

OBJECTIVES

1. Build data dashboards in Power BI
2. Import and manipulate data in Power BI
3. Describe the best practices for data visualization

PREREQUISITES

While there are no prerequisites for this workshop, it is best suited to attendees with some experience working with data.

SYLLABUS & TOPICS COVERED

1. Understanding Power BI and its capabilities
   • What is BI and Power BI?
   • Logical structure of Power BI
   • Uses for Power BI across industries
   • Review the four layers
2. Building a report with formatting
   • Create simple chart
   • Labels/Titles/Legends
   • Radial gauge-doughnuts
   • Conditional formatting
   • Filters
   • Formatting visuals with slicers
3. Lab 1: Creating your first Power BI report
   • Load data–sum/sort
   • Slicers
   • Save and publish
   • Summary report
4. Lab 2: Developing the Report Layer
   • Formatting charts
   • Applying filters such as drillthrough
   • Reintroducing slicers
   • Formatting your visual
5. Storytelling with Visualization
   • Importance of storytelling in BI
   • Design principles
   • Examples of storytelling
6. Lab 3: Power BI Web Services
   • Navigating the portal
   • Building a report online
   • Building a dashboard
   • Understanding workbook
   • Understanding datasets
7. Program in Power BI Using DAX
   • Understanding data tab
   • Fields pane
   • Measure formula
   • Calculate function
   • Connect data from a PowerBI.com
8. Lab 4: Calculating Job Fulfillment & Intro to Calculated Columns
   • Visualize job fulfillment
   • Logical vs physical columns
   • Create columns

SOFTWARE REQUIREMENTS

Microsoft Power BI