This tutorial provides a hands-on guide to creating new objects in your Power BI semantic model using the TMDL view. Instead of relying on the graphical user interface, you’ll learn how to write a simple script in the TMDL editor to define a new measure from scratch. This method highlights one of the key benefits…
This YouTube tutorial provides a foundational understanding of data connectivity and transformation within Power BI, focusing on the crucial role of Power Query. Learn how to bring your data into Power BI from various sources, including files like Excel and CSV, databases, and cloud services. Discover the essential steps to establish these connections and prepare…
This PowerBI tutorial guides users through the creation of a dynamic weather dashboard. It demonstrates how to leverage a weather service website’s API to acquire XML data, which is then meticulously modeled to incorporate additional details like user-friendly, dynamic Unicode icons instead of static images. The tutorial also focuses on visualizing forecast information effectively using…
This Python tutorial provides a comprehensive introduction to variables and data types, suitable for beginners or those seeking a refresher. It explains variables using the analogy of bank lockers, where each locker (variable) has a name and stores a value with a specific data type. The tutorial covers various fundamental data types, including strings (sequences…
This tutorial guides users through creating a Power BI dashboard tailored for risk management professionals. The dashboard focuses on visualizing the capital adequacy ratio (CAR), a crucial metric calculated by dividing total capital (Tier 1 + Tier 2) by total risk-weighted assets. The explanation clarifies what constitutes risk-weighted assets, providing examples like cash (0% risk…
This tutorial explores methods for custom sorting rows, columns, and axes in Looker Studio when direct access to the data source is unavailable. Initially, a previous tutorial demonstrated sorting by adding new columns to the data source. However, for users without data source access, this tutorial offers two alternative approaches: blending data with a separate…
This tutorial provides a comprehensive introduction to setting up and using the R language and RStudio on a Windows PC. It begins by guiding users through the installation process for R, emphasizing the importance of downloading the base version from the official R project website. After a successful R installation, the tutorial demonstrates how to…
This MS Excel tutorial introduces the INDEX and MATCH functions, demonstrating their use with employee data including names, age, gender, employee number, and salary. The INDEX function retrieves a value from a cell based on provided row and column numbers. The tutorial explains how to determine these numbers, including using the COLUMN and ROW functions…
This tutorial guides beginners through creating their first Power Apps application: a to-do list. Power Apps, part of the Microsoft Power Platform, is a low-code development environment that allows for quick and easy app design without traditional programming or database languages. The process begins by creating a new app from scratch, selecting the “start with…
This Power BI tutorial focuses on effectively using the funnel chart to visualize data flow through a process. The video begins by demonstrating how to import data from an Excel file containing three sheets: monthly expenses, profit and loss, and selection data. The selection data is then used as a straightforward example to create a…
