[2024] Power BI Basic Course for Tired Excel Users (Beginner to Intermediate)

Class Summary

👉 In this class, you will learn the following! (Total 10 hours of course / 49 lectures, 2024 version)
✅ How to visualize data and create a report (dashboard) using Power BI Desktop
✅ How to easily edit/preprocess data using the Power Query Editor built into Power BI Desktop
✅ How to effectively share my reports with colleagues and keep them fresh/managed using the Power BI service
✅ How to write simple calculations using basic essential functions
✅ How to refresh this entire process with one button

👉 You won't learn this kind of stuff!
❌ Data Modeling
❌ Composing complex DAX function formulas

For those of you who are just starting out with Power BI or have only recently started using it,
Rather than going into in-depth and difficult content, it is structured so that you can systematically build a foundation for Power BI while also understanding the overall functions and workflow. 🤗

It will be a great stepping stone to moving on to intermediate/advanced levels!

People like this will like to hear it.

👉 This basic course was created for these people!
✅ For Power BI beginners or absolute beginners.
✅ People who learned mostly on their own through free courses, etc., but eventually felt the need to learn systematically again.
✅ People who have taken other Power BI online courses a long time ago but still feel unconfident.
✅ For those looking for a solution for simple data visualization and automated dashboards rather than calculations using complex functions.
✅ People who feel frustrated with processing large amounts of data in Excel.
✅ Excel users who are disappointed with the data visualization function.
✅ People who are struggling to create and manage dashboards using Excel.
✅ Those who are looking for an alternative to automation using Excel VBA/Macros.
✅ Those who want to understand the basic concepts and principles of DAX functions and measures/new columns and write formulas.
✅ Those who want to fully utilize the features of Power BI.

👉 People like this, please wait for the advanced course!
❌ Anyone who wants to derive complex measurement calculations through a combination of various DAX functions.
❌ Anyone who wants to perform three-dimensional data analysis by connecting multiple tables from various angles through modeling.
❌ Those who are looking to automate somewhat complex editing tasks using the M language.

The class proceeds like this.

👉 This class is more focused on practical training, as if it were an on-site lecture, rather than theory!
So, we made it at a speed that you can practice at together.
I highly recommend that students download the practice example files in advance and practice editing and visualizing data, implementing dashboards, etc. with me!

Class Notes

📌 A must-read for Mac users!
Power BI Desktop doesn't work on iOS yet!
Therefore, if you are taking the course on a Mac-based PC rather than a Windows-based PC, you must install Windows before taking the course or prepare a Windows-based PC. Even if Windows is installed, please note that additional explanations regarding the keyboard for Mac users will not be provided separately in the course!