Portfolio - PRAVEEN PA | Codebasics

Powered by
Codebasics DA Bootcamp

PRAVEEN PA

Power BI Developer

EMAIL

[email protected]

PHONE

+91 9500573044

Download CV

About Me

Power BI Developer with 1+ Years of development experience in Microsoft Power BI tool. Experience in developing Power BI Reports using different DAX queries, visuals, filters and configuring dashboards with drill down capabilities. Working knowledge on Power BI objects like Dashboards, Reports, Power Views, Creating Workspaces, Sharing dashboards, Row Level Security implementation. Hands on experience in PostgreSQL Database. Good Knowledge on Power BI Data Modelling and Data Warehousing concepts like Star Schema, Snowflake Schema, Dimensions and Fact Tables.Team player with good analytical and problem-solving skills.

1

Excel Project

1

PowerBI Project

3

Python Projects

Key Skills

SQL

Python

Statistics

Power BI

Pandas

Excel

My Projects

My Experience

Poorvika Mobiles Private Limited

Power BI Developer

Executed descriptive analytics on retail performance across multiple locations and delivered actionable insights through BI dashboards to support strategic business decisions.
Performed HR analytics on project management data to assess employee productivity and improve operational efficiency.
Conducted diagnostic analysis on lead conversion performance of the customer care team using BI dashboards based on received leads.
Worked with multiple stakeholders across various verticals to gather requirements and delivered dashboard presentations through live demos.

Let's Work Together!

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

[email protected]

Call Me

+91 9500573044

LinkedIn

https://www.linkedin.com/in/praveentheanalyst/

GitHub

https://github.com/Praveen-DataAnalyst

PowerBI Project

Supply Chain Data Analysis Project

To generate insights aimed at resolving a supply chain issue within the FMCG domain, thereby enhancing service levels and retaining key customers for the organization.

View Project
Engagement

Supply Chain Data Analysis Project

City and Customer Analysis

Supply Chain Data Analysis Project

Product Insights

Project Details

AtliQ Mart encountered challenges with customer contracts due to service issues, particularly concerning on-time and in-full deliveries. As a Data Analyst in the supply chain team, my role is centered on measuring and improving service levels using metrics such as On-Time Delivery (OT%), In-Full Delivery (IF%), On-Time In Full (OTIF%), Line Fill Rate (LIFR), and Volume Fill Rate (VOFR).

Live Interactive Dashboard

Python Project

Hospitality Data Analysis Project

To provide insights to the Revenue Team in the Hospitality Domain and deliver recommendations to enchane the strategy in gaining their market share and revenue.

Hospitality Data Analysis Project

Computing the average occupancy rates for the four cities.

Hospitality Data Analysis Project

Identifying the trend in occupancy between weekdays and weekend.

Project Details

AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands are losing its market share and revenue in the luxury/business hotels category

As a data analyst, my role is to find out why the company is losing Market Share and Revenue.

Excel Project

Sales Analysis Project

To generate reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Sales Analysis Project

Analyzed the customer net sales performance

Sales Analysis Project

Assessed the market performance against the target

Project Details

I have developed a sales report utilizing Excel pivot tables. This report aims to assist businesses in evaluating successful customer discount strategies, streamlining negotiations with clients, and identifying potential expansion opportunities in promising markets. The generated reports will offer practical insights and suggestions, empowering businesses to refine their sales tactics, improve customer contentment, and increase revenue generation.

Python Project

Web Scraping & Data Analysis Project

To scrape the data from the Wikipedia page 'https://en.wikipedia.org/wiki/List_of_largest_companies_in_India' and conduct data analysis using pandas to generate solutions for Ad-Hoc Requests.

View Project
on GitHUB

Web Scraping & Data Analysis Project

Web Scraping using BeautifulSoup

Web Scraping & Data Analysis Project

Data Analysis using Pandas

Project Details

Utilized BeautifulSoup to extract data from the webpage and leveraged Pandas for comprehensive data analysis. Employing BeautifulSoup allowed me to precisely target elements such as tables and headings, extracting their content effortlessly. Implementing Pandas resulted in a 25% reduction in processing time for ad-hoc requests involving unstructured data.

Python Project

Retail LLM Project

To build an End-to-End LLM project for a retail domain (t-shirts selling store), using SQL Database chain in Langchain along with a few shot learning and to build a question & answer system that can talk to MySQL database and generate answers.

View Project
on GitHUB

Retail LLM Project

RESULTS

Retail LLM Project

RESULTS

Project Details

Built a LLM based tool for detailed inventory analysis in natural language aiding strategic decision making. Achieved a 25% decrease in the duration required to manage complex queries and by leveraging the tool, individuals unfamiliar with the database language can still extract information from the database, thereby enhancing overall inventory management efficiency by 20%.