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 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 demonstrates how to analyze and visualize contagion risk among 20 financial institutions using Power BI Desktop. Contagion risk, also known as contingent risk, occurs when the failure of one institution triggers a chain reaction, impacting others due to their interconnected exposures. The video illustrates this concept with an example: if ECU defaults on…
This Power BI tutorial guides you through data modeling, focusing on the star and snowflake schemas. You’ll learn how to import an Excel dataset containing sales and related tables into Power BI, and then build both types of data models in the Model view. The key difference is explained: star schemas connect all dimension tables…
This video introduces and walks through the Power BI solution, a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities through an easy-to-use interface. Power BI consists of key components like Power BI Service (a cloud-based service for publishing and sharing reports and dashboards, and creating new ones), Power BI Desktop…
In this tutorial we will explore power bi service and power bi desktop, and we will create a dashboard as well. We will also transform data using power query and dax.
This video tutorial demonstrates how to connect to a MariaDB or MySQL server in Power BI using Direct Query with change detection for near real-time data updates. It explains the difference between MariaDB and MySQL, emphasizing the importance of using the correct connector. The tutorial guides viewers through downloading and installing the MariaDB connector, setting…
This tutorial demonstrates how to create a Power BI dashboard to monitor sales and profit data, and then automate the delivery of this data to top management via email using Power Automate. Key steps covered: This tutorial provides a practical example of how to leverage Power BI and Power Automate to streamline data reporting and…
Find and Search, both functions are used to locate substrings within a larger text string. They return the position (as a number) where the substring is found. But both may result in different values. This is because, FIND is case-sensitive, while SEARCH is case-insensitive. Also remember that they both return the position of first substring…
