Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
PowerBI & DAX-A Complete Course (Basic to Advance- 29 Hours)
Rating: 4.5 out of 5(27 ratings)
321 students

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.
Created byajay parmar
Last updated 7/2025
English
English [Auto],

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.

Course content

9 sections • 52 lectures • 29h 28m total length

  • About me and this Course - What are we covering?5:51

    Explore Power BI with DAX from basics to advanced, covering Power Query for data cleaning, visuals, DAX measures and calculated columns, data modeling, dashboards, sharing reports, and bookmarks.

  • Basics of PowerBI & Import Excel data.48:30

    Explore Power BI desktop basics, import Excel data, and create dashboards. Learn data modeling, relationships, and Power Query for ETL and data cleansing to drive visuals.

  • How BI behaves if source data changes with Clustered Column Visual.1:06:30

    Learn how Power BI handles source data changes during refresh, focusing on header stability, case sensitivity in Power Query, and data integrity with the clustered column visual.

  • Legends and Small Multiples.21:15

    Explore how legends unlock category-level insights and how small multiples show the same chart across categories and dates, with tips on color, borders, and date hierarchies.

  • Add same field for more calculations and a Tooltip feature12:20

    Explore how to reuse a single field for total, average, max, and min calculations in a clustered column visual in Power BI, and enhance insights with tooltips and date hierarchy.

  • Stacked Column Visuals in detail16:49

    Explore stacked column visuals in Power BI, compare stacked and clustered column charts, use the ribbon option to reveal year-by-year contributions, and optimize readability with legends, colors, and layout.

  • Slicers - Game changer30:21

    Master slicers in Power BI to compare time ranges, enable cross filtering across visuals, and customize interactions with multiple slicers for dynamic year-level dashboards.

  • How to change source path, if need be17:46

    Learn to change a Power BI data source path via Power Query and data source settings, preserving headers, and refreshing visuals with bar, column, and 100% stacking visuals.

  • Drill On feature - Fantastic9:40

    Explore drill down and drill up to navigate country, age group, and item hierarchies, using expand all down one level and cross filtering to analyze dashboards and visuals.

  • Import files from a folder & PQ Basic important features35:34

    Learn how to import and combine multiple Excel files from a folder using Power Query in Power BI, transforming data, cleaning headers, and loading a unified dataset for dashboards.

  • Cards Visual for Process performance18:29

    Design and format card visuals in Power BI to display a single metric per card, such as cost or sales, copy and customize them while keeping numbers stable against slicers.

  • Table Visual41:17

    Explore the table visual in PowerBI, including table and matrix views, formatting options, conditional formatting, data bars, icons, borders, alignment, and spark line to convey numeric data clearly.

  • How to Sort Months in X axis18:27

    Learn how to sort the x-axis months in power BI by creating a numeric index and sorting by that index, addressing text-month sorting issues and axis sort options.

  • More Sorting techniques27:59

    Master advanced sorting in power bi by creating a custom sort order for months and categories with power query, using index or conditional columns to ensure correct axis order.

  • Matrix - Our pivot37:42

    Explore the matrix visual in Power BI to create pivot-like summaries with multi-level rows and columns, drill down and up, expand all, and customize totals, layout, and conditional formatting.

  • Pie | Doughnut | Funnel Visuals20:12

    Learn to create pie and donut visuals showing weightage and country contributions, and build funnel visuals with sorting, slicers, and DAX-based insights for sales analysis.

  • Weblinks & Decompostion & Gauge Visuals39:16

    Explore web URL links and a decomposition tree to analyze sales by country and category; use gauge visuals with dynamic targets and learn about sharing and locking reports.

  • Multi Card and New Cards visuals25:49

    Discover how to use Power BI's multi card and new card visuals to display multiple metrics in one card, with rich formatting, layouts, and reference-level tooltips.

  • KPI Visual & Shapes with Navigation Bars34:17

    Explore KPI visuals in Power BI to display latest year trends, target, color, and icons for performance. Build navigation bars with buttons, page navigation, bookmarks, and slicers to create dashboards.

  • Drill Through in BI25:51

    Explore drill through in Power BI, linking visuals with drill through fields and build tool buttons. Learn to manage states and hide drill through sheets for secure navigation.

  • Customize Themes and Analytical Pane11:01

    Learn to customize themes and use the analytical pane in Power BI, adjusting colors, fonts, borders, and backgrounds across visuals with light or dark themes and the default mode.

  • Line and Area Visuals5:46

    Explore line and area visuals in Power BI to analyze trends with line charts, focusing on year-on-year and month-on-month patterns, and understand area charts for volume and stacking options.

  • Filter Pane in BI for visuals8:44

    Learn to use the Power BI filter pane to apply basic and advanced filters, top and bottom rules, and numeric comparisons, and control filters on visuals, pages, or all pages.

  • PowerQuery to connect with SQL Server13:46

    Explore importing data from SQL Server with Power Query, connecting to Adventure Works 2019, writing and editing SQL queries, and filtering by zone in Excel or Power BI.

  • Test your knowlege- Visuals and features

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 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

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

Report abuse