IIRF Online > Business > Business Analytics & Intelligence > Data Analysis Expressions (DAX) > Excel Power Query, Power Pivot, DAX, Power BI & Power 3D Map
Excel Power Query, Power Pivot, DAX, Power BI & Power 3D Map by Udemy
Learn Excel Power Query, Power Pivot, DAX, Power BI Tools and 3D Maps. Build Excel Data Analyst Models with Excel 365
Course Highlights
- Learn in depth Power Query, PowerPivot, Power BI and Power Map tools
- Learn from the beginning – blank canvas – until a completed report & dashboard. We show you how to best use the core elements of Power BI to conduct meaningful
- Quickly turn mass quantities of data into meaningful information using Excel PowerPivot add-in
- Make amazing interactive sales maps using Excel Power View powerful add-in
- Create business intelligence reports and dashboards
- Analyze huge amounts of data fast and accurate
- Learn the most current version of Microsoft Excel (Excel 2019 & Office 365)
- Improve general Excel knowledge
- Follow along with included Excel project files
- Course updated regularly
- Learn from an instructor with over 16 years of experience, teaching thousands of students in his own computer learning school
- An instructor ready to answer your questions in less than 24 hours
- Watch high-quality video lectures with lifetime access
- Certificate of completion
Skills you will learn!
Curriculum
6 Topics
Introduction
Course Resources & Important Notes for New Students
Versions Compatibility and Install Power Pivot and Power Map
Power Pivot or Power Query?
HOMEWORK-1
Introduction
8 Topics
What is Power Query
(Optional) Install Power Query for Excel Versions prior to Excel 2016
An example of what is possible with Power Query
Loading Data from a CSV File to Power Query Editor
The Get & Transform Query Editor
Load data only as a connection
Conclusion
Get Started With Power Query (Get & Transform)
11 Topics
Data Set Shaping (Columns)
Data Set Shaping (Rows)
Filtering Data in Power Query
Data Cleansing Introduction
Changing Data Type
Replacing Values
Transforming Column Contents
Filling Down
Grouping Records
Conclusion
Transforming Data Sets & Data Cleansing
12 Topics
Introduction
Splitting Columns
Custom or Calculated Columns
Index Columns
(Advanced) Using Column from Examples
Overview of Joins in Power Query
Merging Data
Appending Data
Pivoting and Unpivoting Data
Handling Multiple Date Formats
Conclusion
Data Mashup with Power Query
6 Topics
Project 1 : Data Table Transformations
Project 2 : Grouping Aggregating and Inserting Calculated Columns
Project 3 : Transposing & Unpivoting a Data Set
Project 4 : Transform a Data Set using Split Column
Project 5 : Create A Macro Using Power Query
Recap of Power Query
4 Topics
Introduction
Part 1 - Split Column by Delimiter
Part 2 - Merging Lookup Tables
Part 3 - Fact and Lookup Tables
13 Topics
Introduction
How Power Query and Power Pivot work together
The Excel Data Model
Loading Data into Power Pivot - Introduction
The Power Pivot Interface
Designing a Data Model
Data View and Diagram View
Creating & Modifying Hierarchies
Key Performance Indicators
Perspectives
DEMO: Managing and Preparing Power Pivot Data for Analysis
HOMEWORK:2 - Loading Data into Power Pivot
Power Pivot - The Excel Data Model
11 Topics
Introduction to DAX Formula Language
DAX Syntax and Data Types
Concatenating Column Contents
Tweaking Text (LEFT & other Text Functions)
Simple Calculations
Calculating Across Tables
Counting Reference Elements
Simple Logic: The IF() Function (& ISBLANK Function)
Complex Logic (IF AND OR functions)
HOMEWORK:3 - Creating Calculated Columns into Power Pivot
DAX Calculated Columns
7 Topics
Introduction to DAX Measures
Calculating Measures
Cross-Table Measures
Filtering Data in Measures
Using DAX ALL() Function
PROJECT: Measures & Pivot Tables
DAX Measures
6 Topics
Simple Date Calculations
Creating a Date Table in Power Pivot
Adding Sort By Columns to the Date Table
Adding the Date Table to the Data Model
Applying Time Intelligence (YearToDate QuarterToDate MonthToDate)
Analyzing Data over Time with DAX
5 Topics
A Tour of Power BI
Microsoft Power BI Tools
Install Power BI Desktop
Launch Power BI Desktop
Introducing Power BI
5 Topics
Introduction
Getting Data from Excel file
Getting Data from csv file
Connect to a Web Data Source
Power BI Data Sources
7 Topics
Introduction
Getting your Data
Getting familiar with the Power BI Interface
Adding Stacked Column Chart & Pie Chart
Adding Interactions with Visuals
Line Charts & Drill Down
Matrix & Card Titles
8 Topics
Using the Power Query Editor
Reducing Rows & Extracting Data
Filtering setting data type and replacing values
Unpivoting columns
Transforming Columns
PROJECT: US Population Data Analysis with Power BI - PART 1
PROJECT: US Population Data Analysis with Power BI - PART 2
Power Query: Transforming & Shaping Data in Power BI
8 Topics
Combining Multiple Tables
Appending Data to a Single Query
Index Column & Cleaning Data
Model Relationships
Merging Data
PROJECT: Create a Sales Dashboard – Part:1
PROJECT: Create a Sales Dashboard – Part:2
Power Query: Combining & Merging Data in Power BI
10 Topics
The Report View
Format Visualizations
Cards Tables and Matrix
Conditional Formatting
Title Formatting
Using Slicers
Filter Reports and Pages
Q&A – Create Visuals by Typing a Normal Sentence
Publish from Power BI Desktop
Reports Visualizations Filters and Q&A
5 Topics
Data Model: Section Overview
The Basics of Data Modeling
Getting Data & Setting up the Data Model
Relationships
Data Model Tour
10 Topics
Create your first Measure using SUM Function
DAX syntax
Add a Matrix using Measures
Count Products with COUNTA and COUNTROWS
Edit or Delete Measures
Find Empty Fields with COUNTBLANK
DISTINCTCOUNT Function
PROJECT: Build DAX understanding (Part:1)
PROJECT: Build DAX understanding (Part:2)
DAX Functions with Power BI
10 Topics
Add a Calculated Column
Explicit vs. Implicit Measures
Summarization Methods
DIVIDE Function
SUMX Function
Date & Time DAX Functions
PROJECT: Build DAX understanding (Part:3)
PROJECT: Build DAX understanding (Part:4)
PROJECT: Build DAX understanding (Part:5)
PROJECT: Build DAX understanding (Part:6)
9 Topics
Power Map Basics
Power Map Format
Power Map Category
Power Map Scene
Power Map Annotation & Text Box
Power Map 2D Chart
Power Map Time Feature
Power Map Capture Screen & Video
Get Started wit Power Map (3D MAP)
5 Topics
Design your Dashboard with Link Buttons
Add Key Metrics and create our first PowerPivot Pivot Table
Create the Pivot Charts
Using Slicers and Timeline
Complete the Dashboard adding Different Pivot Charts
3 Topics
SPECIAL BONUS: Discover Exciting Offers!
Excel 2019 Tutorial for Beginners
Excel 2019 Useful Keyboard Shortcuts and Tips
Excel Power Query, Power Pivot, DAX, Power BI & Power 3D Map
Related Data Analysis Expressions (DAX) Courses
Thank You!
Your review has been submitted successfully.