Category: Power Query

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Aug 19, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric including Power BI!

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, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Aug 19, 2023) (Member Chat 2nd Half)” →

Using Figma to wireframe your Power BI reports

Posted on by Annie D

You care about how your Power BI reports look. Sekou joins us to explore using Figma to wireframe your report design and get that look you want before doing all the hard work in Power BI Desktop!

Figma
https://www.figma.com/

Connect with Sekou Tyler
https://www.youtube.com/@SQLSekou
https://www.linkedin.com/in/sekoutyler/
https://twitter.com/sqlsekou
https://lovelytics.com/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
— <a href="http://twitter.com/awsaxton" Continue reading “Using Figma to wireframe your Power BI reports” →

Enabling Power BI Paginated Report Drill!

Posted on by Annie D

Power BI paginated reports support drillthrough! Patrick walks you through how to configure the reports within Report Builder to get them working.

Drillthrough reports in a paginated report (Power BI Report Builder)
https://learn.microsoft.com/power-bi/paginated-reports/report-design/drillthrough-reports-report-builder

📢 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 “Enabling Power BI Paginated Report Drill!” →

Is Data Wrangler the Power Query of Python?

Posted on by Annie D

Have you tried Data Wrangler within Microsoft Fabric or Visual Studio Code? It’s a great way to start cleaning your data and have it write your python code for you! Really getting the Power Query vibes and we love it!

How to accelerate data prep with Data Wrangler in Microsoft Fabric
https://learn.microsoft.com/fabric/data-science/data-wrangler

Introducing the Data Wrangler extension for Visual Studio Code
https://devblogs.microsoft.com/python/data-wrangler-release/

Connect with Eren Orbey:
https://www.linkedin.com/in/orbey/
https://twitter.com/erenorbey

📢 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 Continue reading “Is Data Wrangler the Power Query of Python?” →

🔴 We’re back! Let’s answer your Microsoft Fabric and Power BI questions… (August 12, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including 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 Continue reading “🔴 We’re back! Let’s answer your Microsoft Fabric and Power BI questions… (August 12, 2023)” →

Excel Add-In To Streamline Bill Of Material BOM Analysis – Episode 2612

Posted on by Annie D

Microsoft Excel Tutorial – BOM Tool Suite from Main Sheet Solutions

Do you deal with Bills of Material? Also known as BOMs. Any Structured List in Excel can make use of this add-in from Main Sheet Solutions:

Download a trial from https://www.mainsheetsolutions.com/

Download the two data sets that I used in this video: https://www.mrexcel.com/youtube/k4A1lg9pPlc/

Table of Contents
(0:00) Bills of Material in Excel
(2:02) Data in a typical BOM
(2:21) Ribbon for BOM
(2:29) Adding Grouping
(2:46) Choosing highlight colors
(3:17) Highlight rows
(3:27) Indent BOM
(3:36) BOM Rollup Calculations
(4:30) Analyzing Mike Girvin Book Table of Contents
(6:03) Adding Structure ID and UID
(6:44) Applying colors to group Continue reading “Excel Add-In To Streamline Bill Of Material BOM Analysis – Episode 2612” →

Excel Fill Handle To Copy Formula Rules Deep Dive – Episode 2611

Posted on by Annie D

Microsoft Excel Tutorial – Troubleshooting when you double-click fill handle to copy a formula.

A great question this morning: Is there a bug in double-click the fill handle to copy a formula? Someone was convinced that Excel was being fooled by the formatting.

The behavior of copying a formula by double-clicking the fill handle changed in Excel 2010. Excel now looks at all columns to the left and the right when figuring out how far to copy down. Imagine if Excel does Ctrl+* to select the current region. Excel will copy down to the last row in the current region.

There are two Continue reading “Excel Fill Handle To Copy Formula Rules Deep Dive – Episode 2611” →

Excel Battle on ESPN – Sketch Comedy – 3 Dimes on Diarmuid Early

Posted on by Annie D

The second ever Excel Battle to air on ESPN will happen on Friday August 4, 2023 at 7 AM Eastern time. This short is a bit of sketch comedy … wouldn’t it be great if Excel on ESPN were so commonplace that bookies would start to allow betting on the competition? That’s when you know that you’ve made it to the big time.

This fictitious sketch imagines a day far in the future when you can just call up a bookie and place some action on Diarmuid Early or your favorite Excel competitor.

For 2023, set your alarm and tune in Continue reading “Excel Battle on ESPN – Sketch Comedy – 3 Dimes on Diarmuid Early” →

Excel Esports Returns on “ESPN8: The Ocho”! on August 4, 2023

Posted on by Annie D

Mark your calendars for 7 AM (ET), August 4, 2023, as we gear up for an adrenaline-pumping Excel Esports Elimination Battle – a completely new Excel Esports game format will be revealed!

8 Excel enthusiasts will be competing in a fierce 30-minute battle, but every 5 minutes one of them will be eliminated: Andrew Ngai, Isaac Lee, Diarmuid Early, David Brown, Alana Reid, Brittany Deaton, Michael Holmes, and Emilie Williams.

Hosted by Excel rock stars Leila Gharani, Bill Jelen, and Oz du Soleil!

From precision plays to amazing strategies, the Excel world’s finest content is being brought to your screens.

Whether you’re a die-hard Continue reading “Excel Esports Returns on “ESPN8: The Ocho”! on August 4, 2023″ →

Leagues Cup Tie Probability / Will Messi Play in Orlando in August – Excel episode 2610

Posted on by Annie D

Microsoft Excel Tutorial: Tiebreakers in Leagues Cup Soccer Group Stage.

Lionel Messi’s debut in the US for Miami is in the Leagues Cup. This four-week tournament includes 47 clubs from across the USA, Canada, and Mexico. What are the odds of a tiebreaker in group play for the Leagues Cup? If Miami finishes first or second in their group, who will they play in the knockout stage?

To download this workbook: https://www.mrexcel.com/youtube/M6xbdRFASnI/

Table of Contents
(0:00) Problem Statement: Odds of tiebreaker
(0:21) Orlando City Soccer two home matches in Leagues Cup
(0:48) Lionel Messi’s US debut will be in Leagues Cup
(1:00) Leagues Continue reading “Leagues Cup Tie Probability / Will Messi Play in Orlando in August – Excel episode 2610” →

The MAGIC of Power BI in PowerPoint!

Posted on by Annie D

There were some recent updates to the storytelling experience in PowerPoint with Power BI. Patrick walks through how you can use these to make the most of PowerPoint and Power BI!

About storytelling with Power BI in PowerPoint
https://learn.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-about

📢 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/
— <a Continue reading “The MAGIC of Power BI in PowerPoint!” →