Superstore Sales Analysis with SQL
Identify business growth opportunities by analyzing superstore sales performance data SQL, DATA ANALYSIS (SQL Server Management Studio) SQL is one of the programming languages which allows us to access and perform data analysis by using all the available data within our database and manipulating or filtering it through queries. Thus, we can generate more insightful […]
Exploratory Data Analysis of Covid-19 Data Set Using SQL
Exploratory data analysis is an approach to analyzing data sets to summarize their main characteristics, often using statistical graphics and other data visualization methods. Link to Code https://github.com/rrizwan43/PortfolioProjects_SQL_data_explorations Tools and Techniques 1. SQL server Management Studio.2. My SQL3. Tables Joins / Relationships4. Data Cleaning5. Data Modeling Tasks 1. Total cases, deaths & population by country.2. […]
Data Cleaning in SQL Server Management Studio
Data cleaning is the most important and time-consuming step in the data analysis process. It’s the process of detecting and correcting corrupt or inaccurate records from a record set, table, or database and refers to identifying incomplete, incorrect, inaccurate, or irrelevant parts of the data and then replacing, modifying or deleting the dirty or coarse data. […]