Powerbi & Dax-A Complete Course (Basic To Advance-25 Hours)

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

What you'll learn

You will learn PowerBI from basic to advance including all new features.

How to create visuals, which one should you choose when alongwith the BI Features

You will learn the data modelling and we are covering all types of cardinality here with great examples

DAX in detail. Yes, we are learning the dax in phenomenol style. These are live lectures of my latest class in High definition quality

You will learn how to create stunning dashboards using dax ,visuals and all features discussed in the course which included data modelling concepts

Sharing the dashboards on Cloud, - BI Service

You wil learn everything in this course about Powerbi and nothing is left, After finishing the course you will be a PRO .

Supporting files are there for you to download under each lecture.

Requirements

Just a Free BI Desktop - you need to download

No programming experience is needed

Basics of Excel will be an added advantage

Description

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 familyHow 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 themArea 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 ServiceHow 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 DashboardTypes of relationships - Data Modelling - One to One , One to Many, Many to ManyTypes of Cardinality. - Single direction and both directionsWhat 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 advanceUtmost important DAX like - ALL , ALL SELECTED, ALL EXCEPTMixing of ALL with CALCUALTE to yield powerful resultsHow to write IF dax as a calculated columnHow 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 scenariosHASONEVALUE Get ready for a DAX Surprise Test.Related DAX - Vlookup wayTime Intelligence DAX functions Cumulative SUMs - yearly, monthy , dailyWhy we should know SUMMARIZE DaxCALCULATETABLE Dax and its use with Summarize daxSelectedValue and VALUES, ConctenateXUserRelationship DAXBI 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

Overview

Section 1: PowerBI Desktop Visual and Features

Lecture 1 About me and this Course - What are we covering?

Lecture 2 Basics of PowerBI & Import Excel data

Lecture 3 How BI behaves if source data changes with Clustered Column Visual

Lecture 4 Legends & Small Multiples

Lecture 5 Add same field for more calculations and a Tooltip feature

Lecture 6 Stacked Column Visuals in detail

Lecture 7 Slicers - Game changer

Lecture 8 How to change source path, if need be

Lecture 9 Drill On feature - Fantastic

Lecture 10 Import files from a folder & PQ Basic important features

Lecture 11 Cards Visual for Process performance

Lecture 12 Table Visual

Lecture 13 How to Sort Months in X axis

Lecture 14 More Sorting techniques

Lecture 15 Matrix - Our pivot

Lecture 16 Pie | Doughnut | Funnel Visuals

Lecture 17 Weblinks & Decompostion & Gauge Visuals

Lecture 18 Multi Card and New Cards visuals

Lecture 19 KPI Visual & Shapes with Navigation Bars

Lecture 20 Drill Through in BI

Lecture 21 Customize Themes and Analytical Pane

Lecture 22 Line and Area Visuals

Lecture 23 Filter Pane in BI for visuals

Section 2: DAX begins

Lecture 24 Basic DAX - SUM, COUNT, COUNTROWS, DISTINCT COUNT,AVG - How to write Dax

Lecture 25 CALCULATE DAX -In ful detail

Lecture 26 FILTER and ALL/ALLSELECTED/ALLEXCEPT

Lecture 27 SUMMARIZE Dax

Lecture 28 TOPN - real practical knowledge

Lecture 29 SUMX COUNTX AVERAGEX - ITERATORS

Lecture 30 Challenge Solved - TOPN with SUMX - Amazing knowlege

Lecture 31 Questions by Students

Lecture 32 Selected Value

Lecture 33 Write DAX in steps - Amazing way

Section 3: DAX Test for you

Lecture 34 Solve these DAX Questions

Section 4: Data Modelling - Relationships in PowerBI

Lecture 35 One to One

Lecture 36 One to Many

Lecture 37 Many to Many

Lecture 38 Many to Many - One more example

Lecture 39 Attrition report on RELATIONSHIPS

Section 5: Dashboards

Lecture 40 Executive Performance Dashboard - Part1

Lecture 41 Creating Top and Bottom performances in 2nd page -Part2

Section 6: BI Service - Sharing your Dashboards

Lecture 42 Sharing the reports using BI License version - Cloud

Section 7: BookMarks with Selections

Lecture 43 Everthing about BookMarks and Selections

Data Analysts, MIS Executives, Sales people, HR, Finance persons.,Whoever want to create reports and on a big level- They can join this program