top of page

Welcome to DK Travel

Nov 1, 2022
1 min read

To demonstrate some of my skills, I have made up a ficticious travel agency called DK Travel and they are going to be asking me for various Data Engineering and Analysis tasks. I will use this blog as a case study and describe the requests and how I have answered them for DK Travel. This case study will demonstrate skills in T-SQL, Python, Pandas, Tableau, Power BI t start. I am also going to try and incorporate some SSIS and SSRS as well when I get time.




So welcome to DK Travel





 
 
 

Recent Posts

See All
Some Initial Setup

Before I start answering requests from DK Travel, I need to set up an initial customer database and due to GDPR cannot use real data. I...

 
 
 
Random Booking Data

As mentioned in the previous post, I can generate random data using T-SQL or Python. I have decided to do the work in Python and...

 
 
 
Case Study - Request 1

We at DK Travel would like to see some of our data displayed in a Tableau dashboard to allow us to get some basic insights such as :...

 
 
 

Comments


bottom of page