Hi, I am Purva Phalak!

About Me

Hello There!👋

Welcome to my portfolio! 😃

➺ I'm a Data Analyst with a passion for finding valuable insights hidden in complex data. With a foundation in Civil Engineering and a successful transition to the dynamic field of data analytics, I've developed solid skills in analyzing data, solving problems, and communicating effectively.

➺ Switching from Civil Engineering to data analytics has been an exciting journey where I've combined my problem-solving mindset with tools like 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐄𝐱𝐜𝐞𝐥, 𝐒𝐐𝐋 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫-𝐁𝐈.

➺ Some highlights of my work include:

➥ Analyzing, transforming and visualizing data using tools like Power BI and Excel.

➥ Writing SQL queries to extract and explore data effectively.

➥ Creating insightful dashboards to make decision-makinng easier.

➥ Transforming raw data into practical solutions for real-world problems.

➺ I developed my core skills through focused learning and hands-on practice, including internships at Cognifyz Technologies, Mentorness, and PwC. During these internships, I worked on projects like NREGA analysis (using Power-BI), Epidemic(Covid-19) Analysis(using MySQL), Customer Churn Analysis, and Diversity and Inclusion dashboards.

➺ These experiences helped me turn raw data into actionable insights, whether it was through designing interactive dashboards in Power BI or performing in-depth SQL analyses.

➺ Some of my favorite projects include tackling real-world challenges like analyzing Electric vehicle market trends and optimizing Twitter engagement strategies.

➺ My portfolio showcases the projects I've undertaken during internships and self-learning, reflecting my dedication to professional growth.

➺ I’m always eager to learn, grow, and collaborate on exciting projects. Let’s connect and create something amazing together!✨

My Projects

Excel

Sales & Finance Analytics || Excel

✦ Created detailed P&L reports for AtliQ Hardware, analysed $598.9M in annual sales, identifying a 9.2% shortfall to targets, and highlighting India as the largest market with $161.3M revenue.

• View Project

SQL

Corona Virus Analysis | MySQL

✦ Analysed 78,000 COVID-19 records in MySQL, highlighting over 90% recovery rates in top countries (India, Brazil, U.S.) and identifying a peak monthly death count of 401,893 in January 2021.

✦ Applied advanced data cleaning and transformation techniques to ensure accuracy, delivering insights critical for global health policy analysis and response strategies.

• View Project
• View Video Presentation

Music Store Analysis | MySQL

✦ Queried a music store dataset with attributes like genre, artist, and sales to identify top-performing genres and artists contributing to 60% of total revenue.

✦ Analyzed customer purchasing trends, revealing a 30% preference for digital downloads over physical albums and peak sales during festive seasons.

✦ Derived insights through SQL queries, uncovering correlations between album pricing, customer retention, and sales volume to optimize marketing strategies.

• View Project

Movie Analysis|| SQL

✦ Analyzed a movie dataset using SQL to assess box office success rates, identifying action and drama as top-performing genres contributing to 40% of total revenue.

✦ Evaluated audience preferences, revealing a positive correlation between high ratings and revenue for movies released during holiday seasons.

✦ Derived insights on release trends, finding that summer releases yielded 25% higher average revenue compared to other seasons, optimizing scheduling strategies.

• View Project

Hospital Management Analysis|| SQL

✦ The primary objective of hospital management analysis is to optimize the efficiency and effectiveness of healthcare delivery within a hospital or healthcare system.

✦ This involves assessing various aspects such as resource allocation, patient flow, quality of care, and financial performance to enhance patient outcomes while managing costs and resources effectively.

• View Project

POWER-BI

Electric Vehicle Analysis || Power-BI

✦ Conducted a deatiled analysis of the Indian EV market for AtliQ Motors for FY 2022-2024, uncovering a 93.91% CAGR and a projected EV sales growth to 54.21 million by 2030, aiding their expansion plans to increase market share beyond 2% in India.

✦ Identified top-performing states and declining EV penetration rates, enabled strategic decision-making to align with AtliQ Motors' goal of achieving a 25% market share similar to North America.

✦ Highlighted Maharashtra as the leading state in revenue (₹79 billion) and Goa as the top state for EV penetration (12.57%).

• View Project

NREGA (National Rural Employment Guaranty Act) Analysis || Power-BI

✦ Customised a functional Power-BI Dashboard to examined NREGA employment metrics, revealed Andhra Pradesh and Uttar Pradesh as top demand regions with over 500,000 job cards issued and an average wage rate of Rs. 276 per worker.

✦ Assessed Rs. 20,000 crore budget allocation and expenditure, identifying effective fund usage in Tamil Nadu and Uttar Pradesh.

✦ Conducted state-wise active worker analysis, finding Tamil Nadu, Uttar Pradesh, and Bihar with over 1 million active workers collectively and Tamil Nadu as a leader in completed projects.

• View Project

Adidas Sales Analysis|| Power BI

✦ This project allows you to Analyze how sales and profitability vary over time for each retailer, to understand the overall sales trends, top-selling products, to see impact of sales methods on profits, to Compare sales performance between different retailers or product categories.

✦ Developed interactive dashboards with product performance indicators to help stakeholders make informed decisions and boost sales by 25%.

• View Project

Call Center Analysis|| Power BI

✦ The objective of the call center analysis project in Power BI is to analyze call center performance metrics such as call volume, wait times, resolution rates, and customer satisfaction scores to identify opportunities for improvement and operational efficiency.

✦ By leveraging Power BI's visualization tools, the project aims to provide actionable insights to optimize staffing levels, training programs, and customer service processes for enhanced overall performance and customer experience.

• View Project

Customer Churn Analysis|| Power BI

