In your account you can view the status of your application, save incomplete applications and view current news and events
June 02, 2022

Power BI: OTTO's reporting vehicle

What is the article about?

Following the official introduction of Power BI at OTTO in 2020, it’s quickly become a household name for many colleagues. Others have already taken their first practical steps in using this technology or have even become advanced and regular users - for good reason!

This is because Power BI is a tool that lets you visualize data efficiently and effectively. If your work is data-driven, i.e. you make decisions based on the information you extract from various raw data, you definitely need Power BI in your portfolio of regular tools.

When you get started with Power BI you won’t be on your own, though, because at diy:BI we actively support you in report development and all other Power BI-related matters!

Power BI infrastructure

Power BI i.e.S. is the Power BI Desktop application that can be installed and used free of charge on a personal computer any time. Essentially, Power BI Desktop is the development environment for creating reports.

Besides this there’s the equally important cloud component: Power BI Service reports developed locally (in Power BI Desktop) are published here and therefore become visible and usable for other OTTO colleagues via the browser. 

The entire Power BI landscape can thus be displayed as follows:

The Power BI landscape
The Power BI landscape

"At diy:BI we actively support you in report development and all other Power BI-related matters!"

Power BI Desktop

As described above, Power BI Desktop is the development environment for reports and therefore an essential part of the Power BI infrastructure.

With Power BI Desktop you can do the following main tasks:

  • Connect various data sources (Exasol, GCP, SharePoint and many more)
  • Transform and combine connected data using Power Query
  • Create a Local Data Model
  • Create your own key figures based on the data model (=DAX)
  • Import design themes (e.g. corporate design-compliant OTTO colours)
  • Develop reports
  • Test and optimize report performance
  • Use external help tools (for advanced users) such as DAX Studio, Tabular Editor, etc.
  • Define RLS (Row Level Security) or row-level permissions, i.e. decide who can see what
  • Publish finished reports in Power BI Cloud and share them with your colleagues.

The entire process, from data connection to the completion and publication of the report with Power BI, can thus be mapped as follows:

The process of Power BI
The process of Power BI

Power BI Service

Power BI Service is Power BI's cloud platform. Here, reports developed locally with Power BI Desktop are published and made accessible to other OTTO colleagues or report consumers.

To publish a report in Power BI Service you need a Workspace. There are 3 types of workspaces available in Power BI Service:

  • Personal Workspace
  • Regular Workspace
  • Premium Workspace.

The Personal Workspace can be used at any time without additional licenses and is the only workspace that already exists by default after the first login (in Power BI Service) and cannot be removed. This Workspace can be used particularly for temporary reports, tests or other personal content that is not widely distributed.

By contrast, a Regular or standard Workspace must be created in addition to the Personal Workspace. You can do this independently at any time (in compliance with a few rules). The Regular Workspace is not linked to a specific person but is usually created for a specific department, team or project. 

A Premium Workspace provides additional capacity and features compared to the regular workspace, such as more storage space for reports or datasets, a higher refresh rate, and easier content-sharing.

Get started with Power BI straight away!

On the one hand you can get started with Power BI as a Developer.

On the other hand, if you’re a report consumer and first want to browse through Power BI Service and the existing unlocked reports we’ve made available, you can now do this on app.powerbi.com. Simply sign up there with your OTTO e-mail address and you're ready to go!

Naturally, should you have any further questions or comments about Power BI & Reporting, feel free to contact us at any time.

Want to be part of the team?

0No comments yet.

Write a comment
Answer to: Reply directly to the topic

Written by

Karolis Ausra
Karolis Ausra
CPM and BI-Specialist

Similar Articles

We want to improve out content with your feedback.

How interesting is this blogpost?

We have received your feedback.

Cookies erlauben?

OTTO und drei Partner brauchen deine Einwilligung (Klick auf "OK") bei einzelnen Datennutzungen, um Informationen auf einem Gerät zu speichern und/oder abzurufen (IP-Adresse, Nutzer-ID, Browser-Informationen).
Die Datennutzung erfolgt für personalisierte Anzeigen und Inhalte, Anzeigen- und Inhaltsmessungen sowie um Erkenntnisse über Zielgruppen und Produktentwicklungen zu gewinnen. Mehr Infos zur Einwilligung gibt’s jederzeit hier. Mit Klick auf den Link "Cookies ablehnen" kannst du deine Einwilligung jederzeit ablehnen.


OTTO arbeitet mit Partnern zusammen, die von deinem Endgerät abgerufene Daten (Trackingdaten) auch zu eigenen Zwecken (z.B. Profilbildungen) / zu Zwecken Dritter verarbeiten. Vor diesem Hintergrund erfordert nicht nur die Erhebung der Trackingdaten, sondern auch deren Weiterverarbeitung durch diese Anbieter einer Einwilligung. Die Trackingdaten werden erst dann erhoben, wenn du auf den in dem Banner auf otto.de wiedergebenden Button „OK” klickst. Bei den Partnern handelt es sich um die folgenden Unternehmen:
Google Inc., Meta Platforms Ireland Limited, elbwalker GmbH
Weitere Informationen zu den Datenverarbeitungen durch diese Partner findest du in der Datenschutzerklärung auf otto.de/jobs. Die Informationen sind außerdem über einen Link in dem Banner abrufbar.