The Power BI Guy
The Power BI Guy
  • 49
  • 1 002 708
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
Переглядів: 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

КОМЕНТАРІ

  • @nimikajadav3004
    @nimikajadav3004 6 годин тому

    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

  • @Winstonsmith1984ingsoc
    @Winstonsmith1984ingsoc День тому

    god bless you

  • @jobihara
    @jobihara День тому

    This guy is fantastic, damn lucky I found him.

  • @jobihara
    @jobihara День тому

    Great video, solved my problem straight away on displaying the heirachy table.

  • @MohanishBajaj
    @MohanishBajaj 2 дні тому

    I am using this feature but when i apply the 'apply all slicer button' the other slicer changes to not yet applied

  • @aryannaik9635
    @aryannaik9635 8 днів тому

    Great Content !! can you make notes of all the theory of DAX functions you made for accessibility

  • @leandro0505
    @leandro0505 21 день тому

    Where can i get the example file?

  • @ryanjohnston9642
    @ryanjohnston9642 25 днів тому

    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.

  • @JonathanHansen-inmk
    @JonathanHansen-inmk 28 днів тому

    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?

  • @uthmanayomide6173
    @uthmanayomide6173 29 днів тому

    Awesome one. Where did you get the icons from please?

  • @goldylock
    @goldylock Місяць тому

    No dataset link? What are suppose to fill in this beautiful remarkable extraordinary template with?? LOL

  • @esther-cq7pe
    @esther-cq7pe Місяць тому

    Just what I needed, thank you!

  • @ambi297
    @ambi297 Місяць тому

    adding the data in the discription could be more beneficial to learn

  • @ambi297
    @ambi297 Місяць тому

    adding the data in the discription could be more beneficial to learn

  • @busta0079
    @busta0079 Місяць тому

    Thank you. Can you explain relationships in football data please

  • @BradStone-1
    @BradStone-1 Місяць тому

    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.

    • @Transformita
      @Transformita Місяць тому

      Pinned. Thanks

    • @crccastro83
      @crccastro83 Місяць тому

      You can be sure, this helped me a lot. Yesterday I was struggling to find this setting. Thank you very much!

    • @cafeaulait69
      @cafeaulait69 6 днів тому

      thank you this has enfuriated me, as soon, which every update, these videos become outdated.

  • @kartikeyatiwari6678
    @kartikeyatiwari6678 Місяць тому

    One of best video across UA-cam

  • @kartikeyatiwari6678
    @kartikeyatiwari6678 Місяць тому

    Awesome 🎉

  • @user-sp4sf1rd1c
    @user-sp4sf1rd1c Місяць тому

    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?

  • @katieo6802
    @katieo6802 Місяць тому

    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?

  • @Simnom247
    @Simnom247 Місяць тому

    This video was helpful. I am currently doing a project on power bi and this explains what i have been looking for. thank you

  • @RodrigoCalloni
    @RodrigoCalloni Місяць тому

    Thank you so much... I found what I needed here, hidden at the Row Headers setting!

  • @johnskilly
    @johnskilly Місяць тому

    Outstanding example!! Super clear

  • @muhammadarifmohamadamir2716
    @muhammadarifmohamadamir2716 Місяць тому

    You focus to much on design instead on the data itself

    • @Transformita
      @Transformita Місяць тому

      Given this is a report design video

  • @SiarheiLabetsik
    @SiarheiLabetsik Місяць тому

    Great job, Power BI Guy. This video is very helpful for me, thanks!

  • @jefffisher1377
    @jefffisher1377 Місяць тому

    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 ?

  • @JavierPose
    @JavierPose Місяць тому

    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.

  • @atharimam1511
    @atharimam1511 Місяць тому

    What will happen if both buttons selected?

  • @tianyaochu9867
    @tianyaochu9867 Місяць тому

    But can I run it by "Click" other than "Ctrl + Click"

  • @tianyaochu9867
    @tianyaochu9867 Місяць тому

    very helpful!

  • @amirbehboodi9703
    @amirbehboodi9703 Місяць тому

    Thanks for sharing. Do you have any idea why I can not see the preview features in the option?

  • @tannievanrijn3141
    @tannievanrijn3141 Місяць тому

    can you share the sample data?

  • @mar25947
    @mar25947 2 місяці тому

    Short n sweet! not 2 hrs long lol

  • @noneB974
    @noneB974 2 місяці тому

    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?

  • @nefcodes
    @nefcodes 2 місяці тому

    you forgot to load data buddy

  • @nefcodes
    @nefcodes 2 місяці тому

    your ux skills are sick

  • @shwetkumar1719
    @shwetkumar1719 2 місяці тому

    Can we transform the data in power bi when we use power bi data set

  • @mikesmith-nh1jw
    @mikesmith-nh1jw 2 місяці тому

    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 ?

  • @bunnyvlogs7647
    @bunnyvlogs7647 2 місяці тому

    bro first keep your camera image some where else which it wont hide your content

    • @Transformita
      @Transformita 2 місяці тому

      Old video. Should be better now 👍🏼

  • @nidhisingh4973
    @nidhisingh4973 2 місяці тому

    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?

  • @alvintraininghub4040
    @alvintraininghub4040 2 місяці тому

    Your video would have made more sense if you had shared the data file used.

  • @charanmarc5376
    @charanmarc5376 2 місяці тому

    Thanks Man! Appreciate it !!!

  • @JhonMoncaleano
    @JhonMoncaleano 2 місяці тому

    Legend, thanks for sharing

  • @JhonMoncaleano
    @JhonMoncaleano 2 місяці тому

    Legend, thanks!

  • @RedCouchChess
    @RedCouchChess 3 місяці тому

    I hope your day is filled with laughter and joy. Thank you for the service you provide to us unqualified data analysts :)

  • @raginiminivlogger
    @raginiminivlogger 3 місяці тому

    kindly share the file

  • @gautamshah75
    @gautamshah75 3 місяці тому

    Great video Quick queation . Can the dataset (semantic layer) be shared across multiple workspaces?

  • @fahadamir6349
    @fahadamir6349 3 місяці тому

    superb brother, MashaAllah you did a great job its really helpful

  • @sivaprakasam6550
    @sivaprakasam6550 3 місяці тому

    Wellness dashboard, I will be learning a few tips, so kindly enclose the practice for Excel file.

    • @Transformita
      @Transformita 3 місяці тому

      Sorry, no longer have the files anymore 👍🏼

  • @edmundorivero85
    @edmundorivero85 3 місяці тому

    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