Advanced Power BI: Solving the Hard Problems
Vložit
- čas přidán 11. 07. 2024
- By now you have probably seen many Power BI demos and likely love what you see in the product. However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try. So what do you do when your data is not perfect or your business problem is more complex? In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work. This session will give you many tips on how to solve real world problems with Power BI.
To download the files used in this session complete this form: share.hsforms.com/1UT54sf6aRJ...
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use the code "youtube30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
![Advanced DAX: Problem, Design, Solution [Heavy Demo]](http://i.ytimg.com/vi/eKgcLcrebzI/mqdefault.jpg)
![Advanced DAX: Problem, Design, Solution [Heavy Demo]](/img/tr.png)
![[DAX] Best Practices 101 for Optimization & Performance (with Alberto Ferrari)](/img/n.gif)
Dude! This is SO INFORMATIVE! Thank you for elavating the community!
Davin Knight ..... more like a Dark Knight of Power BI ... awesome stuff
Excellent tutorial, Thanks Devin 👍👍👍
Very helpful content.....please continue making more of such videos.
Interesting. Can totally consume this.
Another great session to learn PBI. Awesome Devin!
Glad you enjoyed it!
Thanks for sharing! 👍
Awesome thank you!
Excellent!
Thank you so much. This is exactly the solution I was looking for. After taking the steps that you mentioned here. I come to a stage where after expanding the table I have around 2Million rows in my table and I am not sure in how many pages it has spread across. There is an API call limitation of 500 calls per day. So, while loading the data to interface thousands of rows get loaded successfully and after some time getting an error message saying API call limit got over for the day. Is there any way to work around it or If you have any Videos or Blog posts please do suggest it.
Just working through this as an exercise. Good stuff.
Glad to hear it!
THANKS. IT'S HELPFUL
Glad it helped!
wow, thanks for your sharing, really helpful to me
Glad to help!
Thank you so much, great video
Thanks for watching!
Thank you. Its helpful.
Glad it was helpful!
Awesome very useful information :)
Thanks.. we are glad to hear that. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Very Nice thank you so much sir
Good scenarios
That’s was great
Can powerbi attach daily target of store to staff as they show fingerprint as defined shifts thanks
Hi, nice class , i am very happy if you share me data set you used in this demo, i will more help to me to practice in practical
How do you create a single dashboard from visualizations across multiple workspaces? I have a finance GL workspace and a Marketing workspace and now I want a dashboard that the CFO can see visualizations from both.
Most of this i know, but some great tricks learnt along the way.
Impressive
Hi Alfred, we are glad to hear that you were able to learn great and new tricks with this video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
Just had to brag on yourself, huh; get over your self importance or just keep it to self!
Nice explanation
Awwwmayzing presentation
i want the same dataset, from where i can get this?
Thanks
Awesome!!
can you please share all datasets you have used
Can you please share the file with us so that we can also practice? Thanks
Great Video's. I have a qn I have an API with Scroll ID. Can you explain how to use it. I mean the Code to all the API Recursively
Can you tell me if we can do Power BI Adhoc Analytics
Dear Davin,
@# pragmatic works...
Is it possible to get a better quality video, please?
Many places display is blurry and can't make out the code
Thanks
VG
Hi! Where is this data set of salaries you are using? Thanks.
Hi Michael. Please, reach out to Devin (dknight@pragmaticworks.com). He will be able to share the file via email
Great video 👍
Thanks. We are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our 7-day FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
Pragmatic Works Thanks mate. I will definitely check it out.
@@toulasantha Glad to help!
Awesome
We are glad to help
where I can find the exercise file ?
Can you share the data file the above videos?
Nice video 🥰🌹💞
Can I have the file used in this? Thanks
Please can you share me the demo file to practice
Can Power BI help in comparing two months payroll by highlighting the difference in various components for employees who had different payment in both months.
Hi Riaz, getting a month over month difference is pretty easy with DAX and time intelligence. The current month payroll would simply be:
Payroll = SUM('TableName'[PayrollAmount]).
The prior Month Payroll would be something like:
Prior Month Payroll =
CALCULATE(
[Payroll],
DATEADD('DateTable'[DateColumn], -1, Month) )
If you want to see the difference you could then create a third measure:
Month over Month Diff = [Payroll] - [Prior Month Payroll]
Hope this helps!
@@PragmaticWorks thank you for your reply however, what I actually wanted to ask is that lets assume that we have two components of salary i.e. Basic and Conveyance an employee receives USD 100 and 200 respectively for these two components in the month of April and the same employee receives USD 200 and 100 respectively for the same components in the month of May. Can Power BI DAX give me the information in another table under column Basic and Conveyance as 100 and -100 for the same employee? Please note that we have more than 14,000 employees and every month I have to identify the same by looking for the variance in payroll and identifying the staff who receive different payments as compared to last month. Thank you for your help!
@@riazuddin7493 If you grasp the solution from pragmatic works, your problem would be solved surprisingly. Getting stuck of having more than 1 table inside your pbix file? let the data modelling coming to play.
I have a question, wonder if you could help…
Let's say I have a filter called FRUITS, of which I have currently selected BANANA, APPLE, MANGO
I have created a measure called SELECTED FRUITS, in which I take fruits selected using CONCATENATEX
then I put that measure to a CARD VISUAL; result is BANANA, APPLE, MANGO.
I need to change this to BANANA, APPLE AND MANGO. (Basically, I need to add string “AND” before the last item selected. For an example if I select BANANA, APPLE, MANGO, AVOCADO, then CARD-VISUAL should say BANANA, APPLE, MANGO AND AVOCADO.
Can you help? Thanks
Try this community.powerbi.com/t5/Desktop/Card-visual-with-multiple-selection-slicer/td-p/678090
19:15
Can you send me datasets??
Great video but can someone save up and get Devin a mic?
Please share the dataset, else all goes in vain for learners. Thanks.
half of the presentation is blurred. Funny enough the most interesting part.
Check your internet connection. Nothing wrong with the video at all.