Download CV
Data Analyst well versed in SQL, Python, Power-Bi, Excel, Azure Synapse Analytics, Tableau.
Analyzed the T20 World Cup 2024 data using Databricks to create an interactive and insightful dashboard. Leveraging PySpark and PySQL, the project processes, analyzes, and visualizes data to provide comprehensive insights into team performances, player statistics, match outcomes, and tournament trends.
Skills: Azure Data Lake, Databricks, Pyspark, PySQL, SQL, Databricks Dashboard.
This project demonstrates my ability to leverage Azure's data engineering capabilities, manage data pipelines, and perform sophisticated data analyses using SQL. The insights derived from this project provide a deeper understanding of historical Olympic performance and trends.
Extract all relevant data from the databases required for our analysis according to company target requirements using an SQL query. Export the data to Excel files by connecting through the SQL database to enable auto-updation. Check for data redundancy. Perform data analysis in Excel using pivot tables, chart formatting, and slicing. Prepare an interactive dashboard in Power BI.
Sales data Exploration using SQL Query and Advanced Excel. Resolved data types issues.
Skills: SQL Queries, Advanced Excel, Data Transformation, Data Modelling
The objective of this project is to analyze and optimize the sales performance of Global_Mart through comprehensive data analysis, identifying key trends, diagnosing underlying factors, and providing actionable recommendations for future growth.
By using this model, we will be able to understand the properties of products and outlets that play key roles in increasing sales. This model will enable us to forecast sales, which will ultimately help in managing inventory effectively. Additionally, we will be able to identify early warning signals, allowing us to find ways to achieve our goals and make informed strategic decisions.
Portfolio Views
