Build Automated Sales Dashboard with Excel

Curriculum

Overview

Training Outline:

The dashboard is used as the most powerful decision-making tool globally. Visualize, Track, Analyze and make the Perfect Decision for your business. The main purpose of a KPI or Business dashboard is to provide a comprehensive snapshot of performance, that enables you to visualize by a large amount of detail without using too many drill-downs. A Sales Dashboard would help the company to not only expedite the Sales Performance but also to understand the market and bring in innovation to create a new market & enhance the market capability of the existing market.

Learning Outcome / Training Outline:

Understanding Dashboard Architecture
Understand the Sales Analytics & KPIs used Globally
Learn about Excel Power BI Tool
Use Excel Power BI for Shaping & Normalizing Data Source
Data Viz with Pivot, Charts, Number Format & Conditional Format
Build Animation in Slicers to Animate Dashboard
Use Macro to Animate the Dashboard Visualization
Prepare Animated Dashboard on Real Life Case
Bonus Tips for Dashboard

Target Audience:

Senior Sales Leaders
Sales Managers maintaining a team
Specialists working with Data and Analytics

Training Deliverables:

Exercise Files for practice
Full Video recording of the training
Certificate of Participation

Pre-requisites to Participate:

1. Should have intermediate knowledge about Excel.
2. Use Microsoft Office 2016 or higher. Office 365 is the best

Note:

After completing every lesson click on the “COMPLETE” button the go to the next lesson.
Must set up your first name, last name, and display name from settings of your profile for your certificate.
don’t click on the “FINISH COURSE” button.
If you click on the “FINISH COURSE” button then the course will be finished and a Certificate will be generated.
More details: https://thrivingskill.com/faqs/

Instructor: