Big Data….Big Deal?

There is a lot of hype in the world of reporting and analytics at the moment around Big Data. Is Big Data the silver bullet for all BI problems or is it just a passing fad?

Traditional definitions of Big Data refer to it in the context of Volume, Variety and Velocity. In this sense, it is about more than just size, it also about different types of information such as structured and unstructured, and the speed with which this is generated and changes.  For example, retail giant Wal-Mart feeds more than 1million transactions an hour into databases estimated at more than 2.5 petabytes.   Facebook’s estimated 750 million users create an average of 90 pieces of content each month and an average of 294 billion e-mails are sent every day.

Despite this, Big Data is in some ways not a new concept. Organisations have always been adept at generating large amounts of data and the explosion in variety and velocity through things such as social media and the incessant chatter of the ” internet of things” threatens to be the proverbial straw that breaks the camel’s back.

The real challenge with Big Data lies in creating meaning through insight and it is here that technology enablement is at an inflection point. Advancements in analytical capabilities are now at a point where the creation of meaning from mass is achievable.  Economist Intelligence Unit research indicates however, that most businesses have made slow progress in extracting value from big data and some companies attempt to use traditional data management practices on big data, only to learn that the old rules no longer apply.

Technology is however only part of the solution and having a technology centric approach will likely result in organisations being overwhelmed by information irrelevance.  Data does not make decisions, people do, and more data does not automatically result in better decisions.

Miller’s Law suggests that the number of objects an average person can hold in working memory at a point in time is 7 plus or minus 2. While the ability of technology to store, process and sort data has grown exponentially over time, human cognitive ability has arguably not grown at the same rate. The challenge for Big Data is therefore one of relevance – how do you synthesize the masses of data into the 7 plus or minus 2 objects to support effective decision making?

Keeping this in mind Big Data does offer tremendous opportunity to drive value. A recent study by McKinsey has suggested US retailers could realise in excess of a 60% improvement in net margin and consumers globally 0 billion in value through the creative and innovative use of Big Data. They have further indicated that Big Data will become a key basis for competition and growth.

While another global survey In June 2011 by the Economist Intelligence Unit of 586 senior executives, looked at the state of big data, the organisational characteristics of companies that are adept at extracting value from data and the most challenging aspects of data management. The research found:

  •  Extracting value from big data remains elusive for many organisations. For most companies today, data is abundant and readily available, but not well used. Nearly one in four said the vast majority of its company’s data is untapped. Another 53% say they only use about half of their valuable data. Yet 73% say that data collection in their organisation has increased over the last year. These figures indicate that organisations are still learning how to manage Big Data.
  • Many companies struggle with the most basic aspects of data management, such as cleaning, verifying or reconciling data across the organisation. Nearly one-third of respondents admit their data governance practices are insufficient. Many struggle to deliver important data to the right people within an acceptable timeframe. And there is also a depth of workforce skills required to sift through, analyse and develop insights from Big Data. The lack of the right skills to manage data effectively is among the top two challenges cited by CIO’s. While the most difficult process right now is reconciling disparate data sources.
  • Companies that are furthest along the data management competency continuum provide a useful model for how organisations will need to evolve if they are to extract and utilise valuable data-driven insights. Strategic data managers use data to first identify specific measurements and data points that align closely with corporate strategic goals. They select the most appropriate data to make decisions, and put a high percentage of the data they collect to use. They are also more likely to assign a C-level executive to manage data strategy, and they continue to explore emerging sources of data for potential value.

Of course, Big Data will be but one of the tools that companies use to inform decisions. But companies if they are going to effectively harness Big Data need to start with the end in mind and have a razor-sharp focus on outcomes. It also requires some unique people skills in terms of data management and the ability to harness data as a critical factor of production on a par with land, labour and capital.

To understand how we tackle the issue of Big Data in the world of Microsoft go to the Inside Info website by clicking  here and download the Big Data Info Sheet.

Uncover Hidden Container Objects on QlikView Reports

