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

A Complete guide on BI Visuals,Features,Dashboards, Data Modelling,DAX,Sharing reports on cloud. Everything is covered.

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