Microsoft Power BI Desktop for Business Intelligence

BY
Udemy

Master Power BI Desktop and get insight into advanced Power BI analysis and data visualization with a leading Microsoft Power BI instructor.

Mode

Online

Fees

₹ 449 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Power BI is rapidly becoming the world's most powerful self-service business intelligence platform and an indispensable instrument for data pros and novices. You can connect to hundreds of data sources using BI, create large relational models with easy and intuitive tools, and develop interactive dashboards from scratch. Chris Dutton, the founder of Maven Analytics, helps individuals and teams develop expert-level analytics and business intelligence skills created the Microsoft Power BI Desktop for Business Intelligence online certification, which is available through Udemy

Microsoft Power BI Desktop for Business Intelligence online training offers 10.5 hours of digital lessons and 27 articles designed to teach applicants the fundamental concepts required to understand and build applications with Microsoft Power BI Desktop. Microsoft Power BI Desktop for Business Intelligence online course focuses more on concepts such as connecting & Transform Raw Data, Building a Relational Data Model, Adding calculated fields with DAX, and developing Design Interactive Power BI Reports as well as creating reports and dashboards that are collections of visuals and share reports with others using the Power BI service.

The highlights

  • 10.5 hours of on-demand video
  • Self-paced course
  • 27 articles + resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Program offerings

  • Full lifetime access on mobile and tv access
  • Completion certificate
  • Money-back guarantee for 30 days

Course and certificate fees

Fees information
₹ 449  ₹3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Knowledge of data visualization

After completing the Microsoft Power BI Desktop for Business Intelligence certification course the applicant will get an insight into how to build business intelligence reports of professional quality from scratch, combine and transform raw data into beautiful interactive dashboards, and design and implement the BI tools used by experienced analysts and data scientists.

Learn from a best-selling instructor and professional BI developer as you complete two comprehensive course projects (with step-by-step solutions) and study the business intelligence workflow from beginning to end.

The syllabus

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
  • UPDATE: New Power BI Ribbon
  • QUIZ: Introducing Microsoft Power BI Desktop

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
  • QUIZ: Connecting & Shaping Data with Power BI Desktop
  • 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
  • QUIZ: Creating Table Relationships & Data Models in Power BI
  • 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
  • QUIZ: Analyzing Data with DAX Calculations in Power BI
  • 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
  • UPDATE: Conditional Formatting
  • 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
  • QUIZ: Visualizing Data with Power BI Reports
  • 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

Bonus 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

Wrapping Up

  • REFERENCE: Monthly Power BI Updates
  • BONUS LECTURE: More from Maven

Instructors

Mr Chris Dutton
Founder
Freelancer

Mr Aaron Parry
Trainer
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books