Currently Empty: £0.00
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.
Advanced Power Query In Excel for Data Cleaning and Transformation
How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports
-
7Project Overview
-
8How to Activate Microsoft Excel Power Pivot
-
9Importing data into Power Query
-
10Power Query Transform vs Add Columns explained
-
11Importing Multiple tables into Power Query
-
12Updating your current Workbook Settings to get proper Dates and Time
-
13Checking errors and remove columns and rows in Power Query
-
14How to add Index number in Power Query
-
15Merging Queries in Power Query
-
16Basic way to Append Queries
-
17Best way to Append Queries using Folder with Auto Update
-
18Creating a Custom Calendar Table in Power Query
-
19Better way to Create a Date Table in Power Query (Auto Update)
-
20How to Move data into Power Pivot from Worksheet
-
21Important Data Source Settings in Power Query
-
22Data view vs Diagram view
-
23Understand Database Normalization
-
24Creating Relationships in Power Pivot
-
25How to Edit Relationships in Power Pivot
-
26Power Pivot view vs Normal Excel Pivot Table
-
27Power Query and Data Modelling conclusion
DAX Pack (common DAX functions)
-
28Introduction to DAX in Excel Power Pivot
-
29How to add DAX Calculated Column
-
30Calculated Column with Dax If function
-
31Calculated Column with Dax Switch function
-
32Total Revenue with Calculated Column
-
33Introduction to DAX Measures in Power Pivot
-
34How to write DAX using the Measure BOX
-
35Implicit vs Explicit Measures
Advanced Customer Dashboard in Excel using DAX and Excel Functions
-
36How to create a Separate Measures Table
-
37How to calculate COGS and Gross profit
-
38Calculating returned Rate using DAX
-
39How to use DAX All Function
-
40How to use the DAX Filter Function
-
41Filtering Table with DAX Function
-
42How to mark your Date Table
-
43Time Intelligence YTD MTD and QTD DAX Function
-
44Last month Revenue and MoM percentage Change
-
45How to calculate 10-Days Rolling total
-
46How to calculate 10 Days Transactional Average
-
47Better to Count using DAX
Adidas Sales Dashboard
-
48Dashboard overview
-
49Setting Dashboard Canvas
-
50How to add M-Code, Last Update date code
-
51Adding values to cards
-
52Adding Icons
-
53Adding new cards with Gradient colors
-
54How to create a Dynamic Top N in Excel
-
55Creating a dynamic Title
-
56How to create multiple Doughnut chart
-
57Inserting a Bar charts
-
58How to create a Map chart
-
595 Less and Top Profitable Cities
-
60How to connect Slicers to PivotTables
Full Dynamic HR (Human Resources) Dashboard
-
61Dashboard Overview
-
62Transforming and Cleaning data with Power Query
-
63Inserting PivotTable and Advanced Number formatting
-
64Adding Month Filter
-
65Dynamic way to show previous Month revenue with Percentage Change
-
66Quantity Ordered and Transaction Cards
-
67Which Product contributed more to Revenue
-
68Which State should we push more Products to?
-
69What is the peak month for 2020 and 2021?
-
70What's our top Region & Sales Channel?
-
71Revenue trend by Weekday
-
72Connecting Slicers to PivotTables
-
73How to create a Single Button that clear all filters
-
74New way to save your work
-
75Formatting Slicers
-
76Cleaning up your dashboard
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
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!
Stars 5
58
Stars 4
31
Stars 3
7
Stars 2
5
Stars 1
1