My Work

Dashboards &
Analytics Projects

20+ real business dashboards built at Ekologie Forte Pvt. Ltd. — financial, marketing, sales, CRM, forecasting, quality analysis and more.

01 — Dashboard Portfolio

Business Dashboards

Built using Power BI, Excel, Python and R — each dashboard gives leadership a real-time, interactive view of their most important metrics.

01 📊
Financial Analytics
Financial Dashboard
P&L tracking, revenue trends, cost breakdowns, budget vs actuals and financial KPIs with interactive drill-down across departments and time periods.
Power BIExcelSQL
02 📈
Marketing Analytics
Marketing Performance Dashboard
Campaign ROI, channel attribution, CPL, CTR and conversion funnel across Meta Ads, Google Ads, Email and SEO — all in one real-time view.
Power BIGoogle AnalyticsMeta Ads
03 💰
Sales Analytics
Sales Dashboard
Daily, weekly and monthly sales tracking, rep performance, pipeline analysis, win/loss ratios and revenue forecasting by region.
Power BISQLExcel
04 👥
CRM Analytics
CRM Dashboard
Customer lifecycle tracking, lead scoring, follow-up pipeline, customer acquisition cost and lifetime value analysis using Zoho CRM data.
Zoho CRMPower BIPython
05 🚀
Growth Analytics
Growth Funnel Dashboard
Full-funnel visibility from awareness to conversion — drop-off analysis, cohort tracking, acquisition channel comparison and retention metrics.
Power BIPythonGA4
06 🔍
Market Research
Market Research Dashboard
Market size, competitor benchmarking, pricing analysis, customer segmentation and share of voice — supporting strategic planning decisions.
ExcelPythonSPSS
07 🏭
Root Cause Analysis
Root Cause Analysis Dashboard
Fishbone diagrams, Pareto analysis, 5-Why visualisations and defect tracking with integrated SPC control charts for quality monitoring.
ExcelMinitabPower BI
08 🧠
Market Behaviour
Market Behaviour Analysis
Consumer behaviour patterns, purchase frequency, basket analysis, price elasticity and promotional response analysis across segments.
PythonRExcel
09 🏪
Retail Analytics
Retail Sales Analysis
Store-level performance, SKU analysis, inventory turnover, footfall vs conversion and regional sales comparison dashboards.
Power BISQLExcel
10 🛒
E-Commerce Analytics
E-Commerce Sales Analysis
Online sales metrics, cart abandonment, product performance, traffic source ROI, return rate analysis and customer journey mapping.
GA4Power BIPython
11 🔮
Forecasting
Sales Forecasting — 5 Year Historical
Predictive sales model built on 5 years of historical data using time series decomposition, ARIMA and exponential smoothing for accurate future projections.
PythonRExcel
12 🌤️
Seasonal Analysis
Seasonal Effect on Product Sales
Seasonal decomposition, holiday impact modelling, inventory planning recommendations and seasonal pricing strategy for sunscreen and personal care products.
RPythonExcel
13 ☀️
Product Analytics
Sunscreen Sales Effect Analysis
Effect of UV index, temperature, summer campaigns and influencer activity on sunscreen product sales — correlation and regression modelling.
PythonExcelPower BI
14 💧
Product Analytics
Cooling Facewash Sales Effect
Impact of weather, seasonal trends, social media campaigns and promotions on cooling facewash product sales — multi-factor regression.
PythonRExcel
15 📣
Campaign Analytics
Campaign Effect on Sales
Pre/post campaign analysis, A/B testing results, attribution modelling and ROI measurement across all marketing channels and campaigns.
Power BIPythonGA4
16 🎯
Strategy
Marketing Strategy from Insights
End-to-end strategy development — from data collection and insight generation to actionable marketing recommendations with ROI projections.
ExcelPower BIPython
17 ⏱️
Time Series
Time Series Analysis
Trend decomposition, seasonality identification, moving averages, exponential smoothing and ARIMA forecasting models for business planning.
RPythonExcel
18 ⚖️
Factor Analysis
Multi-Factor Sales Effect Analysis
Simultaneous analysis of all factors affecting sales — weather, campaigns, pricing, seasonality, competition and economic indicators.
PythonRSPSS
19 🌐
Import-Export
B2B / B2C Import-Export Analysis
Trade data analysis, supplier performance, buyer segmentation, geographic expansion opportunities and market entry intelligence for strategic decisions.
SQLPower BIExcel
20 📉
Competitor Analysis
Competitor Price & Market Analysis
Price benchmarking, market positioning, share of wallet analysis, competitor campaign monitoring and strategic response planning.
PythonExcelPower BI
02 — Academic & Tutoring

Research & Teaching Work

Academic Research · Machine Learning
Heart Disease Statistical Study — Aurangabad Region
Investigated how lifestyle choices (smoking, stress, diet, gender) impact heart disease risk using a curated patient dataset. Applied Naive Bayes, Logistic Regression, Decision Tree and Random Forest algorithms — Random Forest identified Gender, Tension and Smoking as top predictors.
R Excel Naive Bayes Logistic Regression Decision Tree Random Forest
Freelance Tutoring · TutorBin
70+
Completed Assignments
Statistics, Python, Advanced Mathematics, Discrete Math, Numerical Analysis, Symbolic Logic and VBA assignments. Rs.66,000+ total earnings with active streak and achievement points on TutorBin platform.
📚 Statistics ~65%
🐍 Python ~20%
📐 Mathematics ~10%
💻 Other ~5%
Online Teaching · TeacherOn
Statistics, Data Analysis & Quality Analysis for Industry
1-on-1 Online · 30–35 Hours · 6 Modules · Beginner to Intermediate
01 Foundation of Statistics for Industry
5 hrs
02 Statistical Inference & Hypothesis Testing
6 hrs
03 Data Analysis for Industry
7 hrs
04 Quality Analysis (SPC, Cpk, Gauge R&R)
8 hrs
05 Power BI Quality Dashboards
4 hrs
06 Industry Case Studies & Interview Prep
5 hrs