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.


Monday, June 12, 2017

Dramatically speed up your Tableau visualizations with EXASOL

Tableau is one of the best Business Intelligence and Data Visualization software in the market today. Its game changing drag-and-drop, self-service experience is unparalleled and it is popularly used worldwide.

Tableau is highly optimized and works quite fast in many applications but in applications where you need to read large volumes of data, like hundreds of millions or billions of rows, it can get dramatically slow (yes there are some illustrations of Tableau with large datasets but they are very isolated, single report demos and in a real life dashboard things can get pretty slow if you need to reaf more than 100 million rows).

Tableau is aware of this problem so back in March 2016, they have purchased HyPer, a high performance database system initially developed as a research project at the Technical University of Munich (TUM). Unfortunately, they did not release any plan for the availability of HyPer yet.

Luckily, there is already a solution out there, more established and powerful than HyPer. The solution is Exasol.

EXASOL analytic database management software is currently the fastest, in-memory analytic database in the world. Since 2008 EXASOL led the Transaction Processing Performance Council's TPC-H benchmark for analytical scenarios, in all data volume-based categories 100 GB, 300 GB, 1 TB, 3 TB, 10 TB, 30 TB and 100 TB.

If you are using Tableau’s great BI, reporting and visualization software to see and understand your data, but are struggling with performance, then you need EXASOL. Using EXASOL as the analytic engine to power your Tableau front-end tool means that you will be able to accelerate your reporting and visualizations dramatically.

You can see Exasol in action below. Note that, Tableau already has a native connection to Exasol.



Exasol does one thing and one thing extremely well. Its high-performance, in-memory, MPP database is specifically designed for in-memory analytics. Exasol analytic database achieves lightning-fast performance with linear scalability by combining in-memory technology, columnar compression and storage, and massively parallel processing.

Since 2014, EXASOL has maintained its position as the undisputed leader in TPC-H benchmarks.  From data volumes that range from 100GB right up to 100TB, EXASOL holds the number one position - by a significant margin - over other solutions, for both raw performance and price-performance.
Exasol also offers out-of-the-box support for R, Python, Java and Lua. EXASOL also allows you to integrate the analytics programming language of your choice and use it for in-database analytics. It can easily connect to your existing SQL-based BI, reporting and data integration tools via ODBC, JDBC, .NET as well as a JSON-based web socket API.

Friday, May 19, 2017

Tableau 10 Data Visualization Software Webinar (with Step-by-step demo)

You are invited to Tableau 10 Data Visualization Software webinar on June 9th and June 16th 2017.

In this free event, you will have a chance to learn how a state of the art data visualization platform like Tableau can help you to explore and analyse your data. Thanks to Tableau’s intuitive GUI and drag-and-drop data visualization capabilities, everyone in your organization can easily create flexible, interactive visualizations and make meaningful decisions.

The event will also demonstrate a step-by-step Tableau demo which will show how you can create stunning interactive data analysis dashboards intuitively by just simple drag-and-drop interfaces. You will learn how to explore data with smart visualizations that automatically adapts to the parameters you set — no need for developers, data scientists or designers. We will also cover what are new functionalities in Tableau 10 and Tableau 10.2.

There are 4 date / time slots available for the event.



Tableau Event Information:
Venue : Webinar (details will be provided after registration)

Dates / Times : You can select any of the 4 time-slots below:
  • June 9th 2017 09:00 – 10:00 Singapore Time
  • June 9th 2017 14:00 – 15:00 Singapore Time
  • June 16th 2017 09:00 – 10:00 Singapore Time
  • June 16th 2017 14:00 – 15:00 Singapore Time
Agenda :
- Introduction to Tableau Data Visualization
- Tableau Data Visualization Features
- Tableau 10.2 Demo

This event is conducted by 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 visualization and Big Data Analytics.

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

http://infolyticsglobal.com

Sunday, May 7, 2017

Procurement Data Analytics Dashboard

Analytics is the process of using quantitative methods to derive actionable insight and outcomes from data. It involves the capture and use of the data to support fact-based decision making and gaining competitive advantage. It typically involves reporting on what has happened in the past but using tools like predictive analytics based on historical data, you can also estimate what will happen in the future.

To catch a glimpse on what does Procurement Data Analytics looks like, you can take a look at this Procurement Dashboard sample. This application illustrates how an organization can analyze their spending and contracts. Users can analyze procurement through the use of purchase orders, contract coverage, payment patterns, etc. to determine which parts of the organization make their payments on time and have outstanding balances, monitor the status of contracts and important contract dates.

The data used in this dashboard can be sourced from a standard Procurement or Accounts Payable module in your accounting or ERP system.

Procurement Data Analytics Dashboard
Procurement Data Analytics Dashboard







