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+ Microsoft AZ-900
Graphic Design Photoshop 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 CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business 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:10:29
30-Day Money-Back Guarantee
Office Productivity Microsoft Power Pivot

Microsoft Excel: Business Intelligence w/ Power Query & DAX

Learn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)
Bestseller
Rating: 4.7 out of 54.7 (13,020 ratings)
62,588 students
Created by Maven Analytics, Chris Dutton
Last updated 1/2021
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Get up & running with Excel's game changing data modeling & business intelligence tools
  • 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
  • Get LIFETIME access to project files, quizzes and homework exercises, and 1-on-1 expert support
  • Build pro-quality business intelligence solutions to blend and analyze data from multiple sources
Curated for the Udemy for Business collection

Requirements

  • IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
  • This course is designed for PC users (Power Pivot is currently NOT available for Mac)
  • Experience with Excel PivotTables and formulas & functions is strongly recommended

Description

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Power Query + Excel Power Pivot course:

"I am a self-taught Excel Power Query user and it took me a while to understand what each tool does and how it interacts with others. Thanks to your introduction I finally nailed it in a very clear, unambiguous way. You helped me build a method that I can confidently apply to my data in Excel. Thank you so much!"

-Francesca C.

"I'm less of an expert at breathing than Chris is at Excel. This course is thorough and well-planned, and he presents in a manner that simplifies the complicated. Well worth your time if you want to master Excel power query and power pivot!"

-Tim B.

"I'm geeking out, this is so cool. Where has this been all my life???"

-Karen P.

__________

COURSE DESCRIPTION:

This course introduces Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and absolutely supercharge your Excel analytics game, this course is the A-Z guide that you're looking for.

I'll 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. Together, we'll walk through the Excel BI workflow, and build an entire Excel data model from scratch:

  • First we'll get hands-on with Power Query; a tool to extract, transform, and load data into Excel from flat files, folders, databases, API services and more. We'll 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.

  • From there we'll dive into Data Modeling 101, and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies and more). We'll take a tour through the Excel data model interface, introduce some best practices and pro tips, and then create our own relational database to analyze throughout the course.

  • Finally, we'll use Power Pivot and DAX to explore and analyze our Excel data model. Unlike traditional Excel Pivot Tables, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables (inside of Excel!), and create supercharged calculated fields using a formula language called Data Analysis Expressions (or "DAX" for short). We'll cover basic DAX syntax, then introduce some of the most powerful and commonly-used functions -- CALCULATE, FILTER, SUMX and more.

If you're ready to take your Excel game to new heights and join the leading edge of analytics & business intelligence, this course is for you. It's time to stop fighting with tedious, manual tasks and struggling with "old-school" Excel; join me on this journey and emerge a certified excel analytics NINJA.

See you in there!

-Chris (Founder, Excel Maven & Maven Analytics)

__________

IMPORTANT: Power Query and Power Pivot are currently NOT available in Excel for Mac. You'll need a PC version of Excel that is compatible with Power Pivot (Excel 2010 with plug-in, Excel 2013, Excel 2016, or Excel 2019 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

__________

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!

*** This course includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee! ***

Who this course is for:

  • Excel users who want to learn advanced data modeling & business intelligence tools
  • Students looking for a comprehensive, engaging, and highly interactive approach to Excel training
  • Anyone looking to become an Excel POWER USER and supercharge their analytics skillset
  • Students looking to pursue a career in data analysis or business intelligence

Featured review

Avijit Das
Avijit Das
57 courses
9 reviews
Rating: 5.0 out of 55 months ago
Thank You Chris for creating such an awesome course! Never had so much fun while learning! Your unparalleled teaching methodologies has me kept engaged through out the course and the homework exercises has helped me to solidify my learning! Already enrolled to your Power BI course and hopeful of taking my learning to a whole new level. Thank You very much!

Course content

