Powered by
Codebasics DA Bootcamp

Dhiraj Mahato

Data Analyst

+91 9234738250 [email protected]

Resume

Hello, I am

Dhiraj Mahato.

1

Excel Project

3

PowerBI Projects

1

SQL Project

About Me

I’m Dhiraj Mahato — a data-driven problem solver who turns messy data into meaningful answers. Where others see rows and columns, I see patterns, root causes, and opportunities for growth. At AtliQ Technologies, I’ve tackled real business challenges in sales performance, financial forecasting, and supply chain efficiency. Using tools like Excel and Power BI, I’ve built dashboards that don’t just look good — they tell stories and spark action. Whether it’s improving customer insights, identifying profit leaks, or helping businesses boost their digital presence, I thrive on solving the “why” behind the numbers. I’m also building a digital consulting agency to help brands unlock the power of analytics, design, and smart strategy. For me, every dataset is a puzzle — and I love solving it.

Key Skills

Excel

PowerBI

Effective Communication

SQL

Problem Solving

Python

Pandas

Matplotlib

My Projects

My Experience

Aug 2025 – Present
Data Analyst Intern | AtliQ Technologies, Hyderabad

Designed and deployed 10+ interactive Power BI dashboards to monitor key business KPIs, including sales performance and customer retention — reducing manual reporting time for stakeholders by 25%.
Partnered with cross-functional teams to clean, transform, and optimize large datasets using SQL and Excel, leading to a 30% improvement in data reliability and reporting accuracy.
Contributed to strategic business decisions by delivering actionable insights through data visualization and storytelling.
Demonstrated strong analytical thinking and communication skills in a fast-paced, data-centric environment.

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

5 Star on mySQL

5 Star on mySQL

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/analystdhiraj/

+ 91 9234738250

https://github.com/dhirajmahato67

Excel Project

Financial report of AtliQ

Domain/Function: Financial Report

This Excel project for AtliQ Hardwares delivers a powerful financial report. It features Customer Net Sales Performance (2019–2021) with filters for region, market, and division, plus a 2021 Market Performance Target analysis with region and division filters, enabling data-driven decisions.

View Project
Engagement

View Project
on GitHUB

Financial report of AtliQ

The Customer Net Sales sheet shows sales trends (2019–2021) with filters for region, market, and division, enabling detailed performance analysis.

Financial report of AtliQ

The Market Performance Target sheet tracks 2021 targets with region and division filters, aiding performance evaluation and strategic planning.

Project Details

This Excel project is a game-changer for AtliQ Technologies, empowering smarter financial tracking and driving business growth. The Customer Net Sales Performance sheet dives into sales trends from 2019 to 2021, with intuitive filters for region, market, and division. It enables AtliQ to pinpoint top-performing areas, uncover hidden opportunities, and craft strategies to maximize revenue.

Meanwhile, the Market Performance Target sheet focuses on 2021 goals, providing a crystal-clear view of progress with region and division filters. This dynamic tool helps AtliQ Hardware stay on track, adapt quickly, and achieve their business objectives. With actionable insights at their fingertips, AtliQ is better equipped to make informed decisions, boost financial efficiency, and accelerate growth like never before.

PowerBI Project

AtliQ Hospitality Management

Domain/Function: Hospitality

This dynamic Power BI dashboard empowers AtliQ with actionable insights for smarter decisions. Key features: 📊 Revenue Analysis – Track occupancy, ADR, and revenue. 📈 Performance Metrics – Monitor customer satisfaction & efficiency. 🔍 Filters – Analyze by year, region, property. 📌 Visuals

View Project
Engagement

AtliQ Hospitality Management

📊 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Track occupancy rates, average daily rates, and total revenue effortlessly.

AtliQ Hospitality Management

🔍 𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗲 𝗙𝗶𝗹𝘁𝗲𝗿𝘀: Analyze data by year, quarter, region, and property for granular insights.

Project Details

This dynamic Power BI dashboard is designed to empower AtliQ with actionable insights and elevate their decision-making. Key features include:

📊 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Track occupancy rates, average daily rates, and total revenue effortlessly.
📈 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗠𝗲𝘁𝗿𝗶𝗰𝘀: Gain insights into customer satisfaction, operational efficiency, and service quality.
🔍 𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗲 𝗙𝗶𝗹𝘁𝗲𝗿𝘀: Analyze data by year, quarter, region, and property for granular insights.
📌 𝗩𝗶𝘀𝘂𝗮𝗹 𝗘𝘅𝗰𝗲𝗹𝗹𝗲𝗻𝗰𝗲: Custom visualizations for instant clarity and informed decisions.
🚀 𝗘𝗻𝗵𝗮𝗻𝗰𝗲𝗱 𝗙𝗼𝗿𝗲𝗰𝗮𝘀𝘁𝗶𝗻𝗴: Predict trends to stay ahead in a competitive market.

