🧠 “Without data, you're just another person with an opinion.” — W. Edwards Deming
🎯 Data Analyst | SQL | Business Intelligence | Analytics Engineering
I specialise in transforming structured and unstructured data into actionable business insights using SQL, Python, and Power BI.
- Delivered 8+ structured analytics projects across retail, hospitality, and job market domains
- Designed KPI dashboards with 25+ business metrics
- Built end-to-end SQL solutions using joins, CTEs, and window functions
- Applied revenue analysis, customer segmentation, and inventory risk modelling
- Strong foundation in MySQL, PostgreSQL, SQL Server, Power BI, and Python
I'm a data analytics enthusiast passionate about transforming raw data into actionable insights that drive smarter business decisions.
From hotel performance and retail trends to job market analysis, I build compelling data stories using tools like Power BI, Excel, Python, and SQL.
These projects demonstrate end-to-end SQL analytics, data engineering workflows, and business-driven decision support across multiple domains.
Designed and implemented an end-to-end data warehouse using SQL Server and Medallion Architecture (Bronze, Silver, Gold).
The project focuses on ETL pipeline development, data quality handling, and dimensional modelling for analytics.
🔗 GitHub Repo
🛠 Tools: SQL Server, T-SQL, Stored Procedures, ETL, Dimensional Modelling
Conducted a structured acquisition-style business analysis using MySQL to evaluate revenue stability, inventory capital exposure, and customer lifetime value in a two-store retail model.
The project simulates real-world due diligence, applying multi-table joins, CTEs, and window functions to assess financial risk, capital efficiency, and monetization opportunities.
🔗 GitHub Repo
🛠 Tools: MySQL, SQL, CTEs, Window Functions, Revenue Analysis, CLTV, Inventory Risk, Business Analytics
Built a real-world SQL data validation pipeline in PostgreSQL to clean, standardise, and validate Indian PAN numbers.
Implemented regex-based format checks, duplicate handling, and sequence/repetition detection to classify valid and invalid records and generate data quality insights.
🔗 GitHub Repo
🛠 Tools: PostgreSQL, SQL, DBeaver, Regex, CTE, Window Functions, Data Validation, CSV
Designed and executed SQL-driven exploratory analysis on a digital music store dataset using PostgreSQL.
The project focuses on business-oriented analysis using joins, aggregations, window functions, and CTEs to derive insights from customer, sales, and catalog data.
🔗 GitHub Repo
🛠 Tools: PostgreSQL, SQL, DBeaver, Window Functions, CTEs, CSV
Analysed Walmart sales data using SQL to uncover trends, customer behaviour, and top-performing products. Built insights using aggregations, joins, and time-based analysis to support data-driven decisions.
🔗 GitHub Repo
🛠 Tools: SQL Server, Data Analysis, Business Insights
Analysed 2024 job postings to uncover salary trends, in-demand skills, and remote opportunities.
🔗 GitHub Repo
🛠 Tools: Power BI, Power Query, DAX
Uncovered booking trends and revenue insights using hotel data.
🔗 GitHub Repo
🛠 Tools: Pandas, Seaborn, Matplotlib
Analysed millions of retail transactions to identify key revenue drivers.
🔗 GitHub Repo
🛠 Tools: Python, Time-Series, Seaborn
Explored tech skills, job titles, and salary benchmarks from job postings.
🔗 GitHub Repo
🛠 Tools: Pandas, Python, Plotly, Numpy
Created a multi-page sales dashboard with insights on KPIs, regions, products, and customer segments.
🔗 GitHub Repo
📌 Pages: KPIs, Regions, Products, Customers
🛠 Tools: Power BI, DAX
Hi again! I’m Manohar — someone who loves making work life less overwhelming and a lot more insightful with dashboards, data, and a dose of curiosity.
Here on GitHub, you’ll find:
- 🛠️ Practical projects using real-world datasets
- 📊 Dashboards and analytics reports powered by Python & Power BI
- 🔍 Explorations into trends, behaviours, and business outcomes
- 💡 Lessons I’m learning as I grow into the data space
Whether you’re here to browse code, share ideas, or see how others are figuring things out — you’re in the right place. Let’s connect, learn, and grow — one repo at a time.
You bring the snacks 🍪, I’ll bring the code 💻
Here’s what’s in my toolbox:
| Category | Tools |
|---|---|
| Database |    |
| Programming & Libraries |       |
| Analytics & BI |        |
| Version Control |   |
| Frameworks |  |
| Tools & Platforms |    |
Here are my verified certifications from top platforms:
- 🧾 Excel Skills for Business – Macquarie University
- 🧾 Programming for Everybody (Python) – University of Michigan
- 🧾 Preparing Data for Analysis with Excel
- 🧾 Python Foundations for Data Analysis
- 🧾 MySQL Data Analysis
- 🧾 Microsoft Copilot for Excel
- 🧾 Data Visualization with Matplotlib & Seaborn
- 🧾 Data Analysis with Python & Pandas
- 🧾 Cloud Basics for Data Professionals
💡 "Transforming complex data into intelligent solutions that drive business success"
⭐ Thanks for stopping by! Don’t forget to check out my projects and give them a ⭐ if they spark your interest!