PowerBI & DAX-A Complete Course (Basic to Advance- 29 Hours) | Udemy

This BI course is divided into various sections starting from BI Visuals, DAX, Data Modelling, Dashboards and sharing of the the reports on Cloud. I have covered everything in this Course for you. You will be a FULLY PRO after finishing it.

• We have covered BI Desktop, DAX ,Data modelling, Dashboards and BI service in this big course for you.
• Also, Covered basic level information on PowerQuery for your better grip on fundamental.
• Relationship between Powerquery and PowerBI – Why it is important to understand.
• Clustered Column , Stacked Column Chart , Bar charts family
• How to import data and things to be taken care of from different sources like a folder.
• Drill down – off and on .
• 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.
• Slicers (Old and latest)
• 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, Drill Through, Soriting axis labels and customizing them
• Area Chart Visualization ,Line and Column visualization – including stacked.
• Complete discussion on KPI , Tree Map , 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 a BI Service and what is the relationship between Desktop and Service when it comes to dashboards.
• Create Workspaces, Reports in power BI Service
• How to provide Admin or Viewer rights to team members who can read or edit the reports and you don’t have to email.
• How to link Local excel files or files shared on server with BI service.
• How to prevent or put data restrictions on users so they can not see other reports.
• What is a difference between datasets, dashboards, Reports in BI service.
• Learn how we have made a incredible dashboard – Sales Dashboard
• Types of relationships – Data Modelling – One to One , One to Many, Many to Many
• Types of Cardinality. – Single direction and both directions
• What is a Dax and its role in PowerBI.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
• How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE . Its different from excel in terms of fundamental.
• Learn amazing DAX functions like SUMX, COUNTX,FILTERHow to use One DAX into another DAX ,If situation demands.
• 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.
• Discussing Basic DAX like SUM, COUNT, COUNTBLANK, DISTINCT COUNT .
• How to use Calculated field and what are measures.
• Which one better – Calculated column DAX or Measure DAX – with scenarios
• HASONEVALUE
• Get ready for a DAX Surprise Test.
• Related DAX – Vlookup way
• Time Intelligence DAX functions
• Cumulative SUMs – yearly, monthy , daily
• Why we should know SUMMARIZE Dax
• CALCULATETABLE Dax and its use with Summarize dax
• SelectedValue and VALUES, ConctenateX
• UserRelationship DAX
• BI Mobile apps – how to see reports via mobile – android phones and why it is called next level in bi.
• Major differences between BI Service and BI Desktop