Portfolio - Akhil Reddy

Excel Project

Sales and Finance Analytics

Created 2 reports for the sales and finance team which will help them to understand the customer and market performance with respect to their target and also generated a comprehensive P & L report for AtliQ hardware FY 2022.

View Project
Engagement

View Project
on GitHUB

market performance vs target.

profit and loss statement by markets.

Project Details

In this project, I created a sales and finance analysis reports that focuses on Customer performance, net sales, profit & loss and market performance that enable businesses to identify potential business expansion opportunities and to determine effective customer discounts. The reports will provide actionable insights for businesses to optimize their sales strategies.

Key learnings from this project:

1. Conditional Formatting
2. Power Query
3. Pivot table and power pivot
4. Sales and Finance Business Knowledge
5. Report beautification

Conclusion:
Overall this project aims to provide insights to businesses to evaluate and enhance their sales and finance activities.

PowerBI Project

Business insights 360

In this project, I have created an user interactive BI dashboard using Power BI that provides insights for AtliQ Hardwares. AtliQ hardware is a consumer electronics company which is struggling to compete with other companies as most of their data is in the form of excel.

View Project
Engagement

Home Page

Data modelling (Relationships b/w tables)

Project Details

My goal in this project is to create a user interactive BI report which can be used by stakeholders from sales, marketing, finance and executive team to make informed decisions.

Key learnings from this project:

1. Power query (data cleaning and transformation)
2. Data modelling (establishing relationships b/w tables)
3. DAX
4. Conditional Formatting
5. Dashboard designing principles
6. Bookmarks in power BI
7. Power BI service
8. Sales, finance, marketing metrics.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad hoc Requests

This is an SQL project as a part of Code basics challenge. I have written SQL codes for AD-hoc requests provided as part of the challenge for AtliQ Hardwares.

View Project
on GitHUB

2020 Quarter with maximum quantities sold

Products with highest and lowest manufacturing cost

Project Details

In this project, I have written SQL codes for some AD-hoc requests so that the output results can be used by the stakeholders to make smart and informed business decisions. The project will provide actionable insights for businesses to optimize their business strategies.

Key learnings from this project:
- Data Retrieval from single table (SELECT, WHERE, FROM)
- Data Retrieval from multiple tables (JOINS)
- Subqueries, Co-Related Subquery, CTE - Common table expressions
- Database Creation & updates (INSERT, UPDATE, DELETE)
- ERD - Entity Relationship Diagram, Primary key, Foreign key
- User-Defined SQL Functions, Stored Procedures
- Data Types (INT, CHAR, VARCHAR, DOUBLE......)
- How to improve the performance of the query
- Database Views and Window Functions (OVER, RANK, ROW_NUMBER, DENSE_RANK

Conclusion:
Overall this project aims to provide insights to businesses to make smart and informed decisions.

PowerBI Project

Sales Insights Analysis

Created a dashboard for the Sales team of AtliQ hardware which will help them to understand their sales performance and make rightful data driven decisions.

Describes relationship between the tables

Shows the revenue trend over the years

Project Details

In this project, I have created a dashboard for the sales team that focuses on the revenue and sales quantity that that enable businesses to identify and determine the sales performance. The report will provide actionable insights for businesses to optimize their sales strategies.

Conclusion:
Overall this project aims to provide insights to sales team to make smart and informed decisions.

Live Interactive Dashboard

PowerBI Project

HR Data Analysis

In this project, I have created an user interactive BI dashboard using power BI that provides insights for HR team. HR team can make use of this dashboard to minimize their work time up to 3 hours daily.

Show how many employees are WFH over months

Shows attendance% of employees in day of week

Project Details

My goal in this project is to create an user interactive BI report which can be used by HR team from any company to make informed decisions.

Key learnings from this project:
- Dax measures
- calculated columns
- Parameters
- Functions

Conclusion:
Overall this project aims to deliver insights to the HR team to make better and informed decisions.

Live Interactive Dashboard

Excel Project

Road Accident Analysis

Created a dashboard using Excel and PivotTables for Road Accident Analysis which can be used by anyone to see and gain insights on Road Accidents based in UK.

View Project
on GitHUB

Compares Current vs previous year casualties

Shows casualties by Road Type

Project Details

In this Project, I have taken a sample dataset of Road Accidents and created a simple dashboard in Excel which can be used to gain insights on Road accidents.

Key learnings from this project:
- PivotTables
- Dashboards in Excel
- Charts

Conclusion:
Overall this project shows you road accidents based on vehicle type, weather conditions and so on.

Hello, I am

Akhil Reddy

2

3

1

About

Key

My

Sales and Finance Analytics

Business insights 360

Consumer Goods Ad hoc Requests

Sales Insights Analysis

HR Data Analysis

Road Accident Analysis

Contact Me

Email

Github

Linkedin

Call

Akhil Reddy

Download Resume