Tuesday, December 22, 2015

Self-service Business Intelligence for Commercial Property Leasing

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.

Self-service Business Intelligence for Commercial Property Leasing

Download the white paper here for a step-by-step introduction to Self-service Business Intelligence for Commercial Property Leasing.

Click2Analyze Sales Performance Analysis Dashboard

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 due to its rapid deployment and ease-of-use.

Sample Analysis
  • What is my market share per country and product?
  • What are my target sales and how are my current sales against these target values?
  • How many customers were acquired, retained or lost in the present month, quarter or year?
  • What are my lost sales due to lost customers? 
  • What is the frequency of purchase of my active customers?
  • Who are my high selling and highly profitable or low selling but highly profitable customers?
KMS Sales Performance Analysis Dashboard
KMS Sales Performance Analysis Dashboard
The KMS Sales Analysis dashboard is being used by more than 100 companies is Asia Pacific to drive growth and boost sales.

The package consists of:
  • KMS Click2Analyze Sales dashboard
    • Executive dashboard
    • Sales Analysis dashboard
    • Customer Statistics dashboard
    • Portfolio Analysis dashboard
    • What-if Analysis dashboard
    • Detailed Report dashboard
    • KPI dashboard
  • Software licenses for 5 named users
  • One year of maintenance
  • User training
You can find more details here : KMS Click2Analyze Sales Dashboard Product Page

Thursday, December 10, 2015

Overcoming Oracle Essbase challenges with Jedox Webinar

It's video week at Jedox! This recorded webinar addresses Hyperion Essbase users and reviews key issues faced by business users and developers of legacy calculation engines and planning systems. Learn how the modern Jedox platform can address these challenges to provide greater user satisfaction, less IT burden, and a rapid Return on Investment.

Organizations that simplify and optimize planning, forecasting and reporting free up valuable resources, so they can focus on growth. However, many organizations feel stuck with slow platforms that are not user-friendly, expensive to maintain, and difficult to upgrade.

Often users were forced to select a tool like SAP Business Planning and Consolidation (BPC), or Oracle because it came with their ERP, rather than by selecting the most suitable tool from the market. Other tools like Hyperion Essbase and Hyperion Planning had some unique features 20 years ago, but have been overtaken by newer and more modern platforms that combine planning with visualizations and analytics.

Jedox is built on Excel, the world’s most used reporting and planning tool. Jedox is designed to enable you to leverage your Excel skills to transform your reporting, budgeting and analysis. Easy to use so you can focus on business outcomes.

Jedox software creates extremely effective budgeting and planning and Corporate Performance Management solutions for systematic data analysis.

Its core is a cell-oriented, multi-dimensional in-memory OLAP server that has been especially designed for planning, analysis, reporting, and data consolidation.

Wednesday, December 9, 2015

QlikView 12 Released

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) would release QlikView 12 in 2012. But QlikView 12 has not been been released or talked about until late 2015.

In early 2013, Qlik started to talk about a new platform called QlikView.Next. It was expected to be the next QlikView but Qlik released the desktop edition of the product in 2014 and renamed it to Qlik Sense.

QlikView.Next is renamed as Qlik Sense because it is not the next version of QlikView. It is a new business intelligence platform. Its data loading and cleansing engine and expression engine seems to be same as QlikView but front end is entirely different:

QlikView is a tool for situations where you want prepared business applications, i.e. applications created by developers who put a lot of thought into the data model, the layout, the charts and the formulae; and deliver the applications to end-users who consume the applications. We call this Guided Analytics. The end-user has total freedom to explore data, select, drill down and navigate in the information, and can this way discover both questions and answers in the data. The end-user is however limited when it comes to creating new visualizations. This type of situation will without doubt be common for many, many years to come. 
Qlik Sense is a tool for situations where you don’t want to pre-can so much. Instead you want the user to have the freedom to create a layout of his own and in it, new visualizations; charts that the developer couldn’t imagine that the user wants to see. You want Self-service data discovery, which means a much more active, modern, engaged user. In addition, Qlik Sense is much easier to use when you have a touch screen, and is adaptive to different screen sizes and form factors. On the whole, Qlik Sense is a much more modern tool.
Source : QlikView and Qlik Sense

