Data Analysis Help

Tableau is one of the best Business Intelligence and Data Visualization software in the market today. Its game changing drag-and-drop, self-service experience is unparalleled and it is popularly used worldwide. Tableau is highly optimized and works quite fast in many applications but in applications where you need to read large volumes of data, like hundreds of millions or billions of rows, it can get dramatically slow (yes there are some illustrations of Tableau with large datasets but they are very isolated, single report demos and in a real life dashboard things can get pretty slow if you need to reaf more than 100 million rows). Tableau is aware of this problem so back in March 2016, they have purchased HyPer , a high performance database system initially developed as a research project at the Technical University of Munich (TUM). Unfortunately, they did not release any plan for the availability of HyPer yet. Luckily, there is already a solution out there, more established and po...

Tableau is one of the most popular Business Intelligence software in the market today. Many organizations are adapting Tableau recently and trying to migrate from their old Business Intelligence platform to Tableau. In this post, we will focus on QlikView to Tableau migration. Effort needed to migrate from QlikView to Tableau depends on the way your QlikView software is implemented. In some cases, the data needed for QlikView Dashboard is completely prepared in a 3rd party tool so when migrating to Tableau, you do not need to convert ETL (extraction - transformation - load) code. But in most cases, ETL for QlikView is implemented using Qlik's own query language, AQL (QlikView is based upon patented technology called Associative Query Logic (AQL)). Tableau does not provide a native ETL functionality so when migrating from QlikView to Tableau, you will probably need a 3rd solution to implement ETL for Tableau. The exception above is of course keeping QlikView for ETL and just convert...

