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

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 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. 

Wednesday, December 28, 2016

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 March 17th 2016 on below time :

Singapore / Malaysia / Hong Kong / Taiwan / Philippines                : 09:00 – 10:00 AM
Thailand / Indonesia / Vietnam                                                          : 09:30 – 10:30 AM
Australia                                                                                             : 01:30 – 02:30 PM
Japan / Korea                                                                                      : 10:00 – 11: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.