Video není dostupné.
Omlouváme se.
Top 10 Power BI Best Practices
Vložit
- čas přidán 5. 08. 2024
- Take our Report Development Best Practices Checklist course: portal.enterprisedna.co/p/rep...
Today, I’m going to share my personal Top 10 Best Practices for Power BI. Over the past months, I’ve released a series of videos showcasing a number of best practices addressing the 4 pillars in Power BI report development. I talk about some of the best practices I’ve incorporated throughout the years of my Power BI learning journey. I’ve consumed many resources which have been instrumental but have quickly become overwhelming. So I made my own notes that are easy to digest and hopefully these will be useful to others. This will be a little different from the traditional Top 10s - rather than a ranked Top 10, I will instead be presenting my Top 10 favorites.
Greg
**** Video Details ****
00:00 Introduction
00:59 Auto date/time
01:11 Auto-detect relationships
01:20 Cross-filtering
01:38 Dates Table
02:04 Staging & Referencing data
03:36 Data volume
04:05 Star schema
04:32 Relationships
05:01 Verbose variable naming
05:39 SWITCH TRUE
06:16 Measure branching
07:17 Format \ General
08:40 Table-first development
**** Related Links ****
Power BI Best Practices Vol. 1 - Data Modelling - • Data Modelling - Power...
Power BI Best Practices Vol. 2 - Data Loading and Transformation - • Data Loading And Trans...
Power BI Best Practices Vol. 3 - DAX Calculations - • DAX Calculations - Pow...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 1 - • Reports & Visualizatio...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 2 - • Reports & Visualizatio...
*** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-d...
#EnterpriseDNA #PowerBI #PowerBIBestPractices #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial #PowerBIReporting #PowerBIVisualization
Level up your Power BI skills and learn from industry experts around the globe! Check here for more info: enterprisedna.co/membership
even 2 years later this is still valid. great content!
Hi @UU-ry6gt, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!
Super video Greg. So many great tips
I also use the underscore prefix to name my variables and @ for new columns in virtual tables, it's the best for readability
Thanks for this great video. I especially liked the SWITCH TRUE one
Hi, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Very interesting tips 👌.
I specially loved the last one start with a table then switch to the desired visual and it let me understand way some MVPs use this technique.
Hi Mehdi Hammadi, glad you appreciated the video. We are so grateful to have had such positive feedback.
Awesome video🔥
Amazing, congratulation for such incredible video.
I wish i knew this. Man it could save me ton of hours. Thank you 🙏
Hi Luan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Awesome session !
Hi Francis, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Super useful! Thanks :-)
Hi Alex, we're glad that you found value in this video! You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Enterprise DNA Channel: czcams.com/channels/y2rBgj4M1tzK-urTZ28zcA.html.
Thank you
Hi Alvaro Rodríguez Lasso, glad you appreciated the video. We are so grateful to have had such positive feedback.
On the topic of data staging queries, I load a monthly update from two flat files in two " From folder" queries. Is it best practice to load each month into two separate staging tables for transformation? The files are a source for Facts and a source for my Customer dimension. Thanks.
Hi Randy. Sounds like a good approach, but for a more complete review, create a post on the Enterprise DNA Forum describing your method fully, and many experienced forum members can offer their opinions.
@@gregphilpsful Will do. Thanks.
One word: Hero!
Hi wisam, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
Hello author, Could you please share this pbix file,Thanks
Hi Shunham, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers!
Sign up here: app.enterprisedna.co/sign-up