My Projects
Data Cleaning With SQL
A project which aims to highlight the use of T-SQL to clean and transform a Nashville (USA) housing dataset. The data is extracted from a MS Excel spreadsheet, cleaned and exported as a csv file ready for import into a visualisation tool such as MS Power BI.
Data Cleaning With Python
Under Construction
One of the projects that I am particularly proud of is the use of Python to clean and transform an Olympic Games datasets held within a csv file. Once again the data is cleaned and transformed before it is exported as a csv file for use by a visualisation tool such as Power BI.
Complete Power BI Project
The aim of this project was not only to use metrics to identify trends and insights into a dataset, but to do so utilising as many features of the Power BI development process as possible including:
-
Importing, cleaning and transforming csv data using Power Query.
-
Constructing a Star schema data model.
-
Creating DAX measures, a Date table and adding time-intelligence functions to complement the data model.
-
Creating a report that contains both drill-down and drill-through features as well as informative tooltips
HR Power BI Project
This Power BI project focuses on the import, analysis and visualisation of Human Resources data.
The report contains 4 pages:
-
High Level Overview
-
Demographics
-
Employee Performance
-
Employee Attrition
