Prachi Jha

Data Analyst, Power BI developer

[email protected] +91 8709190366

Resume

Hello, I am

Prachi Jha.

2

PowerBI
Projects

1

Excel
Project

1

SQL
Project

About Me

Hello, I’m Prachi Jha!

With 3.5 years of experience, including 2 years in analytics, I specialize in transforming data into actionable insights. Proficient in Power BI, SQL, and Advanced Excel, I excel in building dynamic dashboards, improving reporting accuracy, and uncovering key trends.

Key achievements include:
➡️ Developing Power BI models to consolidate data, improving accuracy and efficiency.
➡️ Using advanced DAX for customized visualizations.
➡️ Managing market analysis with CRMs like Salesforce and Lead Squared, enhancing sales strategies.
➡️ Presenting clear insights to stakeholders.
➡️ Leveraging Excel (e.g., VLOOKUP, Pivot Tables) for actionable sales trends.

I’m eager to contribute as a Data Analyst or Power BI Developer to help organizations maximize their data potential.

Let’s connect to explore data analytics opportunities!

Key Skills

Power BI

SQL

Advanced Excel

Power Query

Data Validation

Problem Solving

DAX Queries

Data Analysis

My Projects

Business Insights 360

Domain/Function: Retail and E-commerce domain

Sales And Finance Analytics

Domain/Function: FMCG (Fast-Moving Consumer Goods)

Credit card financial analysis

Domain/Function: Customer analytics and financial insights

Consumer Goods Insights

Domain/Function: Consumer Goods

My Experience

UNACADEMY- Sr. Business Associate

• Collected data from various sources, including CSV files, Excel, SharePoint folders, and SQL databases, into the Power BI model, boosting analysis and reporting accuracy by 30%.

•Applied DAX functions and measures in Power BI to create complex data models, enhancing data visualization efficiency by 25%

• Handled ad-hoc requests and modifications on Power BI dashboards owned by other users, ensuring timely updates and increasing data representation accuracy.

• Drafted detailed Power BI dashboard documentation and led 5+ training sessions for end users; resulted in a 30% improvement in platform proficiency and improved data reporting accuracy by 20% across departments.

• Used advanced Excel functions (VLOOKUP, Pivot tables) for sales analysis.

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

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/prachi-jha-47139a1b5

Call Me

+91 8709190366

GitHub

https://github.com/Prachijha0197

PowerBI Project

Business Insights 360

Domain/Function: Retail and E-commerce domain

AtliQ Hardwares, a rapidly expanding consumer electronics company, faces challenges in competing with data-driven rivals, as most reports remain in Excel. My goal is to implement a Power BI-based analytics system to enable smarter decision-making and optimize their business performance.

View Project
Engagement

View Project
on GitHUB

Finance Insights: Discover essential financial metrics and trends revealed through the project's analytics dashboard for informed decision-making.

Data Model: Integrating over 10 tables for a comprehensive and interconnected analysis.

Project Details

In this project, I created a Power BI report for stakeholders in sales, marketing, finance, and executive teams. My focus was on building a robust data model that accommodates complex datasets while ensuring an intuitive, interactive design. This enabled drillable insights for informed decision-making.

I enhanced my skills in Power Query for advanced transformations and used both basic and complex DAX formulas for deeper analysis. The data model integrated over ten interconnected tables, with carefully selected visuals to convey key narratives. By applying dashboard design principles, I ensured clarity and impact, with features like bookmarks enhancing user experience.

The report was deployed via Power BI Service, incorporating stakeholder feedback for improvement. Analyzing vital metrics across departments has empowered teams to make data-driven decisions and drive business success, fostering a culture of analytical thinking.

Live Interactive Dashboard

Excel Project

Sales And Finance Analytics

Domain/Function: FMCG (Fast-Moving Consumer Goods)

This project analyzes AtliQ Hardware's financial performance and market position through reports like "Customer Net Sales Performance" and "Market Performance vs. Target." Utilizing Excel skills, it aims to provide actionable insights for informed strategic decision-making.

View Project
Engagement

View Project
on GitHUB

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

The Market Performance vs Target report allows stakeholders to evaluate how well the country is doing and compare it against the target.

Project Details

In this project, I've developed a dynamic sales report using Excel pivot tables, offering businesses invaluable insights into customer discounts, negotiation strategies, and untapped markets. These reports provide actionable recommendations, empowering businesses to refine sales tactics, elevate customer experiences, and maximize revenue.

Throughout this journey, I've honed skills in:
1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The primary goal is to arm businesses with the tools and insights needed to monitor, assess, and optimize their sales efforts. By leveraging data-driven analysis, businesses can uncover opportunities for growth, adapt to market changes, and maintain a competitive edge in an ever-evolving landscape.

PowerBI Project

Credit card financial analysis

Domain/Function: Customer analytics and financial insights

This project on credit card data analyzes customer demographics, transaction trends, and usage patterns. It provides insights into spending habits, risk analysis, and revenue metrics, helping credit card companies optimize marketing and manage customer risk effectively.

View Project
Engagement

View Project
on GitHUB

Credit card customer reports

Credit card transaction reports

Project Details

Objective: Analyze credit card transaction data to provide business insights such as revenue, spending behavior, and marketing effectiveness.
Data Source: Extract, transform, and load (ETL) data from various sources, ensuring clean and accurate input.
Key Metrics: Visualize key metrics such as transaction counts, quarterly revenue, and customer spending patterns.
Customer Segmentation: Segment customers based on demographics, usage patterns, and preferences.
Visualizations: Use Power BI to create interactive dashboards with metrics like revenue by expense type, card usage trends, and customer insights.
Advanced Features: Leverage DAX for calculations and Power Query for data transformation.
Impact: Enable data-driven decisions on improving credit card offerings, customer retention, and marketing strategies

Live Interactive Dashboard

SQL Project

Consumer Goods Insights

Domain/Function: Consumer Goods

AtliQ Hardwares, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis and Power BI for creating clear, actionable insights.

View Project
Engagement

View Project
on GitHUB

INTRODUCTION

DATA MODEL

Project Details

The Consumer Goods Ad-hoc Insights project by Codebasics centers on helping Atliq Hardware, a prominent computer hardware company, to leverage data-driven decision-making through a series of SQL queries and visual insights in Power BI. This SQL-based challenge, guided by Atliq’s Data Analytics Director Tony Sharma, presents nine key business questions aimed at analyzing performance across sales, customer segments, product profitability, market trends, and inventory management.

The project steps include:

1. Writing efficient SQL queries to respond to each business question.
2. Focusing on metrics like regional sales comparisons, customer behavior, and sales forecasting.
3. Presenting these insights to support Atliq’s strategic and operational decisions.