Microsoft Power BI Desktop for Business Intelligence

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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

Expected Outcomes

  1. 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 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 Show more Show less Featured review Dănuț Oprișan 29 courses 2 reviews Rating: 5.0 out of 5 2 years 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. Show more Show less Course content 9 sections • 117 lectures • 11h 5m total length Expand all sections Getting Started 5 lectures • 9min Course Structure & Outline Preview 01:43 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:25 Introducing the Course Project Preview 03:02 Setting Expectations 02:21 Introducing Microsoft Power BI Desktop 7 lectures • 23min Introduction 00:26 Meet Microsoft Power BI Desktop Preview 05:30 Downloading Power BI & Adjusting Settings 04:05 IMPORTANT: Regional Settings 01:50 Exploring the Power BI Desktop Interface & Workflow Preview 02:34 Helpful Power BI Resources 01:44 UPDATE: New Power BI Ribbon 07:15 QUIZ: Introducing Microsoft Power BI Desktop 7 questions Connecting & Shaping Data with Power BI Desktop 22 lectures • 2hr 25min 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 Preview 14: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 Power BI Demo: Pivoting & Unpivoting Data Preview 08:04 Merging Queries in Power BI Desktop 06:41 Appending Queries in Power BI Desktop 06:29 PRO TIP: Appending Files from a Folder Preview 07: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 Creating Table Relationships & Data Models in Power BI 18 lectures • 1hr 36min 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 "Snowflake" Schemas in Power BI Preview 03:09 Managing & Editing Table Relationships in Power BI Desktop 02:44 Managing Active vs. Inactive Relationships 02:45 Understanding Relationship Cardinality Preview 05: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 Analyzing Data with DAX Calculations in Power BI 26 lectures • 3hr 7min 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 Preview 01: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 Step-by-Step DAX Measure Calculation Preview 02: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 DAX Demo: CALCULATE Preview 13: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 Visualizing Data with Power BI Reports 27 lectures • 2hr 32min 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 Power BI Demo: Showing Key Metrics with Cards & KPI Visuals Preview 09: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 Preview 06:43 Editing Power BI Report Interactions 06:38 Power BI Demo: Adding Drillthrough Filters 05:08 Using Power BI Report Bookmarks Preview 05: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 NEW: Artificial Intelligence (AI) Visuals 5 lectures • 42min 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 Bonus Project: Maven Market 5 lectures • 9min 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 Wrapping Up 2 lectures • 1min REFERENCE: Monthly Power BI Updates 00:22 BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 177,974 Reviews 529,310 Students 23 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. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 160,807 Reviews 529,310 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. Show more Show less Aaron Parry Professional Business Intelligence Trainer & Consultant 4.6 Instructor Rating 46,765 Reviews 529,310 Students 4 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6772e46b7a51ce53',m:'c1a5c7de7a5611f2e1f44f163cd10d332ccfe523-1627693253-1800-AbGuHNnYnvJu8yRjC426VK6D/guEhnSuNiwzvZxRDCkCxFAF4mLmAiNt/2JcXC7KaqlU9VoZmVIJ/2DOOjeNfTluAPFprsxnI2uQwbT3a2ACPSBT7U8n8rkj1Yq36UiirJT0AEEOk3/m4i8co2F9/n2f0Y2uFdOKmIfF3ms/pMSmufCgl3JBvvV1H98xbGf+Sw==',s:[0x92cadb5a08,0xf2634d3740],}})();
  2. 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 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 Show more Show less Featured review Dănuț Oprișan 29 courses 2 reviews Rating: 5.0 out of 5 2 years 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. Show more Show less Course content 9 sections • 117 lectures • 11h 5m total length Expand all sections Getting Started 5 lectures • 9min Course Structure & Outline Preview 01:43 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:25 Introducing the Course Project Preview 03:02 Setting Expectations 02:21 Introducing Microsoft Power BI Desktop 7 lectures • 23min Introduction 00:26 Meet Microsoft Power BI Desktop Preview 05:30 Downloading Power BI & Adjusting Settings 04:05 IMPORTANT: Regional Settings 01:50 Exploring the Power BI Desktop Interface & Workflow Preview 02:34 Helpful Power BI Resources 01:44 UPDATE: New Power BI Ribbon 07:15 QUIZ: Introducing Microsoft Power BI Desktop 7 questions Connecting & Shaping Data with Power BI Desktop 22 lectures • 2hr 25min 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 Preview 14: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 Power BI Demo: Pivoting & Unpivoting Data Preview 08:04 Merging Queries in Power BI Desktop 06:41 Appending Queries in Power BI Desktop 06:29 PRO TIP: Appending Files from a Folder Preview 07: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 Creating Table Relationships & Data Models in Power BI 18 lectures • 1hr 36min 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 "Snowflake" Schemas in Power BI Preview 03:09 Managing & Editing Table Relationships in Power BI Desktop 02:44 Managing Active vs. Inactive Relationships 02:45 Understanding Relationship Cardinality Preview 05: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 Analyzing Data with DAX Calculations in Power BI 26 lectures • 3hr 7min 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 Preview 01: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 Step-by-Step DAX Measure Calculation Preview 02: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 DAX Demo: CALCULATE Preview 13: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 Visualizing Data with Power BI Reports 27 lectures • 2hr 32min 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 Power BI Demo: Showing Key Metrics with Cards & KPI Visuals Preview 09: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 Preview 06:43 Editing Power BI Report Interactions 06:38 Power BI Demo: Adding Drillthrough Filters 05:08 Using Power BI Report Bookmarks Preview 05: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 NEW: Artificial Intelligence (AI) Visuals 5 lectures • 42min 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 Bonus Project: Maven Market 5 lectures • 9min 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 Wrapping Up 2 lectures • 1min REFERENCE: Monthly Power BI Updates 00:22 BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 177,974 Reviews 529,310 Students 23 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. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 160,807 Reviews 529,310 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. Show more Show less Aaron Parry Professional Business Intelligence Trainer & Consultant 4.6 Instructor Rating 46,765 Reviews 529,310 Students 4 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6772e46b7a51ce53',m:'c1a5c7de7a5611f2e1f44f163cd10d332ccfe523-1627693253-1800-AbGuHNnYnvJu8yRjC426VK6D/guEhnSuNiwzvZxRDCkCxFAF4mLmAiNt/2JcXC7KaqlU9VoZmVIJ/2DOOjeNfTluAPFprsxnI2uQwbT3a2ACPSBT7U8n8rkj1Yq36UiirJT0AEEOk3/m4i8co2F9/n2f0Y2uFdOKmIfF3ms/pMSmufCgl3JBvvV1H98xbGf+Sw==',s:[0x92cadb5a08,0xf2634d3740],}})();
  3. 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 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 Show more Show less Featured review Dănuț Oprișan 29 courses 2 reviews Rating: 5.0 out of 5 2 years 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. Show more Show less Course content 9 sections • 117 lectures • 11h 5m total length Expand all sections Getting Started 5 lectures • 9min Course Structure & Outline Preview 01:43 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:25 Introducing the Course Project Preview 03:02 Setting Expectations 02:21 Introducing Microsoft Power BI Desktop 7 lectures • 23min Introduction 00:26 Meet Microsoft Power BI Desktop Preview 05:30 Downloading Power BI & Adjusting Settings 04:05 IMPORTANT: Regional Settings 01:50 Exploring the Power BI Desktop Interface & Workflow Preview 02:34 Helpful Power BI Resources 01:44 UPDATE: New Power BI Ribbon 07:15 QUIZ: Introducing Microsoft Power BI Desktop 7 questions Connecting & Shaping Data with Power BI Desktop 22 lectures • 2hr 25min 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 Preview 14: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 Power BI Demo: Pivoting & Unpivoting Data Preview 08:04 Merging Queries in Power BI Desktop 06:41 Appending Queries in Power BI Desktop 06:29 PRO TIP: Appending Files from a Folder Preview 07: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 Creating Table Relationships & Data Models in Power BI 18 lectures • 1hr 36min 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 "Snowflake" Schemas in Power BI Preview 03:09 Managing & Editing Table Relationships in Power BI Desktop 02:44 Managing Active vs. Inactive Relationships 02:45 Understanding Relationship Cardinality Preview 05: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 Analyzing Data with DAX Calculations in Power BI 26 lectures • 3hr 7min 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 Preview 01: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 Step-by-Step DAX Measure Calculation Preview 02: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 DAX Demo: CALCULATE Preview 13: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 Visualizing Data with Power BI Reports 27 lectures • 2hr 32min 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 Power BI Demo: Showing Key Metrics with Cards & KPI Visuals Preview 09: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 Preview 06:43 Editing Power BI Report Interactions 06:38 Power BI Demo: Adding Drillthrough Filters 05:08 Using Power BI Report Bookmarks Preview 05: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 NEW: Artificial Intelligence (AI) Visuals 5 lectures • 42min 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 Bonus Project: Maven Market 5 lectures • 9min 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 Wrapping Up 2 lectures • 1min REFERENCE: Monthly Power BI Updates 00:22 BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 177,974 Reviews 529,310 Students 23 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. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 160,807 Reviews 529,310 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. Show more Show less Aaron Parry Professional Business Intelligence Trainer & Consultant 4.6 Instructor Rating 46,765 Reviews 529,310 Students 4 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6772e46b7a51ce53',m:'c1a5c7de7a5611f2e1f44f163cd10d332ccfe523-1627693253-1800-AbGuHNnYnvJu8yRjC426VK6D/guEhnSuNiwzvZxRDCkCxFAF4mLmAiNt/2JcXC7KaqlU9VoZmVIJ/2DOOjeNfTluAPFprsxnI2uQwbT3a2ACPSBT7U8n8rkj1Yq36UiirJT0AEEOk3/m4i8co2F9/n2f0Y2uFdOKmIfF3ms/pMSmufCgl3JBvvV1H98xbGf+Sw==',s:[0x92cadb5a08,0xf2634d3740],}})();
  4. 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 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 Show more Show less Featured review Dănuț Oprișan 29 courses 2 reviews Rating: 5.0 out of 5 2 years 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. Show more Show less Course content 9 sections • 117 lectures • 11h 5m total length Expand all sections Getting Started 5 lectures • 9min Course Structure & Outline Preview 01:43 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resources 00:25 Introducing the Course Project Preview 03:02 Setting Expectations 02:21 Introducing Microsoft Power BI Desktop 7 lectures • 23min Introduction 00:26 Meet Microsoft Power BI Desktop Preview 05:30 Downloading Power BI & Adjusting Settings 04:05 IMPORTANT: Regional Settings 01:50 Exploring the Power BI Desktop Interface & Workflow Preview 02:34 Helpful Power BI Resources 01:44 UPDATE: New Power BI Ribbon 07:15 QUIZ: Introducing Microsoft Power BI Desktop 7 questions Connecting & Shaping Data with Power BI Desktop 22 lectures • 2hr 25min 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 Preview 14: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 Power BI Demo: Pivoting & Unpivoting Data Preview 08:04 Merging Queries in Power BI Desktop 06:41 Appending Queries in Power BI Desktop 06:29 PRO TIP: Appending Files from a Folder Preview 07: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 Creating Table Relationships & Data Models in Power BI 18 lectures • 1hr 36min 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 "Snowflake" Schemas in Power BI Preview 03:09 Managing & Editing Table Relationships in Power BI Desktop 02:44 Managing Active vs. Inactive Relationships 02:45 Understanding Relationship Cardinality Preview 05: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 Analyzing Data with DAX Calculations in Power BI 26 lectures • 3hr 7min 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 Preview 01: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 Step-by-Step DAX Measure Calculation Preview 02: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 DAX Demo: CALCULATE Preview 13: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 Visualizing Data with Power BI Reports 27 lectures • 2hr 32min 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 Power BI Demo: Showing Key Metrics with Cards & KPI Visuals Preview 09: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 Preview 06:43 Editing Power BI Report Interactions 06:38 Power BI Demo: Adding Drillthrough Filters 05:08 Using Power BI Report Bookmarks Preview 05: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 NEW: Artificial Intelligence (AI) Visuals 5 lectures • 42min 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 Bonus Project: Maven Market 5 lectures • 9min 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 Wrapping Up 2 lectures • 1min REFERENCE: Monthly Power BI Updates 00:22 BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 177,974 Reviews 529,310 Students 23 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. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 160,807 Reviews 529,310 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. Show more Show less Aaron Parry Professional Business Intelligence Trainer & Consultant 4.6 Instructor Rating 46,765 Reviews 529,310 Students 4 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. Show more Show less Udemy Business Teach on Ud