7 sections • 87 lectures • 7h 13m total length

  • Preview01:47
  • Preview03:15
  • READ ME: Important Notes for New Students
    01:54
  • Introducing the Course Project
    01:16
  • DOWNLOAD: Course Resources
    00:16
  • Setting Expectations
    01:54

  • Understanding the “Power Excel” Workflow
    03:50
  • Power Query + Power Pivot: "Best Thing to Happen to Excel in 20 Years"
    Preview08:18
  • When to use Power Query & Power Pivot
    00:44
  • QUIZ: Intro to "Power Excel"
    7 questions
  • HOMEWORK: Intro to "Power Excel"
    00:21

  • Introduction
    00:27
  • Getting to Know Power Query in Excel
    02:40
  • Preview03:17
  • Power Query Data Loading Options
    01:40
  • IMPORTANT: Updating Locale Settings
    00:46
  • Applying Basic Table Transformations with Power Query
    08:06
  • Power Query Demo: Text Tools
    10:17
  • Power Query Demo: Number & Value Tools
    07:41
  • Power Query Demo: Date & Time Tools
    07:39
  • PRO TIP: Creating a Rolling Calendar with Power Query
    05:02
  • Power Query Demo: Generating Index & Conditional Columns
    07:44
  • Power Query Demo: Grouping & Aggregating Records
    07:10
  • Power Query Demo: Pivoting & Unpivoting Data
    Preview08:52
  • Modifying Excel Workbook Queries
    04:18
  • Merging Queries with Power Query
    07:43
  • Appending Queries with Power Query
    05:49
  • Power Query Demo: Connecting to a Folder of Files
    09:32
  • Excel Power Query Best Practices
    02:44
  • QUIZ: Connecting & Transforming Data with Power Query in Excel
    10 questions
  • HOMEWORK: Connecting & Transforming Data with Power Query in Excel
    01:19

  • Introduction
    00:28
  • Meet Excel's "Data Model"
    03:38
  • The Data Model Data vs. Diagram View
    02:33
  • Principles of Database Normalization
    04:15
  • Understanding Data Tables vs. Lookup Tables
    05:40
  • Benefits of Relationships vs. Merged Tables
    02:07
  • Creating Table Relationships in Excel's Data Model
    06:55
  • Modifying Data Model Table Relationships
    02:06
  • Managing Active vs. Inactive Table Relationships
    03:55
  • Preview05:46
  • Connecting Multiple Data Tables in the Data Model
    05:59
  • Understanding Filter Flow
    05:08
  • Hiding Fields from Excel Client Tools
    04:59
  • Defining Hierarchies in a Data Model
    03:54
  • Excel Data Model Best Practices
    01:38
  • QUIZ: Building Table Relationships with Excel's Data Model
    10 questions
  • HOMEWORK: Building Table Relationships with Excel's Data Model
    00:39

  • Introduction
    00:29
  • Creating a "Power" Pivot Table
    05:27
  • Power Pivots vs. “Normal” Pivots in Excel
    Preview02:48
  • Introducing Data Analysis Expressions (DAX)
    01:12
  • Understanding DAX Calculated Columns
    08:39
  • Understanding DAX Measures
    02:24
  • Creating Implicit DAX Measures
    01:59
  • Creating Explicit DAX Measures with AutoSum
    07:08
  • Creating Explicit DAX Measures with Power Pivot
    07:42
  • Understanding DAX Filter Context
    09:18
  • Step-by-Step DAX Measure Calculation
    12:06
  • RECAP: Calculated Columns vs. DAX Measures
    02:29
  • Excel Power Pivot & DAX Best Practices
    01:50
  • QUIZ: Analyzing Data with Power Pivot & DAX
    10 questions
  • HOMEWORK: Analyzing Data with Power Pivot & DAX
    01:22

  • Introduction
    00:27
  • Understanding DAX Formula Syntax & Operators
    04:05
  • Common DAX Function Categories
    03:54
  • DAX Demo: Basic Math & Stats Functions
    12:45
  • DAX Demo: COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS
    10:35
  • HOMEWORK: Math & Stats Functions
    01:07
  • DAX Demo: Logical Functions (IF/AND/OR)
    16:49
  • DAX Demo: SWITCH & SWITCH(TRUE)
    10:33
  • DAX Demo: Common Text Functions
    10:53
  • HOMEWORK: Logical & Text Functions
    00:36
  • DAX Demo: CALCULATE
    14:39
  • DAX Demo: Adding Filter Context with FILTER (Part 1)
    09:20
  • DAX Demo: Adding Filter Context with FILTER (Part 2)
    14:23
  • DAX Demo: Removing Filter Context with ALL
    09:06
  • HOMEWORK: CALCULATE, FILTER & ALL
    01:19
  • DAX Demo: Joining Data with RELATED
    03:39
  • DAX Demo: Iterating with SUMX
    12:20
  • DAX Demo: Iterating with RANKX
    05:33
  • HOMEWORK: Iterator ("X") Functions
    00:48
  • DAX Demo: Basic Date & Time Functions
    04:58
  • DAX Demo: Time Intelligence Formulas
    Preview17:02
  • HOMEWORK: Time Intelligence
    00:29
  • DAX Speed & Performance Considerations
    03:02
  • DAX Best Practices
    02:03
  • QUIZ: Common DAX Formulas & Functions
    12 questions

  • Introduction
    00:53
  • Data Visualization Options in Excel
    04:35
  • Preview05:55
  • BONUS LECTURE: More from Maven Analytics
    00:55

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 154,734 Reviews
  • 466,827 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
  • 141,815 Reviews
  • 466,827 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.

  • Udemy for 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
  • Featured courses
Udemy
© 2021 Udemy, Inc.