Power BI Desktop & Service with DAX- English

BI For Dashboards and DAX formula

Created by Ajay Parmar

Course Description

A very detailed discussion on Power BI introduction. A Free Microsoft tool works in real world to produce amazing , powerful and dynamic ,interactive dashboards/Reports.
Also, covered basic level information on PowerQuery for your better grip on fundamental.
Installation on Power BI – Real live example shown. No fast forward. Helpful for new students who never seen BI before.
Clustered Column and Stacked Column Chart visualizations covered . When and why they should be used and difference between them discussed too.
how to import data and things to be taken care of from different sources.
Drill down feature for deep analysis.
Stylish Drill-Through feature.
Line & Pie Visualizations.
Tool-tip and Tool Tips features – Why you need them and what is the difference.
How to make Tables and Matrix. Their role in reports .Difference between them. Advantages and disadvantages.
Learn how to create Slicers and rules to be followed.
What are Cards and Themes in BI – Simple awesome.
Learn not so much explored Analytical feature in Visualizations- A full detailed discussion on each feature. Why and where you need this.
Cross Filtering feature – No VBA , no complex formulas- Inbuilt feature which adds so much value to your reports and dashboards.
Area Chart Visualization -from scratch. with practical scenarios telling the difference between it and others .
Line and Column visualization – including stacked.
How to use custom visuals if you not happy with in-built ones though they are always extra-ordinary
Show amazing up and down falls in business using Waterfall visualization
Complete discussion on KPI ,Map , Tree Map , QnA feature, Decomposition tree visualization, Ribbon Chart.
How to use shapes ,bookmarks and selections in power-bi to take the reports to extreme level.
Use of Slicers in navigating pages.
How to Create a Dashboard in Powerbi Using above points.
What is DAX Measure and Calculated Column (This is Part1 series of DAX)
What is the difference between Measure and Calculated Columns in terms of functioning and fundamentals.
Which one is better or which one to choose while writing DAX Formula in PowerBI
To begin with , Learn first how to write DAX in PowerBI window. How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE . Its different from excel in terms of fundamental.
Learn amazing DAX functions like SUMX, COUNTX,FILTER
How to use One DAX into another DAX ,If situation demands.
What is a DAX Studio and how it can help you in understanding DAX
Most versatile and used DAX in POWERBI – CALCULATE – From basic to advance
Utmost important DAX like – ALL , ALL SELECTED, ALL EXCEPT
Mixing of ALL with CALCUALTE to yield powerful results
How to write IF dax as a calculated column
How to write IF as a measure. Its fundamentals which is important.
Use of DISTINCT and DISTINCTCOUNT and what is the difference between them.
How to handle multiple conditions in a simpler manner using SWITCH Dax. Its alternate to your IF Dax.
What is IN and NOT dax. Check out their use.
Get ready for surprise Tests.
Ask anything on the forum related to DAX. You will have my support .
TEXT Functions like LEFT, RIGHT, MID , FIND, SUBSTITUE – Learn their importance in Data crunching.
How to find out top or bottom scores in a table. For eg, how to find top scorers or sales revenue values . Learn TOPN in full detail.
How to use RANKX – its fundamentals with challenges
Which one better – Calculated column DAX or Measure DAX – with scenarios
Learn about HASONEVALUE – From functioning to practical use
Get ready for Surprise Tests also – See how well you are doing.
Related DAX – Vlookup way
All great Time Intelligence DAX functions
Comparison of performance over the years, months,quarters
Cumulative SUMs – yearly, monthy , daily
Why we should know SUMMARIZE Dax
CALCULATETABLE Dax and its use with Summarize dax
Powerful Dax – Selected Value

Course Curriculum

Introduction to PowerBI – Understand in-depth its Components

Introduction to basic and important concepts

52:11

How to Import Excel Data in BI and fundamentals

Clustered Column Visual – Let us finally begin the show

Stacked Column with Bar Visuals

SLICERS Visual – Life changing experience

Line Visual – How to see TRENDS

Area Chart Visual – Magnitude is the key

Column Line and Ribbon Visuals – Do the Deep analysis

Introduction PowerQuery for you – Overview

Power query came to rescue – BI Refresh issues on modifying the data source

Quiz Score – How did students performed

