Portfolio - Prajwal U

Hello, I am

Prajwal U

Data Aspirant

Resume

2

Excel
Projects

1

PowerBI
Project

About

Hello, I am an aspiring data enthusiast with a solid background in Excel, Power BI, Python, and SQL. Currently employed as a database admin at TCS for three years, I am in the process of transitioning into the exciting realm of data analytics. I recently obtained Power BI and SQL certifications from Codebasics, further enhancing my skill set.

As I navigate this transition, I plan to expand my Python skills by delving deeper into data analysis libraries like Pandas, NumPy, and Matplotlib. Additionally, I am interested in exploring machine learning basics, starting with libraries such as Scikit-learn. Strengthening my proficiency in advanced SQL topics, such as stored procedures and optimization techniques, is also on my agenda.

To apply and showcase my skills, I am actively seeking real-world projects.

Key

Skills

SQL

Python

My

Projects

Coffee shop sales Analysis

I delved into the nuanced dynamics of each coffee shop in this coffee sales and transaction analysis conducted across three different locations using Excel.
Discovering distinct consumption patterns, peak transaction periods, and popular product preferences unique to each location.

Atliq Hardware's Business Insights

Atliq Hardware's Business Insights using Power BI Dashboard, this Business Insights Power BI Dashboard demonstrates Atliq Hardware's sales to the retail market.

Market Performance versus Expected Targets.

Key Takeaways: Practical Learning Experience - Codebasics' hands-on approach facilitated my immersion into the realm of Excel. Effective ETL Methodology - I gained insights into the correct way to Extract, Transform, and Load data. Applying these newfound skills, the project served as a canvas for

Awards

& Certificate

Data analyst intership

On the spot Award

Contact Me

Email

[email protected]

Github

https://github.com/PrajwalUnaik

https://www.linkedin.com/in/prajwal-u-n8197106226/

Call

+91 8197106226

Prajwal U

Data Aspirant

Download Resume

Resume

Excel Project

Coffee shop sales Analysis

I delved into the nuanced dynamics of each coffee shop in this coffee sales and transaction analysis conducted across three different locations using Excel. Discovering distinct consumption patterns, peak transaction periods, and popular product preferences unique to each location.

I broke down the transactions based on both the day of the week and the hour of the day, providing a detailed explanation for each.

I detailed the transactions by category and outlined the top 15 popular items sold within the specified time frame.

Project Details

I delved into the nuanced dynamics of each coffee shop in our coffee sales and transaction analysis conducted across three different locations using Excel. I discovered distinct consumption patterns, identified peak transaction periods, and discerned popular product preferences unique to each location through meticulous data analysis.

When I compare and contrast these findings, a comprehensive overview emerges, providing me with valuable insights to optimize operations, tailor marketing strategies, and improve the overall business performance.

PowerBI Project

Atliq Hardware's Business Insights

Atliq Hardware's Business Insights using Power BI Dashboard, this Business Insights Power BI Dashboard demonstrates Atliq Hardware's sales to the retail market.

View Project
Engagement

The home page demonstrates the views created in the project, i.e 📈 Financial View, 💰 Sales View, 🌐 Marketing View,🔄 Supply Chain View

The financial view contains profit and loss statements, net sales by last year' net sales line chart,products and customers by net sales and much more

Project Details

📈 Financial View:
-> Uncover profitability with dynamic Profit and Loss statements.
-> Visualize Net Sales trends through a year-on-year line chart.
-> KPI cards illuminate Net Sales, Gross Margin, and Net Profit.

💰 Sales View:
-> Dive into customer and product performance insights.
-> Explore unit economics, dissecting total sales with DAX formulas.
-> Performance matrix maps Net Sales across regions for strategic decisions.

🌐 Marketing View:
-> Optimize marketing strategies with product and region performance metrics.
-> Dynamic line and cluster column charts track Net Error trends.
-> Product-specific metrics reveal forecast accuracy and inventory risks.

🔄 Supply Chain View:
-> Key metrics by customer unveil forecast accuracy, net error, and risk.
-> Trend analysis of net error enhances forecasting precision.
-> Product-specific metrics refine inventory management strategies.

Live Interactive Dashboard

Excel Project

Market Performance versus Expected Targets.

View Project
Engagement

Comparison of Market Performance with Expected Targets.

Project Details

Journey Highlights:

1️⃣ Hands-On Learning Experience: Codebasics' hands-on approach enabled me to fully immerse myself in the Excel universe.

2️⃣ Mastering ETL: I acquired a comprehensive understanding of the proper Extract, Transform, and Load (ETL) data methodology, applying these skills in real-world scenarios.

3️⃣ Unveiling Market Performance: The report delves into the assessment of market performance over time, comparing results to predetermined targets. The analysis spans sales data from 2019, 2020, and 2021.

4️⃣ Pivot Tables Mastery: Utilizing Pivot Tables with Power Query and leveraging the capabilities of Excel, we crafted concise and straightforward reports.

Hello, I am

Prajwal U

2

1

About

Key

My

Coffee shop sales Analysis

Atliq Hardware's Business Insights

Market Performance versus Expected Targets.

Awards

Contact Me

Email

Github

Linkedin

Call

Prajwal U

Download Resume