Microsoft Power BI Desktop for Business Intelligence
About Course
Dive into the world of Power BI with this comprehensive course, completely FREE, designed to transform you into a data analysis pro! This is the #1 best-selling Power BI Desktop course, featuring over 100,000 5-star reviews from around the globe, making it the ultimate choice for data professionals and aspiring analysts.
Taught by the experts at Maven Analytics, this course provides a hands-on approach, equipping you with practical skills through projects and real-world assignments. You’ll tackle the AdventureWorks Cycles case study, turning raw data into impactful reports and dashboards.
This course meticulously guides you through the key stages of the business intelligence workflow, covering data preparation, modeling, analysis, visualization, and dashboard design. From connecting to various data sources to creating interactive reports, this course equips you with the skills needed for success in today’s data-driven world.
Course Highlights:
- Connect & Shape Data: Mastering Power Query for data extraction, cleaning, transformation, and loading. Explore data connectors, storage modes, query editing tools, and advanced data manipulation techniques.
- Relational Data Modeling: Learn best practices for data modeling, including normalization, cardinality, star schemas, and creating your own AdventureWorks data model.
- DAX Power: Unlock the power of Data Analysis Expressions (DAX) to create calculated columns and measures. Explore row and filter context, master DAX syntax, and apply powerful functions to extract insights from your data.
- Data Visualization: Bring your data to life with reports and dashboards. Learn data visualization best practices, create compelling charts, and incorporate interactivity with slicers, bookmarks, parameters, and more.
- Advanced Techniques: Explore new Power BI features, leverage AI tools like decomposition trees and smart narratives, and optimize report performance for efficient data exploration.
What You Get:
- 15+ hours of high-quality video instruction
- 200+ page Power BI ebook
- 25 homework assignments and solutions
- Downloadable course project files
- Expert Q&A support forum
This course is completely FREE, providing you with immediate, lifetime access.
Offered on platforms like Udemy, Udacity, Coursera, MasterClass, NearPeer, and more.
Don’t miss out on this opportunity to learn Power BI from the best!
What Will You Learn?
- Build professional-quality business intelligence reports from the ground up
- Blend and transform raw data into beautiful interactive visuals & dashboards
- Design and implement the same tools used by professional data analysts and data scientists
- Showcase your skills with two full-scale course projects (with step-by-step solutions)
- Explore powerful artificial intelligence tools and advanced data analysis & visualization techniques
- Learn from a #1 best-selling instructor and professional Power BI developer
Course Content
01 – Getting Started
-
A Message from the Professor
-
002 Course Introduction.mp4
00:00 -
003 Course Structure & Outline.mp4
00:00 -
004 DOWNLOAD Course Resources.html
00:00 -
005 Introducing the Course Project.mp4
00:00 -
006 Setting Expectations.mp4
00:00
02 – Introducing Microsoft Power BI Desktop
-
001 Section Introduction.mp4
00:00 -
002 Meet Power BI Desktop.mp4
00:00 -
003 Downloading Power BI.mp4
00:00 -
004 IMPORTANT Adjusting Settings.mp4
00:00 -
005 Power BI Desktop Interface & Workflow.mp4
00:00 -
006 Resources & Monthly Updates.mp4
00:00
03 – Connecting & Shaping Data
-
001 Section Introduction.mp4
00:00 -
002 Power BI Front-End vs. Back-End.mp4
00:00 -
003 Types of Data Connectors.mp4
00:00 -
004 The Power Query Editor.mp4
00:00 -
005 Basic Table Transformations.mp4
00:00 -
006 ASSIGNMENT Table Transformations.mp4
00:00 -
007 SOLUTION Table Transformations.mp4
00:00 -
008 PRO TIP Storage & Connection Modes.mp4
00:00 -
009 Connecting to a Database.mp4
00:00 -
010 Extracting Data from the Web.mp4
00:00 -
011 Data QA & Profiling Tools.mp4
00:00 -
012 Text Tools.mp4
00:00 -
013 ASSIGNMENT Text-Specific Tools.mp4
00:00 -
014 SOLUTION Text-Specific Tools.mp4
00:00 -
015 Numerical Tools.mp4
00:00 -
016 ASSIGNMENT Numerical Tools.mp4
00:00 -
017 SOLUTION Numerical Tools.mp4
00:00 -
018 Date & Time Tools.mp4
00:00 -
019 Change Type with Locale.mp4
00:00 -
020 PRO TIP Rolling Calendars.mp4
00:00 -
021 ASSIGNMENT Calendar Tables.mp4
00:00 -
022 SOLUTION Calendar Tables.mp4
00:00 -
023 Index & Conditional Columns.mp4
00:00 -
024 Calculated Column Best Practices.mp4
00:00 -
025 Grouping & Aggregating.mp4
00:00 -
026 Pivoting & Unpivoting.mp4
00:00 -
027 Merging Queries.mp4
00:00 -
028 Appending Queries.mp4
00:00 -
029 PRO TIP Appending Files from a Folder.mp4
00:00 -
030 Data Source Settings.mp4
00:00 -
031 PRO TIP Data Source Parameters.mp4
00:00 -
032 Refreshing Queries.mp4
00:00 -
033 PRO TIP Importing Excel Models.mp4
00:00 -
034 Power Query Best Practices.mp4
00:00
04 – Creating a Data Model
-
001 Section Introduction.mp4
00:00 -
002 Data Modeling 101.mp4
00:00 -
003 Database Normalization.mp4
00:00 -
004 Fact & Dimension Tables.mp4
00:00 -
005 Primary & Foreign Keys.mp4
00:00 -
006 Relationships vs. Merged Tables.mp4
00:00 -
007 Creating Table Relationships.mp4
00:00 -
008 Managing & Editing Relationships.mp4
00:00 -
009 Star & Snowflake Schemas.mp4
00:00 -
010 ASSIGNMENT Table Relationships.mp4
00:00 -
011 SOLUTION Table Relationships.mp4
00:00 -
012 PRO TIP Active & Inactive Relationships.mp4
00:00 -
013 Relationship Cardinality.mp4
00:00 -
014 Connecting Multiple Fact Tables.mp4
00:00 -
015 Filter Context & Filter Flow.mp4
00:00 -
016 Bi-Directional Filters & Ambiguity.mp4
00:00 -
017 Hiding Fields from Report View.mp4
00:00 -
018 ASSIGNMENT Filter Flow.mp4
00:00 -
019 SOLUTION Filter Flow.mp4
00:00 -
020 PRO TIP Model Layouts.mp4
00:00 -
021 Data Formats & Categories.mp4
00:00 -
022 Creating Hierarchies.mp4
00:00 -
023 ASSIGNMENT Hierarchies.mp4
00:00 -
024 SOLUTION Hierarchies.mp4
00:00 -
025 Data Model Best Practices.mp4
00:00
05 – Calculated Fields with DAX
-
001 Section Introduction.mp4
00:00 -
002 Data Analysis Expressions 101.mp4
00:00 -
003 DAX vs. M Languages.mp4
00:00 -
004 Intro to DAX Calculated Columns.mp4
00:00 -
005 Intro to DAX Measures.mp4
00:00 -
006 Implicit vs. Explicit Measures.mp4
00:00 -
007 Quick Measures.mp4
00:00 -
008 RECAP Calculated Columns vs. Measures.mp4
00:00 -
009 PRO TIP Dedicated Measure Tables.mp4
00:00 -
010 Understanding Filter Context.mp4
00:00 -
011 Step-by-Step DAX Measure Calculation.mp4
00:00 -
012 DAX Syntax & Operators.mp4
00:00 -
013 Common DAX Function Categories.mp4
00:00 -
014 Basic Math & Stats Functions.mp4
00:00 -
015 Counting Functions.mp4
00:00 -
016 ASSIGNMENT Math & Stats Functions.mp4
00:00 -
017 SOLUTION Math & Stats Functions.mp4
00:00 -
018 Conditional & Logical Functions.mp4
00:00 -
019 The SWITCH Function.mp4
00:00 -
020 ASSIGNMENT Logical Functions.mp4
00:00 -
021 SOLUTION Logical Functions.mp4
00:00 -
022 Common Text Functions.mp4
00:00 -
023 ASSIGNMENT Text Functions.mp4
00:00 -
024 SOLUTION Text Functions.mp4
00:00 -
025 Basic Date & Time Functions.mp4
00:00 -
026 ASSIGNMENT Date & Time.mp4
00:00 -
027 SOLUTION Date & Time.mp4
00:00 -
028 Joining Data with RELATED.mp4
00:00 -
029 The CALCULATE Function.mp4
00:00 -
030 DAX Measure Totals.mp4
00:00 -
031 ASSIGNMENT CALCULATE.mp4
00:00 -
032 SOLUTION CALCULATE.mp4
00:00 -
033 The ALL Function.mp4
00:00 -
034 ASSIGNMENT CALCULATE & ALL.mp4
00:00 -
035 SOLUTION CALCULATE & ALL.mp4
00:00 -
036 The FILTER Function.mp4
00:00 -
037 Iterator (X) Functions.mp4
00:00 -
038 ASSIGNMENT Iterators.mp4
00:00 -
039 SOLUTION Iterators.mp4
00:00 -
040 Time Intelligence Patterns.mp4
00:00 -
041 ASSIGNMENT Time Intelligence.mp4
00:00 -
042 SOLUTION Time Intelligence.mp4
00:00 -
043 DAX Best Practices.mp4
00:00
06 – Visualizing Data with Reports
-
001 Section Introduction.mp4
00:00 -
002 The 3 Key Questions.mp4
00:00 -
003 Dashboard Design Framework.mp4
00:00 -
004 Sketching the Dashboard Layout.mp4
00:00 -
005 Adding Report Pages & Objects.mp4
00:00 -
006 Naming & Grouping Objects.mp4
00:00 -
007 Cards & Multi-Row Cards.mp4
00:00 -
008 ASSIGNMENT Cards.mp4
00:00 -
009 SOLUTION Cards.mp4
00:00 -
010 Building & Formatting Charts.mp4
00:00 -
011 Line Charts.mp4
00:00 -
012 PRO TIP Trend Lines & Forecasts.mp4
00:00 -
013 ASSIGNMENT Line Chart & Trend.mp4
00:00 -
014 SOLUTION Line Chart & Trend.mp4
00:00 -
015 KPI Cards.mp4
00:00 -
016 Bar & Donut Charts.mp4
00:00 -
017 Basic Filtering Options.mp4
00:00 -
018 ASSIGNMENT Donuts & Filters.mp4
00:00 -
019 SOLUTION Donuts & Filters.mp4
00:00 -
020 Table & Matrix Visuals.mp4
00:00 -
021 Conditional formatting.mp4
00:00 -
022 Top N Filtering.mp4
00:00 -
023 ASSIGNMENT Tables.mp4
00:00 -
024 SOLUTION Tables.mp4
00:00 -
025 Top N Text Cards.mp4
00:00 -
026 ASSIGNMENT Top N Text Cards.mp4
00:00 -
027 SOLUTION Top N Text Cards.mp4
00:00 -
028 Map Visuals.mp4
00:00 -
029 Report Slicers.mp4
00:00 -
030 ASSIGNMENT Slicers.mp4
00:00 -
031 SOLUTION Slicers.mp4
00:00 -
032 PRO TIP HASONEVALUE.mp4
00:00 -
033 Gauge Charts.mp4
00:00 -
034 PRO TIP Advanced Conditional Formatting.mp4
00:00 -
035 Area Charts.mp4
00:00 -
036 Drill Up & Drill Down.mp4
00:00 -
037 ASSIGNMENT Drill Up & Drill Down.mp4
00:00 -
038 SOLUTION Drill Up & Drill Down.mp4
00:00 -
039 Drillthrough Filters.mp4
00:00 -
040 Editing Report Interactions.mp4
00:00 -
041 ASSIGNMENT Report Interactions.mp4
00:00 -
042 SOLUTION Report Interactions.mp4
00:00 -
043 Adding Bookmarks.mp4
00:00 -
044 ASSIGNMENT Bookmarks.mp4
00:00 -
045 SOLUTION Bookmarks.mp4
00:00 -
046 PRO TIP Custom Navigation Buttons.mp4
00:00 -
047 PRO TIP Slicer Panels.mp4
00:00 -
048 Numeric Range Parameters.mp4
00:00 -
049 Fields Parameters.mp4
00:00 -
050 ASSIGNMENT Fields Parameters.mp4
00:00 -
051 SOLUTION Fields Parameters.mp4
00:00 -
052 PRO TIP Custom Tool Tips.mp4
00:00 -
053 Importing Custom Visuals.mp4
00:00 -
054 Managing & Viewing Roles.mp4
00:00 -
055 Mobile Layouts.mp4
00:00 -
056 PREVIEW Publishing to Power BI Service.mp4
00:00 -
057 Data Visualization Best Practices.mp4
00:00
07 – Artificial Intelligence (AI)
-
001 Section Introduction.mp4
00:00 -
002 Anomaly Detection.mp4
00:00 -
003 Smart Narratives.mp4
00:00 -
004 Q&A Visuals.mp4
00:00 -
005 Decomposition Trees.mp4
00:00 -
006 Key Influencers.mp4
00:00
08 – Power BI Optimization Tools
-
001 Section Introduction.mp4
00:00 -
002 The Optimize Ribbon.mp4
00:00 -
003 Pausing Visuals.mp4
00:00 -
004 Optimization Presets.mp4
00:00 -
005 Applying All Slicers.mp4
00:00 -
006 Performance Analyzer.mp4
00:00 -
007 External Tools.mp4
00:00
09 – BONUS PROJECT Maven Market
-
001 Introduction.html
00:00 -
002 PART 1 Connecting & Shaping the Data.html
00:00 -
003 PART 2 Creating the Data Model.html
00:00 -
004 PART 3 Adding DAX Measures.html
00:00 -
005 PART 4 Building the Report.html
00:00
10 – BONUS LESSON
-
001 BONUS LESSON.html
00:00
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet
