Mengya's Project Portfolio
Computer Hardware Business Report
Project Roadmap
Business Model Analysis
Dimensional Data Modeling
Business Matrix
Storytelling through Data
Project Introduction
I’m a Business Intelligence Analyst at AtliQ Tech (a fictional company), a global supplier of computer hardware serving both e-commerce and brick-and-mortar customers across multiple countries and regions. My task is to analyze sales datasets of over one million records—to uncover insights across multiple business dimensions, including finance, marketing, sales, and supply chain, in order to support strategic decision-making.
1. Business Analysis
4W1H Analysis
•who needs to see the analysis
- Product Manager, finance/marketing/sales/supply chain teams
•What business metrics does he/she would like to see
- finance, sales, marketing, supply chain metrics etc.
- Classified as measures
- Grouped into fact tables
•How metrics should be presented
- by product & & segment & category, by country & city, by time, by customer etc.
- Classified as attributes
- Grouped into dimension tables
Understanding Business Model
Key Metrics Breakdown
​2. Star Schema Modeling - Logic Model
​3. Star Schema Modeling - Physical Model
​4. Visualizaton Dashboard
