Home
EN - GBP
Site Language
Site Currency
Microsoft Power BI Desktop for Business Intelligence
  • Home
  • Courses
  • Microsoft Power BI Desktop for Business Intelligence
Microsoft Power BI Desktop for Business Intelligence
0.00 (0)
Business Development / Analytics & Intelligence

Microsoft Power BI Desktop for Business Intelligence

Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top

Rita Tremblay
Rita Tremblay
7 Students enrolled
Intermediate
English
This course includes:
  • 13h 45m
  • 122 Lectures
  • 162 Downloadable assets
  • Full lifetime access
  • Access on Mobile and TV
  • Certificate on completion
GBP990.00

Overview

What will students learn in your course?
  • Build professional-quality business intelligence reports from the ground up
  • Blend and transform raw data into beautiful interactive dashboards
  • Design and implement the same B.I. tools used by professional analysts and data scientists
  • Showcase your skills with two full-scale course projects (with step-by-step solutions)
  • Understand the business intelligence workflow from end-to-end
  • Learn from a best-selling instructor and professional BI developer
What are the requirements or prerequisites for taking your course?
  • 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
Who is the course for?
  • Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
  • Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
  • Aspiring data professionals looking to master the #1 business intelligence tool on the market
  • Students who want a comprehensive, engaging, and highly interactive approach to training
  • Anyone looking to pursue a career in data analysis or business intelligence
Description
Course tags

Course content

  • 9 Sections
  • 122 Lectures
  • 13h 45m Total length
Getting Started
35m
5 Lectures

Getting Started

