Microsoft Power BI is a powerful business analytics tool that enables users to visualize data, share insights, and create interactive reports and dashboards, facilitating data-driven decision-making. Here you find hands-on tutorials and best practices about Microsoft Power BI. The tutorials are also a valuable resource for preparing for the Microsoft Exam PL-300. Learn how to become a Power BI developer. We explain step by step how you can start from scratch with Power BI.
Introduction Power BI offers with the Power Query Editor a powerful tool for cleaning and transforming data. One important part of data preparation is filtering your data. Filtering enables you to sort out irrelevant data and to reduce the amount of data. One important type of filtering is conditional filtering....
Introduction Power BI comes with the powerful formula language Data Analysis Expression (DAX) which allows the implementation of custom calculations. There are numerous operators and functions available in DAX. One essential DAX function is the IF function which is used for conditional calculations. In this tutorial, we will explore the...
Introduction Power BI offers with the Power Query Editor a powerful tool for cleaning and transforming data. One important part of data preparation is filtering your data. Filtering enables you to sort out irrelevant data and to reduce your amount of data. In this tutorial, we show you how to...
Introduction Power BI is one of the most widely used BI tools. But using Power BI on the Mac can be a challenge. This is because Microsoft does not offer a version of Power BI Desktop for the Mac. Nevertheless, there are workarounds for using Power BI on the Mac....
Introduction In this tutorial, we want to import Data from a Excel file into Power BI. This can be easily done in the Power BI Desktop interface. Data Source Our data source is the Excel file student. The file contains the following data: Power BI Desktop In the following, we...
Introduction In this tutorial, we want to import Data from a CSV file into Power BI. This can be easily done in the Power BI Desktop interface. Data Source Our data source is the CSV file student. The file contains the following data: Power BI Desktop In the following, we...
Introduction In this tutorial, we want to import Data from a Postgres Database into Power BI. This can be easily done in the Power BI Desktop interface. Data Source We have already created a Postgres server called DLNerdsServer and a database called dlnerdsacademy. In this database we have created the...