Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-15 20:12:05
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Microsoft Power BI

Microsoft Power BI Desktop for Business Intelligence

Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top Microsoft Power BI instructor
Bestseller
Rating: 4.6 out of 54.6 (31,535 ratings)
111,271 students
Created by Maven Analytics, Chris Dutton, Aaron Parry
Last updated 2/2021
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

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 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
Curated for the Udemy for Business collection

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

Description

Hear why this is one of the TOP-RATED Power BI courses on Udemy:

"Instructor is top notch - moves at the right pace and keeps it interesting. Best Power BI course on Udemy!"

-Adam Edwards

"Resources are awesome. Presenter is brilliant. I found this course more useful than the offical Power BI course from Microsoft. Things are easy to follow, and presentations are of high quality."

-Jacobus M.

"Chris is a skilled communicator and does a great job of explaining a complex tool like Microsoft Power BI. His 'pro-tips' are great for new user productivity and gaining a sense of the big picture, and I value his best practices on building and managing Power BI queries and reports. I'm feeling much more confident to dig in and use Power BI on my own projects!"

-Bill Jerrow

__________

COURSE DESCRIPTION:

If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place.

Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch -- all for free.

__________

THE COURSE PROJECT:

In this course, you'll be playing the role of Lead Business Intelligence Analyst for Adventure Works Cycles, a global manufacturing company. Your mission? To design and deliver a professional-quality, end-to-end business intelligence solution, armed only with Power BI and a handful of raw csv files.

But don't worry, I'll be guiding you through the ins-and-outs of Power BI Desktop, sharing crystal clear explanations and helpful pro tips each step of the way. We'll follow a steady, systematic progression through the Power BI workflow, and break down our project into FOUR KEY OBJECTIVES:

__________

POWER BI OBJECTIVE #1: Connect & Transform the Raw Data

  • Intro to the Power BI Query Editor

  • Types of Power BI Data Connectors

  • Basic Table Transformations

  • Text, Number & Date Tools

  • Index & Conditional Columns

  • Grouping & Aggregating Data

  • Pivoting & Unpivoting

  • Modifying, Merging & Appending Queries

  • Connecting to Folders

  • Defining Hierarchies & Categories

  • Query Editing & Power BI Best Practices

__________

POWER BI OBJECTIVE #2: Build a Relational Data Model

  • Intro to Database Normalization

  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables

  • Creating Power BI Table Relationships

  • "Star" vs. "Snowflake" Schemas

  • Active vs. Inactive Relationships

  • Relationship Cardinality

  • Connecting Multiple Data Tables

  • Filtering & Cross-Filtering

  • Hiding Fields from the Power BI Report View

  • Data Modeling & Power BI best Practices

__________

POWER BI OBJECTIVE #3: Add Calculated Fields with DAX

  • Intro to Data Analysis Expressions (DAX)

  • Calculated Columns vs. Measures

  • Row Context vs. Filter Context in Power BI

  • DAX Syntax & Operators

  • Common Power BI Functions

  • Basic Date & Time Formulas

  • Logical & Conditional Statements

  • Text, Math & Stats Functions

  • Joining Data with RELATED

  • CALCULATE, ALL & FILTER Functions

  • DAX Iterators (SUMX, AVERAGEX)

  • Time Intelligence Formulas

  • DAX & Power BI Best Practices

__________

POWER BI OBJECTIVE #4: Design Interactive Power BI Reports

  • Intro to the Power BI Report View

  • Adding Basic Charts to Power BI Reports

  • Formatting & Filtering Options

  • Matrix Visuals

  • Slicers & Timelines

  • Cards & KPIs

  • Power BI Map Visuals (Basic, Fill, ArcGIS)

  • Treemaps, Lines, Areas & Gauges

  • Editing Report interactions

  • Adding Drillthrough Filters

  • Linking to Report Bookmarks

  • Using "What-If" Parameters

  • Managing & Viewing Roles

  • PREVIEW: Publishing to Power BI Service

  • Power BI Data Viz Best Practices

__________

By the end of the Adventure Works project, not only will you have developed an entire business intelligence tool from the ground up using Power BI, but you will have gained the knowledge and confidence to apply these same concepts to your own Power BI projects.

For those looking for more opportunities to test their Power BI skills, I've also included an additional set of project files for a bonus Final Project. This is your chance to showcase all of the skills you've developed throughout the course, and apply them to a brand new data set from Maven Market, a global supermarket chain.

Whether you're a casual Power BI user, aspiring analyst, or data science professional, this course will give you the tools you need to become an absolute Power BI ROCK STAR -- guaranteed.

