Microsoft Power BI - Up & Running With Power BI Desktop
4.6 /5- Offered byUDEMY
Microsoft Power BI - Up & Running With Power BI Desktop at UDEMY Overview
Duration | 6 hours |
Total fee | ₹12,800 |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Power BI - Up & Running With Power BI Desktop at UDEMY Highlights
- Compatible on Mobile and TV
- Earn a Cerificate on successful completion
- Get Full Lifetime Access
- Course Instructor: Maven Analytics
Microsoft Power BI - Up & Running With Power BI Desktop at UDEMY Course details
- 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
- 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
- In this course, you'll be playing the role of Lead Business Intelligence Analyst for Adventure Works Cycles, a global manufacturing company
Microsoft Power BI - Up & Running With Power BI Desktop at UDEMY Curriculum
Getting Started
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Introducing the Course Project
Setting Expectations
Introducing Microsoft Power BI Desktop
Introduction
Meet Microsoft Power BI Desktop
Downloading Power BI & Adjusting Settings
IMPORTANT: Regional Settings
Exploring the Power BI Desktop Interface & Workflow
Helpful Power BI Resources
Connecting & Shaping Data with Power BI Desktop
Introduction
Types of Data Connectors in Power BI Desktop
The Power BI Query Editor (aka Power Query)
Demo: Basic Table Transformations in Power BI
Power BI Demo: Working with Text Tools
Power BI Demo: Working with Numerical Values
Power BI Demo: Working with Date & Time Tools
PRO TIP: Creating a Rolling Calendar in Power BI Desktop
Power BI Demo: Generating Index & Conditional Columns
Power BI Demo: Grouping & Aggregating Records
Power BI Demo: Pivoting & Unpivoting Data
Merging Queries in Power BI Desktop
Appending Queries in Power BI Desktop
PRO TIP: Appending Files from a Folder
Configuring Power BI Data Source Settings
Configuring Power BI Query Refresh Settings
Additional Data Types & Categories in Power BI
Defining Hierarchies in Power BI Desktop
PRO TIP: Importing Models from Excel to Power BI
Power BI Data Connection Best Practices
HOMEWORK: Connecting & Shaping Data with Power BI Desktop
HOMEWORK SOLUTION: Connecting & Shaping Data with Power BI Desktop
Creating Table Relationships & Data Models in Power BI
Introduction
What is a "Data Model"?
Principles of Database Normalization
Understanding Data Tables vs. Lookup Tables
Understanding Table Relationships vs. Merged Tables
Creating Table Relationships in Power BI Desktop
"Snowflake" Schemas in Power BI
Managing & Editing Table Relationships in Power BI Desktop
Managing Active vs. Inactive Relationships
Understanding Relationship Cardinality
Connecting Multiple Data Tables in Power BI Desktop
Understanding Filter Flow
Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
Hiding Fields from the Power BI Report View
UPDATE: New Power BI Desktop "Model" View
Power BI Data Model Best Practices
HOMEWORK: Creating Table Relationships & Data Models in Power BI
HOMEWORK SOLUTION: Creating Table Relationships & Data Models in Power BI
Analyzing Data with DAX Calculations in Power BI
Introduction
Meet Data Analysis Expressions (DAX)
Intro to DAX Calculated Columns
Intro to DAX Measures
RECAP: Calculated Columns vs. DAX Measures
Adding Columns & DAX Measures in Power BI Desktop
Implicit vs. Explicit DAX Measures
Filter Context Examples in Power BI
Step-by-Step DAX Measure Calculation
Understanding DAX Syntax & Operators
Common DAX Function Categories
DAX Demo: Basic Date & Time Functions
DAX Demo: Conditional & Logical Functions (IF/AND/OR)
DAX Demo: Common Text Functions
DAX Demo: Joining Data with RELATED
DAX Demo: Basic Math & Stats Functions
DAX Demo: COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
IMPORTANT: Order Line Items
DAX Demo: CALCULATE
DAX Demo: CALCULATE & ALL
DAX Demo: CALCULATE & FILTER
DAX Demo: Iterator Functions (SUMX, RANKX)
DAX Demo: Time Intelligence Formulas
DAX Best Practices in Power BI Desktop
HOMEWORK: Analyzing Data with DAX Calculations in Power BI
HOMEWORK SOLUTION: Analyzing Data with DAX Calculations in Power BI
Visualizing Data with Power BI Reports
Introduction
Exploring the "Report" View in Power BI Desktop
Adding Simple Objects to the Power BI Report Canvas
Inserting Basic Charts & Visuals in Power BI
Power BI Report Formatting Options
Power BI Report Filtering Options
Power BI Demo: Exploring Data with Matrix Visuals
Power BI Demo: Filtering with Date Slicers
Power BI Demo: Showing Key Metrics with Cards & KPI Visuals
Power BI Demo: Inserting Text Cards
Power BI Demo: Visualizing Geospatial Data with Maps
Power BI Demo: Visualizing Data with Treemaps
Power BI Demo: Showing Trends with Line & Area Charts
Power BI Demo: Adding Trend Lines & Forecasts
Power BI Demo: Goal Pacing with Gauge Charts
Editing Power BI Report Interactions
Power BI Demo: Adding Drillthrough Filters
Using Power BI Report Bookmarks
PRO TIP: Testing Scenarios with "What-If" Parameters
Managing & Viewing Roles in Power BI Desktop
PREVIEW: Custom Power BI Visuals (Log-in Required)
PREVIEW: Designing for Phone vs. Desktop Report Viewers
PREVIEW: Publishing to Power BI Service
Power BI Data Visualization Best Practices
HOMEWORK: Visualizing Data with Power BI Reports
HOMEWORK SOLUTION: Visualizing Data with Power BI Reports
NEW: Artificial Intelligence (AI) Visuals
Power BI Demo: Q&A Visual
Power BI Demo: Key Influencers Visual (Part 1)
Power BI Demo: Key Influencers Visual (Part 2)
IMPORTANT: Correlation vs. Causation
Power BI Demo: Decomposition Tree Visual
Wrapping Up
REFERENCE: Monthly Power BI Updates
Resources & Next Steps
More from Maven Analytics
Bonus Course Project: Maven Market
Introduction
PART 1: Connecting & Shaping the Data
PART 2: Creating the Data Model
PART 3: Adding DAX Measures
PART 4: Building the Report
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?