UDEMY
UDEMY Logo

Microsoft Excel: Business Intelligence w/ Power Query & DAX 

  • Offered byUDEMY

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 
Overview

Learn advanced Excel for data analysis & business intelligence

Duration

7 hours

Total fee

455

Mode of learning

Online

Credential

Certificate

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 
Highlights

  • Earn a Certificate of completion from Udemy
  • Get a 30 days money back guarantee on the course
  • Get full lifetime access of the course material
  • Learn from 5 downloadable resource and 13 articles
Read more
Details Icon

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 
Course details

Who should do this course?
  • For Excel users who want to learn advanced data modeling & business intelligence tools
  • For Students looking for a comprehensive, engaging, and highly interactive approach to Excel training
  • For Anyone looking to become an Excel POWER USER and supercharge their analytics skillset
  • For Students looking to pursue a career in data analysis or business intelligence
What are the course deliverables?
  • Learn how to use Power Query, Power Pivot & DAX to absolutely revolutionize your workflow in Excel
  • Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Build pro-quality business intelligence solutions to blend and analyze data from multiple sources
More about this course
  • This course introduces Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX)
  • Introduce the "Power Excel" landscape, and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence
  • Practice shaping, blending and exploring our project files in Excel's query editor, and create completely automated loading procedures inside of Excel with only a few clicks
  • Dive into Data Modeling 101, and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies and more)

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 
Curriculum

Getting started

Course structure and outline

IMPORTANT: Versions & Compatibility

Introducing the Course Project

Setting Expectations

Intro to Power Excel

Understanding the 'Power Excel-Workflow

Power Query + Power Pivot: "Best Thing to Happen to Excel in 20 Years"

When to use Power Query & Power Pivot

Connecting & Transforming Data with Power Query in Excel

Introduction

Getting to Know Power Query in Excel

Exploring Excel's Power Query Editor

Power Query Data Loading Options

IMPORTANT: Updating Locale Settings

Applying Basic Table Transformations with Power Query

Power Query Demo: Text Tools

Power Query Demo: Number & Value Tools

Power Query Demo: Date & Time Tools

PRO TIP: Creating a Rolling Calendar with Power Query

Power Query Demo: Generating Index & Conditional Columns

Power Query Demo: Grouping & Aggregating Records

Power Query Demo: Pivoting & Unpivoting Data

Modifying Excel Workbook Queries

Merging Queries with Power Query

Appending Queries with Power Query

Power Query Demo: Connecting to a Folder of Files

Excel Power Query Best Practices

Building Table Relationships with Excel's Data Model

Introduction

Meet Excel's "Data Model"

The Data Model Data vs. Diagram View

Principles of Database Normalization

Understanding Data Tables vs. Lookup Tables

Benefits of Relationships vs. Merged Tables

Creating Table Relationships in Excel's Data Model

Modifying Data Model Table Relationships

Managing Active vs. Inactive Table Relationships

Understanding Relationship Cardinality

Connecting Multiple Data Tables in the Data Model

Understanding Filter Flow

Hiding Fields from Excel Client Tools

Defining Hierarchies in a Data Model

Excel Data Model Best Practices

Analyzing Data with Power Pivot & DAX

Introduction

Creating a "Power" Pivot Table

Power Pivots vs. 'Normal-Pivots in Excel

Introducing Data Analysis Expressions (DAX)

Understanding DAX Calculated Columns

Understanding DAX Measures

Creating Implicit DAX Measures

Creating Explicit DAX Measures with AutoSum

Creating Explicit DAX Measures with Power Pivot

Understanding DAX Filter Context

Step-by-Step DAX Measure Calculation

RECAP: Calculated Columns vs. DAX Measures

Excel Power Pivot & DAX Best Practices

Common DAX Formulas & Functions

Introduction

Understanding DAX Formula Syntax & Operators

Common DAX Function Categories

DAX Demo: Basic Math & Stats Functions

DAX Demo: COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS

DAX Demo: Logical Functions (IF/AND/OR)

DAX Demo: SWITCH & SWITCH(TRUE)

DAX Demo: Common Text Functions

DAX Demo: CALCULATE

DAX Demo: Adding Filter Context with FILTER (Part 1)

DAX Demo: Adding Filter Context with FILTER (Part 2)

DAX Demo: Removing Filter Context with ALL

DAX Demo: Joining Data with RELATED

DAX Demo: Iterating with SUMX

DAX Demo: Iterating with RANKX

DAX Demo: Basic Date & Time Functions

DAX Demo: Time Intelligence Formulas

DAX Speed & Performance Considerations

DAX Best Practices

Wrapping Up

Introduction

Data Visualization Options in Excel

Sneak Peek: Microsoft Power BI

Faculty Icon

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 
Faculty details

Chris Dutton, Founder, Maven Analytics
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.

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by UDEMY

549
50 hours
– / –
3 K
10 hours
– / –
549
4 hours
– / –
599
10 hours
– / –
View Other 2346 CoursesRight Arrow Icon

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 
Students Ratings & Reviews

4.5/5
Verified Icon6 Ratings
B
Bhumika shaw
Microsoft Excel: Business Intelligence w/ Power Query & DAX
Offered by UDEMY
3
Learning Experience: I had the best learning in Excel access and it make my work easy in just few minutes and even there is some coding in this which makes it more exciting.
Faculty: very nice and our teachers is very good to us
Course Support: I have a good computer knowledge now and I'm having a good interest in computer after this course .
Reviewed on 16 Mar 2023Read More
Thumbs Up IconThumbs Down Icon
H
Himanshi Jaiswal
Microsoft Excel: Business Intelligence w/ Power Query & DAX
Offered by UDEMY
5
Learning Experience: All about DAX and power pivot
Faculty: Instructors taught well Curriculum was relevant and comprehensive
Course Support: Career support was helpful
Reviewed on 15 May 2022Read More
Thumbs Up IconThumbs Down Icon
D
Dinesh C B
Microsoft Excel: Business Intelligence w/ Power Query & DAX
Offered by UDEMY
5
Learning Experience: Learning experience was good
Faculty: Instructors taught well Curriculum was relevant and comprehensive
Course Support: Career support was helpful
Reviewed on 27 Feb 2022Read More
Thumbs Up IconThumbs Down Icon
A
Akhil Panwar
Microsoft Excel: Business Intelligence w/ Power Query & DAX
Offered by UDEMY
5
Learning Experience: I learned the Excel BI tools Like power query, Power Pivot and DAX which is very important for business intelligence
Faculty: It was a self pace online course on udemy yes, it was comprehensive
Course Support: No career support provided
Reviewed on 31 Dec 2021Read More
Thumbs Up IconThumbs Down Icon
View All 4 ReviewsRight Arrow Icon
qna

Microsoft Excel: Business Intelligence w/ Power Query & DAX
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...