![Page 1: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/1.jpg)
Chapter 3
Introduction to the Orion Star Data
![Page 2: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/2.jpg)
Section 3.1
Overview
![Page 3: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/3.jpg)
3
Course DataThe 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.
![Page 4: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/4.jpg)
4
Orion Star – Organization The Orion Star organization hierarchy has several levels: country company department group.
![Page 5: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/5.jpg)
5
Orion Star – EmployeesInformation stored for each employee includes: employee ID job title hire date termination
date address gender salary.
![Page 6: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/6.jpg)
6
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.
Orion Star – Merchandise
![Page 7: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/7.jpg)
7
Orion Star – MerchandiseEach 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.
![Page 8: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/8.jpg)
8
Orion Star – CustomersOrion 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.
![Page 9: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/9.jpg)
9
Orion Star – OrdersMost 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).
![Page 10: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/10.jpg)
10
Orion Star – SuppliersAll 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.
![Page 11: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/11.jpg)
11
Orion Star Information ConsumersThere are many people and groups at Orion Star who use SAS software, including information systems business users management and
C-level executives.
![Page 12: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/12.jpg)
Section 3.2
Data Models
![Page 13: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/13.jpg)
13
Orion Star – Data ModelsThe Orion Star data is organized two ways:
Normalized Normalized (relational) (relational) modelmodel
represents the extracts from OLTP, represents the extracts from OLTP, ERP, and other systems. This data can ERP, and other systems. This data can be transformed, cleansed, and loaded be transformed, cleansed, and loaded into a data warehouse.into a data warehouse.
Dimensional Dimensional modelmodel
represents a data warehouse that represents a data warehouse that consists of a star schema design. This consists of a star schema design. This data is well suited for use in business data is well suited for use in business intelligence applications and for ad hoc intelligence applications and for ad hoc querying and reporting.querying and reporting.
...
![Page 14: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/14.jpg)
14
The Normalized (Relational) Data Model
![Page 15: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/15.jpg)
15
The Dimensional Data Model
![Page 16: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/16.jpg)
Section 3.3
Case Study
![Page 17: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/17.jpg)
17
Case Study ScenarioThe 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.
![Page 18: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/18.jpg)
18
Case Study ScenarioOnce 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.
![Page 19: Chapter 3 Introduction to the Orion Star Data. Section 3.1 Overview](https://reader036.vdocuments.us/reader036/viewer/2022082215/56649e655503460f94b6010b/html5/thumbnails/19.jpg)
19
Case Study Scenario Flowchart
Register Source Tables
DefineData Libraries
CreateETL Jobs
DefineTarget Tables
CreateOLAP Cubes
View and AnalyzeData
CreateStored Processes
Create Reports
CreateInformation Maps
Use the InformationDelivery Portal
Metadata