✦ Examined customer churn data in Power BI with a focus on 7043 total customers, identified 1869 churned customers & 5174 retained customers, providing actionable insights for retention strategies.

✦ Created dashboard, tracking churn metrics, facilitating real-time monitoring, causing 20% upgrade in retention initiatives.

• View Project

Diversity & Inclusion || Power BI

✦ The diversity and inclusion project in Power BI utilizes quantitative metrics to analyze workforce demographics, examining factors such as gender, ethnicity, age, and job roles within an organization.

✦ By leveraging Power BI's analytical capabilities, the project aims to facilitate data-driven decision-making and implement targeted initiatives to promote diversity, equity, and inclusion across all aspects of the organization.

• View Project

Online Retail Store Analysis|| Power BI

✦ The project involved gathering business requirements from stakeholders and creating a data visualization with business intelligence requirements.

✦ By leveraging Power BI's capabilities, the project aims to optimize marketing strategies, inventory management, and customer engagement to enhance overall sales performance and profitability in the online retail space.

• View Project

About

Lorem ipsum dolor sit amet, consectetur et adipiscing elit. Praesent eleifend dignissim arcu, at eleifend sapien imperdiet ac. Aliquam erat volutpat. Praesent urna nisi, fringila lorem et vehicula lacinia quam. Integer sollicitudin mauris nec lorem luctus ultrices. Aliquam libero et malesuada fames ac ante ipsum primis in faucibus. Cras viverra ligula sit amet ex mollis mattis lorem ipsum dolor sit amet.

Experience

Data Analyst Intern | Mentorness

✅ Conducted COVID-19 analysis using MySQL, processing over 1.69 billion records to uncover trends in confirmed cases, recoveries, and deaths, identifying the U.S. as the highest impacted country and India as the leader in recovery rates.

✅ Created a 4-page interactive Power BI dashboard for NREGA data, visualizing metrics like 15 million+ job cards issued, budget allocations, and workforce participation, enabling stakeholders to improve resource planning by 20%.

• See Internship Projects Here

Power-BI Intern | PWC

✅ Designed and optimized Power BI dashboards for Call Centre Analysis, enhancing operational insights and reducing issue resolution times by 20%.

✅ Performed Customer Churn Analysis using advanced DAX and visualizations, identifying key drivers of churn and contributing to a 15% improvement in retention strategies.

✅ Created a Diversity and Inclusion dashboard, visualizing workforce demographics and fostering data-driven initiatives to increase workplace inclusivity by 10%.

• See Internship Projects Here

Data Visualisation Intern | Tata Group

✅ Streamlined data collection processes by exploring sources of investment information, reducing information gathering time by 30%.

✅ Identified and visualized key reasons for investments, enhancing the company's ability to tailor financial advice to client needs, resulting in a 15% boost in customer satisfaction.

• See Internship Projects Here

Power-BI Intern | Cognifyz Technologies

✅ Streamlined data collection processes by exploring sources of investment information, reducing information gathering time by 30%.

✅ Identified and visualized key reasons for investments, enhancing the company's ability to tailor financial advice to client needs, resulting in a 15% boost in customer satisfaction.

• See Internship Projects Here

CERTIFICATIONS

Data Analyst Certificate

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• End-to-end data analysis lifecycle: data collection, cleaning, and analysis.

SQL( Basic) Certificate

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Fundamental SQL commands: SELECT, FROM, WHERE.

• Usage of GROUP BY, ORDER BY, and aggregate functions like COUNT, SUM, AVG.

• Introduction to filtering, sorting, and basic query structuring.

• Simple joins to combine datasets.

SQL( Intermediate ) Certificate

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Advanced joins (INNER, OUTER, and CROSS).

• Working with subqueries and nested queries.

•Window functions like ROW_NUMBER, RANK, and PARTITION BY.

•Usage of conditional expressions (CASE, IF) for advanced filtering

SQL(advanced) Certificate

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Crafting complex queries with multiple joins and subqueries.

• Advanced window functions (LEAD, LAG, NTILE).

• Query optimization techniques for better performance.

• Insights into database indexing and execution plans.

• Proficiency in managing large-scale datasets.

Complete Guide to Power BI for Data Analysts by Microsoft Press

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Comprehensive understanding of Power BI features and functionalities.

• Building interactive dashboards and visualizations.

• Data transformation using Power Query.

• Publishing and sharing reports on the Power BI Service.

• Integration of different data sources into Power BI.

Power BI Data Modeling with DAX

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Developing efficient data models in Power BI.

• Mastering DAX for calculated columns, measures, and relationships.

• Handling complex data transformations in Power BI Desktop.

• Performance tuning of Power BI models for large datasets.

Advanced Power BI -DAX Formulas and Calculations

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Writing complex DAX formulas for data analysis and reporting.

• Advanced calculations, measures, and KPIs in Power BI.

• Optimizing data models for better query performance.

• Use of time intelligence functions for trend analysis.

SQL for Data Analysis

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Transforming raw data into actionable insights.

• Advanced analytical queries for business decision-making.

• Proficiency with complex joins, unions, and set operations.

• Statistical summarization techniques for datasets.

SQL-Data Reporting and Analysis

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Building business-oriented reports using SQL.

• Advanced aggregate functions to calculate metrics for reporting.

• Data formatting and visualization-friendly query writing.

• Deriving insights through trend analysis and dataset summarization..

Data Visualization- Storytelling

𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝 :-

• Crafting data-driven narratives using visualizations.

• Choosing the right chart types for specific datasets.

• Designing compelling and audience-friendly visuals.

• Emphasizing key insights and trends through storytelling techniques.

Let’s Connect

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';