__________

Join today and get immediate, lifetime access to the following:

  • 100+ page Power BI ebook

  • Downloadable Power BI project files

  • Homework exercises & quizzes

  • 1-on-1 expert support

  • Course Q&A forum

  • 30-day money-back guarantee

See you in there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Who this course is 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

Featured review

Dănuț Oprișan
Dănuț Oprișan
29 courses
2 reviews
Rating: 5.0 out of 5a year ago
This is the best course on Power BI I have encountered! He makes it really easy to understand such complex topics and it trains you as you go along so that once you're finished with the course you are confident enough to work on your own. I totally recommend this course to anyone who is interested in Power BI or Business Inteligence.

Course content

9 sections • 117 lectures • 11h 5m total length

  • Preview01:43
  • READ ME: Important Notes for New Students
    01:54
  • DOWNLOAD: Course Resources
    00:25
  • Preview03:02
  • Setting Expectations
    02:21

  • Introduction
    00:26
  • Preview05:30
  • Downloading Power BI & Adjusting Settings
    04:05
  • IMPORTANT: Regional Settings
    01:50
  • Preview02:34
  • Helpful Power BI Resources
    01:44
  • UPDATE: New Power BI Ribbon
    07:15
  • QUIZ: Introducing Microsoft Power BI Desktop
    7 questions

  • Introduction
    00:30
  • Types of Data Connectors in Power BI Desktop
    03:53
  • The Power BI Query Editor (aka Power Query)
    04:28
  • Demo: Basic Table Transformations in Power BI
    10:03
  • Power BI Demo: Working with Text Tools
    Preview14:54
  • Power BI Demo: Working with Numerical Values
    08:37
  • Power BI Demo: Working with Date & Time Tools
    08:53
  • PRO TIP: Creating a Rolling Calendar in Power BI Desktop
    07:08
  • Power BI Demo: Generating Index & Conditional Columns
    08:30
  • Power BI Demo: Grouping & Aggregating Records
    07:33
  • Preview08:04
  • Merging Queries in Power BI Desktop
    06:41
  • Appending Queries in Power BI Desktop
    06:29
  • Preview07:38
  • Configuring Power BI Data Source Settings
    05:05
  • Configuring Power BI Query Refresh Settings
    03:06
  • Additional Data Types & Categories in Power BI
    07:19
  • Defining Hierarchies in Power BI Desktop
    04:35
  • PRO TIP: Importing Models from Excel to Power BI
    05:40
  • Power BI Data Connection Best Practices
    02:09
  • QUIZ: Connecting & Shaping Data with Power BI Desktop
    12 questions
  • HOMEWORK: Connecting & Shaping Data with Power BI Desktop
    01:10
  • HOMEWORK SOLUTION: Connecting & Shaping Data with Power BI Desktop
    12:36

  • Introduction
    00:19
  • What is a "Data Model"?
    05:17
  • Principles of Database Normalization
    04:07
  • Understanding Data Tables vs. Lookup Tables
    07:25
  • Understanding Table Relationships vs. Merged Tables
    02:31
  • Creating Table Relationships in Power BI Desktop
    04:34
  • Preview03:09
  • Managing & Editing Table Relationships in Power BI Desktop
    02:44
  • Managing Active vs. Inactive Relationships
    02:45
  • Preview05:08
  • Connecting Multiple Data Tables in Power BI Desktop
    08:26
  • Understanding Filter Flow
    06:33
  • Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
    13:16
  • Hiding Fields from the Power BI Report View
    04:15
  • UPDATE: New Power BI Desktop "Model" View
    08:32
  • Power BI Data Model Best Practices
    01:34
  • QUIZ: Creating Table Relationships & Data Models in Power BI
    11 questions
  • HOMEWORK: Creating Table Relationships & Data Models in Power BI
    01:34
  • HOMEWORK SOLUTION: Creating Table Relationships & Data Models in Power BI
    14:09

  • Introduction
    00:32
  • Meet Data Analysis Expressions (DAX)
    01:03
  • Intro to DAX Calculated Columns
    07:33
  • Intro to DAX Measures
    02:51
  • RECAP: Calculated Columns vs. DAX Measures
    Preview01:34
  • Adding Columns & DAX Measures in Power BI Desktop
    03:12
  • Implicit vs. Explicit DAX Measures
    06:27
  • Filter Context Examples in Power BI
    08:07
  • Preview02:39
  • Understanding DAX Syntax & Operators
    03:49
  • Common DAX Function Categories
    03:16
  • DAX Demo: Basic Date & Time Functions
    12:24
  • DAX Demo: Conditional & Logical Functions (IF/AND/OR)
    10:06
  • DAX Demo: Common Text Functions
    09:24
  • DAX Demo: Joining Data with RELATED
    08:54
  • DAX Demo: Basic Math & Stats Functions
    14:01
  • DAX Demo: COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
    07:46
  • IMPORTANT: Order Line Items
    06:21
  • Preview13:06
  • DAX Demo: CALCULATE & ALL
    09:25
  • DAX Demo: CALCULATE & FILTER
    09:37
  • DAX Demo: Iterator Functions (SUMX, RANKX)
    12:27
  • DAX Demo: Time Intelligence Formulas
    12:29
  • DAX Best Practices in Power BI Desktop
    02:57
  • QUIZ: Analyzing Data with DAX Calculations in Power BI
    15 questions
  • HOMEWORK: Analyzing Data with DAX Calculations in Power BI
    01:57
  • HOMEWORK SOLUTION: Analyzing Data with DAX Calculations in Power BI
    15:05

  • Introduction
    00:29
  • Exploring the "Report" View in Power BI Desktop
    05:33
  • Adding Simple Objects to the Power BI Report Canvas
    03:07
  • Inserting Basic Charts & Visuals in Power BI
    05:47
  • UPDATE: Conditional Formatting
    02:58
  • Power BI Report Formatting Options
    09:51
  • Power BI Report Filtering Options
    11:09
  • Power BI Demo: Exploring Data with Matrix Visuals
    06:38
  • Power BI Demo: Filtering with Date Slicers
    07:14
  • Preview09:24
  • Power BI Demo: Inserting Text Cards
    06:14
  • Power BI Demo: Visualizing Geospatial Data with Maps
    07:15
  • Power BI Demo: Visualizing Data with Treemaps
    03:21
  • Power BI Demo: Showing Trends with Line & Area Charts
    06:23
  • Power BI Demo: Adding Trend Lines & Forecasts
    05:36
  • Power BI Demo: Goal Pacing with Gauge Charts
    Preview06:43
  • Editing Power BI Report Interactions
    06:38
  • Power BI Demo: Adding Drillthrough Filters
    05:08
  • Preview05:49
  • PRO TIP: Testing Scenarios with "What-If" Parameters
    11:47
  • Managing & Viewing Roles in Power BI Desktop
    05:27
  • PREVIEW: Custom Power BI Visuals (Log-in Required)
    02:05
  • PREVIEW: Designing for Phone vs. Desktop Report Viewers
    02:54
  • PREVIEW: Publishing to Power BI Service
    02:27
  • Power BI Data Visualization Best Practices
    01:35
  • QUIZ: Visualizing Data with Power BI Reports
    10 questions
  • HOMEWORK: Visualizing Data with Power BI Reports
    02:47
  • HOMEWORK SOLUTION: Visualizing Data with Power BI Reports
    07:22

  • Power BI Demo: Q&A Visual
    10:54
  • Power BI Demo: Key Influencers Visual (Part 1)
    12:34
  • Power BI Demo: Key Influencers Visual (Part 2)
    05:11
  • IMPORTANT: Correlation vs. Causation
    04:24
  • Power BI Demo: Decomposition Tree Visual
    08:59

  • Introduction
    00:44
  • PART 1: Connecting & Shaping the Data
    02:31
  • PART 2: Creating the Data Model
    00:52
  • PART 3: Adding DAX Measures
    02:47
  • PART 4: Building the Report
    01:57

  • REFERENCE: Monthly Power BI Updates
    00:22
  • BONUS LECTURE: More from Maven Analytics
    00:55

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 145,249 Reviews
  • 443,768 Students
  • 20 Courses

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.

Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.

Chris Dutton
Founder, Maven Analytics
Chris Dutton
  • 4.6 Instructor Rating
  • 133,804 Reviews
  • 443,768 Students
  • 6 Courses

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor.

As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world.

A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Aaron Parry
Professional Business Intelligence Trainer & Consultant
Aaron Parry
  • 4.6 Instructor Rating
  • 35,134 Reviews
  • 443,768 Students
  • 3 Courses

Aaron is a professional analytics consultant and Power BI expert, with 10+ years working in business intelligence and marketing analytics.

He's an instructor, coach and mentor for aspiring analysts, and has deep experience helping companies develop and implement full-stack BI solutions.

Aaron is the Head of Student Success at Maven Analytics, a leader in analytics education, whose mission is to empower everyday people to change the world with data.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.