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 tutorial focuses on data mapping and enrichment in Looker Studio, building upon a previous tutorial that created a student data analysis dashboard. The previous dashboard displayed gender as numerical values (1 and 2) instead of descriptive terms (male and female), and parental support as numbers (1, 2, and 3) instead of “low,” “medium,” and…
This tutorial introduces how to create a responsive dashboard in Google Looker Studio, a feature that allows dashboards to automatically adjust to various screen sizes like mobiles, tablets, and computers. This eliminates the need to design separate reports for different devices. The process begins by creating a new Looker Report, connecting a CSV file as…
This tutorial demonstrates how to leverage multiple CSV files to construct a unified dashboard or report in Looker Studio. The key principle is to treat each new CSV file as an incremental update, where its data is appended to the existing information within Looker Studio. This approach is highly beneficial when you receive data in…
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…
This SQL tutorial demonstrates how to summarize and analyze data using aggregate functions in conjunction with the GROUP BY clause. It also covers sorting data with ORDER BY and filtering information using both the WHERE and HAVING clauses in SQL Server. The tutorial begins by creating an Orders table in the TutorialDB database and populating…
In this SQL Server tutorial, we embarked on a journey to understand and implement data modeling concepts. The primary goal of data modeling is to streamline database design, ensuring both efficiency and effectiveness in meeting the data requirements of a business. We explored the three distinct stages of data modeling: the conceptual model, where initial…
Tired of wrestling with complex SQL queries just to analyze your data? Welcome to this comprehensive tutorial where we’ll unlock the power of Microsoft Excel to seamlessly connect with your SQL Server database! Forget intricate coding – Excel empowers even non-technical users to effortlessly extract, analyze, and visualize crucial business information directly from your SQL…
Today, we demonstrated building an SQL Server database from CSV files. We had multiple CSVs, each representing a table (‘brand’, ‘category’, ‘channel’, ‘customer’, ‘method’, ‘product’, ‘staff’, ‘store’), except ‘sales’, which was split into three files. This is common when migrating from simpler databases struggling with large datasets or multi-user access. We exported tables to CSV…
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…
