Skip to content

rayyan-merchant/Data-Analytics-Portfolio

Repository files navigation

Data Analytics Portfolio — Projects & Case Studies

Welcome to my Data Analytics portfolio repository!
This collection showcases end-to-end analytical projects across multiple tools, platforms, and business domains. Each project lives in its own folder with a detailed README.md explaining the context, methodology, findings, and artifacts.

The goal of this repository is to demonstrate proficiency in:

✔ Data Exploration
✔ Data Wrangling
✔ Statistical Analysis
✔ Business Intelligence
✔ Predictive Analytics
✔ Reporting & Visualization
✔ Dashboarding & Storytelling
✔ SQL & Data Warehousing Concepts
✔ Python-based Data Science Workflows


Types of Projects Included

This repo features a variety of analytic project types:

🔹 Exploratory Data Analysis (EDA)

Data profiling, trends, correlations, relationships, anomalies

🔹 Predictive & Inferential Modeling

Regression, hypothesis testing, survival analysis (where applicable)

🔹 Business Intelligence Dashboards

KPIs, data storytelling, business insights, drill-downs

🔹 Excel & Spreadsheet Analysis

Pivot tables, lookups, risk models, cost-benefit analysis

🔹 SQL Querying & Analytics

Window functions, aggregations, joins, subqueries

🔹 Data Warehouse & ETL

Dimensional modeling, star schema, fact tables, transformations


Project Index (Updating as Repository Grows)

# Project Domain Tools Used Status
1 Cancer Data Analysis Healthcare Python Done
2 SQL DWH Project Business SQL Done
3 Performance Dashoard using Excel Corporate Excel Done
4 Python App for SQL Operations No code SQL SQL, Python, Streamlit Done
5 PowerBI Real time Dashboard API Data PowerBI Done
6 Database Creation and Migration Hospital SQL Done
7 EDA using SQL EDA SQL Done
8 ETL and Scheduling Automation App ETL Python, SQL In Progress

More will be added as projects are pushed.


Purpose & Audience

This repository is designed for:

  • Recruiters & Hiring Managers
  • Data Science & BI Professionals
  • Researchers & Analysts
  • Students and Learners
  • Myself — as an evolving portfolio of analytical capability

Connect with Me

About

Portfolio of data analytics projects including Python EDA, BI dashboards, SQL analysis, Excel modeling, and data warehousing. Showcasing end-to-end analytical workflows and turning raw data into business insights through analytics, visualization, and modeling.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages