Pinned Loading

1. DA_Portfolio_Project DA_Portfolio_Project Public

   This repository will showcase all the projects that I had done in order to become a Data Analyst.

2. data_analysis_on_COVID19_using_python data_analysis_on_COVID19_using_python Public

   In this project, using COVID19 of Germany, I did the data analysis using Python. Libraries that I used are: Numpy, Pandas, Seaborn, Matplotlib, Plotly.

   Jupyter Notebook

3. data_cleaning_using_SQL data_cleaning_using_SQL Public

   Here, I work on cleaning a dataset using SQL. For that I used a dataset called Nashville Housing Data which is also available in the repository. I applied different cleaning techniques like standar…

4. excel_project excel_project Public

   In this project. I worked with MS Excel using a dataset called Bike Purchase Data. Here I performed the following approaches to process the data as well as visualize data:

5. sql_queries_advance sql_queries_advance Public

   In this repository, I practiced advanced queries like CTE, Stored Procedures, String functions, Substring, Temp Table.

6. sql_queries_intermediate sql_queries_intermediate Public

   This repository contains intermediate level queries that I practiced while learning SQL. Here I used queries like Update and Delete, Join, Case statement, Union, Having, Alias, and Partition by. I …