Qlik Sense is not QlikView 12
Qlik Sense is not QlikView 12. In fact, Qlik Sense is not QlikView at all.

My estimation was that they would release a new QlikView version named QlikView 12. And  I was hopefully this new server will support both QlikView and Qlik Sense as front end. For example Access Point of QlikView 12 would display both QlikSense and QlikView applications. I wrote since both Qlik Sense and QlikView have common expression and data engine, it should not be difficult". It seems like this feature is not on the roadmap at all.

Monday, November 30, 2015

Data Visualization by Tableau Introduction in Singapore

If you are looking for a chance to know Tableau data visualization platform in Singapore, Knowledge Management Solutions, a Business Intelligence and Data Visualization solution provider and Tableau partner in Singapore, is offering a half day free Introduction to Data Visualization with Tableau 9

Tableau is a business intelligence and data visualization software platform that allows anyone to connect to data in a few clicks, then visualize and create interactive, shareable dashboards with a few more. It’s easy enough that any Excel user can learn it, but powerful enough to satisfy even the most complex analytical problems. Securely sharing your findings with others only takes seconds. The result is BI software that you can trust to actually deliver answers to the people that need them.

Tableau Singapore event - Introduction to Tableau 9.0
Data Visualization with Tableau in Singapore
Who should attend?
Business people, General Managers, Analysts, Operations Managers, IT Managers, HR Managers, Finance Managers, Marketing Managers, Sales Managers, Service Managers, etc.

What you will learn during the event:
You will witness the self-service Business Intelligence capabilities of Tableau platform as well as different components of the platform.

Seats are limited hence we encourage you to register early to secure your seat(s).

Tableau Event Details
Date : 10th December 2015
Time: 09 am to 12 pm
Venue: South Beach Tower, Level 10, 38 Beach Road, Singapore 189767 (Tableau Software APAC Office)

1.     Introduction to Tableau Business Intelligence and Data Visualization
2.     What is new in Tableau 9
3.     Data extraction from different sources
4.     Data modeling
5.     Building your data visualizations in Tableau
6.     Dashboards and stories

See the details here.

Thursday, September 3, 2015

Free Qlik Sense / QlikView Demo Session in Singapore on September 16th

Qlik has recently released a new version and more mature version of Qlik Sense, Qlik Sense 2.0, and also a brand new concept / platform named Qlik Analytics Platform. Besides, Qlik Sense now also has a cloud version where you can use this cutting edge data visualization software as SaaS.

There will be a QlikView / Qlik Sense introduction event at 9am - 11am on 16th September 2015 in Singapore Management University. In this event, you will not only have a chance to learn about Qlik product and platform family, you will also have chance to see the newest features of Qlik Sense and QlikView.

This event is a free and for registration and details you can visit Free Qlik workshop for Business Users and IT professionals: Interactive Business Reporting and Analysis with QlikView & Qlik Sense page.

Qlik Sense
Qlik Sense
Imagine analytics so intuitive, anyone in your company could easily create personalized reports and dynamic dashboards to explore vast amounts of data and find meaningful insights. And imagine if this could be done while ensuring accuracy and reliability of data and analytics. That’s Qlik Sense —a revolutionary visual analytics platform that supports self-service visualization, guided analytics apps and dashboards, embedded analytics, and reporting, all within a governed framework that offers enterprise scalability and trust for IT.

The QlikView Business Discovery platform delivers true self-service BI that empowers business users by driving innovative decision-making.

Monday, August 31, 2015

Qlik Sense Cloud

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.

Monday, August 17, 2015

