Unified Sales Intelligence Dashboard v1.0.0

Read full text Summarise with VIRAT
Authors: Omar Sharafeldin Mohamed Abdelfatah
Cited by: 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