Microsoft Power BI Foundations

Book Now

Course Description

Microsoft Power BI is quickly becoming one of the world’s most powerful self-service business intelligence platforms, as well as an absolutely essential tool for today’s top data professionals

Curriculum

• Introduction to Power BI Desktop
  Downloading Power BI Desktop
  Power BI Desktop Interphase & Workflow

• Connecting & Shaping Data
  Types of Data Connectors
  Power Query Editor
  Connecting to a Database
  Calculated Columns
  Grouping & Aggregating
  Pivoting & Unpivoting
  Merging Queries
  Appending Queries
  Refreshing Queries

• Creating a Data Model
  Fact & Dimension Tables
  Primary & Foreign Keys
  Creating Table Relationships
  Star & Snowflake Schema

• Data Analysis with Pivot Tables

  Creating a Pivot Table
  Modifying Pivot Table Views
  Summarize Values by Options
  Show Values as Calculations
  Sorting & Filtering
  Slicers & Timelines
  Calculated Fields
  Refreshing Pivot Table Data

• Data Visualization with Charts & Graphs
  Why Visualize Data?
  Creating a Basic Chart
  Choosing the Right Chart Type
  Line & Area Charts
  Bar & Column Charts
  Combo Charts
  Pie & Donut Charts
  Histograms
  Maps