Financial Data Analysis by Jedox event in Singapore

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 free Jedox event is Singapore Management University 60 Stamford road
Singapore, 178900.

For more details and registration, please visit Register for Jedox Finance Data Analysis event. Watch a short video of Jedox below to see the capabilities.

Friday, August 14, 2015

Sales Performance, Pipeline and Productivity Data Analysis Dashboard Demo by Qlik Sense

Would monitoring the health of your pipeline by region, industry, function, rep, division, etc. help you improve forecast accuracy? Are you remaining competitive in your industry and can you identify areas for improvement to increase your win rate? 

Sales Performance, Pipeline and Productivity Data Analysis model holds the sales opportunities in pipe and closed business. Additional information like region, division, customer industy, segment and function is available to dissect, analyze and forecast. Finally, there is a competitive analysis view to see who the company compete against and the company's effectiveness in those competitive situations.

The application consist of the followign views :

  • Dashboard - This view shows the current quarter's sales pipeline.
  • Performance / Effectiveness Dashboard - This view helps to analyze the current quarter sales performance (Quote, Pipeline, Revenue) by region and Sales rep.
  • Pipeline Analysis Dashboard - This dashboard helps to deconstruct the sales pipeline by aging, sector and function.
  • Quote Analysis Dashboard - This dashboard helps to verify quote attainment by region and sales representative.
  • Competitive Analysis Dashboard - This dashboard helps to explore the competitive landscape and review wins and losses.
You can access this Qlik Sense Sales Performance Analysis Dashboard here : Sales Performance, Pipeline and Productivity Data Analysis Dashboard

Sales Performance, Pipeline and Productivity Data Analysis Dashboard Demo by Qlik Sense
Sales Performance, Pipeline and Productivity Data Analysis Dashboard Demo by Qlik Sense

Supply Chain - Inventory and Product Availability Dashboard Demo by Qlik Sense

This Supply Chain - Inventory and Product Availability Dashboard demo application provides visibility into inventory levels (in-store, depot, and in transit) and potential insights into availability through out of stock measures and sales information. Lack of availability can mean lost potential sales. Too much inventory creates excess costs.

The demo app is designed to give visibility into the Retail environment to Consumer Products companies. The source data is the Retailer who makes information available from their store EPOS and depot systems to the Consumer Goods company.

This demo gives consumer goods company and any retailers a picture of product stock levels in store, depot and in transit, as well as sales analysis. The app supports Consumer Products companies in their effort through allowing users to reduce out-of-stocks and lost sales potential, as well as identifying potential alternative sources of replenishment.

This data can be viewed at the multiple levels and locations, in providing Consumer Products companies with detailed insights to support key business processes such as forecasting, demand and supply management.

This Qlik Sense demo is available online and you can access it by filling Data Analytics with Qlik Demo/App Request Form (select "Supply Chain - Inventory and Product Availability Dashboard Demo by Qlik Sense" in drop down).

Data visualization for suppply chain and inventory
This Qlik Sense supply chain, inventory and product availability dashboard demo illustrates how you can use Qlik Sense to potentially gain insights through visualizations and try to optimize inventory and availability not just one side of the equation.
About Qlik Sense

Qlik Sense analytics software is a business intelligence tool designed for the enterprise. Developed by Qlik, the company behind popular QlikView Business Intelligence Platform, Qlik Sense makes visual dashboard creation simple and intuitive, but doesn’t stop there. Qlik Sense also makes it easy to explore the data so you can understand what’s happening and why. Ask questions. Follow your intuition. Seamlessly navigate vast amounts of data from multiple sources. Then share your insights visually and accurately with other users directly or through the cloud.

Tuesday, August 11, 2015

Retail Store Performance Dashboard Demo

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 drop-down menu).

QlikView Retail Store Performance Dashboard
Retail Store Performance Dashboard showcases how QlikView can be used to analyze retail store data from regional level all the way down to the individual store level.
About QlikView

