Are you struggling to create a data culture in your organization that can support everyone inside the company, not just the executive? Chris Wagner, a director of data solutions at Baker Tilly, is here to help. With over two decades of experience in the data analytics space, Chris has worked with large organizations to create modernized data and analytical strategies. He will provide actionable ideas on how to build a data culture that can help individuals take their next step forward in their data career. This article will cover three focus areas of data engineering, analytics and data science, and Continue reading “Building an Inclusive Data Culture with Chris Wagner”
Category: Business
Excel Reverse Wildcard Search – 2365
VLOOKUP, XLOOKUP, and SUMIFS all allow a wildcard in the Lookup_Value. But today, Chris wants wildcards wrapped around the lookup table! After trying XLOOKUP, FILTER, and COUNTIF, I finally end up with TEXTJOIN, IF, and SEARCH. Do you have a better way?
Table of Contents
(0:00) Use wildcard for the lookup range
(0:34) XLOOKUP, FILTER, COUNTIF failed
(0:54) SEARCH function on an array
(2:11) TEXTJOIN, IFERROR, and SEARCH
(3:15) Surprisingly difficult
Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!
Have you wanted to use a Stored Procedure with Incremental Refresh? Patrick has a way that you can do just that!
Sandeep’s blog:
https://pawarbi.github.io/blog/power%20bi/powerquery/queryfolding/m/optimization/2022/01/25/parameter-valuenativequery-query-folding-where-clause-in-powerbi.html
Stored Procedures: https://learn.microsoft.com/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver16
Sample:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2023/20230201%20-%20IR%20with%20SP.zip
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Continue reading “Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!”
How To Bulk Copy Measures From Different Reports In Power BI
You’ll most probably encounter having to reuse the same measure when working with multiple Power BI reports. In this video, Brian shares a handy trick for copying measures from one report to another. There is no direct way to do this in Power BI but this is something you can achieve using the Tabular Editor.
*****Video Details*****
00:00 Introduction
00:27 Case scenario
00:45 DAX Offsets table
01:22 Copying measures
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Continue reading “How To Bulk Copy Measures From Different Reports In Power BI”
Excel Secret To Maximizing Euro Jackpot Winnings – 2364
Markus is looking for Excel help to pick numbers for the Euro Jackpot where you have to choose 5 numbers from 1 to 50. In this video, I share secrets from my late friend Dogtrack Bill.
To use the number picker in a free Excel Online, follow this link:
https://1drv.ms/x/s!As7G72Sl487JljvjcWPxwg0_pTe1?e=CMGO1E
The Euro Jackpot payout for matching 5 numbers with no bonus numbers is a parimutuel system. A fixed percentage of the betting pool is split between all people that matched five numbers. To maximize the payout if you win, choose numbers that are not likely to be chosen by Continue reading “Excel Secret To Maximizing Euro Jackpot Winnings – 2364”
Ready to be a Kusto Detective with Azure Data Explorer?
Your detective journey starts with the Kusto Detective Agency for Azure Data Explorer. This is a really fun way to learn the Kusto Query Languate (KQL)! Patrick gets you started! And, it’s FREE!
Kusto Detective Agency:
https://detective.kusto.io/
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— rel=”nofollow”>https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#ADX #Kusto #GuyInACube
Excel Use Previous Workday If Not A Workday – 2363
Vicki: I have a list of dates and I’m looking for a formula to calculate the previous workday only if the date in the list is a weekend or holiday.
Why: Accrue Fed Fund Interest Daily (Fed Funds Rate only published on Business Days).
This is mildly complex, because you need to be able to create a named range for the holidays, and after building the long formula, Excel will likely give you the date serial number instead of the formatted date.
Table of Contents
(0:00) Introduction
(0:23) Create a named range with holidays
(1:23) Excel formula to detect if date is a workday using NETWORKDAY Continue reading “Excel Use Previous Workday If Not A Workday – 2363”
How To Calculate Running Totals In Power BI Using DAX
Running Totals is one of the most common analytical insight required when building reports or dashboards within most, if not all, organizations. In this video, Sam is going to show the simple logic required in DAX to develop visualization of this type of analysis.
*****Video Details*****
00:00 Introduction
01:42 Running total in 30 days
03:58 Running total in 90 days
04:30 DATESINPERIOD
06:17 Turning it into a visualization
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Continue reading “How To Calculate Running Totals In Power BI Using DAX”
🔴 Power BI tips from the Pros – LIVE (Jan 28, 2023) (Member Chat 2nd Half)
Join us live as we answer your questions about Power BI!
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (Jan 28, 2023) (Member Chat 2nd Half)”
Free Excel Templates From Microsoft Create – 2361
The Microsoft Create platform is in preview. Sign in with a Microsoft 365 Home account to access free templates for Excel and more. It also includes training on social media from Kat Norton Miss Excel and promises future features.
Table of Contents
(0:00) Free templates in Preview
(0:34) Start at Create.Microsoft.Com
(1:30) Opening a template in Excel Online
(1:54) Accessing from Win32
(2:24) Learning videos including Kat Norton
(3:00) Designer & Clipchamp coming
Considerations For Dark Backgrounds In Power BI Reports [2023 Update]
Dark backgrounds with light font colors make your visuals really pop, but there are a few things to consider when implementing this design format. In this video, Sam details out what to watch out for and what you need to implement to make sure your reports still stay effective.
*****Video Details*****
00:00 Introduction
01:06 Why Use Dark Backgrounds For Visuals
03:58 Conclusion
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events Continue reading “Considerations For Dark Backgrounds In Power BI Reports [2023 Update]”
What do you want to see from Guy in a Cube? – Channel Update
It’s 2023 and there are amazing things ahead! Adam looks at what will be coming for the Guy in a Cube channel, and more importantly has a question for YOU!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – <a Continue reading “What do you want to see from Guy in a Cube? – Channel Update”