Netflix - Information Technology

1

Reporting Systems and OLAP

Chapter Extension 13

ce13-2

Study Questions

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

Q1: How do reporting systems enable people to create information?

Q2: What are the components and characteristics of reporting systems?

Q3: How are reports authored, managed, and delivered?

Q4: How are OLAP reports dynamic?

2

ce13-3

Q1: How Do Reporting Systems Enable People to Create Information?

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

• Reporting systems – Create meaningful information from disparate data sources – Deliver information to user on time

• Generate information by: – Filtering data – Sorting data – Grouping data – Making simple calculations

ce13-4

Raw Sales Data: List Contains Little or No Information

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

3

ce13-5

Sales Data Sorted by Customer Name

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

Create Information by Sorting

ce13-6

Sales Data Sorted by Customer Name and Grouped by Number of Orders and Showing Purchase Amounts

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

Create Information by Grouping & Summing

4

ce13-7

Sales Data Filtered to Show Repeat Customers

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

Create Information by Filtering & Formatting

ce13-8

Q2: What Are the Components and Characteristics of Reporting Systems?

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

• Reads and combines data from disparate data sources

• Filters, sorts, groups, simple calculations to produce meaningful contexts

• Metadata to prepare and deliver reports • Report characteristics

– Type – Media – Mode

5

ce13-9

Components of a Reporting System

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

ce13-10

Summary of Report Characteristics

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

6

ce13-11

Report Media

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

• Printed on paper • PDFs—Portable Document Format • Delivered to computer screens and mobile devices

Applications for CRM and ERP systems • Digital dashboards • Alerts • Exported from report generator to another program • Published via Web service

ce13-12

Digital Dashboard Example

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

7

ce13-13

Report Mode

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

Types of reports

• Push report – Sent or e-mailed to users according to a preset schedule

• Pull report – Users download report from web portal or digital dashboard

ce13-14

Q3: How Are Reports Authored, Managed and Delivered?

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

Report authoring • Connecting to data sources, create report structure, format

report • Examples: MS Access, Visual Studio

Report management • Defines who receives what reports, when, what format, and

by what means • Defines user accounts and user groups

8

ce13-15

Connecting to a Report Data Source Using Visual Studio

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

ce13-16

How Are Reports Delivered?

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

Report delivery function • Pushes or allows pulling reports based on metadata

• Delivered via an email server, Web site, SOA services, or other program-specific means

• Security components ensure only authorized users receive reports

• For queries, serves as intermediary between users and report generator

9

ce13-17

Q4: How Are OLAP Reports Dynamic?

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

• OLAP provides ability to sum, count, average, perform other simple arithmetic operations on groups of data

• OLAP reports – Dynamic

– Measure: item summed, averaged or processed in OLAP report.

– Dimension: category or class

– Cube: measure with associated dimensions

– OLAP vendors and products

ce13-18

OLAP CUBE: Typical OLAP Report

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

OLAP Product Family by Store Type

10

ce13-19

OLAP Sales Report by Product Family, Store Country, State, Store Type

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

ce13-20

OLAP Sales Report by Country, State, City and Store Type

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .

11

ce13-21

Role of OLAP Server and Dimensional Database

C o p y r i g h t © 2 0 1 7 P e a r s o n E d u c a t i o n , I n c .