Blog

Bonbon's Guide To Data & Tech > Blog

Unleashing Data for OneLake with Mirroring in Microsoft Fabric

Posted on by Annie D

Learn how to replicate your database to Microsoft Fabric using Mirroring! Patrick walks you through how you can do this with Azure SQL Database and CosmosDB and join across the two.

What is Mirroring in Fabric?
https://learn.microsoft.com/fabric/database/mirrored-database/overview

Mirroring Azure SQL Database (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-sql-database

Mirroring Azure Cosmos DB (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-cosmos-db

📢 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 Continue reading “Unleashing Data for OneLake with Mirroring in Microsoft Fabric” →

Design Engaging Power BI Report Page Tooltips Effortlessly

Posted on by Annie D

We’ve talked about Tooltips before, but this time Adam walks you through how to recreate his Report Page Tooltip in Power BI Desktop. Learn how you can make things a bit more exciting and engaging!

Create tooltips based on report pages
https://learn.microsoft.com/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop

📢 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 href="https://www.instagram.com/guyinacube/" Continue reading “Design Engaging Power BI Report Page Tooltips Effortlessly” →

Some GOTCHAs when using Mirroring in Microsoft Fabric

Posted on by Annie D

Mirroring in Microsoft Fabric can be very powerful but setting them up can sometimes have some frustrations. Patrick walks you through the challenges he hit and how he got around it.

What is Mirroring in Fabric?
https://learn.microsoft.com/fabric/database/mirrored-database/overview

Mirroring Azure SQL Database (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-sql-database

Mirroring Azure Cosmos DB (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-cosmos-db

📢 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 Continue reading “Some GOTCHAs when using Mirroring in Microsoft Fabric” →

Excel Why Are SEC Edgar Numbers Showing as Text in Excel? – Episode 2654

Posted on by Annie D

Microsoft Excel Tutorial: Why Are SEC Edgar Numbers Showing as Text in Excel?

In this episode of the Learn Excel podcast, MrExcel dives into a common issue when working with numbers copied from the SEC Edgar database. Sometimes, Excel displays these numbers as text, causing frustrating #VALUE! errors during calculations. We’ll take a quick break from Copilot and explore why this happens and how to fix it!

The problem? Non-breaking spaces (character 160) sneak into your data when copying from sources like SEC Edgar. Even though they look like regular spaces, they can cause Excel to treat numeric data as text. Continue reading “Excel Why Are SEC Edgar Numbers Showing as Text in Excel? – Episode 2654” →

Copilot In OneDrive Versus Copilot In Excel for Excel Workbooks – Episode 2655

Posted on by Annie D

Microsoft Excel Tutorial: Copilot In OneDrive Versus Copilot In Excel for Excel Workbooks

In today’s video, we’re diving into Copilot in OneDrive and how it handles analyzing an Excel workbook.

But first, let’s settle a little controversy that popped up about my “Spreadsheets are my Jam” coffee mugs. Take my survey to let me know if you carry your coffee mug in your dominant hand or not.

Now, let’s get back to Excel. Remember that awesome trick from Dr. Nitin, where he used Copilot in Word to analyze financial statements? Well, I decided to throw a regular Excel file at Copilot Continue reading “Copilot In OneDrive Versus Copilot In Excel for Excel Workbooks – Episode 2655” →

Excel Word Cloud Using Copilot And Python In Excel – Episode 2656

Posted on by Annie D

Microsoft Excel Tutorial: Word Cloud Using Copilot And Python In Excel – Episode 2656

Creating a word cloud in Microsoft Excel has never been easier! In this video, I walk you through how to generate a word cloud using the new Copilot – Advanced Analysis feature. With just a few clicks, I transformed 3000 rows of data from the Title column into a visually stunning word cloud. The best part? Excel automatically excludes common stop words like “The,” “A,” and “of” so you can focus on the key terms.

I was amazed at how Excel leverages Python to make this happen behind Continue reading “Excel Word Cloud Using Copilot And Python In Excel – Episode 2656” →

Excel Find Active Cell With New Focus Cell (in Beta Now)

Posted on by Annie D

In this Microsoft Excel tutorial, learn how to add a crosshair to locate the active cell with the new Focus Cell feature, now in beta! As our eyes age and screen resolutions increase, it can be tough to spot the active cell. But with the Focus Cell feature, Excel highlights the entire row and column of the active cell, making it much easier to find.

In this video, I’ll walk you through how to enable the Focus Cell setting, which is located on the View tab (next to View Gridlines). You can choose from eight different colors, and the crosshair appears Continue reading “Excel Find Active Cell With New Focus Cell (in Beta Now)” →

Excel – Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs – Episode 2657

Posted on by Annie D

Microsoft Excel Tutorial: Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs

In this video, I’m excited to show you a demo I saw from Microsoft that’s seriously cool! We’re diving into how to use the new Python integration with Excel Copilot to create an NBA basketball shot chart. With data sensors installed in every NBA arena since 2013, we now have detailed info on every shot, including the exact X and Y coordinates and whether the shot was made or missed. This data opens up a whole new world of possibilities for sports analytics Continue reading “Excel – Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs – Episode 2657” →

Mock up new web apps and automations fast – here’s how to do it.

Posted on by Annie D

In this video, I walk through how easy it is to create web apps using GitHub and AI tools, focusing on how these technologies have democratized app development, even for beginners like myself. I highlight how platforms like Replit and Streamlit, along with open-source projects, can supercharge the web app development process, making it faster and more accessible.

You’ll see how I quickly set up repositories on GitHub, find code templates or cookbooks, and fork them to start building my own web apps. I also explore the power of the Grock API and Replit as tools for rapid development, where I Continue reading “Mock up new web apps and automations fast – here’s how to do it.” →

Selenium in Python – What’s possible?

Posted on by Annie D

In this video, I dive into the powerful web automation capabilities of the Selenium library in Python, sharing how it can be integrated with AI tools to efficiently automate tasks. I talk about my personal experiences using Selenium to automate web interactions, such as data input, navigation, and even data acquisition, making it a great tool for anyone looking to streamline repetitive tasks.

You’ll see how Selenium can be used to automate workflows without needing to write a lot of Python code. I demonstrate how it grabs data from spreadsheets, loops through items in a CSV file, and inputs that data Continue reading “Selenium in Python – What’s possible?” →

Accelerating your skills acquisition using AI

Posted on by Annie D

In this video, I share my insights on leveraging AI to rapidly acquire new skills, emphasizing the unprecedented learning opportunities available. I discuss the transformative power of AI in learning, the efficiency of short bursts of learning followed by project implementation, and the personalized learning experience AI offers. I recommend integrating AI into skill acquisition processes and highlight the compounding effect it has on productivity and skill development.