Monday, March 10, 2014

Do you need Business Intelligence? No thanks, we are too busy.

Do you need Business Intelligence? No thanks, we are soo busy.

Saturday, March 8, 2014

Tableau and Splunk partner up

Tableau, one of the hottest and most popular Business Intelligence and Analytics platform in the market, Splunk, a Big Data player that specializes in machine data, goes to a technical partnership that will make their products work together.

Tableau will connect through to the semi- and unstructured data managed by Splunk using an ODBC driver that Splunk had previously made available. But rather than making users build a generic ODBC connection, Splunk will now appear as an explicit data source option inside Tableau.

Splunk's analytics software detects bottlenecks in companies' applications and networks, while Tableau's software provides a way for business executives to create graphs and charts with their company data.

Both companies are growing extremely fast: Tableau's year-over-year revenue growth has spiraled upward 62%, 71%, 90% and 95% in the last four quarters, while Splunk's year-over-year quarterly revenue has grown by over 50% in each of the last four quarters. Tableau shares are up 41% so far this year after ending 2013 up 122% from its May 17 IPO offering price. Shares of Splunk are up 34% this year after ending 2013 up more than 136%.

Tableau Software
Tableau Software

Friday, March 7, 2014

Data Analytics with QlikView in Healthcare

QlikView is one of the most powerful yet easy to use business intelligence platform in the world. With its proven in-memory, associative technology, QlikView is extensively used in many industries and domain including healthcare. With the QlikView Business Discovery platform, healthcare providers can analyze and improve KPIs such as average length of stay, waiting times and reduce problems such as opportunities for medical errors, excess healthcare operational costs. More than 500 healthcare providers spanning hospitals, nursing and residential care facilities, and ambulatory services worldwide uses QlikView now to overcome business intelligence challenges and improve performance.

Let's look at how? You can read many papers on business intelligence in healthcare but the best way to understand the usage is to see them in action. QlikView provides very nice healthcare related demos for prospective users to try and understand how QlikView or business intelligence in general can help their organization.

Below is a list of available healthcare dashboard demos. At the end of this post, there is a button to access to the full demo stack including online applications, video demos and self-executable files.

Hospital Activity Dashboard - This application allows the user to look into the world of a hospital in the United Kingdom and analyze real world data to see the struggles that hospitals face each day. The Hospital Activity – UK application allows the user to view hospital activity (Patient Wait Times and Length of Stay) analysis through various different views. All of the analysis can be filtered by various selection criteria including age group, patient classification, admission type, healthcare resource group, etc.

Hospital Activity Dashboard Demo
QlikView Hospital Activity Dashboard Demo

Hospital Profitability Dashboard - As is the case in any business, hospitals are always looking for ways to reduce costs and increase revenue. The Hospital Profitability –US application allows the user to look into the world of a hospital in the United States and analyze real world data to see the struggles that hospitals face each day.

This application allows the user to view profit analysis through various different views. The user can see actual charges billed for services, payments (Insurance/Patient) received for the services billed, patient length of stay and variable cost analysis for supplies used.

Finally the user can analyze the number of procedures performed by month-year and the total diagnosis by department. All of the analysis can be filtered by various selection criteria including fiscal year, fiscal quarter, fiscal month, patient type, doctor, procedure, etc.

QlikView Hospital Profitability Dashboard Demo
QlikView Hospital Profitability Dashboard Demo
Surgical Dashboard - The Surgical Dashboard application empowers Operating Room Managers and Directors to visualize data that illustrates primary concerns, patterns, and performance as it pertains to OR management, efficiency and utilization.

The Surgical Dashboard application helps to ensure patient safety and the highest quality of care, it provides surgeons with appropriate access to the operating room and it helps to maximize efficiency of OR utilization, of staff, and of materials to reduce costs.
QlikView Surgical Dashboard Demo
QlikView Surgical Dashboard Demo
Clinical Readmissions Analysis Dashboard - Hospitalizations account for roughly half of all health care costs and, as a result, reducing the number of readmissions is the main focus in improving the coordination and quality of care. Many organizations are data rich, but unfortunately, they also tend to be information poor. Understanding where to start analyzing your patient population can be a daunting task.

