Portfolio - Mohan Ram P

PowerBI Project

Business Insights 360 with Power BI

Empowering AtliQ Hardware's Growth with Data Analytics! The project targets comprehensive insights across finance, sales, marketing, and supply chain to meet stakeholder queries and enhance overall business efficacy.

View Project
Engagement

View Project
on GitHUB

Streamlining decisions with critical metrics—operational costs, gross margins, and net profits.

Delivered actionable insights, facilitating strategic decision-making and contributing significantly to the company's sales growth strategy.

Project Details

AtliQ Hardware embraces data-driven success with our cutting-edge analytics project, unlocking new opportunities and informed decisions. Powerful YTD, YTG, and LE measures via Power Query facilitate efficient analysis, complemented by seamless STAR and Snowflake data modeling. Tailored views for Finance, Sales, Marketing, and Supply Chain enhance decision-making. Our executive view delivers zone-specific insights and risk management for impactful visuals.

#DataAnalytics #PowerBI #BusinessGrowth #EfficientAnalysis #DataDrivenDecisions

Live Interactive Dashboard

PowerBI Project

An innovative data-driven project for Shield Insurance!

Led data analytics exploration for Shield Insurance, leveraging Power BI insights. Revealed Offline Agents' sales dominance, optimizing strategy for growth.

View Project
Engagement

View Project
on GitHUB

An innovative data-driven project for Shield Insurance!

Provided a overview of Shield Insurance's performance through key metrics and visualizations, enabling strategic insights and trend identification.

Assessed sales modes, highlighting Offline Agents as the major contributor, demonstrating a strong market presence and effectiveness.

Project Details

The Shield Insurance project is a comprehensive data analytics endeavor aimed at gaining valuable insights into the company's performance. Through powerful data visualization and analysis, we explore key metrics such as revenue trends, customer distribution, and policy preferences. The project harnesses the potential of Power BI to present these findings in a clear and impactful manner. With a focus on data-driven decision-making, this project aims to empower Shield Insurance with actionable information to optimize strategies and enhance customer satisfaction.

Project video

Live Interactive Dashboard

Excel Project

Dynamic Sales Reporting System: Optimizing Performance and Driving Growth with Excel

Transformed FMCG market dynamics with adept use of Excel's Power Query, Pivot Table, and DAX. Crafted growth-centric strategies and user-friendly reports for actionable insights.

Explore financial performance by region and country, comparing actuals with 2021 targets in USD.

Analyze performance percentages (%) to assess variances in achieving 2021 targets across regions and countries.

Project Details

I crafted a robust sales report in Excel, empowering businesses to navigate customer discounts, refine communication strategies, and identify growth prospects. This report not only advises on optimizing sales but also prioritizes customer satisfaction and revenue generation.

Key Proficiencies Gained:

1. Excel's specialized table utilization
2. Strategic data manipulation techniques
3. Fundamental mathematical analysis for data insights
4. Designing visually appealing and informative reports

This project is centered around arming businesses with essential tools to analyze, comprehend, and elevate their sales strategies. By leveraging sales data, companies can uncover improvement opportunities, foster growth, and stay competitive in a dynamic market landscape.

SQL Project

Extracting Ad-Hoc Insights with AtliQ Hardware

Successfully navigated MySQL to handle 10 crucial ad-hoc inquiries raised by AtliQ Hardware's top management. Extracted valuable insights from a complex database housing approximately 1 million sales records distributed across 6 tables.

SQL script gauges AtliQ Hardware's unique product growth (2020 vs. 2021). Efficient, precise, actionable insights.

Condensed SQL script identifies top-grossing channel for AtliQ Hardware in FY2021. Displays sales and contribution percentage succinctly.

Project Details

Project Overview: AtliQ Hardware Data Insights

Business Goals: AtliQ Hardware, an innovative hardware company in India, seeks quick insights for smarter decision-making.

Data Hub: Leveraging a MYSQL database housing around 1 million sales records, our project dives into the core of AtliQ Hardware's sales landscape.

Analytical Approach: Using advanced SQL techniques like CTEs and window functions, we swiftly respond to 10 unique ad-hoc queries, unraveling valuable insights for our stakeholders.

Practical Impact: The project distills complex data into straightforward insights, providing executives with actionable information for immediate decision-making.

This initiative not only meets our stakeholders' needs but also marks a step forward in fostering a data-informed culture at AtliQ Hardware.

Hello, I am

Mohan Ram P

2

1

1

About

Key

My

Business Insights 360 with Power BI

An innovative data-driven project for Shield Insurance!

Dynamic Sales Reporting System: Optimizing Performance and Driving Growth with Excel

Extracting Ad-Hoc Insights with AtliQ Hardware

Contact Me

Email

Github

Linkedin

Call

Mohan Ram P

Download Resume