Project - Advanced Sales Productivity Dashboard
Project - Advanced Sales Productivity Dashboard
Sales,Business,Business Development
Lectures -59
Duration -7 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.
Who this Courses is For:
- 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
Introduction
2 Lectures
- Introduction to Sales Productivity Dashboard Advanced 09:50 09:50
- Data Introduction 05:50 05:50
Data Formulaes
8 Lectures
Formatting
6 Lectures
Macro
4 Lectures
Sigma Analysis
5 Lectures
Budget
2 Lectures
Pivot Table and Chart
3 Lectures
Consolidation and Trend Analysis
4 Lectures
Montecarlo Simulation
7 Lectures
Null Matrix
3 Lectures
Active Visavis and Inactive Analysis
4 Lectures
Histogram And Regression Analysis
3 Lectures
Rank and Percentile and Descriptive Statistics
4 Lectures
Index and Headers
3 Lectures
Conclusion
1 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