1 / 19

Chapter 3

Chapter 3. Introduction to the Orion Star Data. Section 3.1. Overview. Course Data. The data used in this course is from Orion Star Sports & Outdoors , which is a fictitious retail company selling sports and outdoor products has retail stores in many countries throughout the world

farrah-velasquez
Download Presentation

Chapter 3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 3 Introduction to the Orion Star Data

  2. Section 3.1 Overview

  3. Course Data • The data used in this course is from Orion Star Sports & Outdoors, which • is a fictitious retail company selling sports and outdoor products • has retail stores in many countries throughout the world • sells products in retail stores, through catalog mail orders, and over the Internet • utilizes the Orion Star Club to track purchases, enabling analyses of buying patterns and providing a basis for CRM activities and targeted product offerings.

  4. Orion Star – Organization • The Orion Star organization hierarchy has several levels: • country • company • department • group.

  5. Orion Star – Employees • Information stored for each employee includes: • employee ID • job title • hire date • termination date • address • gender • salary.

  6. Orion Star – Merchandise • Approximately 5,500 different sports and outdoors products are offered at Orion Star. The products are organized into the hierarchy of: • product line • product category • product group • product.

  7. Orion Star – Merchandise • Each product has a cost and sales price. Price change history is maintained by recording start and end datesfor each price. All prices are in U.S. dollars.

  8. Orion Star – Customers • Orion Star has approximately 100,000 customers spread across many countries. Customer address information is stored in a number of tables and includes • street • city • state • postal code • country.

  9. Orion Star – Orders • Most of the approximately 750,000 orders are sales to Orion Star Club members for whom customer information is recorded. Each order contains one or more order lines (one line per product purchased).

  10. Orion Star – Suppliers • All of the Orion Star products have a pointer to a supplier. There are 64 suppliers, based in different countries, but only one supplier per product.

  11. Orion Star Information Consumers • There are many people and groups at Orion Star who use SAS software, including • information systems • business users • management and C-level executives.

  12. Section 3.2 Data Models

  13. Orion Star – Data Models • The Orion Star data is organized two ways: Normalized (relational) model represents the extracts from OLTP, ERP, and other systems. This data can be transformed, cleansed, and loaded into a data warehouse. Dimensional model represents a data warehouse that consists of a star schema design. This data is well suited for use in business intelligence applications and for ad hoc querying and reporting. ...

  14. The Normalized (Relational) Data Model

  15. The Dimensional Data Model

  16. Section 3.3 Case Study

  17. Case Study Scenario • The remainder of this course uses the SAS BI Client Tools in a case study scenario to build the Orion Star Marketing Data Mart by • defining data libraries • registering source tables • defining target tables • creating ETL jobs • creating OLAP cubes.

  18. Case Study Scenario • Once the Marketing Data Mart is built, it is used to • create stored processes • view and analyze data • create information maps • create reports • use the information delivery portal.

  19. Define Data Libraries Create Stored Processes Register Source Tables View and AnalyzeData Metadata Define Target Tables CreateInformation Maps CreateETL Jobs Create Reports CreateOLAP Cubes Use the Information Delivery Portal Case Study Scenario Flowchart

More Related