Blog

Bonbon's Guide To Data & Tech > Blog

Excel Customers Paying Less Than Average – Episode 2639

Posted on by Annie D

Microsoft Excel Tutorial: Create an Excel Pivot Table to Identify Which Customers Are Paying Less than Average for a Product.

To download the workbook from today: https://www.mrexcel.com/youtube/4XrKZhiBB-k/

Hey Excel enthusiasts! 👋 In this MrExcel netcast, we tackle a fascinating question from Glenn, who joined our recent Nashville IMA webinar. Ever wondered which customers are paying less than the average? 🧐 We’ve got you covered!

🔍 Using a special pivot table based on the Data Model, we delve into the powerful DAX function CALCULATE. Follow along as we transform our data into a table named “Sales” and explore 12,000 rows of Continue reading “Excel Customers Paying Less Than Average – Episode 2639” →

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Jan 20, 2023) (Member Chat 2nd Half)

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 “🔴 Microsoft Fabric / Power BI Q&A – LIVE (Jan 20, 2023) (Member Chat 2nd Half)” →

Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn that the Filter Feature CANNOT run an OR Logical Test Across Two Columns. Solution #1: Add a Helper Column with the OR function. Solution #2: Use the FILTER Array Function. Lean about logical tests in the FILTER function.
Topics:
1. (00:00) Introduction
2. (00:06) Filter Feature CANNOT run an OR Logical Test Across Two Columns
3. (01:03) Helper Column with OR Function to help the Filter Feature
4. (02:01) FILTER Array Function with OR Logical Test
5. (04:06) Summary
6. (04:20) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #filter #filterfunction

Power BI Tutorial for Beginners (2024)

Posted on by Annie D

Learn how to use Power BI with this beginner tutorial! Get started on creating visualizations, building reports, and analyzing data with this powerful tool. Get a head start on using Power BI!

📢 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.linkedin.com/company/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page Continue reading “Power BI Tutorial for Beginners (2024)” →

Get Your DP-600 the Smart Way: Microsoft Fabric Career Hub

Posted on by Annie D

Discover the best way to get your Microsoft DP-600 certification with the new Career Hub on Microsoft Fabric. Access resources, practice tests, and expert advice to help you ace the exam and advance your career in data engineering & analytics. Don’t miss out on this valuable tool for your professional development! Did we also say discounts?

Microsoft Fabric Career Hub
https://aka.ms/fabriccareerhub

Validate your skills with our new certification for Microsoft Fabric Analytics Engineers
https://techcommunity.microsoft.com/t5/microsoft-learn-blog/validate-your-skills-with-our-new-certification-for-microsoft/ba-p/3500872

Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Microsoft Fabric Learn Together
https://learn.microsoft.com/en-us/shows/learn-live/microsoft-fabric-wave-1/?WT.mc_id=academic-114764-leestott

📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Get Your DP-600 the Smart Way: Microsoft Fabric Career Hub” →

Power Query: Referencing Vs Duplicating Queries

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Showcase – the importance of referencing a query
Learn and understand – how to duplicate a query effectively
Discuss – the difference between referencing vs. duplicating
Know – the techniques how to be strategic Continue reading “Power Query: Referencing Vs Duplicating Queries” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Jan 13, 2024) (Member Chat 2nd Half)

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.

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 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, Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Jan 13, 2024) (Member Chat 2nd Half)” →

What happens to the incremental data???

Posted on by Annie D

We talked about incremental data using an integer within your Synapse Data Warehouse in Microsoft Fabric. But Patrick forgot to go through what you do after staging. Well, here you go!

📢 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 – Continue reading “What happens to the incremental data???” →

Excel Show Details In Excel Pivot Table – Episode 2638

Posted on by Annie D

Microsoft Excel Tutorial: Microsoft improves the Show Details feature in a pivot table and adds new entry points.

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

Unlock New Insights with Excel Pivot Tables! 🚀 In this tutorial, we dive into the latest updates from the Excel team. Discover the new Show Details feature, making data analysis smoother than ever! 📊💡

🔍 Show Details Icon: Spot the new icon on the Pivot Table Analyze tab – it’s a game-changer! Similar to the classic double-click, it opens a new sheet to the left with detailed information. Now, with a handy title indicating the Continue reading “Excel Show Details In Excel Pivot Table – Episode 2638” →

Incremental Refresh with your Warehouse without a date in Microsoft Fabric

Posted on by Annie D

Want to incrementally refresh your data without using a date for your Synapse Data Warehouse in Microsoft Fabric? Patrick gives you a pattern you can leverage!

Alex Powers’ Blog

CHANGE (IN THE HOUSE OF LAKES)
https://itsnotaboutthecell.com/2023/10/16/change-in-the-house-of-lakes/

📢 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 Continue reading “Incremental Refresh with your Warehouse without a date in Microsoft Fabric” →

Offset Magic: Make DAX Time Intelligence Disappear

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Discover – the theory behind offsets and how to generate them
Know – how offsets dramatically simplify DAX by rendering DAX time intelligence functions unnecessary
Learn – how to use offsets to easily Continue reading “Offset Magic: Make DAX Time Intelligence Disappear” →

Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637

Posted on by Annie D

Microsoft Excel Tutorial: Finding best routing for a trip with 148 locations.

Hey Excel fam! 🚀 Bill Jelen here with an epic Excel challenge. 🏋️‍♂️ Joined forces with the Supernatural workout community to optimize a 148-location quest using Excel magic. 🌍 Check out the journey, from Tahiti to Antarctica, and witness the distance-cutting madness unfold. 🌐

💡 First attempt started in Tahiti, but the route was a rollercoaster. 🔄 Tried a radical pivot, starting in Antarctica. 🏔️ Improved the distance to 90,253 miles, but still seeking perfection.

🤔 Experimented with K-Means clustering, exploring different strategies. 🧩 Finally settled on a plan starting in Continue reading “Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637” →