Portfolio - Hardika Bhalala

Hardika Bhalala

Data Analyst

Resume

3

PowerBI Projects

2

SQL Projects

1

Python Project

About Me

Hi, welcome to my Portfolio! I am Hardika, a data enthusiast. My passion to play with data and derive meaningful insights helps stakeholder to arrive on data driven decision for their business. With my postgraduate degree, I bring a unique interdisciplinary approach to data analysis. My proficiency with tools like Python, Power BI and SQL, coupled with my ability to communicate insights effectively to stakeholders, has consistently contributed to the success of my projects.
I am driven by a passion for uncovering actionable insights from data and i am always eager to tackle new challenges that require a blend of analytical rigor and scientific knowledge. Lets connect and explore the exciting possibilities to contribute to the success of your team

Key Skills

Excel

power BI

MySQL

My Projects

Consumer goods ad-hoc analysis

Domain/Function: Consumer goods

Business insight dashboard for Finance, sales, Marketing and Supply chain

Domain/Function: Brick & Morter and E-commerce

Avocado price prediction

Domain/Function: food and agriculture

Energy drink survey

Domain/Function: Food and beverages

Revenue analysis of hospitality domain

Domain/Function: Hospitality domain

Cricket data analysis

Domain/Function: Cricket

My Experience

September 2023 - October 2023

Exposes data lab - intern

Developed a ML model for profit prediction of 50 startup companies

June 2021 - August 2021

TUV Nord India - Jr. analyst

Gathered and analyzed data on food samples, from different customers for various attributes and maintained databases on LIMS.
Created visual representation of data findings using MS excel and power BI to communicate insights to stakeholders.

May 2015 - March 2018

Tata chemicals innovation Centre - Research assistant

Conducted data extraction of over 500 food samples, performed statistical analysis and data visualization in Microsoft excel.
Designed Impactful reports and presentation and communicated to the Scientific community.

Awards & Certificate

Workshop on Cricket Data Analysis using PostgreSQL, NPTEL

The Complete SQL Bootcamp: Go from Zero to Hero, Udemy

Internship from Epoxys data lab

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/hardika-bhalala/

Call Me

+91 9850023306

GitHub

https://github.com/hardikabhalala

SQL Project

Consumer goods ad-hoc analysis

Domain/Function: Consumer goods

Atliq hardware is one of the major manufacturer of computer hardware. There are 10 ad-hoc requests for which the company needs insights. Need to provide a solution for ad-hoc requests.

View Project
on GitHUB

SQL query output for total sold quantity by quarters in FY 2020 and its visual presentation derived using Power BI

SQL query code for total sold quantity by quarters in FY 2020

Project Details

#About Company: AtliQ Hardwares (imaginary company) is one of the major computer hardware manufacturers in India, with a strong presence in other nations.

#Background : The management noticed that they do not get enough insights to make quick and smart data-informed decisions.

#Problem: There are 10 ad-hoc requests for which the company needs insights.

#Approach: Run a SQL query to answer these requests. Convert it into visualizations and present the Insights to the top level management.

PowerBI Project

Business insight dashboard for Finance, sales, Marketing and Supply chain

Domain/Function: Brick & Morter and E-commerce

Atliq Hardware is consumer electronic company, rapidly expanding but most of their reports still in Excel. They wanted to use Power BI for data driven decision making and to reduce time. My goal is to implement advanced analytical solution that will reduce time and cost and get insights.

View Project
on GitHUB

User-empathetic landing page of dashboard design.

Finance dashboard

Project Details

In this project, the goal is to be able create dashboard which will be used by stakeholders to undertake actions required in Sales, Finance, Marketing, Supply chain and Executive level of the company in which it is lacking.

The project focuses, mainly on:

Intriguing Data Modelling
User-empathetic Report Design
Drillable Insights

learned the following things in this project:
1. Power Query (Basic and Advanced Operations)
2.Basic and Complex DAX formula
3.Data modelling involving 10+ tables
4.Choosing the right visuals and formatting
5.Dashboard designing principles
6.Using bookmarks
7.Deploying in Power BI service
8.Stakeholder Feedback Implementation
9.Sales, Marketing, Finance & Supply Chain metrics.

Live Interactive Dashboard

Python Project

Avocado price prediction

Domain/Function: food and agriculture

Avocados are widely used by millennials. By using the dataset. predicted the price of avocado and evaluated the model using various regression algorithm.

View Project
on GitHUB

Information about the data set

Visualized data and got insights using Matplotlib and seaborn library

Project Details

In this project developed and evaluated the model for predicting the price of avocado by using various regression models
steps followed: -
• Data preprocessing and data cleaning
• Feature engineering to extract relevant feature
• Visualization of different patterns and relationship between variables
• Performed EDA
• Applied various regression algorithm
• Train and evaluate the model to get best accuracy

PowerBI Project

Energy drink survey

Domain/Function: Food and beverages

Insights of Codex(A German beverage company), They launched their energy drink in 10 cities. Conducted a survey. As a data analyst conduct an analysis and provide actionable recommendation for codex marketing team

View Project
on GitHUB

Overview of how Codex brand is performing in those 10 cities

overview of performance of different Marketing strategy and packaging preference of consumers

Project Details

Codex is a germen beverage company. They recently launched theit energy drink in 10 cities of india. The marketing team of codex wanted to increase brand awareness, Market share, and product development. so, they conducted a survey in these 10 cities.

Task : Conduct an analysis of survey and provide an actionable recommendation for codex chief marketing officer.

As a data analyst my main goal is to conduct a drive a meaningful insights that can increase brand awareness, increase market share, Product development, identify target consumer.

Live Interactive Dashboard

PowerBI Project

Revenue analysis of hospitality domain

Domain/Function: Hospitality domain

This project gives insights of revenue analysis of the Atliq grand hotels. As a data analyst i made a dashboard that gave insights to the revenue team

View Project
on GitHUB

Overview of revenue analysis of hotel business

revenue analysis

Project Details

AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.

Their revenue management team had decided to hire a 3rd party service provider to provide them with insights from their historical data.

Live Interactive Dashboard

SQL Project

Cricket data analysis

Domain/Function: Cricket

This project is an analysis of the ICC world cup 2023.The project aims to answer various questions related to the cricket tournament, such as performance of different teams, Players, Venues, etc.

View Project
on GitHUB

View Project
on

Questions related to data answered using MySQL

SQL query

Project Details

This project contains 6 different tables, information about the tournament, Bowling and Bating performance.