Advanced Power BI: Solving the Hard Problems

Рет қаралды 125,486

Күн бұрын

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
✔️KZfaq: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com

Пікірлер: 65

@cromeromail 5 ай бұрын

Dude! This is SO INFORMATIVE! Thank you for elavating the community!

@rohit5145 4 жыл бұрын

Davin Knight ..... more like a Dark Knight of Power BI ... awesome stuff

@kebincui 3 жыл бұрын

Excellent tutorial, Thanks Devin 👍👍👍

@defaultHandle1110 4 жыл бұрын

Interesting. Can totally consume this.

@sagaroberoi7998 3 жыл бұрын

Very helpful content.....please continue making more of such videos.

@sophiar5280 2 жыл бұрын

Another great session to learn PBI. Awesome Devin!

@PragmaticWorks 2 жыл бұрын

Glad you enjoyed it!

@FRANKWHITE1996 2 жыл бұрын

Thanks for sharing! 👍

@TDR_RUTVIK_OFFICIAL Жыл бұрын

THANKS. IT'S HELPFUL

@PragmaticWorks Жыл бұрын

Glad it helped!

@waynethurman2144 3 жыл бұрын

Excellent!

@AMITAS5 4 жыл бұрын

Good scenarios

@user-gz2nt6jn2t 3 жыл бұрын

wow, thanks for your sharing, really helpful to me

@PragmaticWorks 3 жыл бұрын

Glad to help!

@DeepakJaiswal-pg8zg 2 жыл бұрын

Thank you. Its helpful.

@PragmaticWorks 2 жыл бұрын

Glad it was helpful!

@taniabertrand1066 5 ай бұрын

Awesome thank you!

@alejandroramirez5451 2 жыл бұрын

Thank you so much, great video

@PragmaticWorks 2 жыл бұрын

Thanks for watching!

@harshalpatil2111 3 жыл бұрын

Very Nice thank you so much sir

@arunsahoo1277 3 жыл бұрын

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.

@curtismoxam5382 3 жыл бұрын

Thanks

@alfredlear4141 3 жыл бұрын

Most of this i know, but some great tricks learnt along the way. Impressive

@PragmaticWorks 3 жыл бұрын

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.

@waynethurman2144 3 жыл бұрын

Just had to brag on yourself, huh; get over your self importance or just keep it to self!

@Kmsbi 4 жыл бұрын

Awesome very useful information :)

@PragmaticWorks 4 жыл бұрын

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

@comeandsee8275 Жыл бұрын

That’s was great Can powerbi attach daily target of store to staff as they show fingerprint as defined shifts thanks

@parameshtadari9245 3 жыл бұрын

Nice explanation

@nishachauhan6067 4 жыл бұрын

i want the same dataset, from where i can get this?

@nakirikantikiran 3 жыл бұрын

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

@adamtaft8445 4 жыл бұрын

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.

@jideraheem3813 3 жыл бұрын

Awwwmayzing presentation

@sandymaverick4702 5 жыл бұрын

Awesome!!

@yashverma9443 3 жыл бұрын

can you please share all datasets you have used

@lucernec3101 Жыл бұрын

Can you tell me if we can do Power BI Adhoc Analytics

@user-oh1tz8my6g Жыл бұрын

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

@anilkumarkarimbanakkal5043 4 жыл бұрын

Awesome

@PragmaticWorks 4 жыл бұрын

We are glad to help

@vilasg1228 2 жыл бұрын

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

@MNEMETH318 4 жыл бұрын

Hi! Where is this data set of salaries you are using? Thanks.

@PragmaticWorks 4 жыл бұрын

Hi Michael. Please, reach out to Devin (dknight@pragmaticworks.com). He will be able to share the file via email

@shoppersdream 3 жыл бұрын

Can you please share the file with us so that we can also practice? Thanks

@toulasantha 4 жыл бұрын

Great video 👍

@PragmaticWorks 4 жыл бұрын

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.

@toulasantha 4 жыл бұрын

Pragmatic Works Thanks mate. I will definitely check it out.

@PragmaticWorks 4 жыл бұрын

@@toulasantha Glad to help!

@svitirur1665 3 жыл бұрын

where I can find the exercise file ?

@sanjayshah5571 3 жыл бұрын

Can you share the data file the above videos?

@KalraJatin 2 жыл бұрын

Can I have the file used in this? Thanks

@fanyntrmny8521 2 жыл бұрын

Nice video 🥰🌹💞

@sunnyn1343 2 жыл бұрын

Please can you share me the demo file to practice

@riazuddin7493 3 жыл бұрын

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.

@PragmaticWorks 3 жыл бұрын

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!

@riazuddin7493 3 жыл бұрын

@@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!

@bram5782 3 жыл бұрын

@@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.

@zobiakhan7531 2 жыл бұрын

19:15

@philiphibberd9490 9 ай бұрын

Great video but can someone save up and get Devin a mic?

@dinethprabash1001 4 жыл бұрын

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

@tigsik3128 4 жыл бұрын

Try this community.powerbi.com/t5/Desktop/Card-visual-with-multiple-selection-slicer/td-p/678090