Powered by
Codebasics DA Bootcamp

Mohanakumaran S R

Data Analyst

+91 9344119878 [email protected]

Resume

Hello, I am

Mohanakumaran S R.

2

PowerBI Projects

1

Excel Project

About Me

Diligent Data Analyst with a fresh perspective, specializing in extracting actionable insights from complex data sets. With a foundation in Business Administration and experience in data analytics, I offer a blend of financial acumen and technical expertise. At TCS, I implemented practices that improved cash flow and reduced overdue payments. Proficient in Power BI, Tableau, Excel, SQL, and Python, I deliver high-impact data solutions. Notable projects include developing dashboards that optimized sales performance and drove revenue growth. I am eager to apply my skills to new challenges in data analytics.

Key Skills

MySQL

Tableau

Power BI

Excel

My Projects

Awards & Certificate

Visualise Data with PowerBI

Visualise Data with PowerBI

Tableau Training

Tableau Training

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/mohanakumaransr/

+ 91 9344119878

https://github.com/Mohanakumaran-SR

PowerBI Project

Hospitality Analysis - Hotel Chain Business

Developed a comprehensive dashboard for AtliQ Grands, a five-star hotel chain in India, to analyze historical data and regain market share. The dashboard includes key metrics and provides actionable insights to enhance strategic decision-making and revenue management.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Hospitality Analysis - Hotel Chain Business

This screenshot for AtliQ Grands shows key metrics like occupancy rates, average daily rates, and revenue per room, plus customer & trend analysis.

Hospitality Analysis - Hotel Chain Business

Insights at a glance: occupancy, rates, revenue, and customer analysis for AtliQ Grands' strategic growth.

Project Details

Developed a dynamic dashboard for AtliQ Grands, a renowned chain of five-star hotels in India, to combat declining market share and revenue. Leveraged historical data to create key performance metrics, as outlined by the stakeholders. The dashboard features occupancy rates, average daily rates, revenue per available room, and customer segmentation analytics. Additionally, it includes actionable insights beyond the provided metrics, such as trend analysis and competitive benchmarking. This data-driven approach equips AtliQ Grands with the intelligence needed to make informed strategic decisions, optimize revenue management, and enhance their competitive edge in the luxury hotel market.

Live Interactive Dashboard

Excel Project

AtliQ_Excel_Reports

AtliQ Hardware's Excel project enhances data-driven decisions in sales and finance. Using Power Query, Power Pivot, and DAX, it generates detailed performance and P&L reports. This approach improves sales monitoring, financial planning, and strategic decision-making.

View Project
on GitHUB

AtliQ_Excel_Reports

Compares actual market performance against targets with interactive charts, highlighting sales, revenue, and market share by region.

AtliQ_Excel_Reports

Breaks down financial performance by market, detailing revenue, expenses, and net profit, with interactive elements for deeper analysis.

Project Details

Project Overview:

Sales Report:
Objective: Create comprehensive customer performance and market performance vs. target reports.
Purpose: Enable businesses to monitor sales activities, identify patterns, and track KPIs.
Importance: Aid in decision-making for discounts, negotiations, and identifying expansion opportunities.

Finance Report:
Objective: Develop detailed Profit and Loss (P&L) reports by fiscal year, month, and market.
Purpose: Assess financial performance and support strategic decision-making.
Importance: Facilitate benchmarking, budgeting, and forecasting, aligning financial plans with goals.

Skills:
Technical: ETL methodology, Power Query, Power Pivot, DAX.
Soft: Sales and finance report comprehension, user-centric design, report optimization, systematic report planning.

PowerBI Project

Business 360 - Brick & mortar and e-commerce

AtliQ Hardware's PowerBI Project: Leveraging data insights across finance, sales, marketing, and supply chain to enhance decision-making. Tech: SQL, PowerBI, Excel. Key Components: Data modeling, KPIs, conditional formatting.

View Project
on GitHUB

Other Tools

SQL

Excel

Dax Studio

Business 360 - Brick & mortar and e-commerce

A centralized hub offering an overview of key metrics and navigation options, empowering users to delve into specific areas effortlessly.

Business 360 - Brick & mortar and e-commerce

A high-level snapshot tailored for top-level decision-makers, providing critical insights at a glance for swift strategic actions.

Project Details

Objectives:
Implement data analytics using PowerBI for informed decision-making.
Surpass competitors by leveraging data-driven insights.
Enhance performance across finance, sales, marketing, and supply chain.

Key Components:
Tech Stack: SQL, PowerBI Desktop, Excel, DAX Language, DAX Studio.
PowerBI Techniques: Data modeling, calculated columns, measures, dynamic visuals, KPI indicators, conditional formatting.
Business Context: Facing recent setbacks, AtliQ recognized the need for robust analytics to navigate market challenges and optimize operations.
Dataset Overview: Customer, product, sales, and forecast data across various markets and channels.
Project Kick-off: Align project objectives, success metrics, stakeholders' expectations, and design preferences.
Dashboard Design: Interactive visuals based on mockups to address stakeholder requirements.

Outcomes:
Improved decision-making through data-driven insights.
Enhanced operational efficiency and cost optimization.

Live Interactive Dashboard

Sales Insights – Brick & mortar business

Tableau Sales Dashboard compares regions' sales for better insights. Utilizes Sample Superstore data, visualizes key metrics, aiding decision-making. Enables dynamic region selection, target vs. actual sales comparison. Provides clear visuals, empowering strategic planning.

View Project
on GitHUB

Other Tools

Tableau

Sales Insights – Brick & mortar business

Dive into sales dynamics, comparing the Central & East regions. Explore trends, customer insights, and more for informed decisions.

Sales Insights – Brick & mortar business

Track revenue milestones effortlessly. Visualize sales trends, identify growth opportunities, and optimize strategies for success.

Project Details

The Tableau Sales Comparison Dashboard project facilitates sales analysis between two regions for a leading organization. Utilizing the Sample Superstore dataset, it offers a comprehensive visualization of key sales metrics, aiding decision-making and pinpointing areas for improvement.

Implemented parameters, calculated fields, and data organization enable dynamic selection and comparison of primary and secondary regions. The dashboard visualizes crucial metrics like total sales, average sales per order, customer count, orders, and products sold. It also includes a comparison of target versus actual sales to assess performance against goals.

Featuring clear visuals and interactive elements, the dashboard provides upper management with a holistic view of regional sales performance, supporting strategic planning and resource allocation. Ultimately, the project empowers decision-makers with actionable insights to optimize sales and foster business growth.