Data Analysis Help

Qlik has recently intoduced its brand new product, Qlik Sense, and as a Qlik partner, Knowledge Management Solutions is starting a series of apps build events in the upcoming months to introduce this exiting new product. Known as "Build Your First Data Visualization Dashboard in half-day", this 4 hours free Qlik Sense introduction offers a hands-on experience with this new self-service Business Intelligence solution. Qlik Sense free desktop application will be used in the session so there is not license cost at all. The apps build session is on 9th January 2015 between 10:00 AM and 14:00 PM and will cover a hands-on session where you will build your first Qlik Sense Business Intelligence Dashboard with a Qlik Sense expert. See below for details and to register. Build Your First Data Visualization Dashboard in half-day! Data Analytics with Qlik Sense You are invited to join Knowledge Management Solutions Pte Ltd for Data visualization by Qlik Sense Desktop Session. The hands...

With skyrocketing revenues and number of 100K USD deals (a gauge showing enterprise adaptation of a business software), Tableau is getting fast into enterprise-wide BI deployment. As the emphasis on "Tableau for Enterprise" was significantly higher in this years Tableau Customer Conference (September 2014), Tableau Software has also released Tableau Drive, a  methodology for scaling out self-service analytics. So what is Tableau Drive? This is a freely available methodology relying on iterative, agile methods that are faster and more effective than traditional long-cycle deployment. A cornerstone of this approach is a new model of a partnership between business and IT. In Drive methodology, IT owns the “Center of Operations” and business owns analytics and the “Center of Evangelism”. Tableau Software released the methodology ahead of Tableau 9.0 which is expected in the first quarter of 2015. Tableau 9.0 is expected to have a lot of improvements in scalability some ...

Tableau , one of the most popular BI tools in the market today, is truly an amazing and comprehensive platform. Yet, many still think that Tableau just an eye candy toy tool, good for making pretty pictures but not for a serious, enterprise BI level platform. This is absolutely not true (if this was true, Tableau would not be in the leaders quadrant of Magic Quadrant for Business Intelligence and Analytics Platforms 2014 ). Tableau offers tremendous efficiency, productivity, flexibility, performance and cost savings. Some discovers this accidentally, they bring Tableau in the project as their personal tool to understand data and then Tableau's highly viral nature carries it into the hearth of enterprise BI. Some innovative project teams head starts enterprise BI with Tableau and usually awarded successful implementations ("usually" because some teams will always have the ability to screw up projects even with great tools). You can see this in numbers. In Q2 2014, there we...

QlikView is one of the most popular and powerful business intelligence platform in the market today. QlikView's distruptive technology makes it a key player in business intelligence industry. With its flexible and powerful analytics environment, building QlikView apps can be mastered by both developers and business users. Qlik (the company behind QlikView) provides two basic courses for those who wish to learn QlikView : QlikView Designer Training courses for business users and QlikView Developer Training for advanced developers. QlikView Designer course is 2 days and QlikView Developer Training is 3 days. Those who wish to take 3 days developer training needs to take the 2 days designer training. These two courses are what you can find when you take training from Qlik or some partners of Qlik. But there are alternatives. There is for example a QlikView 11 for Developers material, which covers a more hands-on approach then the standard training. In this course, some powerful and co...

This powerful white boarding and demo of a Revenue and Profit Analysis of a shipping company is a rare gem which shows how a powerful data visualization plarform (Tableau in this case) can help companies to analyze their data and dig deep into "why"s. The video is prepared by a Tableau customer in Indonesia, a leading Shipping and Shipyard Company named PT Usda Seroja Jaya, to introduce their new data visualization platform, Tableau, to their users. The video starts with a white boarding presentation to illustrate how data analytics can help the company to improve decision making process. The second half of the video is a detailed Tableau demo, a rare data analytics demo for shipping industry. The Tableau demo is also a nice self-service BI presentation for this powerful application. Tableau is business intelligence software that allows anyone to connect to data in a few clicks, then visualize and create interactive, sharable dashboards with a few more. It's easy enough t...

Singapore, October 8th 2014 – Singapore based Business Intelligence Solutions Provider Knowledge Management Solutions Pte. Ltd. ( KMS ) has announced today that it has been voted and endorsed as the 2014 Top vendor of BI Information Delivery & Analytics by CXO Honour Singapore . Over 700 Chief Information Officers (CIOs) across Singapore were invited to take part in an unbiased online survey with CIOs naming their preferred Vendors in selected segments and categories over the full technology landscape. The award came as Knowledge Management Solutions was preparing to celebrate its 10th year in Business Intelligence in December 2014. The company, which started as a vendor specific BI solution provider successfully turned itself into a BI Information Delivery and Analytics Solutions Provider in the previous years, offering a decade old experience in BI on some of the best platforms in the market today, QlikView, Tableau and Jedox. KMS has received the award at by CXO Honour Singapo...

