- 49
- 1 002 708
The Power BI Guy
Приєднався 9 жов 2013
I teach Power BI, Excel & SQL content!
Database vs Data Warehouse vs Data Lake - What's the difference?
So what is the difference beween a Database a Data Warehouse and a Data Lake? These are often terms you hear in the data world and understand what a Database is, what a Data Warehouse is and What a Data Lake is crucial.
We will cover the difference between an OLTP and OLAP database and then how they differ from Data Lakes
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -
SUBSCRIBE!
🔴 Don't forget to subscribe: www.youtube.com/@Transformita
✅ Connect on LinkedIn: www.linkedin.com/in/rajausmaanayub/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -
⌚Timestamps
0:00 Intro
0:28 Databases
0:56 OLTP Database
1:49 Data Warehouse
2:08 OLAP Database
3:10 Data Lake
We will cover the difference between an OLTP and OLAP database and then how they differ from Data Lakes
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -
SUBSCRIBE!
🔴 Don't forget to subscribe: www.youtube.com/@Transformita
✅ Connect on LinkedIn: www.linkedin.com/in/rajausmaanayub/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -
⌚Timestamps
0:00 Intro
0:28 Databases
0:56 OLTP Database
1:49 Data Warehouse
2:08 OLAP Database
3:10 Data Lake
Переглядів: 736
Відео
How to Write IF STATEMENTS like a PRO in Power BI
Переглядів 2 тис.4 місяці тому
Learn how to write IF statements in Power BI and then how to do them BETTER using SWITCH. The SWITCH function can be used instead of IF and in particular scenerios where you have to write NESTED IF statements. SWITCH basically works by specifying an expression and then if you have multiple values to check, you can return them with something else. When you have conditions this is when we have to...
How to Pull DATA from a CSV file in Python - EASY
Переглядів 8444 місяці тому
Learn how to read a CSV file in Python and place your data into a table. This is very simple to do and we will be using Pandas to do so. If you have an Excel CSV file and want to load this data then this tutorial is for yourself. #python #pythondataanalysis #datanalytics SUBSCRIBE! 🔴 Don't forget to subscribe: ✅ Connect on LinkedIn: www.linkedin.com/in/rajausmaanayub/ ⌚Timestamps 0:00 Introduct...
MUST KNOW Excel functions to SAVE LOADS of TIME!
Переглядів 7358 місяців тому
There's a variety of functions in Excel to save time but I often find myself using these the most. 🔴 Don't forget to subscribe: / @transformita ✅ Connect on LinkedIn:www.linkedin.com/in/rajausmaanayub/ Timestamps 🕐 0:00 Introduction 0:19 Moving columns 0:36 Sort and filter 0:58 Totals without typing 1:20 Navigating tables 1:46 Adding rows and columns In this video I go over 5 Excel shortcuts or...
STORE tables inside a SLICER and select which table to SEE 😲!
Переглядів 3,5 тис.9 місяців тому
You can configure pre-built table views inside your slicers. Users can make a selection and change the table to one of the configured views. This will reduce the number of individual tables across your reports and let users dynamically select what they need see without having to select individual columns etc. Much better than field parameters without the grouping. 🔴 Don't forget to subscribe: /...
AMAZING new Card Visual Power BI - June 2023 | Tutorial & Examples
Переглядів 9 тис.Рік тому
In this video I cover how to use the new card visual in Power BI. This will save you a lot of time and as a whole is just better than the old cards. This was released as part of the June 2023 Release of Power BI Desktop and is one of my favourite features in a while. I use cards so often this is one that is going to help my workflow. ✅ Connect on linkedIn: www.linkedin.com/in/rajausmaanayub/ ✅ ...
How to BUILD this STUNNING Power BI Report with JUST POWER BI | June 2023
Переглядів 8 тис.Рік тому
In this video I will cover how to build this Power BI report utilising just Power BI and 1 Shape we make in PowerPoint. Building a good looking report that is functional and flexible to change is key when learning Power BI. 🔴 Don't forget to subscribe: / @transformita ✅ Connect on LinkedIn for the Dataset, Tips and Other videos: www.linkedin.com/in/rajausmaa... Timestamps: 0:00 Introduction 0:2...
SQL for Dummies! - 30 Mins
Переглядів 1,8 тис.Рік тому
Welcome to a comprehensive SQL querying tutorial! In this video, I will guide you through the essential skills needed to master SQL querying. This is aimed for beginners looking to enhance their skills, no previous experience is required. If that's you this tutorial is perfect for you. This SQL tutorial is focused at learning how to Query data. What that means, you'll find out during the introd...
Ultimate Guide to MATRIX Tables in Power BI | 2023
Переглядів 53 тис.Рік тому
In this video I cover everything matrix tables in Power BI. I have often found people struggle to use Matrix tables and don't know how to format them and get the view they want or need. A lot of the functionality is hidden behind the formatting tab and drill-down options, and with knowing where to click you can transform your matrix tables. LinkedIn: www.linkedin.com/in/rajausmaanayub/ 0:00 - I...
MAKE and CLEAR all slicer selections at once in Power BI | March 2023
Переглядів 5 тис.Рік тому
Microsoft have released a bunch of new features in the March 2023 Power BI release. One of my favourites being the clearing and selection of slicers. Prior to this release, you would have to create bookmarks for clearing slicers and slicers could not be applied at once. This new functionality should help your end users make and remove the correct selections much easier. Honestly, the amount of ...
5 TIPS for Power BI that EVERY developer SHOULD know
Переглядів 3,6 тис.Рік тому
In this video I go over 5 tips that are super helpful for Power BI report developers. In terms of effeciency and longevity of your reports, it's super useful to know and include these during your development. My favourite tip being 3 batch editing of text in Measures. It saves so much time! If you have any questions, feel free to connect and reach out on linkedIn: www.linkedin.com/in/rajausmaan...
Expand CARDS with more DETAIL in Power BI
Переглядів 6 тис.Рік тому
Card visuals are great and we tend to use them in a lot of our reports. Utilising clickable cards you can allow users to see the detail they need without having to navigate and investigate their data in other visuals with relative ease. linkedIn: www.linkedin.com/in/rajausmaanayub/ Content: 0:00 - Introduction 1:06 - pop-out 1 4:24 - pop-out 2 - - - - - - - - Search Tags: Microsoft PowerBI, Mic...
The Power BI Developer Experience...
Переглядів 8 тис.Рік тому
Welcome to the Power BI developer experience. Hope this made you chuckle, slightly different from the more serious content I post. This took me too long to edit... Inspired from: ua-cam.com/users/results?search_query=new python developers be like @MrPSolver - - - - - - - - Search Tags: Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI for Desktop, PowerBI Pro, PowerBI Online, Po...
How to Clear ALL FILTERS with a one CLICK Button
Переглядів 40 тис.Рік тому
Having a reset button on your report pages will significantly improve your end-user experience. I suggest using one with pages that have over 5 filters. Having to clear all selections individually can become fustrating for end-users doing quick analysis. 0:00 Introduction 0:38 How to create Button - - - - - - - - Search Tags: Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI for...
Power BI Datasets | The Architecture explained & Guide to creating Datasets.
Переглядів 35 тис.Рік тому
Power BI Datasets | The Architecture explained & Guide to creating Datasets.
Understand VARIABLES and use them in DAX | Power BI
Переглядів 4,9 тис.2 роки тому
Understand VARIABLES and use them in DAX | Power BI
HOW to BUILD a Stunning Power BI Report with LAYERS that make your Reports POP! [REPORT DESIGN]
Переглядів 17 тис.2 роки тому
HOW to BUILD a Stunning Power BI Report with LAYERS that make your Reports POP! [REPORT DESIGN]
ADD and REMOVE Columns from a TABLE with a SLICER SELECTION in Power BI | May 2022 RELEASE
Переглядів 15 тис.2 роки тому
ADD and REMOVE Columns from a TABLE with a SLICER SELECTION in Power BI | May 2022 RELEASE
How to HIGHLIGHT data in your Visuals CONDITIONALLY from a Measure #2022
Переглядів 2,2 тис.2 роки тому
How to HIGHLIGHT data in your Visuals CONDITIONALLY from a Measure #2022
Dynamic Visual Filters that will TRANSFORM your Power BI reports #2022
Переглядів 25 тис.2 роки тому
Dynamic Visual Filters that will TRANSFORM your Power BI reports #2022
Transform your reports with INTERACTIVE buttons that SWITCH visuals
Переглядів 48 тис.2 роки тому
Transform your reports with INTERACTIVE buttons that SWITCH visuals
Understand the ALL function once and for all in Power BI
Переглядів 1,6 тис.2 роки тому
Understand the ALL function once and for all in Power BI
How to Build a STUNNING Sales Dashboard in Power BI - Tutorial #2022
Переглядів 228 тис.2 роки тому
How to Build a STUNNING Sales Dashboard in Power BI - Tutorial #2022
How to Use and Understand CALCULATE in Power BI - 2021 DAX
Переглядів 1,3 тис.2 роки тому
How to Use and Understand CALCULATE in Power BI - 2021 DAX
Fact & Dimension tables in Power BI | Data Modelling
Переглядів 67 тис.2 роки тому
Fact & Dimension tables in Power BI | Data Modelling
Change Measures using Slicers in Visuals
Переглядів 8 тис.2 роки тому
Change Measures using Slicers in Visuals
Power BI Report Design for Beginners | Tips & Tricks
Переглядів 10 тис.2 роки тому
Power BI Report Design for Beginners | Tips & Tricks
Creating a minimalistic Power BI report | Timelapse
Переглядів 30 тис.2 роки тому
Creating a minimalistic Power BI report | Timelapse
How to calculate PERCENTAGES based on a single column TOTAL in Power BI
Переглядів 17 тис.2 роки тому
How to calculate PERCENTAGES based on a single column TOTAL in Power BI
COUNT functions in Power BI | Dax Course #3 2021
Переглядів 9842 роки тому
COUNT functions in Power BI | Dax Course #3 2021
I want to get rate from users then want to convert into that rate . how to do ? like if choosed INR then show INR value, if choose USD then pur rate from numeric range parameter and convert into USD using given rate , not manually put into table then convert
god bless you
This guy is fantastic, damn lucky I found him.
Great video, solved my problem straight away on displaying the heirachy table.
I am using this feature but when i apply the 'apply all slicer button' the other slicer changes to not yet applied
Great Content !! can you make notes of all the theory of DAX functions you made for accessibility
Where can i get the example file?
Very interesting data model! I'm new to PowerBI and have a follow-up question... When you add the index column to a DIM query, if the source data changes such that a new ZIP Code is added (or a new client), will these index columns not change when you refresh the source data for the query? Will these index values not change and perform as relative-references? I'm concerned that the data will get mixed around when the DIM table merges into the FACT table mid-query. Or am I overthinking this? Will these relative references update safely so that everything merges correctly? Or maybe the issue is that everybody using the fact table needs to understand that Client ID# is a relative reference that can't be relied upon to stay the same from one cycle of reporting to the next.
Great demo. I really appreciated your clear explanations of how to create dim tables. I did have a question about grouping by zip and city though. If you remove duplicates on postal code you could potentially lose some cities since there are some postal codes with multiple cities in them. Can you remove duplicates bas on city and postal code?
Awesome one. Where did you get the icons from please?
No dataset link? What are suppose to fill in this beautiful remarkable extraordinary template with?? LOL
Just what I needed, thank you!
adding the data in the discription could be more beneficial to learn
adding the data in the discription could be more beneficial to learn
Thank you. Can you explain relationships in football data please
It appears the new version of Power BI doesn't have Format > Visual > Row headers > Options. To get the same effect as turning off (what used to be called) "Stepped Layout", it appears you now go to: Format > Visual > Layout and style presets > Layout = Tabular To turn "Stepped Layout" back on: Format > Visual > Layout and style presets > Layout = Compact ... which will then give you the additional option (right under the Layout pull down menu) to set the amount of indentation. Hope that this helps others.
Pinned. Thanks
You can be sure, this helped me a lot. Yesterday I was struggling to find this setting. Thank you very much!
thank you this has enfuriated me, as soon, which every update, these videos become outdated.
One of best video across UA-cam
Awesome 🎉
If I have two datasets, should I create two star Schema? If yes, how can I manage Dim tables and Facts tables from both datasets?
This was helpful thank you! How would you incorporate an OR clause such as: Count of orders > 500 OR SUM of order amount > 100,000?
This video was helpful. I am currently doing a project on power bi and this explains what i have been looking for. thank you
Thank you so much... I found what I needed here, hidden at the Row Headers setting!
Outstanding example!! Super clear
You focus to much on design instead on the data itself
Given this is a report design video
Great job, Power BI Guy. This video is very helpful for me, thanks!
Great Video and well presented. A Question : I have data stored in SQL and ODATA from which i have pulled the tables I need and saved as a dataset. Because there are 2 sources , when i publish I get a warning message about there being 2 remote source and will result in Refresh failures ? is there are workaround , or will FABRIC be a better route ?
hi, is there any way to apply multiple filters using edit interactions. I'm looking to display a filtered chart based on the selected categories of two donuts charts.
What will happen if both buttons selected?
But can I run it by "Click" other than "Ctrl + Click"
very helpful!
Thanks for sharing. Do you have any idea why I can not see the preview features in the option?
can you share the sample data?
Short n sweet! not 2 hrs long lol
How would you achieve same results for a model with 2 fact tables where you have to make a common dimension from both to use that common dimension for slicing?
you forgot to load data buddy
your ux skills are sick
Can we transform the data in power bi when we use power bi data set
Great video just one question. Wouldnt it be better to 'reference' the source data or cleaned up copy of the source data rather than 'duplicate' as then you wouldnt have to remove the applied steps later ?
bro first keep your camera image some where else which it wont hide your content
Old video. Should be better now 👍🏼
Thank you so much this video. Got a good understanding of building fact and dimension tables from raw data. Just want to know, do we create dimension and fact tables directly in power bi in real world project?
Your video would have made more sense if you had shared the data file used.
Thanks Man! Appreciate it !!!
Legend, thanks for sharing
Legend, thanks!
I hope your day is filled with laughter and joy. Thank you for the service you provide to us unqualified data analysts :)
kindly share the file
Great video Quick queation . Can the dataset (semantic layer) be shared across multiple workspaces?
superb brother, MashaAllah you did a great job its really helpful
Wellness dashboard, I will be learning a few tips, so kindly enclose the practice for Excel file.
Sorry, no longer have the files anymore 👍🏼
Thank you very useful, do you have a video about same subject but related with Financial Statements, example Balance Sheet or Profit and Loss, I`m trying to build a Matrix with this approach. Thank you