Qlik Project

This is our standard Alteryx / Qlik View assignment. I’ve attached 2 CSV files of our time tracking data - 1 for the year 2016 and 1 for the year 2017. Here is the assignment: Using Alteryx, ingest and integrate the CSV files and model the data as you see fit (i.e. additional flat files, QVDs, other). Load the modeled data into Qlik View. Create a dynamic interactive tool in Qlik View to answer the following questions: How many Clients (Customers) and Projects (Jobs) have hours logged in total? Breakdown by Client (Customer). What are the biggest clients in the last week? The last month? The last year? What is the trend of hours over time? Which employees log the most amount of hours? How do billable and non-billable hours compare overall and by employee? Use the attached wireframe as a mock-up for your dashboard. Background: TSheets is our timetracking tool. Employees and vendors log in daily and enter time by Customer (i.e. Ford Motor Company) and Job (or project, i.e. GDIA Engagement). Vendors are subcontractors, but employees and vendors are really the same thing as they both log time against jobs. Non-billable time is logged under the Customer of Internal Codes. All other time is billable. A Customer is the same thing as a Client and a Job is the same thing as a Project. You should submit your Alteryx and Qlik View solutions. QUESTION FOR DISCUSSION: Does Qlik prefer a snowflake or star schema, and why?