Knowledge just a click away
QlikTech challenges competitors with an affordable, lightning-fast BI solution coupled with capable Java-powered Web deliveryFollow @infoworld
PROPERLY DEPLOYED business intelligence applications offer invaluable information that helps companies serve customers better and optimize critical business processes. Unfortunately, many BI solutions require an infrastructure based on data marts, and analytic and reporting tools, which can be appropriate for large organizations but which bears prohibitive cost and complexity for most midsize companies.
Raleigh, N.C.-based QlikTech, a software company that has been quietly strengthening its BI solutions and expanding its market presence for a few years, proposes a different approach with QlikView 5 and QlikWeb 5, two products that work in tandem to create and deliver custom data analysis for midtier companies as stand-alone PC applications or browser-contained Java applets.
Unlike competitors' offerings, QlikTech applications provide the ability to analyze data at the source, directly accessing databases, spreadsheets, XML documents, or flat files to create comprehensive views of business processes, displayed with a variety of charts and reports. In addition, both QlikWeb and QlikView deliver lightning-fast, memory-resident data analysis, which makes creating and using those charts and reports pleasant and efficient.
QlikView is essentially a powerful tool for analyzing data and creating synthetic views for managers or other business users. Using this Windows-based, stand-alone PC application, a business analyst can create QlikView documents, containers for charts, and reports that focus on a specific business process, such as sales, supply, or inventory management.
QlikView is not a networked application; hence it lacks the tools to efficiently deliver documents to other users. Enter QlikWeb, a Web server application that installs on Microsoft IIS (Internet Information Server) and provides users access to QlikView documents from Java applets.
QlikView can easily access data from just about any database via OLE DB and ODBC. In addition, you can use spreadsheets, XML files, or text documents, or access data using FTP via a LAN or the Internet.
Using a powerful query language (and a SQL clone), QlikView automatically finds relationships between different data structures. For example, it understands that customer ID on a spreadsheet and an Oracle database belong to the same data domain.
QlikView has a straightforward approach to data analysis: You create a document for a specific analysis task, select the proper data feed, and dress that document with a variety of charts and online reports. Think of that document as a probe, centered on an ASQL script, that facilitates collecting data and discovering its relationships.
For our first document, we used Northwind, a sample database with customer names, order invoices, and product info. Connecting to our database and selecting the tables for our documents was straightforward. Next we populated our document with simple list tables containing key pointers to our database, such as country, customer, products sold, discount, and invoices.
List tables are rudimentary, one-column charts. However, they provide a good feel of QlikView's analytic power. In addition, QlikView offers the ability to create a range of sophisticated charts that include statistical indicators for functions such as automatically finding maximum, average, and minimum discounts on sales records, and charts with quick drill down from summary data to transaction details.