Sale!

Microsoft Power BI Desktop for Business Intelligence

Original price was: $25.00.Current price is: $5.00.

Price: 5.00 USD | Size: 5.15 GB |  Duration : 10.44  Hours  | 133 Video Lessons |  Bonus : Microsoft Power BI PDF Guides

BRAND: Expert TRAINING | ENGLISH | INSTANT DOWNLOAD | ⭐️⭐️⭐️⭐️⭐️ 4.9

 

OR

Description

Price: 5.00 USD | Size: 5.15 GB |  Duration : 10.44  Hours  | 133 Video Lessons |  Bonus : Microsoft Power BI PDF Guides

BRAND: Expert TRAINING | ENGLISH | INSTANT DOWNLOAD | ⭐️⭐️⭐️⭐️⭐️ 4.9

Microsoft Power BI Desktop for Business Intelligence

Master Power BI Desktop for data analysis with hands-on assignments & projects from top-rated Power BI instructors

What you’ll learn

  • Build professional-quality business intelligence reports from the ground up
  • Blend and transform raw data into beautiful interactive dashboards
  • Design and implement the same tools used by professional 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 visualization techniques
  • Learn from a #1 best-selling instructor and professional Power BI developer

Requirements

  • Microsoft Power BI Desktop (free download)
  • This course is designed for PC/Windows users (currently not available for Mac)
  • Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required

1. Getting Started
1. Course Structure & Outline
1. Course Structure & Outline
2. READ ME Important Notes for New Students
3. DOWNLOAD Course Resources
3.1 AdventureWorks CSV Files
3.2 Power_BI_AI_Visuals
3.3 AdventureWorks_Report_COMPLETE
3.4 AdventureWorks_Logo
3.5 kickstarter_projects
3.6 Up_&_Running_With_Power_BI_Desktop
4. Introducing the Course Project
4. Introducing the Course Project
5. Setting Expectations
5. Setting Expectations

2. Introducing Microsoft Power BI Desktop
1. Introduction
1. Introduction
2. Meet Microsoft Power BI Desktop
2. Meet Microsoft Power BI Desktop
3. Downloading Power BI & Adjusting Settings
3. Downloading Power BI & Adjusting Settings
4. IMPORTANT Regional Settings
5. Exploring the Power BI Desktop Interface & Workflow
5. Exploring the Power BI Desktop Interface & Workflow
6. Helpful Power BI Resources
6. Helpful Power BI Resources
7. UPDATE New Power BI Ribbon
7. UPDATE New Power BI Ribbon
8. QUIZ Introducing Microsoft Power BI Desktop

3. Connecting & Shaping Data with Power BI Desktop
1. Introduction
1. Introduction
2. Types of Data Connectors in Power BI Desktop
2. Types of Data Connectors in Power BI Desktop

3. The Power BI Query Editor (aka Power Query)
3. The Power BI Query Editor (aka Power Query)
4. Demo Basic Table Transformations in Power BI
4. Demo Basic Table Transformations in Power BI
5. Power BI Demo Working with Text Tools
5. Power BI Demo Working with Text Tools
6. Power BI Demo Working with Numerical Values
6. Power BI Demo Working with Numerical Values
7. Power BI Demo Working with Date & Time Tools
7. Power BI Demo Working with Date & Time Tools
8. PRO TIP Creating a Rolling Calendar in Power BI Desktop
8. PRO TIP Creating a Rolling Calendar in Power BI Desktop
9. Power BI Demo Generating Index & Conditional Columns
9. Power BI Demo Generating Index & Conditional Columns

10. Power BI Demo Grouping & Aggregating Records
10. Power BI Demo Grouping & Aggregating Records
11. Power BI Demo Pivoting & Unpivoting Data
11. Power BI Demo Pivoting & Unpivoting Data
11.1 Unpivot_Demo
12. Merging Queries in Power BI Desktop
12. Merging Queries in Power BI Desktop
13. Appending Queries in Power BI Desktop
13. Appending Queries in Power BI Desktop
14. PRO TIP Appending Files from a Folder
14. PRO TIP Appending Files from a Folder
15. Configuring Power BI Data Source Settings
15. Configuring Power BI Data Source Settings
16. Configuring Power BI Query Refresh Settings
16. Configuring Power BI Query Refresh Settings
17. Additional Data Types & Categories in Power BI
17. Additional Data Types & Categories in Power BI
18. Defining Hierarchies in Power BI Desktop
18. Defining Hierarchies in Power BI Desktop
19. PRO TIP Importing Models from Excel to Power BI
19. PRO TIP Importing Models from Excel to Power BI
20. Power BI Data Connection Best Practices
20. Power BI Data Connection Best Practices
21. QUIZ Connecting & Shaping Data with Power BI Desktop
22. HOMEWORK Connecting & Shaping Data with Power BI Desktop
23. HOMEWORK SOLUTION Connecting & Shaping Data with Power BI Desktop
23. HOMEWORK SOLUTION Connecting & Shaping Data with Power BI Desktop

