Powered by
Codebasics DA Bootcamp

Priyannka Kollekar

Data Aspirant

+91 8451980577 [email protected]

Resume

Hello, I am

Priyannka Kollekar.

5

PowerBI Projects

1

Excel Project

About Me

With 12 years of experience in web development, I've honed my skills in creating seamless, user-focused digital experiences. Throughout my career, I've cultivated a deep understanding of technology, problem-solving, and project management. Now, I'm channeling this expertise into a new and exciting direction—data analytics.

In my journey to transition into data analytics, I've acquired strong skills in Power BI, SQL, and Excel. I'm passionate about leveraging data to drive insights and make informed decisions. Whether it's visualizing complex datasets, optimizing processes, or uncovering trends, I'm committed to delivering high-impact solutions.

As I step into this new phase, I'm eager to connect with professionals and opportunities that align with my skills and interests. Let's collaborate and explore how data-driven strategies can transform businesses.

Key Skills

MySQL

POWER BI

PYTHON

EXCEL

My Projects

My Experience

Web Developer with 11 years of experience, now transitioning into Data Analytics. Proficient in Power BI, SQL, and Excel.
Optimized 50+ WordPress sites, enhancing UX and client satisfaction by 25%.
Led website migrations, reducing load times by 40%.
Implemented e-commerce solutions, increasing sales by 15%.

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.

[email protected]

https://www.linkedin.com/in/priyannka-kollekar/

+ 91 8451980577

https://github.com/priyannkakollekar

PowerBI Project

Blinkit Sales & Inventory Analysis

Domain/Function: Sales Analysis

To conduct a comprehensive analysis of Blinkit's sales performance, customer satisfaction, and inventory distribution to identify key insights and opportunities for optimization using various KPIs and visualizations in Power BI.

View Project
Engagement

View Project
on GitHUB

Blinkit Sales & Inventory Analysis

This dashboard includes various KPIs such as total sales, average sales, the number of items sold, and average customer ratings.

Blinkit Sales & Inventory Analysis

Blinkit's sales performance, including total sales, average sales, number of items sold, and customer ratings, segmented by factors like outlet size.

Project Details

In this project, I developed a comprehensive Power BI dashboard for Blinkit, focusing on key performance indicators (KPIs) such as Total Sales, Average Sales, Number of Items, and Average Rating. The dashboard visualizes sales by various factors including fat content, item type, outlet size, and location using diverse chart types like Donut, Bar, Stacked Column, Line, and Funnel Map. I executed ETL processes, ensured data quality through Power Query, and standardized currency types. Insights revealed Blinkit's total sales of ₹1.2M, strong customer satisfaction with an average rating of 4/5, and significant contributions from low-fat items and medium-sized outlets. This analysis supports strategic decision-making, inventory optimization, and growth strategies. Through this project, I gained practical experience with DAX calculations, data modeling, and the use of advanced Power BI visuals.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: Sales Analysis

AtliQ Hardware is growing rapidly in the recent years, and they have decided to implement the data analytics using PowerBi in their company for the first time to surpass their competitors in the market and to make data driven decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

MySQL

Business Insights 360

AtliQ Hardware implemented Power BI for data-driven insights, aiding in finance, sales, marketing, and supply chain decisions to outpace competitors.

Business Insights 360

Implemented Power BI at AtliQ Hardware to provide data-driven insights across business functions, enhancing decision-making and competitive edge.

Project Details

AtliQ Hardware, a rapidly growing company, sought to surpass its market competitors by implementing data analytics through Power BI. This project was initiated to empower stakeholders with data-driven insights in finance, sales, marketing, and supply chain management. Leveraging the Codebasics Power BI course, I executed this project using SQL, Power BI Desktop, Excel, and DAX language. The project involved various Power BI techniques such as data modeling, creating dynamic visuals, KPI indicators, and utilizing Power BI services for publishing reports and setting up auto-refresh. The outcome enabled AtliQ Hardware to make informed decisions, thereby enhancing their market position. The project's success was anchored in thorough data exploration, robust data modeling, and intuitive dashboard design, which addressed the core questions and fears of stakeholders.

Live Interactive Dashboard

PowerBI Project

AtliQ Sales Insights

Domain/Function: Sales Analysis

Sales director of the AtliQ hardware, decided to build a PowerBI Dashboard for converting the data into visual representation to make data driven decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

MySQL

AtliQ Sales Insights

Developed a Power BI Dashboard for AtliQ Hardware to address declining sales, providing visual insights to enable data-driven decisions and improve pe

AtliQ Sales Insights

A Power BI Dashboard transformed AtliQ Hardware's sales data into actionable insights, aiding in understanding declining sales and optimizing business

