Introduction In the following you will find a fictional dataset for a university. The dataset consists of five files in different formats. Attendance.csv This CSV file contains information related to the courses students have attended, including their grades and the semesters. AttendanceAttendance.csv1 KBdownload-circle Student.xlsx This Excel file...
Introduction Microsoft Fabric is a powerful All-in-One Data Platform (SaaS) in the Azure Cloud that combines various Azure components to cover the fields of Data Integration, Data Engineering, Data Science and Business Intelligence. One key component of the Microsoft Fabric architecture is the KQL Queryset. In this tutorial, we will...
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 this tutorial, we will show you how to get a randomly sampled subset of a PySpark DataFrame. In order to do this, we will use the sample() function of PySpark. What is the sample() Function? The sample() function in PySpark is used to create a new DataFrame by...
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 Microsoft Fabric, you can schedule a data pipeline by defining specific times and frequencies for your data processing tasks. This automation helps ensure that your data is constantly updated and available at the right time. In this tutorial, we will explain step-by-step how to schedule a data pipeline...
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 In Microsoft Fabric, you can schedule a dataflow by defining specific times and frequencies for your data processing tasks. This automation helps ensure that your data is constantly updated and available at the right time. In this tutorial, we will explain step-by-step how to schedule a dataflow in Microsoft...
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....
