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
- All BI and data files are attached for you to download
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
-
Data importing
41:24
Clustered Column Visual – Let us finally begin the show
-
Clustered Column Visual
57:00
Stacked Column with Bar Visuals
-
Stacked visual
17:11 -
Bar Visual
19:17
SLICERS Visual – Life changing experience
-
Slicers
24:55
Line Visual – How to see TRENDS
-
Line Visual -Trends
18:06
Area Chart Visual – Magnitude is the key
-
Area Visual
03:58
Column Line and Ribbon Visuals – Do the Deep analysis
-
Line Column Visual
23:26
Introduction PowerQuery for you – Overview
-
PowerQuery Intro
01:34:21
Power query came to rescue – BI Refresh issues on modifying the data source
-
Taking up your issue
24:34
Quiz Score – How did students performed
-
BI Test begins
20:30
Quiz Score discussion continues
-
Test continues
05:42
Quiz Score ends – What was your Score
-
Test finished
12:20
Small multiples Feature in BI
-
more interesting features
08:51
My favorite Tables – Most used Visual
-
Table visual
21:45
Multi Card Visual – Useful in displaying overall numbers
-
MultiCard
12:35
Gauge Visual – Track how far are we from Targets
-
How far are we from Targets
28:54
A surprise Test conducted- check your score
-
Another Test solved
49:16
MATRIX Visual – Its awesome – Everything you need to know
-
Matrix visual begins
26:00 -
Next level and expand buttons
10:22 -
Drill On
13:42 -
subtotals
13:31
How to use Drill on feature in Matrix – game changing
Map Visual
-
map visual begins
17:26 -
map more knowledge
22:59 -
Map continues
07:56 -
Map – Deep knowledge
12:41 -
Map ends
13:18
Decomposition Visual
-
Intro
38:53 -
part2
08:47 -
Part3
11:16
How to use Drill on feature – Deep dive
-
Drill on
15:00
CrossFiltering feature – A unique way of doing the automations
-
cross filter
09:30
Filter pane in BI
-
Filter pane
14:21
Shapes in BI
-
Shapes
17:24
Buttons in BI
-
Buttons Role
41:25
Let us create a Dashboard – Begin the story
-
Dashboard starts
23:03
Dashboards Continues
-
Dashboard continues
29:31
Final touch to your Dashboard – Great success
-
Dashboard Finished
36:49
Scattered Visualization – How one parameter affect second
-
Scattered – Relationship between two fields
33:30
Funnel Visual
-
Nice way to see top contributions
09:07
Import Data from Google Sheet and how to change it – Challenge solved
-
GoogleSheet in BI issue
11:55
Data Modelling – Relationships
-
Part1
40:23 -
Part2
27:27 -
Part3
35:21
BI Service – Sharing of Reports
-
BI Service introduction
26:13 -
How to Publish BI Reports
16:25 -
BI Service features – know your new Tool
08:01 -
How to share WorkSpaces
33:15 -
Sharing BI Reports
17:09 -
Admin and Viewer Roles
30:03 -
Exploring Other Sharing options – With specific people
24:23
DAX Tutorials Starts now
-
DAX Introduction – Calculated Column and Measures
31:47 -
BASICS DAX now
23:35 -
COUNT Family DAX – ALL in One
15:50 -
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:05 -
What is DISTINCTCOUNT and DISTINCT DAX – Very Useful and Interesting.
27:58 -
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:00 -
Use SWITCH Dax – Great way to put logics together in a faster way
25:00 -
IN use in CALCULATE and NOT
07:19 -
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:48 -
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:55 -
Time Intelligence Begins – Create CALENDERs
16:47 -
Time Intelligence – Get Cumulative totals using YTD MTD QTD
26:34 -
Exercise
20:28 -
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:27 -
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:04 -
How to Compare two categories but in one Visual
15:24
₹899.00
₹6,400.00
-
LevelAll Levels
-
Total Enrolled147
-
Duration35 hours
-
Last UpdatedFebruary 7, 2023
Hi, Welcome back!
Power BI Desktop & Service with DAX- English
₹899.00
₹6,400.00
-
LevelAll Levels
-
Total Enrolled147
-
Duration35 hours
-
Last UpdatedFebruary 7, 2023
Material Includes
- All BI and data files are attached for you to download
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
-
Data importing
41:24
Clustered Column Visual – Let us finally begin the show
-
Clustered Column Visual
57:00
Stacked Column with Bar Visuals
-
Stacked visual
17:11 -
Bar Visual
19:17
SLICERS Visual – Life changing experience
-
Slicers
24:55
Line Visual – How to see TRENDS
-
Line Visual -Trends
18:06
Area Chart Visual – Magnitude is the key
-
Area Visual
03:58
Column Line and Ribbon Visuals – Do the Deep analysis
-
Line Column Visual
23:26
Introduction PowerQuery for you – Overview
-
PowerQuery Intro
01:34:21
Power query came to rescue – BI Refresh issues on modifying the data source
-
Taking up your issue
24:34
Quiz Score – How did students performed
-
BI Test begins
20:30
Quiz Score discussion continues
-
Test continues
05:42
Quiz Score ends – What was your Score
-
Test finished
12:20
Small multiples Feature in BI
-
more interesting features
08:51
My favorite Tables – Most used Visual
-
Table visual
21:45
Multi Card Visual – Useful in displaying overall numbers
-
MultiCard
12:35
Gauge Visual – Track how far are we from Targets
-
How far are we from Targets
28:54
A surprise Test conducted- check your score
-
Another Test solved
49:16
MATRIX Visual – Its awesome – Everything you need to know
-
Matrix visual begins
26:00 -
Next level and expand buttons
10:22 -
Drill On
13:42 -
subtotals
13:31
How to use Drill on feature in Matrix – game changing
Map Visual
-
map visual begins
17:26 -
map more knowledge
22:59 -
Map continues
07:56 -
Map – Deep knowledge
12:41 -
Map ends
13:18
Decomposition Visual
-
Intro
38:53 -
part2
08:47 -
Part3
11:16
How to use Drill on feature – Deep dive
-
Drill on
15:00
CrossFiltering feature – A unique way of doing the automations
-
cross filter
09:30
Filter pane in BI
-
Filter pane
14:21
Shapes in BI
-
Shapes
17:24
Buttons in BI
-
Buttons Role
41:25
Let us create a Dashboard – Begin the story
-
Dashboard starts
23:03
Dashboards Continues
-
Dashboard continues
29:31
Final touch to your Dashboard – Great success
-
Dashboard Finished
36:49
Scattered Visualization – How one parameter affect second
-
Scattered – Relationship between two fields
33:30
Funnel Visual
-
Nice way to see top contributions
09:07
Import Data from Google Sheet and how to change it – Challenge solved
-
GoogleSheet in BI issue
11:55
Data Modelling – Relationships
-
Part1
40:23 -
Part2
27:27 -
Part3
35:21
BI Service – Sharing of Reports
-
BI Service introduction
26:13 -
How to Publish BI Reports
16:25 -
BI Service features – know your new Tool
08:01 -
How to share WorkSpaces
33:15 -
Sharing BI Reports
17:09 -
Admin and Viewer Roles
30:03 -
Exploring Other Sharing options – With specific people
24:23
DAX Tutorials Starts now
-
DAX Introduction – Calculated Column and Measures
31:47 -
BASICS DAX now
23:35 -
COUNT Family DAX – ALL in One
15:50 -
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:05 -
What is DISTINCTCOUNT and DISTINCT DAX – Very Useful and Interesting.
27:58 -
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:00 -
Use SWITCH Dax – Great way to put logics together in a faster way
25:00 -
IN use in CALCULATE and NOT
07:19 -
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:48 -
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:55 -
Time Intelligence Begins – Create CALENDERs
16:47 -
Time Intelligence – Get Cumulative totals using YTD MTD QTD
26:34 -
Exercise
20:28 -
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:27 -
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:04 -
How to Compare two categories but in one Visual
15:24