Data Analyst Portfolio

Shayantha Das

Transforming complex relational datasets into optimized SQL queries, predictive ML models, and executive-ready interactive dashboards.

Explore Portfolio Work Dashboard Gallery
Shayantha Das

Core Analytics Capabilities & Stack

Concrete engineering and visualization tools applied across my end-to-end analytics projects.

Relational SQL Databases

Constructing multi-table JOINs, subqueries, CTEs, and window functions to query, clean, and structure raw data pipelines.

MySQL PostgreSQL CTEs & Window Functions Query Optimization

Python Analytics & ML

Wrangling tabular data, performing exploratory statistical analysis, and modeling customer retention/churn behaviors.

Pandas NumPy Scikit-Learn Matplotlib & Seaborn

Business Intelligence & Dashboards

Designing intuitive, interactive business intelligence reports with custom DAX calculations, parameters, and drill-throughs.

Power BI Tableau Server DAX Measures Star Schema Modeling
25+
Dashboards Deployed
14+
GitHub Repositories
6
Core Industry Domains
100%
Reproducible Codebases

Domain & Industry Coverage

Interactive list of business domains covered with direct links to completed portfolio repositories.

HR & Workforce Analytics

Employee turnover driver analysis, attrition machine learning classification, and demographic profiling.

Marketing & Advertising

Campaign ROI tracking, global ad performance monitoring, conversion funnel metrics, and attribution evaluation.

E-Commerce & Retail Sales

Customer purchasing behavior, store sales dashboards, Walmart demand forecasting, and Olist platform analytics.

Media & Entertainment

Streaming platform content distribution strategies, genre growth analytics, and release timeline patterns.

Customer Retention & Churn

End-to-end retention tracking combining predictive machine learning models with interactive Power BI dashboards.

Predictive Modeling & Real Estate

Supervised machine learning regression for property price estimation and exploratory demographic modeling.