Unified Sales Intelligence Dashboard v1.0.0
Summary
No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.
Summarise with VIRAT Free to try with your Science Catalogs account.Abstract
π Initial Release β v1.0.0 π Overview First release of the Unified Sales Intelligence Dashboard, an end-to-end E-Commerce BI pipeline integrating multiple data sources into a Power BI dashboard. β
What's Included ETL Pipeline extract.py β Fetches data from Fake Store API, ExchangeRate API & generates synthetic customers transform.py β Cleans, enriches, and adds date dimensions & multi-currency support load.py β Loads transformed data into PostgreSQL Database schema.sql β Full table definitions with indexes for Power BI performance queries.sql β 10 KPI queries covering revenue, trends, segments & growth Dashboard Power BI Dashboard with 3 pages: Executive Summary, Sales Analysis, Customer Insights π οΈ Tech Stack Python 3.10 Β· Pandas Β· Faker Β· SQLAlchemy PostgreSQL 15 Power BI Desktop π Getting Started pip install -r requirements.txt cp .env.example .env python etl/load.py Built by Omar Sharafeldin Mohamed Abdelfatah Omar S. M. Abdelfatah
Fields of Study & Subjects
Big Data and Business Intelligence
Competitive and Knowledge Intelligence
Engineering and Information Technology
Publication details
- Journal / source
- Zenodo (CERN European Organization for Nuclear Research)
- Publication date
- 1 April 2026
- Language
- EN