Qlikview is very much a dynamic tool that lends itself to adhoc queries by those using it.  However there’s still the need for well formatted reports that can be distributed to viewers who don’t have access to the document through the QlikView application.  A typical example of this is a Finance Balance Sheet that may then be bound up to a consolidated PDF file.  Qlikview provides for this through the use of Reports.

A Qlikview report allows a designer to layout multiple Qlikview objects, such as charts and textboxes, on a paper page that can then be printed.  The objects are not stored in the report, but are stored as virtual links to the objects in the document.

This is great for reflecting the dynamic requests of the user, but what if an object is hidden in the document? Or what if it is in an inactive tab of a container?  In both these cases, the object will also be hidden in the report.  Possibly not what you’d want, so how do you get around this?

At design time, copy the object from the container to a separate sheet, and ensure it is visible.  Hiding the sheet will then still allow it to be seen on the report without end users seeing a redundant copy of the object in the document.

What happens if you modify the original object in the container? If the copy outside the container is not a linked copy, it won’t get modified. If however it is a linked copy, it will be modified but it won’t be visible on a report if the container hides the original object.  A bit of a trade-off I know, but a way around this is to:

  1. Use a macro to unlink the two objects
  2. Print the report that refers to the unlinked version
  3. Relink the objects so any future modifications happen to both versions

Linked objects simply have the same ObjectID. Unlinking them only requires changing one of the ObjectIDs, while relinking them requires changing it back.  Note the report would have to always refer to the ObjectID of the unlinked object to ensure it’s never hidden.

How QlikView Business Intelligence Stands Out For Developers

Developers love QlikView business intelligence software after they start using it, able to use features that they already know in different ways where they gain new wisdom to use their creativity. Here’s some pointers on some of QlikView’s simple and advanced capabilities that stand out.

  1. Drag and drop to open a QlikView application:
    • Drag and drop a QlikView application (qvw) file into the QlikView Developer client to have it opened.
  2. The power of grey and selections:
    • With QlikView, users can literally see relationships in the data. They can see not only which data is associated with their selections, they can just as easily see which data is not associated. This generates new insights and unexpected discoveries.
    • With a right click, they can reverse their analysis by selecting the non-associated data (select excluded).
    • By using the “show alternatives” option on list boxes, the user can get further insight on the data values that are related to the selection state besides the green value.  When a selection is made on a list box, the selected value is highlighted in green and all of the other values are highlighted in grey. If the user would like to get insight on the data values that are still relevant with the selection state in addition to the green value, they can check the “show alternatives” option and can get insight on all of the relevant values in addition to the selected value.    
    • The user can move between selected values in a list box by using the down arrow on the keyboard. As the selection changes with the down arrow pressed, the charts recalculate on the fly and the user sees changes in the data. 
  3. List box with expression:
    • The user can create new data selection points by creating a list box with an expression. For example, the expression can define the sum of sales at the customer level. The user can then make selections on these new data points to do further analysis.
  4. Calculated dimensions:
    • The dimension values on charts do not need to exist in the data model; new data points can be created and used as dimension values on charts. For example, in a chart showing the inventory quantities by the number of weeks, the number of weeks is a calculation that is used as dimension values. 
  5. Bookmark:
    • In QlikView, the current state of selections can be saved as bookmarks for later use. To create the bookmark, QlikView does not store the actual data values; it stores the criteria that are used while the selections are made (the filters the user applied). If the selection criterion is an expression, let’s say “top 15 customers,” QlikView will store the expression and when the data refresh happens, the updated top 15 customers will be displayed when the bookmark is selected.  
  6. Document chaining:
    • With document chaining, it is possible to open one QlikView application from another QlikView application and carry the selection states from the first to the second application.
  7. Power of in-memory data transformation:
    • QlikView provides a lot of functionality to transform data in memory. It is possible to create new tables, and new fields in memory. Please see the script syntax part of the QlikView reference manual document.
  8. Data exploration:
    • On the table viewer, when hovering with the cursor above the fields, users can get information about the data density and subset ratio to understand any data integrity issues. The number of selected values vs. all of the values is displayed on the right bottom part of the QlikView screen.
  9. Binary load:
    • With binary load, it is possible to load the in-memory data model from one QlikView application to another one. Binary loads are very fast. It is possible to do further in-memory data transformation on the data after the binary load.
  10. Search:
    • QlikView allows search not only by actual data values but also by new data calculations. For example, the user can type “=rank(sum(Sales)) <=5” on a product list box. This would select the top 5 products based on sales. The same type of search can be done on a search box. In that case, QlikView not only will display the top five products but also all of the associated data (e.g., sales people, regions, price, etc. . . anything related to these five top products). Pretty powerful! 

