Category: Business

1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1862.xlsx
Learn how to add a formula helper column to the data set to group the dates by half year increments in a PivotTable.
Topics:
1. (00:00) Introduction
2. () Viewer Question
3. () Helper Column Formula
4. () PivotTable
5. () Summary
6. () Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #pivottable #grouping #groupby #formulas #functions

Introduction to the excelisfun Channel at YouTube: Free Videos, Files and Full Free Courses!!

Posted on by Annie D

Home page with free videos, files and full free courses: https://www.youtube.com/@excelisfun
This is an introduction to the excelisfun channel at YouTube, where the videos, practice files and full courses are all free! Mike Girvin created this channel back in 2008 and have posted over 3,700 videos, over 10,000 practice files and over 100 playlists and classes to learn from.

Dive into Power BI and Microsoft Fabric – IN PERSON – two events!

Posted on by Annie D

We are presenting a full day introduction to Microsoft Fabric at two different events in September! This is also important for Power BI folks to understand what all is available to them. Join us to get up to speed quickly!

Data Saturday Dallas (Dallas-Fort Worth, Texas:
Friday, September 6, 2024

Data Saturday Registration:
https://www.eventbrite.com/e/data-saturday-dallas-tickets-905734084027
Data Saturday Pre-Con Sign up:
https://www.eventbrite.com/e/harnessing-the-power-of-microsoft-fabric-tickets-931743197987

SQLKonferenz (Hanau, Germany):
Monday, September 30, 2024
https://sqlkonferenz.de/precon-workshops-2024/
https://sqlkonferenz.de/registration/

📢 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 Continue reading “Dive into Power BI and Microsoft Fabric – IN PERSON – two events!” →

REPLAY Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (July 27, 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

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: <a href="https://www.youtube.com/" Continue reading “REPLAY Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (July 27, 2024)” →

Happy little accidents with the Power BI Card Visual

Posted on by Annie D

Ready to take the Power BI card visual to the next level? Adam tinkers to get it to look just right. It’s a lot of customization but the outcome is way better than the starting point.

Create a (new) card visualization in Power BI Desktop (preview)
https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-new-card?tabs=On-the-ribbon

📢 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
— <a Continue reading “Happy little accidents with the Power BI Card Visual” →

Creative way to use Sempy to update a Power BI report definition

Posted on by Annie D

Need to do a bulk change of something in your Power BI report? The new Power BI report format enables some slick automations. Patrick uses Sempy to get this done!

What is semantic link?
https://learn.microsoft.com/fabric/data-science/semantic-link-overview

Items – Get Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/get-item-definition?tabs=HTTP

Items – Update Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/update-item-definition?tabs=HTTP

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

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

#PowerBI #report #GuyInACube

Which Microsoft Fabric SQL Analytics Endpoint should you use?

Posted on by Annie D

Both the Microsoft Fabric lakehouse and warehouse have a SQL Analytics Endpoint. But they have different limitations. Which one is the right one to use? Patrick breaks it down!

Better together: the lakehouse and warehouse
https://learn.microsoft.com/fabric/data-warehouse/get-started-lakehouse-sql-analytics-endpoint

📢 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***
🛠 Continue reading “Which Microsoft Fabric SQL Analytics Endpoint should you use?” →

Mind-Blowing! Using Copilot Outside of Excel to Analyze Financial Statements! Episode 2652

Posted on by Annie D

Microsoft Excel Tutorial: Using Copilot Outside of Excel to Analyze Financial Statements!

In today’s video, we dive into something that completely blew me away – analyzing financial statements using Microsoft Copilot but not in Excel! You won’t believe what Copilot can do with financial data when working outside of Excel, like in OneDrive or Word.

We’re taking three financial statements (Income Statement, Balance Sheet, and Cash Flow) and letting Copilot generate summaries, calculate financial ratios, and even provide a financial outlook. It’s a game changer for anyone working with complex datasets!

A shoutout to Dr. Nitin, who first showed me this Continue reading “Mind-Blowing! Using Copilot Outside of Excel to Analyze Financial Statements! Episode 2652” →

Excel Copilot With Excel With Python – First Look – Episode 2653

Posted on by Annie D

Microsoft Excel Tutorial: Excel Copilot With Excel With Python
An exciting announcement from Satya Nadella this morning.

In today’s video, we’re diving into something groundbreaking! It’s September 16th, 2024, and right now, Satya Nadella is still talking at Microsoft’s big event, but the exciting news is already here—Copilot in Excel is now generally available, and even better, Copilot with Excel with Python for Advanced Analysis is in preview!

📊 What’s in this Episode? I’ve got 18,000 customer records categorized into four groups—Excel Books, Power BI, Power Query, and VBA—and I’m using Python’s K-means clustering to create six clusters, giving me a clearer picture Continue reading “Excel Copilot With Excel With Python – First Look – Episode 2653” →

Excel New Range Reference For Dynamic Sized Ranges – Episode 2651

Posted on by Annie D

Microsoft Excel Tutorial: Excel New Range Reference For Dynamic Sized Ranges and TRIMRANGE function.

In today’s video, we’re diving into an exciting new feature in the Excel beta that’s bound to change the way we work with dynamic ranges. Microsoft has introduced a groundbreaking method for referencing ranges using a simple dot notation, or by leveraging the new TRIMRANGE function. Say goodbye to inefficient full-column references and hello to cleaner, more efficient formulas. Stick around as we explore how these new features can streamline your Excel workflows!

First up, let’s talk about the TRIMRANGE function. This new function allows you to specify Continue reading “Excel New Range Reference For Dynamic Sized Ranges – Episode 2651” →