Portfolio - PRATIK | Codebasics

Hello, I am

PRATIK

Data Aspirant

Resume

1

Excel
Project

2

PowerBI
Projects

About

Welcome to my portfolio! I am an aspiring Data Analyst with a passion for transforming raw data into actionable insights. With a Bachelor's degree in B. Com With Computer Application, I discovered my knack for data analysis and decided to pursue it further. Through extensive self-learning and hands-on experience, I have honed my skills in Excel, Power BI, SQL, and Python, allowing me to efficiently analyze complex datasets and extract meaningful conclusions. I have embarked on numerous business projects that have not only fortified my expertise but also allowed me to showcase my capabilities, all of which can be found in my portfolio below.

My dedication to continuous growth and my enthusiasm for data-driven decision-making make me an ideal candidate for any organization seeking a talented Data Analyst.
Thank you for visiting my portfolio, and I look forward to connecting with you..

My

Projects

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with data-driven strategies for growth and expansion. Acquired proficiency in ETL, Power Query, Power Pivot, DAX, and user-centric report design.

Revenue Insights in the Hospitality Industry

Transformed AtliQ Grands with data insights! Created a dynamic Power BI dashboard analyzing RevPAR, ADR, and more. Explore the interactive dashboard and project details on GitHub. Check out my portfolio for more data-driven successes!

Business Insight 360

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.

Contact Me

Email

[email protected]

Github

https://github.com/PRATIKDHONE

https://www.linkedin.com/in/pratik-dhone-295276263/

Call

+91 7020985190

PRATIK

Data Aspirant

Download Resume

Resume

Excel Project

Sales and Finance Analytics

View Project
Engagement

View Project
on GitHUB

Customer Performance Report

Market Performance vs Target Report

Project Details

I have made this sales report using Excel and Power Pivot that helps businesses figure out good discounts for customers, talk better with them, and find new places to grow. The report gives advice on how to make sales better, make customers happier, and earn more money.

I learned to:

1. Use special tables in Excel
2. Work with data in a smart way
3. Do some basic math for data
4. Make things look pretty with colors
5. Make reports nice to look at

This project is all about giving businesses the tools they need to watch, understand, and improve how they sell things. By looking at sales info, companies can find chances to do better, grow, and stay ahead in the changing market.

PowerBI Project

Revenue Insights in the Hospitality Industry

View Project
Engagement

View Project
on GitHUB

AtliQ Hospitality Analysis Dashboard's Overall View

Data Model View

Project Details

Working with AtliQ Grands, a renowned luxury hotel chain, we implemented "Business and Data Intelligence" strategies to revitalize their market share and revenue. Our primary task was to create a dynamic Power BI dashboard to glean insights from their historical data.

Key areas of focus included:
1. Developing an interactive Power BI dashboard for real-time data analysis.
2. Implementing crucial hospitality domain metrics like RevPAR, ADR, DBRN, DSRN, and DURN.
3. Analyzing historical data to uncover revenue-enhancing opportunities.
4. Providing actionable insights to guide pricing and occupancy decisions.

During this project, I acquired the following skills and knowledge:
1. Proficiency in Power BI for data visualization and analysis.
2. Deep understanding of key hospitality metrics and KPIs.
3. Data-driven decision-making for pricing and occupancy optimization.
4. Effective data presentation to aid in strategic decision-making.

Project video

Live Interactive Dashboard

PowerBI Project

Business Insight 360

View Project
Engagement

View Project
on GitHUB

Dashboard's Home Page

Finance View

Project Details

Project Details
In this project, the primary objective was to create a unified report for stakeholders in sales, marketing, finance, and the executive team. Key areas of focus included:

1. Building a Robust Data Model
2. Designing User-Centric Reports
3. Providing Drillable Insights

During this project, I acquired the following skills and knowledge:

1. Proficiency in Power Query, covering both basic and advanced operations.
2. Mastery of basic and complex DAX formulas.
3. Expertise in data modeling with over 10 interconnected tables.
4. Selection of appropriate visuals and formatting techniques.
5. Skill in using bookmarks for enhanced user experience.
6. Deployment on the Power BI service platform.
7. Actively incorporating stakeholder feedback.
8. Analysis and reporting of metrics across sales, marketing, finance, and supply chain domains.

Hello, I am

PRATIK

1

2

About

My

Sales and Finance Analytics

Revenue Insights in the Hospitality Industry

Business Insight 360

Contact Me

Email

Github

Linkedin

Call

PRATIK

Download Resume