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

Free Download PowerBI & DAX-A Complete Course (Basic to Advance-25 Hours)
Published 11/2024
Created by ajay parmar
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 43 Lectures ( 25h 34m ) | Size: 15 GB

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
Who this course is for
Data Analysts, MIS Executives, Sales people, HR, Finance persons.
Whoever want to create reports and on a big level- They can join this program
Homepage

https://www.udemy.com/course/powerbi-dax-a-complete-course-basic-to-advance-25-hours/