In this tutorial, you’ll learn about turning multiple calendar type layouts into a tabular format using Power Query in Power BI. You’ll learn how to transform multiple files instead of a single file from a folder. This tutorial will also teach you how to fill gaps in your data and how to harvest them in
In this tutorial, we’ll discuss essential transformations within Power BI Query Editor that can be used to optimize your rows and columns. In developing an intuitive Power BI model, it’s best to simplify your rows and columns inside your table. Optimizing your table is essential in creating visualizations, so you can easily recognize your data.
In this tutorial, I will discuss Power BI datasets, including data types and the importance of naming conventions. The data used in this example is a resource pack made available for Enterprise DNA members. DOWNLOAD FILES USED IN THIS ARTICLE We want to make sure that when we import this Excel data into our Power
In today’s tutorial, I want to highlight how important it is to build your data model relationships correctly. Data modelling is one of the foundations of your Power BI report so it’s necessary to set it up correctly. Previously, I discussed some techniques that can help you manage your model right. One of them is
In today’s blog, I want to teach you all about data table types. It’s important to understand how the tables work so you can build your data model effectively. A data table contains columns and rows of information used to achieve easier visual representation. There are two types of tables within a data model: the
