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…
Welcome to our channel! Today’s update focuses on a significant change within Power BI dashboards. Upon attempting to access the dashboard, a prompt appeared announcing the introduction of the Azure Maps visual. This new visual is set to replace the existing traditional map functionalities that users have been accustomed to. Consequently, users are presented with…
Alright, buckle up for a whirlwind tour of creating a real-time Bitcoin price dashboard! We’re diving into the exciting world of Power BI and Power Automate to snatch live data from Binance and display it dynamically. First things first, we’ll head over to SQL Server Management Studio and craft a table named “Binance” with columns…
Welcome to this Power BI tutorial where we’ll guide you through the process of hosting your Power BI reports on your own server. To achieve this, we’ll utilize Power BI Report Server, which can be conveniently downloaded from the Microsoft website. Simply navigate to the website, click on “advanced download options,” and then select the…
Welcome to our tutorial on the Power BI Q&A visual, where we’ll guide you through effectively utilizing this feature and designing dashboards with it. We’ll begin by importing data into Power BI’s data pane, selecting the desired table, and loading it, populating the data pane with its fields for visual design. Before using Q&A, we’ll…
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 tutorial addresses the common problem of missing data in time series visualizations, particularly when dealing with progressive or accumulative data in Power BI. It explains that while missing data points might appear as zeros in standard charts, this can lead to inaccuracies when values represent cumulative totals. The video demonstrates two solutions: first, filtering…
This tutorial guides viewers through creating a visually engaging PowerBI dashboard with an animated background. It begins by importing a sales dataset containing month, branch, sales, and profit data from an Excel file into PowerBI Desktop. The tutorial then demonstrates how to design a basic dashboard, including a title text box, a line and clustered…
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.
