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.


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:

SAP_AP_QlikStart 
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
SAP_AR_QlikStart
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
SAP_CO_QlikStart 
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
SAP_HR_QlikStart
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
SAP_MM_QlikStart
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
SAP_PP_QlikStart
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
SAP_PS_QlikStart 
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
SAP_SD_QlikStart
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
SAP_FI_GL_QlikStart 
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