Portfolio - sudheendra nekkanti

Hello, I am

sudheendra nekkanti

Data analyst

About Me.

Welcome to my Data Analyst portfolio, where I bring a hands-on approach to diving into the data universe. As a business analytics grad, I’m all about digging into numbers, but not in a stuck-up way. I speak the language of data without the unnecessary jargon, using my skills in Excel, SQL, and PowerBI to make things straightforward. Seeking a role in a growth-focused organization, I aim to turn data insights into real-world solutions. This isn’t just about crunching numbers; it’s about making them work for the team. So, let's explore my portfolio together, where I decode the mysteries of data in a practical, approachable way. It's not rocket science – it's just making data work, one spreadsheet at a time.

1

Excel Project

4

PowerBI Projects

1

SQL Project

Skills.

python

SQL

DATABRICKS

HADOOP

APACHE SPARK

POWERBI

AZURE

Projects.

Awards & Certificate.

Data Analytics Consulting Virtual Internship

Data Analytics and Visualization Virtual Experience

Power BI Virtual Case Experience

Python for Data science and machine learning bootcamp

Microsoft Certified: Power BI Data Analyst Associate

Contact.

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.

Download CV

[email protected]

Call Me

+91 9121931440

https://www.linkedin.com/in/sudheendra-nekkanti/

GitHub

https://github.com/Sudheendra66/SQL-Project-Consumer-Goods-Ad-hoc-Insights

PowerBI Project

Business Insights 360

Atliq Hardware, a consumer goods electronics company, was grappling with data inefficiencies. They had outgrown Excel and urgently needed a more robust solution to analyze and leverage their massive dataset of 4 million transaction records. The mission was crystal clear: Create a dynamic dashboard t

Finance dashboard highlighting Total Net Sales, Gross Margin Percentage, and Net Profit Percentage,

Sales dashboard displaying customer, product performance and performance matrix over the period of time.

Project Details

Created a series of meticulously crafted dashboards within Power BI, each catering to a specific department's needs:
📊 Finance View: A financial compass that illuminated Total Net Sales, Gross Margin Percentage, and Net Profit Percentage, enabling a deep dive into trends and regional influences.
📊 Sales View: A powerhouse for tracking customer and product performance, unlocking opportunities for growth.
📊 Marketing View: A data-driven guide to optimize marketing strategies and maximize profitability, centered around product performance.
📊 Supply Chain View: An indispensable tool for assessing forecast accuracy, net error, and absolute error, invaluable for inventory management.
📊 Executives' Dashboard: A panoramic view summarizing key metrics from all departments, offering a 360-degree perspective on business performance.

Live Interactive Dashboard

PowerBI Project

UK ROAD ACCIDENT ANALYSIS

This project provides comprehensive insights derived from the examination of road accidents spanning the years 2021–2022. The focal point is a dynamic and intuitive Power BI dashboard that provides various key performance indicators (KPIs) and trends related to road accidents and casualties.

Showing Primary KPIs- Total Casualties, Total Accidents & their YOY growth, Total Casualties by Accident Severity

Showing Additional KPIs- Monthly Trends, Road Types, Area/Location & Day/Night Casualties, Total Casualties & Accidents by Location.

Project Details

Utilizing Power BI, the project focused on analyzing UK road accidents from 2021 to 2022. We emphasized key performance indicators (KPIs) such as total casualties, accidents, and their year-on-year (YOY) growth, alongside insights into the severity impact and vehicle involvement. Our detailed analysis covered monthly trends, road types, day/night casualty stats, providing a comprehensive view of road safety scenarios.

THE GOAL- Empowering decision-makers to take targeted actions for safer roads. Looking ahead, our plan involves integrating real-time data and predictive analytics to proactively enhance safety measures.

This project analysis serves as a foundation for informed decision-making and future road safety strategies."

Live Interactive Dashboard

PowerBI Project

ADVENTURE WORKS

Using Power BI and Adventure Works data, I crafted an in-depth dashboard providing actionable insights on sales trends, customer behaviors, and product performance across bikes, accessories, and clothing, illuminating opportunities for strategic business decisions.

Weekly product analysis and pricing's impact on profits. The radar chart illustrates monthly performance compared to set targets.

