Kat Norton – Power BI with Miss Excel

Description

Power BI with Miss Excel is designed to take you from the basics to building stunning, interactive dashboards in Power BI. You’ll learn how to:

• Clean & Transform Data with Power Query for accurate, reliable insights.

• Build Strong Data Models to connect and manage complex datasets.

• Design Professional Reports & Dashboards that communicate data clearly and beautifully.

• Leverage Power BI Service to publish, share, and collaborate on reports across your organization.

By the end of the course, you’ll have the skills to confidently turn raw data into powerful visual stories that drive smarter decisions.

Power BI with Miss Excel with Kat Norton

90+
Training Videos

Step by Step Interactive Training from Power BI Basics to Advanced Tools

Practice Files & Guides

Collection of Practice Files & PDF Guides

Course Curriculum

92 VIDEO LESSONS

1. Module 1: Welcome to Power BI with Miss Excel!

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*)

2. Module 2: Meet Power BI

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 ✔️

3. Module 3: Basics of Connecting & Organizing Data

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 🧰

4. Module 4: Transforming Data in Power Query

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 📇

5. Module 5: Transforming Data in Power Query (Intermediate)

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💥

6. Module 6: Building Relationships

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 🆘

7. Module 7: Intro to DAX

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* 🔔

8. Module 8: Designing Data Visualizations

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 🛣️

9. Module 9: Building Power BI Reports

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 👷‍♂️

10. Module 10: Report Final Touches

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 📰

11. Module 11: Analyzing Reports in Power BI Service

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 🔖

12. Module 12: Al in Power BI & M365 App Integrations

1200: AI in Power BI 🤖

1201: AI Tools in Power BI 🔨

1202: Integrations with Microsoft 365 Apps

1203: CONGRATS!!! 🥳

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Power BI with Miss Excel with Kat Norton do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank You For Choosing Us! We appreciate it.