Portfolio - Rupali Sherekar

PowerBI Project

Business Insights 360

Established an extensive Power BI dashboard gathering sales data from 2 different sources (Excel/CSV files and a SQL database). The dashboard provides deep insights from finance, sales, marketing, supply chain and executive perspectives. 𝗟𝗲𝗮𝗿𝗻𝘁 SQL, PowerBi Desktop,Excel,DAX

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Sql

DAX Studio

This screen shot is the executive view. New card for KPI's, parameters , conditional formatting were used to create an engaging visual experience

This is the complex data model used with more than 25 tables, above 60 key measures and many parameters

Project Details

AtliQ Hardware is a consumer goods electronics company having operations in various countries. Their business is growing rapidly and they still rely on excel files for data analytics. Excel files are hard to consume and not effective in generating insights. Also due to the lack of effective analytics the company faced a major loss in Latin America. As a strategic move, Senior executives of this company have decided to invest in a data analytics project and have assigned a team for this work. I have created Power BI dashboard that's I called Business Insights 360 to fulfil the demands of the Product Owner and the stakeholders. This was a part of the Data Analytics Boot Camp By Code Basics.This dashboard provides insights to the business with 5 different perspectives

◼ Sales View
◼ Finance View
◼ Marketing View
◼ Supply cCain View
◼ Executive View

Live Interactive Dashboard

PowerBI Project

Hospitality-Industry-Revenue-Insights

AtliQ Grands have been in the hospitality industry for the past 20 years. They are losing its market share and revenue in the luxury/business hotels. The managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their loosing market share and revenue

View Project
Engagement

View Project
on GitHUB

This is the main page that shows the key metrics along with trends and KPI's. Also has filters to see weekly,monthly , citywise,platform wise metrics

Five tool tip pages for Revenue, Occupancy % ,average rating,Average Daily Rate, Revenue per available room have been used to show the details

Project Details

As a data analyst I was provided with sample data and a mock-up dashboard to work on the following task. **

Create the metrics according to the metric list.
Create a dashboard according to the mock-up provided by stakeholders.
Create relevant insights that are not provided in the metric list/mock-up dashboard. With this dashboard, the Revenue team of Atliq Grands was able to gain insights into their monthly and weekly revenue trends with respect to cities , category of hotel and
booking platform

Live Interactive Dashboard

PowerBI Project

Promotion-Analysis-for-Insights-to-Sales-Director-FMCG

AtliQ Mart is a retail giant . All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. The sales director wants to understand which promotions did well and make informed decisions for their next promotional period

View Project
Engagement

View Project
on GitHUB

Promotion-Analysis-for-Insights-to-Sales-Director-FMCG

The main page gives an overview of the overall top and bottom:stores, category of products,cities by incremental revenue and sold quantity

The other pages show the campaign wise top and bottom performers

Project Details

Used MySQL - Used Joins, CTEs, Window functions, etc.
PowerBI - Used Dax,Measures, New Card, created Dynamic Labels, created summary table and usedvisuals like Bar Chart, Matrix,tables,Buttons Donut Chart, etc, as well as Bookmarks for different perspectives

Hello, I am

Rupali Sherekar

3

About

Key

My

Business Insights 360

Hospitality-Industry-Revenue-Insights

Promotion-Analysis-for-Insights-to-Sales-Director-FMCG

Awards

Contact Me

Email

Github

Linkedin

Call

Rupali Sherekar

Download Resume