I've been brought on board to help a company start to build their first business intelligence setup. I'm a developer by trade, and have good knowledge of SQL and application design using relative tables but this is my first step into designing a data warehouse.
I have two questions initially from the customer, and if I can do a good job of providing a report setup for this we'll expand from there. The questions I'm tasked to answer are:
How many support tickets are being opened each day?
How many support tickets have been closed each day?
How many does each employee have?
How many does each group of employees have?
I've designed my first start schema to handle the answering of these questions which is as follows.
I would love any feedback/critique of this design.
p.s As a side note I'm planning on using SISS to perform the ELT tasks rather than programming my own software to do the job? Does this seem like a sensible opinion? For the first part of the data entry I'll be pulling information out of Dynamics CRM and Request Tracker.