Month: January 2024


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

🔴 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)” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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???” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

9 hidden gems about On-Object Editing in Power BI

Posted on by Annie D

On-Object editing in Power BI has had a ton of updates! Adam walks through 9 hidden gems you probably didn’t know about using it. You definitely want to see the last one!

Power BI December 2023 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-december-2023-feature-summary/

Use on-object interaction with visuals in your report (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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
— <a href="http://twitter.com/patrickdba" Continue reading “9 hidden gems about On-Object Editing in Power BI” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Thinking about your DAX Queries like a SQL Query in Power BI

Posted on by Annie D

Coming to Power BI with SQL experience? Trying to learn DAX? Patrick shows you how to think about your DAX Queries like a SQL Query in Power BI. We hope this helps you to create DAX Queries that are much more accurate and effective!

📢 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
— <a Continue reading “Thinking about your DAX Queries like a SQL Query in Power BI” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Track Changes Using Dimensions In Power Query

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 – how to implement an SCD Type 2 using Power Query to allow a full historical analysis of a specific dimension
Design – in a precise way to facilitate tracking changes Continue reading “Track Changes Using Dimensions In Power Query” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10

Posted on by Annie D

Download Excel Start file: https://excelisfun.net/files/10-M365ExcelClassStart2024.xlsx
Download pdf notes: https://excelisfun.net/files/10-M365ExcelClass2024.pdf
Download Excel Finished file: https://excelisfun.net/files/10-M365ExcelClassFinished2024.xlsx
This is a 1:45 hour video about everything that the Excel LAMBDA function, LAMBDA Helper Functions & Eta-LAMBDAs can do. This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (01:18) Overview
3. (03:09) Defined Names
4. (13:00) First look at LAMBDA to create a re-usable function
5. (19:25) Advanced Formula Environment
6. (24:08) Continue reading “Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10” →