- 15
- 92 989
BI With Gurpreet
United Kingdom
Приєднався 18 лис 2022
My name is Gurpreet Singh Dhindsa and I have created this channel to help beginners learn and build a career in BI (Business Intelligence), especially focusing on Power BI. I believe in continuous learning and improvement and enjoy the process of learning and sharing. And this channel is my way of giving back to the universe and the community.
I have been lucky to gain more than 20 years of experience in Data Management, especially Business Data Analytics and Business Intelligence. I am currently the Practice Director for Data & AI at Aligne (aligne.ai).
You can also connect with me on other socials:
LinkedIn - www.linkedin.com/in/gurpreetsdhindsa
I have been lucky to gain more than 20 years of experience in Data Management, especially Business Data Analytics and Business Intelligence. I am currently the Practice Director for Data & AI at Aligne (aligne.ai).
You can also connect with me on other socials:
LinkedIn - www.linkedin.com/in/gurpreetsdhindsa
How to do custom sort in Power BI? - recommended method and best practices!
This is quick and powerful Power BI tutorial on how to set a custom sort order for your charts, legends, or values! This is definitely something you should add to your Power BI skills.
If you have a text column in your chart, legend or slicer, and you want to sort it based on a different order than the normal alphabetical order, then watch this video to learn the method.
In this video, I have also shared some of the best practices, that you should keep in mind when using these custom sort methods.
--------------------------------------------------------------------------------------------------------
✅ DOWNLOAD FILES:
Download exercise files used in this video: tinyurl.com/yc29w4a5
--------------------------------------------------------------------------------------------------------
⏱️TIMESTAMPS:
00:00 Why is the need to learn custom sort?
03:21 THIS METHOD IS NOT RECOMMENDED - Only use this method for POC etc.
04:20 METHOD 1 to apply custom sort
09:02 METHOD 2 to apply custom sort
13:58 Hide table and columns from Report view
16:20 THE CHALLENGE - can you custom sort the Marital Status column?
17:01 Quick RECAP
🙏🏽 FORM TO REQUEST VIDEOS :
forms.gle/4BFcH6msQEwuBrEU9
--------------------------------------------------------------------------------------------------------
🔔 SUBSCRIBE!
Do you want to become a Data Analyst or a BI Analyst? That's what this channel is all about! My goal is to help you learn the skills, knowledge and tools to successfully launch a career in Data Analytics. Be sure to subscribe to not miss out on any content! -- @biwithgurpreet
--------------------------------------------------------------------------------------------------------
🔽 CONNECT WITH ME:
Instagram: biwithgurpreet
If you have a text column in your chart, legend or slicer, and you want to sort it based on a different order than the normal alphabetical order, then watch this video to learn the method.
In this video, I have also shared some of the best practices, that you should keep in mind when using these custom sort methods.
--------------------------------------------------------------------------------------------------------
✅ DOWNLOAD FILES:
Download exercise files used in this video: tinyurl.com/yc29w4a5
--------------------------------------------------------------------------------------------------------
⏱️TIMESTAMPS:
00:00 Why is the need to learn custom sort?
03:21 THIS METHOD IS NOT RECOMMENDED - Only use this method for POC etc.
04:20 METHOD 1 to apply custom sort
09:02 METHOD 2 to apply custom sort
13:58 Hide table and columns from Report view
16:20 THE CHALLENGE - can you custom sort the Marital Status column?
17:01 Quick RECAP
🙏🏽 FORM TO REQUEST VIDEOS :
forms.gle/4BFcH6msQEwuBrEU9
--------------------------------------------------------------------------------------------------------
🔔 SUBSCRIBE!
Do you want to become a Data Analyst or a BI Analyst? That's what this channel is all about! My goal is to help you learn the skills, knowledge and tools to successfully launch a career in Data Analytics. Be sure to subscribe to not miss out on any content! -- @biwithgurpreet
--------------------------------------------------------------------------------------------------------
🔽 CONNECT WITH ME:
Instagram: biwithgurpreet
Переглядів: 4 394
Відео
Basket Analysis using Power BI - Intermediate DAX Power BI Project | Power BI Mastery
Переглядів 16 тис.Рік тому
In this video we will be learning all about basket analysis and how to perform it in Power BI, in the form of a complete project. This is an intermediate level project, with focus on learning and writing a bit complicated DAX formulas and functions, to to data analysis required in order to effectively perform basket analysis. ✅ DOWNLOAD PROJECT FILES: Download Microsoft Power BI file: tinyurl.c...
End to End Power BI Project - Customer Churn Analysis | Power BI Mastery #powerbitraining
Переглядів 48 тис.2 роки тому
In this video, you can follow-along, to create and publish a complete Power BI Report for Customer Churn Analysis. The is a completely hands Power BI Report tutorial, for beginners, to go from raw data to a finished report. In this video, we take Bank Customer Churn dataset and go through the end-to-end process of developing and publishing the Customer Churn Analysis report in Power BI, includi...
2.2 Power Query Editor User Interface - Complete walkthrough | Power BI Masterclass 2023 #powerquery
Переглядів 7562 роки тому
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on UA-cam, with all the exercise files provided. In this video, I will introduce you to Power Query Editor user interface and show you the 7 key parts of the Power Query Editor window: 1. Ribbon 2. Queries Pane 3. Data Pane 4. Query Settings Pane 5. Formula Bar 6. Preview Pane...
2.1 Power Query Data Connectors & Data Connections | Power BI Masterclass #powerbitutorial
Переглядів 1 тис.2 роки тому
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on UA-cam, with all the exercise files provided. In this video, I explain the following concepts in detail: 1. What is a data connector? 2. Details of Data connectors in Power BI Desktop 3. Understand different types of Data Connections 4. Import vs DirectQuery vs LiveConnecti...
Bikeshare Power BI Report - Step by Step | Power BI Project #powerbitraining
Переглядів 5 тис.2 роки тому
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on UA-cam, with all the exercise files provided. In this video, you can follow-along, to create and publish your first Power BI Report. The is a completely hands Power BI Report tutorial, for beginners, to go from raw data to a finished report. In the next video, we take the B...
1.3 Understanding the Power BI Desktop Workflow | Power BI Masterclass #powerbitraining
Переглядів 7962 роки тому
Welcome to the Power BI Masterclass. This is a complete end to end, beginner friendly Power BI Training with all the exercise files provided. This is the third video in the Power BI Masterclass. In this video, you will: 1. Understand the typical workflow within Power BI Desktop 2. Learn the steps to go from raw data to a finished report within Power BI Desktop 3. How the Power BI Workflow align...
1.2 Power BI Desktop Installation and detailed walkthrough | Power BI Masterclass #powerbitraining
Переглядів 6172 роки тому
Welcome to the Power BI Masterclass. This is a complete end to end, beginner friendly Power BI Training with all the exercise files provided. This is the second video in the Power BI Masterclass. In this video, you will learn: 1. How to download and install Power BI Desktop 2. Complete walkthrough of the Power BI Desktop user interface 3. How to change the options and settings Chapter links: 00...
1.1 Introduction to Power BI | Power BI Masterclass with Exercise Files #powerbitraining
Переглядів 1,1 тис.2 роки тому
Welcome to the Power BI Masterclass. This is a complete end to end, beginner friendly Power BI Training with all the exercise files provided. In the video, we cover: 00:00 Introduction to Power BI Masterclass 01:18 What will you learn in this video? 02:12 What is Business Intelligence? 02:56 Benefits of Business Intelligence 04:08 The 5 Step BI Process 09:31 What is Power BI? 10:54 Key componen...
How to RESHAPE Subcategorised data into a table with Power Query #powerbitutorial
Переглядів 2,5 тис.2 роки тому
In this video you will learn how to reshape subcategorised data (data with multiple header rows), with Power Query, into nicely formatted tabular format. Chapter Links: 00:00 What are we going to learn? 01:09 Review the raw data and the data transformation challenge 02:15 Connect to data in the excel file 03:01 Power Query Editor - applied steps cleanup 04:00 Power Query Editor - remove top row...
How to RESHAPE Horizontally Stacked data into a table with Power Query #powerbitutorial
Переглядів 3,8 тис.2 роки тому
In this video you will learn how to reshape multi column horizontally stacked data into a table, with Power Query. Chapter Links: 00:05 Review the source data and understand the challenge 00:56 Connect to the data source (.xlsx file) 02:27 Review and cleanup the (Auto) Applied Steps 03:09 The technique to reshape multi column horizontally stacked data 06:47 The technique to promoting headers wh...
How to RESHAPE Multi-Column Stacked Data into a table with Power Query #powerbitutorial
Переглядів 2,9 тис.2 роки тому
In this video, you will learn how to reshape multi column vertically stacked data, with Power Query, into nicely formatted tabular format. Chapter Links: 00:00 Introduction 01:05 Review the source data and understand the challenge 03:30 Connect to the data source (.xlsx file) 05:01 The technique to reshape multi column vertically stacked data 08:52 Data Cleanup 10:30 Save transformations and im...
How to RESHAPE Single Column stacked data into a Table with Power Query #powerbitutorial
Переглядів 1,7 тис.2 роки тому
In this video, you will learn how to reshape single column stacked data, with Power Query, into nicely formatted tabular format. Chapter Links: 00:00 Introduction 01:03 Review the characteristics of source data 02:26 Connect to the data source (.txt file) 05:08 The technique to reshape single column stacked data 08:45 Data Cleanup 12:05 Save transformations and import data 13:09 Recap Link to t...
How to Import and join multiple text files data with APPEND in Power Query #powerquerytutorial
Переглядів 1,2 тис.2 роки тому
In this video, we will continue from where we left in the PART 1 of working with text files in Power BI. If you haven't watched it, I will highly recommend you to watch and practice the concepts covered in Part 1 first. Part1 - Importing and cleaning messy data from text file - Power Query Tutorial: ua-cam.com/video/JZH2y4dystk/v-deo.html In this video, you will learn to import and join multipl...
How to import and clean messy data with Power Query #powerbitutorial #powerquerytutorial
Переглядів 3 тис.2 роки тому
In this video, you will learn how to import and clean messy data from a text (.txt) file. Topics Covered: 00:00 Introduction 00:58 Review and identify the challenge at hand 06:30 Connect .txt file using Get Data 08:00 Launch Power Query to Transform Data 09:56 Remove the unwanted header rows 11:33 Promote top row as headers 11:55 Remove blank rows 13:22 Remove the repeated column headers 14:25 ...
best video i have seen so far clear simple and highly educating thanks sir.
Sir could you suggest me some books for real world business application using Power BI and increase business understanding so that during dashboard creating i could make according to business need and I could give some recommendation as per visualization. Sir please share me lists books name.
Great work
Dear Gurpreet, thank you for the video, this has been very well demonstrated and easy to understand. I have a small query, if you can help - in the slicer 'Churn Status' if I have to also use ALL but have to rename it to something else, maybe 'Both', then how to do this. And once this done, how to custom sort this slicer to always keep the "Both" on top.
thank you so much
Thank you
Wow Sir, Nice Showing All the thing.......One by one ...its really affirmative.......Pls make dax series sir....
Dear Gurpreet, many thanks for the explanation it’s really very useful and well detailed, thank you very much. Just one point, I’m struggling to understand the filter effect applied on the Crossjoin function. I’ve understood the result but the logic behind is a bit fuzzy for me, when we say [Product1]<>[Product2] or [Product1]=[Product2] it’s more or less clear, but [Product1]>[Procuct2] or vice versa especially when we deal with a text fields. I’m a little bit lost regarding this point. Is their any logic behind or should I take it like that and move forward? Many thanks.
That was amazing tutorial literally detailed the best
I LOVE YOU MAN!
Great video, very helpful. How did you figure out this process?
Thanks
Thanks
Thanks
Thanks.
Hi Gurpreet, Thanks for the video. I really appreciate your efforts. However though, I have the data as stated below. Col.A - Item Col.B - Qty 1 Col.C - Price 1 Col.D - Qty 2 Col.E - Price 2 and so on... till Qty 10 and Price 10 and would like to transpose/unpivot/pivot to the end result that i am trying to achieve as mentioned below Col.A - each Item repeated 10 times Col.B - Qty (with all the different Qty for each item to be repeated) Col.C - Price (with all their relevant prices for those quantities and items) Because for each item, will have different price points based on the quantities purchased. Hope that makes sense. Would you share some inputs on how this would be realistically possible using powerbi/power query editor? Thanks
everything is okay but you are not audible even though my system volume is 100 so it is super irritating
Solved my issue. Thanks
Excelent. Thank you
Thank u
This trick is really useful! Excellent video, very well explained and quick to watch! Thank you so much!
Hi. Im working with a lot of data so when I want to create the Basket analysis Table it says that there is not enough space. Do you have any suggestions on what I can do?
Why you stopped making video, we needed such great project in this tough time.
Thank you for an excellent tutorial! Is there anything worth considering if I want to add products e.g. Prod 3 and Prod 4 in the basket analysis?
Quite helpful to import Association Rule basis analysis as relevant option with easy to follow way. Many Thanks and hope you share more various example of data mining cases on Power BI. Thank you.
Thanks for this video Gurpreet
This is extremely helpful! How would I apply slicers (and where) if I want to look at a specific region or sales channel?
+1 Subs Here!
Thanks for making this Video, I salute you Sir
phew!!!, i got to the end. You are a really good teacher, very detailed.
Thanks for sharing such a great content
This is a masterful video. Thank you so much!!!
How can download the dataset???
Amazing attention to detail, very calm and complete analysis and explanation of the topic. Unfortunately there is no "cleaner" way of achieving this, but I'm happy you confirmed that there is no other option. Will definitely check in again
Thank you so much for such an amazing video !!! You have explained it in the simplest way possible. Really Helped
Plz
Plz sir quick response as you can
Absolutely great video, exactly what I was looking for. The best thing about this is that you started off by explaining the key concepts of support, confidence and lift, which not a lot of youtubers do, since they focus too much on the technical aspects of data without realizing that the true value of such projects lies in the derived business insights. So, thank you for that!
Dear sir hope you're well please guide me about excel so that i can earn online
Subscribed
Thank you from Kenya
thanks
Thank you for a fantastic tutorial. It's really helpful practising along. Much appreciated. I have a question about the groupings created for the Account Balance category at the beginning. Could you help me understand how the groupings were decided? In the 'Add conditional column' window, I noticed that there is an overlap between the upper bound of a clause and the lower bound of the clause after it, for example, 1-1k and then 1k-10k. If we were to have someone with an account balance of 1k, it seems uncertain which grouping they would be in.
Thank you soooooo much
in the data set activity status of the customer is active and churn status of the customer is churned ,is it possible?
Suppose now if we refresh our data for june nd july month we get that in this way only?
Load Customer Data Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Age Groups Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Account Balance Groups Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Credit Score Groups Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Close STILL FACING THE ISSUE
Hi, Can we use Product1<>product2 (not equal) instead greater than. How greater than works here?
So that the product combinations shouldn't be repeating like (Milk --> Bread) or (Bread --> Milk)
For a Calendar table, Its not at all a best practice to use static date range. Use Min and Max function instead and make it dynamic. Just a suggestion from my end...