4. Creating Table Relationships & Data Models in Power BI
1. Introduction
1. Introduction
1.1 AdventureWorks_Report_SEC3_COMPLETE
2. What is a Data Model
2. What is a Data Model
3. Principles of Database Normalization
3. Principles of Database Normalization
4. Understanding Data Tables vs. Lookup Tables
4. Understanding Data Tables vs. Lookup Tables
5. Understanding Table Relationships vs. Merged Tables
5. Understanding Table Relationships vs. Merged Tables
6. Creating Table Relationships in Power BI Desktop
6. Creating Table Relationships in Power BI Desktop
7. Snowflake Schemas in Power BI
7. Snowflake Schemas in Power BI
8. Managing & Editing Table Relationships in Power BI Desktop
8. Managing & Editing Table Relationships in Power BI Desktop
9. Managing Active vs. Inactive Relationships
9. Managing Active vs. Inactive Relationships
10. Understanding Relationship Cardinality
10. Understanding Relationship Cardinality
11. Connecting Multiple Data Tables in Power BI Desktop
11. Connecting Multiple Data Tables in Power BI Desktop
12. Understanding Filter Flow
12. Understanding Filter Flow
13. Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
13. Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
14. Hiding Fields from the Power BI Report View
14. Hiding Fields from the Power BI Report View
15. UPDATE New Power BI Desktop Model View
15. UPDATE New Power BI Desktop Model View
16. Power BI Data Model Best Practices
16. Power BI Data Model Best Practices
17. QUIZ Creating Table Relationships & Data Models in Power BI
18. HOMEWORK Creating Table Relationships & Data Models in Power BI
19. HOMEWORK SOLUTION Creating Table Relationships & Data Models in Power BI
19. HOMEWORK SOLUTION Creating Table Relationships & Data Models in Power BI

 

 

5. Analyzing Data with DAX Calculations in Power BI
1. Introduction
1. Introduction
1.1 AdventureWorks_Report_SEC4_COMPLETE
2. Meet Data Analysis Expressions (DAX)
2. Meet Data Analysis Expressions (DAX)

3. Intro to DAX Calculated Columns
3. Intro to DAX Calculated Columns
4. Intro to DAX Measures
4. Intro to DAX Measures
5. RECAP Calculated Columns vs. DAX Measures
5. RECAP Calculated Columns vs. DAX Measures
6. Adding Columns & DAX Measures in Power BI Desktop
6. Adding Columns & DAX Measures in Power BI Desktop
7. Implicit vs. Explicit DAX Measures
7. Implicit vs. Explicit DAX Measures
8. Filter Context Examples in Power BI
8. Filter Context Examples in Power BI
9. Step-by-Step DAX Measure Calculation
9. Step-by-Step DAX Measure Calculation

10. Understanding DAX Syntax & Operators
10. Understanding DAX Syntax & Operators
11. Common DAX Function Categories
11. Common DAX Function Categories
12. DAX Demo Basic Date & Time Functions
12. DAX Demo Basic Date & Time Functions
13. DAX Demo Conditional & Logical Functions (IFANDOR)
13. DAX Demo Conditional & Logical Functions (IFANDOR)
14. DAX Demo Common Text Functions
14. DAX Demo Common Text Functions
15. DAX Demo Joining Data with RELATED
15. DAX Demo Joining Data with RELATED
16. DAX Demo Basic Math & Stats Functions
16. DAX Demo Basic Math & Stats Functions
17. DAX Demo COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
17. DAX Demo COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
18. IMPORTANT Order Line Items
18. IMPORTANT Order Line Items
19. DAX Demo CALCULATE
19. DAX Demo CALCULATE
20. DAX Demo CALCULATE & ALL
20. DAX Demo CALCULATE & ALL
21. DAX Demo CALCULATE & FILTER
21. DAX Demo CALCULATE & FILTER
22. DAX Demo Iterator Functions (SUMX, RANKX)
22. DAX Demo Iterator Functions (SUMX, RANKX)
23. DAX Demo Time Intelligence Formulas
23. DAX Demo Time Intelligence Formulas
24. DAX Best Practices in Power BI Desktop
24. DAX Best Practices in Power BI Desktop
25. QUIZ Analyzing Data with DAX Calculations in Power BI
26. HOMEWORK Analyzing Data with DAX Calculations in Power BI
27. HOMEWORK SOLUTION Analyzing Data with DAX Calculations in Power BI
27. HOMEWORK SOLUTION Analyzing Data with DAX Calculations in Power BI

 

