Tuesday, August 1, 2017

Data Analytics for Online Shops

Making shopping a smooth and easy experience is the goal of many online shops. But how can easy website navigation be optimized? Unlike the physical shops, you cannot talk to the sales people in the online shops and a customer should find his or her way through the online shop. And unlike pysical shops, online shops can have hundreds of thousands of visitors every day.

To optimize the shopping experience, some important questions should be answered :

  • Why do customers put products into their shopping cart and do not buy them at the end?
  • Was it because of the sales process or he/she liked another product simply better?
  • What impact has a customer's drop from a detail page?
  • Where are the differences in customer behavior depending on the different product groups,
  • Customer types or assortments?
  • What are the figures compared to the previous year?
  • Were there any technical errors? Was the accessibility of all pages always guaranteed?

Traditionally, answering these questions require a lot of work and usually takes a few days a month to prepare answers and presentations for the management. Since the process is slow and requires many man-days, most companies cannot perform it anytime they want or in the frequency they need.

German business consultancy company Mayato automatize this process using data preparation, analytics and visualization tools.

The company extracts data from the operational database to in-memory, ultra-fast analytics database named EXASOL. Traditionally, large volumes of data need to be extracted from the database, loaded into R statistical language based scripts and run; and then loaded back to database for analysis and visualization.

Markus Dill, Managing Director at Mayato, explains the importance of good analytics for companies in the manufacturing sector and why having an analytic database that is low-maintenance such as EXASOL is critical for business success.

But EXASOL has built-in R capabilities so R scripts can be run on EXASOLs ultra-fast and high performance analytics environment. The company uses Talend ETL tool for automated data extraction, transformation and load. The data extraction, crunching (using R) and data visualization (in Tableau software) are all automated without human intervention.

The combination of Talend, EXASOL and Tableau fully automated the process and reduced its report generation cycle from days to hours.

Big Data Analytics in real-time with EXASOL and Tableau webinar

If you are using Tableau’s great BI, reporting and visualization software to see and understand your data, but are struggling with performance or just want to overcome the limitations of Tableau Data Extracts (TDE), EXASOL is the solution you need. Using EXASOL as the analytic database engine to power your Tableau server and client, means that you will be able to accelerate your reporting and visualizations dramatically by boosting your Tableau performance.

EXASOL is the world’s fastest in-memory, high-performance (Massive Parallel Processing or MPP), analytic database which is designed for big data analytics. EXASOL makes large volumes of data analysis in real-time possible, which helps you to accelerate your Business Intelligence and Analytics applications. EXASOL is ideally suited for real-time big data reporting, analysis, and advanced analytics.

EXASOL also enables in database analytics. It supports R, Python, Java, Lua or your preferred programming language to build analytic applications to unearth key insights.



Event Information:
Venue : Webinar (details will be provided after registration)
Dates / Times : You can select any of the 2 time-slots below:
August 4th 2017 10:00 – 11:00 AM Singapore Time
August 18th 2017 10:00 – 11:00 PM Singapore Time

About Infolytics Global

The founders of Infolytics Global Pte Ltd (Infolytics) have experience in providing Big Data Analytics and Data Visualization solutions for all sizes of companies for over 15 years. With our vast knowledge and experience in Data Warehousing and Business Intelligence we have the capability for being the “go to” company for BI solutions. Our expertise is on delivering insights using data visualisation and Big Data Analytics.

We have vast experience in end to end project management of leading BI software like Tableau, QlikView and Qlik Sense. Our team has been part of some of the largest Tableau and QlikView deployments in Asia. One such example is a large semiconductor manufacturing company with more than 3,000 BI users globally. 


Monday, June 26, 2017

Scenario Planning and Optimization in Integrated Business Planning Webinar

By utilizing a well-executed Integrated Business Planning process (IBP), companies can achieve cross-functional alignment, optimize costs and improve customer satisfaction. The need for both strategic and tactical agility is manifested in the ability to anticipate changes in demand and supply conditions, investigate ad-hoc scenarios and generate executable plans.

Integrated Business Planning process has extended the Sales & Operations Planning process and has now been the best practice in the industry. The process is led by senior management and aims to align company plans every month to allocate the critical resources - people, equipment, inventory, materials, time and money - to most effectively satisfy your customers, in a profitable way.

IBP is a complex process and unfortunately, many companies are trying to run it manually using spreadsheets with the help of their ERP or SCM software. To make this manual process practical, the companies does a lot of aggregation and abstraction and try to focus more on bottleneck resolution rather than optimization. The process also does not allow significant what-if-analysis (scenario planning).

There is actually a way to significantly automate and improve the IBP process with focus on speed, optimization and multiple scenario analysis : Mathematical optimization. This method is available since early 1940s but it was mostly a luxury for significantly large companies until recently. Now with the advances in computer technology and advanced planning and scheduling technologies, mathematical optimization can be applied to IBP process.

In the Scenario Planning and Optimization in Integrated Business Planning (IBP) webinar to discover how companies like ASMLVestel and Trakya Cam are utilizing ICRON Advanced Planning and Scheduling to evaluate multiple scenarios, rapidly generate optimized plans and compare financial and operational KPIs to make informed decisions in their S&OP/IBP processes.