QlikView is one of the most popular business intelligence platforms which offers revolutionary in-memory, associative data analysis at your finger tip. Focused on easy and smooth end user experience, the platform enables easy search and access to data with state-of-the-art visualization as well as Google like easy to use and intuitive experience.

OEE Analysis Dashboard by QlikView

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 equipment, including the number of pieces produced, hours of runtime and downtime and causes for downtime.

OEE Calculation  formula is Availability x Performance x Quality:

  • Availability is a measure of how much the process is available vs how much time it was supposed to
  • be available, it is measured as (actual uptime)/(scheduled run time)
  • Performance measures how fast the process runs, it is measured as (pieces produced per unit time) /
  • (standard rate for process)
  • Quality measures the quality of the process, it is typically measured as first pass yield: (Good pieces
  • on first try – no rework) / (total pieces input to process)
You can reach the online application and whitepaper about the app here : Data Analytics with Qlik Demo/App Request Form (select "OEE Analysis Dashboard by QlikView" in the drop-down).

QlikView OEE Analysis Application Dashboard View
OEE Analysis Application Dashboard View
About QlikView

QlikView is one of the most popular business intelligence platforms which offers revolutionary in-memory, associative data analysis at your finger tip. Focused on easy and smooth end user experience, the platform enables easy search and access to data with state-of-the-art visualization as well as Google like easy to use and intuitive experience.

Monday, August 10, 2015

Microsoft Power BI Desktop

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 been relatively weak in presentation layer of BI. The new Power BI Desktop, which also first time in Microsoft's BI journey freed presentation from MS Excel, may well change that. Power BI online services are also quite easy to use. You can setup an account with your work email and immediately enjoy free services. Paid service as seen above is also not expensive and only comes at US$9.99 per user per month.

Currently the platform is only on cloud and no option to install it in-house. This will definitely prevent a lot of companies to seriously adapt it but its free entry price, ease of use and minimum setup requirements, it will probably be a very powerful cloud based self-service BI platform.

You can watch a 3 minutes Getting Started with the Power BI Desktop below.

How Qlikview works?

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 and makes maintenance easy. Plus, in-memory integration of QlikView application layer and data model enables fast execution which usually eliminates the necessity to aggregate the operational data for performance reasons.

Wednesday, August 5, 2015

MicroStrategy Singapore Symposium

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 Desktop 10 (a $600 value). During the conference, attendees will also get to attend hands-on workshops to gain first-hand experience with MicroStrategy 10 and its revolutionary enterprise-ready data discovery and visualization capabilities.

You can see the details and full agenda at MicroStrategy Singapore Symposium 2015 page.

MicroStrategy Desktop 10

Credit Risk Management Dashboard Demo by QlikView Business Intelligence Platform

Business and risk have always been seen to go hand-in-hand and the need for banks to strengthen their risk management framework is vital. Exposing the true risk profile to the users has been a challenging business problem due to multiple data sources and differences in operational processes and metric definitions.

To mitigate this situation, a financial institution should provide a holistic view of the risks faced by the organization at any point in time. When up-to-date information on risks can be analyzed and put at the users fingertips, firms will inevitably find it easier to maximize profit AND reduce risk.

The purpose of the Credit Risk Management demo is to illustrate how QlikView can be used by a
financial institution to manage credit risk. By providing a unified picture to the entire business, QlikView helps everyone have the same, up to date, picture of their risk exposure instead of disparate spreadsheets floating around the business. Credit Risk data is also interesting to the entire Business, not only the Credit Analysts. Are we pricing the products correctly? Are we in compliance with regulations? Should we continue to do business in a specific market or geographic segment? These are all questions that could be asked against Credit Risk data.

QlikView Credit Risk Management Dashboard application is designed to cover the following main analysis areas:
  • Exposure Concentration Analysis (Exposure : The total amount of credit extended to a client by the lending company)
  • Correlation Analysis
  • Probability of Default (PD) Analysis (The likelyhood that a borrower will default on their loans)
  • Exposure Comperison
  • Capital Allocation Modeling
