Know Who I'M

Hi Everyone,

I am Parthiv Bhayani from Surat, Gujarat.
Working as a Data Analyst at finestar jewellery & diamonds pvt ltd.

Additionally, Energetic and highly motivated data enthusiast with a strong academic foundation in statistics and data analysis. Skilled in data visualization like Power BI, Tableau and proficient in Python, Advance Excel and SQL, I bring a fresh perspective to problem-solving. My passion for uncovering insights from data, combined with my adaptability and quick learning, make me an ideal candidate for a data analyst role.

Skillset



  • Power BI

  • Advance Excel

  • Python

  • SQL [MYSQL & Microsoft SQL Server]

  • Data Exploration & Data Cleaning

  • Tableau

Projects


Hear, I showcased a data analysis project where I utilized Python, SQL, Power BI, and Excel to extract actionable insights, enabling data-driven decision-making and demonstrating my ability to translate complex data into meaningful strategies.

Diamond Sale Dashboard

Comprehensive Power BI Diamond Sale Dashboard showcasing real-time sales trends.

  • Power BI
  • Excel
  • Data Cleaning
  • Data Visualization

Diamond Inventory Dashboard

Comprehensive Diamond Full Stock Report detailing inventory status, valuations, classifications, and movement trends for effective stock analysis.

  • Power BI
  • Advance Excel
  • R language
  • SQL

Vrinda Store Data Analysis

The Vrinda Store wants to create an annual sales report for 2022. So that, the owner of the Vrinda store can understand their customers and grow more sales in 2023.

  • Excel
  • Data Cleaning
  • Data Exploration
  • Data Visualization

Sale Dashboard

Compare sales performance of two diamond companies based on growth rate, average PPC, and total sales.

  • Power BI
  • Excel
  • SQL

Diamond Rapaport Dashboard

Interactive Diamond Rapaport Dashboard offering pricing insights, market trends, and comparative analysis for informed trading and valuation.

  • Power BI
  • Advance Excel

ShopFusion Ecommers Sales Dashboard

Analyzed ecommers sales data, created intractive dashbord using power bi.

  • Power BI
  • Excel

Amazon Sales Analysis (Python)

Analyze Amazon sales data to check the buyers preferred choice in the sales using Python Jupyter Notebook.

  • Jupyter Notebook
  • Data Exploration
  • Data Visualization

Covid-19 Data Exploration

Utilized SQL to perform in-depth EDA on COVID-19 datasets.

  • MSSQL
  • Data Exploration

Nashville Housing Data Cleaning Project

Utilized SQL to transform raw data into a format suitable for in-depth analysis.

  • SQL
  • Data Cleaning

Diwali Sales Analysis

Work on Diwali sales data to improve customer experience and sales.

  • Jupyter Notebook
  • Data Exploration
  • Data Cleaning
  • Data Visualization