Kibana dashboard tutorial for beginners

If large amounts of data have to be indexed and structured, the license-free engine, Elasticsearch, is a popular solution. The Kibana web interface is often used to present the processed data in an appealing form. Together with Elasticsearch and Logstash, this forms the so-called ELK stack. In our Kibana tutorial, we explain step by step how to get the server application Kibana up and running and...

Referral spam: attack patterns and countermeasures

Do you find that lots of the traffic that arrives on your site comes from suspicious sources? There’s no need to worry since website operators encounter inconsistencies in reports from analysis tools (such as Google Analytics, Piwik, or etracker). The reason: referral spam falsifies visitor statistics. Learn how hackers can manipulate referrer information and traffic data, as well as which...

6 tips for significant A/B tests

Your website or online store is finally ready, but you still need to adapt and optimize it. Even small changes, such as the position of a form or CTA buttons, can have a positive impact on your business. Running simple A/B tests enable you to check certain hypotheses and test them accordingly. But if you decide to use A/B testing to help your company succeed, you need more than just the right...

Pivot tables: using Excel to its fullest

Excel pivot tables can considerably ease the evaluation of data. Data analysis can be especially time-consuming and tedious with complex numerical series, but with Excel pivot, this doesn’t have to be the case. Simply place your data in the right context and filter the essential information in just a few clicks. The pivot table allows you to create expressive diagrams in no time. Find out all you...

Practical functions in Excel: COUNTIF explained

What is COUNTIF? With Excel, Microsoft provides a helpful spreadsheet program. The application combines numerous functions – most of which many users are unaware of. It therefore makes all the more sense to learn more about it and use the program for more than just creating tables. The COUNTIF function helps you create statistics, for example. We explain clearly how to use COUNTIF correctly in...

The best Google Analytics alternatives

Website tracking is very important in online marketing to be able to see how users are interacting on your site. The first choice is normally the tracking tool offered by the search engine, Google. But for data protection reasons, more and more users are looking for alternatives to Google Analytics. There’s a great selection of web analytics tools – we will examine applications with similar...

Web analytics: data privacy when creating a profile

Tracking tools can provide website operators with a useful indication on how to adapt an online project to suit a target group. These tools focus on user profiles, which reveal how users find the website, and which content provokes interactions. This information is based on user data, which can be subject to stringent data protection guidelines in some countries within the European Union. Find out...

30 Excel shortcuts to speed up your work

Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.

Splitting the bill: the best apps for sharing the cost

Whether it’s splitting the bill at the restaurant, keeping track of a household budget, or keeping a tab on vacation with friends: bill splitting apps help you share costs, calculate expenses, manage invoices, and pay off debts. They can also help facilitate financial cooperation. In the meantime, there are a number of tools that you can install for free. Here is a guide to the best apps for...

Google Tag Manager: the hub for your tracking and testing snippets

Tools for recording and analyzing user behavior are part of everyday life for website operators. Yet the more codes you need to embed and keep track of, the more difficult and time-intensive the task becomes. How can you keep track of everything? The Google Tag Manager offers the perfect answer. Here you will learn how the tool created by the search engine giant works and how you can make best use...

1