Blog

It's been ten years since SQL Server 2012 was brought out. Ten years, and soon it will be over again – at least as far as extended support is concerned. Before we talk about what this means and what our options are, I would like to take this opportunity to look back on these ten years: On aspects whose foundations were laid back then, and which are now standard in the database landscape, especially in the BI context.

For specific use cases such as the contribution margin schema, it makes sense to display key figures in a dimension table instead of the classic fact table. This article describes characteristic features and a method of implementation in Power BI.

Increasingly frequently, Power BI is used not only as a self-service tool, but also forms the basis of operationalized analytics applications at many internationally active companies and even in the B2B sector. This, in particular, requires Power BI reports to be displayed in multiple languages. Here you have to decide: Do I create one report per language or try to make my report filterable by language? This article considers the latter approach.

This post deals in detail with the Protegrity platform and its interaction with Exasol. The Protegrity platform is meant to achieve extensive, end-to-end data protection over various applications and data storage devices.

Just as most of us prefer harmonic chords to dissonance in music, value creation is maximized only by harmonizing data strategy, data organization and data governance. We will address the most important issues and provide successful examples.

When we do simple descriptive data exploration, we are seldom content with analyzing mean values only. More often, we take a more detailed look at the distribution, have a look at histograms, quantiles, and the like. Mean values alone often lead to erroneous conclusions, and keep important information hidden. But if this is the case, why do we forget about this as soon as we build predictive models? These usually aim only at mean values - and they lie.

If you choose SAP Analytics Cloud, you are soon confronted with the question of which capabilities to make available to users. The answer to this is provided in the operating concept. We will now show you what needs to be considered.

During selection of a connection type, several aspects must be considered. Find out here which these are, and which scenarios can be covered with the various connections.

Architecture recommendation and data-processing techniques with Azure Stream Analytics and Azure Functions. In this article, we provide two architecture recommendations, show how they can be implemented, and visualize the data acquired via IoT Central in a Power BI dashboard. Here you can read part 1.

In addition to data ingestion, data processing in the Industrial Internet of Things (IIoT) is still a major challenge for many companies. How companies successfully implement IoT projects on the basis of a 6-point plan, can be read here. An easy start in connecting industrial devices to the cloud has been described here. Also shown is how IoT Central can be used to read an industrial robot's data from an OPC-UA server, and deposit the data in Azure Blob Storage.

Architecture recommendations and data-processing techniques with Azure Synapse Analytics. This article of ours provides two architecture recommendations, besides showing how they ca be implemented an how data are provided for visualization.

Power BI from Microsoft is a versatile, intuitive, and therefore widely used data visualization tool. But other software manufacturers are also making a name for themselves in the data evaluation market. One of them is Tableau. As an experienced Power BI developer, I was recently able to try my luck with Tableau for a customer. I would like to share the results with you in the following blog post.

Do you want to prepare a Power BI report, but the data quantity is too large to even start creating visuals? Or you've actually managed to prepare the report based on such data, but Power BI desktop keeps seizing up? Or the report takes forever to be published? You're not alone here. We will therefore next provide a few tips which are easy to implement.