Что такое findslide.org?

FindSlide.org - это сайт презентаций, докладов, шаблонов в формате PowerPoint.


Для правообладателей

Обратная связь

Email: Нажмите что бы посмотреть 

Яндекс.Метрика

Презентация на тему Dashboard Spec Aspen Sales Force

Log in details for new serverREMOTE DESKTOP LOGINIP: 41.76.209.124 Username: OWLAFRICA2\Administrator Password: nBvU392@MSSQL SERVER LOGIN + JASPER DATASET CONNECTIONUsername: sa  Password: nBvU392@
Dashboard Spec Sales_Force_SSD_Daily_Dashboard Log in details for new serverREMOTE DESKTOP LOGINIP: 41.76.209.124 Username: OWLAFRICA2\Administrator Password: [Dim_Aspen Employee List Sales] is the table that is used to loop PHCY - CLICKSIndep - East Rand : Basket : Independent 1Date: 14 Dashboard page one data informationDisplay the date that the report is generatedDataset Dashboard page one data information12. Dataset 1 - SELECT count(distinct([Manufacturer_Product_Code]))  FROM Date: 4 May 2016Indep - East Rand : Basket : Independent 1# Dashboard page one data informationDataset 2 – Display list of [ASPEN CLASSIFICATION] Date: 4 May 2016Indep - East Rand : Basket : Independent 1# Dashboard page one data informationDataset 2 – Display list of products that Date: 4 May 2016Indep - East Rand : Basket : Independent 1# Dashboard page one data informationDataset 2 – Display list of customers that Supplier Data Roster Aug 16 - Oct 16 First LineManager
Слайды презентации

Слайд 2 Log in details for new server
REMOTE DESKTOP LOGIN
IP:

Log in details for new serverREMOTE DESKTOP LOGINIP: 41.76.209.124 Username: OWLAFRICA2\Administrator

41.76.209.124 Username: OWLAFRICA2\Administrator Password: nBvU392@

MSSQL SERVER LOGIN + JASPER DATASET CONNECTION
Username:

sa 
Password: nBvU392@

Слайд 3 [Dim_Aspen Employee List Sales] is the table that

[Dim_Aspen Employee List Sales] is the table that is used to

is used to loop through and mailed to users

the Dashboard where [Designation Name] = ‘Rep’ . Field [Email] is the user’s email. Before report is emailed the first check must be to look at [Status] field. If “Active” then can proceed to next check ELSE exit
[Employee Name] and [Manager Name] fields is used to populate boxes 1 and 2 in report – rep and the regional sales manager
IF [Designation Name] = ‘Rep’ THEN (To get subset of data for rep – his product basket(team) and his territory)
Dataset 1: this is filtered on rep team and territory
PARAM1 = [Team ] AND PARAM2 = [Territory]
PARAM1(first filter) is used to filter reps products that he sell
SELECT [Aspen_Product_Code] FROM [AspenHQ].[dbo].[Dim_Aspen_Teams_Louwrie] WHERE Team = PARAM1
SELECT FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Manufacturer_Product_Code] in ([Aspen_Product_Code] )

PARAM2(second filter) is used to filter reps customers that he calls on - customers in his territory
SELECT [orgcode] FROM [AspenHQ].[dbo].[Rep_Dim_Terr_Orgnames] where [Territory Description] = PARAM2
SELECT FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Medpages_OrgCode] in ([orgcode] )

Dataset 2: this is filtered on rep’s team(products) and the territory is this time all territories for this team that is selected – this will be used as national coverage to compare to rep’s territory coverage
PARAM1(first filter) is used to filter reps products that he sell
SELECT [Aspen_Product_Code] FROM [AspenHQ].[dbo].[Dim_Aspen_Teams_Louwrie] WHERE Team = PARAM1
SELECT FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Manufacturer_Product_Code] in ([Aspen_Product_Code] )

Territories - SELECT [orgcode] FROM [AspenHQ].[dbo].[Rep_Dim_Terr_Orgnames] where [Territory Description] in (SELECT distinct([Territory]) FROM [AspenHQ].[dbo].[Dim_Aspen Employee List Sales] where team = ' PARAM1 ‘)
SELECT FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Medpages_OrgCode] in ([orgcode] )










