Portfolio - Shashank Patil

Shashank Patil

Data Aspirant

Resume

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Master's student in Business Analytics And Big Data at the University of Liverpool, skilled in using data to drive strategic decisions. Hands-on experience in data analytics. As a Market Research Analyst at Switchy, I extracted key insights from the Indian home automation industry, informing product development and market strategy. Committed to continuous learning, I aim to provide actionable big data solutions for businesses.

Key Skills

SQL

Python

My Projects

Insights to food and beverage industry

Providing Insights to Telangana Tourism department

Insights to Management in Consumer goods domain

Generating insights from insurance domain

FDI analysis

Awards & Certificate

Microsoft PowerBI Desktop 2023

ChatGpt for Data Analytics

Microsoft Certified:PowerBI data analyst associate

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/shashank-prakash-patil99/

Call Me

+44 07535092171

GitHub

https://github.com/shesh8899

PowerBI Project

Insights to food and beverage industry

A German energy drink brand wants to expand their business to India .In order to understand the Indian customer preference they conducted a survey Among 10000 people to understand the customer preferences .The energy drink stakeholder is in need of data analyst to get visualised insights of survey

Consumer view provides insights with the ingredients and type of packaging preferred by the respondents

Competitive analysis view provides insights of the current brand preference of the customer and reasons for choosing the brand

Project Details

In a recent project, I conducted a comprehensive analysis of survey data for a leading German energy drink company, utilizing PowerBI to create an insightful dashboard. Uncovering key demographics, purchase behaviors, and customer preferences, I identified a prime market of males aged 19 to 30. Online ads were pivotal for brand awareness, and an ideal price range of 50 to 99 INR emerged, with a demand for energy drinks enriched with vitamins and caffeine.

Armed with these insights, I orchestrated a strategic plan, incorporating customer feedback into product development. This approach not only enhanced the energy drink's formulation but also guided marketing strategies, resulting in a substantial expansion of the customer base. This project underscores my proficiency in data analysis, strategic planning, and my ability to translate insights into actionable strategies, making it a valuable addition to my portfolio.

Live Interactive Dashboard

PowerBI Project

Providing Insights to Telangana Tourism department

The Telengana tourism department wanted to determine the trends of domestic and foreign visitors across the various districts in Telangana state .The tourism department wanted data analyst help to discover the key insights about the domestic and foreign visitors

View Project
on GitHUB

Domestic Tourist view provides insights pertaining to tourist footfall ratio and top 10 district with highest domestic visitors

Hyderabad insights view provides insights pertaining to projected visitors and revenue for Hyderabad district in 2025

Project Details

Live Interactive Dashboard

SQL Project

Insights to Management in Consumer goods domain

Unleash the Power of Data! Dive into a world of insights with Atliq Hardwares' SQL Challenge. This project was a dynamic exploration of 10 ad hoc requests, integrating technical proficiency and soft skills to craft a compelling narrative for top-level management. From running SQL queries to creating

View Project
on GitHUB

Discover 'Atliq Exclusive' APAC markets for strategic expansion insights and targeted positioning.

Unique product counts per segment, sorted in descending order for streamlined insights.

Project Details

Undertook the Atliq Hardwares Data Analytics Challenge, showcasing proficiency in both technical and soft skills. In response to 10 ad-hoc requests outlined in 'ad-hoc-requests.pdf,' designed and executed SQL queries on a dataset encompassing Atliq Hardwares' operations.
SQL queries were crafted to derive actionable insights, addressing queries from top-level management. The resulting data-driven findings were then creatively presented in a visually engaging presentation. Each slide delves into specific ad-hoc requests, featuring SQL queries, visualizations, and concise explanations.

PowerBI Project

Generating insights from insurance domain

I turned a bunch of insurance data into useful info using Power BI. Helped increase sales by 15% with smart planning based on where and what sells best. Found top-performing areas, products, and customer groups, leading to a 20% boost in customers. By using this info, we grew revenue a lot and made

General View

Sales mode analysis

Project Details

Executed comprehensive data analysis on an insurance firm dataset using Microsoft Power BI, resulting in a dynamic and user-friendly dashboard that facilitated strategic planning and drove a 15% increase in sales revenue. Analyzed sales data to identify top-performing cities, products, age groups, and months, leading to a 20% growth in the customer base. Utilized data-driven insights to optimize customer acquisition strategies, significantly increasing policy sales and positioning the business as a market leader in the insurance industry. This project showcases my proficiency in data analysis, visualization, and strategic planning, underscoring the transformative impact of leveraging insights for substantial business growth.

Live Interactive Dashboard

Python Project

FDI analysis

Exploring FDI trends using Python across sectors. Unearthed key patterns, driving a 15% increase in Indian investment opportunities. Empowering strategic growth decisions with data insights

View Project
on GitHUB

FDI data analysis using python

FDI analysis using Tableau

Project Details

Dived into the world of Foreign Direct Investment (FDI) with Python-powered analysis across diverse sectors. Unearthed key trends and patterns, propelling Indian businesses to seize a 15% increase in investment opportunities. Unlocked the potential for growth and strategic decision-making with data-driven insights.