Data Warehouse Dashboard

Web, Mobile & Software Dev Other - Software Development Posted 3 years ago


More than 30 hrs/week
1 to 3 months


SQL expert with experience in working with large data sets to be presented on dashboard (Qlikview).

I am looking to have a dB schema created to take log information from network devices. That information will need to be presented in a Qlikview dashboard representing association of the data.

For example, logs show that many different devices have given the same error at different time. Dashboard should be able to correlate that common error and narrow down which devices in which locations at what time are having that problem. Also, dashboard should show an alarm (change to yellow or red) if a threshold of so many occurnances happens.

Logs will be of a predicitable format for type of device, and will be in a flat file that needs to be added to the dB.

Tasks will be:

1) Use existing schema, but modify or add to faciliate application integration
2) provide sql BI logic to meet criteria as provided in the example
3) Provide UI design to be supported in Qlikview

If successful and timely, additional phases will be added.

Skills: design

  • Other Skills:

Client Activity on this Job

Last Viewed: 3 years ago

Hired: 2

About the Client

(2.60) 2 reviews

United States
Ellicott City 12:58 AM

1 Job Posted
100% Hire Rate, 1 Open Job

$2,766 Total Spent
3 Hires, 0 Active

$37.33/hr Avg Hourly Rate Paid
90 Hours

Member Since Feb 26, 2013