Month: January 2025

What is an Unmanaged Tenant in Entra ID with Microsoft Fabric / Power BI

Posted on by Annie D

What happens when you sign up for Microsoft Fabric and you are the first for your organization? Adam dives into an unmanaged Entra ID tenant / directory so you can understand!

What is Microsoft Entra ID?
https://learn.microsoft.com/entra/fundamentals/whatis

Quickstart: Create a new tenant in Microsoft Entra ID
https://learn.microsoft.com/entra/fundamentals/create-new-tenant

What is self-service sign-up for Microsoft Entra ID?
https://learn.microsoft.com/entra/identity/users/directory-self-service-signup

📢 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!
*******************

— <a href="http://twitter.com/guyinacube" Continue reading “What is an Unmanaged Tenant in Entra ID with Microsoft Fabric / Power BI” →

Keep your secrets SAFE in Microsoft Fabric and Azure Key Vault

Posted on by Annie D

You don’t want to store your secrets in plain text! Patrick walks you through how you can store your secrets in Azure Key Vault and then leverage them within a Microsoft Fabric Notebook.

NotebookUtils (former MSSparkUtils) for Fabric – Credentials utilities
https://learn.microsoft.com/fabric/data-engineering/notebook-utilities#credentials-utilities

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Keep your secrets SAFE in Microsoft Fabric and Azure Key Vault” →

🔴 Microsoft Power BI / Fabric Q&A – LIVE (Jan 11, 2025) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI & Microsoft Fabric! 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 Power BI / Fabric Q&A – LIVE (Jan 11, 2025) (Member Chat 2nd Half)” →

How to understand large code bases for applications quickly

Posted on by Annie D

***** Video Details *****
Explore how an AI-first development workflow can transform the way you build, understand, and manage complex applications. In this video, you’ll see a live demonstration of using cutting-edge tools like WindSurf and ChatGPT to quickly get to grips with extensive codebases—even if you haven’t written a single line of code yourself.

Follow along as we: • Introduce Prompt Central, an AI-driven application in active development • Show how to pull entire repositories into a single PDF for easy reference • Demonstrate how to upload that PDF to ChatGPT and receive a comprehensive overview of the code’s architecture and Continue reading “How to understand large code bases for applications quickly” →

MS 365 Excel Basics 07: Comprehensive Excel Formula Lesson To Become The Go-To Excel Guru!

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics07.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics07.pdf
In this video learn about.
Topics:
1. (00:00) Introduction
2. (00:39) Topics
3. (02:05) Starting a worksheet formula
4. (02:17) What formula do
5. (02:37) Keyboard shortcuts are fast
6. (03:21) How default alignment helps
7. (05:12) Number Formatting
8. (05:28) Formulas & Number Formatting
9. (07:11) Excel’s Golden Rule
10. (12:09) Formula elements
11. (12:37) Cell References
12. (12:52) Formula to “List products that each employee sold last week” (Relative and Absolute Cell References)
13. (15:15) TEXTJOIN function
14. (16:09) Conditionally format a row with a logical formula with Mixed Cell References
15. (16:48) What is a Mixed Cell Reference?
16. (23:00) Continue reading “MS 365 Excel Basics 07: Comprehensive Excel Formula Lesson To Become The Go-To Excel Guru!” →

Highline College Excel Corporate Finance ACCTG 455 Class 2025 Winter by Mike “excelisfun” Girvin

Posted on by Annie D

This class is for matriculating students at Highline College, but videos and files are free at YouTube in this playlist: https://www.youtube.com/watch?v=cSs9jYudZBQ&list=PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4

Videos (both old from 2010 and new ones for MS 365 Excel) to be posted over next three months.

Topics:
Chapter 1: Introduction
Chapter 2: Financial Statements
Chapter 3: Working with Financial Statements
Chapter 4: Time Value of Money and Valuation
Chapter 5: Discounted Cash Flow Valuation
Chapter 6: Interest Rates & Bond Valuation
Chapter 7: Equity Markets & Stock Valuation
Chapter 8: NPV & Other Investment Criteria
Chapter 9: Capital Investment
Chapter 10: Some Lessons from Capital Market History
Chapter 11: Risk & Return

Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1868.xlsx
Learn how to detect what hidden characters are causing N/A! Errors In XLOOKUP And VLOOKUP And Fix It!
Many functions in this video: CODE, CHAR, RIGHT, TRIM, LOOKUP, XLOOKUP, ARRAYTOTEXT, REDUCE, LAMBDA, SUBSTITUTE, REGEXREPLACE, REGEXTEST, UNICODE, and more!
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction.
2. (00:27) Using XLOOKUP and getting an #N/A Error.
3. (01:12) What cause #N/A? Hidden characters that are unknown.
4. (01:40) Check for hidden characters at end of lookup value with RIGHT & CODE function to check.
5. (02:29) Lookup Ascii codes to figure out what it is? LOOKUP function.
6. (03:42) TRIM to Continue reading “Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868” →