Quiz Score discussion continues

Quiz Score ends – What was your Score

Small multiples Feature in BI

My favorite Tables – Most used Visual

Multi Card Visual – Useful in displaying overall numbers

Gauge Visual – Track how far are we from Targets

A surprise Test conducted- check your score

MATRIX Visual – Its awesome – Everything you need to know

How to use Drill on feature in Matrix – game changing

Map Visual

Decomposition Visual

How to use Drill on feature – Deep dive

CrossFiltering feature – A unique way of doing the automations

Filter pane in BI

Shapes in BI

Buttons in BI

Let us create a Dashboard – Begin the story

Dashboards Continues

Final touch to your Dashboard – Great success

Scattered Visualization – How one parameter affect second

Funnel Visual

Import Data from Google Sheet and how to change it – Challenge solved

Data Modelling – Relationships

BI Service – Sharing of Reports

DAX Tutorials Starts now

DAX Introduction – Calculated Column and Measures

31:47
BASICS DAX now

23:35
COUNT Family DAX – ALL in One

15:51
FILTER DAX by definition and Use with DAX Studio- Complete discussion

23:40
SUMX DAX- One of the most fantastic thing developed over the years

33:31
What is COUNTX and how to use it.

07:04
What is COUNTAX Dax and its use.

25:06
What is DISTINCTCOUNT and DISTINCT DAX – Very Useful and Interesting.

27:59
The biggest and most versatile DAX – CALCULATE

01:00:08
CALCULATE & ALLSELECTED & ALLEXCEPT DAX – Very important and Powerful

40:24
CALCULATE & ALLSELECTED & ALLEXCEPT DAX

21:09
Test for you

42:01
Learn your IF Dax in a style

31:04
One for Test for you- Monitor your progress

25:01
Use SWITCH Dax – Great way to put logics together in a faster way

25:01
IN use in CALCULATE and NOT

07:18
TEXT DAX Functions

16:31
TOPN – Get top or bottom performances or scorers names

25:24
userrelationship

17:41
Difference between Measure and Calculated Columns

53:08
RANKX DAX – Part1

12:20
RANKX DAX Challenge – Part2

18:27
How to Use SELECTEDVAL

19:49
More example on SELECTEDVALUE

09:06
RANKX with SELECTED VALUE

16:25
DAX – RELATED -its your new VLOOKUP

21:25
HAS ONE VALUE – DAX – it use is incredible

11:43
A challenge for you

27:56
Time Intelligence Begins – Create CALENDERs

16:47
Time Intelligence – Get Cumulative totals using YTD MTD QTD

26:34
Exercise

20:27
Time Intelligence – First Date and Last Date – Part1

03:06
Time Intelligence – First Date and Last Date – Part2

05:49
Find out End date of a month OR Start date of a year

04:54
Find out CLOSING BALANCE of a Month or quarter or Year

07:28
My favourite DATEADD

11:09
Your question my solution

42:05
Summarize dax

20:25
Dynamic Title for dashboard

12:13
Titles using Min and Max

05:05
How to Compare two categories but in one Visual

15:24

₹1,200.00

Level

All Levels
Total Enrolled

66
Duration

35 hours
Last Updated

February 7, 2023

Power BI Desktop & Service with DAX- English

₹1,200.00

Level

All Levels
Total Enrolled

66
Duration

35 hours
Last Updated

February 7, 2023

Course Description

