Response to Case Study - Reponse 1
The first thing I need to do is to create a view in my DKTravel database to join bookings and customer data into a form more appropriate for carrying out BI. This could be done within Tableau if the data was from outside a database, but as I have access to SQL Server I am combining the data here and will use that as the source for Tableau. Here is the view definition. I am splitting the dates into Month and Year components and also converting the Leadtime days into weeks.
CREATE VIEW v_BookingData_BI AS
SELECT C.PostCode,
C.Town,
YEAR(B.BookingDate) AS BookingDate_Year,
MONTH(B.BookingDate) AS BookingDate_Month,
YEAR(B.DepartDate) AS DepartDate_Year,
MONTH(B.DepartDate) AS DepartDate_Month,
YEAR(B.ReturnDate) AS ReturnDate_Year,
MONTH(B.ReturnDate) AS ReturnDate_Month,
B.LeadTime,
B.LeadTime/ 7 AS LeadTimeWeeks,
B.PassengerCount,
B.Resort,
B.BookingAmount AS Revenue,
B.ID
FROM tblCustomers C
INNER JOIN tblBookings B ON C.ID = B.CustomerID
For the purposes of my portfolio, I have installed a trial version of Tableau Desktop and have set up a Tableau Public workspace.
I have created 2 simple dashboard sheets in Tableau and published to Tableau Public showing Bookings Data on one and Revenue data on another.

Comments