About

►Hi there! I'm Purva Phalak, an aspiring data analyst with a passion for turning data into practical solutions.I'm eager to learn and grow in this dynamic field.

►My key skills include data analysis, data visualization, and proficiency in SQL, I'm also adept at problem-solving and effective communication.

►Graduated with a Bachelor's in Civil Engineering and switched my domain into data analytics was a very great journey for me. I'm committed to continuous learning and professional development to fuel my passion for data-driven insights.

►I am excited about the opportunity to be part of a data analysis team and contribute to your organization's success.

➡️𝐓𝐨𝐨𝐥𝐬 & 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐈 𝐰𝐨𝐫𝐤-

► 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - Data cleaning, Extract Transform & Load [ETL], Data Modelling, DAX, Data Visualisation, Publishing Reports & Dashboards.

► 𝐌𝐲𝐒𝐐𝐋 - Data types, Queries, Joins, Aggregate Functions, Windows Functions.

► 𝐀𝐝𝐯𝐚𝐧𝐜𝐞 𝐄𝐱𝐜𝐞𝐥 - Pivot Tables, Charts, Lookups, Power Query and Power Pivot.

➡️𝐌𝐲 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐚𝐥 𝐚𝐫𝐞𝐚𝐬-

► Data Cleaning

► Data visualization

► Data Analysis & Interpretation

► Dashboarding

► Business intelligence

Projects

𝐒𝐐𝐋 𝐏𝐑𝐎𝐉𝐄𝐂𝐓𝐒

Music Store Analysis|| SQL

✤ The objective of the project is to gain valuable insights into the store's operations, Customer Segmentation, trends ,artist effectiveness, artist growth, customer interest and money spent by customer.

✤ By joining multiple tables, i calculated customers lifetime value, generating to 15% improvement in customer retention strategies.

Movie Analysis|| SQL

✤ The movie analysis project in SQL involves querying a dataset comprising various attributes of movies, such as genre, release date, revenue, and ratings, to derive statistical measures and trends.

✤ Through SQL queries, the project quantitatively assesses factors like box office success rates, audience preferences, and correlations between different movie attributes.

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.

𝐏𝐎𝐖𝐄𝐑-𝐁𝐈 𝐏𝐑𝐎𝐉𝐄𝐂𝐓𝐒

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%.

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.

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.

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.

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.

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.

Elements

Text

This is bold and this is strong. This is italic and this is emphasized. This is superscript text and this is subscript text. This is underlined and this is code: for (;;) { ... }. Finally, this is a link.


Heading Level 2

Heading Level 3

Heading Level 4

Heading Level 5
Heading Level 6

Blockquote

Fringilla nisl. Donec accumsan interdum nisi, quis tincidunt felis sagittis eget tempus euismod. Vestibulum ante ipsum primis in faucibus vestibulum. Blandit adipiscing eu felis iaculis volutpat ac adipiscing accumsan faucibus. Vestibulum ante ipsum primis in faucibus lorem ipsum dolor sit amet nullam adipiscing eu felis.

Preformatted

i = 0;

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

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

Lists

Unordered

  • Dolor pulvinar etiam.
  • Sagittis adipiscing.
  • Felis enim feugiat.

Alternate

  • Dolor pulvinar etiam.
  • Sagittis adipiscing.
  • Felis enim feugiat.

Ordered

  1. Dolor pulvinar etiam.
  2. Etiam vel felis viverra.
  3. Felis enim feugiat.
  4. Dolor pulvinar etiam.
  5. Etiam vel felis lorem.
  6. Felis enim et feugiat.

Icons

Actions

Table

Default

Name Description Price
Item One Ante turpis integer aliquet porttitor. 29.99
Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
Item Three Morbi faucibus arcu accumsan lorem. 29.99
Item Four Vitae integer tempus condimentum. 19.99
Item Five Ante turpis integer aliquet porttitor. 29.99
100.00

Alternate

Name Description Price
Item One Ante turpis integer aliquet porttitor. 29.99
Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
Item Three Morbi faucibus arcu accumsan lorem. 29.99
Item Four Vitae integer tempus condimentum. 19.99
Item Five Ante turpis integer aliquet porttitor. 29.99
100.00

Buttons

  • Disabled
  • Disabled

Form