Tableau may be a great data visualization tool but it has very limited functionality for data blending and data integration. Worse, most customers misunderstand "self service business intelligence concept" and think that they will get Tableau and without any data integration they can connect to the databases and create visualization (customers are actually made to believe this with Tableau's sales pitch). Unfortunately, most business data is stored in complex relational database management systems or ERP which is very difficult, if not impossible to connect directly. Thus, many companies buying self service business intelligence solution realize that they cannot use it effectively due to this limitation. Solution for this Tableau data integration problem is developing a  data integration with a non-Tableau application which is purpose built for this function. This data integration layer will simplify, consolidate and usually enrich the complex transactional data and will ...

Marketing data analysis allows marketing people to align strategies to address market shifts, customer sentiment, and developing trends. Used correctly, a data analysis dashboard for marketing can boost marketing ROI through better targeting and campaign performance. This Marketing Performance Analysis Dashboard , named Marketing 360, is an online business intelligence demo app brings together data from multiple sources into a one-stop-shop view. Analyze Marketing's performance across the organization from digital performance of the website to pipeline and install base engagement. The demo application is composed of below screens to analyze different details and aspects of the marketing data : Marketing Performance Dashboard View - Summarizes Awareness (Total Visits), Pipeline (Number of Opportunities Created) and Engagement (Net New Logos). Awareness View - This section analysis visits to company site through Web, Social Media and Inbound (CRM). Pipeline View - This section sho...

Tableau Software is finally making the big change in the way it sells its business intelligence products: they have announced their new  Tableau subscription pricing  for all its products, including Tableau Desktop and Tableau Server. These new pricing model will potentially lower the threshold for users looking to gain access to a full-fledged analytics platform. Tableau subscription prices are now as below : Tableau Desktop Personal subscription price is US$35 per user per month Tableau Desktop Professional subscription price is $70 per user per month Tableau Server subscription price is US$35 per user per month Tableau Enterprise offerings prices are not public but this is also available under  Tableau subscription model. Tableau perpetual prices are $1000 for Tableau Desktop Personal, $2000 for Tableau Desktop Professional and $1000 for Tableau Server per user. The perpetual model also comes with 20% yearly license maintenance. Since Microsoft Power BI entered the mar...

Commercial Real Estate Leasing is an extremely competitive sector of the Real Estate Industry and the players are required to be imaginative and have information at their fingertips to avail of the opportunities that arise as well as quickly respond to government, economic and market pressures that might challenge their business models. Having market and business metrics at the tips of your fingers therefore becomes a necessity. Interactive Business Intelligence gives Commercial Real-estate professionals number of benefits: Allows you to have a data based strategy for real estate portfolio optimization. Provides a broad spectrum of self-service, easy to use business intelligence tools with customizable levels of access, reporting or analytics per user. Allows for both internal and external performance measurement and benchmarking. Interactive BI breaks down multidimensional Data mashups with beautiful, rich data visualizations that support your natural ability to spot patterns. Downloa...

Your ability to track, analyze, and understand all aspects of your sales – what is being sold to which customer, when and by whom – is critical to identifying profitable customers. It is also important to keep track of your company's and sales people's sales performance to keep the company sales at top. KMS Click2Analyze Sales Performance Analysis dashboard is compatible with any ERP system enabling companies to analyze their sales performance, giving you the full range of analysis, from the dashboard to the individual transaction. Now with Click2Analyze Sales Analysis dashboard, you have complete visibility to business-critical customer, sales, product, budget, and channel data in a single, powerful yet easy-to-use business performancemanagement application. Click2Analyze Sales Performance Analysis Dashboard can easily be integrated with your enterprise systems, even for companies running different ERP and CRM systems in differentdivisions. The dashboard provides a rapid ROI...

Qlik has finally released the new version of its business intelligence platform, QlikView 12. The major change in the QlikView 12 compared to QlikView 11 (which was released in 2011) is the data engine. QlikView now uses the same QIX Associative Data Indexing Engine (QIX) that powers Qlik Sense . Other than the data engine improvement, QlikView also has enhancements in its security and mobile experience. All functions on web client are now available on touch devices without limitations.  Other changes are improved clustering, native connectors to web services and accessibility of Data Market to QlikView. Qlik has released a new platform, Qlik Sense, in September 2014, after two years without any major release and the release date of QlikView 12 was since awaited by existing users of the platform. The last major release of QlikView was QlikView 11 released in 2011. Since the company was releasing a new version in every year the expectation was that Qlik (then called QlikTech...

Qlik's self-service business intelligence Qlik Sense now has a cloud based offering which is named Qlik Sense Cloud . This is a hosted, Software as a service, version of Qlik Sense where you can privately share your applications with others. Qlik Sense Cloud pricing information is currently not available and in fact, the current version is free! You can add up to 5 users freely to view your Qlik Sense application on your cloud. Currently the total app size is restricted to 1 GB and each Qlik Sense application cannot be more than 25 MB in size. Below, you can watch a nice introduction and getting started to Qlik Sense Cloud video. You can simply create your Qlik Sense applications on Qlik Sense Desktop (also freely available) and upload them to your Qlik Sense cloud. Below in Qlik Sense Cloud - Registration and Orientation video, Michael Tarallo from Qlik shows how easy it is to register with Qlik Sense Cloud.

Jedox is an Excel based financial planning software. Financial data is often difficult to audit and unreliable because of ineffective controls in Excel. The issues surface in overworked teams, manually reconciling data scattered across multiple systems and countries. Traditional BI/PM software needed specialised technical teams to develop and maintain them. Waterfall implementations meant Finance filled out requirement documents, explained basic finance concepts to the technical team - and then waited for the result. The business process (that Finance was still ultimately responsible for) was no longer under Finance’s control. To manage this, agile companies adopt the Jedox Suite. Jedox gives you unified planning, consolidation and reporting in one intuitive solution. Knowledge Management Solutions , an authorized Jedox partner in Singapore, is having a free event to introduce this great platform to finance specialists in Singapore at 3pm - 5pm, on 28th August 2015. The address of this...

Retail Store Performance dashboard demo is a free, online QlikView demo which showcases how an interactive business intelligence platform can be used to analyze the performance of stores from a regional level all the way down to the individual store level. The user can analyze sales versus budget, sales versu target, customer satisfaction, Year to date scorecard for regions, as well as detailed sales trends and numbers. The application also has an integrated map chart where the user can perform geospatial analysis. The Retail Store Performance dashboard ties corporate strategy to store level execution at all levels of the store operations hierarchy.  Timely and accurate store performance metrics can be analyzed in the corporate office, in a store, or through a mobile device for traveling store operations and field management. You can access the application by filing  Data Analytics with Qlik Demo/App Request Form  (select "Retail Store Performance Dashboard Demo" in the ...

Overall Equipment Effectiveness (OEE) provides an overall measure of performance for a process. Developed by Seiichi Nakajima in the 1960s to evaluate how effectively a manufacturing operation is utilized, OEE is commonly used as a key performance indicator (KPI) in conjunction with lean manufacturing efforts to provide an indicator of success. OEE Analysis Dashboard by QlikView is a rare freely available business intelligence example which provides a performance overview for manufacturing, provide diagnostic capabilities in order to improve performance over time to understand the current level of performance: What is it getting better or worse?  Why is my performance at its current level?  What are the drivers behind the performance?  By machine, By cell, By time period?  What resources do I invest where to have the biggest impact? The application sits on top of a shop floor data collection system and would contains information about the performance of shop floor...

Microsoft’s cloud-based business analytics tool, Power BI, came out with a brand new addition in late July 2015,  Power BI Desktop . Officially named Power BI Designer, this free desktop tool aims business analysts and can be used to analyze data in a wide range of data sources. Power BI is also capable of ETL (Extract, Transform & Load) and can cleanse, transform and model interrelationships between the data; explore the resulting mashed up datasets. Microsoft Power BI Desktop can create interactive reports and dashboards with simple drag and drops and these reports can then be published to the Power BI service for use by end users. As Microsoft announced earlier in 2015, users will be able to choose between two versions of Power BI – a free service and a paid one (Power BI Pro), which comes with additional features and data capacity, costing US$9.99 per user per month. Microsoft indeed has a very powerful platform offering for business intelligence but it has be...

The core feature of QlikView is an in-memory, associative data model which feeds the visualization in a very unique way. In a traditional business intelligence application, the data visualization layer interacts with data through queries which are basically scripts executed by the platform. So if you for example select a country to drill-down to the sales numbers in that country, the data visualization layer runs a script, queries the data, retrieves the data from the data layer and updates the charts and reports in the screen. QlikView on the other hand do not use this query mechanism. Application and data layer are tightly integrated in QlikView and data relationships are handled in engine level not application level. This means the QlikView charts and reports are integrated with in-memory data model and they know how to filter themselves when user drills down. The mechanism above help QlikView developers to write significantly less software scripts which shortens the development an...

MicroStrategy has announced that  2015 MicroStrategy Symposium Series is coming to the Marina Bay Sands on October 21st. In this event, MicroStrategy will showcase how MicroStrategy 10 brings ease-of-use to true enterprise-grade analytics. Latest in Enterprise Analytics, Mobility, and Security will also be shared. You can have first hand experience of how MicroStrategy 10 sets new standards for data discovery, big data, advanced analytics, and more. MicroStrategy Singapore Symposium will be packed with keynotes, technical sessions, and workshops focused on enterprise analytics, mobile, and security. The full agenda is available online. • Visionary keynotes from MicroStrategy executives and customers • Informative sessions on data discovery, big data, enterprise security, and much more • Hands-on workshops with MicroStrategy 10 • The opportunity to network with technology innovators, partners, and sponsors All attendees will receive a complimentary copy of MicroStrategy...

QlikView is one of the most popular business intelligence platform today. Its popularity is not an accident. With its super fast and user-friendly data discovery interface, rapid development cycle, fast response time, it provides a very capable platform to extract the hidden value in the enterprise data. SAP is on the other hand one of the most popular ERP solutions in the market today. Although it also provides BI capabilities, many customers choose QlikView as their BI platform to extract data from SAP. With QlikView, you can consolidate information from SAP BI, SAP R/3 or any other data source easily and then search and analyze this data with Google-like ease and speed. QlikView also provides a QlikView Connector for SAP Netweaver which enables SAP customers to get easy and quick access to all the data hidden in different SAP systems in QlikView. KMS , an authorized QlikView partner in Singapore is having a free event named "QlikView for SAP: How to unlock the value of your da...

Tableau Software has recently released their brand new data visualization platform version, Tableau 9.0 in April and in June officially released the new version in Singapore. If you are keen to try out this mind blowing self-service business intelligence platform, you can download a free Tableau download (14-days trial) and also watch this 23 minute full demo of the platform, Getting Started with Tableau . For those in Singapore, Knowledge Management Solutions, an official Tableau Software partner based in Singapore (with offices in Kuala Lumpur, Bangkok and Jakarta) is conducting a full 1.5 hour demo of Tableau on 31st July 2015 - 9:30am - 11am in Singapore Management University campus. You can see the details and form to register here : Tableau for Business Users Event . This Tableau 9.0 demo for Business Users event is regularly conducted and this session targets manufacturing. Still, it is offers a demo for every one including non-manufacturing industries to experience how Tab...

Oil prices shrunk from $115 a barrel to less than $50 a barrel forcing energy firms to reconsider their strategy. Break-even price of producing a barrel of oil needs to be reduced to counter falling prices. Reports have stated that better data analysis could boost production of oil & gas companies by up to 6-8 percent. There is a whitepaper about Oil and Gas Analytics from Knowledge Management Solutions, a Singapore based Business Intelligence and Analytics solution provider, explains how BI can boost Oil & Gas Industry : Exploration and production analysis Loss code analysis Drilling and Completion analysis Health, Safety, Environment & Security analysis Production Optimization analysis A sample Oil and Gas Analytics dashboard screen - Production Surveilance You can download the White paper on Interactive Business Intelligence for Oil & Gas Industry .

Gartner's infamous  Magic Quadrant for Business Intelligence and Analytics Platforms for 2015 has just been released. You can see the quadrant below. We will write about it a little later. Also compare it with Magic Quadrant of 2014 (see below). For now some notes : Tableau's stellar rise to leaders quadrant and now becoming the outliner performing better than all others is much more pronounced now in 2015. And this is still before the exiting new release of Version 9. Gartner says "Tableau has clearly defined the market in terms of data discovery, with a focus on "helping people see and understand their data." It is currently the perceived market leader with most vendors viewing Tableau as the competitor they most want to be like and to beat. At a minimum, they want to stop the encroachment of Tableau into their customer accounts." Tibco Software fell from leaders to visionaries. Gartner says "The future of Tibco itself is uncertain, following the acq...

Navision Sales Analyzer is a Business Intelligence Dashboard for sales which built on the powerful Tableau data visualization platform. Developed by Singapore based  Knowledge Management Solutions , it empowers Microsoft Navision users to analyze and visualize data and to make strategic calls about sales and marketing. Plan revenue Analyze the impact of promotions Discover performance of products Compare product market share Vs. market growth Perform market basket analysis See customer buying behaviour clearly You can watch a video introduction of Navision sales analyzer below. If you would like to find out more, KMS has a free demo event to introduce the product to the market. Click here to join : KMS Navision Sales Analyzer Demo .