6. Visualizing Data with Power BI Reports
1. Introduction
1. Introduction
1.1 AdventureWorks_Report_SEC5_COMPLETE
2. Exploring the Report View in Power BI Desktop
2. Exploring the Report View in Power BI Desktop
3. Adding Simple Objects to the Power BI Report Canvas
3. Adding Simple Objects to the Power BI Report Canvas
4. Inserting Basic Charts & Visuals in Power BI
4. Inserting Basic Charts & Visuals in Power BI
5. UPDATE Conditional Formatting
5. UPDATE Conditional Formatting
6. Power BI Report Formatting Options
6. Power BI Report Formatting Options
7. Power BI Report Filtering Options
7. Power BI Report Filtering Options
8. Power BI Demo Exploring Data with Matrix Visuals
8. Power BI Demo Exploring Data with Matrix Visuals
9. Power BI Demo Filtering with Date Slicers
9. Power BI Demo Filtering with Date Slicers
10. Power BI Demo Showing Key Metrics with Cards & KPI Visuals
10. Power BI Demo Showing Key Metrics with Cards & KPI Visuals
11. Power BI Demo Inserting Text Cards
11. Power BI Demo Inserting Text Cards
12. Power BI Demo Visualizing Geospatial Data with Maps
12. Power BI Demo Visualizing Geospatial Data with Maps
13. Power BI Demo Visualizing Data with Treemaps
13. Power BI Demo Visualizing Data with Treemaps
14. Power BI Demo Showing Trends with Line & Area Charts
14. Power BI Demo Showing Trends with Line & Area Charts
15. Power BI Demo Adding Trend Lines & Forecasts
15. Power BI Demo Adding Trend Lines & Forecasts
16. Power BI Demo Goal Pacing with Gauge Charts
16. Power BI Demo Goal Pacing with Gauge Charts
17. Editing Power BI Report Interactions
17. Editing Power BI Report Interactions
18. Power BI Demo Adding Drillthrough Filters
18. Power BI Demo Adding Drillthrough Filters
19. Using Power BI Report Bookmarks
19. Using Power BI Report Bookmarks
20. PRO TIP Testing Scenarios with What-If Parameters
20. PRO TIP Testing Scenarios with What-If Parameters
21. Managing & Viewing Roles in Power BI Desktop
21. Managing & Viewing Roles in Power BI Desktop
22. PREVIEW Custom Power BI Visuals (Log-in Required)
22. PREVIEW Custom Power BI Visuals (Log-in Required)
23. PREVIEW Designing for Phone vs. Desktop Report Viewers
23. PREVIEW Designing for Phone vs. Desktop Report Viewers
24. PREVIEW Publishing to Power BI Service
24. PREVIEW Publishing to Power BI Service
25. Power BI Data Visualization Best Practices
25. Power BI Data Visualization Best Practices
26. QUIZ Visualizing Data with Power BI Reports
27. HOMEWORK Visualizing Data with Power BI Reports
28. HOMEWORK SOLUTION Visualizing Data with Power BI Reports
28. HOMEWORK SOLUTION Visualizing Data with Power BI Reports

7.NEW Artificial Intelligence (AI) Visuals
1. Power BI Demo Q&A Visual
1. Power BI Demo Q&A Visual
2. Power BI Demo Key Influencers Visual (Part 1)
2. Power BI Demo Key Influencers Visual (Part 1)
3. Power BI Demo Key Influencers Visual (Part 2)
3. Power BI Demo Key Influencers Visual (Part 2)
4. IMPORTANT Correlation vs. Causation
4. IMPORTANT Correlation vs. Causation
5. Power BI Demo Decomposition Tree Visual
5. Power BI Demo Decomposition Tree Visual

8. Bonus Project Maven Market
1. Introduction
1.1 Maven_Market_Report_COMPLETE
1.2 Maven_Market
1.3 Maven Market CSV Files
2. PART 1 Connecting & Shaping the Data
3. PART 2 Creating the Data Model
4. PART 3 Adding DAX Measures
5. PART 4 Building the Report

9. Wrapping Up
1. REFERENCE Monthly Power BI Updates
2. BONUS LECTURE More from Maven Analytics

0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Add to cart