• Which facilities have a higher readmission rate than others?

• Which ICD9 codes lend themselves to a higher readmission rate?

• Which providers have the highest readmission rates?

In order to answer these questions and more, you need a flexible ,yet powerful, analytics engine to help turn all that data into useable information. This application is one example of how QlikView is helping many providers do just that.

QlikView Clinical Readmissions Analysis Dashboard Demo
QlikView Clinical Readmissions Analysis Dashboard Demo
Clinical Pathways Analysis Dashboard - Clinical pathways, also known as care pathways, critical pathways, integrated care pathways, or care maps, are one of the main tools used to manage the quality in healthcare concerning the standardization of care processes. It has been shown that their implementation reduces the variability in clinical practice and improves outcomes.

This application analyzes data related to clinical pathways in terms of several key areas that are targeted for analyzing components of Pathways management:

1. Length of Stay

2. Time to first order Lasix

3. Time to administer Lasix

4. Comparison of patients on Pathway vs not on Pathway

Clinical Pathways Analysis Dashboard
Clinical Pathways Analysis Dashboard

Thursday, March 6, 2014

What is QlikView.Next?

Update : After calling it QlikView.Next for a few years, Qlik (formerly known as QlikTech) has changed the name of the new platform to Qlik Sense.

QlikTech has released its last major version upgrade, QlikView 11 almost 3 years ago in November 2011. Since than, there were several service packs and new builts but no new version. And if you are looking forward for QlikView 12, it will never be released. Next version of QlikView will be named QlikView.Next.

According to the information QlikTech has released up to now, QlikView.Next will be fundamentally different than QlikView 11 and its almost identical predecessor QlikView 10. The interactive visualization user experience is completely redesigned in QlikView.Next. QlikTech calls this Natural Analytics which according to them makes it easier for users to discover and share new insights.

Natural Analytics builds on QlikView’s game-changing associative experience and again according to QlikTech incorporates enhanced comparisons, collaboration, workflow, sharing and data dialogs, as well as enhanced insights from unique visualization techniques that Qlik acquired from NComVA in June 2013.

With QlikView.Next, QlikView Server and administration capabilities will also be completely re architectured. QlikView.Next business intelligence software suite will also come with reusable semantic intelligence and modeling that draws on its acquisition of Expressor Software, open APIs for extensibility, expanded data connectivity, and enhanced scalability and security features.

Compared to the offerings of the incumbent IT-centric vendors, QlikView revolutionized business intelligence domain for its ease of use for end users, particularly in terms of its interactive dashboards plus its successful “land-and-expand” strategy. But that was long long time ago. Since 2010 or QlikView 10, QlikTech has released nothing significantly new and also abandoned its land-and-expand strategy by forcing QlikView customers to buy at minimum a QlikView Server instead of desktop licences. And in terms of visual-based interactive exploration and analysis capabilities, user experience, and the time it takes for business users to gain proficiency in authoring, the current QlikView 11.x is more limited compared to offerings from other stand-alone data discovery vendors like Tableau. You can see this in successive Gartner Magic Quadrant for Business Intelligence Reports. In 2012, QlikView was the only “agile” visual discovery platform in “leaders” quadrant among big boys like SAP, Oracle and Microsoft. In 2013, Tableau and Spotfire has entered the “leaders” quadrant and now in the latest 2014 edition, you can see that Tableu is clearly ahead of QlikView in terms of ability to execute and on par with it in its completeness of vision. So while QlikTech was pouring all the cash in its marketing juggernaut, it looks like no fund is left for R&D and QlikView became a little obselete in the past 3 years.

What is QlikView.Next?
What is QlikView.Next?
And almost 1 year long delay in the release of QlikView.Next, which is seen as QlikView’s answer to Tableu’s rise, does not help. QlikView.Next was expected to be released in 2013 (already breaking QlikView’s product release phase of 1 major release in every year) but we have still not seen it yet (except some marketing mumbo jambo about it). This gap of whole year delay has given other vendors to improve their offerings, close the gap and in some major areas supress what QlikView offers.

