Zomato Data Exploration and Analysis with SQL (SQL SERVER)
-
Updated
Jul 15, 2024 - TSQL
Zomato Data Exploration and Analysis with SQL (SQL SERVER)
Data Analyst Portfolio Project 1 - SQL and PowerBI - Cleaning and analysing the AdventureWorks dataset with SQL, then visualizing it with PowerBI
This is a query showing different SQL skills ranging from Data Exploration to Data Cleaning and Using the Query to develop Tableau Presentation.
This module enables you summarize and identify the quality of the data using concepts such as aggregation and window functions.
Zomato Data Exploration and Analysis with SQL (SQL SERVER)
This is my Portfolio Projects' repository
Analyzed COVID-19 data using SQL and Tableau. Set up a SQL Server, cleaned data, and created a database. Built an interactive dashboard in Tableau to visualize trends in reproduction rates, ICU patients, testing metrics, and vaccination impacts.
In this project I perform data cleaning using T-SQL, to improve the quality of a dataset containing information about houses in Nashville, Tennessee..
In this personal Electric Vehicle Data Analysis Portfolio project, an exploratory data analysis was performed on the Electric Vehicle Data available on Kaggle. The main aim of the project is to uncover insights into the Electric Vehicle Good and profits trends.
This module covers performing descriptive analytics on time series data, geospatial data, complex data types (arrays, JSON, and JSONB), and text.
This module covers how to assemble multiple tables into a dataset using SQL queries. It also introduces how to transform and clean data using SQL functions.
This project analyzes sales data for AdventureWorks, focusing on revenue, customer segments, and product performance. The dashboard provides insights into top-selling products, sales by region, and customer trends across multiple years. It helps in identifying sales opportunities and optimizing marketing strategies.
Covid-19 Data Exploration and Analysis with SQL
MS SQL server data migration scripts
SQL for effective data analysis use for ad hoc querying, data cleaning and reporting with advance techniques.
Add a description, image, and links to the data-cleaning topic page so that developers can more easily learn about it.
To associate your repository with the data-cleaning topic, visit your repo's landing page and select "manage topics."