Data Analysis Help

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

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

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

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

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

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