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