This tutorial guides you through harnessing the power of Python visuals in Power BI to perform data analysis and predictive modeling. The initial steps involve loading actual sales and advertisement data, which runs from the start of the year through September, while also including targeted ad spending for the final quarter (October, November, and December)….
Learn how to use parameters in Power BI to create dynamic and interactive reports! This tutorial walks you through the creation and application of both numeric range parameters and fields parameters using a sample sales dataset. We start by importing data and setting up a basic dashboard with a column chart and a donut chart….
This comprehensive tutorial walks users through leveraging the Google Data API and Python within Google Colab to perform in-depth YouTube channel analysis. The process begins by guiding users to the Google Cloud Console to enable the YouTube Data API v3 and secure an API key. This key is the credential needed to access YouTube’s data….
In this video, we dive into a comprehensive data analysis and visualization project for Global Swift Logistics. The project leverages a JSON file containing detailed shipping and transportation information. Using Power BI, we create a dynamic, multi-page dashboard to analyze various aspects of the company’s shipping operations. We start by building a dashboard to track…
Ready to move past DAX for your year-over-year analysis? This tutorial shows you a powerful alternative, using Power Query to create stunning Power BI dashboards. You’ll learn how to transform and manipulate your data directly within Power Query, creating new columns for year and month to streamline your analysis. Instead of relying on complex DAX…
In this tutorial, we show you how to design a multi-page Power BI company performance dashboard from scratch. We start with a dataset in a pivoted, report-like format, which isn’t ideal for analysis. To fix this, we’ll walk you through the process of using the Power Query Editor to unpivot the data, making it much…
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 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 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…
