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
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
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
Introduction to PowerBI – Understand in-depth its Components
-
Introduction to basic and important concepts
52:11