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.
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…
The DAX ACCRINT function calculates the accrued interest for a security that pays periodic interest. It takes several arguments, including the issue date, first interest date, settlement date, annual coupon rate, par value, frequency of payments, day count basis, and a logical value to determine the calculation method. The function returns the total accrued interest…
ABS stands for Absolute Value. It takes a number as input and returns its distance from zero, basically ignoring the positive or negative sign. So, ABS(5) returns 5, and ABS(-3) returns 3. You can use ABS to convert negative numbers into positives for calculations that only work with non-negative values. Imagine you need to find…
This tutorial creates a data model and visualizes a flow of orders in Power BI. Here’s a summary: – We start with 11 excel tables related to orders. – We import them into Power BI and create relationships between tables based on matching columns (e.g., product ID). – We use DAX queries to create new…
In this tutorial, we will perform Exploratory Data Analysis (EDA) on the Netflix userbase dataset. EDA is a technique used to summarize and analyze data sets using visualizations. The dataset contains various fields, including user ID, subscription type, monthly revenue, joining date, last payment date, country, age, gender, device, and plan duration. To get started,…
Welcome to our comprehensive Power BI Desktop tutorial where we will guide you through creating an engaging dashboard that showcases airports around the world. Join us as we dive into the powerful features of Power BI, utilizing maps, pie charts, column charts, and scatter charts to visualize airport data like never before. Step 1: Accessing…
Welcome to another Power BI tutorial! In this video, we will show you how to create hierarchical data using DAX and how to use this data to create reports in Power BI. We will start by using an Excel file with four columns: ID, Account, Parent, and Amount. This is a simple Chart of Accounts…
In this video, we will perform financial ratio analysis using DAX in Power BI Desktop. We will use financial data of various companies to calculate typical ratios and create a dashboard comparing these ratios. These ratios will help us understand the overall picture of the industry as well as the individual performance of each company…