Kat Norton – Power BI with Miss Excel

*** Proof of Product ***

Exploring the Essential Features of “Kat Norton – Power BI with Miss Excel”

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!

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 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!!! 🥳

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 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.

Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/