Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI - Building Interactive Dashboards
Rating: 4.5 out of 5(15 ratings)
64 students

Power BI - Building Interactive Dashboards

A combination of Power Query, Power Pivot, Power View, and Power Map!
Created byLenny Wu, MBA, CPA, CGA
Last updated 1/2021
English
English [Auto],

What you'll learn

  • This course will help you
  • to have awareness of the fastest growing BI program, bar none
  • to refresh on data transformation concepts in Power Query and data analysis skills in Power Pivot
  • to learn how to build from scratch a stunning Power BI dashboard
  • to learn about the best practices in Power BI modeling
  • to incorporate the Artificial Intelligence function into your dashboard
  • to be well positioned for building the shareable “on-demand” Power BI dashboards

Course content

5 sections • 24 lectures • 1h 3m total length

  • Introduction0:42

    Explore how Power BI enables building interactive dashboards from data transformation with Power Query and pivot techniques, delivering actionable business insights.

  • Why Power BI: compared with Excel1:04

    Discover how Power BI compares to Excel, highlighting more visuals and charts, natural language questions with instant answers, and slicers that turn charts into interactive filters.

  • Why Power BI: compared with other BI tools1:12

    Power BI leads Gartner’s magic quadrant in completeness of vision and ability to execute, with Tableau second and Qlik third, and it connects to 130+ data sources with monthly updates.

  • Author1:29

    Meet Lenny Wu, a Power BI educator and expert in Power Query, Power Pivot, BI, and self-service reporting, with MBA finance and CPA Canada backgrounds.

  • How this course is compared with “other similar courses”?1:36

    This course is NOT an academic course like others that:

    - teaches ALL skills from A to Z, whether they are useful or obsolete, such as CONCATNATE() in Excel

    - does not tell you which formulas/skills are mostly used at work!


    This course is a practical course where it

    - capitalizes on my 20+ years’ professional experiences in financial reporting and modeling

    - builds upon my 22+ years’ Excel and 5+ years Power BI experiences

    - has the top crucial skills hand-picked by me so that you can “get your foot in the door” and survive in the “office” environment

    - focuses on business uses rather than academic uses, e.g. how to calculate YTD sales using a DAX formula?

    - opens doors to more opportunities and promotions at office!


    In summary:

    - I am NOT teaching you skills for the sake of teaching skills

    - I am teaching you only the relevant skills that will automate your workload and get yourself EXCEL at work!

  • Why this course?0:49

    Explore why this course helps you master the fastest growing BI program, refresh data transformation concepts, and boost query, data analysis, and AI-enabled Power BI dashboards.

  • What you will get from this course?0:55

    Build a Power BI dashboard after data transformation in Power Query and data analysis, create seven top visuals, deploy automated commentary, and use AI natural language queries for self-service reporting.

Requirements

  • Some background using Power Query and/or Power Pivot in Excel is preferred.
  • Example: be able to connect to external files and load to Power Query and/or Power Pivot.

Description

In the 2010s, we used to have the Excel Add-ins to perform simple data transformation (Power Query), data modeling and analysis (Power Pivot), and data visualizations (Power View, and Power Map). I called them the “Power Suite”.

Then a bottleneck was reached, as the largest rows of data allowed in Excel is 1 million rows, and you would be out of luck if you extract tens of, or hundreds of millions of rows of data you want to analyze.

Now in July 2015, a completely new but powerful platform was born that incorporated all the tools in the “Power Suite” as I called. It exists independent of Microsoft Excel and yet allows for hundreds of millions or even more data rows to process in a shorter period of time. This means that people do not have to own Excel in order to use Power BI.

And the biggest win is that it is FREE! Seriously, it is free! Microsoft only charges nominal monthly fees for sharing dashboards online.

So what are you waiting for?! Let’s see what Power BI, equipped with all of the 4 components of the “Power Suite”, can do for us!

Did I mention that Power BI is the first dashboard software to incorporate Artificial Intelligence to create visuals or charts for you when all you need is to type English words telling it what to chart??!!


Who this course is for:

  • Students (Secondary or post secondary), Office workers, Professionals, and Managers

Report abuse