Skip to content
View ManoharManu1999's full-sized avatar

Block or report ManoharManu1999

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ManoharManu1999/README.md

Banner

Hi there, I'm Manohar K.

Data Analyst | SQL • Python • Power BI

Portfolio Website


🚀 Professional Summary

Data Analyst with 4+ years of experience driving operational efficiency in the telecom sector. I specialize in transforming raw, complex datasets into actionable business insights that improve decision-making.

  • 📊 Design and optimize end-to-end SQL solutions (Joins, CTEs, Window Functions)
  • 📈 Develop interactive Power BI dashboards for business decision-making
  • 🧠 Focus on revenue analysis, customer segmentation, and ETL pipeline design
  • 💼 Experience across Telecom operations, Retail, Hospitality, and Job Market analytics
  • 📫 Reach me at: manoharmanu.k1999@gmail.com

💥 Impact Highlights

  • 🚀 Built and deployed dashboards tracking 25+ critical business KPIs.
  • Improved data analysis efficiency using SQL automation and reusable queries.
  • 📉 Identified key revenue trends, seasonal patterns, and customer segments across retail and hospitality domains.
  • 🏗 Designed end-to-end ETL workflows, data warehousing architectures, and validation pipelines.

⭐ Featured Projects

Click on any project title to view the full repository and code.

Preview Project Business Impact & Description Tech Stack
Adventure Works Adventure Works Dashboard Designed a multi-page dashboard tracking KPIs, regional performance, and high-margin customer segments. Power BI, DAX
SQL Data Warehouse SQL Server Data Warehouse Architected an end-to-end data warehouse utilizing Medallion Architecture and robust ETL pipelines. SQL Server, ETL
Maven Movies Maven Movies Acquisition Analysis Simulated due diligence to evaluate revenue stability, inventory risk, and customer lifetime value (CLTV). MySQL, CTEs
AtliQ Hospitality AtliQ Hospitality Data Analysis Performed EDA on booking data to uncover revenue trends and occupancy patterns. Python, Pandas
PAN Data Validation PAN Data Validation Pipeline Built a pipeline to validate and clean data using regex, duplicate detection, and quality checks. PostgreSQL, Regex
Maven MegaMart Maven MegaMart Retail Analysis Analyzed millions of transactions to identify key revenue drivers and seasonal sales patterns. Python, Seaborn

📂 Other Projects

  • 👉 SQL Music Store Analysis
    • Exploratory analysis using window functions to derive customer insights.
    • Tools: PostgreSQLSQL
  • 👉 U.S. Data Analyst Job Trends
    • Explored tech skills, job titles, and salary benchmarks from 2024 postings.
    • Tools: PythonPandasPlotly
  • 👉 Walmart Sales Analysis
    • Uncovered customer behavior patterns and top-performing product categories.
    • Tools: SQL ServerT-SQL
  • 👉 Data Jobs Market Dashboard
    • Built a comprehensive dashboard analyzing global job market trends and in-demand skills.
    • Tools: Power BIDAXPower Query

🧰 Tech Stack

Category Tools
Databases MySQL PostgreSQL SQL Server
Languages & Libraries Python Pandas NumPy Matplotlib Seaborn Plotly
BI Tools Power BI Excel DAX Power Query
Concepts ETL Data Warehousing Data Modeling EDA Data Validation
Tools Git GitHub Jupyter VS Code DBeaver Notion

📚 Currently Learning

  • Advanced Power BI: DAX optimization and performance tuning for large semantic models.
  • Data Engineering Concepts: Exploring ETL orchestration and robust data pipelines.
  • Data Workflows: API integration and automated data extraction.

🎓 Education

  • Bachelor of Science in Computer Science | Tumkur University (2017 - 2021)
    • Core focus on programming, databases, and analytical problem-solving.

📜 Certifications


📞 Let's Connect

LinkedIn Email

💡 "Transforming complex data into intelligent solutions that drive business success"

Pinned Loading

  1. Adventure-Works-Power-BI-Sales-Analytics Adventure-Works-Power-BI-Sales-Analytics Public

    End-to-end Power BI Business Intelligence dashboard built using Adventure Works data. Designed a star schema model, created advanced DAX measures, implemented What-if analysis, and built multi-page…

  2. SQL-Data-Warehouse-Project SQL-Data-Warehouse-Project Public

    End-to-end SQL Server Data Warehouse & Analytics project implementing the Medallion Architecture (Bronze, Silver, Gold). Demonstrates real-world ETL pipelines, data modeling, and analytics-ready tr…

    TSQL

  3. SQL-Maven-Movies-Project SQL-Maven-Movies-Project Public

    SQL-based acquisition due diligence case study analyzing revenue stability, inventory capital risk, and customer lifetime value in a two-store retail business.

  4. Python-Maven-Megamart-Retail-Analysis Python-Maven-Megamart-Retail-Analysis Public

    End-to-end retail acquisition analysis using Python, uncovering growth trends, customer behavior insights, and strategic expansion opportunities from 2M+ transactions.

    Jupyter Notebook

  5. SQL-PAN-Number-Validation-Project SQL-PAN-Number-Validation-Project Public

    SQL-based PAN data validation & data quality analysis using PostgreSQL. Implements cleaning, business-rule validation, and audit-ready reporting.

  6. AtliQ-Hotels-Data-Analysis AtliQ-Hotels-Data-Analysis Public

    Python-based EDA of hotel booking data uncovering revenue leakage, occupancy trends, and city-level performance insights.

    Jupyter Notebook