Customer Details dashboard provides analysis on evolving customer revenue trends.

Project Details

This Power BI dashboard dissects Adventure Works' sales landscape. The Executive Dashboard provides a concise overview, emphasizing accessory and bike sales, surpassing the $1.83 million revenue target. Notably, the 30 oz water bottle and Mountain 200 Black bike stand out.

The Map page offers a geographic view of order distribution across continents.

In the Product Details section, we delve into weekly product analysis and pricing's impact on profits. The radar chart illustrates monthly performance compared to set targets.

The Customer Details segment delves into evolving customer trends, highlighting revenue peaks in June 2017 and a high-value customer in the average income segment.

PowerBI Project

Spotify Most streamed songs Analysis

Dive deep into tracks across different years, identifying top hits and artists based on various indicators. This dashboard allows you to compare musical characteristics, understand the dynamics of music popularity, and witness how these elements evolve over time.

View Project
Engagement

Showing top tracks and artists according to number of streams, danceability, speechiness, and bpm.

showing the top tracks and artists according to the release year and energy of the song.

Project Details

Let's explore music together! I've looked at lots of songs from different years to see how music has changed. The goal is to find cool insights, highlight awesome songs, and spot trends that shaped music.

Now, you get to play with a dashboard that lets you:

1. Find the best songs and artists using different things like how many people listened, the year it came out, how danceable it is, and more.
2. Compare what makes songs and artists different from each other.
3. Figure out how popular songs connect with different traits.
4. See how music traits change over the years.
I used some cool tools like Python to make the data better, Glassmorphism for the look, Power BI for the dashboard, HTML for personalized cover art, and DENEB Visuals to make sense of things. It's not just numbers; it's a trip through the history of music. Join in and let's explore the beats and vibes together!

Live Interactive Dashboard

Excel Project

Coffee Sales Dashboard

Revolutionize your coffee business with our dynamic Excel dashboard! Gain key insights into sales trends, customer behavior, and regional preferences. Leverage visualizations like line charts, column charts, and slicers to make informed decisions and drive strategic growth.

Showcasing coffee sales over time, country according to the order date

showing the top 5 customers by country and time.

Project Details

"Explore the world of coffee sales with our comprehensive Excel dashboard! Visualize Total Sales by Coffee Type over time through an intuitive line chart, identifying popular brews and seasonal trends.

The Top 5 Customers column chart reveals key patrons, aiding in personalized marketing and retention strategies. Gain a holistic perspective on business performance with Total Sales for 3 Available Years.

This dynamic dashboard extends its capabilities with a geographical lens, showcasing sales distribution across the United States, Ireland, and the United Kingdom. The versatile timeline feature allows users to analyze data over various intervals—years, months, quarters, or specific dates. Three slicers further refine data:

💠 The Size Slicer enables exploration of coffee product size variations.
💠 The Loyalty Card Slicer indicates customer affiliation with loyalty programs.
💠 The Roast Type Slicer categorizes coffee products into Dark, Light, or Medium roasts.

SQL Project

Consumer Goods Ad-hoc insights

Atliq Hardware, a leading computer hardware producer, sought to enhance data-informed decision-making by expanding its data analytics team. As an applicant, I undertook a SQL challenge to address 10 ad hoc requests and create a presentation for top-level management.

View Project
Engagement

View Project
on GitHUB

Slide showing the top 5 customers who received an average high pre_invoice_discount_pct for the fiscal year 2021 and in the Indian market.

The visualization on the slide displays the monthly gross sales amounts for a specific customer "Atliq Exclusive".

Project Details

Atliq Hardware is a leading manufacturer of computer hardware in India and other nations, but it struggles to make prompt and wise choices based on data. The management intends to add more junior data analysts to the data analytics team. Tony Sharma, the head of data analytics, conducts a SQL challenge to identify applicants with both technical and soft skills.

🛠️ Tools Used:

1. SQL for data querying
2. Power BI for data visualization
3. PowerPoint for presenting insights
📝 Key Learnings:

1. Utilizing advanced SQL techniques such as CTEs, Case statements, and Window functions.
2. Importing and modeling data in Power BI to create insightful visualizations.
3. Crafting engaging PowerPoint presentations to effectively showcase insights.