Click here or image below to access the webinar recording : IBP Webinar video.

Scenario Planning and Optimization in Integrated Business Planning Webinar

Webinar is conducted by the Chief Technology Officer of ICRON Technologies, Zeki Caner Taşkın. Mr. Taşkın joined ICRON in 2001 and specializes on large-scale optimization methods and software. He was named the recipient of the 2010 Pritsker Doctoral Dissertation Award given by the Institute of Industrial Engineers (IIE) and his research has appeared in many leading Operations Research journals. Caner received his Ph.D. from the University of Florida and as an academic he teaches in the Industrial Engineering department of Bogazici University.

Friday, June 23, 2017

Next Generation Advanced Planning and Scheduling for Manufacturing Webinar

Production Planning and Scheduling in modern manufacturing environment has become quite complex. But unfortunately many ERP solutions, even in their production planning and scheduling modules, do not provide a satisfactory mechanism to handle the complexity of the problem. These ERP, MRP or MPS mechanisms are transactional and designed for mass production facilities of past with low product mix, generous inventory sizes and relatively simple supply chain networks.

Since the complexity is not addressed by the systems in hand, most planners rely on a cumbersome, time-consuming, error-prone and manual process run on many Excel files. But this does not need to be the case and there is a superior and highly successful process out there : Advanced Planning and Scheduling.

Advanced Planning and Scheduling (APS) is a software platform which deploys advanced mathematical algorithms or logic to perform optimization and/or and/or simulation on finite capacity scheduling, sourcing, capital planning, resource planning, forecasting, demand planning and others.

In this webinar, you will have a chance to see a modern Advanced Planning and Scheduling Platform, ICRON, in action. The webinar first introduces APS and why it is needed. Then, it lists some of the characteristics (or musts) of a next generation Advanced Planning and Scheduling platform for manufacturing. Later you will see a demo of the application (the specific domain selected in this demo is paper production planning and scheduling but the concept can also be applied to broader process manufacturing).

The demo displays the capabilities of ICRON APS in 3 levels of planning : Tactical Planning, Operational Planning and Dispatching. The corresponding modules of the application in the demo are ICRON S&OP, ICRON Capacity Planner and ICRON Detailed Scheduler.

The next webinar is on July 17th 2017 on below time :

Singapore / Malaysia / Hong Kong / Taiwan / Philippines                : 09:00 – 10:00 AM
Thailand / Indonesia / Vietnam                                                          : 08:00 – 09:00 AM

You can use this link to register : Next Generation Advanced Planning and Scheduling for Manufacturing Webinar Registration

You can watch an old webinar below.


Tuesday, June 20, 2017

Advanced Planning and Scheduling for Electronics Manufacturing : Vestel Case

Manufacturing in 21st century is a complex task. It is mostly Make-to-order and the production is highly capital-intensive. The high product mix combined with large number of components or manufacturing tasks makes it already a big challenge to plan but because there is little to no stock to shield manufacturing from changes in demand, frequent schedule changes creates extra complexity.

Most manufacturing companies have ERP and Supply Chain Management systems but these do not help a lot. The logic in these systems are developed and matured in 1980s and they are transactional systems, developed for make-to-stock, low product-mix, high order volume manufacturing.

Since ERP systems are not helping a lot, most planners use spreadsheets to create a more executable and feasible plan. But this manual process is cumbersome, time consuming, slow, inflexible and error prone. It does not also allow to deploy optimization (a supply chain which is not optimized is usually 15% - 20% more costly to operate). Excel is free, readily available but Excel based planning is costly.

But there is a solution which is much superior when it comes to planning : Advanced Planning and Scheduling. Advanced Planning and Scheduling is a software platform which deploys advanced mathematical algorithms or logic to perform optimization, and/or simulation on finite capacity scheduling, sourcing, capital planning, resource planning, forecasting, demand planning and others. This platform can :

  • reduce planning / scheduling cycle by 70 – 90% 
  • shift the organization from reactive to proactive planning
  • create a centralized planning / scheduling for all (SVOT)
  • reduce overtime, inventory costs, WIP times, setup times
  • increase customer service level and revenue
Electronics manufacturers can benefit from an APS platform tremendously. There are some manufacturers deploying this technology for years. One such company is Vestel Group.

Advanced Planning and Scheduling plarform
Advanced Planning and Scheduling plarform
Vestel Group is comprised of 24 companies operating in manufacturing, software and  technology development, mareting, and distribution fields in the consumer electronics,  household appliances, mobile technologies, LED lighting, and defense industries.  Vestel exports its products to 149 countries under the leading Japanese and European  brands. 

Vestel uses a highly flexible, integrated, and automated S&OP process developed on ICRON Advanced Planning and Scheduling solution. ICRON’s solution – which was developed, tested, integrated with Vestel’s existing ERP system – was implemented over the course of six months and became immediately fully operational.

You can read how Vestel uses Advanced Planning and Scheduling for different levels of planning such as Sales & Operations Planning, Capacity Planning and detailed scheduling here : Vestel Advanced Planning and Scheduling Case Study.

