Microsoft Excel: Business Intelligence w/ Power Query & DAX
- Offered byUDEMY
Microsoft Excel: Business Intelligence w/ Power Query & DAX at UDEMY Overview
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
Microsoft Excel: Business Intelligence w/ Power Query & DAX at UDEMY Course details
- 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
- 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
- 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