ฝัง
- เผยแพร่เมื่อ 2 ก.ค. 2024
- In this video we go through the two ways you can combine data in Power BI, using Merge, and Relationships; we go through how to use them, and also when to use one or the other.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of TH-cam.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence
Thanks. Exactly what I was looking for. I have used both for a while and suddenly realised it is sort of the same thing. But wanted to know why the one rather than the other. Thanks.
In Power BI the power of performance is in the star schema. If you flatten the dimensions (as you mentioned in the video) into facts you lose out on the performance, as well as complexity of DAX code you will have to write. What you'd want to do is flatten the dimensional hierarchy (if one exists) into dimension tables that are only one degree of separation from the fact table(s).
That’s makes more sense to me
Love your insight.
haha do YOU have any videos?? I'm thinking your logic is where I need to go with my dataset. I have 4 enormous PBI data sets pulled in to one new PB model. They have identical columns and names. If they were smaller I would just Append them - and that would get me the resulting model that I need. But they're too big to do that. Do I have to create a fact table in the consolidating PB model?
Thanks for the video.
Which is more performance efficient Joins or Relationships? if we have big data
Hi there, relationships tend to be more efficient than joins for bigger datasets, especially when you're joining up fact tables with millions of rows. But if you're working with tiny datasets, its simpler to do joins
@@SolutionsAbroad can you please explain why relationship are better for bigger tables and why joins are better for small data sets?
If we don't have a unique column in both the tables Fact & dimension. Then what approach to follow? create a bridge table, merge or many to many?
Hi, if there is no unique column on both sides I typically create a bridging table. I always avoid many to many relationships whenever possible because it can be pretty unpredictable
👍
Is it necessary for 2 tables to be related before I can do a merge?
Not at all, as long as they have a column they can merge by, that should be all you need
@@SolutionsAbroad thanks! More power to your channel, bro!
Very clear instruction. Thank you. Just a quick question. When we use merge, we can match multiple criterias in main table with dimention table, while we can not do the same with relationship right ?
yes thats correct
Brilliant! Bye bye to Vlook-up.
index and match if you have to vlookup has flaws
Actually it should be MERGE or RELALATIONSHIP or RELATEDTABLE, right?
merge or RT are sa,e
So you basically created a flat file? I thought it was a golden rule to NOT do that
Hi there, thanks for watching! Working with flat files can't be avoided sometimes, either limitations to the systems or process, so the general rule of thumb is to work with relational structures (like the star schema I show in this video)
If you mean creating a one, single flat table through merging, this can be a valid way to of approach too in certain cases, like simplifying your schemas for example.
Hope that helped
@@SolutionsAbroad I guess I meant you took multiple files and through merging, created what would look like a flat file. At what point point does the processing time for the queries and the calculations become resource intensive? I’m thinking from a power pivot/query point of view in excel as well.
I had sent you an email, can you kindly reply me. I would appreciate Fernan.