Project Details

AtliQ Hardware, a prominent computer hardware and peripherals provider with branches across India, faced challenges in understanding its business performance due to declining sales. The Sales Director struggled with obtaining clear, actionable insights from regional managers, who found it difficult to interpret data from Excel files. To address these challenges, a Power BI Dashboard was developed to convert raw data into visual representations, enabling data-driven decisions.

The project employed the AIMS Grid project management tool to define the purpose, stakeholders, end results, and success criteria. MySQL was used to extract data, which was cleansed using Power Query and transformed through ETL processes. Key metrics were developed and visualizations were created in Power BI, including standardized currency conversions. The project resolved issues with product categorization and enhanced sales transaction data, leading to insights.

Live Interactive Dashboard

PowerBI Project

AtliQ HR Analytics Dashboard

Domain/Function: Human Resources

Dashboard provides a comprehensive analysis of employee attendance, work-from-home (WFH) trends, & sick leave (SL) patterns across the organization. Key metrics like Attendance %, WFH %, & SL % are visually tracked over time, offering valuable insights for HR teams to optimize workforce management.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

AtliQ HR Analytics Dashboard

This Power BI Dashboard analyzes attendance, WFH, and sick leave trends, offering HR insights to optimize workforce management with key metrics and vi

AtliQ HR Analytics Dashboard

This Dashboard visualizing employee attendance, WFH, & sick leave trends, providing HR teams with actionable insights to improve workforce management.

Project Details

This Dashboard offers a detailed analysis of employee attendance, work-from-home (WFH) trends, and sick leave (SL) patterns within the organization. By visually tracking key metrics like Attendance %, WFH %, and SL % over time, the dashboard provides HR teams with essential insights for optimizing workforce management. The project was built using Power BI Desktop and Excel, focusing on advanced techniques such as creating calculated columns and measures using DAX, data modeling, dynamic visuals, KPI indicators, and conditional formatting. Additionally, the dashboard was published with auto-refresh capabilities in Power BI Services.
Key highlights from the analysis include an overall attendance rate of 91.83%, WFH trends at 10.00%, and sick leave insights at 1.10%. The dashboard also offers detailed day-wise attendance and leave patterns, enabling more informed decision-making. This project provided a valuable opportunity to deepen my skills in data visualization and storytelling.

Live Interactive Dashboard

PowerBI Project

Chocolate Sales Analysis

Domain/Function: Sales Analysis

The Dessert Chocolate Company has undertaken a comprehensive data analysis project to gain insights into its sales performance, customer base, and shipment efficiency. The Power BI dashboard provides a detailed overview of key metrics and trends, enabling stakeholders to make informed decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Chocolate Sales Analysis

A Power BI dashboard analyzing sales, shipments, and profits for the Dessert Chocolate Company, revealing key trends and supporting data-driven decisi

Chocolate Sales Analysis

Power BI dashboard offering insights into sales, shipment efficiency, and customer preferences for Dessert Chocolate Company, driving strategic growth

Project Details

The Dessert Chocolate Company embarked on a data analysis project to gain in-depth insights into sales performance, customer preferences, and shipment efficiency. A Power BI dashboard was developed to meet these objectives, offering a comprehensive overview of key metrics and trends. This dashboard empowers stakeholders to make data-driven decisions, improving strategic planning and business outcomes.

Key performance indicators (KPIs) include Total Sales, Total Boxes, Total Shipments, Total Costs, and Total Profits. The company achieved total sales of $34.04M, a significant 11.3% increase compared to the previous year, demonstrating strong market demand and effective sales strategies. The dashboard also highlights that 2M boxes were shipped, a 3.9% increase, and 6,000 shipments were successfully managed. The analysis reveals that 'Bars' are the top-selling category and Australia leads in shipments, showcasing strong international demand.

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics Reports

Domain/Function: FMCG

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics Reports

This report give insights about Market Performance VS Target for the AtiQ Hardwares

Sales and Finance Analytics Reports

This report is give insights about P&L by Financial Year by division wise.

Project Details

In the report I utilized a combination of powerful tools to transform raw sales data into actionable insights. The project was structured around three main stages: Extract, Transform, and Load (ETL) using Power Query, data analysis using Power Pivot with Data Analysis Expressions (DAX) and finally visualizing the results through Pivot Tables.
🔸In sales project I use various dimensions like Region, Division, Market, Product and Customer to check the net sales pattern & track KPIs .
🔸In Finance Project I learn how to derive COGS, Gross Margin, increase in Growth%, Increase in Revenue %, fiscal months and quarters .
🔸 Domain Knowledge
🔸 Design user-centric reports
🔸 Business Principles