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.


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?

Evner: QlikView

Se mere: qlik market, qlik community blogs, qlikview qliksense, qlik login, qlik extensions download, qlik community, qlik sense sankey, qlik sense extensions list, project completion time table, setup deployment project give time, business analyst project full time basis india, project short time job, project work time counter, good ratio project management time, website project log time spent, penang programmer project part time, develop java project part time, ecg fpga project real time, best project business time monitor iphone app, example project integrate paypal using php

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #17510089

12 freelancere byder i gennemsnit $212 på dette job


Hi, I'm interested in your project. Is it possible to make an ETL part in QlikView as I don't have an Alteryx license?

$270 USD in 7 dage
(6 bedømmelser)

Hi, Hope you are doing great. I have expert knowledge in Qlikview designing and development. I have created many dashboards using this tool. Performance wise, star schema is good, but if we consider memory, then snow f Flere

$277 USD in 3 dage
(12 bedømmelser)
$250 USD in 5 dage
(6 bedømmelser)
$188 USD in 3 dage
(0 bedømmelser)

hello, i viewed the data, and I can provide the help on it. we can discuss the details if required. I am not familiar with Alteryx, only Qlikview. as for the best data model, i usually prefer Tree shaped data model for Flere

$222 USD in 5 dage
(0 bedømmelser)
$277 USD in 5 dage
(0 bedømmelser)

• Having total 4.4 years of experience in Qlikview Designing and Development, Qlikview Admin & Qliksense Developer. • Creating the New Robocopy, Modifying the Robocopy & Create a task in QMC for Robocopy or FTP (batch Flere

$222 USD in 7 dage
(0 bedømmelser)

I have just completed a similar project for another client

$177 USD in 3 dage
(0 bedømmelser)

I am certified Qlikview developer and architect. I have 6 years of experience in analytics. I am qlikview admin and developer worked from infrastructure to deploying the files.

$244 USD in 5 dage
(0 bedømmelser)
$30 USD på 1 dag
(0 bedømmelser)

Hello, Based on the requirements and datasets provided, this should be a fairly standard Qlik buildout. As a Qlik architect and designer for 6 years and a certified instructor for 2, most of the data sources I work Flere

$230 USD in 3 dage
(0 bedømmelser)

Hi, I am currently working in the Qlikview domain and would like to contribute to this project. Thanks, Venkatesh

$155 USD in 6 dage
(0 bedømmelser)