Currently (as of 2014), our view is that QlikView is the best data visualization leader, closely followed by QlikView. QlikView may be the top business intelligence platform in 2015 if QlikView.Next becomes a success. But it seems like QlikView guys are also planning to shoot themselves from their feet by discontinuing free QlikView Desktop edition at a time Tableau is planning to release a Mac version of its desktop edition. If QlikView.Next does not take of as Qlik expects and Tableau innovates like this, we are pretty sure that 2014 will be the year when Tableau took over the leadership from QlikView.

There were rumors that QlikView Free Desktop will be removed from Qlikview.Next but according to a press release on 9 April 2014, qlikView will still provide free desktop:

Presenting to over 1200 attendees at its Global Partner Conference, Anthony Deighton, Chief Technology Officer of Qlik (NASDAQ: QLIK), a leader in user-driven Business Intelligence (BI), announced that the Company will release a free desktop version of QlikView.Next via Personal Edition download early in third quarter of 2014. Qlik will also offer a free cloud service for small group sharing of analysis built in this desktop client. Personal Edition business analytics users will be able to leverage QlikView.Next’s intuitive features to build a customized app in minutes by just dragging and dropping, experiencing many of the Natural AnalyticsTM user interface capabilities before the server and enterprise functionality of the complete platform is expected to be generally available in second half of 2014.
Source : Qlik Announces Free QlikView.Next Personal Edition Download Will Be Available to the public early third quarter

Wednesday, March 5, 2014

QlikView Expense Management Dashboard Demo

Every company has expenses. Every sales or services company has traveling costs. But most expense tools don't give you the insight information about how the expenses were spent. This Expense Management Dashboard application provides you with a way to discover unexpected expenses and track employee spending. With the power of data association, QlikView helps you identify ways to save money for your organization.

QlikView Data Discovery platform is one of the leading business intelligence tools in the market today with agile, intuitive and cost effective structure. You can see a detailed information about QlikView here in our What is QlikView? QlikView Overview post.

QlikView can help  finance users and managers to  analyze large volumes of expense data from disparate sources in a single intuitive expense application.  Business users can freely investigate costs and expenses across multiple geographies, business lines, and systems, to understand detailed spending trends and identify efficiency opportunities. QlikView allows users to eliminate their reliance on end-of-month, high-level static reports, and instead focus on understanding spend activity and taking meaningful action to reduce expenses.

This sample expense management application comes with a Dashboard View, Expense Breakdown View, Employee Expense View and Reports view. Download Expense Management Dashboard package and try it freely on your own. The package includes :

  • Expense Management Dashboard QlikView File (QlikView is required to view it)
  • Expense Management Dashboard Web Link (No installed app is required, just a web browser to use)
  • Expense Management Dashboard executable (You can access demo app without QlikView installed)
  • Expense Management Dashboard video introduction
  • QlikView for Expense Management PDF

The application is structured in a very nice "DAR" Structure. Dashboard - Analysis - Report structure is composed of 3 types of views : high level view for strategic decisions, analysis views for details and reports view for detailed reports.

Expense Management Scorecard

Below is the screenshot from the demo app showing high level Expense Scorecard. This is a typical "Dashboard" level view to show you the current situation at a glance with respect to targets. Color coded alarms and warning icons are used to highlight problems and issues to be looked in more details.

QlikView Expense Management Dashboard
QlikView Expense Management Dashboard
Expense Breakdown Analysis and Employee Expense Analysis

These to analysis views, Expense Breakdown and Employee Expense, analysis allows users to drill down to the details of the expense breakdown. It allows users to dive into individual employee expenses, if needed.

Expense Breakdown Analysis
Expense Breakdown Analysis
Employee Expense Analysis
Employee Expense Analysis

Free access to Expense Management Dashboard

You can try Expense Management Dashboard demo by accessing the free public demo application. Fill in your name, e-mail and phone to the below form and press submit button. You will receive an e-mail links to web based dashboard (you can also access through mobile devices), a self-executable file for you to try it locally (no QlikView license required) and supporting material such as demo video.

Get Acess to Free Copy of Expense Management Dashboard
Name :
E-mail :
Phone :