Pratik Kulkarni

Data Aspirant

[email protected] +91 9356636815

Hello, I am

Pratik Kulkarni.

1

Excel
Project

1

SQL
Project

1

PowerBI
Project

About Me

Hello and welcome to my portfolio!

I'm a dedicated Data aspirant with skills in Excel, SQL, Power BI, and Python. I love working with data to find useful insights that help businesses grow and improve. My focus is on identifying patterns, improving performance, and helping teams make better decisions using clear and easy-to-understand reports.

I believe in paying close attention to detail and always keep learning to stay up-to-date with the latest trends. This helps me bring fresh ideas to every project I work on. Whether it’s analyzing data or creating reports, I enjoy helping businesses understand their data and use it to make smart choices.

Thank you for visiting my portfolio. I’m excited about the opportunity to work together and help you use data to achieve your goals!

Key Skills

SQL

Excel

Power BI

Python

Machine Learning

My Projects

AtliQ Hardware Sales Report

Domain/Function: Sales

Ad-Hoc FMCG

Domain/Function: Ad-Hoc FMCG

Business Insight 360

Domain/Function: Business Insight 360

My Experience

AtliQ Technologies, Remote – Data Analyst Intern

Cleaned and analyzed over 6000 records in Excel, and performed ad-hoc analysis on the data.
Resolved issues in SQL queries and applied problem-solving skills.
Used SQL and Excel functions like VLOOKUP and Pivot Tables to validate and ensure data accuracy.
Automated reporting processes using Power Query, improving efficiency by 20%.
Created custom dashboards to visualize KPIs, revenue, and customer growth trends, and presented insights.

Internship Studio, Pune – Data Science Intern

Built a machine learning regression model to predict YouTube Ads review count based on other metrics.
Cleaned datasets by handling missing values and outliers.
Normalized data and split it into training, validation, and test sets.
Trained models using linear regression and Support Vector Machine (SVM), and evaluated errors.
Built and trained an artificial neural network (ANN) with different layers and hyperparameter.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python IBM Certification

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.

Mail Me

[email protected]

https://www.linkedin.com/in/pratik-kulkarni-585409243/

Call Me

+91 9356636815

GitHub

https://github.com/Pratikulkarni

Excel Project

AtliQ Hardware Sales Report

Domain/Function: Sales

AtliQ Hardware, known for PCs, mice, and computers, is embracing data-driven growth. They aim to improve sales and marketing by analyzing disorganized sales data to identify trends and key performance indicators for a clearer view of overall performance.

View Project
Engagement

View Project
on GitHUB

Market Performance Vs Target Report

AtliQ India Report

Project Details

I developed a Sales and Financial Analytics Report for AtliQ Hardware using Power Query, Power Pivot, data modeling, and DAX formulas. The report provides actionable insights into customer preferences, market performance, and financial health by analyzing net sales trends, comparing 2021 sales targets with actuals, and reviewing KPIs like gross margin and COGS. It also ranks top-performing products based on sales growth and evaluates the success of new product launches, enabling data-driven decision-making and strategic planning.

SQL Project

Ad-Hoc FMCG

Domain/Function: Ad-Hoc FMCG

This project was focused on leveraging SQL to solve complex, real-time business problems through the use of ad-hoc queries and advanced database management techniques.

View Project
on GitHUB

View Project
on SQL

SQL Queries

Project Details

I utilized SQL queries to extract and analyze data, ensuring accuracy and relevance. I implemented stored procedures to streamline the process, automating repetitive tasks and enhancing efficiency. Additionally, I used views to improve query performance by simplifying complex data retrieval and ensuring faster execution. This combination of SQL techniques allowed for better data management and reporting.

I have learned the following:

1. Data retrieval using SQL queries.
2. Entity Relationship Diagram.
3. Extract, Transform, Load.
4. OLTP and OLAP.
5.SQL functions.
6. Creation of a Database.
7. SQL Data types.
8. Automation with stored procedures.
9. Streamlining data management
10. Kanban - Project Management Methodology.

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their short-term goals. By leveraging data analysis, businesses can unlock new opportunities, drive growth, and stay competitive.

PowerBI Project

Business Insight 360

Domain/Function: Business Insight 360

Business Insights 360 is a powerful dashboard created using Microsoft Power BI. This multi-functional dashboard has been customized to provide AtliQ Hardware with valuable insights into their different departments such as Finance, Sales, Marketing and Supply Chain.

View Project
on GitHUB

View Project
on Power BI

Main Dashboard

Executive Dashboard

Project Details

•Customized Dashboard: Developed a multi-functional Power BI dashboard to specifically meet AtliQ Hardware's needs, allowing them to gain insights into their various departments.

•Data Integration: Data was sourced from disparate locations, including Excel/CSV files and a MySQL database, and seamlessly integrated into Power BI for comprehensive analysis.

•Data Model and Visualizations: A robust data model was developed within Power BI, enabling the creation of visually appealing and interactive visualizations to represent key performance indicators (KPIs).

•Performance Optimization: The dashboard's performance was significantly improved using DAX Studio, resulting in a 5% increase in report efficiency.

•Data-Driven Decisions: AtliQ Hardware can now analyze trends across different departments, empowering them to make data-driven decisions.