By: Ngan Dinh
Skills and Tools: SSMS, SQL Server Import and Export Data, SQL Server Scripts, DDL and DML, Tableau Public, Google Colaborator, Python Numpy, Pandas, MatPlotlib, Seaborn, HTML5Up template, Githud storage and server
Data Sets:
Housing Data: https://github.com/ngandinh/DataAnalyst/blob/main/Nashville%20Housing%20Data%20for%20Data%20Cleaning.xlsx
Us Inflation: https://raw.githubusercontent.com/ngandinh/DataAnalyst/main/US%20CPI.csv
Download Housing Data Excel File
Import the Excel file to SQL Server
Clean Data: Change Data Type, update values, add columns, split data, delete unneeded columns...
Prepare Data for creating Tableau Dashboard
Create Views from Housing Data
Run and export Views to Excel files
Create Tableau Dashboard:
Import the Excel files to Tableau Public Desktop App
Change data type of the files for report creating
Create Tableau Reports/Visualizations
Embed the reports/visualizations to Dashboard
Save it to Tableau Public
Download US Infation
Create a new file from Google Colaboratory
Read the Excel/CSV file
Create a dataframe
create visualizations using matplotlib and seaborn library for the dataframe