A very detailed discussion on Power BI introduction. A Free Microsoft tool works in real world to produce amazing , powerful and dynamic ,interactive dashboards/Reports.
Also, covered basic level information on PowerQuery for your better grip on fundamental.
Installation on Power BI – Real live example shown. No fast forward. Helpful for new students who never seen BI before.
Clustered Column and Stacked Column Chart visualizations covered . When and why they should be used and difference between them discussed too.
how to import data and things to be taken care of from different sources.
Drill down feature for deep analysis.
Stylish Drill-Through feature.
Line & Pie Visualizations.
Tool-tip and Tool Tips features – Why you need them and what is the difference.
How to make Tables and Matrix. Their role in reports .Difference between them. Advantages and disadvantages.
Learn how to create Slicers and rules to be followed.
What are Cards and Themes in BI – Simple awesome.
Learn not so much explored Analytical feature in Visualizations- A full detailed discussion on each feature. Why and where you need this.
Cross Filtering feature – No VBA , no complex formulas- Inbuilt feature which adds so much value to your reports and dashboards.
Area Chart Visualization -from scratch. with practical scenarios telling the difference between it and others .
Line and Column visualization – including stacked.
How to use custom visuals if you not happy with in-built ones though they are always extra-ordinary
Show amazing up and down falls in business using Waterfall visualization
Complete discussion on KPI ,Map , Tree Map , QnA feature, Decomposition tree visualization, Ribbon Chart.
How to use shapes ,bookmarks and selections in power-bi to take the reports to extreme level.
Use of Slicers in navigating pages.
How to Create a Dashboard in Powerbi Using above points.
What is DAX Measure and Calculated Column (This is Part1 series of DAX)
What is the difference between Measure and Calculated Columns in terms of functioning and fundamentals.
Which one is better or which one to choose while writing DAX Formula in PowerBI
To begin with , Learn first how to write DAX in PowerBI window. How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE . Its different from excel in terms of fundamental.
Learn amazing DAX functions like SUMX, COUNTX,FILTER
How to use One DAX into another DAX ,If situation demands.
What is a DAX Studio and how it can help you in understanding DAX
Most versatile and used DAX in POWERBI – CALCULATE – From basic to advance
Utmost important DAX like – ALL , ALL SELECTED, ALL EXCEPT
Mixing of ALL with CALCUALTE to yield powerful results
How to write IF dax as a calculated column
How to write IF as a measure. Its fundamentals which is important.
Use of DISTINCT and DISTINCTCOUNT and what is the difference between them.
How to handle multiple conditions in a simpler manner using SWITCH Dax. Its alternate to your IF Dax.
What is IN and NOT dax. Check out their use.
Get ready for surprise Tests.
Ask anything on the forum related to DAX. You will have my support .
TEXT Functions like LEFT, RIGHT, MID , FIND, SUBSTITUE – Learn their importance in Data crunching.
How to find out top or bottom scores in a table. For eg, how to find top scorers or sales revenue values . Learn TOPN in full detail.
How to use RANKX – its fundamentals with challenges
Which one better – Calculated column DAX or Measure DAX – with scenarios
Learn about HASONEVALUE – From functioning to practical use
Get ready for Surprise Tests also – See how well you are doing.
Related DAX – Vlookup way
All great Time Intelligence DAX functions
Comparison of performance over the years, months,quarters
Cumulative SUMs – yearly, monthy , daily
Why we should know SUMMARIZE Dax
CALCULATETABLE Dax and its use with Summarize dax
Powerful Dax – Selected Value

Course Curriculum

Introduction to PowerBI – Understand in-depth its Components

Introduction to basic and important concepts

52:11

How to Import Excel Data in BI and fundamentals

Clustered Column Visual – Let us finally begin the show

Stacked Column with Bar Visuals

SLICERS Visual – Life changing experience

Line Visual – How to see TRENDS

Area Chart Visual – Magnitude is the key

Column Line and Ribbon Visuals – Do the Deep analysis

Introduction PowerQuery for you – Overview

Power query came to rescue – BI Refresh issues on modifying the data source

Quiz Score – How did students performed

Quiz Score discussion continues

Quiz Score ends – What was your Score

Small multiples Feature in BI

My favorite Tables – Most used Visual

Multi Card Visual – Useful in displaying overall numbers

Gauge Visual – Track how far are we from Targets

A surprise Test conducted- check your score

MATRIX Visual – Its awesome – Everything you need to know

How to use Drill on feature in Matrix – game changing

Map Visual

Decomposition Visual

How to use Drill on feature – Deep dive

CrossFiltering feature – A unique way of doing the automations

Filter pane in BI

Shapes in BI

Buttons in BI

Let us create a Dashboard – Begin the story

Dashboards Continues

Final touch to your Dashboard – Great success

Scattered Visualization – How one parameter affect second

Funnel Visual

Import Data from Google Sheet and how to change it – Challenge solved

Data Modelling – Relationships

BI Service – Sharing of Reports

DAX Tutorials Starts now

DAX Introduction – Calculated Column and Measures

31:47
BASICS DAX now

23:35
COUNT Family DAX – ALL in One

