Portfolio - Abhishek manohar | Codebasics

Powered by
Codebasics DA Bootcamp

Abhishek manohar

Data Analyst

EMAIL

[email protected]

PHONE

+91 8886390364

About Me

I’m a Data Analyst currently working in the transportation industry, with hands-on experience in Power BI, Microsoft Fabric, Excel, and SQL. My work focuses on building data solutions that support business operations, streamline reporting, and enable data-driven decision-making.

I’ve been actively involved in end-to-end report development—right from understanding business requirements to designing interactive dashboards and optimizing performance. I also work with SharePoint-based data sources, automate processes using Power Automate, and integrate insights into day-to-day business workflows.

My recent projects involve working with large operational datasets, identifying trends, and delivering actionable insights tailored to real-time logistics and supply chain needs. I'm continuously expanding my knowledge in modern data platforms and enjoy applying analytics to solve real business problems efficiently.

1

Excel Project

4

PowerBI Projects

1

SQL Project

Key Skills

Stakeholder management

Power bi

Excel

Python

Data Cleaning

Data Modeling

MySQL

Microsoft Fabric

Power Automate

Power Apps

Business Requirement Gathering

Visualization

My Projects

My Experience

Data Analyst | PBL Transport Pvt Ltd | (Jan 2025 - Present) Orchestrated seamless integrations in all stages of Power BI project lifecycles; analyzed complex datasets leading findings to fix three biggest causes impacting slow reporting times for faster business intelligence delivery. • Delivered five comprehensive Power BI reports and dashboards focused on critical transportation KPIs, which enhanced decision-making speed by 45% and improved resource allocation across the fleet. • Conducted deep-dive analytics on fuel efficiency, route optimization, and penalty forecasts, uncovering key cost-drivers and saving operational costs

Let's Work Together!

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

[email protected]

Call Me

+91 8886390364

LinkedIn

https://www.linkedin.com/in/abhishek-manohar-926a51258/

GitHub

https://github.com/Abhishekmanohar1

Excel Project

Sales Analytics

Domain/Function: Sales and finance

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect the their target

View Project
Engagement

View Project
on GitHUB

Sales Analytics

This visual shows the net sales performance of various customers for AtliQ Hardwares from 2019 to 2021, highlighting the percentage growth.

Sales Analytics

This visual displays the Profit and Loss (P&L) analysis for AtliQ Hardwares by market, including Net Sales, COGS, Gross Margin, and GM%.

Project Details

The goal of this project was to provide the sales and finance teams with key insights into their business performance. By analyzing sales data, the project aimed to identify trends, improve decision-making, and support strategic planning.

Sales View: The reports created for the sales team focused on metrics such as net sales, customer segmentation, and product performance. This helped the team to better understand their market and optimize their sales strategies.
Finance View: For the finance team, the reports provided insights into financial metrics like revenue, gross margin, and profitability. These insights were crucial for budgeting, forecasting, and ensuring financial health.
Skills Learned:
During this project, I honed my skills in Excel, specifically in using Power Query for data transformation and DAX basics for calculations. Additionally, I leveraged Power Pivot to create complex data models, enabling the generation of detailed and insightful reports.

PowerBI Project

Business insights 360

Domain/Function: Business Intelligence (BI) and Analytics

Implementing a project for AtliQ Hardware to enhance transparency and data-driven decision-making across markets and functions, aiming to deliver a 10% increase in profits by transitioning from instinct-based to data-backed insights using Power BI

View Project
Engagement

Business insights 360

User-empathetic landing page as a part of Dash board design

Business insights 360

Data modeling involving 10+ tables

Project Details

This project, titled "Business Insights 360," focuses on enabling data-driven decisions across various markets and functions for AtliQ Hardware which could be used by stakeholders. It involves developing a Power BI dashboard that delivers actionable insights across key business areas:

Finance: In-depth analysis of profitability, expense management, and financial health to support informed decisions.
Sales: Performance metrics, trends, and growth opportunities to optimize strategies and achieve targets.
Marketing: Insights into campaign effectiveness, customer engagement, and market penetration to drive better marketing decisions.
Supply Chain: Detailed analysis of inventory, logistics, and supplier performance for efficient, cost-effective operations.
Executive: A consolidated view of key metrics across all business functions, aiding strategic decision-making at the highest level.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality analysis

Domain/Function: Hospitality

AtliQ Grands owns several five-star hotels across India and has been in the hospitality industry for 20 years. Recently, they have been losing market share and revenue in the luxury/business hotels category due to competition and poor management decisions.

View Project
Engagement

View Project
on GitHUB

AtliQ Hospitality analysis

The dashboard display hotel performance metric like revenue, occupancy rate, ADR, and RevPAR trends by city, room type, and booking platform over time

AtliQ Hospitality analysis

The image displays a data model with tables connected by key fields like property_id and room_id, supporting analysis of bookings, rooms and dates

Project Details

This challenge involved designing a comprehensive dashboard aimed at helping revenue managers make informed business decisions.

Throughout this journey, I had the opportunity to dive deep into the 𝐇𝐨𝐬𝐩𝐢𝐭𝐚𝐥𝐢𝐭𝐲 𝐃𝐨𝐦𝐚𝐢𝐧, exploring how revenue flows, uncovering key trends, and understanding the insights that truly drive strategic decision-making. The process was both eye-opening and rewarding, as I gained a clearer picture of how data can empower businesses to optimize their operations.

