Skip to main content

Excel data analytics advanced tools and Power Bi


Target audience: financiers, analysts, and employees with an advanced knowledge in Excel.

  • Power Pivot

Analyzing Data

Write measures using DAX language

Work with Data spread over multiple tables through relationships

Power Pivot isn't limited in the number of rows. You can work on millions of rows stored in the Power Pivot model.

Create relationships, analysis and KPI report

Connect pivot table to the data model and add slicers, pivotcharts and timelines

Power Query

Get and transform data

Automate tasks of getting and cleaning data

Import files from folder

Split columns

Extract text from string

Add and calculated columns

Add custom columns/ from examples

conditional columns

If function in PQ

Dates and time calculations

Data types


Merge queries

Merge columns

Create connection to query

Append multiple sheets into one sheet

COMBINE Multiple Excel Files into ONE

Write basic M functions

Load the Data to Excel or Power Pivot model

Update original data and refresh query

**Both are available in Excel and Power BI

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights

Connect Excel Data with Web data

Create dashboards using visualizations

Create measures, calculated columns using DAX


Measure that references another measure

Organize measures in a new measure table

Iterator functions

Calculate function

Using visuals as slicers

Formatting slicers

Conditional formatting in power bi

Align Objects

Create Page navigation

Lock Objects

Tips and tricks