Category: Business

πŸ”΄ Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)

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 “πŸ”΄ Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)” →

What does Microsoft Fabric mean for Power BI?

Posted on by Annie D

You’ve heard the news about Microsoft Fabric but what about Power BI? How does Power BI fit in? Do you need to migrate anything? Can you still do what you were doing? Adam tells you what you need to know!

Direct Lake (PREVIEW)
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

Microsoft Fabric Build 2023 Day 1
https://youtu.be/5jlP0wdEsls

Microsoft Fabric Build 2023 Day 2
https://youtu.be/wdDx0-jvl7w

πŸ“’ 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!
*******************

— Continue reading “What does Microsoft Fabric mean for Power BI?” →

Excel Formulas Sort By Last Name, Names My Have Middle Name #Short Excel Magic Trick 15

Posted on by Annie D

Learn how to create a formula to sort a column of full names with an Excel Formula. Some names have no middle name others have a middle name.
Download Excel File: https://excelisfun.net/files/SEMT00015.xlsx

#excel #excelisfun #analytics #microsoftexcel #microsoftmvp, #short #shorts #excelmvp #excelformulas #excelfunctions #excelformulaforjobinterview #excelforbegginers #excelshorts #exceltutorial #exceltips #exceltipstricks #freeclass #freecourse #freeclasses #freeexcelcourse #freeexcel #shortsyoutube #shorts #short #Sort #sortby #SortNames

What Is ChatGPT & How Do You Use It

Posted on by Annie D

Get ready for an in-depth journey into the world of ChatGPT, a revolutionary AI engine changing industries and job roles across the globe.

In this video, Sam explores how ChatGPT, developed by the incredible minds at OpenAI, has attracted millions of users within its first 5 days. Discover how you can leverage ChatGPT’s Natural Language Processing abilities to simplify complex concepts, improve your professional workflows and amplify your learning experience.

Are you curious about how ChatGPT is enhancing programming? We dive into the nitty-gritty of how this amazing AI tool can offer detailed explanations to intricate coding problems, helping programmers Continue reading “What Is ChatGPT & How Do You Use It” →

Understanding the TIMELINE in DAX Studio

Posted on by Annie D

We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This is one to watch!

DAX Studio
https://daxstudio.org

Marco Russo
https://twitter.com/marcorus
https://www.linkedin.com/in/sqlbi/
https://sqlbi.com

Optimizing DAX Video Course
https://www.sqlbi.com/p/optimizing-dax-video-course/

πŸ“’ 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
— Continue reading “Understanding the TIMELINE in DAX Studio” →

Conditional Format Row When Employee Is Listed More Than 1 Time For Date. Excel Magic Trick 1821.

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1821.xlsx
Learn how to conditionally format a row in a table when the employee is listed more than one time for a specified Date. Learn how to create Logical Formula to apply Formatting. See COUNTIFS function.
Topics:
1. (00:00) Introduction
2. (00:26) Learn how to conditionally format a row in a table when the employee is listed more than one time for a specified Date. Learn how to create Logical Formula to apply Formatting. See COUNTIFS function.
3. (02:47) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #microsoftexcel #microsoftmvp #conditionalformating #conditionalformatting #conditionalformattinginexcel

Create your FIRST Lakehouse in Microsoft Fabric

Posted on by Annie D

You started your journey into Microsoft Fabric. Ted wants to help you understand how to create your first Lakehouse and start getting data into OneLake!

What is a lakehouse in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/lakehouse-overview

Create a lakehouse in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/create-lakehouse

Ted Vilutis
https://www.linkedin.com/in/tedvilutis/
https://twitter.com/tvilutis

πŸ“’ 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/

#MicrosoftFabric #Lakehouse #GuyInACube

What Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class 20

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/20-M365ExcelClass.xlsx
Pdf notes: https://excelisfun.net/files/20-M365ExcelClass.pdf
Learn how to build a Bank CD worksheet schedule to show monthly interest and final CD Value. Learn about the financial concepts behind CD value, and the more general investment future value. Learn about the math that makes compound interest so powerful. See two solutions: worksheet formula model and dynamic spilled array formula model.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:31) Continue reading “What Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class 20” →

πŸ”΄ Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric including Power BI with out guest Amir Netz who is a Microsoft Technical Fellow and CTO/Visionary of Microsoft Fabric. You don’t want to miss this one!

Connect with Amir:
LinkedIn: https://www.linkedin.com/in/amirnetz/
Twitter: https://twitter.com/amirnetz

πŸ“’ 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 Continue reading “πŸ”΄ Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)” →

Excel Formula to Sort By Last Name: Four Awesome Examples! Excel Magic Trick 1821

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1821.xlsx
Learn about how to sort a column of full names (including middle names) by last name using an Excel Formula. See 4 different methods, including Microsoft 365 Excel methods and methods that will work in older versions of Excel.
Topics:
1. (00:00) Introduction
2. (00:21)
3. (00:37) Microsoft 365 Excel Formula (Easy One), SORTBY, TEXTAFTER, LEN and SUBSTITUTE functions.
4. (01:57) Crazy M 365 Excel Formula #1. LOOKUP, BYROWS, LAMBDA, TEXTSPLIT, SORTBY functions with BIG Text Lookup Value β€œzzzzzz”.
5. (03:57) Crazy M 365 Excel Formula #2. Same as #2, but using BIG Text Lookup Value β€œΞ©β€.
6. (04:31) Old School Continue reading “Excel Formula to Sort By Last Name: Four Awesome Examples! Excel Magic Trick 1821” →

Understanding Microsoft Fabric Licensing and Cost (Public Preview)

Posted on by Annie D

Everyone has been asking and now we have some information. Adam breaks down how Microsoft Fabric Licensing and costs work. Helping you get the most out of Fabric!

Announcing Microsoft Fabric capacities are available for purchase
https://blog.fabric.microsoft.com/blog/announcing-microsoft-fabric-capacities-are-available-for-purchase

Microsoft Fabric licenses
https://learn.microsoft.com/fabric/enterprise/licenses

Power BI for US government customers
https://learn.microsoft.com/power-bi/enterprise/service-govus-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
— <a href="http://twitter.com/patrickdba" Continue reading “Understanding Microsoft Fabric Licensing and Cost (Public Preview)” →

Excel Place Local Pictures In Cell Using Formula and a VBA Hack – Episode 2607a

Posted on by Annie D

Microsoft Excel Tutorial: Use Excel VBA to replicate the IMAGE function for images stored locally.

In episode 2606, I showed the new Insert Pictures in Cells and lamented that they did not change the IMAGE function to allow images stored on the local hard drive. Using the VBA Macro in this workbook, you can do it. The VBA is actually better because it remembers the image path and displays it in the formula bar.

To download the workbook or copy the VBA: https://www.mrexcel.com/youtube/0NArag0pV7I/

Table of Contents
(0:00) Enhancing Picture In Cells to use a formula
(0:30) Behind Scenes of 2606
(1:00) Sort Order Continue reading “Excel Place Local Pictures In Cell Using Formula and a VBA Hack – Episode 2607a” →