Powered by
Codebasics DA Bootcamp

HEMANTH S

Data Aspirant

+91 9066617897 [email protected]

Resume

Hello, I am

HEMANTH S.

4

PowerBI Projects

1

Excel Project

1

Python Project

About Me

👋 Hi there! I'm Hemanth, a passionate data analyst with a diverse portfolio of projects spanning Excel, SQL, Power BI, and Python.

I've dedicated myself to transforming complex data into actionable insights that drive informed business decisions. My projects showcase my proficiency in handling data across various platforms and my ability to deliver impactful solutions.

Feel free to explore my project portfolio on GitHub and LinkedIn, where I've documented my journey in data analytics and visualization. I'm always eager to connect with fellow professionals and discuss how we can leverage data to achieve strategic goals.

My expertise lies in transforming complex data into actionable insights, enabling businesses to make informed decisions.
I am passionate about continuous learning and staying up-to-date with BI trends and technologies. This commitment allows me to bring innovative solutions to the table and drive the success of my projects.

Key Skills

SQL

Python

My Projects

Awards & Certificate

Accenture North America Data Analytics and Visualization Job Simulation on Forage

Accenture North America Data Analytics and Visualization Job Simulation on Forage

SQL Basic

SQL Intermediate

SQL Intermediate

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

+ 91 9066617897

https://github.com/HemanthSh

PowerBI Project

Adventure works dashboard

Discover insights with the Adventure Works Power BI Dashboard! Analyze sales performance, monitor revenue vs. targets, track YoY growth, and explore customer behavior trends. Interactive reports facilitate strategic decisions and optimize sales strategies for enhanced business outcomes.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Adventure works dashboard

Europe's Data: Bookmark to view and analyze data specific to Europe.

Adventure works dashboard

Revenue vs Target: Comparison of revenue achieved versus the set target. YoY Growth: Year-over-year growth in the revenue. Order Qty vs Target.

Project Details

Explore the Adventure Works Power BI Dashboard, meticulously crafted to analyze sales data with precision and clarity. This comprehensive dashboard leverages the robust Adventure Works dataset to visualize key performance indicators (KPIs) and trends. From monitoring revenue against targets to identifying customer behavior patterns, the project empowers stakeholders with actionable insights for informed decision-making and strategic optimizations.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: Business Intelligence and Data Analytics

Transforming AtliQ Hardware's traditional reports into dynamic Power BI dashboards, this project leverages advanced analytics to drive strategic decision-making across key departments, enhancing visibility, efficiency, and profitability.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

Excel

DAX studio

Business Insights 360

Homepage

Business Insights 360

Sales report page

Project Details

AtliQ Hardware, a consumer electronics company, embarked on a journey to enhance its competitive edge through advanced data analytics. By integrating data from MySQL into Power BI, this project creates comprehensive dashboards for departments like Sales, Finance, Marketing, Executive, Supply Chain, and Logistics. The analysis focuses on key metrics such as Net Sales, Gross Margin, Net Profit, and COGS, offering a real-time view of business performance. This transformation from static Excel reports to dynamic, interactive dashboards empowers AtliQ Hardware to make informed decisions, optimize operations, and drive strategic growth across the organization.

Live Interactive Dashboard

Excel Project

AtliQ Hardware Sales and Finance report

Domain/Function: Business Intelligence and Data Analytics

Leveraging Excel's advanced features, this project transforms AtliQ Hardware's raw data into actionable insights. We've created detailed reports on sales, finance, and market performance, enabling data-driven decision-making and enhancing the company's competitive edge.

View Project
on GitHUB

AtliQ Hardware Sales and Finance report

Entity Relationship diagram

AtliQ Hardware Sales and Finance report

Top 10 Products

Project Details

AtliQ Hardware, a leader in consumer electronics, sought to turn its vast data into strategic business insights. This project utilizes Excel's powerful functions like VLOOKUP, XLOOKUP, Index Matching, and Power Query to create comprehensive reports that analyze key aspects of the business. From Customer Net Sales to P&L FY, Top 5 Products to Market Performance vs. Target, these reports provide a deep dive into the company's financial and operational health. By focusing on metrics like GM % by Quarter and tracking new product launches, the project equips AtliQ Hardware with the tools to make informed decisions, optimize operations, and maintain its competitive advantage.

