Tim Huntington
Other Projects

In addition to Power Bi, Powershell and Websites I also learn various other technologies. I often create various Hyper-V machines to seperate out different purposes and have previously used VMWare.

Hyper-V Screen Capture
A screen capture from Hyper-V Manager.

I have spent a substantial amount of time studying SQL Server including SSRS and SSIS.
I have imported publicly available food business ratings in to an SQL database using SSIS and Visual Studio. I downloaded an XML file and then used the SSIS Toolkit to import the XML file and map it to destination tables in an SQL database. I then created a view to combine the multiple tables in to one view and I also added calculated columns. I used the graphical interface to initially create the view then added additional code to create the calculated fields for the Outward and Inward Postcode. Seperately, I also created a query with calculated values.

SSIS Dataflow
A screen capture from Visual Studio showing SSIS data flow.
Food Business Ratings SQL View
Code to create SQL view combining food ratings tables and adding two calculated fields.
Food Business Ratings SQL Query
Code to create SQL query listing proportion of businesses awaiting inspection.