Learn the basics of Power BI, all the important tools and when and how to use them properly, and how to visualize your data effectively.
Read more.Course Skill Level
Beginner
Time Estimate
14h 15m
Instructor
Hi! My name is Nikolai Schuler and I am super excited about equipping you with the skillset to master Data Science and Data Analytics! In my work as a data scientist and BI consultant I see that there a lot of new tools that bring a lot of benefits. Yet I also see that it is not always easy to learn working with these tool beside the daily other tasks we have to do. Also I found it hard to find courses that are high quality as well as easy to understand and well structured. For that rea
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Anyone who is looking for a complete and comprehensive intro to Power BI
- Everyone who wants to also learn more advanced Power BI skills such as DAX for calculated columns and measures
- Anyone who wants to pursue a career as a data analyst, data scientist or BI consultant
- Anyone who has never used Power BI before and is looking for a hands-on approach to learn it
What you’ll learn:
- Learn the complete workflow in Power BI from A to Z
- Advanced analytics with DAX – calculated columns and measures
- All-in-One: Power BI Desktop, Power BI Cloud and Power BI Mobile!
- Learn how to design and implement professional reports
- Learn storytelling with data to visualize your data effectively
- Advanced features such as working with parameters, using R scripts, optimizing performance and
- Row-Level Security
- Performance optimizing
- Storytelling with data
- Python and R in Power BI
- Forecasting and advanced analytics
- Time intelligence
Requirements:
- A computer with Windows operating system
- Power BI Desktop (free download)
- For some modules with Power BI Service (Cloud) account, a school or work email address is required to sign up (free 60 day trial)
Do you want to learn the skills to professionally analyze data?
Do you want to learn all the steps to create impressive reports?
Then Microsoft Power BI is the right tool for you!
In this course you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator.
Understand everything from scratch – step by step, very structured and practice-oriented
- Learn all the important tools – know when and how to use them properly
- Connect different data sources – from basics to advanced
- Create your data model – and understand it
- Master DAX – to do more advanced analysis on your data
- Get to know all the different visualizations – and how to use them
- Storytelling with data – learn how to visualize your data effectively
- Create interactive visualizations – with drill throughs and drill downs
- Advanced analysis – learn how to use R Script in Power BI (Data Science)
- Forecasting – Advanced analytics which can be helpful in Data Science
- Row-Level Security – Implement the security concept to control access to the data
This course is right for you if you have never worked with Power BI and want to learn everything hands-on in one course. OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.
This is the course that covers everything in Power BI to become an advanced report developer!
Enroll now to get life long access!
Our Promise to You
By the end of this course, you will have learned storytelling with data to visualize your data effectively.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Power BI.
Course Curriculum
| Section 1 - Introduction | |||
| Downloadable Resources – All Source Files | 00:00:00 | ||
| Welcome! | 00:00:00 | ||
| What Is Power BI? | 00:00:00 | ||
| Download And Installing Power BI Desktop | 00:00:00 | ||
| Getting To Know The Interface | 00:00:00 | ||
| Mini Project: Transform Data | 00:00:00 | ||
| Mini Project: Visualize Data | 00:00:00 | ||
| Mini Project: Creating A Data Model | 00:00:00 | ||
| Course Outline: What Will You Learn In This Course? | 00:00:00 | ||
| Section 2 - Preparing Our Project | |||
| Creating Our Initial Project File | 00:00:00 | ||
| Working With The Attached Project Files | 00:00:00 | ||
| Section 3 - Data Transformation - The Query Editor | |||
| Exploring The Query Editor | 00:00:00 | ||
| Connecting To Our Data Source | 00:00:00 | ||
| Editing Rows | 00:00:00 | ||
| Changing Data Types | 00:00:00 | ||
| Replacing Values | 00:00:00 | ||
| Close And Apply | 00:00:00 | ||
| Connecting To A CSV File | 00:00:00 | ||
| Connecting To A Web Page | 00:00:00 | ||
| Extracting Characters | 00:00:00 | ||
| Splitting And Merging Columns | 00:00:00 | ||
| Creating Conditional Columns | 00:00:00 | ||
| A Little Note Regarding The Next Lecture | 00:00:00 | ||
| Creating Columns From Examples | 00:00:00 | ||
| Merging Queries | 00:00:00 | ||
| Pivoting And Unpivoting | 00:00:00 | ||
| Appending Queries | 00:00:00 | ||
| Practice And Solution: Population Table | 00:00:00 | ||
| The Fact-Dimension-Model | 00:00:00 | ||
| Practice: Load The Dimension Table | 00:00:00 | ||
| Organizing Our Queries In Groups | 00:00:00 | ||
| Text To Be Used In The Next Lecture | 00:00:00 | ||
| Entering Data Manually | 00:00:00 | ||
| Creating An Index Column | 00:00:00 | ||
| Workflow And More Transformations | 00:00:00 | ||
| Module Summary | 00:00:00 | ||
| Exercise 1 | 00:00:00 | ||
| 1 Question | 00:00:00 | ||
| Section 4 - Data Transformation - Advanced | |||
| Advanced Editor – Best Practices | 00:00:00 | ||
| Performance: References Vs. Duplicating | 00:00:00 | ||
| Performance: Enable/Disable Load And Report Refresh | 00:00:00 | ||
| Group By | 00:00:00 | ||
| Mathematical Operations | 00:00:00 | ||
| Run R Script | 00:00:00 | ||
| Using Parameters To Dynamically Transform Data | 00:00:00 | ||
| M Formula Language: Basics | 00:00:00 | ||
| M Formula Language: Values, Lists And Tables | 00:00:00 | ||
| M Formula Language: Functions | 00:00:00 | ||
| M Formula Language: More Functions And Steps | 00:00:00 | ||
| Exercise 2 – Instructions | 00:00:00 | ||
| Exercise 2 – Solution | 00:00:00 | ||
| Section 5 - Creating A Data Model | |||
| Why A Data Model? | 00:00:00 | ||
| Create And Edit Relationships | 00:00:00 | ||
| One-To-Many And One-To-One Relationship | 00:00:00 | ||
| Many-To-Many (M:N) Relationship | 00:00:00 | ||
| Cross Filter Direction | 00:00:00 | ||
| Activate And Deactivate Relationships | 00:00:00 | ||
| Module Summary | 00:00:00 | ||
| Exercise 3 – Instructions | 00:00:00 | ||
| Exercise 3 – Solution | 00:00:00 | ||
| Section 6 - Data Visualization | |||
| Our First Visual | 00:00:00 | ||
| The Format Tab | 00:00:00 | ||
| Understanding Tables | 00:00:00 | ||
| Conditional Formatting | 00:00:00 | ||
| The Pie Chart | 00:00:00 | ||
| All About The Filter Visual | 00:00:00 | ||
| The Filter Pane For Developers | 00:00:00 | ||
| Cross Filtering And Edit Interactions | 00:00:00 | ||
| Exercise 4 – Instructions | 00:00:00 | ||
| Exercise 4 – Solution | 00:00:00 | ||
| Syncing Slicers Across Pages | 00:00:00 | ||
| Creating Drill Downs | 00:00:00 | ||
| Creating Drill Throughs | 00:00:00 | ||
| The Tree Map Visual | 00:00:00 | ||
| The Decomposition Tree | 00:00:00 | ||
| Understanding The Matrix Visual | 00:00:00 | ||
| Editing Pages | 00:00:00 | ||
| Buttons And Actions | 00:00:00 | ||
| Bookmarks To Customize Your Report | 00:00:00 | ||
| Analytics And Forecasts With Line Charts | 00:00:00 | ||
| Working With Custom Visuals | 00:00:00 | ||
| Get Data Using R Script And R Script Visual | 00:00:00 | ||
| R Script To Use | 00:00:00 | ||
| Asking Questions – Q&A Visual | 00:00:00 | ||
| Wrap Up – Data Visualization | 00:00:00 | ||
| Section 7 - Power BI And Python | |||
| Python In Power BI – Plan Of Attack | 00:00:00 | ||
| Setting Up Python For Power BI | 00:00:00 | ||
| Transforming Data Using Python | 00:00:00 | ||
| Python Script I Used In The Next Lecture | 00:00:00 | ||
| Creating Visualizations Using Python | 00:00:00 | ||
| Python Script II Used In The Next Lecture | 00:00:00 | ||
| Violin Plots, Pair Plots And Ridge Plots Using Python | 00:00:00 | ||
| Python Script III Used In The Next Lecture | 00:00:00 | ||
| Machine Learning (BayesTextAnalyzer) Using Python | 00:00:00 | ||
| Performance And Troubleshooting | 00:00:00 | ||
| Section 8 - DAX - The Essentials | |||
| Introduction | 00:00:00 | ||
| The Project Data | 00:00:00 | ||
| DAX Cheat Sheet | 00:00:00 | ||
| All Files For The DAX Part | 00:00:00 | ||
| Measures Vs. Calculated Columns | 00:00:00 | ||
| Automatically Creating A Date Table In DAX | 00:00:00 | ||
| CALENDAR | 00:00:00 | ||
| Creating A Complete Date Table With Features | 00:00:00 | ||
| Script To Be Used In Your Future Projects | 00:00:00 | ||
| Creating Key Measure Table | 00:00:00 | ||
| Aggregation Functions | 00:00:00 | ||
| The Different Versions Of Count | 00:00:00 | ||
| SUMX – Row Based Calculations | 00:00:00 | ||
| DAX Exercise 1 | 00:00:00 | ||
| DAX Solution 1 | 00:00:00 | ||
| Section 9 - DAX - The Calculate Function | |||
| CALCULATE – The Basics | 00:00:00 | ||
| Changing The Context With FILTER | 00:00:00 | ||
| ALL | 00:00:00 | ||
| ALLSELECTED | 00:00:00 | ||
| ALLEXCEPT | 00:00:00 | ||
| DAX Exercise 2 | 00:00:00 | ||
| DAX Solution 2 | 00:00:00 | ||
| Section 10 - Tell A Story With Your Data - Learn To Visualize Effectively | |||
| Intro – Best Practices | 00:00:00 | ||
| Show Empathy And Identify The Requirements | 00:00:00 | ||
| Find The Most Suitable KPIs | 00:00:00 | ||
| Choose An Effective Visual | 00:00:00 | ||
| Make Use Of Natural Reading Pattern | 00:00:00 | ||
| Tell A Story Using Visual Cues | 00:00:00 | ||
| Avoid Chaos And Group Information | 00:00:00 | ||
| Wrap Up – Storytelling With Data | 00:00:00 | ||
| Section 11 - Power BI Service - Power BI Cloud | |||
| How To Go On Now? | 00:00:00 | ||
| Power BI Pro Vs Premium And Signing Up | 00:00:00 | ||
| An Alternative If You Don’t Have A Business Email | 00:00:00 | ||
| Exploring The Interface | 00:00:00 | ||
| Discovering Your Workspace | 00:00:00 | ||
| Little Note On The Next Lecture – Uploading Your Report | 00:00:00 | ||
| Connecting Power BI Desktop And Cloud | 00:00:00 | ||
| Understanding Datasets And Reports | 00:00:00 | ||
| Working On Reports | 00:00:00 | ||
| Updating Reports From Power BI Desktop | 00:00:00 | ||
| Creating And Working With Workspaces | 00:00:00 | ||
| Installing And Using A Data Gateway | 00:00:00 | ||
| Get Quick Insights | 00:00:00 | ||
| Creating Dashboards | 00:00:00 | ||
| Sharing Our Results Through Apps | 00:00:00 | ||
| Power BI Mobile App | 00:00:00 | ||
| Creating The Layout For The Mobile App | 00:00:00 | ||
| Wrap Up – Power BI Cloud | 00:00:00 | ||
| Section 12 - Row-Level Security | |||
| Introduction | 00:00:00 | ||
| Creating A Row-Level Security | 00:00:00 | ||
| Row-Level Security In The Cloud | 00:00:00 | ||
| Row-Level Security And Data Model | 00:00:00 | ||
| Dynamic Row-Level Security | 00:00:00 | ||
| Dynamic Many-To-Many RLS | 00:00:00 | ||
| Hierarchical Row-Level Security | 00:00:00 | ||
| Section 13 - More Data Sources | |||
| JSON And REST API | 00:00:00 | ||
| Setting Up A Local MYSQL Database | 00:00:00 | ||
| Connecting To A MYSQL Database In Power Bi | 00:00:00 | ||
| Connecting To A SQL Database (PostgreSQL) | 00:00:00 | ||
| Section 14 - Next Steps To Improve And Stay Up To Date | |||
| Congratulations And Next Steps | 00:00:00 | ||
| The End | 00:00:00 | ||
| More Data To Practice | 00:00:00 | ||
Course Review
5.0
1 RatingsRelated Courses
Are you interested in higher education?
Awesome Masterclass!
Wow! That was a masterclass for a beginner like me. It was full of content, very well structured, and easy to follow, and work along by myself. I really enjoyed it and am very excited to take what I have learned into practice.
I feel like I have learned loads – much more than I bargained for – and I can’t wait to keep practicing and learning going forward.
Thank you so much Nikolai!