Project - Sales Productivity Dashboard
Project - Sales Productivity Dashboard
Lectures -49
Duration -6.5 hours
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
What are the prerequisites for this course?
- 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
eCourse 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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now