Skip to main content

Featured post

Golf Solutions Designed at Barnham Broom Golf Club in Norfolk

 Many sports tend to be biassed towards one sex or another. For example, football is a sport dominated by men and does not become much more masculine than rugby! On the other side of the fence, netball definitely falls into the women's category. However, there are some sports that share gender gracefully, which appeal to both men and women. Reddit live streaming Golf is undoubtedly one of these sports and has no age limits. Spread across courses in the UK you will find some unlikely groups of people bound by their love for this great outdoor sport. Some will play every day, while others will only play on the weekends, perhaps as a way to relieve the stress of a difficult week at the office. No golfer tends to join a club and membership packages vary widely in price. Most golf clubs simply offer standard packages with the assumption that one size fits all and offers a bit of flexibility. However, some offer more realistic membership packages, considering how much you will be playing...

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.

Comments

Popular posts from this blog

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

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

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