Advanced Aero MRO Planning and Scheduling

The global aviation fleet is set to grow steadily over the coming decade, with global CAGR at 3.4%, and areas such as Asia-Pacific, seeing CAGR of 4.2%. This will significantly increase the demand for aircraft Maintenance Repair and Overhaul in the following years.

Increased demand will introduce new competitive forces and an increasingly demanding customer base. MRO companies will respond by capacity increase, overtime or hardware technology updates to accommodate the increase but this wont be enough or even if it would be enough the constraints on resources and the sheer cost of increasing capacity will be prohibitive.

A more intelligent way to handle the growth will be using game changer IT Technologies. Using advanced data analytics, predictive maintenance, data visualization and algorithmic supply chain planning and scheduling will enable companies to significantly increase the productivity and predictability of their MRO operations.

You may have heard the first 3 IT Technologies a lot recently but the last one, algorithmic supply chain planning and scheduling, is used in classical manufacturing for decades. This technology is based on Advanced Planning and Scheduling and automates and optimizes the generation of plans and schedules for supply chain and repair operations.

In MRO business, planning and scheduling is very complex. It requires planning and scheduling of thousands or tens of thousands of repair operations w.r.t tight physical resources, regulations, certifications, spare parts, etc. The environment is also very unpredictable since there are frequent rescheduling due to post strip/inspection repair needs, unplanned Aircraft On Ground (AOG) repairs and part cannibalization, machine breakdowns, spare part unavailability's, certified personnel absence, etc. Moreover, MRO plan, shop floor execution data and ERP data are not blended and visualized so the shop floor is a black box.

Singapore Aero Engine Services Limited (SAESL) uses Advanced MRO Planning and Scheduling
for its repair operations since 2007.
Algorithmic MRO planning and scheduling applications, such as ICRON Advanced MRO Planning solution, introduces 3 key concepts : Finite Capacity Planning and Optimization, High Performance, Automated Planning and Web Based Data Distribution and Visualization. Algorithmic optimization modeling introduced by ICRON can overcome significant MRO planning problems.

ICRON Aero MRO Planning and Scheduling is implemented in some large MRO facilities like Singapore Aero Engine Services Limited (SAESL) and Singapore Airlines Engineering Company. You can find the case study for SAESL here : ICRON SAESL Case Study.

Finite Capacity Planning allows better planning and sequencing w.r.t all your constraints will produce better and more realistic results. With finite capacity planning, you know any bottle neck and lateness due to these bottlenecks so you can take action.

MRO ERP systems (like SAP) assumes infinite capacity when detailed scheduling. This will mask a lot of lateness until it is too late. This is costly in MRO. Finite capacity planning allows you to see the results of capacity problems immediately. This allows you to take actions. It also helps you to answer repair history, current status and future schedule of the component in repair shops.

Optimization ensures the generated plan is the best possible one towards achieving your goals such as :

  • Reduced Turn Around Times
  • Reduced Overtime costs
  • Reduced Total Setup times
  • Reduced # of late jobs
  • Increased customer satisfaction / revenue
  • Increased facility productivity
  • Increased workload balance on technicians

Monday, June 19, 2017

What is Exasol?

Data analytics on very large sets of data can be frustrating in terms of performance. Many Business Intelligence applications like Tableau can annoyingly get slow when you are trying to perform real time analysis on large data sets. Solution is usually consolidating and thus reducing the size of the data but this requires extra development and scripts to maintain plus, you lose the granularity of the data.

A good solution to this problem is EXASOL, worlds fastest in-memory, high-performance (Massive Parallel Processing or MPP), analytic database which is designed for big data analytics. EXASOL makes large volumes of data analysis in rel-time possible, which helps you to accelerate your Business Intelligence and Analytics applications. EXASOL is ideally suited for real-time big data reporting, analysis, and advanced analytics.

EXASOL deploys two techniques together : Massive Parallel Processing (MPP) which enables clusters of hardware running EXASOL to achieve the task and in-memory analytics. The database also deploys columnar data compression and storage.

Like a standard RDBMS, EXASOL uses a standard SQL interfaces avoiding the trap of NoSQL skill shortages and easy compatibility with pre-existing applications and data structures.

In below video, you can see how EXASOL can speed up Tableau. The example shows how data residing in two large tables (2.5 billion and 24 billion rows) can be analyzed in Tableau. Tableau has a connector to EXASOL.



EXASOLs in-memory technology enables large amounts of data to be processed in RAM which is significantly faster than processing data residing on hard disk. EXASOL also deploys column-based storage and compression to reduce the number of I/O operations and amount of data needed for processing in main memory and accelerates analytical performance. And Massively Parallel Processing (MPP) enables queries to be distributed across all nodes in a cluster using optimized, parallel algorithms that process data locally in each node’s main memory. The EXASOL intelligent database is self-optimizing and tuning-free. It gives you more time to focus on analytics and insights, not administration.

EXASOL also enables in database analytics. It supports R, Python, Java, Lua or your preferred programming language to build analytic applications to unearth key insights.