The application allows you to load your own data. If you download the zip file below, you will see a RiskData Excel file in it. You can input your data in this format by simply opening Credit Risk Management Dashboard app and selecting File > Reload.

You can access the application by following the below links:
QlikView Credit Risk Management Dashboard Template online demo
QlikView Credit Risk Management Dashboard QVW file (opens with QlikView)

QlikView for Salesforce.com

Salesforce is the of the most popular cloud based Customer Relationships Management (CRM) product available in the market today. Organizations today invested in Salesforce.com today can also enjoy the business intelligence interfaces provided for them to make sense of Salesforce data. But leaving CRM functionality in Salesforce.com while integrating the data from Salesforce into a more flexible but third party BI platform has definite advantages. For example, you can blend data from Salesforce and other in-house systems to analyze it together.

QlikView provides a Salesforce connector which can extract data into QlikView to develop powerful analysis, reports and dashboards and empower users with rich and interactive visualization. These dashboards in return will help you to improve key CRM KPIs like sales forecast accuracy, pinpoint cross-sell and up-sell opportunities and achieve more customer centric service and support delivery.

You can instantly try out how a QlikView dashboard for Salesforce.com works using QlikView for Salesforce template. This QlikView application is designed specifically to provide Salesforce users with key pipeline-related data at their fingertips. The application allows you to easily load and analyze all your CRM information directly from your salesforce.com account.

With QlikView for Salesforce, information can be explored intuitively and visually – with drill-down detail in just a few clicks. Reloading your own data must be performed on your local machine. Before attempting to reload your own data, please download the QVW and print the white paper using the links below.

QlikView for Salesforce Template Package Links:

QlikView for Salesforce dashboard screenshot
QlikView for Salesforce provides ready to use business intelligence dashboard for Salesforce customers.
Please fill in QlikView for Salesforce.com Template Request form so we can send you the package below :
  • QlikView Template for Salesforce Online Application (Opens in Web Browser)
  • QlikView Template for Salesforce.com video demo (mp4)
  • Download QlikView Template for Salesforce.com QVW file (QlikView Application File) - You will need a licensed QlikView Desktop application to open this file.
  • Download QlikView Template for Salesforce.com Self Executable EXE file  - You do not need QlikView desktop to open and run this.

See also Customer retention & churn analysis by Enhencer post for an example of customer data analytics.

QlikView SAP Template

QlikView SAP Templates known as "SAP Qlikstart Templates" are pre-built QlikView applications to be used with QlikView SAP Netwaver connector. QlikStart templates provide a sample set of key information deliverables for your SAP™ modules that combine data extraction scripts, pre defined calculations and a variety of sample analyses in a front end application combining dashboards, charts and reports. QlikStart templates contain value for both IT and the business, for IT a series of predefined extraction scripts with table joins and calculations provide valuable insight.  The business user can start using the predefined reports to analyse their business within a very short time.

You can download SAP Qlikstart Templates here. The link contains a 29 MB Rar file which has three documents for each template below : two QlikView qvw files for data extraction and actual application and a document to explain how to setup these QlikView SAP templates. 

If you do not have a licensed QlikView application, you will not be able to open these applications. Fortunately some of the templates are also available online for you to experiment with using nothing more than your browser. We have added explanation and link for such templates below. The QlikView applications in the template are:

This QlikStart for SAP Accounts Payableallows you to rapidly analyze the following KPIs:
  • Analyze each suppliers A/P status.
  • Make an action on inactive accounts
  • Analyze amounts by buckets
  • Analyze days of sales outstanding
  • Ad Hoc analysis of aged debt
