Category: Business

Why not a date and time table in Power BI instead?

Posted on by Annie D

We had a video talking about creating a Date and Time table in your Microsoft Fabric Warehouse. There were some comments centered around “why”??? Why not do that in Power BI? Patrick shows you!

📢 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 “Why not a date and time table in Power BI instead?” →

A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience

Posted on by Annie D

Want to create a series of data within a Microsoft Fabric Warehouse? Patrick looks at how GENERATE_SERIES can help you instead of doing INSERT after INSERT which doesn’t perform well.

Scripts: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Fabric/20241017%20-%20Generate%20Series.zip

GENERATE_SERIES (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16

GENERATESERIES – DAX Function
https://dax.guide/generateseries/

Brad Schacht
https://x.com/BradleySchacht
https://www.linkedin.com/in/bradleyschacht/

📢 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 “A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience” →

How to create a slick way to adjust your Power BI visual

Posted on by Annie D

Create a slick way to adjust your visual by way of bookmarks leveraging the Navigation button. Adam shows you how to set this approach up to get a nice look and feel.

📢 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 “How to create a slick way to adjust your Power BI visual” →

Leverage Power Query Parameters with Power BI Paginated reports

Posted on by Annie D

You’ve seen how you can use Power Query within Power BI Paginated reports. Now Patrick shows you how you can leverage parameters to drive interactivity!

📢 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 – https://guyinacube.com/tools/

#PowerBI #Paginated #GuyInACube

Unlock Data Factory Power with Existing Connections

Posted on by Annie D

Minimize the clicks you take when setting up connections within Data Factory pipelines to get data QUICKLY! Patrick shows you different ways you can leverage existing connections that you’ve already set up within Pipelines in Microsoft Fabric.

📢 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 “Unlock Data Factory Power with Existing Connections” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (June 29, 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

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

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

Want Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (June 29, 2024)” →

Reframe your Power BI Direct Lake Semantic Model

Posted on by Annie D

Want to know how to make sure you see the latest data when using Direct Lake in your Power BI semantic models? Patrick shows you two options you have and looks at the concept of reframing.

Direct Lake
https://learn.microsoft.com/fabric/get-started/direct-lake-overview

📢 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 “Reframe your Power BI Direct Lake Semantic Model” →

Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645

Posted on by Annie D

Microsoft Excel Tutorial: Excel Introduces TRANSLATE and DETECTLANGUAGE Functions.

Unlock the Power of Excel’s New Functions: TRANSLATE and DETECTLANGUAGE

To download the workbook from today: https://www.mrexcel.com/youtube/rOQraANkokQ/

Hey Excel enthusiasts! If you found this video helpful, don’t forget to click Like down below. It helps more people discover this content. In this video, we’re diving into two amazing new Excel functions: TRANSLATE and DETECTLANGUAGE. These functions are game-changers, making it easier than ever to work with different languages in Excel.

First up, the TRANSLATE function. This powerful tool allows you to translate any text from one language to another effortlessly. Just enter Continue reading “Excel Introduces TRANSLATE and DETECTLANGUAGE Functions – Episode 2645” →

UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1861.xlsx
Download Timing Test file: https://excelisfun.net/files/EMT1861TestResults.xlsx
When extracting a sorted unique list with a formula, it is more efficient to use UNIQUE-SORT, rather than SORT-UNIQUE.
Topics:
1. (00:00) Introduction
2. SORT-UNIQUE combination tends to calculate slowly.
3. UNIQUE-SORT tends to calculate quickly.
4. () Summary
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #sort #unique #arrayformulas #excelarrys #dynamicspilled arrays

Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1860.xlsx
Learn how to extract a lookup value from a description and use it to lookup a value without getting an error.
Topics:
1. (00:00) Introduction
2. () Use lookup value from description to lookup a value. MID function and XLOOKUP with Plus Zero.
3. () Summary
4. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #xlookup #exceltips

Microsoft Revokes excelisfun MVP Status!

Posted on by Annie D

Today, July 10, 2024, I got a letter from Microsoft that says I am no longer an Excel MVP. I posted about the same number of videos, files and free classes as the year before. I just passed 1,00,000 subscribers. I give everything away for free. But Microsoft says: NO MVP for excelisfun. So be it. I will keep making Excel and Power BI videos because it is fun!!!