Thursday, April 27, 2017

Qlikview to Tableau Migration

Tableau is one of the most popular Business Intelligence software in the market today. Many organizations are adapting Tableau recently and trying to migrate from their old Business Intelligence platform to Tableau. In this post, we will focus on QlikView to Tableau migration.

Effort needed to migrate from QlikView to Tableau depends on the way your QlikView software is implemented. In some cases, the data needed for QlikView Dashboard is completely prepared in a 3rd party tool so when migrating to Tableau, you do not need to convert ETL (extraction - transformation - load) code. But in most cases, ETL for QlikView is implemented using Qlik's own query language, AQL (QlikView is based upon patented technology called Associative Query Logic (AQL)).

Tableau does not provide a native ETL functionality so when migrating from QlikView to Tableau, you will probably need a 3rd solution to implement ETL for Tableau.

The exception above is of course keeping QlikView for ETL and just converting QlikView in-memory data to Tableau's native data set, TDE. But this usually involves, keeping two software licenses under maintenance.
Qlikview to Tableau Migration
QlikView to Tableau Migration
So usually, Qlikview to Tableau migration requires :
1 - Selecting an ETL tool to migrate QlikView AQL code to
2 - Migrating QlikView AQL code to new ETL logic
3 - Reimplementing the dashboards

Yes, there is no product/tool that does automatic migration from Qlikview to Tableau dashboards. You need to manually implement the dashboards in Tableau. Traditionally, QlikView scripting language is richer than Tableau's own expression language so you will also need to handle some in dashboard calculations in ETL when migrating to Tableau.

Though looks difficult, the task is achievable, especially if you outsource the Qlikview to Tableau migration work to a company who knows both QlikView and Tableau. Here is one such company.

Monday, April 24, 2017

Tableau Data Integration

