What Reference Layers have you found and used to enhance your reports?
@dannimarketing3 күн бұрын
I'd love to see Power BI VS tableau usage by area!! 😊😊
@UlyssesHaq2 ай бұрын
So glad to have you back! Can't wait to tuck into this new chapter! Thanks for sharing with us all these years! Haway let's gan!
@GeordieIntelligence2 ай бұрын
Thanks, we've moved office and expanding he team. Expansion is what has allowed me to allocate time to the channel again. It has been refreshing seeing how many of the reports packs that were set up for demos are still running... Even this one only needed half an hour's work to change the initial query, the original function still worked! Check Geordie Consulting on LinkedIn to find our in person training/demo sessions as well all in Central Newcastle if that helps.
@akhileshkhadseofficial5 ай бұрын
How to combine the PBIX files present on 3 different accounts into a one PBIX file ??
@GeordieIntelligence4 ай бұрын
There's a lot to unpack with that request. If you just want a single view, you can bring all the report content into a single workspace and set up a Dashboard covering them. IF you want to build everything into a single Semantic Model, you can either bring the data together using Dataflows as an intermediary or into a single model... You can copy and paste queries between files using Ctrl + C and Ctrl + V, and then set up the relationships. Measures can be imported using Tabular Editor (2.x works fine), you will no doubt need to tweak them as table or column names may have changed. Our partner consultancy would be able to set up a meeting to get you started. Drop them an email is you are interested office (at) geordieconsulting.co.uk
@osmangokturk51547 ай бұрын
Where is the high density sampling?
@GeordieIntelligence6 ай бұрын
Yes this video really didn't work as we did it. The high density sampling algorithm in Power BI is locked away. You can see when it is happening and from demos Microsoft have provided it looks to be getting better, but the compromise of a dynamic web based tool was in limiting how many data points it could render reliably. High density scatter plots just don't work as they will always end up dropping some elements (remember maps a really scatter plots), in practice you can use heatspots to get around it, but it is a compromise, in some instances you will lose edge cases that could be statistically interesting or you can lose elements of the "hot spot", there really is no way of configuring the sampling.
@JG-ii5nt7 ай бұрын
Hi Thanks for the video. But my map is missing parts on my power bi . And I cant figure why. I think it's too detailed
@GeordieIntelligence6 ай бұрын
Detail is the compromise within Power BI. As you push into more than 1000 datapoints it starts to loose elements (you get an exclamation mark on the visual). Typically this is where the drill feature will help. Use your maps to show numbers at a county, state or country level and then zoom when you drill down to that level show the full map.
@carero229 ай бұрын
"Maybe🤣 Al-aska!"
@dkrana2859 Жыл бұрын
can you please make a video on how to create custom shape file if I am not able to get it online. And also as you said that we can drill down the maps, if possible can you please make a video on that too? Would be highly gratefull if you can
@GeordieIntelligence Жыл бұрын
Thanks, we're looking at the next series at the moment. If we can find a suitably easy way to build them we will, technically you can do it with notepad but that's a painful way with a learning brickwall rather than curve... Stick with the channel, the new series is finally starting to take shape after a pause for client projects.
@wolfiereimold1993 Жыл бұрын
🙈 *PromoSM*
@608er Жыл бұрын
Awesome video! I was tasked with plotting all our opportunities across the US for our sales team and this is great. The sun burst looks like what I may want.
@GeordieIntelligence Жыл бұрын
Really glad it was helpful. Maps are central to so many of our jobs but they are so often deployed without being fully considered. Opportunities tracking reports are interesting but must be thought about in terms of response capability. Hope it all works for you, that sounds like a great data stack.
@pbiqueryous Жыл бұрын
Everyone loves a map! A bit niggly to set up, but the rewards are huge :)
@GeordieIntelligence Жыл бұрын
Yes, almost every client wants a map at some point. But understanding what is going on can really help you choose what to use when.
@jotarokujo8190 Жыл бұрын
mr waterston fell off fr
@pbiqueryous Жыл бұрын
The pipeline facility in Premium is perfect. In the Pro licence world, this management is alot more manual and more prone to mistakes! What's your opinion on separating DEV, UAT and PRD for Thin Reports? Is it necessary, or should we only the methodology to datasets only? For example would you every have an instance of an App that contains both UAT reports and PRD reports?
@GeordieIntelligence Жыл бұрын
You've hit the nail on the head with that one. That was exactly what I wanted viewers to get to. Thin reports are too "Volatile" to really wrap a Change Management process around. That said the are also the part of Power BI that organisations new to the platform struggle to comprehend. The majority of clients that I start working with are duplicating their Datasets not even realising that they can use thin reports. Applying your deployment pipeline to these thin reports is just an "Make-work", in the same way connecting a Dev Deployment Pipeline workspace is just going to force you to follow different schedules otherwise you would be deploying against different source systems. Additionally as the final demo shows editing in situ is all too common in the world of Power BI reports as the pressures of delivery bring out bad habits! In Week 5 we'll build a real world example solution, where Data and visualisations are kept separate. so your thin reports exist within another premium workspace (they need to be Premium to access the content of the Deployment Pipeline). Governance of your Deployment Pipeline will then become much more manageable.
@Gandalf1969Guy Жыл бұрын
Love this mate - perfect example of some stuff I was looking for and I learned a bunch of other stuff too! I like that it was a step-through vid, not just talking about it but I also like that it wasnt 3hrs long and I still could follow it. I'm hoping there's a follow-up vid on similar sport content. I'm looking to make a teams profile solution as well as this games analysis solution (across the league not just one team). Cheers for the great work and sharing! Have subscribed. My only suggestion for all your great content would be give them some more relevent graphic (when I'm browsing your channel I have to really 'look' to see what each one is - the current pic of the video gives me no (obvious) idea. But small price :)
@GeordieIntelligence Жыл бұрын
Thanks for the feedback. I try to use the playlists to organise things. But I take your point about the graphics. I'll see what I can do. Ross
@jamesbrown6602 Жыл бұрын
So useful thank you!
@GeordieIntelligence Жыл бұрын
Glad it was helpful!
@mattoandsamo Жыл бұрын
Champion
@cavanagd1 Жыл бұрын
Cheers bud. Very useful. Some links to docs in the video description would be helpful.
@GeordieIntelligence Жыл бұрын
Thanks for your feedback.
@joelvargas8397 Жыл бұрын
Amazing work!
@GeordieIntelligence Жыл бұрын
Glad you think so! I'll be revisiting Shape files in the coming weeks.
@fataimomoh9227 Жыл бұрын
Very helpful
@pbiqueryous Жыл бұрын
Auto-date time and auto-relationships... get it in the bin! 🙏 Or at least turn them off by default. I had to inherit a 3rd party consultancy's enterprise data model, and it was all setup with auto-relationships.. the amount of incorrect relationships and inactive relations made it seriously difficult to debug. Excellent presentation.. Geordie Intelligence for 2023 and beyond!
@jotarokujo8190 Жыл бұрын
good job mr waterston
@kudratilla Жыл бұрын
Thank you very much for this amazing and easy-to-understand video! It took me days to find an answer to why many of my locations are missing from the map.
@GeordieIntelligence Жыл бұрын
Yes, a limitation of power bi is around 1000 data points. This is a trade off for the online nature of the platform. It is more something to be aware of as it'll be an issue in specific situations rather than all the time.
@UlyssesHaq Жыл бұрын
@GeordieIntelligence, i hope you make a comeback and start producing content again. Your channel is.vital, and you play an important role representing Data and PowerBI in the North East!
@nodrogMelb Жыл бұрын
17:44 minutes in and I am shouting "F&$ck YOU YESSSSS!" when I work out that it's 'Shape map > Custom Map > Map Settings' and my TopoJson appears on the page. I work in Geographic Information Systems but have just started using BI and faffing around trying to get a map up without having to sign up for Arc GIS was driving me nuts Thanks Mate. (you might want to add that Shape Map is hidden in Desktop and needs to be enabled under Options > Preview Features > Shape Map Visual)
@nodrogMelb Жыл бұрын
Also QGIS is a great free desktop GIS if anyone is interested
@GeordieIntelligence Жыл бұрын
Thanks for the feedback. Shape maps are not my favorite thing to use in Power BI they tend to be over complex so slow. This video was because I had lots of requests about how to start using shape maps. They are useful but as the longest running preview feature it's nice for people to see how they can get started. I was thinking of re-doing it with a new shape file and I'll be sure to add the enable preview feature step.
@jotarokujo81902 жыл бұрын
mr Waterston back at it again ❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️💥💣💣🕋
@jotarokujo81902 жыл бұрын
Another classics from mr waterston
@theg98112 жыл бұрын
Can a datamart retreive data from different power bi tennants? or do we have to copy them manually to datamart on main tenant?
@GeordieIntelligence2 жыл бұрын
Wow, there's a question. Technically tenants are supposed to be separate so no, but I've not experimented enough with the B2B functionality of Azure. From what's there it should be possible to set something up. I suspect you may prefer to go down the Dataflow route for that part however and then pull the result into your datamart. 🤔 So directly no, but something can be done using Azure B2B.
@jotarokujo81902 жыл бұрын
another classic from mister waterston ❤️❤️❤️❤️❤️❤️❤️❤️❤️
@jotarokujo81902 жыл бұрын
I’ve subscribed and I hope to see more amazing videos mr waterston
@christismbuta72292 жыл бұрын
Thank you soo much this was soo useful
@jotarokujo81902 жыл бұрын
Thank you again for the great vids mr waterston❤❤❤❤❤❤
@jotarokujo81902 жыл бұрын
thank you mr waterston
@pbiqueryous2 жыл бұрын
This was a mint demonstration -as always - thank you! The power of dataflows cannot be under estimated. I have one question please regarding Dataflows. I've read the documentation somewhere, how does "daisy-chaining" work?: eg - If I had Dataflow A - and Dataflow B linked A, and done some transformations there. Then Dataflow C loads the results of Dataflow B. I then load Dataflow C into my PBI data model. If I want to refresh data, if refresh A - and then refresh the dataset, will the daisy-chain affect work and automatically update C, or will I ALSO need to refresh dataflow C in order to capture the updates in Dataflow A? sorry for the massive, i hope this makes sense?
@GeordieIntelligence2 жыл бұрын
Daisy-chaining is the process of using a dataflow to feed another dataflow. First off you HAVE to have Premium (Capacity or Per User) to be able to use it, so the Workspace it is in must be flagged as Premium. The main challenge is always getting them to run appropriately, my advice is don't go down this route without setting up Power Automate Scripts to manage them. One of the major benefits of daisy-chaining is the rubbish habit I have of using "Base" tables, if you first Dataflows do the RAW data pull and then the data is curated by the second set of dataflows. Source System --> Extract Dataflow --> Curation Dataflow --> Dataset --> Report (Visualisation) Power Automate has a Dataflow Completion trigger, using a condition on the Output of Status (I'll do a video on this) = Success" then allows you to either trigger the first flow again - for failure - or your curation dataflow - for success.
@jumpropemonk77032 жыл бұрын
Thanks! GI!
@belindac52282 жыл бұрын
Is it possible to get raster layers into a map in Power BI? (e.g. I am trying to use a bathymetry layer)
@GeordieIntelligence2 жыл бұрын
Not with the shape maps. I have heard there may be a plans for it in the Azure Maps visual, but the development plans for Azure Maps are vague.
@pbiqueryous2 жыл бұрын
Ready for this journey! KZbin algorithm has been slow in reminding me. Today's lesson was vitally important. Multiple perspectives/scenarios unlocked from only one Date table - not multiples! Get in!
@GeordieIntelligence2 жыл бұрын
Yes, getting people to switch to a proper date table early saves so much heartache!
@UlyssesHaq2 жыл бұрын
Yessa! Welcome back, am so glad you've returned.! January was the big reset... New focus and new motivations, this year is about growth and evolution, building on our existing knowledge and finessing it. Looking forward to expanding my skillset, getting MS certfified... And hopefully at some point... Get PREMIUM. Deneb is offering new possibilities in datavisualisation within PBI too. 🤓
@GeordieIntelligence2 жыл бұрын
Yes, it's been a busy few months for me and the channel has suffered. I'm preparing a series from "Zero to Hero", going from basics to advanced. I was looking at charticulator for doing some videos on, but I find these solutions tend to be really focused so a solution for one chart just won't work for someone else. I'll keep thinking about it though and see if I can come up with something.
@UlyssesHaq2 жыл бұрын
Base in the place Jesmond! 🤭 Loving this localised journey. Tis nippy outside and there's still danger around us. Be Safe. Looking forward to rejoining for the next step.
@oladman90582 жыл бұрын
Very intuitive. I gained
@UlyssesHaq2 жыл бұрын
I truly admire your approach to PBI data reporting. Most content creators focus on specific tips n tricks. Your content is much deeper and more engaging, you show us to challenge our preconceptions, our misconceptions and to build a proper data culture as a foundation to build compelling reports. Thank you for this journey. I'm looking forward to continuing this learning path.
@GeordieIntelligence3 жыл бұрын
Check out the report for yourself - app.powerbi.com/view?r=eyJrIjoiOWQxZjNiOWItNzFlNS00NjlmLWIxYzMtY2RiMGNhZjI0MmJjIiwidCI6ImZjOWNjMDdlLTA4OWItNDM2OC05YzIzLTVhNmU4MGY5OTNhNCJ9
@UlyssesHaq3 жыл бұрын
Strong content, strong message, strong support. Thank you always. Have a great weekend. Looking forward to more on the otherside.
@GeordieIntelligence3 жыл бұрын
Thanks, I really hate doing Covid reporting, but there is too much nonsense out there. if we can get something meaningful and simple out there then I will have done something good.
@UlyssesHaq3 жыл бұрын
Very well explained. The layer cake of PowerBI. In the day-to-day, people often hoy around the term dashboard when they mean report. Making this distinction as you have explained so elegantly is so helpful in understanding the spiders web of data connectivity and sharing/collaboration. Thank you for your continued content. Always look forward to more.
@GeordieIntelligence3 жыл бұрын
View the COVID report - app.powerbi.com/view?r=eyJrIjoiOWQxZjNiOWItNzFlNS00NjlmLWIxYzMtY2RiMGNhZjI0MmJjIiwidCI6ImZjOWNjMDdlLTA4OWItNDM2OC05YzIzLTVhNmU4MGY5OTNhNCJ9
@UlyssesHaq3 жыл бұрын
This lesson has been a massive (even muckle) game-changer. I've been searching far and wide for a decent explanation on how to use ShapeMaps in PowerBI and it hasn't truly sunk in until I seen this video. I have gone from having pants Bing maps with bubble points, to exquisite choropleth maps that show the LSOA boundary details for each Local Authority district of Tees Valley. You have unlocked greatness and I am eternally grateful. Thank you again, looking forward to more content.
@GeordieIntelligence3 жыл бұрын
Glad it's been of use. The only thing that's still missing is a graduated legend, but you can't have everything can you 🤔
@UlyssesHaq3 жыл бұрын
Thank you again, indepth, insightful content for real world situations. Could i ask for some guidance/advice? You always have quality filled shape maps, with thr tidy segments. There's nothing oot of the box that's ready to use for UK maps, and using QGIS is abit of a nightmare for the uninitiated (me 😅). Is there a simpler or tidier way of getting nice UK segment shaped maps for data with postcodes/district codes etc? Thank again. Big love for this channel.
@GeordieIntelligence3 жыл бұрын
Shape maps are from the shape visual it may still be in preview (it's been there for the last 3 years) There are some supplied with it, but yes you do often have to get creative. New York actually has different shape files for their water towers and Taxis though and the UK is just as bad. You also have to get your data quality nice and high to assign things to the right shape. I'll dig some UK links out to download the shape data and then to make sure it'll work with Power BI
@UlyssesHaq3 жыл бұрын
@@GeordieIntelligence That is extremely kind, cheers good sir. Aye, ive found just trying to make a simple shape map fof the 5 towns/citys of Tees Valley is a nightmare, i have the district codes and postcodes, but i cant find any other way other than QGIS - and their interface is just not intuitive. And there's next to no content online on how to do a UK map for PowerBI. 😔
@GeordieIntelligence3 жыл бұрын
@@UlyssesHaq Postcodes are a great start. Typically, there is a delay before new postcodes get added to any documentation, so be aware of that for new build areas. Github has some great repositories. These can be an awesome starting point. Postcodes may be the best place to start and then work on getting a shapefile build and the standardisations needed to make it work consistently. Using Postcodes and their Latitude and Longitude, though, can give you some powerful heatmaps. Postcodes - github.com/Gibbs/UK-Postcodes/blob/master/postcodes.csv GeoJSONs (UK) - martinjc.github.io/UK-GeoJSON/ You then need to validate and check your GeoJSON - mapshaper.org/ Video explaining this (sorry about the audio it was a long time ago) - kzbin.info/www/bejne/iou7fKeilJ2seq8
@UlyssesHaq3 жыл бұрын
Brilliant topic. It raises some very important and even philosphical questions for the analyst. It demonstrates the importance of data-driven culture. Visuals help tell the story, but data is the evidence that supports that story. Question, what is that visual (bottom-right of your report) with the ticket duration, is that a bog standard one, can it be downloaded from the custom viz selections? It looks extremely useful! Thank you again. Really appreciate your content and the new knowledge sharing journey
@GeordieIntelligence3 жыл бұрын
Yes that is the process.science process mining visual, there are a couple available for free on appsource. Week 8 will be a conclusion video, but 9 - 15 will be exploring KPIs and measurements, process mining will be included in that as it is a real game changer. Glad you enjoy the videos, be sure to tell your colleagues about them!
@UlyssesHaq3 жыл бұрын
I was literally just faced with this question yesterday! Can PowerBI also connect to a SharePoint Document Library, as well as SharePoint Lists?
@GeordieIntelligence3 жыл бұрын
Computer says "Yes!"
@UlyssesHaq3 жыл бұрын
This is AMAZING. Tremendous knowledge. Shows that a little bit of ETL legwork provides the foundations for supremely robust dataset and data preparations.
@GeordieIntelligence3 жыл бұрын
Yes, a few simple changes can have a huge difference.
@UlyssesHaq3 жыл бұрын
Geordie Intelligence content is has became essential viewing. Waking up these videos to start the data-driven day. Appreciating the graft and sharing of knowledge. Thank you!
@UlyssesHaq3 жыл бұрын
Many happy returns and I wish many more succesful years to come! I appreciate your content, quality insights and guidance, the themes are relevent to real-world scenarios and the intelligence is Geordie! Propa belta.
@GeordieIntelligence3 жыл бұрын
Thanks, it's been an interesting year. The only thing I was sure of was I didn't want to use the standard demo datasets. Newcastle Libraries and fish in the Tyne are just two examples. 😂🤣😂... Stick with us there's more to come definitely!