Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
How to build Interactive Excel Dashboards that Update with ONE CLICK! Creative and outstanding design Excel Dashboard
This course will take you beyond your expectations, I have put together all you need to master data analytics and dashboard creation. We use real-life datasets that are companies and industry standards.
You will learn from my years of experience as an analyst, data analytics freelancer, and as well learn how to monetize your data analytics skills and make money from them.
We have more projects in this course than you can ever find from other instructors (courses) on this platform. We illustrated all projects using a real-life dataset that applied to day-to-day business activities.
All the dashboards taught in these classes are not only dynamic and interactive but all so have outstanding designs.
By participating in this Microsoft Excel Dashboard course you'll gain the widely sought-after skills necessary to analyze enormous datasets.
You will learn Power Query for data cleaning and transformations, Power Pivot to handle huge datasets like millions of rows of data and have it analyzed in Excel.
You learn how to manipulate data with DAX language in Power Pivot and as well create easy relationships between multiple tables instead of using basic lookups that might slow your analytics down.
Join us today to create your own stories and help businesses make accurate decisions.
Course Content
- 17 section(s)
- 168 lecture(s)
- Section 1 Watch me first
- Section 2 Kitchen Equipment Revenue Analysis DASHBOARD
- Section 3 Week 1 Personal Expenses Dashboard
- Section 4 Week 2 Dashboard for shipping status
- Section 5 Week 3 Sales Analysis Dashboard
- Section 6 Week 4 Profit Analysis Dashboard
- Section 7 Week 5 Cancer Mortality Dashboard
- Section 8 Week 6 Hr Dashboard
- Section 9 Week 7 Migration insight Dashboard
- Section 10 Week 8 Order Analysis Dashboard
- Section 11 Week 9 Online store sales Dashboard
- Section 12 Week 10 mobile phone Dashboard
- Section 13 All you need to master analytics
- Section 14 How to Monetize your Analytics and Dashboard Skills
- Section 15 All you need to Master Excel Data Analytics
- Section 16 Bonus Dashboards
- Section 17 What is next
What You’ll Learn
- Learn how to analyze and design a well presentable dashboard for organizations and businesses
- You will learn how to Monetize your Excel Dashboard skill and make money working as a freelancer or an In-House Data analyst
- You will learn how to use Excel formulas and Pivot Table successfully
- You will learn Excel Power Query for data cleaning and transformation
- You will learn how to design modern dashboards
- You will learn how to use Power Pivot to manage huge rows of data without breaking down
- You will learn how to use DAX measures to speed up analysis and create dashboards
- How to create your portfolio (Online presence)
- How to receive payment from clients
- How to approach clients project
- Will learn how to pitch for jobs
Skills covered in this course
Reviews
-
OOlushola Sunday
Thank you for this amazing course and the teaching methodology. I love its simplicity.
-
LLaurens Suarez
It is clear and straightforward.
-
AAhmed Mamdouh
perfect
-
RRichard Stiehm
Nice simple clean approach