Tableau Desktop has been rated as the best business intelligence platform by business software reviews site G2 Crowd users.  Tableau, the long time category winner, was followed by QlikView, TIBCO Spotfire, SAS BI and Oracle BI. The Grid for Business Intelligence by G2 Crowd rates and profiles business intelligence products. Products shown on the Grid for Business Intelligence have received a minimum of 10 reviews in data gathered by September 19th, 2014. Products are ranked by customer satisfaction (based on user reviews) and market presence (based on market share, vendor size, and social impact) and placed into four categories on the Grid : Leaders, Contenders, Niche and High Performers. Leaders offer Business Intelligence products that are rated highly by G2 Crowd users and have substantial scale, market share, and global support and service resources. According to G2 Crowd Grid for Business Intelligence, Tableau Desktop, QlikView, TIBCO Sportfire, SAS BI and Oracle BI we...

Asset Under Management analysis is an important part of any financial institution in asset management, private banking and wealth management business. The data can be quite huge and data from many different sources need to be combined to get the big picture. Unfortunately, this process is quite manual in many organizations where plain old MS Excel is used  to perform analysis with usually poor results. We have seen that a powerful business intelligence platform can be leveraged for wealth management, asset management and private banking institutions to increase analyis productivity greatly. But what is developed is usually not public (even dashboard layouts are protected) so you can not see a lot of nice asset management business intelligence dashboards. This rare Asset Management demo provides an analysis of assets under management by various dimensions such as asset class, investor, fund type and region. Users can look up funds and their performance and analyze fund details. The...

Retailer POS Data Analysis Dashboard demo is designed to give visibility into the Retail environment for Consumer Products companies. The source of data is the Retailer who makes information available from their store EPOS and depot systems to the Consumer Goods company. This demo gives any retailers a picture of product stock levels in store, depot and in transit, as well as sales analysis. The app supports you in you efforts to deliver improved product availability through allowing your organization to reduce out-of-stocks and lost sales potential, as well as identifying potential alternative sources of replenishment. The POS Data Analysis is developed on powerful QlikView Business Intelligence platform and utilizes its associative features as well as state-of-the-art GUI. Over 3,000 Retail and Wholesale Distribution companies globally rely on QlikView to empower business users and decision-makers today, by providing access to on-demand analysis, insights and business discovery. ...

Microsoft Excel spreadsheet application is by far the most widely used business application on the planet. It is free (well actually not but since comes with every business PC it is perceived to be free), simple, fast, flexible and gives independence to its users. But, a big but, is that MS Excel based processes have several drawbacks : it is inconsistent and error prone, maintenance - intensive, complex and not audit proof, slow and manual to consolidate, difficult to access and collaborate, provides low data-security and there is no process control and workflow. Although these drawbacks are universal, MS Excel became the basis of complex business processes with many stakeholders and although it sits outside IT-managed systems, it holds business-critical reporting and planning and analysis. Enter the Excel hell ! Jedox is a business intelligence and coorporate performance management platform positioning itself as EXCELPLUS. Excel plus means that JEDOX removes Excel’s drawbac...

Tableau Software has finally released the new version of its benchmark setting data visualization and business intelligence platform, Tableau 9.0 today on April 7th 2015. The new version comes with an entirely new experience for Tableau Server, significant performance improvements, new data preparation features, drag-and-drop analytics, updates to mapping and much more. Tableau 8 has been a phenomenal success[1] for data visualization and business intelligence platform provider Tableau Software after the release of Tableau 8.3, everybody was waiting for the new version : Tableau 9.  Tableau 9 release date  is postponed a few times. In Tableau Conference 2013, the expectation was that Tableau 8.1 would be released in fall 2013, Tableau 8.2 in winter 2014 and Tableau 9.0 later in 2014. Tableau 9.0 release date is later pushed to Q1 2015 and in March one more time to April 2015. But this is a release worth waiting. There are many significant improvements in Tableau 9.0 over Table...

