Preview Sales Analytics & Productivity Advanced dashboarding

Getting Started

01 - Introduction to Sales Productivity Dashboard Advanced

Data+file+1_Advanced

data+file+2_Advanced

02 - Data Introduction

03 - Adding Formula Data Base

04 - Quarter‚Target and Percentage Achievement

05 - Target YTD

06 ctc definition

07 - Remove Part

08 - CTC Tagging

09 - Working With Core Revenue

10 - Adding Core Revenue to Each Factor

11 - Conditional Formatting

12 - Individual Employee View

13 - Individual Employee View Continues

14 - Department Grid View

15 - Sales Employee Profile

16 - Zone Grid View

17 - Data Break Macro

18 - Data Break Macro Continues

19 - Delete Sheets Macro

20 - Performance Linkage

21 - Sigma Analysis

22 - More on Sigma Analysis

23 - Core Rev Sigma Analysis

24 - CTC wise Analysis

25 - Core Rev CTC Analysis

26 - Budget

27 - Budget Continues

28 - Pivot Table

29 - Pivot Table Continues

30 - Pivot Charts

31 - Consolidation

32 - Trend Analysis

33 - More on Trend Analysis

34 - Goal Seek

35 - Objectives and Distribution of Montecarlo Simulation

36 - Advantages of Montecarlo Simulation

37 - Normal Distribution for Montecarlo Simulation

38 - Iteration in Montecarlo Simulation

39 - Iteration in Montecarlo Simulation

40 - Trigular Distribution in Montecarlo Simulation

41 - Trigular Distribution in Montecarlo Simulation Continue

42 - Create a Data Analysis with Null Matrix

43 - Year to Year Data Analysis

44 - Formatting a Data Piece

45 - Top Ranked Exits Analysis

46 - Year on Year Exit Analysis

47 - Active Visavis Inactive Analysis

48 - Active Visavis Inactive Analysis Continues

49 - Histogram Analysis

50 - Histogram Analysis Continues

51 - Regression Analysis

52 - Rank and Percentile

53 - Descriptive Statistics

54 - Create Presentation View Macro

55 - Dashboard to PPT

56 - Using Hyper Link in Index

57 - Using Hyper Link in Index Continues

58 - Adding Header to Sales Productivity Dashboard

59 - Conclusion

Preview - Sales Analytics & Productivity Advanced dashboarding