business intelligence using olap - anantakultwo board type of database activity oltp - online...
TRANSCRIPT
![Page 1: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/1.jpg)
Business Intelligence using OLAPASSIST. PROF. DR. ANANTAKUL INTARAPADUNG
![Page 2: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/2.jpg)
Agenda
History of the relational database? BI using OLAP
OLAP by MS-Excel
![Page 3: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/3.jpg)
History of the relational database?
![Page 4: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/4.jpg)
Difficulty in reporting from relational database
![Page 5: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/5.jpg)
Instant reporting using OLAP
![Page 6: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/6.jpg)
How an OLAP cube works
![Page 7: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/7.jpg)
MDX (Multi-dimensional expressions
![Page 8: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/8.jpg)
OLTP & OLAP
OLTP ( Create, Insert, Update, Delete) OLAP(Report, Dashboard)+ (Select & Read Only)
![Page 9: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/9.jpg)
Two board type of database activity
OLTP - Online Transaction Processing
Short transaction
Simple queries
Touch small portion of data
Frequent updates
OLAP- Online Analytical Processing
Long transaction
Complex queries
Touch large portion of the data
Infrequent updates
![Page 10: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/10.jpg)
More terminology
![Page 11: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/11.jpg)
Star Schema
Fact table
Updated frequently, very large
Sales transaction, course enrollment
Dimension tables
Stores, items, customer
Students, course
Web pages ,user, advertisers
![Page 12: Business Intelligence using OLAP - anantakulTwo board type of database activity OLTP - Online Transaction Processing Short transaction Simple queries Touch small portion of data Frequent](https://reader030.vdocuments.us/reader030/viewer/2022040921/5e9a471ec3325225a87b9c77/html5/thumbnails/12.jpg)
Reference
[1] ExcelCentral.com (2015), What is Business Intelligence and an OLAP Cube? [Online] Available: http://excelcentral.com. Retrieved June 16,2015