Jedox is a Self Service Business Intelligence, Analytics and Performance Management platform developed by Jedox AG based in Freiburg im Breisgau/Germany. With a modular structure, JEDOX platform uses Microsoft Excel as its user interface on the one hand and a Jedox-specific spreadsheet on the other, both of which can be used in all common browsers. Jedox is unique in a sense that while most business intelligence solutions try to replace MS Excel based analysis and planning process entirely with their platform (and usually fails to do so because at one point things are exported to Excel), Jedox puts the powerful MS Excel sheet in the heart of their solution. By doing this they provide a familiar interface to users while enhancing business intelligence capabilities far beyond MS Excel. This is actually what JEDOX offers in a nutshell : Excel Plus. The modular architecture of JEDOX has a cell-oriented, multi-dimensional in-memory OLAP server that has been especially designed for...

Since version 5.1, European business intelligence (BI) software provider Jedox offers a powerful data-driven modeling feature, Jedox users can create an entire OLAP model with existing data at the click of a button, with the model immediately available for analysis, reporting and planning tasks. This new Jedox 5.1 data-driven modeling feature uniquely combines the content depth of classic OLAP tools and the simplicity of state-of-the-art data discovery software. How data driven modelling works? First, you start with your existing data in Excel. With one click, you create a Jedox in-memory cube. You can now immediately report, plan and collaborate across your organization. This works by automatically generating a sophisticated load (ETL) script to read your data from Excel. The ETL you can edit, extend, and schedule in order to refresh your data as often as you need. The result is you can instantly take any Excel data and immediately use this live through Jedox anywhere. ...

Qlik has finally released its long awaited Qlik Sense platform on 17th September 2014. Qlik Sense is a next-generation self-service data visualization application from Qlik (see more here What is Qlik Sense? ). According to Qlik, Qlik Sense is built on the QIX Associative Data Indexing engine , the second generation of Qlik’s proven and patented engine technology. It has some dramatic changes compared to QlikView , such as drag-and-drop visualization, server side dashboard development and distribution, a token based pricing ( Qlik Sense pricing ), overhauled data extraction, integrated maps, new charts, etc. Is Qlik Sense new QlikView or QlikView 12? The answer is no. Qlik started the project as QlikView,Next which was implying that the next product will be the new version of QlikView which is on version 11 released in 2011. But Qlik has changed the name to Qlik Sense. It makes sense because this product is different. Not entirely but different. Conceptually, Qlik Sense and QlikVie...

Qlik Sense is a next-generation self-service data visualization application from Qlik, a leading data discovery platform provider. Launched on September 17th 2014 , Qlik Sense empowers everyone to easily create a range of flexible, interactive visualizations that drive exploration and discovery through intuition. Qlik Sense is a new product and is not QlikView 12 . So now basically Qlik offers two BI platforms: Qlik Sense and QlikView. You can read more about the difference between Qlik Sense and Qlik View : Qlik Sense vs Qlik View . Qlik Sense is built on the QIX Associative Data Indexing engine , the second generation of Qlik’s proven and patented engine technology. Associative Data Indexing allows people to explore data relationships across many sources that would otherwise be hidden in hierarchical or query-based approaches. Qlik Sense drives faster time to insight with intuitive exploration, smart search, and smart visualizations. It broadens knowledge sharing with data storytell...

Qlik has launched its long awaited product named Qlik Sense. Composed of Qlik Sense, a governed, server-based data visualization and discovery application, and Qlik Sense Desktop, a free Windows desktop self-service data visualization application, the new suite enables server side BI development and distribution, drag-and-drop visualization, smart search and data storytelling. Qlik Sense pricing is also completely overhauled. The licensing in Qlik Sense (Server) is based on tokens, which are used to allocate access passes that allow users to access Qlik Sense. Token-based licensing model of Qlik Sense is to provide greater flexibility for license management. Qlik Sense tokens can be allocated to named users, or leveraged across multiple login sessions for one or more users. With the token-based licensing model, customers can deploy multiple servers, across multiple geographies, to optimize for performance and availability without paying any additional costs. Qlik Sense pric...

The wait is over. Qlik, one of the leading data discovery solution provider, has launched Qlik Sense, its device-independent, self-service visualization and discovery product engineered for enterprise-class governance and performance. Qlik Sense product suite is composed of Qlik Sense , a governed, server-based data visualization and discovery application and Qlik Sense Desktop , free Windows desktop self-service data visualization application. Here is the full press release from Qlik : Qlik , a leader in data discovery, today introduced general availability of Qlik Sense , the first device-independent, self-service visualization and discovery product engineered for enterprise-class governance and performance.  Built on a modern architecture and powered by the patented, industry-proven Qlik data indexing engine, Qlik Sense gives users the unrestricted ability to create personalized data analyses and explore the relationships that exist in data to reveal connections i...

