Power BI Desktop & Service with DAX- English
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
Basics of Power BI Layout and Design
-
New PowerBI Course- Basics of PowerBI -Layouts | Chapter1 | Part1
40:52
PQ and BI behaviour when Data changes
Legends and Small Multiples
ToolTip and Calcualtions with same field
Column Visuals
SLICERS
How to change paths and Bar Visuals
Drill On Feature and more features you should know
Import files from a folder & PowerQuery features
CARDS
Table Visual
Sorting issues in Months
Customize Sorting of axis labels
Matrix
Pie & Doughnut & Funnel Visuals
Weblink | Decompostion | Gauge |
MultiCards and New Cards
KPI | Navigation bar | Shapes on Action |
Drill Through feature
Customize Themes | Analytical Pane |
Line Visual
Filters
DAX Begins
CALCULATE DAX
Filter and ALL Family DAX Functions
Summarize dax
TOPN
RANKX SUMX and other iterators with TOPN Challenge
IF Dax
SELECTED VALUE
DAX – How to write in multiple Steps
DAX TEST for you
Import Data from Google Sheet and how to change it – Challenge solved
Data Modelling – Relationships
BI Sales Dashboard
BI Service – Sharing
Bookmarks
Power BI Desktop & Service with DAX- English
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
Basics of Power BI Layout and Design
-
New PowerBI Course- Basics of PowerBI -Layouts | Chapter1 | Part1
40:52