Blog

Bonbon's Guide To Data & Tech > Blog

Discover Adam and Patrick’s Epic 2024 Adventure

Posted on by Annie D

July is here and conferences are coming for the 2nd half of 2024. Learn where you’ll find Adam and Patrick and how you can register. We hope to see you there!

SQL Saturday Baton Rouge 2024 – July 27th
https://sqlsaturday.com/2024-07-27-sqlsaturday1076/

Data Saturday Dallas – September 7th
https://datasaturdays.com/Event/20240907-datasaturday0056

Power Platform Conference – Las Vegas, NV – September 18-20th
https://powerplatformconf.com/

European Microsoft Fabric Community Conference – Stockholm, Sweden – Sept 24-27th
https://aka.ms/fabcon-europe

📢 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 “Discover Adam and Patrick’s Epic 2024 Adventure” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 13, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 13, 2024)” →

Multiple DAX Measure updates in DAX Query View? Yes, Please!

Posted on by Annie D

We got some new updates for the DAX Query view in Power BI Desktop that take it to a whole other level! Patrick shows you how you can start using it with models in the service and more!

Power BI July 2024 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-july-2024-feature-summary/#post-27650-_Toc1615654178

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #DAX #GuyInACube

Overwhelmed with all the Microsoft Fabric Updates???

Posted on by Annie D

There are a lot of updates coming with Microsoft Fabric just like there was with Power BI. It can be overwhelming and hard to keep up. Adam gives some thoughts and lets you know it’s ok!

Managers, What Are You Doing About Change Exhaustion?
https://hbr.org/2022/05/managers-what-are-you-doing-about-change-exhaustion

Navigating Change Fatigue: Strategies For Resilience https://www.forbes.com/sites/johnkotter/2023/09/18/navigating-change-fatigue-strategies-for-resilience/

📢 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
— <a Continue reading “Overwhelmed with all the Microsoft Fabric Updates???” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 20, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 20, 2024)” →

Learn Power Query M Code From Mike Girvin New Book

Posted on by Annie D

Every time I use the Power Query interface, I am aware that I am writing code that is probably as inefficient as recorded VBA code.

Today, a new book from Mike Girvin will teach you how to write M code in Power Query. This is for Power Query in Excel, Power BI, or Power Automate.

The book will be shipping from Amazon on October 1, 2024. However, by the third week in August, I am going to have 200 advance copies. For $29.95, you can buy one of these books with free shipping to the USA. While you wait, you Continue reading “Learn Power Query M Code From Mike Girvin New Book” →

Microsoft Excel Where Did They Move 3D Map Feature – 2646

Posted on by Annie D

Microsoft Excel Tutorial: Where is the 3D Map feature in Excel?

I am a fan of 3D Maps, formerly called Power Map, formerly called GeoFlow. But today, the feature is no longer on the Insert tab. Where did they move it?

Go to the Data Tab. Look towards the right to the Data Tools group. In that group, find the Data Model drop-down. Open that drop-down and there you will find 3D Map.

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Excel Adds Support For RegEx In XLOOKUP And XMATCH – Episode 2647

Posted on by Annie D

Microsoft Excel Tutorial: Using a RegEx match in Excel XLOOKUP
To download the workbook from today: https://www.mrexcel.com/youtube/NZybVpM_dI4/

Welcome to another exciting update from MrExcel! In today’s video, we’re diving into a major breakthrough: RegEx support in XLOOKUP and XMATCH, which was just rolled out on August 14th, 2024. This new feature has been made available to 50% of insiders and promises to revolutionize how you work with data in Excel. If you enjoy the content, don’t forget to hit that Like button below to help more people discover this video!

We’ll start by exploring the new RegEx functionality in XLOOKUP Continue reading “Excel Adds Support For RegEx In XLOOKUP And XMATCH – Episode 2647” →

Excel Copilot First Look August 2024 – Episode 2648

Posted on by Annie D

Microsoft Excel Tutorial: First Look at Copilot in Excel, recorded late August 2024

In today’s video, I dive into my very first experience with the new Copilot feature in Excel on Windows. This is exciting stuff, folks! Imagine Bobby Moynihan’s SNL characters bringing some sass to Excel—because that’s exactly what it felt like working with this tool! 😄 Copilot has some cool new tricks up its sleeve, like no longer needing your data to be in a table format. It can now work with regular ranges, making things so much easier for all of us Excellers.

We’re talking about features like Suggest Continue reading “Excel Copilot First Look August 2024 – Episode 2648” →

Excel Which Invoices Add Up To This Check Amount – 2658

Posted on by Annie D

Microsoft Excel Tutorial: Which Invoices Add Up To This Check Amount – Faster method using Python in Excel.

To download the workbook from today: https://www.mrexcel.com/youtube/6IohCo5KP9Q/

Today, I’m excited to share a powerful solution to a problem I used to call the “knapsack problem” in accounts receivable. We often face scenarios where customers send a payment without specifying which invoices are covered—leaving us to solve the puzzle! In this video, I’ll show you how to identify which invoices match a specific payment amount using Python in Excel, without the need for a Copilot subscription. 🚀

This challenge involves finding a combination Continue reading “Excel Which Invoices Add Up To This Check Amount – 2658” →

Using AI voice tutors to learn new data and programming skills

Posted on by Annie D

In this video we go through how amazing AI voices are becoming. They can already walk you through in a very customized way how to learn about new skills in the data and programming space. You can acquire advanced new skills much faster than you ever thought possible if you embrace this new way of learning.