超市销售数据报表

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
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 ? 他们应怎样运用及其使用频率？
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
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 跟踪今明两年一定销售额排名内的指定行业和时段的客户的销售情况
Member of METRO Group
Advantages of Business Intelligence (BI)
==>
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 确保他们作出更好的商业决策
MicroStrategyBΒιβλιοθήκη Raw Data 原始数据
Data Warehouse 数据库 Point-of-Sale 销售 Supply Chain 供应链 ERP Data 企业系统应用数据 ….
Insight 数据解析
Business Intelligence 商业智能
Action 行动
Report 报表
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
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
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
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, ...) 客户行为分析（最后一次光顾距今天的天数，频率，关系持续时间，商品数量……）