• SQL Training and Skills, SQL Classes

    SQL Training

    Is it time to develop or improve your SQL and database skills? Try one of our exceptional SQL training classes which are now available in both classroom and virtual form. Click here to see list of SQL classes that will help you become an SQL expert.

  • site_slide_dashboards

    Dashboards and Data

    Your ability to quickly and accurately identify key issues and address them may not be what it should. Talk to us about how quickly we can get you up and running with interactive dashboards.
    Contact us to learn more about the leading dashboard and data analysis technologies.

  1. 1
  2. 2
  3. 3

site_home_services  site_home_solutions
 
Looking for help with online reporting, dashboards, data analysis, data management or software development? Our team of business intelligence experts and developers can get your organization up and running fast. We have years of experience implementing and developing solutions using Microsoft SQL Server, QlikView, Qlik Sense, .NET, PHP, MySQL, JasperSoft, Talend, Crystal Reports, BusinessObjects and many other data and software development technologies.

 Recent Articles Posted by Our Consultants

  • Qlik Custom Calendars (for Qlik Sense & QlikView)

    Qlik Custom Calendars (for Qlik Sense & QlikView)

    Qlik Sense and QlikView both handle dates via list boxes (or Filter Panes in Sense). The conventional approach to providing users with date selectors is to create a master calendar and create list boxes in the application to select things such as “Year”, “Month” and “Quarter”. This works well enough, and it addresses issues with missing dates […]
  • Qlikview – Inputbox as a filter

    Qlikview – Inputbox as a filter

    Recently, I was working with a client who wanted to make it easier for end users to be able to do complex associative searches in a list box. A few examples of how associative searches can be used in order of increasing complexity: 1) Search for all Suppliers whose name starts with the letter S […]
  • Qlikview Sorting by Multiple Expressions

    Qlikview Sorting by Multiple Expressions

    I was recently working with a client who needed to use a list-box rather than a straight table to show a list of values and some measures. The reason for the list-box was that, unlike a chart, when the user makes selections, we can set it up so that all values continue to be shown […]
  • Key Concepts of Qlik Sense – Part I (The Hub)

    Key Concepts of Qlik Sense – Part I (The Hub)

    Qlik Sense is a web-based application with different areas to work in. You chose which area to view depending on what you would like to see in the application. There are areas to see the data model, work with storytelling, or exploring data. On startup, Qlik Sense will open up the hub in your default […]
  • Benchmarking QlikView Load Script Strategies

    Benchmarking QlikView Load Script Strategies

    I recently worked on a project that involved improving the performance of a user developed QlikView document load script. The problem I was told was that the reload took approximately 12 hours to complete. The request that I received was to examine the document and improve the data model and load strategy. One issue that […]
  • Qlik Sense Load Order Sorting

    Qlik Sense Load Order Sorting

    QlikView Developers have long used load order sorting to provide a custom or business rule driven sort order. Load Order sorting provides a simple way to sort values in an expected order without resorting to a numeric prefix, hidden sort fields or other techniques. Some common examples of lists commonly sorted in non-standard orders are […]
  • Qlikview SQL Timer – see how long each query takes

    Qlikview SQL Timer – see how long each query takes

    About a year ago I was working with a client to clean up a series of Qlikview load scrips that had grown to be quite lengthy over time. Each of the scripts consisted of several SQL queries. As part of the process to investigate the queries, I was asked if there was a way for […]