The Data Analysis with Excel + Power BI Bundle
What's Included
Up & Running with Power BI Desktop
- Experience level required: All levels
- Access 116 lectures & 10 hours of content 24/7
- Length of time users can access this course: Lifetime
Course Curriculum
116 Lessons (10h)
Your First Program
Getting Started
Course Structure & Outline1:43DOWNLOAD: Course ResourcesIntroducing the Adventure Works Project3:02Setting Expectations2:21Introducing Power BI Desktop
Introduction0:26Meet Power BI5:30Downloading Power BI & Adjusting Settings4:05IMPORTANT: Regional SettingsThe Power BI Interface & Workflow2:34Helpful Resources1:44UPDATE: New Power BI Ribbon (2020)7:15QUIZ: Introducing Power BI DesktopConnecting & Shaping Data
Introduction0:30Types of Data Connectors3:53The Query Editor4:28Basic Table Transformations10:03Text-Specific Tools14:54Number-Specific Tools8:37Date-Specific Tools8:53PRO TIP: Creating a Rolling Calendar7:08Index & Conditional Columns8:30Grouping & Aggregating Data7:33Pivoting & Unpivoting8:04Merging Queries6:41Appending Queries6:29PRO TIP: Appending Files from a Folder7:38Data Source Settings5:05Query Refresh Settings3:06Additional Data Types & Categories7:19Defining Hierarchies4:35PRO TIP: Importing Models from Excel5:40Data Connection Best Practices2:09QUIZ: Connecting & Shaping DataHOMEWORK: Connecting & Shaping DataHOMEWORK SOLUTION: Connecting & Shaping Data12:36Creating a Data Model
Introduction0:19What is a "Data Model"?5:17Database Normalization4:07Data Tables vs. Lookup Tables7:25Relationships vs. Merged Tables2:31Creating Table Relationships4:34"Snowflake" Schemas3:09Managing & Editing Relationships2:44Active vs. Inactive Relationships2:45Relationship Cardinality5:08Connecting Multiple Data Tables8:26Understanding Filter Flow6:33Two-Way Filters (Use with Caution!)13:16Hiding Fields from Report View4:15UPDATE: New Model View8:32Data Model Best Practices1:34QUIZ: Creating a Data ModelHOMEWORK: Creating a Data ModelHOMEWORK SOLUTION: Creating a Data Model14:09Adding Calculated Fields with DAX
Introduction0:32Meet DAX1:03Intro to Calculated Columns7:33Intro to Measures2:51RECAP: Calculated Columns vs. Measures1:34Adding Columns & Measures3:12Implicit vs. Explicit Measures6:27Filter Context Examples8:07Step-by-Step Measure Calculation2:39DAX Syntax & Operators3:49Common DAX Function Categories3:16Basic Date & Time Functions12:24Logical Functions10:06Text Functions9:24Joining Data with RELATED8:54Basic Math & Stats Functions14:01COUNT Functions7:46IMPORTANT: Order Line Items6:21The CALCULATE Function13:06CALCULATE & ALL9:25CALCULATE & FILTER9:37Iterator ("X") Functions12:27DAX Time Intelligence Formulas12:29DAX Best Practices2:57QUIZ: Adding Calculated FieldsHOMEWORK: Adding Calculated FieldsHOMEWORK SOLUTION: Adding Calculated Fields15:05Visualizing Data with Reports
Introduction0:29The "Report" View5:33Adding Simple Objects3:07Inserting Basic Charts & Visuals5:47UPDATE: Conditional Formatting2:58Formatting Options9:51Report Filtering Options11:09DEMO: Matrix Visuals6:38DEMO: Date Slicers7:14DEMO: Cards & KPIs9:24DEMO: Text Cards6:14DEMO: Map Visuals7:15DEMO: Treemaps3:21DEMO: Line & Area Charts6:23DEMO: Trend Lines & Forecasts5:36DEMO: Gauge Charts6:43Editing Report Interactions6:38Adding Drillthrough Filters5:08Adding Report Bookmarks5:49"What-If" Parameters11:47Managing & Viewing Roles5:27PREVIEW: Custom Visuals (Log-In Required)2:05PREVIEW: Designing for Phone vs. Desktop2:54PREVIEW: Publishing to Power BI Service2:27Data Visualization Best Practices1:35QUIZ: Visualizing Data with ReportsHOMEWORK: Visualizing Data with ReportsHOMEWORK SOLUTION: Visualizing Data with Reports7:22NEW: Artificial Intelligence (AI) Visuals
The Q&A Visual10:54The Key Influencers Visual (Part 1)12:34The Key Influencers Visual (Part 2)5:11IMPORTANT: Correlation vs. Causation4:24The Decomposition Tree Visual8:59Wrapping Up
More from Maven AnalyticsREFERENCE: Monthly Power BI Updates
Up & Running with Power BI Desktop
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton | Founder of Maven Analytics
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
Description
If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place. Power BI is quickly becoming the world's most powerful self-service business intelligence platform and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models, and design stunning, interactive dashboards from scratch.
18,197 positive ratings from 71,106 students enrolled
- Access 116 lectures & 10 hours of content 24/7
- Build professional-quality business intelligence reports from the ground up
- Understand the business intelligence workflow from end-to-end
- Blend and transform raw data into beautiful interactive dashboards
- Design and implement the same B.I. tools used by professional analysts & data scientists
Note: Software NOT included
Specs
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: all levels
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Data Analysis with Excel PivotTables
Intro to Power Query, Power Pivot & DAX
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Trey Russell
Great concise way to learn analysis and Power Bi. Cheap and it allows you to rerun lectures to master content.
john oshanahan
Top class training, very easy to follows courses, highly recommend to intermediate excel users. the quizzes and homework are great features