logo
আরবি ভাষা শিক্ষক প্রশিক্ষণ কোর্স - নিবন্ধন করুন এখনি! x

Mastering Dashboard and KPI Analysis in Excel for MIS/Reporting

  • No Rating
  • (0 Reviews)
  • 0 students enrolled

Mastering Dashboard and KPI Analysis in Excel for MIS/Reporting

Its’ a Business Analytics & Intelligence course in MS Excel. The WHOLE Excel Mastery Series In One! for data analysis through Pivot Table and Dashboard for MIS Reporting By getting the course, Level up your data dashboard skills. This course will open you up to the world of dashboard design and management. Learn the latest data dashboard skills from experts with real-world experience. The data dashboard learning path arms you with the knowledge of Tableau design, Salesforce integration MIS/Reporting and more.

  • No Rating
  • (0 Reviews)
  • 0 students enrolled
  • 7500.00৳
  • 10000.00৳
  • Course Includes
  • A Business Analytics & Intelligence course for MIS
  • daily online support
  • Free performance review after 1 month
  • Completion Certificate


What learn

  • Its’ a Business Analytics & Intelligence course in MS Excel. The WHOLE Excel Mastery Series in One! for data analysis th...
  • • Create Professional Interactive Excel Dashboards from scratch
  • • Create over 10 Amazing Interactive Non-Standard Charts in Microsoft Excel. BONUS: Excel Workbook files + Sample files...
  • • Improve general Excel knowledge - Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macro...
  • • Analyze Data with Excel PivotTables and Pivot Charts
  • • Learn how to create a professional KPI dashboard from scratch
  • • Build Interactive Dashboard Reports with Buttons and Drop Down Menus
  • • Understand and Identify the Principles of Data Analysis
  • • Analyze Excel data using Excel's based Functions
  • • Quizzes and exercises

Course Content

8 sections • 8 lectures •
1.Introduction; 2.Inserting Charts ; 3.Using Ideas 4.Chart Ribbons; 5.Pivot Charts; 6.Charting Elements

Day-1:

The Basics of Charting In Excel 

  • Introduction
  • Inserting Charts
  • Using Ideas
  • Chart Ribbons
  • Pivot Charts
  • Charting Elements
mb
• 1.Principles of Data visualization Introduction; • 2.Principles of visualizations; • 3.Good and Bad charts;

 

Day-1:

Principles of Data visualization

  • Principles of Data visualization Introduction
  • Principles of visualizations
  • Good and Bad charts
mb
• 1.Mastering common Charts Intro; • 2.Working with Line charts and Trendlines; • 3.Working with Bar and Column Charts in Excel;

Day-2:

Mastering Common Charts

  • Mastering common Charts Intro
  • Working with Line charts and Trendlines
  • Working with Bar and Column Charts in Excel
  • An introduction to Histograms
  • Working with Histogram and Pareto Charts in Excel
  • Pie and Donut Charts
  • Scatter Charts
  • Working with Scatter Charts in Excel
  • Filled Maps in Excel
mb
• 1.An introduction to bubble charts; • 2.Bubble charts; • 3.Introducing Waterfall charts;

Day-3:

Mastering Less Common Charts

  • An introduction to bubble charts
  • Bubble charts
  • Introducing Waterfall charts
  • Working with Excels Waterfall charts
  • Getting started with Waterfall charts
  • working with Combination charts in Excel
  • Sparklines
  • Stock Image Dashboard in Excel
mb
• 1.Lets talk about Dashboards Introduction; • 2.What is a Dashboard; • 3.Where to start when designing a dashboard;

Day-4:

Lets talk about Dashboards

  • Lets talk about Dashboards Introduction
  • What is a Dashboard
  • Where to start when designing a dashboard
  • Dashboard Don'ts
  • Why use Excel
  • Good and bad dashboard examples
mb
• 1.Creating dynamic charts Introduction; • 2.Creating a custom visual overlay; • 3.Dynamic Sales V's Budget;

Day-4:

Creating dynamic charts

  • Creating dynamic charts Introduction
  • Creating a custom visual overlay
  • Dynamic Sales V's Budget
  • Sales V's Budget part
  • Creating Dynamic Legends
  • Formatting based on values
  • Dynamic formatting based on criteria
  • How and why to fix an axis on dynamic and multiple charts
mb