Hello! I’m Bhushan Gawali, a Data Analyst with a passion for transforming complex data into actionable insights. I specialize in:

• 🛠️ SQL
• 🐍 Python
• 📊 Power BI
• 📑 Excel
• 📈 Data Analysis
• 🖥️ Dashboard Creation
• 🔍 Data Visualization
• 📉 Forecasting & Statistical Analysis

I leverage these tools to create interactive dashboards, perform advanced data analysis, and deliver valuable insights. Explore my repositories to see a range of projects showcasing my expertise!

• Data Manipulation: Mastery in Pandas for cleaning, transforming, and analyzing data.
• Data Visualization: Expertise in Matplotlib and Seaborn for creating insightful visualizations.
• Web Scraping: Extracting and analyzing data using BeautifulSoup and Requests.
• Machine Learning: Basic proficiency in machine learning models and algorithms.

• Complex Queries: Crafting and optimizing intricate SQL queries for data extraction and analysis.
• Database Design: Designing and managing relational databases, including table creation and indexing.
• Data Manipulation: Efficient in data insertion, updates, and deletions.
• Performance Optimization: Enhancing query performance for faster data retrieval.

• Dashboard Creation: Designing dynamic and interactive dashboards to visualize data trends and metrics.
• Data Modeling: Building robust data models and relationships to support comprehensive analysis.
• DAX Formulas: Proficient in DAX for advanced calculations and measures.
• Report Sharing: Expertise in sharing reports through Power BI Service and embedding in applications.

• Advanced Formulas: Mastery of formulas such as VLOOKUP, HLOOKUP, INDEX-MATCH, and array formulas.
• Conditional Formatting: Applying dynamic formatting rules to highlight key data points.
• Pivot Tables and Charts: Analyzing data using pivot tables and visualizing with pivot charts.
• Data Validation: Creating dropdown lists and validation rules for accurate data entry.
• Macros and VBA: Automating tasks and developing custom functions with VBA.
• Forecasting and Trend Analysis: Using Excel’s forecasting tools and trendlines for accurate predictions.

I am actively seeking a Data Analyst position and am available immediately. With my expertise in Python, SQL, and Power BI, coupled with my advanced Excel skills, I am eager to contribute to a dynamic team and solve complex data challenges.

Connect with me through the following channels:

• 📧: Email
• 🔗: LinkedIn
• 💬: WhatsApp
• 📸: Instagram

• Dashboard Development: Created interactive dashboards enhancing data-driven decision-making.
• Advanced SQL: Mastered complex SQL queries and optimized database performance.
• Python Proficiency: Leveraged Python for data manipulation, visualization, and web scraping.
• Excel Expertise: Demonstrated advanced Excel skills in formulas, conditional formatting, pivot tables, and macros.

• Description: Analyzed the 2024 Olympic Games focusing on 🥇 athlete performance, 🏆 medal distribution, and 🌍 country rankings using Power BI and Python.
• Key Features: Medal distribution visualization, athlete performance analysis.

• Description: Analyzed coffee shop sales using SQL for data extraction and Power BI for visualization. Focused on 📈 sales trends and 📋 order patterns.
• Key Features: Sales performance insights, order pattern analysis.

• Description: Explored IPL data to show team and player performances. Analyzed match results, highest scores, and performance at various venues using charts.
• Key Features: Match results analysis, player performance metrics.

• Description: Designed and managed a library database with CRUD operations, including tables for branches, employees, and books.
• Key Features: CRUD functionalities, database management.

• Description: Developed a fully automated Excel dashboard to analyze and visualize key metrics of a bank's loan portfolio. Provided insights into loan applications, funded amounts, and more.
• Key Features: Automated reporting, loan metrics visualization.

• Description: Provided real-time visualizations of IPL scorecards and standings using Power BI. Pulled live data from the Cricbuzz API.
• Key Features: Live score updates, dynamic standings visualization.

• Description: Imported data into SQL, performed queries, and visualized results in Power BI dashboards. Included summaries, trends, and regional analysis.
• Key Features: Loan application metrics, regional analysis.

• Description: Created a comprehensive Retail Sale Dashboard using Power BI and MySQL. Analyzed and visualized retail sales data with key insights into sales trends.
• Key Features: Sales trends visualization, comprehensive retail analysis.

• Description: Analyzed smartphone market trends and patterns using SQL and Python. Evaluated price distribution, user ratings, and market share.
• Key Features: Price distribution analysis, user ratings insights.

• Description: Designed a comprehensive Sales Dashboard in Excel to provide data-driven insights into sales performance across various time frames and categories.
• Key Features: Sales performance analysis, interactive Excel dashboards.

• Description: Utilized Excel to forecast YouTube views for the next 7 days using FORECAST Function, Graph Trendlines, and Forecast Sheet Tool. Compared methods for accuracy.
• Key Features: Forecasting methods comparison, trend analysis.

• Description: Created a dynamic registration form in Excel with dependent dropdown lists, functional macros, and protected sheets to streamline data collection.
• Key Features: Data collection automation, functional macros.

• Description: Focused on web scraping using Python libraries like Requests and BeautifulSoup to extract and analyze data from websites. Structured data into tables with Pandas.
• Key Features: Data extraction automation, structured data tables.

• Description: Used SQL and Python to create an interactive dashboard analyzing sales performance and customer trends from the Northwind database.
• Key Features: Sales performance analysis, customer trend insights.

• Description: A collection of my data analysis projects showcasing expertise in Python, SQL, Power BI, and Excel. Includes detailed case studies and interactive visualizations.
• Key Features: Portfolio showcase, detailed case studies.

• Description: Welcome to my GitHub profile! 🚀 I’m Bhushan Gawali, a Data Analyst with expertise in Python 🐍, SQL 💾, and Power BI 📊. Explore my repositories to see a range of projects that highlight my skills in data analysis.
• Key Features: Overview of my expertise and projects.

Feel free to explore these projects and connect with me for any queries or collaborations! 🌟