Portfolio - Peter joy

Excel Project

Excel Sales Analytics

I led a sales analytics project using Excel, creating an interactive report with dynamic filters for region, division, and customers. A meticulously designed Excel pivot table summarized data, empowering quick insights and informed decisions, making it a valuable tool for business growth.

View Project
on GitHUB

In Excel, I ranked top and bottom 5 products by total quantity sold across regions, divisions, and customers, using conditional formatting.

In Excel, I analyzed 2020-2021 product revenue across regions, divisions, and customers, using formatting for a concise two-year market comparison.

Project Details

Project Title: Sales Analytics

Project Overview:
The "Sales Analytics" project aimed to provide business owners with actionable insights from historical sales data. It emphasized simplicity, accuracy, and visual appeal, employing advanced techniques like conditional formatting for optimal presentation.

Project Benefits:
The "Sales Analytics" project equipped the team with expertise in data analysis and visualization tools and techniques, including:

DAX Language: Mastery of Data Analysis Expressions (DAX) for advanced calculations and data modeling.
M Language: Proficiency in M language for data transformation and manipulation within Power Query.
Pivot Tables: Effective utilization of pivot tables for dynamic data summarization and reporting.
Conditional Formatting: Skillful implementation of conditional formatting to emphasize critical data points and trends.

PowerBI Project

Growth Analysis of Telangana

During a @CodeBasics challenge, I completed a Power BI project that provided critical insights to the Telangana government using open data sources. The project's primary focus was on analyzing vehicle and revenue growth trends.

View Project
Engagement

Home page of the project with actionable icons ,description and data loaded time

Data modelling and connections of the project

Project Details

As part of a @CodeBasics challenge, I completed a Power BI project delivering insights to the Telangana government using Open Data Telangana. Our project boasts an intuitive home page with actionable icons. Key insights include district-wise investment analysis, a 'Trend View' for sector-based growth trends over years, stamp revenue growth analysis, and vehicle growth categorized by class and fuel type. Additionally, we analyze industrial growth across districts. Users can filter data by fiscal year, quarters, and months, with separate views for each category for easy access and visualization. This Power BI project is a powerful tool for data-driven governance, empowering the Telangana government with actionable insights for strategic planning and decision-making.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Creating an integrated business intelligence platform centralizing data from finance, sales, marketing, and supply chain for valuable insights across departments, enhancing decision-making.

View Project
Engagement

Dynamic Home page of the project with icon description and data refreshed date

Data modelling and connections of the project

Project Details

Empowering comprehensive business insights through a Power BI solution, our project incorporates advanced techniques like calculated columns, DAX measures, dynamic data modeling, bookmarks, and page navigation. Additionally, we've integrated robust data validation and visualization practices, including KPI indicators and conditional formatting. With a strong focus on financial metrics such as gross price, net sales, and gross margin, our tool allows users to analyze Year to Date and Year to Go performance across various fiscal years and quarters. Furthermore, seamless integration with Power BI Services enables effortless report sharing, while setting up a personal gateway ensures data auto-refresh for up-to-the-minute decision-making. This dynamic platform equips finance, sales, marketing, supply chain, and executive departments with actionable insights for informed, agile, and growth-focused strategies.

Live Interactive Dashboard

SQL Project

Executive Management

I presented Insights on 10 ad-hoc business requests to the executive management team, by querying the million rows database using SQL. Insights from my presentation have the potential to reduce overall operational costs by approximately 10 % significantly.

View Project
Engagement

What is Atliq hardware and Why analyzing data

The 10 Questions that Atliq Hardware need answers

Project Details

Augmenting Data-Driven Decision-Making at Atliq Hardware

Overview:
Atliq Hardware, a leading computer hardware manufacturer in India, aims to improve data-informed decision-making by recruiting junior data analysts.

Your Role:
Review 'ad-hoc-requests.pdf' comprising ten essential insight requests. Execute SQL queries to address these requests and create compelling presentations.

Resources:
You'll have dataset access, metadata, hints, and presentation templates.

Tools Used:
MySQL for data querying, PowerPoint for presentation development.

Impact:
Engaged in this project to master vital data analytics skills like SQL operations, advanced concepts, and effective presentation techniques

Hello, I am

Peter joy

1

2

1

About

Key

My

Excel Sales Analytics

Growth Analysis of Telangana

Business Insights 360

Executive Management

Awards

Contact Me

Email

Github

Linkedin

Call

Peter joy

Download Resume