These are just some of the “unlisted” benefits of QlikView.

7 Key Business Intelligence Trends for 2012

2012 is shaping up to be another big year, with Gartner citing that its survey of over 2,300 CIO’s worldwide ranked BI and analytics as their top technology priority for this year.  So here’s Inside Info’s take on the latest trends based on what the analysts are saying.

1.    Less Technology, More Business & Decision Support

The emphasis has moved very clearly to business value – emphasising the ‘why’ rather than the ‘how’ – analytics has to support business decision making and result in business innovation.  Most BI platforms are deployed as systems of performance measurement, not for decision support. According to Gartner this is changing as organisations are recognising that analytic capabilities are just one important piece of the decision process. User-designed scenarios/models simulate possible performance outcomes and contributors iterate on the model until there is consensus on the best decision to take. Some are beginning to automate repeatable, operation decisions in analytic applications and implement collaborative decision-making platforms around analytic capabilities to improve the quality and transparency of tactical and strategic decisions where collaboration between decision makers is critical to the outcome.

2.    Get Your BI Basics Right

There’s definitely a need to ‘get the BI basics’ right before buying into the next big thing.  Too often, most mid market and enterprise organisations are still struggling with the ability to deliver timely information to teams when they need it, in a form they can easily use and interpret.  Typically a small number of power users get what they need and are happy  – everyone else has to fend for themselves with standard reports or lots of data manipulation. In fact, the 2012 BI & Information Management Survey by Information Week found that for businesses that had adopted a BI tool, only 25% of employees in those businesses had access to that tool. Certainly in some respects, traditional BI tools have been too bulky and technical for that other 75% of employees to use, rather than being a case of not needing that information.

Often cost and time to deploy a new BI project is price prohibitive to the business – so doesn’t happen.  Be mindful of this as BI Survey 10, cites slow and late BI implementations as one of the biggest problems facing BI success. Evidence shows that the longer you take to implement your BI solution, the more difficult it is to achieve positive business benefits. ‘Agile BI’ is key. Minimal support required, promising faster, better results.

3.    Data Discovery Momentum Continues to Increase

Gartner continues to see users exerting significant influence over BI decisions and choosing user-driven BI tools known as ‘Data Discovery’ tools.  These enterprise BI platforms, of which QlikView is considered at the forefront, are alternatives to traditional BI platforms, characterised by rich data visualizations, typically in-memory capability with simple point & click analysis, that can deliver value fast.  In fact when businesses were asked the question by Information Week about what was needed in a BI tool, ‘easy to use’, ‘easy to deploy’, ‘affordability’ (Microsoft often wins on this front) and ‘easy to administer’ (self-service BI) were the top criteria. The consideration for IT is how to keep users happy with these type of tools, without creating a fragmented ‘siloed’ information environment.

4.    In-memory BI

In-memory technology continued to take centre stage in 2011, with its ability to provide speed-of-thought analysis on ever-increasing amounts of data. By 2014, 30% of analytic applications will use in-memory functions to add scale and computational speed according to Gartner. There is a direct correlation between fast query performance and project success, depending on how long it takes users to get the answers they’re after.  By 2014, 30% of analytic applications will use proactive, predictive and forecasting capabilities. Gartner calls ‘In-Memory’ BI a ‘strategic imperative’ and advises that organisations should look at in-memory as a ‘quantum leap in their computing strategy because “dramatically faster data access can profoundly change the nature of some applications.” QlikView is the pioneer of the in-memory BI space and continues to shine as the Leader in this area in the Gartner 2012 BI Platforms Magic Quadrant.

