Microsoft Excel: Business Intelligence w/ Power Query & DAX

Learn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)

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

Requirements
Microsoft Office 365 for PC/Windows or Mac, or a version of Excel compatible with Power Query & Power Pivot (2016+)
Experience with Excel PivotTables and formulas & functions is strongly recommended

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!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.*** This course includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee! ***

Overview
Section 1: Getting Started

Lecture 1 Course Structure & Outline

Lecture 2 IMPORTANT: Versions & Compatibility

Lecture 3 READ ME: Important Notes for New Students

Lecture 4 Introducing the Course Project

Lecture 5 DOWNLOAD: Course Resources

Lecture 6 Setting Expectations

Section 2: Intro to “Power Excel"

Lecture 7 Understanding the “Power Excel” Workflow

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

Lecture 9 When to use Power Query & Power Pivot

Lecture 10 HOMEWORK: Intro to "Power Excel"

Section 3: Connecting & Transforming Data with Power Query in Excel

Lecture 11 Introduction

Lecture 12 Getting to Know Power Query in Excel

Lecture 13 Exploring Excel's Power Query Editor

Lecture 14 Power Query Data Loading Options

Lecture 15 IMPORTANT: Updating Locale Settings

Lecture 16 Applying Basic Table Transformations with Power Query

Lecture 17 Power Query Demo: Text Tools

Lecture 18 Power Query Demo: Number & Value Tools

Lecture 19 Power Query Demo: Date & Time Tools

Lecture 20 PRO TIP: Creating a Rolling Calendar with Power Query

Lecture 21 Power Query Demo: Generating Index & Conditional Columns

Lecture 22 Power Query Demo: Grouping & Aggregating Records

Lecture 23 Power Query Demo: Pivoting & Unpivoting Data

Lecture 24 Modifying Excel Workbook Queries

Lecture 25 Merging Queries with Power Query

Lecture 26 Appending Queries with Power Query

Lecture 27 Power Query Demo: Connecting to a Folder of Files

Lecture 28 PRO TIP: Additional Data Connectors (Excel, MySQL, PDF, Web)

Lecture 29 Excel Power Query Best Practices

Lecture 30 HOMEWORK: Connecting & Transforming Data with Power Query in Excel

Section 4: Building Table Relationships with Excel's Data Model

Lecture 31 Introduction

Lecture 32 Meet Excel's "Data Model"

Lecture 33 The Data Model Data vs. Diagram View

Lecture 34 Principles of Database Normalization

Lecture 35 Understanding Data Tables vs. Lookup Tables

Lecture 36 Benefits of Relationships vs. Merged Tables

Lecture 37 Creating Table Relationships in Excel's Data Model

Lecture 38 Modifying Data Model Table Relationships

Lecture 39 Managing Active vs. Inactive Table Relationships

Lecture 40 Understanding Relationship Cardinality

Lecture 41 Connecting Multiple Data Tables in the Data Model

Lecture 42 Understanding Filter Flow

Lecture 43 Hiding Fields from Excel Client Tools

Lecture 44 Defining Hierarchies in a Data Model

Lecture 45 Excel Data Model Best Practices

Lecture 46 HOMEWORK: Building Table Relationships with Excel's Data Model

Section 5: Analyzing Data with Power Pivot & DAX

Lecture 47 Introduction

Lecture 48 Creating a "Power" Pivot Table

Lecture 49 Power Pivots vs. “Normal” Pivots in Excel

Lecture 50 Introducing Data Analysis Expressions (DAX)

Lecture 51 Understanding DAX Calculated Columns

Lecture 52 Understanding DAX Measures

Lecture 53 Creating Implicit DAX Measures

Lecture 54 Creating Explicit DAX Measures with AutoSum

Lecture 55 Creating Explicit DAX Measures with Power Pivot

Lecture 56 Understanding DAX Filter Context

Lecture 57 Step-by-Step DAX Measure Calculation

Lecture 58 RECAP: Calculated Columns vs. DAX Measures

Lecture 59 Excel Power Pivot & DAX Best Practices

Lecture 60 HOMEWORK: Analyzing Data with Power Pivot & DAX

Section 6: Common DAX Formulas & Functions

Lecture 61 Introduction

Lecture 62 Understanding DAX Formula Syntax & Operators

Lecture 63 Common DAX Function Categories

Lecture 64 DAX Demo: Basic Math & Stats Functions

Lecture 65 DAX Demo: COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS

Lecture 66 HOMEWORK: Math & Stats Functions

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

Lecture 68 DAX Demo: SWITCH & SWITCH(TRUE)

Lecture 69 DAX Demo: Common Text Functions

Lecture 70 HOMEWORK: Logical & Text Functions

Lecture 71 DAX Demo: CALCULATE

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

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

Lecture 74 DAX Demo: Removing Filter Context with ALL

Lecture 75 HOMEWORK: CALCULATE, FILTER & ALL

Lecture 76 DAX Demo: Joining Data with RELATED

Lecture 77 DAX Demo: Iterating with SUMX

Lecture 78 DAX Demo: Iterating with RANKX

Lecture 79 HOMEWORK: Iterator ("X") Functions

Lecture 80 DAX Demo: Basic Date & Time Functions

Lecture 81 DAX Demo: Time Intelligence Formulas

Lecture 82 HOMEWORK: Time Intelligence

Lecture 83 DAX Speed & Performance Considerations

Lecture 84 DAX Best Practices

Section 7: Wrapping Up

Lecture 85 Introduction

Lecture 86 Data Visualization Options in Excel

Lecture 87 Sneak Peek: Microsoft Power BI

Lecture 88 BONUS LESSON

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

without You and Your Support We Can’t Continue
Thanks for Buying Premium From My Links for Support
Click >>here & Visit My Blog Daily for More Udemy Tutorial. If You Need Update or Links Dead Don't Wait Just Pm Me or Leave Comment at This Post