Basic to Advance Microsoft Power BI with DAX

• 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

Who this course is for:

• Students who want to make a career in Analytics.
• Students who are keen to make powerful and impactful visualizations in a few minutes and with very very little effort.
• Professionals who have been working on Excel a lot like MIS Analysts, Business Analysts, or someone who wants to produce data reports in an exclusive manner.