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…
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…
This video is a tutorial on how to perform cost-benefit and payback analysis of a project using Power BI. It walks you through creating a table with initial cost, yearly cost, yearly benefit, and interest rate. Then it demonstrates how to calculate present value, cumulative present value, and net present value. Finally, it shows how…
The video is about creating a dashboard and exploring Dax query view in Power BI. The speaker first introduces the Dax query view, which is a new feature in Power BI desktop. Then he demonstrates how to load data into Power BI and create a dashboard with various charts. After that, he explains how to…
This Power BI tutorial introduces new features like DAX Query View, New Card Visual, New Button Slicer, Visual Calculations, On Object Interaction, Build a Visual Button, Dynamic Values, Pane Switcher, Analyzer, etc. It then demonstrates how to create a dashboard using these features, explaining each step along the way. The video covers connecting to data,…
The tutorial starts by guiding you through creating a table in SQL Server to store game data like turn number, player scores, and dice rolls. Then, it demonstrates writing DAX code in Power BI to calculate turn order, roll dice, update scores, and determine the winner. Finally, it shows how to create an interactive dashboard…
In this tutorial, we’ll walk you through the process of creating an insightful dashboard to compare the price, cost, and profit of various products. We’ll use Excel and Power BI to extract and visualize the data. Follow along to learn how to transform raw information into valuable insights. To begin, open the Excel file in…
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,…
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…
Today we will use Data Analysis Expressions (DAX) to create columns and tables in the Power BI and use those tables to display visualizations. Excel file: https://docs.google.com/spreadsheets/d/1cSmnIs9vW6cyJ5Z-vf1IjV-Gb7vk7feD/edit?usp=share_link&ouid=111966831820301688680&rtpof=true&sd=true Power BI File: https://drive.google.com/file/d/1FH8r45s8sO672lBCE0VVMwYw_PQyUD6J/view?usp=share_link #powerbi #dax