How vishwajeetkumarsingh/nike_dashboard works
Project type and purpose
• This is a business‑intelligence / data‑analytics project built in Power BI (a .pbix file) that ingests two tabular datasets (an Excel file and a CSV), performs ETL and modeling, and produces an interactive Nike sales dashboard (Overview, Insights, Performance pages) with images and slicers.
File structure
• Top‑level “Dashboard” folder holding the Power BI report file (Nike_Dashboard.pbix)
• “Data” folder containing the two raw source files (Excel, CSV)
• “Images” folder containing PNGs of dashboards and product visuals
• README.md describing datasets, features, visuals used, and process steps (Power Query, DAX, model)
Main components
a. Data Sources
• Nike US Sales Dataset (Excel)
• nike_2020_04_13 (CSV)
b. ETL / Data Preparation
• Power Query transformations (cleaning, type conversions, calendar table)
c. Data Model / Semantic Layer
• Tables and relationships (fact table + dimension tables, calendar)
• DAX measures (key measures table)
d. Presentation / Visualization Layer
• Report pages (Overview, Insights, Performance)
• Visual elements: slicers (image slicer), cards, charts, navigation buttons
• Static assets (shoe images)
e. Hosting / Distribution
• Power BI Service or embedded link (Interactive Dashboard Link)
• Version control (GitHub repo with .pbix, data, images, README)
Relationships and data flow
• From Data Model → DAX Calculation Engine → Visualization Layer
• From Visualization Layer → User via Power BI Service or embedded dashboard
Architectural patterns and design principles
• Layered architecture:
1) Data Ingestion, 2) Data Preparation, 3) Semantic Model, 4) Presentation
• Separation of concerns: ETL logic isolated in Power Query, business logic in DAX, UI in report pages
• Reusability: calendar table and measures shared across visuals
Relevant technologies, frameworks, libraries
• Power BI Desktop (.pbix)
• Power Query (M language)
• DAX for measure calculation
• Data sources: Excel, CSV
• Hosting: Power BI Service or NovyPro embed
• Git/GitHub for versioning