Data Cleaning in SQL
Imported Excel dataset on Nashville Tennessee housing statistics in Microsoft SQL Server. Cleaned the dataset and prepared it for future analysis.
Data Analyst Skilled in SQL, Tableau, and Excel @BrianTheAnalyst
Imported Excel dataset on Nashville Tennessee housing statistics in Microsoft SQL Server. Cleaned the dataset and prepared it for future analysis.
Cleaned and analyzed a dataset on COVID statistics in Microsoft SQL Server, creating views with subsets of the data to analyze specific variables. Imported views to Microsoft Excel to clean and format data for use in visualizations.
Tableau Data Visualization Dashboards. Created various visuals in Tableau, including bar charts, line graphs, and a map chart to display data conclusions, then compiled them into a dashboard.
Cleaned and analyzed a dataset on bike buyer customers. Imported Excel data sheet with hundreds of entries into Excel, then cleaned and formatted data for visualization. Created various visuals including bar charts, and line graphs to display data conclusions, then compiled them into a dashboard.
Imported 12 excel datasheets with millions of entries into R, then used tidyr package to clean the datasets and prepare them for analysis. Joined all of the datasets together, created subsets of the data, and converted each attribute to the proper data type before performing analysis to find differences between members and casual customers.
Sequim, WA 98382