Helsana Group, a leading health and accident insurer in Switzerland, will use uses QlikView Business Intelligence platform to consolidate and analyze data from Teradata, Microsoft and Oracle data warehouses. QlikView will enable Helsana users to perform quick and easy data analysis in the areas of sales, management control and information management. Helsana required a dynamic analysis tool which is alternative to their existing and cumbersome reporting. Traditional business intelligence solutions are too complex and creates a lot of extra work for the IT department so the company turned to an easy to use and flexible QlikView. QlikView enables business users to assemble data from multiple sources, explore it, make discoveries, and uncover insights that enable them to solve business problems in new ways. QlikView works the way the mind works. Users conduct searches and interact with dynamic dashboards and analytics from any device. They ask and answer streams of question...

Project Elastic is the code name for a new tablet-based product by Tableau Software which was first announced in Tableau Conference 2014 . Tableau Elastic Technology is designed specifically with mobile users in mind and aims to help users to ask questions to their data using just their two fingers and making fairly complicated queries, are just a tap, swipe, scroll or pinch away. Tableau's VP of Mobile, Dave Story, has demonstrated the product in annual Tableau customer conference. What we can see up to now is that Tableau Software is basically building a new iPad app (or tablet app). In the presentation, Dave Story took an email attachment (a data file listing sales information about a local sandwich shop) and opened it in the Tableau Elastic app. The app immediately opens with a view of a chart showing categories of products sold at the shop. As other Tableau user interfaces, Elastic is also "drag-and-drop" based. With taps, swipes and scrolls, you can easily change...

Singapore Technologies Electronics (ST Electronics) and IBM Singapore has announced that they have signed a Memorandum of Understanding  to collaborate on transport data analytics and to exchange technical information about products and capabilities, specifically on the use of smart analytics for urban mobility. With transport data analytics, governments and companies can better understand the commuting patterns and can optimize the traffic and transportation systems. But since the input data for the transport analytics would be huge and the mathematical foundation of the problem is very complex, powerful platforms as well as expert skills are needed to utilize the analytics. "IBM is working with organisations around the world to make cities smarter with data driven solutions to attain new levels of insight and efficiency through analytics" said Janet Ang, Managing Director, IBM Singapore. "Our collaboration with ST Electronics (Info-Comm Systems) leverages on IBM’s glob...

Tableau 8.2 was released on June 18, 2014 and Tableau 8.2 Tour stop in Singapore was held on Wednesday July 23, 2014. The new release is already in 8.2.2 (released in August 21) and contains a lot of exiting features. The release includes the first-ever Mac OS version of Tableau Desktop, Story Points for interactive, data-driven storytelling, a more visual connection experience with data previews and improved experience in defining data table joins, and updated maps, in addition to enhancements to simplify administration and support of Tableau Server. Here is a list of major new features in Tableau 8.2. Tableau Desktop on the Mac The revolutionary technology of Tableau Desktop now runs natively on the Mac. It’s the full analytics package, built to support high-resolution Retina displays, Mac-specific controls, and also all of your existing Tableau workbooks. Story Points One of the most anticipated features of Tableau 8.2, Story Telling lets you create compelling, interactive, data...

Insurance data analysis  can help all types of insurance firms (including property & casualty, life, health, etc) to improve profitability across the board. But to make it happen, insurance companies also need to have the right tool. This rare Insurance data analysis dashboard ( Insurance dashboard in short) is a business and profitability management application for the insurance industry developed on powerful QlikView Business Intelligence reporting platform. The application covers a range of business areas, and presents a compelling story for how a powerful Business Discovery tool can help companies improve profitability across the board. This application contains the transaction level details of insurance claims and policies. The sample data is on customers, policies, and claims from a midsize insurance carrier. The dashboard allows its users to analyze this year’s performance based on the number of claims and policies as well as loss ratio. Customer mix is captured using ...

QlikView is a fantastic business intelligence platform but it does have some limitations when it comes to security management. Although the application is quite secure (it is used in a lot of banks where security is extremely important) but setting up security is cumbersome. QlikView platform by default lacks a single, easy manageable and scalable security module. The built-in security framework is highly manual and script based to setup. Although it is manageable for 50-100 users, security management becomes a real burden for a few hundred to few thousand users. In addition to manageability issues, QlikView default security framework lacks the following: Role based security setup assignment – Every users security configuration is done separately even a large group of users share the same security configuration where role based security assignment is crucial. GUI based security configuration – Security configuration in QlikView is script based. Although QlikView Publisher (an...