4.32 out of 5
4.32
68 reviews on Udemy

Advanced Microsoft Interactive and Dynamic Excel Dashboard

2023 (Edition) Start an Advanced Excel Dashboard Today using Power Pivot, DAX, Power Query and Advanced Excel Functions
Instructor:
Ismaila Mumuni Omeiza
1,336 students enrolled
English [Auto]
Learn how to write DAX (Data analysis Expression) to create advanced dashboard in Excel
Learn how to use Power Pivot and Power Query in Excel for advanced data Analysis
Mix formula and function with Pivot Table to create interacive dashboard
How to use data to make business decisions
How to market your new dashboard skill
How to create Portfolio to showcase your dashboard to prospective Employers

If you are really new to Excel dashboards or data analytics in general or you want to advance your knowledge, this is the course for you. We have provided you with the fundamentals you need to work with Excel efficiently and effectively.

This dashboard is going to take you through Power Query, Power Pivot, Modeling, and DAX (Data Analysis Expression).

Learning this advanced Excel Dashboard will make you use Power BI with ease as it uses DAX for computation and Power Query for cleaning and data transformation.

Our aim in this course is to show you how to analyze data and create a visualization from the different tables without you using Xlookup, VLOOKUP or Index and Match but just with simple data Modeling in Power Pivot.

This course is 100% practical

Microsoft Excel is the most commonly used data analysis tool available on the market today. In this course, we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)

Say no to a boring dashboard. With this course, you will start creating a very powerful interactive and dynamic Excel dashboard from day one.

If you are ready to learn with me, let’s join the class and see how creative you could be in the few days to come as you begin the class.

Remember you have life Time access to this course.

This course will be updated frequently with the new dashboard.

be free to ask questions should you got stuck in any of the steps.

I am already waiting for you in the class, nice to have you.

Getting Started

1
Course Project Snippet
2
Why do we need to use Power Query & Power Pivot
3
Advanced Process to a Better Dashboard Creation
4
Course Materials
5
Picking the best Charts for your visualizations
6
Build free Portfolio to showcase your Dashboard skills to Employers

Advanced Power Query In Excel for Data Cleaning and Transformation

1
Project Overview
2
How to Activate Microsoft Excel Power Pivot
3
Importing data into Power Query
4
Power Query Transform vs Add Columns explained
5
Importing Multiple tables into Power Query
6
Updating your current Workbook Settings to get proper Dates and Time
7
Checking errors and remove columns and rows in Power Query
8
How to add Index number in Power Query
9
Merging Queries in Power Query
10
Basic way to Append Queries
11
Best way to Append Queries using Folder with Auto Update
12
Creating a Custom Calendar Table in Power Query
13
Better way to Create a Date Table in Power Query (Auto Update)
14
How to Move data into Power Pivot from Worksheet
15
Important Data Source Settings in Power Query
16
Data view vs Diagram view
17
Understand Database Normalization
18
Creating Relationships in Power Pivot
19
How to Edit Relationships in Power Pivot
20
Power Pivot view vs Normal Excel Pivot Table
21
Power Query and Data Modelling conclusion

How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports

1
Introduction to DAX in Excel Power Pivot
2
How to add DAX Calculated Column
3
Calculated Column with Dax If function
4
Calculated Column with Dax Switch function
5
Total Revenue with Calculated Column
6
Introduction to DAX Measures in Power Pivot
7
How to write DAX using the Measure BOX
8
Implicit vs Explicit Measures

DAX Pack (common DAX functions)

1
How to create a Separate Measures Table
2
How to calculate COGS and Gross profit
3
Calculating returned Rate using DAX
4
How to use DAX All Function
5
How to use the DAX Filter Function
6
Filtering Table with DAX Function
7
How to mark your Date Table
8
Time Intelligence YTD MTD and QTD DAX Function
9
Last month Revenue and MoM percentage Change
10
How to calculate 10-Days Rolling total
11
How to calculate 10 Days Transactional Average
12
Better to Count using DAX

Advanced Customer Dashboard in Excel using DAX and Excel Functions

1
Dashboard overview
2
Setting Dashboard Canvas
3
How to add M-Code, Last Update date code
4
Adding values to cards
5
Adding Icons
6
Adding new cards with Gradient colors
7
How to create a Dynamic Top N in Excel
8
Creating a dynamic Title
9
How to create multiple Doughnut chart
10
Inserting a Bar charts
11
How to create a Map chart
12
5 Less and Top Profitable Cities
13
How to connect Slicers to PivotTables

Adidas Sales Dashboard

1
Dashboard Overview
2
Transforming and Cleaning data with Power Query
3
Inserting PivotTable and Advanced Number formatting
4
Adding Month Filter
5
Dynamic way to show previous Month revenue with Percentage Change
6
Quantity Ordered and Transaction Cards
7
Which Product contributed more to Revenue
8
Which State should we push more Products to?
9
What is the peak month for 2020 and 2021?
10
What's our top Region & Sales Channel?
11
Revenue trend by Weekday
12
Connecting Slicers to PivotTables
13
How to create a Single Button that clear all filters
14
New way to save your work
15
Formatting Slicers
16
Cleaning up your dashboard

Full Dynamic HR (Human Resources) Dashboard

1
Dashboard Overview
2
Importing data into Excel Power Query
3
Removing unwanted columns in Power Query
4
Transforming Hr data in Excel Power Query
5
Cleaning the Dashboard area (Canvas)
6
Formatting your DataTable
7
06 Employees KPI
8
Adding shapes to the dashboard environment
9
How to download Gif animated images to Excel
10
Creating chart for attrition and current employees
11
Employees by performance Status
12
How to create an icon slicer in Excel
13
Attrition by distance from work with dynamic legend
14
Attrition by job role visual
15
Formatting legends
16
Job role average Attrition
17
Attrition by Education types
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
68 Ratings

Detailed Rating

Stars 5
36
Stars 4
24
Stars 3
5
Stars 2
2
Stars 1
1