Month: February 2024

Increasing Your Development Speed & Productivity In Power BI

Posted on by Annie D

Learn how these many functions can be applied to your own data sets, to enable you to extract the insights you require very fast

**** Details of what you will learn during this module ****
– Learn how these many functions can be applied to your own data sets, to enable you to extract the insights you require very fast 
– Use combinations of DAX formulas to find and extract very meaningful insights from your data 
– Discover the key points on how to apply them effectively and see how they are used to solve real-world problems

***** Learning with Enterprise DNA *****
FREE Courses Continue reading “Increasing Your Development Speed & Productivity In Power BI” →

Append Tables in Excel. Excel Magic Trick 1852

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1852.xlsx
Learn the old way and the new way to append tables in Excel.
Topics:
1. (00:00) Introduction
2. (00:10) Old Method
3. (00:17) New Method with VSTACK
4. (00:37) Summary
5. (00:53) Closing, Video Links

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

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

Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640

Posted on by Annie D

Microsoft Excel Tutorial: Excel Keeps Inserting Old Formula – How to Fix It!

Every time that Tori adds a new row to her Excel table, four columns auto-fill formulas from years ago.

Oh my gosh. Ever had a crazy frustrating problem with Excel? In this video, we tackle Tori’s Excel nightmare head-on. Tori’s adding new rows to her table, only to find four columns haunted by formulas from three years ago! What gives?

Hey there! If you’re facing Excel woes like Tori, hit that Like button below to help more folks find this solution-packed video – thanks for the support!

Picture this: Tori’s table Continue reading “Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640” →

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