Category: Business

DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class

Posted on by Annie D

Download files: https://excelisfun.net/files/DAMEwithMPT06.zip, pdf notes: https://excelisfun.net/files/06-DAMEMPT.pdf
This video teaches how the fundamentals of Columnar Database, DAX Calculated Columns, DAX Measures, Row Context, Filter Content, Context Transition, Overwrite Operation, DAX X Iterator functions, DAX CALCULATE function and much more!
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about
This video covers.
1. (00:00:00) Introduction and video topics
2. (00:00:25) Topics in Video
3. (00:01:49) Why we use DAX, M Code & Worksheet Formulas: What makes Each Special?
4. (00:05:30) Review data, data structure, Excel Continue reading “DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class” →

Excel – RegEx Building Blocks – 2643

Posted on by Annie D

Microsoft Excel Tutorial: Learning the Building Blocks for RegEx in Excel
Learn the basic building blocks of RegEx in Excel.

To download the RegEx Cheat Sheet and workbook from today: https://www.mrexcel.com/youtube/fbHQgDM0P1E/

Welcome back to MrExcel’s YouTube channel! In this video, we’ll dive into the building blocks for mastering Regular Expressions (RegEx) and their integration in Excel. If you find this video helpful, don’t forget to click the Like button below – it helps us reach more viewers. We’ve got over 2,500 videos on various Excel topics, so there’s plenty to explore!

Our focus today is on RegEx, specifically the new functions Continue reading “Excel – RegEx Building Blocks – 2643” →

Excel RegEx Support For Pattern Matching – Episode 2642

Posted on by Annie D

Microsoft Excel Tutorial: Excel Adds RegEx Support for Pattern Matching in Excel.

🎥 Unlocking the Power of RegEx in Excel: New Features Explained! 📊

Hey Excel enthusiasts! 🌟 In today’s video, we’re diving into an exciting new feature: RegEx support in Excel for pattern matching. If you enjoy exploring new Excel functionalities, this is a must-watch! Don’t forget to Like this video to help it reach more people. 👍

🔥 What’s New? 🔥
Excel has introduced three powerful RegEx functions: RegExTest, RegExReplace, and RegExExtract. These functions are set to revolutionize how we handle data patterns. Plus, there are updates to XLOOKUP and XMATCH functions Continue reading “Excel RegEx Support For Pattern Matching – Episode 2642” →

Ditch the whiteboard! Use Microsoft Fabric task flows!

Posted on by Annie D

Tired of drawing out your flow on a whiteboard and it getting erased? Now you can use task flows within Microsoft Fabric to lay things out. Patrick gets you started!

Announcing the public preview of task flows in Microsoft Fabric
https://blog.fabric.microsoft.com/en-us/blog/announcing-the-public-preview-of-task-flows-in-microsoft-fabric?ft=All

Task flows in Microsoft Fabric (preview)
https://learn.microsoft.com/fabric/get-started/task-flow-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
— 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 #Taskflows #GuyInACube

Deliver your Power BI subscriptions to OneDrive or SharePoint!

Posted on by Annie D

We’ve had subscriptions in Power BI for a while but you were limited to just email. NOW you can deliver your subscriptions to OneDrive or SharePoint Online! Patrick shows you how!

Deliver report Subscriptions to OneDrive and SharePoint (Preview)
https://powerbi.microsoft.com/en-us/blog/deliver-report-subscriptions-to-onedrive-sharepoint-preview/

Send large report subscriptions to OneDrive SharePoint (Preview)
https://learn.microsoft.com/power-bi/paginated-reports/paginated-reports-onedrive-sharepoint

📢 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 “Deliver your Power BI subscriptions to OneDrive or SharePoint!” →

We’re back! Latest thoughts and updates on AI and Enterprise DNA

Posted on by Annie D

After a 6 month break, the podcast is back! There’s been a lot of reflecting and thinking that’s been happening over the last while and those thoughts are shared in detail in this latest episode of The Analytic Mind.

New content, new ideas, new guests. This is now TIW 2.0. The world is changing and so shall we!

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX Continue reading “We’re back! Latest thoughts and updates on AI and Enterprise DNA” →

DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)

Posted on by Annie D

DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)
Download files: DAME05zip Pdf notes to read online: DAME05pdfNotes
Alternative download site: https://excelisfun.net/files/DAMEwithMPT05.zip, pdf notes: https://excelisfun.net/files/05-DAMEMPT.pdf
In this video learn about all the fundamentals of the M Code language, the coding language behind Power Query. Learn all about the keys to M Code Mastery: M Code Values, Expressions, Data Types, Operations by Data Types, let expression, M Code Lookup, Custom Functions, and M Code functions such as: Table.AddColumn, Csv.Documnet, Excel.CurrectWorkbook, Table.Group and much more!
Free YouTube Data Analysis Class about Continue reading “DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)” →

Expert Tips for Managing OneLake Data Access in Microsoft Fabric

Posted on by Annie D

Learn how to control access to OneLake data the right way in Microsoft Fabric with these security tips. Keep your data safe and secure with these best practices!

OneLake data access roles – Public Preview Announcement
https://blog.fabric.microsoft.com/en-us/blog/9046?ft=All

OneLake security overview
https://learn.microsoft.com/fabric/onelake/security/get-started-security

Role-based access control (RBAC)
https://learn.microsoft.com/fabric/onelake/security/data-access-control-model

Microsoft Fabric security white paper
https://learn.microsoft.com/fabric/security/white-paper-landing-page

Aaron Merrill:
LinkedIn: https://www.linkedin.com/in/aajmerrill/

📢 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 “Expert Tips for Managing OneLake Data Access in Microsoft Fabric” →

Leverage RLS with Direct Lake in Microsoft Fabric without access to OneLake

Posted on by Annie D

You don’t want to give your users access to OneLake or the Lakehouse/Warehouse directly, but you still want to use Power BI Direct Lake in Microsoft Fabric. Patrick shows you a way to get this done!

Direct Lake Overview
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/
— Continue reading “Leverage RLS with Direct Lake in Microsoft Fabric without access to OneLake” →

Unleash Your Power BI Mobile Audience Potential with Automated layouts!

Posted on by Annie D

Your Power BI Report consumers are probably using the Power BI Mobile app. Have you set up a layout for mobile? Patrick shows you how to quickly create a layout with 1 click!

Automatic mobile layout creation
https://learn.microsoft.com/power-bi/create-reports/power-bi-create-mobile-optimized-report-mobile-layout-view?tabs=powerbi-desktop#automatic-mobile-layout-creation

📢 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 href="https://guyinacube.com" Continue reading “Unleash Your Power BI Mobile Audience Potential with Automated layouts!” →

DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video04Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about when Excel worksheet formulas are the perfect tool for data analysis. An hour lesson in the power of Excel worksheet formulas and when they beat PivotTables, Power Query and Power BI.
Topics:
1. (00:00) Introduction
2. (00:40) 4 scenarios where worksheet formulas are better than other tools.
3. (02:33) Example #1: Enter Data In Worksheet & Need Analysis Off To Side.
4. (03:22) MOD function for hours worked formula
5. (05:19) Line Chart
6. (06:37) 7-Day Continue reading “DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 4, 2024) (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

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: <a href="https://www.youtube.com/" Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 4, 2024) (Member Chat 2nd Half)” →