This is great! No surprise as you explain everything very clear and easy to follow. Thank you very much
@AccessAnalytic2 жыл бұрын
Thank you for taking the time to leave a kind comment Ana. Greatly appreciated 😀
@saucytortoise2 ай бұрын
Excellent video, thanks so much! I did a Power BI course 2 weeks ago, feel like I've already forgotten nearly everything, plus the data I'm working with is a lot more complex than what we used in the training. Your clear concise video is a lifesaver.
@AccessAnalytic2 ай бұрын
Glad to help, I’ve a full playlist here that may help kzbin.info/aero/PLlHDyf8d156VDobBIk13o4mZLk19DbV81&si=JNcNN5QfUBBgvTYm
@Freemarkets12362 жыл бұрын
Unpivot is an amazing tool. I like how you’re like “it’s beautiful” because it truly is. Especially the unpivot other columns which gives your source data the ability to expand in columns without messing up your query.
@AccessAnalytic2 жыл бұрын
Absolutely!
@notesfromleisa-land Жыл бұрын
I had a thorny data problem with some credit card file downloads where I needed different information for different purposes: sales sheet tie out, bank tie out (each neededing horizontal layout with different data filtered) and journal entry (needing no filtering but some cajoling and a vertical layout for entry upload). The unpivot was key. This technique needs to be in everyone's toolkit. As always your explanations are clear and highlights the benefits (and ease) of the technique.
@AccessAnalytic Жыл бұрын
Glad to help
@zakharlukash51157 ай бұрын
You absolutely nailed it, one of the best overall videos about PowerQuery! I like your articulation and the instructions are sophisticated, yet easy to follow. Great content!
@AccessAnalytic7 ай бұрын
Thanks Zakhar, it’s greatly appreciated.
@VaneyRio11 ай бұрын
Apart from being very informative and clear, your voice and accent make it super enjoyable. Thanks!
@AccessAnalytic11 ай бұрын
Thank you ☺️
@Trutchie Жыл бұрын
Breakthrough! I have been trying to understand pivoting all afternoon! Your video has nailed it
@AccessAnalytic Жыл бұрын
Glad to help 😀
@SuperChrisDub Жыл бұрын
I live that you add the tbl at the start of the table name. Methinks you have a programming background. I do that, too. At first glance, it is seems unnecessary but in complicated vba code it makes perfect sense.
@AccessAnalytic Жыл бұрын
I’ve an accounting background but logical naming just feels right 😀
@mohammadsujon1244 ай бұрын
Tis tutorial is very nice. I have learnt the easy way. If gave the source file , it would be easy to practice.
@AccessAnalytic4 ай бұрын
Than you. I’ve started to include files in more recent video.
@JJ_TheGreat2 жыл бұрын
7:52 How do you do that? I know how to merge queries with common fields, but splitting a table? The best approach which I can think of is: 1) Duplicate the query; 2) In each respective query, delete the columns which are unneeded. Then you will have two (2) tables, each with the respective columns you need.
@AccessAnalytic2 жыл бұрын
I’d reference the queries , remove other columns, and append if more than one source. And remove duplicates.
@sf5028 Жыл бұрын
Super helpful, thank you. Very clear, concise, well-explained, and a new user I appreciate the little side tips and best practice notes thrown in as you went through the steps.
@AccessAnalytic Жыл бұрын
You’re welcome, thanks for taking the time to leave a comment letting me know
@nandra80532 жыл бұрын
This is the powerhouse of knowledge. Amazing work. Thank you!
@AccessAnalytic2 жыл бұрын
Thank you
@zrnosoli9 ай бұрын
Your tutorials are very useful and straight forward. I just wish you added links to download the tables you are using in your videos so one could practice while watching :)
@AccessAnalytic9 ай бұрын
Thanks. These days I try to add links to files.
@sofemme39247 ай бұрын
I’m enjoying your videos so much and happy to keep learning. Thanks for creating great content!🙏 I’m curious to know why use a separate date table as a reference table. Is it essential, or can one go without it? Additionally, for those without Power BI access, is there a way to achieve this in Power Query?
@AccessAnalytic7 ай бұрын
Hi, thanks for the kind comment. They Calendar table allows you to slice and dice one or more Data tables by year month day, financial year, month etc. You can also do this in Excel using Power Pivot ( the pre cursor to Power BI ) kzbin.info/www/bejne/iIeXaKyObJWBhJosi=cKLP0tBdKKJNW0mr And kzbin.info/www/bejne/iIeXaKyObJWBhJosi=cKLP0tBdKKJNW0mr
@tijanameduric Жыл бұрын
The tutorial is nice. Calling tidy data in pivot horrible is just 🤣🤣🤣 Tidy data and unpivot data are both perfectly fine, it only depends on what you need it for.
@AccessAnalytic Жыл бұрын
Yep, matrix layout good for reading, horrible for flexible analysis
@tijanameduric Жыл бұрын
in queries yea, in python pivot format, was what we were required to make to analyze. It all depends on what you need, but I agree for a pivot in excel unpivot format is much more useful.
@mandypaulissen Жыл бұрын
Mind blowing!!!! Brilliant way to break data into rows!!!!❤️🔥❤️🔥
@AccessAnalytic Жыл бұрын
It’s a brilliantly useful feature 😀
@zaheerahmad389611 ай бұрын
Good one
@Shhheye1 Жыл бұрын
❤❤❤ Thank you so so much. I’m having do many emotions right now.
@AccessAnalytic Жыл бұрын
Glad to help
@kebincui2 жыл бұрын
Thanks Wyn, excellent video 👍. Just a small query, around 12:29 in the clip, you said that 3 fact tables. I am not sure but feel they are dimension table. Myabe slip of the tongue? Just curious。 Thanks
@AccessAnalytic2 жыл бұрын
Excellent pick-up Kebin. Yep those are 3 dimension tables.
@mnowako2 жыл бұрын
Good lesson, from basic to more complex solution. Thank you! 👏
@AccessAnalytic2 жыл бұрын
Thanks Mariusz
@user-tn3iy6qw6n Жыл бұрын
Great !!1 God bless you.
@AccessAnalytic Жыл бұрын
Thank you
@CelesteAlvarado9311 ай бұрын
Awesome explanation, so helpful! Thank you!
@AccessAnalytic11 ай бұрын
You're welcome 😃
@user-ws6yl3rv3n11 ай бұрын
Thank you very much sir.
@AccessAnalytic11 ай бұрын
You’re welcome
@user-qh6yu1ri5n Жыл бұрын
More videos please, you're the best
@AccessAnalytic Жыл бұрын
Thank you 😀
@abeerattia4523 Жыл бұрын
Excellent video , thanks for sharing your knowledge
@AccessAnalytic Жыл бұрын
You're welcome Abeer, thanks for taking the time to leave a kind comment
@anaballesteros-sosa40072 жыл бұрын
Great tutorial. Thanks so much.
@Aussiepeoplestats Жыл бұрын
great video. btw, where are the downloadable files?
@AccessAnalytic Жыл бұрын
Thanks, not for this one sorry
@user-cz4rp3tt7i Жыл бұрын
Do we have to create tables for all dimensions? What if we have many dimensions?
@AccessAnalytic Жыл бұрын
Yes, pretty much. Certainly all those that have multiple common repeated factors. E.g. date has Year Month Day etc, Product has name, supplier, colour, Customer has address, phone, contact Etc
@garethwoodall5772 жыл бұрын
Excellent tutorial, thank you Wyn!
@AccessAnalytic2 жыл бұрын
You’re welcome Gareth
@wayneedmondson10652 жыл бұрын
Great Wyn! The second example was tricky! Thanks for walking through the process. Just curious, I noticed in your Fields list that the My Measures table shows at the top of the list. My field list sorts automatically alphabetically. So, I must name my measures table as something like --myMeasures or 1-myMeasures for it to sort to the top. How did you position yours at the top before the Auditor Table and Calendar table, etc. that would all naturally sort before the M of MyMeaures? I rooted around for a setting and couldn't find one. Curious how you do that. Thanks again for all the tips. Thumbs up!!
@AccessAnalytic2 жыл бұрын
Cheers Wayne, remove any columns from your measures table and it moves to the top. See the 1:15 mark here kzbin.info/www/bejne/e5q6la19obCarKs
@wayneedmondson10652 жыл бұрын
@@AccessAnalytic Thanks Wyn. I think I was trying to sort it to the top of the list before removing the empty column. Also, good to know that a disconnected measures table won't allow for drill-down from a Pivot Table. Thanks again for all the great tips! Thumbs up!!
@AccessAnalytic2 жыл бұрын
Cheers @@wayneedmondson1065
@WisamMSaeed Жыл бұрын
Thank you
@AccessAnalytic Жыл бұрын
You’re welcome
@nidhipandya71322 жыл бұрын
Great Explaination! Thank you so much.
@AccessAnalytic2 жыл бұрын
Thank you Nidhi
@learnpowerbi2 жыл бұрын
Thanks Wyn, excellent lesson.
@AccessAnalytic2 жыл бұрын
Cheers Iwan
@picksmile5010 Жыл бұрын
Great! thanks
@AccessAnalytic Жыл бұрын
No worries!
@angelaisland40362 жыл бұрын
Thank you so much! Great explanation!
@AccessAnalytic2 жыл бұрын
Thanks for taking the time to let me know Angela
@mon_rich53662 жыл бұрын
best
@salahuddin5022 жыл бұрын
Sir, How can I revert the unpivot excel value. Please it would help me a lot.
@AccessAnalytic2 жыл бұрын
Could you explain more please
@tijanameduric Жыл бұрын
I am wondering the same thing. How to pivote data back? From unpivot format back to pivoted format.
@AccessAnalytic Жыл бұрын
There’s a pivot option in Power Query
@adelhamzah5695 Жыл бұрын
SUPEEER
@cristianchelu1563 Жыл бұрын
Great tutor!
@AccessAnalytic Жыл бұрын
Thanks for the kind comment
@timolff92392 жыл бұрын
Very nice, thank you.
@AccessAnalytic2 жыл бұрын
Cheers Tim
@MD-lk4qr Жыл бұрын
Hi Thanks for the video. I have 3 columns of values and at the very before the column header it is written the date in which identifies the value in the column belongs to a certain date something like this: 202201|202202|202203 how can I fix this issue in power Q to read in Power BI? will it make sense to create 3 different columns of dates relative to the date of the column and then povit them and then povit the 3 columns also? im kindda confuse. your help would be great :)
@AccessAnalytic Жыл бұрын
Hi, that’s a bit too tricky to answer here. I’d post your question with some screenshots here community.powerbi.com/t5/Desktop/bd-p/power-bi-designer
@MrDhunpagla2 жыл бұрын
Thanks Sir 🙏
@AccessAnalytic2 жыл бұрын
You’re welcome
@JJ_TheGreat2 жыл бұрын
7:09 What about SUMIFS distinct values?
@AccessAnalytic2 жыл бұрын
Is there such a thing? Ideally use Power Query to make your formulas simpler in your data model
@hazemali38210 ай бұрын
unfortunately one Episode from 4 have workbook to practice 😔
@AccessAnalytic10 ай бұрын
In the last year or two I started to include a link to download the files I use. This older video does not have a downloadable file.
@nicollealfaro55682 жыл бұрын
Please get back to me ..I would like to pay for a private class