elektrikçi şişli elektrikçi ataşehir elektrikçi üsküdar elektrikçi ümraniye deri mont

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.

Reviews

Power BI

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Rating