Analytical Vizualization Intelligence
Retail Intellegence System
Centralized retail operations data, enabling the business to perform sub-second analytical queries on millions of transaction records.
Objectives
- Design a high-availability data architecture capable of handling concurrent transactions.
- Apply Data Warehousing principles to streamline complex analytical queries.
- Ensure the system is inclusive, addressing ethical data use and accessibility for users with visual or cognitive impairments.
Solution
Engineered a robust BI system using Oracle Database 11g on Oracle Linux, implementing advanced concurrency management and high-availability protocols. I transformed raw retail data into an optimized Data Warehouse schema, which was then visualized through Tableau for actionable insights. To ensure inclusivity, I integrated specific UI/UX considerations for accessibility and adhered to strict ethical data management standards.
Stack: Oracle Database 11g, Oracle Linux, Tableau
- Architectural Design: Deployed a high-availability backend on Oracle Linux 6.7 with optimized Concurrency Control to handle simultaneous read/write loads.
- Schema Modeling: Designed a Star Schema within Oracle 11g to simplify complex retail queries and improve join performance.
- Visualization: Connected the warehouse to Tableau to build real-time executive dashboards for sales performance and inventory tracking.
Dashboard Design
Figure: Executive Dashboard
Figure: Pareto Dashboard
Figure: Whatif Analysis
Figure: Calendar Dashboard