15:51
FILTER DAX by definition and Use with DAX Studio- Complete discussion

23:40
SUMX DAX- One of the most fantastic thing developed over the years

33:31
What is COUNTX and how to use it.

07:04
What is COUNTAX Dax and its use.

25:06
What is DISTINCTCOUNT and DISTINCT DAX – Very Useful and Interesting.

27:59
The biggest and most versatile DAX – CALCULATE

01:00:08
CALCULATE & ALLSELECTED & ALLEXCEPT DAX – Very important and Powerful

40:24
CALCULATE & ALLSELECTED & ALLEXCEPT DAX

21:09
Test for you

42:01
Learn your IF Dax in a style

31:04
One for Test for you- Monitor your progress

25:01
Use SWITCH Dax – Great way to put logics together in a faster way

25:01
IN use in CALCULATE and NOT

07:18
TEXT DAX Functions

16:31
TOPN – Get top or bottom performances or scorers names

25:24
userrelationship

17:41
Difference between Measure and Calculated Columns

53:08
RANKX DAX – Part1

12:20
RANKX DAX Challenge – Part2

18:27
How to Use SELECTEDVAL

19:49
More example on SELECTEDVALUE

09:06
RANKX with SELECTED VALUE

16:25
DAX – RELATED -its your new VLOOKUP

21:25
HAS ONE VALUE – DAX – it use is incredible

11:43
A challenge for you

27:56
Time Intelligence Begins – Create CALENDERs

16:47
Time Intelligence – Get Cumulative totals using YTD MTD QTD

26:34
Exercise

20:27
Time Intelligence – First Date and Last Date – Part1

03:06
Time Intelligence – First Date and Last Date – Part2

05:49
Find out End date of a month OR Start date of a year

04:54
Find out CLOSING BALANCE of a Month or quarter or Year

07:28
My favourite DATEADD

11:09
Your question my solution

42:05
Summarize dax

20:25
Dynamic Title for dashboard

12:13
Titles using Min and Max

05:05
How to Compare two categories but in one Visual

15:24

Power BI Desktop & Service with DAX- English

Power BI Desktop & Service with DAX- English

BI For Dashboards and DAX formula

Created by Ajay Parmar

Material Includes

Course Description

Course Curriculum

Introduction to PowerBI – Understand in-depth its Components

Introduction to basic and important concepts

How to Import Excel Data in BI and fundamentals

Data importing

Clustered Column Visual – Let us finally begin the show

Clustered Column Visual

Stacked Column with Bar Visuals

Stacked visual

Bar Visual

SLICERS Visual – Life changing experience

Slicers

Line Visual – How to see TRENDS

Line Visual -Trends

Area Chart Visual – Magnitude is the key

Area Visual

Column Line and Ribbon Visuals – Do the Deep analysis

Line Column Visual

Introduction PowerQuery for you – Overview

PowerQuery Intro

Power query came to rescue – BI Refresh issues on modifying the data source

Taking up your issue

Quiz Score – How did students performed

BI Test begins

Quiz Score discussion continues

Test continues

Quiz Score ends – What was your Score

Test finished

Small multiples Feature in BI

more interesting features

My favorite Tables – Most used Visual

Table visual

Multi Card Visual – Useful in displaying overall numbers

MultiCard

Gauge Visual – Track how far are we from Targets

How far are we from Targets

A surprise Test conducted- check your score

Another Test solved

MATRIX Visual – Its awesome – Everything you need to know

Matrix visual begins

Next level and expand buttons

Drill On

subtotals

How to use Drill on feature in Matrix – game changing

Map Visual

map visual begins

map more knowledge

Map continues

Map – Deep knowledge

Map ends

Decomposition Visual

Intro

part2

Part3

How to use Drill on feature – Deep dive

Drill on

CrossFiltering feature – A unique way of doing the automations

cross filter

Filter pane in BI

Filter pane

Shapes in BI

Shapes

Buttons in BI

Buttons Role

Let us create a Dashboard – Begin the story

Dashboard starts

Dashboards Continues

Dashboard continues

Final touch to your Dashboard – Great success

Dashboard Finished

Scattered Visualization – How one parameter affect second

Scattered – Relationship between two fields

Funnel Visual

Nice way to see top contributions