Portfolio - Dinesh S

Dinesh S

Data Analyst

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

About Me

Welcome to my portfolio!

I'm a data analyst with a background in computer science and an ongoing MBA in Business Analytics. I’ve built real-world projects using Power BI, SQL, Excel, and Python across domains like hospitality, consumer goods, finance, and OTT.

My work includes full-stack analytics apps, executive dashboards, and automated reports that deliver insights and improve business performance.

I'm currently seeking entry-level or internship roles as a Data Analyst, BI Analyst, or Business Analyst where I can apply my skills and grow further.

Key Skills

Effective Communication

Data Visualization

Stakeholder Management

Problem Solving

Decision Making

Presentation skills

My Projects

Sales and Finance Analysis

Domain/Function: FMCG Sector

Business Insights 360

Domain/Function: FMCG Sector

Hospitality Analysis

Domain/Function: Hospitality Sector

Strategic Merger Analysis - OTT Platform

Domain/Function: Telecom & Streaming Services

AD HOC Insights

Domain/Function: Consumer Goods

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

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.

Download Resume

Resume

Mail Me

[email protected]

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

Call Me

+91 8778939790

GitHub

https://github.com/Dinesh281197

Excel Project

Sales and Finance Analysis

Domain/Function: FMCG Sector

Created reports for sales and finance teams to evaluate customer performance, optimize discount strategies, analyze profitability, and identify market expansion opportunities.

View Project
on GitHUB

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

P&L by Fiscal Year: Helps stakeholders analyze net sales, costs, and profitability trends over the years to support strategic financial decisions.

Project Details

In this project, I created a sales and financial report using Excel tools like Pivot Tables, Power Query, and DAX functions. The report helps businesses optimize discount strategies, support customer negotiations, and identify expansion opportunities while providing insights into profitability and cost management.

𝐊𝐞𝐲 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬:
● Optimize sales strategies and enhance customer satisfaction
● Identify growth opportunities and maximize revenue
● Monitor key financial metrics like gross margins and COGS

𝐊𝐞𝐲 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬:
● Pivot Tables for data summarization
● Power Query for data transformation
● DAX for basic calculations
● Conditional Formatting for visualization
● Report Beautification for clear insights
● Sales and finance domain metrics

This project empowers businesses to monitor, evaluate, and enhance sales activities, unlocking growth and staying competitive.

PowerBI Project

Business Insights 360

Domain/Function: FMCG Sector

AtliQ Hardware, a rapidly expanding consumer electronics company, struggles to compete due to Excel-based reports. My goal is to implement a Power BI solution to deliver insights and support informed decisions.

View Project
on GitHUB

Other Tools

SQL

MS Excel

DAX Studio

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to create one report that could be used by stakeholders from sales, marketing, finance, Supply Chain, and executive teams. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

𝐈 𝐥𝐞𝐚𝐫𝐧𝐞𝐝 𝐭𝐡𝐞 𝐟𝐨𝐥𝐥𝐨𝐰𝐢𝐧𝐠 𝐭𝐡𝐢𝐧𝐠𝐬 𝐢𝐧 𝐭𝐡𝐢𝐬 𝐩𝐫𝐨𝐣𝐞𝐜𝐭

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

Domain/Function: Hospitality Sector

AtliQ Grands, a prestigious 5-star hotel chain in India, is experiencing a dip in revenue and market share. The company's goal is to halt the losses, enhance customer satisfaction, and reclaim its market dominance. I will be using Power BI to help them achieve their goal.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Performance Overview: Visualizes Revenue, RevPAR, and Occupancy. Filters enable analysis by city and booking platform for data-driven insights.

Revenue Analysis: Visualizes Revenue, RevPAR, and Occupancy. Filters enable analysis by city and booking platform for data-driven insights.

Project Details

As a data analyst, I was tasked with developing a business intelligence solution for AtliQ Grands, a five-star hotel chain seeking to regain market share. Using historical data, I created a comprehensive dashboard in Power BI to provide actionable insights.

𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭: Designed an interactive dashboard consisting of three key sections:

• 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰: High-level summary of key metrics, enabling quick assessment of overall performance.

• 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: Detailed breakdown of revenue by city, platform, and room class, identifying key revenue drivers and areas for improvement.

• 𝐁𝐨𝐨𝐤𝐢𝐧𝐠 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: Exploration of booking patterns, including occupancy rates, cancellation rates, and booking platform performance, to optimize booking strategies.

𝐊𝐞𝐲 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬:
•DAX Proficiency
•Data Visualization
•Critical Thinking
•Decision-Making
•Stakeholder Management
•Business Intelligence

Project video

Live Interactive Dashboard

PowerBI Project

Strategic Merger Analysis - OTT Platform

Domain/Function: Telecom & Streaming Services

Lio, a leading telecommunications provider in India, is planning a strategic merger with Jotstar. My goal is to gain insights that will help the management make Informed decisions to establish Lio-Jotstar as the leading OTT platform in India

View Project
Engagement

View Project
on GitHUB

Other Tools

MY SQL

𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧 𝐓𝐫𝐞𝐧𝐝𝐬 𝐚𝐧𝐝 𝐑𝐞𝐯𝐞𝐧𝐮𝐞: Insights of plan migration dynamics, month-over-month upgrade, and downgrade rates, etc.

𝐔𝐬𝐞𝐫 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐚𝐧𝐝 𝐄𝐧𝐠𝐚𝐠𝐞𝐦𝐞𝐧𝐭𝐬:Provides insights about Active rates, watch Time trends, User Distribution, etc.

Project Details

The project's primary goal is to gain insights into individual platform
performance, content consumption patterns, subscriber growth, Inactivity behavior, upgrade
and downgrade trends

𝐈 𝐜𝐫𝐞𝐚𝐭𝐞𝐝 𝐚 𝐜𝐨𝐦𝐩𝐫𝐞𝐡𝐞𝐧𝐬𝐢𝐯𝐞 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐭𝐨 𝐩𝐫𝐨𝐯𝐢𝐝𝐞 𝐚𝐜𝐭𝐢𝐨𝐧𝐚𝐛𝐥𝐞 𝐢𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐜𝐨𝐧𝐬𝐢𝐬𝐭𝐢𝐧𝐠 𝐨𝐟 𝐟𝐨𝐮𝐫 𝐬𝐞𝐜𝐭𝐢𝐨𝐧𝐬:

Performance Overview
User Insights and Engagements
Subscription Trends and Revenue
Content Library and Language Analysis

𝐊𝐞𝐲 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬:

Domain Knowledge of the OTT Industry
SQL Expertise
Power Query (Basic and Advanced Operations)
DAX Proficiency
Power BI Visualization

Project video

Live Interactive Dashboard

SQL Project

AD HOC Insights

Domain/Function: Consumer Goods

AtliQ Hardwares, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis and Power BI for creating clear, actionable insights.

View Project
Engagement

View Project
on GitHUB

View Project
on PowerPoint

Other Tools

Excel

This visualization highlights the specific markets within the APAC region where 'Atliq Exclusive' operates, offering a clear snapshot of its regional

This visualization highlights the top 5 customers in the Indian market who received the highest average pre-invoice discount percentages during the fi

Project Details

Title: AD HOC Insights

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.

My Task:
As a hypothetical applicant, I
► Reviewed 'ad-hoc-requests.pdf' with 10 business queries.
► Crafted and executed SQL queries.
► Developed a Power BI and PowerPoint presentation to showcase insights to top management.

Approach: Utilized MySQL for data retrieval and analysis. Employed Power BI for impactful visualizations. Designed a professional presentation to communicate findings and recommendations effectively.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical and communication skills.