5.    Collaboration

According to Gartner, by 2013, 15% of BI deployments will combine BI, collaboration and social software into decision-making environments. Organisations are starting to more proactively manage, capture and optimise decision processes and outcomes to improve performance beyond the decision inputs such as BI. Collaborative decision environments will drive investment in new BI and analytic applications, particularly those that link with collaboration and social networking functions. The value of collaborative decision making can then be demonstrated by focusing on departmental, line-of-business or process-specific decisions such as forecasting.

BI in the cloud is still something for the future for most businesses.  For many, only when underlying operational systems are themselves running in the cloud.

6.    A Fit-For-Purpose Approach to BI Works Better

According to Gartner, operational or tactical business intelligence (BI) is growing. Businesses are seeing the benefits of using BI tools to solve a specific need or problem, proving value and then expanding its use from there, rather than jumping in head first. IT vendor and standards should not be more important than the user needs and supporting the business user.  BI Survey 10 says evidence shows a strong correlation between product suitability & achieving business benefits.  Companies that buy BI tools for their features & best-fit rather than ‘standards’ or ‘price’ send a clear message that the product is worth having.

7.    Mobile Business Intelligence

Mobile BI is now a given in this market. Gartner believe that by 2013 33% of all BI usage will be on a mobile device. More than 20% of Gartner’s survey respondents report that they are already using mobile BI or are piloting it. A whopping 33% plan to deploy mobile BI in 2012. Businesses should recognise that users will want to use mobile devices to access corporate BI data. They also need to ensure that the current BI infrastructure supports these demands while promoting the use of tablets to improve the BI experience of the mobile workforce.

Inside Info Ramps Up for the Launch of QlikView 11 in Australia

QlikView’s latest release, QlikView 11 is due out at the end of this year and has focused its attention in five key areas:

  • Social Business Discovery – Allowing users to collaborate on discoveries & generate multiplicative insights.
  • Comparative Analysis – Builds on QlikView’s unique associative analysis engine with more enhanced levels of quick, comparative analysis of different data views and selection states.
  • Mobile Business Discovery – Extending QlikView’s mobile capability to allow users to make decisions ‘on location’ taking advantage of being in a particular place at a particular time.
  • Rapid Analytic App Development – New capabilities to improve application development.
  • Enterprise Platform – Improvements to capabilities designed to improve performance of large deployments and make them easier for IT to secure and administer

 

Getting the Right Balance – Internal vs External Business Intelligence Skills

One challenge a lot of organisations face when implementing or looking to enhance their Business Intelligence capability is deciding on the right mix of internal and external skills to provide the necessary organisational elasticity required by the business. Inside Info’s Managing Consultant of our Microsoft Business Intelligence Practice, Ian Forrester, explores the elements that make up a business intelligence capability and the importance of those elements in the success of the overall initiative. 

There are typically four areas where specific skills are required. They are as follows:

  • Business engagement and requirements definition
  • Data warehouse architecture and build
  • Report and dashboard tool development
  • User education and training

The skills requirement for each of these areas is different and in assessing the appropriate approach, it is important to understand the ideal skills profile, the duration of the requirement and the implications of having the wrong skills. The framework provided in this article has been designed to facilitate this decision making process.

Industry analysts like Gartner and recruitment specialists like Michael Page, point to a skills shortage this year in IT, with the area of Business Intelligence seen as the biggest technical priority according to the majority of CIO’s surveyed in Michael Page’s 2011 CIO Viewpoint survey.  According to Michael Page, CIO’s are trending towards service providers who can offer CIO level peers to execute projects because of a lack of internal capacity.  The ultimate success however of any BI initiative, depends on getting the right blend of internal skills to ensure the solution is relevant and utilised, and right level  of specialist external skills to ensure technical quality and robustness of the platform.