Live Interactive Dashboard

SQL Project

Executive Management - Consumer Goods

Domain/Function: Consumer Goods

🚀 Driving Business Growth with My Project 🔍 Market Insights – Mapped Atliq Exclusive in APAC. 📈 Product Trends – Compared 2021 vs. 2020 growth. 💰 Cost Optimization – Identified high/low-cost products. 🏆 Customer Focus – Ranked top 5 by discounts. 📊 Sales Analysis – Tracked trends for forecast

View Project
Engagement

View Project
on GitHUB

Executive Management - Consumer Goods

This is a sql queries for one solution, there is total 10 queries for this each solution, for more visit Github

Executive Management - Consumer Goods

this is a visualization of one queries, there is total 10 visualization for each solution, for more visit live dashboard

Project Details

Ad hoc requests help businesses gain quick, valuable insights to drive smarter decisions. AtliQ Technologies uses them to optimize sales, streamline operations, and boost profitability by answering critical questions beyond routine reports.

PowerBI Project

Business Insights 360

Domain/Function: Business Insights

🚀 Just completed a Power BI project turning raw data into actionable insights! 📊 Dive into Sales, Finance, Marketing & Supply Chain dashboards with interactive filters by year, region & customer. 🔍 Explore live dashboards packed with trends, KPIs & performance metrics!

View Project
Engagement

Business Insights 360

This is a home page, where there is available Finance view, Sales view, Marketing view, Supply chain view, Executive View.

Business Insights 360

This is screenshot of Marketing view

Project Details

🚀 Just wrapped up a comprehensive 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 Project that transforms 𝗱𝗮𝘁𝗮 𝗶𝗻𝘁𝗼 𝗮𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀! 🎉 You can check out the 𝗹𝗶𝘃𝗲 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 of my project to explore these insights in action! Here's a sneak peek of what's included:

🎯 𝗦𝗮𝗹𝗲𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱:
-📋 Customer & Product Performance Table
-🥧 Pie Charts of Unit Economics
-📊 Scatter Plot: Performance Matrix

💰 𝗙𝗶𝗻𝗮𝗻𝗰𝗲 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱:
-💵 Net Sales, Gross Margin %, Net Profit %
-📋 Profit & Loss Statement
-📈 Net Sales Trends Over Time
-📌 Top/Bottom Customers by Net Sales

📢 𝗠𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱:
-🌍 Regional & Customer Performance Table
-🥧 Unit Economics Pie Chart
-📊 Performance Matrix Scatter Plot

📦 𝗦𝘂𝗽𝗽𝗹𝘆 𝗖𝗵𝗮𝗶𝗻 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱:
-📊 Forecast Accuracy %, Net & Absolute Error
-📋 Key Metrics: Customer & Product Tables
- Scatter Graph: Accuracy vs. Error

✨ 𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗲 𝗙𝗶𝗹𝘁𝗲𝗿𝘀

Live Interactive Dashboard

PowerBI Project

Bharat Herald's post-COVID data analysis

Domain/Function: Media & Entertainment (Print & Digital News Industry)

Analyzed Bharat Herald’s post-COVID decline to design a data-driven digital transformation strategy. Examined print circulation, ad revenue, and digital readiness using Power BI, delivering insights to rebuild trust, boost revenue, and enable digital growth.

View Project
Engagement

Bharat Herald's post-COVID data analysis

This is the financial page of this project.

Bharat Herald's post-COVID data analysis

This is the Digital performance of this project.

Project Details

Project: Bharat Herald – Post-COVID Business & Digital Transformation Analysis

Conducted an in-depth analysis of Bharat Herald, a 70-year-old newspaper facing steep declines in print circulation and ad revenue after COVID-19. Using Power BI, I analyzed multi-year trends in sales, ad categories, and city-level performance to identify causes of revenue loss and digital readiness gaps. Designed a data-driven roadmap for digital transformation—recommending mobile-first content, subscription models, and influencer-based credibility campaigns. Delivered an interactive Power BI dashboard and executive presentation highlighting strategies to rebuild advertiser trust, improve operational efficiency, and accelerate Bharat Herald’s transition from a legacy print business to a sustainable digital media powerhouse.

Project video

Live Interactive Dashboard