Tableau may be a great data visualization tool but it has very limited functionality for data blending and data integration. Worse, most customers misunderstand "self service business intelligence concept" and think that they will get Tableau and without any data integration they can connect to the databases and create visualization (customers are actually made to believe this with Tableau's sales pitch).

Unfortunately, most business data is stored in complex relational database management systems or ERP which is very difficult, if not impossible to connect directly. Thus, many companies buying self service business intelligence solution realize that they cannot use it effectively due to this limitation.

Solution for this Tableau data integration problem is developing a  data integration with a non-Tableau application which is purpose built for this function. This data integration layer will simplify, consolidate and usually enrich the complex transactional data and will make it available for business users to easily develop visualizations. It will also transfer the query load from transactional system to this intermediary stage so the dashboards will also work faster. Such intermediary Tableau data integration layer became more crucial in the big data age.

Since Tableau deploys ease of use of "Drag-and-Drop", ideally the data integration system should also have the same drag-and drop capability and free of scripting. Luckily there are drag-and-drop data integration software out there and some are open source such as Pentaho.

There are drag-and-drop data integration software out there and some are open source such as Pentaho.
You can download Tableau Data Integration Services brochure to find out more : Enterprise Tableau Data Integration and Management Paper.

If you are having problems in Tableau data integration and data management, an expert Tableau services help may be very useful. In this case you should choose a Tableau consultancy firm, which will guide you in the process and implement the actual Tableau data integration layer.

Wednesday, April 19, 2017

Marketing Performance Analysis Dashboard

Marketing data analysis allows marketing people to align strategies to address market shifts, customer sentiment, and developing trends. Used correctly, a data analysis dashboard for marketing can boost marketing ROI through better targeting and campaign performance.

This Marketing Performance Analysis Dashboard, named Marketing 360, is an online business intelligence demo app brings together data from multiple sources into a one-stop-shop view. Analyze Marketing's performance across the organization from digital performance of the website to pipeline and install base engagement.

The demo application is composed of below screens to analyze different details and aspects of the marketing data :

Marketing Performance Dashboard View - Summarizes Awareness (Total Visits), Pipeline (Number of Opportunities Created) and Engagement (Net New Logos).

Awareness View - This section analysis visits to company site through Web, Social Media and Inbound (CRM).

Pipeline View - This section shows overall pipeline, marketing contribution to this pipeline as well as marketing influenced pipeline.

Engagement View - This section analysis penetration, community and partners.

The application is freely accessible online. To access it, fill in Data Analytics with Qlik Demo/App Request Form and don't forget to select Marketing Performance Analysis Dashboard from drop-down menu).

Marketing Performance Analysis Dashboard - Marketing 360
Marketing 360 - Marketing Performance Analysis Dashboard

Thursday, April 6, 2017

Tableau subscription pricing model

Tableau Software is finally making the big change in the way it sells its business intelligence products: they have announced their new Tableau subscription pricing for all its products, including Tableau Desktop and Tableau Server. These new pricing model will potentially lower the threshold for users looking to gain access to a full-fledged analytics platform.

Tableau subscription prices are now as below :
  • Tableau Desktop Personal subscription price is US$35 per user per month
  • Tableau Desktop Professional subscription price is $70 per user per month
  • Tableau Server subscription price is US$35 per user per month
  • Tableau Enterprise offerings prices are not public but this is also available under  Tableau subscription model.
Tableau perpetual prices are $1000 for Tableau Desktop Personal, $2000 for Tableau Desktop Professional and $1000 for Tableau Server per user. The perpetual model also comes with 20% yearly license maintenance.

Since Microsoft Power BI entered the market 2 years ago, there is a growing market pressure on Tableau and its rival Qlik to lower the prices or provide flexible subscription models. This new Tableau pricing model is in line with customer demand and industry trends, and will significantly reduce the initial expense of deploying Tableau business intelligence. Under subscription model, customers will also gain full access to frequent product updates without having to purchase a perpetual software license.

“Many customers have told us they prefer to purchase software through a subscription model to more easily access the products they want, reduce upfront expenses and increase flexibility,” said Adam Selipsky, president and CEO of Tableau.

Tableau subscription pricing model
Tableau subscription pricing offers affordable access to one of the best Business Intelligence solution available today.
This move will make it easier for Tableau to compete in a very crowded BI market. Tableau customers surveyed for Gartner’s Magic Quadrant were always happy overall with Tableau software, but they were often frustrated with the company’s rigid pricing policies.

Tableau's rival Qlik has also announced their subscription model this year in January.

Monday, February 27, 2017

Best freelance Data Mining, Web Scraping, Data Extraction,Excel CSV jobs

If you are looking for a freelancer or someone to outsource services of Web Scraping  / Data Mining/ Data Extraction from any website according to your instructions, read on. Fiverr, one of the most popular online freelance or micro service provider market, has a very good gig at your service.

Fiverr level 2 seller Hotopilams has this gig titled "I will do Data Mining, Web Scraping, Data Extraction,Excel CSV job" on Fiverr with 5 star reviews and 667 customers as of the writing of this post.

Starting from 5 USD per gig, he will write data mining scripts that will automatically extract data from the website you need. He also offers data extraction from .pdf, .txt, .csv excel, Access, MySQL. The final data can be delivered in many formats like XLS, CSV, SQL, TXT, DOC, PDF etc. All you need to do is to try to describe your needs as much as possible (exact site URL + the fields you need).

Data Mining, Web Scraping, Data Extraction,Excel CSV job
Freelance Data Mining, Web Scraping, Data Extraction,Excel CSV job

Tuesday, January 24, 2017

Qlik Sense subscription pricing model

Qlik has finally announced the general availability of its Qlik Sense Cloud Business Platform. Qlik Sense tokens on cloud will now be available for only 25 USD per user per month. With this addition, Qlik Sense now offers following cloud pricing models :

  • Qlik Sense Cloud Basic is free,
  • Qlik Sense Cloud Plus is priced at 20 USD per user per month,
  • Qlik Sense Cloud Business is priced at 25 USD per user per month.

Qlik Sense Cloud Basic and Plus are for individuals. Basic model has a limitation to share your dashboards with up to 5 users. The newly announced Qlik Sense Cloud Business targets groups and teams and features collaborative and operationalized analytics with group-level governance, coauthoring workspace and automated data refreshes.

Qlik Sense perpetual pricing model has 2 options : Qlik Sense Desktop is free and Qlik Sense Enterprise is 1,500 USD per user and also requires 20% annual license maintenance.

Qlik Sense cloud subscription pricing model
Qlik Sense cloud subscription pricing model
Qlik Sense licensing is based on a flexible and simple token model. Qlik customers buy tokens and are able to allocate and reallocate these tokens to adapt to changing usage needs over time. Tokens can be allocated by customers to either named individuals who need frequent access to the system, or to pools of access for groups of users who use the system infrequently.

For more information about Qlik Sense token licensing download Qlik Sense Token Licensing PDF.


Tuesday, January 3, 2017

Optimization and Scenario Based Sales & Operations Planning (S&OP) for Manufacturing Webinar

Although the computer technology as well as the available advanced planning and scheduling platforms has matured to a level to provide advanced optimization based Sales and Operations Planning for many manufacturing facilities within a very reasonable budget, most companies still deploy old school, cumbersome and very slow S&OP processes.

In this webinar, Associate Professor Caner Taşkın from Bogazici University (VP of Technology in ICRON Technologies) presents how mathematical optimization is accessible for Sales & Operations Planning thanks to advances in computer technology and proven optimization engines like ICRON. He also presents some real life examples of optimization and scenario based S&OP.

Mr. Taşkın starts with an introduction to S&OP and then details how modern S&OP process should be. Later in the webinar, he gives case studies and sample implementations of Optimization and Scenario Based Sales & Operations Planning using ICRON Technologies.


Optimization and Scenario Based Sales & Operations Planning (S&OP) for Manufacturing Webinar 


About ICRON Technologies

Founded in 1992, ICRON Technologies Inc. is a leading developer of Advanced Planning, Scheduling (APS) and Optimization solutions for manufacturing, distribution, MRO and Services organizations. Once deployed it allows large enterprise companies to improve their supply chain operations by better streamlining inventory keeping, production (constraints), and sourcing of material including lead time with forecasted demand. More than 70 customers used the software today including ASML, Singapore Airlines, Rolls Royce, Bridgestone, DHL, Ford, Rohm & Haas, and others. The company is headquartered in Amsterdam with R&D in Istanbul and an office in Singapore. 
www.icrontech.com

Twitter Analysis Dashboard demo

Twitter is one of the most influential and important social media site on the planet today. Most companies want to know (or should want to know) what people are talking about them, their products and competitors. Which companies get tweeted about most? Us or competitors? How does the sentiment trend over time for us and competition?

It is obviously impossible to manually track hundreds and thousands of tweets about your company and competition to get a sense of market sentiment. You need an automated twitter analysis tool to help. Like a Twitter Data Analysis Dashboard.

Here in this post, we will introduce a sample Twitter Analysis Dashboard which nicely summarizes publicly available data. The Business Intelligence platform used here is Qlik Sense. The application uses  Qlik Web Connectors  to extract Twitter data and automatically loads and visualizes the data for you.

You can access the application using this link : Twitter Analysis Dashboard. The dashboard is available online and you can play around to get sense of how modern business intelligence platforms can help you to analyze publicly available social media data.

Twitter Data Analysis Dashboard Qlik Sense
Twitter Analysis Dashboard Qlik Sense. This sample dashboard helps you to analyze the number of tweets and retweets of the airlines to see which airline gets mentioned the most and if the tweets have a positive or negative sentiment.


Sentiment Analysis using Twitter data. How does the sentiment trend over time for the companies?

ICRON Technologies Advanced Planning, Scheduling and Optimization in Singapore

ICRON Technologies B.V., a Netherlands based Advanced Planning, Scheduling and Optimization solution provider is setting up an office in Singapore. ICRON Technologies Asia Pacific will serve South East Asia and East Asia markets to help companies to solve their planning, scheduling, supply chain network optimization, demand planning and S&OP problems.

ICRON Technologies has more than 20 years of experience in Advanced Planning, Scheduling and Optimization and their solutions are used in some well established companies like ASML, Vestel, LG, Singapore Airlines, Rolls Royce, Bridgestone, Perfetti van Melle, etc. The company builts these solutions on their Advanced Planning and Scheduling engine and is known for fast implementation times hovering around 3 months. Their product family includes :

ICRON Advanced Planning and Scheduling (ICRON APS) - Enterprise level finite capacity planning and scheduling solution offering offers a clear, cost-effective migration path to full-function supply chain optimization.

ICRON Capacity Planning (ICRON CP) - Enterprise level supply chain network optimization solution providing strategic and tactical (long-term) planning of supply chain network including customers, production facilities, distribution centers, warehouses and transportation routes.

- ICRON Demand Planning (ICRON DP) - With ICRON DP, companies can accurately model their multiple forecasting inputs creating their unique forecasting algorithms and methodologies to drive forecast improvement across all types of products (fast- and slow-moving, lumpy, short life cycle, trending, steady, highly seasonal, causal driven) on different levels across your value chain. It introduces demand optimization to your organization by applying mathematical optimization techniques to identify the best combination of price and promotion to achieve desired sales, gross margin, inventory or market share objectives.

Manufacturing Planning and Scheduling Gantt Chart
ICRON Advanced Planning and Scheduling system.
ICRON Sales and Operations Planning (ICRON S & OP) - ICRON S&OP helps companies keep demand and supply in balance and achieve synchronization among different functions in the organization by rapidly generating high-quality plans and enabling ad-hoc scenario analysis.

About ICRON Technologies

Founded in 1992, ICRON Technologies Inc. is a leading developer of Advanced Planning, Scheduling (APS) and Optimization solutions for manufacturing, distribution, MRO and Services organizations. Once deployed it allows large enterprise companies to improve their supply chain operations by better streamlining inventory keeping, production (constraints), and sourcing of material including lead time with forecasted demand. More than 70 customers used the software today including ASML, Singapore Airlines, Rolls Royce, Bridgestone, DHL, Ford, Rohm & Haas, and others. The company is headquartered in Amsterdam with R&D in Istanbul and an office in Singapore.