Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
April 7, 2006 PowerPoint Presentation
Download Presentation
April 7, 2006

April 7, 2006

120 Views Download Presentation
Download Presentation

April 7, 2006

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. MAC-PAC XE Business Intelligence Solutions April 7, 2006

  2. Agenda • Introductions & Objectives • Overview • Pivot Table Training • Sales Analysis Data Mart Training • Q&A

  3. Provide a training session to understand Microsoft Excel Pivot Tables and the Sales Analysis Data Mart solution developed for Compac Corporation. Upon completion you will be able to access and analyze information in the Sales Analysis Data Mart and generate reports and analyses as needed. Objective

  4. Solution Benefits • The Business Intelligence solution provides: • A flexible and powerful reporting environment • Easy-to-use, intuitive tools (vs. MAC-PAC Sales Analysis module) • Allow analysts to focus on analyzing data instead of gathering data • Data structured for analysis (vs. Transaction systems which are structured for ease of data entry, not analysis) • Mine data to identify targeted business opportunities • Common source of data • Pre-built extractions of MAC-PAC source data using TDCI’s BuyDesign Integrator • Standard process for organizing and validating data • MAC-PAC data presented using latest OLAP technologies for Slice & Dice and drill-down analysis • Reduce risk of getting different answers to the same questions • Data audit tools and techniques for data reconciliation to the General Ledger • Reduce costly decision making based on partial or inaccurate data • Performance monitoring framework • Measure and manage the business – data is timely and accessible • Identify sales trends and profitable customers and products • Improve processes by identifying bottle necks and cost impact areas

  5. Sales Analysis Data Mart • Measures: • Invoiced Sales • Invoiced Cost • Invoiced Qty • Invoiced Lines • Invoiced Std Margin • Invoiced Std Margin Pct • MSF • MSI Selling UOM Selling UOM Sales Org SalesPerson1 Time Variants Time Variant Sourcing Warehouse Warehouse Time Day Product Part No. • Additional Info (Attributes) • Invoice No • Invoice Line No • Invoice Key • Invoice Type • Invoice Date • Order Key • Order No • Order Line No • Order Release No • Order Class • Order Type • Accounting Date • Sales Acct • COS Acct • Customer PO • Adjustment Code • Other Charges (Freight) • Unit Cost • Unit Price • SalesPerson2? • Template Code • Creation Operator – Invoice • Creation Operator – Sales Order • Sourcing Co • Sourcing Loc • Selling Co • Selling Loc Geography Ship-To State Invoices Config Code Config Code Core Type Core Type Customer Status Status Width Width Length Length Customer Bill To Product Group Product Sub Class Home Export HomeExport Segment Market Segment Product Status Product Status Ship To Ship To Segment Group Segment

  6. Solution Architecture Data Warehouse OLAP Report Delivery USER INTERACTION Staging and Transformation Data Store (Invoice Detail, Customer, Product, Segment Data, etc.) Data Transform-ation Processing Staging Tables Shared Dimensions Data Mart Dimension Data Data Mart Shared Dimensions Processing Extract and Load to Staging Area Sales Analysis Cube Sales Analysis Templates Sales Analysis Application Processing Data Mart Sales Facts Source Data Extraction Routines TDCI’s BuyDesign Integrator SourceData MAC-PAC MS Analysis Services MS Office MS SQL Server 2000