Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Model (Metrics (CO (Standard (Reported, Organic), COGS rates, Full),…
Data Model
Metrics
Volume
Non-Promo
Promo
Net Sales
Reported
Organic
CO
COGS rates
Standard
Reported
Organic
Full
TTM
Accruals
Settlements
CAF
Reports
KAM dashboard
Daily Sales
Customer
Region
Product
Brand
layer cumulative
Format
as cumulative?
Managerial dashboard
Controlling Model
With extract from ttm
NS calculation
Bridges Vs gps ly
Before closing NS
With pricing calculation
Table in excel linked to model
With dates for carry pver
With invest calculation?
Low prio
Daily sales
Vs gps
Customer
Brand
Total month
Vs trend
Brand
Separate KPI chart
Day
Separate daily cumulated chart
Var Tons per day above
And MTD total var
Show customer per day somehow
Sparklines?
TT Budgets tracking
MicroStrategy input
Analytics tab
Customer
Product
Nego
Nego tools aggregation
Invest summary
Analytics for TM
Closing
P&L view
With accruals calculation
On YTD basis
Variances
Vs trend
Brand
Vs GPS
Customer
Brand
Heatmap
KAM Nego tool
Scenarios
Summary
Analytics tab
Volume management tab
Monthly
With variances
Per format
Brand aggregation
Power Query
Essbase
Hierarchies
Products
Pnl_Storage
AIG
Blueplanner
Manual
Product Type
Indulgence etc.
Customers
Pnl_Storage
AIG
Blueplanner
SAP
Manual
Channels
Data
AC
GPS
RF
AIG cube
Microstrategy
Daily Sales
Customer
Product Format
Daily file auto drop
Microstrategy FTP
Metrics
Volume
CAF
CAF/PC ?
Blueplanner
Data Models
Controlling
AC
Monthly
GPS
RF
IP
PRGM
Promo
AC
Forecast
Monthly
Demand
Sales
weekly update?
Detailes Sales
daily granularity?
owner?
Daily Sales
Hierarchies
Customer Hierarchy
Channel
Customers Group
Customer
Region
Product Hierarchy
Type
Brand
SubBrand
Format
SKU
Guidelines
(
https://d13ot9o61jdzpp.cloudfront.net/images/pq_pq_db_web_2.png
)
http://www.skuteczneraporty.pl/wp-content/uploads/2010/09/wzorcowy-dashboard.png
