Saturday, 9 August 2014

Salesman KPI Dashboard

  
This Dashboard displays Key Performance Indicators of Employees for their sales by region-year wise and also for each customer type.

Dashboard contains:
1> Sales by Customer Type and Region wise - Pivot data is presented for this filter/report.
2> Stats by Products - Wile selecting the product, it sows who has been the best salesman for each year 2008 and 2009
                                        along with othe salesman average sales per month
                                        A graphical Chart is also provided for average sales year-wise by each salesman.
3> Salesman Performance - In this we try to present graphically month wise sales of selected salesmen, for each                                                               product individually or  all products collectively.
4> Big Picture- Top Sales Region by Customer Type - Graphical presentation with % Share by each type of custmer -                                      region wise.

5> Big Picture- Top Salesman by Region for each Customer type - Graphical presentation with region wise sales by each                             salesman for each customer type.

Friday, 8 August 2014

Data Model in MS Excel


The Excel Data Model is revolutionizing how you can work with data in Excel. In this webinar, guest host Owen Duncan teaches us how Excel Data Models provide lightning fast data analysis and visualizations.

What you will learn

  • What an Excel Data Model is
  • How to get data into a Data Model
  • How to create relationships between tables in the model
  • How to extend the model by using Power Pivot
References for this webinar can be found below.