As a Data Analyst, I analyze and visualize data in order to answer business questions and to enable data-driven decision making.
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 this tutorial, we will explain step-by-step how to query data from a Fabric lakehouse with T-SQL using an SQL analytics endpoint. Goal Data should be queried from a delta table in the lakehouse with T-SQL using an SQL analytics endpoint. Data We consider the delta table student that...
Introduction In this tutorial, we will explain step-by-step how to save a T-SQL query as table in Microsoft Fabric. Goal An existing T-SQL query should be saved as table. Step 1: Open Data Warehouse Experience We have already signed in into Fabric and opened the Data Warehouse Experience. We have...
Introduction In this tutorial, we will explain step-by-step how to save a T-SQL query as view in Microsoft Fabric. Goal An existing T-SQL query should be saved as view. Step 1: Open Data Warehouse Experience We have already signed in into Fabric and opened the Data Warehouse Experience. We have...
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 In this tutorial, we will explain step-by-step how to query data from a Fabric warehouse with T-SQL using the visual query editor. Goal Data should be queried from a table in the warehouse with T-SQL using the visual query editor. Data We consider the table student that is stored...
Introduction In this tutorial, we will explain step-by-step how to query data from a Fabric warehouse using T-SQL. Goal Data should be queried from a table in the warehouse with T-SQL. Data We consider the table student that is stored in the warehouse "dlnerds_warehouse". Step 1: Open...
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...