Category: Business

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

Excel Extract Everything After First Digit – Episode 2650

Posted on by Annie D

Microsoft Excel Tutorial: Extract Everything After First Digit

**How to Extract Everything in a Cell Starting from the First Digit in Excel!**

In today’s video, we tackle a great question from Alex: *How do we extract everything in a cell starting from the first digit?* Alex has a large dataset, and in one of the columns, he needs to separate “what has to be done” from the address where it needs to be done. The tricky part? There’s no consistent delimiter to separate these two pieces of information. Today, I’ll show you two different solutions to solve this problem—one Continue reading “Excel Extract Everything After First Digit – Episode 2650” →

Copilot Never Watch An Entire YouTube Video Again! Episode 2649

Posted on by Annie D

With a subscription to Copilot 365 and the Edge browser, you will never have to watch an entire YouTube video again.

In this video, I’m showing you an incredible hack using Copilot in Microsoft Edge that will save you from having to watch entire YouTube videos again! Imagine being able to jump straight to the key moments of any video without sitting through the lengthy intros or outros. With Copilot, you can do exactly that—access the essential highlights from any video and skip all the fluff. Here, I’ll walk you through how to do it step-by-step with a practical example from Continue reading “Copilot Never Watch An Entire YouTube Video Again! Episode 2649” →

Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1865.xlsx
Learn how to perform approximate match lookup in Power Query M Code by creating custom functions. The first function we build in a Custom Column using the Table.SelectRows function and the let expression. The second we build as a reusable function in the Advanced Editor using the Table.SelectRows function. The third we build as a reusable function in the Advanced Editor using the List.Accumulate function.

M Code book from excelisfun at Mr Excel Site: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/

M Code book from excelisfun at Amazon: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ref=sr_1_1

The M Code book is Mike “excelisfun” Girvin’s Continue reading “Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865” →

Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864

Posted on by Annie D

Here is link: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ or Amazon: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ref=sr_1_1
Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel.

Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.

Remember:
Microsoft and Lotus though that 1900 was a leap year and so they added 2/29/1900 as a date in Excel. But if you import your dates into Excel or the reverse, all dates work.

Special Offer: New Power BI & Excel Power Query M Code Book from excelisfun!!!

Posted on by Annie D

Here is link: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ or Amazon: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ref=sr_1_1
Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel.

Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.

GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1863.xlsx
Learn how to use the amazing GROUPBY and PIVOTBY functions to create a sales report with categories to summaries by half year increments.
Topics:
1. (00:00) Introduction
2. (00:02) Viewer Suggestion
3. (00:18) IF Function to create ½ data attributes for the table of data.
4. (00:43) GROUPBY Function
5. (01:47) Conditional Formatting for Report
6. (02:22) GO TO Trick to find cells in worksheet that contain Conditional Formatting
7. (02:48) Mixed Cell References and Conditional Formatting for Total Row
8. (04:26) PIVOTBY Function
9. (05:04) Add New Data and Watch Formulas Update!!!
10. (05:37) Summary
11. (05:50) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics Continue reading “GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863” →

Claude vs ChatGPT – which is best, in which situations?

Posted on by Annie D

In this video, I dive into a comparison of two powerful AI tools, Claude and ChatGPT, and highlight the strengths each brings to the table. While ChatGPT excels in quickly generating text and handling general AI tasks, Claude shines when it comes to coding and offers a user interface that makes tasks like code visualization and web app creation much easier.

I also explore how Claude’s superior coding capabilities make it an ideal tool for developers, particularly with its smooth integration with GitHub for seamless code editing and deployment. For those who need to generate text or boilerplate code quickly, ChatGPT Continue reading “Claude vs ChatGPT – which is best, in which situations?” →

How to use Replit for build simple web apps

Posted on by Annie D

In this video, I introduce Replit, an online IDE that has made web app development much simpler, especially for people like me who are still learning to code. I’ll show you how Replit integrates with GitHub and offers AI assistance, making the entire coding process more accessible, even if you’re not a coding expert.

During the video, I demonstrate how I built a speech-to-speech AI assistant using open-source templates. One of the key takeaways is the importance of understanding the code logic behind these apps, which has been a big focus for me as I continue learning. Replit is such a Continue reading “How to use Replit for build simple web apps” →