How to validate users that this report is emailed to on daily schedule


Слайд 4


PHCY - CLICKS
Indep - East Rand : Basket

PHCY - CLICKSIndep - East Rand : Basket : Independent 1Date:

: Independent 1
Date: 14 Oct 2016
Sales R 2 653

5 out of 7

Sep 16

Current Month Sales Trend Indep - East Rand : Basket : Independent 1



R 22 653

SALES TOTAL
CURRENT MONTH MAY 2016



120 out of 130



SALES CURRENT MONTH OCT 2016

10 K

20 K

30 K



Oct 16

Rep: Jonny Depp

10 %

GROWTH TOTAL SALES MAY 2016 Vs. PREVIOUS MONTH


-10 %

GROWTH # Customers MAY 2016 Vs. PREVIOUS MONTH

10 %

GROWTH # SKU’s
MAY 2016 Vs. PREVIOUS MONTH



# NUM CUSTOMERS
MAY 2016 in territory

115 Out of 300

# NUM SKU
MAY 2016

40 K

50 K


National Sales Trend Vs Indep - East Rand Basket :Independent 1

JAN FEB MAR APR JUN JUL AUG SEP OCT NOV DEC










Aug 16




National



10 K

20 K

30 K

40 K

107 MIL

10 MIL

1077 MIL















1 Oct 16

2 Oct 16

3 Oct 16

4 Oct 16

5 Oct 16

6 Oct 16

7 Oct 16

8 Oct 16

1

2

5

6

7

8

9

10

11

12

13

14

14

CUSTOMER GROUP SALES CURRENT MONTH OCT 2016



PHCY – Dis chem

Sales R 2 653
5 out of 7



Ind Pharm

Sales R 2 653
4 out of 7



Pharmacy Medirite

Sales R 2 653
5 out of 7



Hosp Netcare

Sales R 2 653
5 out of 8

Sales Force Sales In Dashboard

3


Слайд 5 Dashboard page one data information
Display the date that

Dashboard page one data informationDisplay the date that the report is

the report is generated
Dataset 1 - SELECT sum([LineTotal])

FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Tran_YearMonths] = Max([Tran_YearMonths]) and Group By [ASPEN CLASSIFICATION] – display underneat each other
Dataset 2 - SELECT count(distinct Medpages_OrgCode) FROM [Rep_SSD_Daily_Sales_Monthly_Sum]
where [Tran_YearMonths] = Max([Tran_YearMonths]) and Group By [ASPEN CLASSIFICATION] – The total amount of pharmacies : SELECT count(distinct Medpages_OrgCode) FROM [Rep_SSD_Daily_Sales_Monthly_Sum] – is to get the total amount of pharmacies in this group – this selection is on whole year – dataset 2
4.