Course Structure & Outline
Preview 0:06:12
READ ME: Important Notes for New Students
0:06:12
DOWNLOAD: Course Resources
0:09:13
Introducing the Course Project
Preview 0:06:54
Setting Expectations
0:06:54
Introduction
0:09:13
Meet Microsoft Power BI Desktop
Preview 0:03:41
Downloading Power BI & Adjusting Settings
0:07:30
IMPORTANT: Regional Settings
0:09:13
Exploring the Power BI Desktop Interface & Workflow
Preview 0:06:54
Helpful Power BI Resources
0:09:13
UPDATE: New Power BI Ribbon
0:07:30
QUIZ: Introducing Microsoft Power BI Desktop
0:06:12
Introduction
0:09:13
Types of Data Connectors in Power BI Desktop
0:09:13
The Power BI Query Editor (aka Power Query)
0:06:12
Demo: Basic Table Transformations in Power BI
0:06:12
Power BI Demo: Working with Text Tools
Preview 0:06:12
Power BI Demo: Working with Numerical Values
0:06:54
Power BI Demo: Working with Date & Time Tools
0:06:12
PRO TIP: Creating a Rolling Calendar in Power BI Desktop
0:07:30
Power BI Demo: Generating Index & Conditional Columns
0:06:12
Power BI Demo: Grouping & Aggregating Records
0:06:12
Power BI Demo: Pivoting & Unpivoting Data
Preview 0:03:41
Merging Queries in Power BI Desktop
0:07:30
Appending Queries in Power BI Desktop
0:09:13
PRO TIP: Appending Files from a Folder
Preview 0:09:13
Configuring Power BI Data Source Settings
0:07:30
Configuring Power BI Query Refresh Settings
0:03:41
Additional Data Types & Categories in Power BI
0:06:12
Defining Hierarchies in Power BI Desktop
0:09:13
PRO TIP: Importing Models from Excel to Power BI
0:03:41
Power BI Data Connection Best Practices
0:03:41
QUIZ: Connecting & Shaping Data with Power BI Desktop
0:06:54
HOMEWORK: Connecting & Shaping Data with Power BI Desktop
0:06:12
HOMEWORK SOLUTION: Connecting & Shaping Data with Power BI Desktop
0:06:54
Introduction
0:09:13
What is a "Data Model"?
0:06:54
Principles of Database Normalization
0:07:30
Understanding Data Tables vs. Lookup Tables
0:06:54
Understanding Table Relationships vs. Merged Tables
0:06:12
Creating Table Relationships in Power BI Desktop
0:06:54
"Snowflake" Schemas in Power BI
Preview 0:03:41
Managing & Editing Table Relationships in Power BI Desktop
0:09:13
Managing Active vs. Inactive Relationships
0:03:41
Understanding Relationship Cardinality
Preview 0:09:13
Connecting Multiple Data Tables in Power BI Desktop
0:09:13
Understanding Filter Flow
0:07:30
Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
0:06:54
Hiding Fields from the Power BI Report View
0:06:12
UPDATE: New Power BI Desktop "Model" View
0:09:13
Power BI Data Model Best Practices
0:09:13
QUIZ: Creating Table Relationships & Data Models in Power BI
0:03:41
HOMEWORK: Creating Table Relationships & Data Models in Power BI
0:06:54
HOMEWORK SOLUTION: Creating Table Relationships & Data Models in Power BI
0:07:30
Introduction
0:06:12
Meet Data Analysis Expressions (DAX)
0:06:54
Intro to DAX Calculated Columns
0:03:41
Intro to DAX Measures
0:06:12
RECAP: Calculated Columns vs. DAX Measures
Preview 0:09:13
Adding Columns & DAX Measures in Power BI Desktop
0:06:54
Implicit vs. Explicit DAX Measures
0:03:41
Filter Context Examples in Power BI
0:03:41
Step-by-Step DAX Measure Calculation
Preview 0:06:12
Understanding DAX Syntax & Operators
0:06:12
Common DAX Function Categories
0:09:13
DAX Demo: Basic Date & Time Functions
0:03:41
DAX Demo: Conditional & Logical Functions (IF/AND/OR)
0:03:41
DAX Demo: Common Text Functions
0:03:41
DAX Demo: Joining Data with RELATED
0:07:30
DAX Demo: Basic Math & Stats Functions
0:07:30
DAX Demo: COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
0:07:30
IMPORTANT: Order Line Items
0:06:54
DAX Demo: CALCULATE
Preview 0:06:12
DAX Demo: CALCULATE & ALL
0:06:54
DAX Demo: CALCULATE & FILTER
0:07:30
DAX Demo: Iterator Functions (SUMX, RANKX)
0:06:12
DAX Demo: Time Intelligence Formulas
0:06:54
DAX Best Practices in Power BI Desktop
0:06:12
QUIZ: Analyzing Data with DAX Calculations in Power BI
0:06:12
HOMEWORK: Analyzing Data with DAX Calculations in Power BI
0:06:12
HOMEWORK SOLUTION: Analyzing Data with DAX Calculations in Power BI
0:06:12
Introduction
0:06:54
Exploring the "Report" View in Power BI Desktop
0:03:41
Adding Simple Objects to the Power BI Report Canvas
0:06:54
Inserting Basic Charts & Visuals in Power BI
0:06:54
UPDATE: Conditional Formatting
0:07:30
Power BI Report Formatting Options
0:07:30
Power BI Report Filtering Options
0:07:30
Power BI Demo: Exploring Data with Matrix Visuals
0:09:13
Power BI Demo: Filtering with Date Slicers
0:06:54
Power BI Demo: Showing Key Metrics with Cards & KPI Visuals
Preview 0:03:41
Power BI Demo: Inserting Text Cards
0:06:54
Power BI Demo: Visualizing Geospatial Data with Maps
0:03:41
Power BI Demo: Visualizing Data with Treemaps
0:06:12
Power BI Demo: Showing Trends with Line & Area Charts
0:06:12
Power BI Demo: Adding Trend Lines & Forecasts
0:06:12
Power BI Demo: Goal Pacing with Gauge Charts
Preview 0:09:13
Editing Power BI Report Interactions
0:06:12
Power BI Demo: Adding Drillthrough Filters
0:06:54
Using Power BI Report Bookmarks
Preview 0:09:13
PRO TIP: Testing Scenarios with "What-If" Parameters
0:09:13
Managing & Viewing Roles in Power BI Desktop
0:09:13
PREVIEW: Custom Power BI Visuals (Log-in Required)
0:09:13
PREVIEW: Designing for Phone vs. Desktop Report Viewers
0:09:13
PREVIEW: Publishing to Power BI Service
0:03:41
Power BI Data Visualization Best Practices
0:03:41
QUIZ: Visualizing Data with Power BI Reports
0:07:30
HOMEWORK: Visualizing Data with Power BI Reports
0:06:12
HOMEWORK SOLUTION: Visualizing Data with Power BI Reports
0:09:13
Power BI Demo: Q&A Visual
0:06:12
Power BI Demo: Key Influencers Visual (Part 1)
0:07:30
Power BI Demo: Key Influencers Visual (Part 2)
0:09:13
IMPORTANT: Correlation vs. Causation
0:03:41
Power BI Demo: Decomposition Tree Visual
0:06:12
Introduction
0:06:54
PART 1: Connecting & Shaping the Data
0:03:41
PART 2: Creating the Data Model
0:06:54
PART 3: Adding DAX Measures
0:09:13
PART 4: Building the Report
0:03:41
REFERENCE: Monthly Power BI Updates
0:09:13
BONUS LESSON
Preview 0:06:54

About tutor

Rita Tremblay
0.00 (0)

Rita Tremblay

Courses 2

I received a master's degree in Accounts, Geography, and English from the University of North Dakota. I have experience with the both one-on-one and group tutoring.

View profile

More courses from Rita

The Complete Train the Trainer Bootcamp - Beginners-Advanced
4.00 (1)
The Complete Train the Trainer Bootcamp - Beginners-Advanced
67h 35m 603 Lectures

GBP726.00

Rita Tremblay
Rita Tremblay
The website uses cookies to provide the best user experience while browsing safely. You can read more about cookies in the Privacy Policy. Read more Accept cookies Choose cookies