Project - Sales Productivity Dashboard
Project - Sales Productivity Dashboard
Lectures -49
Duration -6.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
These dashboards help to maintain huge chunks of data and also to convert dashboard data into user friendly visuals. These online tutorials are indeed self-paced and one can easily make way and learn to create out dashboards and business intelligence and understand the importance of data trending and create valuable data visualizations.
The training includes the following information;
- INTRODUCTION – We shall learn Database creation, Database extraction, Index designing, Process flow, Hyperlinks.
- BUSINESS ANALYSIS – Here we will explore concepts like Cluster analysis, Graphs, Macro filters, Target vs achievement analysis.
- LOCATION ANALYSIS – In this sections we are considering Zone comparison, State comparison, Data consolidation.
- STATISTICAL MODELLING – Let’s learn CAGR, Correlation analysis, Moving average, Standard deviation.
- PREDICTIVE ANALYSIS – Lets look at Trendline, Michael t. Robinson generation analysis, Advanced filters, Excel solver.
- EXIT ANALYSIS – Here we shall concentrate on %loss reports, growth ratios, scenario manager.
- SALE EMPLOYEE PROFILE – Lets understand Singular view, Data validations, Performance linked growth and CTC vis-à-vis target.
- CONCLUSION – In the concluding lecture we will see Full screen macro, Protect sheet, Protect file, Presentation view macro, Page layout.
Target Customers:
- Commerce students
- Sales professional
- Students from the business administration
- Working professionals who go through the hectic working schedule of same repetitive work every day
Prerequisites
- Basic knowledge of excel tools and functions
- Passion to learn and apply

Curriculum
Check out the detailed breakdown of what’s inside the course
BackUP
1 Lectures
-
Introduction to Sales Productivity Dashboard - Beginners Training 07:35 07:35
Data Base Creation
3 Lectures

Formatting
1 Lectures

Index
3 Lectures

Business Analysis
4 Lectures

Zone State
2 Lectures

Consolidation
4 Lectures

Tenure and Age Group and CAGR
3 Lectures

Moving Average
3 Lectures

Standard Deviation
4 Lectures

Exit Analysis
3 Lectures

Growth Ratios and Scenario
3 Lectures

Sales Employee Profile
3 Lectures

Department Profile
3 Lectures

Zone Profile
2 Lectures

Trend Prediction
2 Lectures

Generation Analysis
3 Lectures

Advanced Filter and Hyperlinks
2 Lectures

Instructor Details

Corporate Bridge Consultancy Private Limited
Corporate Bridge Consultancy Private Limited - EDUCBA is an initiative by IIT IIM Graduates, We are one of the leading providers of skill-based education addressing the needs of 1,000,000+ members across 70+ Countries. With more the 15+ years of experience in Training and Development, our expertise lies in Self-paced learning, Digital Learning content, Corporate Training, Content Development and Consultancy.
Our Vision:
To be a leading and progressive partner with our clients in their journey of progress.
"We are passionate about our work. We believe in empowering and improving our members’ lives with skill-based, hands-on training programs."
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now