超市销售数据报表
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Track the customer performance in term of buying customer and sales in selected period 跟踪某项活动客户在一定时段的采购情况 Check if the code in system is right or not 检查系统中的活动代码是否正确 Track the performance of per SE/KAE in term of sales in selected period, also track in each branch such as Canteen,CBU,Other Horeca,Top Hotel,Trader 跟踪SE/KAE对应客户在指定时段的销售情况，同时可跟踪几个行业的销售 Track the top customer list in selected branch by appointed sales value 跟踪今明两年一定销售额内指定行业的客户排名清单 Track the top customer sales and invoice in selected branch and period by appointed sales value 跟踪今明两年一定销售额排名内的指定行业和时段的客户的销售情况
What is CRM CA ? CRM – Customer Relationship Management
CRM is the business strategy, processes and solutions that an organisation uses to maximise the relationship it has with it’s customers and the value it derives from these relationships. CRM是一种经营战略、流程和方案，使用者可最大限度的利用 他的客户关系以及源于这些关系的价值
CA - Customer Analysis
CA is a business intelligence tool that allows analysis and reporting of customer information. CA supports decision making in the business and the maximisation of customer relationships. CA是允许进行客户信息分析和报告的商业智能化工具，支持商业 决策和优化客户关系。
METRO Cash & Carry China CRM CA – End User Training
Member of METRO Group
1. Introduction 2. CRM CA Application Overview 3. CRM CA Reports Overview
Member of METRO Group
MicroStrategy
B
Raw Data 原始数据
Data Warehouse 数据库 Point-of-Sale 销售 Supply Chain 供应链 ERP Data 企业系统应用数据 ….
Insight 数据解析
Business Intelligence 商业智能
Action 行动
Report 报表
C
Graph 图表
A
B
Alert 预警
C
Member of METRO Group
Data Model
Analysis „Grid“ - Data Dimensions and Hierarchies分析网格-数据坐标和层次
Promotion
Art.Main Group
Food / NonFood
Member of METRO Group
Advantages of CRM CA
– Increased revenue opportunities 增加收入的机会 – Get more spending from Metro customers 提高客户的消费 – Better return on promotion activities 提高促销活动的回报 – More reliable information on customers 获得更多可靠的客户信息 – Customer consulting process can be more effective 使客户咨询手段更有效 – Increased sharing of information within the organisation 提高内部的信息的共享 – Improve organisational learning 改进组织的知识 – Increased competitive position and profitability of operations 提高竞争位置和运作收益 – Improve the Metro offering to customers 提高Metro对客户提供的服务
Member of METRO Group
CRM CA Release 1.0 Analysis
• Customer group reporting (customer number, sales or sales development, gross profit on sales sub domain / store / month) 客户组报表（卡号，销售或销售发展，行业/商场/月毛利） • Customer reporting (sales or sales development, gross profit on article group / store / month) 客户报表（销售或销售提高，商品组/商场/月毛利） • Customer assortment use (food / nonfood, regular / promotion, sales sub domain, dedicated articles) 客户分类应用（食品/非食品，常规/促销，销售范围，特殊商品） • Customer promotion sales analysis (customer groups, promotion sales ratio, promotion assortment part, gross profit, buying frequency, ...) 客户促销销售分析（客户组，促销商品比率，促销分类部分，毛利，采购频率） • Customer profitability analysis (assortment use, frequency, timezone, branch) 客户收益分析（分类，频率，时区，行业） • Customer behaviour analysis (recency, frequency, duration of relationship, numbers of articles, ...) 客户行为分析（最后一次光顾距今天的天数，频率，关系持续时间，商品数量……）
Member of METRO Group
Country Report only for BU
CRM CA Report Invoice control Daily sales over certain amount customer New customer(buying) Top articles of customer branch Top article for selected customer Report Purpose
Sales Sub Dom.
Art.Sub Group
Food / NonFood
... Home Store ZIP Timezone
Sales Dom.
Art Group
Article
Cust. Group ... Frequency Branch Family Branch
Customer
Cardholder
Member of METRO Group
What is Business Intelligence ?
Business Intelligence (BI) applications are decision support tools that enable real-time, interactive access, analysis and manipulation of mission critical corporate information. 商业智能方案作为决策支持工具，能够实现对于公司重要信 息及时,互动的访问，以及分析和掌控。 These applications provide users with valuable insight into key operating information to quickly identify business opportunities and problems. 这些应用软件给用户提供了有价值的运作信息，从而迅速地 把握商机和发现问题。
Member of METRO Group
Oracle Database
A
Data Warehouse: Centralize data from multiple sources into a data warehouse 汇总多种数据源到 该数据库 Insight: BI Tools analyze the data to help better understand the business 商业智能化分析数 据以便更好的理解 业务 Action: Act on the insight provided by BI tools by reallocating resources 通过BI工具和资源重 组来制定行动 Oracle9i
Member of METRO Group
CRM CA Release 1.0 - Country Reports
Country Report for BU and Store
CRM CA Report Activity tracking Activity code check SE/KAE Bonus Top customer 2004/2005 2004/2005 Top customer evaluation Report Purpose
Member of METRO Group
Advantages of Business Intelligence (BI)
==>Baidu Nhomakorabea
Business Intelligence provides decision makers 商务智能化方案为决策者提供 » with the right information 正确的信息 » at the the right time 正确的时机 » in the right place 正确的场合 enabling them to make better business decisions 确保他们作出更好的商业决策
Member of METRO Group
Business Impact – CRM CA
• What is the purpose of this report ? 这些报表的用途是什么？ • What is the key information in this report / analysis ? 这些报表和分析的关键信息是什么？ • What business process does this impact ? 哪些商业流程会有这些影响？ • What business decisions can this information support ? 这些信息如何支持商务决策？ • Who in the business should use this report ? 那些人会用到这些报表？ • How should they use it and how often ? 他们应怎样运用及其使用频率？
What is CRM CA ? CRM – Customer Relationship Management
CRM is the business strategy, processes and solutions that an organisation uses to maximise the relationship it has with it’s customers and the value it derives from these relationships. CRM是一种经营战略、流程和方案，使用者可最大限度的利用 他的客户关系以及源于这些关系的价值
CA - Customer Analysis
CA is a business intelligence tool that allows analysis and reporting of customer information. CA supports decision making in the business and the maximisation of customer relationships. CA是允许进行客户信息分析和报告的商业智能化工具，支持商业 决策和优化客户关系。
METRO Cash & Carry China CRM CA – End User Training
Member of METRO Group
1. Introduction 2. CRM CA Application Overview 3. CRM CA Reports Overview
Member of METRO Group
MicroStrategy
B
Raw Data 原始数据
Data Warehouse 数据库 Point-of-Sale 销售 Supply Chain 供应链 ERP Data 企业系统应用数据 ….
Insight 数据解析
Business Intelligence 商业智能
Action 行动
Report 报表
C
Graph 图表
A
B
Alert 预警
C
Member of METRO Group
Data Model
Analysis „Grid“ - Data Dimensions and Hierarchies分析网格-数据坐标和层次
Promotion
Art.Main Group
Food / NonFood
Member of METRO Group
Advantages of CRM CA
– Increased revenue opportunities 增加收入的机会 – Get more spending from Metro customers 提高客户的消费 – Better return on promotion activities 提高促销活动的回报 – More reliable information on customers 获得更多可靠的客户信息 – Customer consulting process can be more effective 使客户咨询手段更有效 – Increased sharing of information within the organisation 提高内部的信息的共享 – Improve organisational learning 改进组织的知识 – Increased competitive position and profitability of operations 提高竞争位置和运作收益 – Improve the Metro offering to customers 提高Metro对客户提供的服务
Member of METRO Group
CRM CA Release 1.0 Analysis
• Customer group reporting (customer number, sales or sales development, gross profit on sales sub domain / store / month) 客户组报表（卡号，销售或销售发展，行业/商场/月毛利） • Customer reporting (sales or sales development, gross profit on article group / store / month) 客户报表（销售或销售提高，商品组/商场/月毛利） • Customer assortment use (food / nonfood, regular / promotion, sales sub domain, dedicated articles) 客户分类应用（食品/非食品，常规/促销，销售范围，特殊商品） • Customer promotion sales analysis (customer groups, promotion sales ratio, promotion assortment part, gross profit, buying frequency, ...) 客户促销销售分析（客户组，促销商品比率，促销分类部分，毛利，采购频率） • Customer profitability analysis (assortment use, frequency, timezone, branch) 客户收益分析（分类，频率，时区，行业） • Customer behaviour analysis (recency, frequency, duration of relationship, numbers of articles, ...) 客户行为分析（最后一次光顾距今天的天数，频率，关系持续时间，商品数量……）
Member of METRO Group
Country Report only for BU
CRM CA Report Invoice control Daily sales over certain amount customer New customer(buying) Top articles of customer branch Top article for selected customer Report Purpose
Sales Sub Dom.
Art.Sub Group
Food / NonFood
... Home Store ZIP Timezone
Sales Dom.
Art Group
Article
Cust. Group ... Frequency Branch Family Branch
Customer
Cardholder
Member of METRO Group
What is Business Intelligence ?
Business Intelligence (BI) applications are decision support tools that enable real-time, interactive access, analysis and manipulation of mission critical corporate information. 商业智能方案作为决策支持工具，能够实现对于公司重要信 息及时,互动的访问，以及分析和掌控。 These applications provide users with valuable insight into key operating information to quickly identify business opportunities and problems. 这些应用软件给用户提供了有价值的运作信息，从而迅速地 把握商机和发现问题。
Member of METRO Group
Oracle Database
A
Data Warehouse: Centralize data from multiple sources into a data warehouse 汇总多种数据源到 该数据库 Insight: BI Tools analyze the data to help better understand the business 商业智能化分析数 据以便更好的理解 业务 Action: Act on the insight provided by BI tools by reallocating resources 通过BI工具和资源重 组来制定行动 Oracle9i
Member of METRO Group
CRM CA Release 1.0 - Country Reports
Country Report for BU and Store
CRM CA Report Activity tracking Activity code check SE/KAE Bonus Top customer 2004/2005 2004/2005 Top customer evaluation Report Purpose
Member of METRO Group
Advantages of Business Intelligence (BI)
==>Baidu Nhomakorabea
Business Intelligence provides decision makers 商务智能化方案为决策者提供 » with the right information 正确的信息 » at the the right time 正确的时机 » in the right place 正确的场合 enabling them to make better business decisions 确保他们作出更好的商业决策
Member of METRO Group
Business Impact – CRM CA
• What is the purpose of this report ? 这些报表的用途是什么？ • What is the key information in this report / analysis ? 这些报表和分析的关键信息是什么？ • What business process does this impact ? 哪些商业流程会有这些影响？ • What business decisions can this information support ? 这些信息如何支持商务决策？ • Who in the business should use this report ? 那些人会用到这些报表？ • How should they use it and how often ? 他们应怎样运用及其使用频率？