Author: Annie D

Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1851.xlsx
Celebrate Mike Girvin’s excelisfun 16 Years at YouTube Birthday Party!!! Learn Power Query M Code tricks too.
Topics:
1. (00:00) Introduction
2. (00:01) Thanks you for 16 years!!!!
3. (00:25) Alphanumeric Min and Max. List.Min on Text items, Words!?!?! Yes!
4. (01:37) Group By Can Insensitive!?!? Yes!!! With Table.GroupBy function
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #powerquery, #mcode
Comparer.Ordinal, Comparer.OrdinalIgnoreCase

REPLAY Microsoft Fabric/Power BI Q&A – LIVE (Sept 2, 2023)

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 (Sept 2, 2023)” →

The secret whereabouts of Adam & Patrick revealed!

Posted on by Annie D

Conference season is in full swing, and you have an opportunity to come meet Adam and Patrick in person! From Microsoft Power Platform Conference, to dataMinds Connect, PASS Data Community Summit and the Microsoft Data & AI conferences, now is a great time to take part in the community.

We will be bringing Microsoft Fabric and Power BI to the community!

Microsoft Power Platform Conference
https://powerplatformconf.com/

dataMinds Connect
https://datamindsconnect.be/

PASS Data Community Summit
https://passdatacommunitysummit.com/
Pre-Con: https://passdatacommunitysummit.com/sessions/1970

Microsoft Data & AI Conferenct
https://msdataaiconf.com/
Pre-Con: https://msdataaiconf.com/#!/workshop/Power%20BI%20Hidden%20Gems/6191

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

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

Want to Continue reading “The secret whereabouts of Adam & Patrick revealed!” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 14, 2023)

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 (Oct 14, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Oct 21, 2023)

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 (Oct 21, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (October 28, 2023)

Posted on by Annie D

Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc…

📢 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 SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto

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

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

Want to take your Power BI skills to the next level? We have training Continue reading “REPLAY Microsoft Fabric / Power BI Q&A w/ Marco Russo LIVE (October 28, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 2, 2023)

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 (Dec 2, 2023)” →

Control ACCESS to your Microsoft Fabric Lakehouse or Warehouse

Posted on by Annie D

Want to secure your data in Microsoft Fabric? Adam walks you through different options and layers to control access and prevent people from looking at data they shouldn’t for your lakehouse or warehouse!

Roles in workspaces in Microsoft Fabric
https://learn.microsoft.com/fabric/get-started/roles-workspaces

Row-level security in Fabric data warehousing
https://learn.microsoft.com/fabric/data-warehouse/row-level-security

Row-level security
https://learn.microsoft.com/sql/relational-databases/security/row-level-security?view=sql-server-ver16

Column-level security in Fabric data warehousing
https://learn.microsoft.com/fabric/data-warehouse/column-level-security

How lakehouse sharing works
https://learn.microsoft.com/fabric/data-engineering/lakehouse-sharing

Share your warehouse and manage permissions
https://learn.microsoft.com/fabric/data-warehouse/share-warehouse-manage-permissions

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

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

Want to take your Power BI skills to the next level? We have training courses available to Continue reading “Control ACCESS to your Microsoft Fabric Lakehouse or Warehouse” →

Why can’t I edit my Power BI semantic model?

Posted on by Annie D

Wait!?! I need to adjust some properties in my Power BI semantic model, but I can’t edit it? What’s going on? Patrick shows you what you need to know!

📢 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 – <a href="https://guyinacube.com/tools/" Continue reading “Why can’t I edit my Power BI semantic model?” →

Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050

Posted on by Annie D

Microsoft Excel Tutorial: 🎵 Celebrating Spreadsheet Day in Times Square with the Naked Cowboy! 🎵 | Excel Song and Serenade.

Welcome to my latest video, where the Naked Cowboy, is celebrating Spreadsheet Day from the iconic Times Square in New York City. As a lover of all things Excel, he couldn’t resist the opportunity to serenade the accounting team and all spreadsheet enthusiasts out there with a special song. So, grab your calculators and get ready to sing along with me!

For those who may not know, Spreadsheet Day falls on October 17th and is a day dedicated to celebrating the powerful Continue reading “Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050” →

Excel – First Look At Copilot AI For Excel – Episode 2636

Posted on by Annie D

Microsoft Excel Tutorial: Preview of AI Copilot for Excel.

Welcome to episode 2636 of Mr. Excel’s netcast! In this video, we will be taking a first look at Copilot AI for Excel, a new feature from Microsoft that has been generating a lot of buzz. I was lucky enough to get a sneak peek at this feature, even though it was initially only available for enterprises with over 100 customers. But now, I have access to it and I’m excited to share it with you.

In this video, we will be exploring the Copilot feature and its capabilities. We will be working Continue reading “Excel – First Look At Copilot AI For Excel – Episode 2636” →

We’ve been working on something new…

Posted on by Annie D

Join me as I take you on a journey with our new tool, Data Mentor on Enterprise DNA. Dive into the world of AI-enhanced tools from Code Generators, Debuggers to Visualizers, and Advisors. Understand how Data Mentor can transform your data analytics approach and enhance your AI-driven solutions.

🔍 What to Expect:
– A detailed walkthrough of the Data Mentor’s various AI tools.
– Dive into ‘Creators’ tools like the Pseudo Code Generator and Regex Generator.
– Uncover the potential of ‘Debuggers’ such as the Exception Handler and Syntax Corrector.
– Explore the insights offered by ‘Visualizers’ like the Code Simplifier and Logic Visualizer.
– Introduction Continue reading “We’ve been working on something new…” →