PowerBI Project

Post-5G Launch Analysis: Unlocking Telecom Trends with Power BI

Domain/Function: Telecommunications Analytics

This project analyzes AtliQo's telecom data using Power BI and Excel to compare key performance indicators (KPIs) before and after the 5G launch in May 2022. The analysis aims to uncover trends in user behavior, revenue changes, and market share dynamics to guide strategic decisions.

View Project
Engagement

View Project
on GitHUB

Post-5G Launch Analysis: Unlocking Telecom Trends with Power BI

Dashboard overview

Post-5G Launch Analysis: Unlocking Telecom Trends with Power BI

Revenue & Plan performance

Project Details

The Telecom Data Analysis project focuses on AtliQo, a leading telecom provider in India, which launched its 5G plans in May 2022. Following the launch, AtliQo observed a decline in active users and revenue growth. This project utilizes Power BI and Excel to conduct a comprehensive analysis of key performance indicators (KPIs) from before and after the 5G launch. The dataset includes information on cities, dates, internet plans, revenue, active users, and market share. By comparing these metrics across different time periods, the analysis aims to identify trends, evaluate the impact of 5G on AtliQo's business, and provide insights for optimizing internet plans and improving user engagement. The findings offer valuable recommendations to help AtliQo regain its market position and drive growth in a competitive telecom industry.

Live Interactive Dashboard

PowerBI Project

Email Network Analysis: Understanding Company Dynamics

Domain/Function: Organizational Communication Analytics

This project analyzes internal email communications within a company using Power BI, Excel, and ZoomCharts. The goal is to uncover communication patterns, detect informal networks, and assess sentiment across departments and seniority levels, providing insights into organizational dynamics.

View Project
Engagement

View Project
on GitHUB

Email Network Analysis: Understanding Company Dynamics

Overview of the Total emails along with their sentiments and platforms count through which they have been sent

Email Network Analysis: Understanding Company Dynamics

Email Interaction with Email tracking, Email metrics, Email lifecycle

Project Details

The Email Communication Analysis project is part of the global DataDNA initiative by Onyx Data, focusing on understanding internal communication within an organization. Using Power BI, Excel, and ZoomCharts, this project examines email exchanges to reveal key communication patterns, informal networks, and the sentiments expressed across different departments and seniority levels. The dataset includes detailed information on email senders and receivers, topics, sentiments, and whether emails were sent during or outside of work hours. By analyzing this data, the project aims to identify influential individuals, assess the tone of internal communications, and uncover potential areas for improving collaboration and employee engagement. The insights derived from this analysis can help organizations optimize communication flows, enhance workplace culture, and make data-driven decisions to foster a more connected and efficient work environment.

Live Interactive Dashboard

Python Project

Hospitality Analytics: Unveiling Trends with Python

Domain/Function: Hospitality Analytics

This project involves analyzing a hospitality dataset using Python to calculate occupancy rates, explore booking trends, and evaluate revenue across multiple properties of AtliQ Grands, a leading hotel chain in India.

View Project
on GitHUB

Hospitality Analytics: Unveiling Trends with Python

Room bookings through various platforms

Hospitality Analytics: Unveiling Trends with Python

Occupancy percentage and types of room class

Project Details

The Hospitality Data Analysis project leverages Python's Pandas library to explore and analyze data from AtliQ Grands, a prominent hotel chain with properties in major Indian cities like Delhi, Mumbai, Hyderabad, and Bangalore. The analysis focuses on key metrics like occupancy rates, booking trends, and revenue across various room categories and booking platforms. By diving deep into the data, this project aims to uncover insights that can help optimize hotel operations, enhance customer satisfaction, and boost revenue. The findings provide valuable recommendations for improving booking success rates and maximizing occupancy, making it a vital tool for strategic decision-making in the hospitality industry.