Power BI
Join 30,000+ students mastering work productivity
$397
$899
Join 30,000+ students
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!
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?
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
90+
Training Videos
Step 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
Proficiency Quiz: START HERE
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
FINAL QUIZ π
1203: CONGRATS!!! π₯³
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 2,000,000 people on TikTok & Instagram (@miss.excel) through viral Excel trick videos infused with creativity, music and dance.
Kat was awarded the Microsoft MVP Award 5x 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
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.
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!
excelerate