5. Dataset 1 – Line Chart - SELECT sum([LineTotal]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Tran_YearMonths] = Max([Tran_YearMonths]) – to display latest months sales totals per day. X axis is the days of latest or current month
6. Dataset 1 – % Sales growth- SELECT sum([LineTotal]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Tran_YearMonths] = Max([Tran_YearMonths]) – to get latest months sales totals then compare to total sales from previous month with same amount of days. For instance today is the 14 th – I can only compare up to 14 th of previous month to get accurate growth %
7. Dataset 1 – % customer growth- SELECT count(distinct [Medpages_OrgCode]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Tran_YearMonths] = Max([Tran_YearMonths]) – to get latest months customer count then compare to customer count from previous month with same amount of days. For instance today is the 14 th – I can only compare up to 14 th of previous month to get accurate growth %
8. Dataset 1 – % product growth- SELECT count(distinct [Manufacturer_Product_Code]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where [Tran_YearMonths] = Max([Tran_YearMonths]) – to get latest months product count then compare to product count from previous month with same amount of days. For instance today is the 14 th – I can only compare up to 14 th of previous month to get accurate growth %
9. Dataset 1 – select max(Tran_YearMonths) to display latest month in header in text box type
10. Dataset 1 - SELECT sum([LineTotal]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where Tran_YearMonths = max(Tran_YearMonths) – to display latest months sales total
11. Dataset 1 - SELECT count(distinct([Manufacturer_Product_Code])) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where Tran_YearMonths = max(Tran_YearMonths) to get count of customers for the max day. Then SELECT count([Manufacturer_Product_Code]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] to get total products












Слайд 6 Dashboard page one data information
12. Dataset 1 -

Dashboard page one data information12. Dataset 1 - SELECT count(distinct([Manufacturer_Product_Code])) FROM

SELECT count(distinct([Manufacturer_Product_Code])) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where Tran_YearMonths = max(Tran_YearMonths)

to get count of customers for the max month. Then SELECT count([Manufacturer_Product_Code]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] to get total customers
13. Dataset 1 - SELECT count(distinct( Medpages_OrgCode)) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where Tran_YearMonths = max(Tran_YearMonths ) to get count of customers for the max Month. Then SELECT count( Medpages_OrgCode) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] to get total customers
14. Dataset 2 –SELECT sum([LineTotal]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Sum] where Tran_YearMonths >= 201601 – to display years data per month sales total – THIS IS ON REPS TEAM AND TERRITORY. The top line is National coverage – show all territories but same team as rep – Filter on team














Слайд 7 Date: 4 May 2016
Indep - East Rand :

Date: 4 May 2016Indep - East Rand : Basket : Independent

Basket : Independent 1
# Customers group performance last 3

months

1

2

3

4

5

6


Слайд 8 Dashboard page one data information
Dataset 2 – Display

Dashboard page one data informationDataset 2 – Display list of [ASPEN

list of [ASPEN CLASSIFICATION] groups that are in the

territory. Sort 4.
Dataset 2 – Display month names of last 3 months as headers of columns
Dataset 2 - SELECT count distinct ([Medpages_OrgCode]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum
Dataset 2 - SELECT sum(LineTotal) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum] where product = ‘ product‘ and last 3 months total
Dataset 2 - SELECT sum(LineTotal) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum] where product = ‘ product‘ and group by month to display month – last 3
Dataset 2 - select sum(line total) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum for latest month per group



















Слайд 9 Date: 4 May 2016
Indep - East Rand :

Date: 4 May 2016Indep - East Rand : Basket : Independent

Basket : Independent 1
# Customers who bought products(SKU) last

3 months

1

2

3

4

5

6


Слайд 10 Dashboard page one data information
Dataset 2 – Display

Dashboard page one data informationDataset 2 – Display list of products

list of products that the reps team sell. This

will be the team parameter. Sort 4.
Dataset 2 – Display month names of last 3 months as headers of columns
Dataset 2 - SELECT count distinct ([Medpages_OrgCode]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum
Dataset 2 - SELECT sum(LineTotal) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum] where product = ‘ product‘ and last 3 months total
Dataset 2 - SELECT sum(LineTotal) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum] where product = ‘ product‘ and group by month to display month – last 3
Dataset 2 - select sum(line total) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum for latest month per group



















Слайд 11 Date: 4 May 2016
Indep - East Rand :

Date: 4 May 2016Indep - East Rand : Basket : Independent

Basket : Independent 1
# SKU(product) that was bought last

3 months by customers

1

2

3

4

5

6


Слайд 12 Dashboard page one data information
Dataset 2 – Display

Dashboard page one data informationDataset 2 – Display list of customers

list of customers that is in the reps territory.

This will be the territory parameter. Sort 4.
Dataset 2 – Display month names of last 3 months as headers of columns
Dataset 2 - SELECT count distinct ([Manufacturer_Product_Code]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum
Dataset 2 - SELECT sum(LineTotal) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum] where product = ‘ product‘ and last 3 months total
Dataset 2 - SELECT count distinct ([Manufacturer_Product_Code]) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum] where product = ‘ product‘ and group by month to display month – last 3
Dataset 2 - select sum(line total) FROM [AspenHQ].[dbo].[Rep_SSD_Daily_Sales_Monthly_Sum for latest month per group



















  • Имя файла: dashboard-spec-aspen-sales-force.pptx
  • Количество просмотров: 116
  • Количество скачиваний: 0