SAP AP – Accounts Payable allowing you to analyse aged debt, DSO and payment information by company, business area, supplier plus many others. Business questions answered include:
  • What percentage of my company suppliers have an aged debt of over 150 days?
  • What is the payment profile of my suppliers?
  • What is the Overdue payment and DSO split for my companies and suppliers?
  • Plus the ability analyse individual payment items down to document number. 
Click on the image below to access the browser based application.

SAP AP – Accounts Payable QlikView Template
SAP AP – Accounts Payable QlikView Template
This QlikStart for SAP Accounts Receivable allows you to rapidly analyze the following KPIs:
  • Analyze each suppliers A/R status.
  • Make an action on inactive accounts.
  • Analyze amounts by buckets
  • Analyze days of sales outstanding.
  • Ad Hoc analysis of aged debt
This QlikStart for SAP Controlling allows you to rapidly analyze the following KPIs:
  • Analyse actual and planned costs by company
  • Analyse cost centre variance
  • Analyse profit centre details 
  • Drill down to individual account code details
  • Analyse account and activity cost items
This QlikStart for SAP HR allows you to rapidly analyze the following KPIs:
  • Analyze Company Employee Distribution
  • Identify Employee Demographics
  • Monitor Employee Absentees
  • Analyse Pay and Hours
  • Be Empowered to Make Faster More Accurate Decisions
This QlikStart for SAP Materials Management allows you to rapidly analyze the following KPIs:
  • Analyze purchase order spend and quantity 
  • Analyze requisitions over time and by plant
  • Analyze reminders/urging documents
  • Overview of physical inventory
  • Analyze invoiced purchase orders
  • Analyze deliveries by qty and time
SAP MM – Materials Management – Purchasing allowing you to analyse supplier purchase order spend, requisitions, documents,physical inventory by supplier, plant, purchasing organisation plus many others. Business questions answered include:
  • How much do my purchasing organisations spend annually?
  • Which plant has the highest purchase requisition amount?
  • What are the invoice numbers for my highest purchase order values?
  • Plus the drill down capability to individual purchase order numbers.
Click on the image below to access the browser based application.

QlikView Template for SAP MM
QlikView Template for SAP MM
This QlikStart for SAP Production Planning allows you to rapidly analyze the following KPIs:
QlikStart for SAP Production Planning allows you to rapidly analyse the following KPI's:
  • Analyze production orders by plant and material
  • Analyze routings by type and operation
  • Analyze capacity requirements by work centre and plant
  • Analyze capacity details
  • Analyze work centre breakdowns by plant
  • Analyze BOM components
This QlikStart for SAP Project Systems allows you to rapidly analyze the following KPIs:
QlikStart for SAP Project Systems allows you to rapidly analyse the following KPI's:
  • Analyze actual and planned project costs
  • Analyze project spend by company and WBS
  • Analyse project cost variance
  • Analyze network schedules and time scales
  • Drill down to WBS elements and networks
  • Analyse completed milestones
This QlikStart for SAP Sales and Distribution allows you to rapidly analyse the following KPI's:
  • Analyze Billing by company,division,sales organisations 
  • Analyze Billing by fiscal trends
  • Analyze deliveries by company,division,sales organisations
  • Analyze sales roders by company,division and sales organisations
  • Drill down to individual sales ordersAnalyze on time and late deliveries
SAP SD – Sales and Distribution allows you to analyse billing, sales orders, shipments and schedules by company, division, customer, sales organisation plus many others. Business questions answered include:
  • Who is my best customer from a sales perspective and which product do they buy?
  • How many deliveries are late / on time?
  • Which Materials and divisions generate the highest margin?
  • How is the billing compared to last year and how does it trend over time?
  • Plus the ability to drill down to individual sales order and billing document line item detail.
Click on the image below to access the browser based application.

QlikView SAP Sales Disribution Template
SAP Sales Disribution QlikView Template
This QlikStart for SAP General Ledger allows you to rapidly analyze the following KPIs:

