In this course you will learn how to build beautiful data visualizations from scratch with Power BI Desktop, including cleaning and transforming data in Power Query, leveraging powerful Data Modeling techniques and designing Reports & Dashboards. We also dive into Power BI Service and learn how to publish, share and edit our reports from there too!
Power BI
with Miss Excel
![Power BI with Miss Excel](https://import.cdn.thinkific.com/405436%2Fcustom_site_themes%2Fid%2F9ZBDuD62RN26TXdCOzJo_Course%20Covers%20%2814%29.png)
![Power BI with Miss Excel](https://import.cdn.thinkific.com/405436%2Fcustom_site_themes%2Fid%2F9ZBDuD62RN26TXdCOzJo_Course%20Covers%20%2814%29.png)
Do you ever feel like...
-
You would be more marketable for a job or promotion if you were more efficient in Power BI?
-
There must be a way to automate tasks and stop doing so many things manually?
-
You hear so much about Data Modeling and Dashboards, but don't know how to use them to make your life easier?
Can You Imagine...
-
Quickly mastering Power BI to grow your career
-
Impressing your boss with your Data Modeling skills
-
Saving hours with work by streamlining analysis with Power BI
If any of this resonated with you, my course package has exactly what you need!
-
90+
Training VideosStep by Step Interactive Training from Power BI Basics to Advanced Tools
-
Practice Files & Guides
Collection of Practice Files & PDF Guides
-
Access to Kat in our Excelerator Lounge
Private Facebook group where I will be answering your questions and providing my top tips
Course Curriculum
100: How to Use This Course 💻
101: Meet & Download the Course Data 🧁
102: Join the Excelerator Lounge 👯
103: How to Access Our Support Team 💁♀️
104: How to Access Power BI 💻
105: Power BI Settings for This Course ⚙️(*IMPORTANT*)
200: Meet Power BI 👋
201: What is Power BI? 🤖
202: Comparing Power BI to Excel 📊
203: How Power BI Works 🚗
204: Power BI Terms Recap ✔️
300: Organizing & Connecting Data 🛠️
301: Types of Connections 🫶
302: Map of Power Query Editor 🗺️
303: Changing Names & Data Types 🔁
304: Managing Columns & Rows 📈
305: Quality Control Tools 🧰
400: Transforming Data 🖥️
401: Formatting Data 🎨
402: Replacing Values 🔢
403: Splitting Columns 🪓
404: Merging Columns 🤝
405: Transforming Dates 🗓️
406: Rounding Data ⭕
407: Managing Different Locales 🌍
408: Index Columns 📇
500: Data Transformation (Intermediate) 🪜
501: Conditional Columns 🤔
502: Creating Custom Columns 🧑🎨
503: Grouping Data 🤗
504: Customized Refresh 🔃
505: Fill Down & Fill Up 🍶
506: Merging & Appending Queries 🙏
507: Close & Apply💥
600: Building Relationships 😻
601: Meet Data Modeling 🙋♀️
602: Table Types 📅
603: Key Types 🗝️
604: Creating & Editing Relationships 💔
605: Star & Snowflake Schemas ⭐❄️
606: Data Categories & Field Categories 🌐
607: Hierarchies 🖇️
608: Filter Flow 🌪️
609: Hiding Fields 🫥
610: Layout Hacks 🧚♀️
611: Troubleshooting Data Sources 🆘
700: Meet DAX 🥼
701: What is DAX? 🔬
702: DAX Calculated Columns 101 👨🔬
703: DAX Measures 101 📏
704: Function Categories 📔
705: DAX Calculated Columns for this Course *IMPORTANT* 🔔
706: DAX Measures for this Course *Important* 🔔
800: Miss Excel's Power BI Design Lab 👩🎨
801: Choosing Which Metrics to Visualize 🎭
802: Pro-Tips for Report Design Aesthetics 🖼️
803: Designing Your Dashboard Roadmap 🛣️
900: Power BI Reports
901: Outlining with Shapes ⏹️
902: Logos & Titles 🧁
903: Card Visuals🃏
904: Line Charts 📈
905: Format Painter 🖌️
906: Bar Charts 📊
907: Pie & Donut Charts 🍩
908: Tables & Matrixes 📅
909: Conditional Formatting Visuals 🎨
910: Maps 🗺️
911: Slicers ✂️
912: Pro Tip - Building Reports off a Duplicate 👷♂️
1000: Final Touches 🖌️
1001: Editing Interactions 🚫
1002: Creating Buttons 🔳
1003: Creating Custom Tool Tips with Charts 📊
1004: Advanced Chart Formatting 🎨
1005: Mobile Layouts 📱
1006: Optimization Tools 📈
1007: Managing Roles 🛂
1008: Publishing Reports 📰
1100: Power BI Report Analysis 🙋♂️
1101: Walkthrough of Power BI Service Workspaces 🚶
1102: Overview of Power BI Service 🤩
1103: Editing the Data Model in Power BI Service 📅
1104: Using Reports to Answer Strategic Questions 🤯
1105: Editing Existing Reports in Power BI Service 🫡
1106: Leveraging Views & Filters 🪟
1107: Creating Dashboards ⚡
1108: Saving Bookmarks 🔖
1200: AI in Power BI 🤖
1201: AI Tools in Power BI 🔨
1202: Integrations with Microsoft 365 Apps
1203: CONGRATS!!! 🥳
![kat norton](https://import.cdn.thinkific.com/405436%2Fcustom_site_themes%2Fid%2FTnakoX3RTemLP9kmsxCY_kat_scribble.png)
Kat Norton
Miss Excel And Instructor
Kat Norton energetically teaches Microsoft Excel to individuals, businesses and educational institutions.
Since launching Miss Excel in June 2020, she has grown a community of over 1,000,000 people on TikTok & Instagram (@miss.excel) through viral Excel trick videos infused with creativity, music and dance.
Kat was recently awarded the Microsoft MVP Award and has been featured in Business Insider, CNBC, and Entrepreneur Magazine as a pioneer in the "Excel Influencer" space. Kat was also named one of the Top Influencers of 2021 by Forbes.
AS SEEN IN
Frequently Asked Questions
Each course is designed to be one module per week over 12 weeks. However, if you are the “Netflix binge-watching” type (like myself) — feel free to go forth and conquer! The courses have approximately 12 hours of content in each and the Mini Courses are about 3 hours each.
No! You can start the courses whenever you’d like!
Yes! Each course comes with lifetime access to all course materials.
Please email Kat directly at [email protected] to learn more about bulk discounts.
Yes! You will receive a Completion Certificate at the end of each course.
![](https://import.cdn.thinkific.com/405436%2Fcustom_site_themes%2Fid%2Fc9c0HUY1T3WgPRCI3qiB_Group%202180.png)
The Miss Excel Guarantee
If in the first 14 days of your purchase your course doesn't address your learning and growth needs, we'll refund you in full!
Ready to
excelerate
your skills?
![](https://import.cdn.thinkific.com/405436%2Fcustom_site_themes%2Fid%2FCiZQ603TgGZQmUDw8zAq_kat_brown_jacket.png)