How jahnavi1473/data-portfolio works
This repository is a portfolio of four analytics projects. Their common user-to-result pattern is transforming project datasets into SQL or spreadsheet analyses, then presenting dashboards and business insights. The graph preserves each project’s documented warehouse, KPI, dashboard, and reporting capabilities. Relationships are documented in the root README; source excerpts were not available, so implementation details beyond those statements are omitted.
Main entry points: data Claims Data · Data Loading.sql Warehouse Loading · Data Modeling.sql Star Schema · Analysis queries.sql Claims Analysis
Components 17
Healthcare Claims
- Claims Data
healthcare-claims-analytics/data - Warehouse Loading
healthcare-claims-analytics/sql/Data Loading.sql - Star Schema
healthcare-claims-analytics/sql/Data Modeling.sql - Claims Cleaning
healthcare-claims-analytics/sql/Data Cleaning & Transformation.sql - Claims Analysis
healthcare-claims-analytics/sql/Analysis queries.sql - Fraud and Cost Insights
healthcare-claims-analytics/sql/Analysis queries.sql
Retail SQL BI
- Retail Transactions
Retail_Analysis/Dataset/online_retail_utf8.csv - Retail Data Cleaning
Retail_Analysis/SQL/01_B_data_cleaning.sql - Sales Star Schema
Retail_Analysis/SQL/02_warehouse_queries.sql - Sales Analysis
Retail_Analysis/SQL/03_business_analysis.sql - Interactive BI Dashboard
Retail_Analysis/Power BI/Retail_Analytics_Dashboard.pbix
Retail Excel
- Retail Dataset
Retail-Sales-Analytics-Excel/Dataset/OnlineRetail_Cleaned1.xlsx - KPI Dashboard and Macros
Retail-Sales-Analytics-Excel/Excel_Dashboard/Retail_Sales_Dashboard.xlsm
PwC Simulation
- Simulation Datasets
pwc-switzerland-powerbi-job-simulation/dataset - Three BI Dashboards
pwc-switzerland-powerbi-job-simulation/powerbi - Executive Insights
pwc-switzerland-powerbi-job-simulation/insights
Other components
- Business Analyst
Connections 16
- Business Analyst → Claims Data: analyzes
README.md - Claims Data → Warehouse Loading: loads
README.md - Warehouse Loading → Star Schema: structures
README.md - Claims Data → Claims Cleaning: transforms
README.md - Star Schema → Claims Analysis: supports queries
README.md - Claims Analysis → Fraud and Cost Insights: identifies
README.md - Business Analyst → Retail Transactions: analyzes
README.md - Retail Transactions → Retail Data Cleaning: cleans
README.md - Retail Data Cleaning → Sales Star Schema: models
README.md - Sales Star Schema → Sales Analysis: supports analysis
README.md - Sales Analysis → Interactive BI Dashboard: visualizes
README.md - Business Analyst → Retail Dataset: analyzes
README.md - Retail Dataset → KPI Dashboard and Macros: feeds reporting
README.md - Business Analyst → Simulation Datasets: analyzes
README.md - Simulation Datasets → Three BI Dashboards: visualizes
README.md - Three BI Dashboards → Executive Insights: informs
README.md