Python is a versatile, high-level programming language known for its simplicity and readability. It was created by Guido van Rossum and first released in 1991. Python’s design philosophy emphasizes code readability and a syntax that allows programmers to express concepts in fewer lines of code than would be possible in languages like C++ or Java….
This video provides a comprehensive guide to data modeling in Power BI, using a MariaDB server as the primary data source, though an Excel/CSV version of the database is also provided. It begins by demonstrating how to connect to the database and import multiple tables. The video then delves into the core of data modeling,…
Connecting Power BI to a MariaDB SQL Server requires a specific third-party connector, which can be a bit more complex than connecting to other built-in data sources. This tutorial walks you through the precise steps to ensure a successful connection. We will guide you on how to find the exact connector version recommended by your…
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 is a list of cities with relevent states and countries which can be used as web data source in power bi and excel for practice. City State/Province Country New York NY USA Los Angeles CA USA Toronto ON Canada London England UK Sydney NSW Australia Paris Ile-de-France France Berlin Berlin Germany Edinburgh Scotland UK…
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…
