Power Bi Data Analysis

Aditya Sawarkar

Nagpur,Maharashtra

Ó +91-883******* R ******************@*****.*** Linkedin Github SKILLS

Languages and Tools: SQL, Python, Advanced Excel, Power BI (DAX, Power Query), MySQL Quantitative Skills: Data Analysis, Data Modelling Soft Skills: Problem-Solving, Teamwork

WORK EXPERIENCE

Fireblaze AI School W 12 2023 – 05 2024

Data Analyst Intern Nagpur, Maharashtra

• Analyzed the collected data Gen Z data using SQL Joins and Aggregate Function to extract valuable insights to find Gen Z career preferences and utilized Google Forms to gather career goals and learning preferences data for Generation Z.

• Created dynamic dashboards in Excel and Power BI, integrating Pivot Charts and Slicers for enhanced data visualization and filtering across sales, customer relations, and finance domains. PROJECTS

Clothing Store Data Analysis W Excel 05 2024

• Analyzed clothing store sales and order data utilizing Microsoft Excel to identify customer preferences, sales trends, and patterns. Conducted data cleaning and utilized Advanced Excel features like pivot tables and formulas to explore trends. Developed detailed sales reports and dashboards, resulting in a 10 percent increase in sales.

Layoffs Data Analysis W SQL 04 2024

• Analyze a dataset on layoffs to understand trends and patterns. The analysis will focus on identifying companies with the most significant layoffs, industries most affected, and potential correlations between factors like funding and layoffs and Conducted data cleaning and Exploratory Data Analysis (EDA) using MySQL

ICICI Bank Management System W SQL 04 2024

• Developed and maintained a relational database for ICICI Bank using SQL, enabling efficient management of customer, employee, and account information and built and administered an ICICI Bank data infrastructure using SQL queries, facilitating data retrieval, manipulation, and analysis for banking operations. Hotel Booking Data Analysis W Python 02 2024

• Utilized Python and data analysis libraries (Pandas, Matplotlib, Seaborn) to evaluate hotel booking data, conducting exploratory data analysis (EDA) and data cleaning for improved insights and Identified key factors driving high booking cancellations, resulting in a 15 percent reduction by providing recommendations and developed interactive visualization with graphs and charts to communicate analysis insights to stakeholders.

Credit card transaction and customer weekly report W Power BI 01 2024

• Developed an interactive dashboard using Power BI to provide transaction and consumer data from a MySQL database to prove real-time insights Streamlined data processing and analysis to monitor key performance metrics and trends and shared actionable insight with stakeholders based on dashboard findings to support -decision-making processes.

EDUCATION

Rashtrasant Tukadoji Maharaj Nagpur University 06 2015 – 06 2018 Bachelor of Engineering - Civil Engineering - CGPA - 7.59 Nagpur, Maharashtra CERTIFICATIONS

• SQL(Basic) - Hackerrank • MS PowerBi-Infosys • Data Processing and Visualisation - Accenture

• SQL(Intermediate) - Hackerrank • MySQL - Infosys • Data Science with Python- Simplilear

Contact this candidate