🛠 Tools Used:
• Visualization: Power BI
• Backend: Excel

📈 Skills Acquired:

➡️ETL mastery
➡️Data transformation with Power Query
➡️Data modeling
➡️Creating DAX measures for KPIs
➡️Dashboard design

𝗟𝗲𝗮𝗿𝗻𝘁 𝘁𝗵𝗶𝗻𝗴 𝗳𝗿𝗼𝗺 𝘁𝗵𝗶𝘀 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 :
1.Deep understanding of Domain knowledge how RevPar, ADR, Occupancy% plays a very important role in getting insights to revenue management.
2.Comparison on Key performance indicators with respect to pervious Month/Week.

Project video

Live Interactive Dashboard

PowerBI Project

Electric vehicles Analysis

Domain/Function: Automotive

Challenge : Analyze and provide insights on launching electric vehicles in India, focusing on market trends, consumer preferences, and growth opportunities.

View Project
Engagement

View Project
on GitHUB

Electric vehicles Analysis

The map highlights EV sales in India, with Maharashtra and Karnataka leading, while northern and rural areas have lower adoption rates.

Electric vehicles Analysis

The dashboard shows 2M EVs sold in India. Ola Electric leads 2-wheelers, while Tata Motors dominates the 4-wheeler market with 61.81% share.

Project Details

The project focused on AtliQ Motors, a USA-based EV giant with 25% market share in electric and hybrid vehicles in North America. As part of their India expansion, where their market share is below 2%, Bruce Haryali, head of AtliQ Motors India, tasked the analytics team with a deep dive into the Indian EV/Hybrid market. Abhishek, the data analyst, took on the challenge to deliver actionable insights.

🛠 Key Learnings: ➡️India’s growing shift to EVs, shown by the penetration rate %. ➡️Understanding of CAGR for future forecasting. ➡️Using map visualizations to bring insights to life.

📊Insights Delivered: Regions like Maharashtra and Karnataka had the highest EV penetration, while rural areas lagged behind.
📄Impact on Business: The analysis will guide AtliQ Motors' expansion strategy, focusing on areas with higher EV adoption and tailoring product offerings for the Indian market.

Project video

Live Interactive Dashboard

SQL Project

Executive Insights through SQL: Enhancing Data-Informed Decision-Making for AtliQ Hardwares

Domain/Function: Consumer Goods

This project focuses on providing key insights for AtliQ Hardwares' executive management through SQL analysis. By addressing 10 ad hoc business requests, it aims to enhance data-driven decision-making. A creative presentation showcases findings, enabling smarter and quicker management decisions.

View Project
Engagement

View Project
on Code basics

Executive Insights through SQL: Enhancing Data-Informed Decision-Making for AtliQ Hardwares

The SQL query uses a CTE to simplify monthly gross sales calculations and aggregates the data by fiscal year for clearer insights and performance.

Executive Insights through SQL: Enhancing Data-Informed Decision-Making for AtliQ Hardwares

The SQL script creates a new column fiscal_quarter using the ALTER clause and updates it based on the month of the date, assigning quarters Q1 to Q4.

Project Details

I was tasked with tackling 10 ad hoc business requests for AtliQ Hardware’s executive management using SQL, which tested both my technical SQL skills and my ability to effectively present complex insights to top-level management in a creative and engaging way.

Here’s what I did:

🔖 Ran SQL queries to address key business questions.
🔖 Generated clear, actionable insights to help executives make quick, data-driven decisions.
🔖 Designed a C-suite presentation showcasing data in an easily digestible format.

SQL skills learned:

🔖 Stored Procedures: Automated recurring queries for efficient reporting.
🔖 Views: Simplified complex joins into virtual tables for easier analysis.
🔖 Functions: Built reusable logic for metrics like revenue growth and profit margins.
🔖 CTEs: Organized nested queries for better readability and performance.

This project reinforced the importance of blending technical proficiency with strong communication skills.

Project video

PowerBI Project

Shield Insurance Analysis

Domain/Function: Insurance

Developed a Power BI dashboard for Shield Insurance during my internship at Atliq Technologies, tackling limited data-driven decision-making. The dashboard offered month-on-month insights into revenue and customer trends, empowering Shield Insurance to make informed, strategic business decisions.

View Project
Engagement

Shield Insurance Analysis

This Power BI data model connects customer, policy, premium, and settlement tables to analyze key metrics like revenue trends and settlement rates.

Shield Insurance Analysis

User-empathetic landing page as a part of Dash board design

Project Details

This challenge involved designing a comprehensive Power BI dashboard aimed at empowering Shield Insurance to make informed, data-driven business decisions.

Throughout this project, I explored the Insurance Domain, diving into customer trends and revenue insights, which were crucial for guiding strategic decisions. This experience allowed me to understand how real-time data can be transformed into actionable insights to optimize operations. It was both insightful and rewarding to see how data visualization can drive better decision-making.

📊 Insights Delivered: The dashboard enabled management to optimize strategies, potentially driving a 20% increase in revenue. It highlighted key trends, empowering faster strategy adjustments.

📄 Business Impact: This project enhanced Shield Insurance’s decision-making speed, improved performance tracking, and strengthened data-driven strategies, positioning them for greater growth and efficiency.

Project video

Live Interactive Dashboard