|
I am a Data & Business Analyst focused on transforming raw business data into clear, actionable insights. My approach combines SQL, Power BI, Python, Excel, AI, and business thinking to understand what is happening in a business, why it is happening, and what should happen next. I enjoy working across the complete analytics lifecycle: Business Problem → Data → Analysis → Visualization → Insight → Decision My goal is simple:
|
📊 Business Analytics |
1. Business Problem ➔
2. Data Collection ➔
3. Data Cleaning ➔
4. Data Analysis
➔
5. Visualization ➔
6. Business Insights ➔
7. Decision Making
|
Data extraction |
Power BI |
Pandas |
KPI analysis |
A selection of business-focused analytics projects built around real-world scenarios.
| Project | Business Problem | Tools | Key Outcome | Repository |
|---|---|---|---|---|
| Sales RTO Analysis | Diagnose RTO drivers and improve order profitability | Power BI · SQL | Analyzed RTO patterns, payment behavior and profitability | View |
| D2C Customer & RFM Analysis | Understand customer value, retention and purchasing behavior | SQL · Power BI | Developed customer segmentation using RFM methodology | View |
| Marketing Campaign Analysis | Evaluate campaign performance and customer acquisition | MySQL · Power BI | Identified campaign-level performance and conversion patterns | View |
| Excel Sales Dashboard | Improve visibility into sales and operational performance | Excel · Power Query | Built an interactive management reporting solution | View |
| Banking & Loan Analytics | Analyze customers, loans and financial risk indicators | SQL · Power BI | Created business KPIs and customer/loan performance analysis | View |
| Stage | Focus | |
|---|---|---|
| 01 | Business Problem | Define objectives, KPIs and business questions |
| 02 | Data Sources | Collect data from databases, files, APIs and systems |
| 03 | Cleaning & Transformation | Prepare accurate, consistent and analysis-ready data |
| 04 | Analysis | SQL, Python, statistical and exploratory analysis |
| 05 | Visualization | Power BI dashboards and data storytelling |
| 06 | Business Insight | Identify trends, drivers, risks and opportunities |
| 07 | Decision & Impact | Turn insights into measurable business actions |
Business Problem → Data → Analysis → Insight → Decision → Impact