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.
Introduction The first step when creating a Power BI report is to connect with data sources. Power BI can connect to a wide range of data sources. This capability allows users to access and analyze data from various sources within Power BI. One important format to often deal with is...
Introduction In Power BI, the visualization and interpretation of data in a table can be improved by using conditional formatting with icons. This feature dynamically adds icons to a table based on the values it contains. This allows important information to be highlighted so that patterns, trends and outliers can...
Introduction In Power BI, the visualization and interpretation of data in a table can be improved by using conditional formatting with background colors. This feature dynamically sets the cell colors in a table based on the values it contains. This allows important information to be highlighted so that patterns, trends...
Introduction In Power BI, readability and visualization of tables can be enhanced using data bars, which provide a visual representation of numerical values for quick comparisons and trend identification. In this tutorial, we will show you how to use data bars in a table visualization in Power BI. Data The...
Introduction In Power BI, you can enhance data visualization by sorting one column based on the values of another column. This feature allows you to customize the order of your data, providing clearer insights and more meaningful comparisons. In this tutorial, we will show you how to sort one column...
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 of the most important DAX functions is the CALCULATE function. The CALCULATE function enables dynamic aggregations based on specific criteria....
Introduction In the realm of data visualization, bar charts stand tall as one of the most effective and widely used tools for conveying information. In Power BI, it is very easy to create vertical and horizontal bar charts. Furthermore a grouping can be added, which can be displayed in different...
Introduction Power BI makes it possible to bring numbers and information to life, tell stories and make data-driven decisions. This is the world of Power BI! Whether you are already familiar with data or just starting out, Power BI is a powerful tool that allows you to turn raw data...
Introduction Power BI offers with the Power Query Editor a powerful tool for cleaning and transforming data. One important part of data preparation is adding an Index Column. For organizing and structuring your data it is crucial that every row is uniquely identified by an ID. An Index Column enables...