Power BI

Power BI Training Course Content

Learning PowerPivot

  • What is PowerPivot for Excel
  • Importing Your Data PowerPivot
  • Creating a PowerPivot Data Model
  • Creating PivotTables with PowerPivot
  • Creating a Date Table
  • Using Slicers to Filter Data
  • Connecting Slicers to more than one PivotTable
  • Using Charts and Slicers to create interactive Dashboards
  • Using DAX in PowerPivot
  • Creating Calculated Columns
  • Creating Calculated Fields
  • Implicit and Explicit Calculated Fields
  • Using DAX aggregate functions in a PowerPivot PivotTable
  • Using Count Rows and Distinct Count Functions
  • The difference between evaluations using Row Context and evaluations using Filter Context

Advanced DAX functions

  • SUMX and CALCULATE
  • Time Intelligence Functions
  • Creating Key Performance Indicators
  • Using PowerPivot Sets

POWER QUERY

  • Adding Data to Power Query from various data sources
  • Creating a Query, the Query Editor Window
  • Load to Worksheet and Load to Data Model
  • Remove Duplicate Data in Columns
  • Split and Merge Columns of Data
  • Group data to create summary Queries
  • Merge and Append Queries
  • Transpose Data to swap Rows and Columns
  • Filling data Down to populate missing values
  • Unpivot Columns: flatten a “cross tab” table
  • Duplicate Columns, Creating Custom Columns and Additional Date Columns
  • Working with Applied Steps
  • Importing Data From a Folder

POWER VIEW

  • The Power View Field List
  • Using Text Boxes
  • Creating Tables
  • Changing Table Visualisations
  • Using a Matrix and Enable Drill Down
  • Using Cards; Setting up Titles and Pictures for Cards
  • Creating Chart Visualisations and Interactive Charts
  • Creating Power View Slicers
  • Using Tiles
  • Using Power View Filters
  • Working with interactive Bubble Charts using the Play Axis
  • Creating Power View Maps

POWER MAPS

  • Create a Power Map and Plot Geographic Data
  • Creation Visualisation; Column, Bubble, Heat map, Regions
  • Using the 3-D Environment
  • Using Charts with Power Maps
  • Working with Layers and adding Scenes
  • Adding Annotations
  • Visualising Data over Time
  • Playing the Tour

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.