Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
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)
63 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

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
  • Why Power BI: compared with Excel1:04
  • Why Power BI: compared with other BI tools1:12
  • Author1:29
  • 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
  • What you will get from this course?0:55

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