BI-and-Analytics
Business Intelligence and Analytics
Video Tutorial: https://www.youtube.com/watch?v=En6vQvhUlDE&ab_channel=AbdulAzzamAjhari
Question: 20211029025438_COMP8047041_FIN_RCQuestion.pdf
Answer: uas_compressed.pdf
This repositories discuss about:
- Identification Business process type from a few questions and finding the dimension and fact table (page 1)
- Enterprise Bus Matrix (page 1)
- Star Schema according questions business process (page 2)
- Pre-processing Extract, Transform, Load (ETL) regarding the data from the business process (page 4, 6, 7)
- Type 2 Slowly Change Dimension (SCD) and dimensional table with fact table (page 8)
- Pentaho ETL transformation step by step ==> (page 54)
- Visualization using Power BI ==> (page 67)