QlikStart for SAP General Ledger allows you to rapidly analyse the following KPI's:
  • Analyse chart of account hierarchies
  • Analyse YTD ledger details
  • Analyse customer and vendor positions
  • Drill down to individual account code details
  • Analyse document number and line details

Tuesday, August 4, 2015

QlikView for SAP: How to unlock the value of your data hidden in SAP

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 data hidden in SAP" on 13th August 2015, 9:30am - 11am, Singapore Management University. In this event several aspects and benefits of using QlikView as data analysis and business intelligence platform on top of SAP installation.

QlikView for SAP event in Singapore will present the benefits of QlikView BI platform for SAP users.

You can follow the link or image below for details and registration :

QlikView for SAP Event

Tuesday, July 14, 2015

Free Tableau Demo in Singapore for manufacturing

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 Tableau can help them to make sense of their data.

Tableau in Singapore
Tableau for Business Users offers a 1.5 hour Tableau demo in Singapore.

Monday, April 27, 2015

Free Hands On Qlikview workshop in Singapore

QlikView is one of the most powerful and popular business intelligence platform in the market today. It has a really powerful interactive interface, data massaging module and rich set of charts, reports and graphs which can help you to create almost all types of business intelligence dashboards you need.

Although complex QlikView dashboards may require some experience and IT skills, one do not need these two to benefit QlikView. With a very short learning curve, you can easily start to create powerful dashboards on your own. To do this, you can follow online QlikView videos, free QlikView training modules as well as regular QlikView classroom trainings in your area.

You can also join a hands on QlikView workshop to kick start your QlikView experience. Knowledge Management Solutions, a QlikView partner based in Singapore (with offices in Kuala Lumpur, Bangkok and Jakarta) is regularly conducting QlikView hands on workshops in Singapore to introduce QlikView to business users. Open to every business executive who are struggling to make sense of their data with traditional BI tools and plain old MS Excel, these 4 hours workshops are very popular and easy way to start your QlikView experience.

The next QlikView workshop (the company also calls them QlikView apps build sessions) will be on June 18th 2015 between 09:30 AM and 13:30 PM. In this workshop, participants are required to bring their own laptop where they download and install QlikView free desktop edition. This free QlikView desktop addition does not expire so whatever you create can be used personally on the laptop.

QlikView is one of the most powerful business intelligence and analysis platform in the
market today.

In this workshop you will learn how to bring in data to QlikView, create your very first QlikView dashboard, master QlikView's unique associative experience and enhance your dashboard to create multi-view, multi dimensional BI applications to drill-down and slice-and-dice among your data to do data analysis.

You can register the event here : Knowledge Management Solutions Free QlikView Singapore Workshops Registration. The event will be at Singapore Management University. If you cannot make it on that day, do not worry. Just register and when you receive an email from the company with a request to be informed about the next QlikView workshops.

Monday, April 13, 2015

Oil and Gas Analytics

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
Oil and Gas Analytics dashboard screen - Production Surveilance
A sample Oil and Gas Analytics dashboard screen - Production Surveilance
You can download the White paper on Interactive Business Intelligence for Oil & Gas Industry.

Wednesday, February 25, 2015

Gartner Magic Quadrant for Business Intelligence and Analytics Platforms 2015

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 acquisition of the company by Vista Equity Partners (which closed in December 2014). In the near term, Tibco will operate as a privately held single entity, as it did when it was publicly traded, but the longer-term intentions of Vista are not yet clear. The ingredients for a leading BI and analytics platform are present with Tibco's many strategic acquisitions; however, Vista will need to implement major changes to address the sales model and execution issues, which have plagued Tibco historically, in order to regain traction and once again be recognized as a market leader."
  • Logi Analytics is moving closer to leaders quadrant. 

Gartner Magic Quadrant for Business Intelligence 2015

Gartner Magic Quadrant for Business Intelligence 2015

Tuesday, January 6, 2015

Navision Sales Analyzer Dashboard

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.