Palak Agrawal

Data Analyst

[email protected] +1 4253642943

Resume

Hello, I am

Palak Agrawal.

2

PowerBI
Projects

1

SQL
Project

About Me

Hi there,

I'm a Data Analyst with over 3 years of experience. I love digging into data using tools like Excel, PowerBI, and SQL. My professional journey has been a data-driven adventure. I've honed my skills, cultivated expertise, and created real impact through data analysis.

I invite you to explore these projects, each one showcasing my ability to turn raw data into actionable insights. In my portfolio, you'll discover a collection of my work where I've used these tools to uncover secrets hidden in data. These projects aren't just numbers; they're real examples of how I turn data into smart decisions.

Come explore these projects with me.

Key Skills

SQL

Power BI

ETL

DAX

Excel

Power Query

My Projects

Comprehensive Business Insights Dashboard: Finance, Sales, Marketing, and Supply Chain

Consumer Goods Analytics

AtliQ Sales Insights

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

AZ900

Certified Scrum Master

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.

Mail Me

[email protected]

https://www.linkedin.com/in/palak-agrawal/

Call Me

+1 4253642943

GitHub

https://github.com/palak01

PowerBI Project

Comprehensive Business Insights Dashboard: Finance, Sales, Marketing, and Supply Chain

AtliQ Hardwares, a fast-growing consumer electronics company, is facing challenges in the competitive market due to its reliance on Excel-based reporting. My objective is to introduce an advanced analytics solution powered by Power BI that will enable the company to get insights and make informed de

View Project
Engagement

Designing a welcoming landing page with users in mind as part of the dashboard

Working with more than 10 tables in data organization

Project Details

This project aims to create a unified report for stakeholders in sales, marketing, finance, and the executive team.
- It emphasizes three key aspects:
1. Robust Data Modeling
2. User-Centric Report Design
3. Drillable Insights

Throughout this project, I've gained valuable experience in:

1. Working with Power Query, including basic and advanced operations.
2. Mastering both basic and complex DAX formulas.
3. Handling data modeling involving over 10 tables.
4. Selecting appropriate visuals and applying effective formatting.
5. Dashboard designing principles
6. Utilizing bookmarks for enhanced user experience.
7. Deployment in Power BI Service.
8. Incorporating stakeholder feedback for continuous improvement.
9. Focusing on metrics in sales, marketing, finance, and supply chain.

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics

Presented insights on 10 ad-hoc business requests to the executive management team, by querying more than 1 million rows database using SQL. Findings - Important metrics such as Gross Profit, Contribution %, Order by Overall Amount Sold, Average Gross Sales, Average Manufacturing Cost, etc.

View Project
Engagement

View Project
on GitHUB

Which Quarter got the maximum total sold quantity in 2020?

Top 3 product in each division by total sold quantity

Project Details

1. In the Consumer Goods Domain' project at Atliq Hardware, I worked on their database. My job was to use data for making decisions, and I addressed ten specific requests to find useful insights.

2. What I found was a big increase in different products, with 'Notebooks' being the most popular. I also discovered patterns in sales throughout the year and saw how important the 'Retailer' channel is.

3. From this project, I learned that using data can help make smart decisions.

4. This project helped me get better at analyzing data, solving problems, and communicating my findings, making me a better data analyst

Skills Learned:

1.SQL Query Writing using CTE, rank, joins, date functions, sub-queries, numeric functions, etc.

2.Data Extraction and Transformation

3.Data Analysis and Interpretation

4.Report Generation

5.Problem Solving and Decision Making

PowerBI Project

AtliQ Sales Insights

AtliQ Hardware is a leading computer hardware and peripherals supplier in India, with a head office in Delhi and regional offices across the country. The aim of this project is to AtliQ hardware Sales Insights, which aims to analyze the sales of AtliQ hardware.

View Project
on GitHUB

Customer insights: Top 5 Customer, Revenue Trend etc

Updated dashboard with Profit Margin%, Profit Margin Contribution by customer etc.

Project Details

The business issue here is that the sales director facing challenges in tracking dynamic marketing growth, requiring accurate insights for informed decision-making. As a result he decided to build a PowerBI Dashboard for converting the data into visual representation to make data driven decisions. So, he hired a team of data people to complete this task.

Tools Used:
SQL Queries (MySQL Workbench): Extracted insights from the data.
Power BI: Used for ETL processes and visualizations to generate actionable insights.

Steps Followed in this project
1. Performed a High level analysis of data in SQL to get better understanding over the data.
2. Connected the SQL data set to PowerBI.
3. Performed ETL and data cleaning on the imported data.
4. In the currency there were two types of currencies in transactions, performed currency conversion to make all the currency type same
5. Created measure for needs and used them for creating visuals in PowerBi.