Category: Business

Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn that the Filter Feature CANNOT run an OR Logical Test Across Two Columns. Solution #1: Add a Helper Column with the OR function. Solution #2: Use the FILTER Array Function. Lean about logical tests in the FILTER function.
Topics:
1. (00:00) Introduction
2. (00:06) Filter Feature CANNOT run an OR Logical Test Across Two Columns
3. (01:03) Helper Column with OR Function to help the Filter Feature
4. (02:01) FILTER Array Function with OR Logical Test
5. (04:06) Summary
6. (04:20) Closing, Video Links

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

Power BI Tutorial for Beginners (2024)

Posted on by Annie D

Learn how to use Power BI with this beginner tutorial! Get started on creating visualizations, building reports, and analyzing data with this powerful tool. Get a head start on using Power BI!

📢 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.linkedin.com/company/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page Continue reading “Power BI Tutorial for Beginners (2024)” →

Get Your DP-600 the Smart Way: Microsoft Fabric Career Hub

Posted on by Annie D

Discover the best way to get your Microsoft DP-600 certification with the new Career Hub on Microsoft Fabric. Access resources, practice tests, and expert advice to help you ace the exam and advance your career in data engineering & analytics. Don’t miss out on this valuable tool for your professional development! Did we also say discounts?

Microsoft Fabric Career Hub
https://aka.ms/fabriccareerhub

Validate your skills with our new certification for Microsoft Fabric Analytics Engineers
https://techcommunity.microsoft.com/t5/microsoft-learn-blog/validate-your-skills-with-our-new-certification-for-microsoft/ba-p/3500872

Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Microsoft Fabric Learn Together
https://learn.microsoft.com/en-us/shows/learn-live/microsoft-fabric-wave-1/?WT.mc_id=academic-114764-leestott

📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Get Your DP-600 the Smart Way: Microsoft Fabric Career Hub” →

Power Query: Referencing Vs Duplicating Queries

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Showcase – the importance of referencing a query
Learn and understand – how to duplicate a query effectively
Discuss – the difference between referencing vs. duplicating
Know – the techniques how to be strategic Continue reading “Power Query: Referencing Vs Duplicating Queries” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Jan 13, 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.

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 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, Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Jan 13, 2024) (Member Chat 2nd Half)” →

Excel Show Details In Excel Pivot Table – Episode 2638

Posted on by Annie D

Microsoft Excel Tutorial: Microsoft improves the Show Details feature in a pivot table and adds new entry points.

To download the workbook from today: https://www.mrexcel.com/youtube/d8kKJlZIr_g/

Unlock New Insights with Excel Pivot Tables! 🚀 In this tutorial, we dive into the latest updates from the Excel team. Discover the new Show Details feature, making data analysis smoother than ever! 📊💡

🔍 Show Details Icon: Spot the new icon on the Pivot Table Analyze tab – it’s a game-changer! Similar to the classic double-click, it opens a new sheet to the left with detailed information. Now, with a handy title indicating the Continue reading “Excel Show Details In Excel Pivot Table – Episode 2638” →

What happens to the incremental data???

Posted on by Annie D

We talked about incremental data using an integer within your Synapse Data Warehouse in Microsoft Fabric. But Patrick forgot to go through what you do after staging. Well, here you go!

📢 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 – Continue reading “What happens to the incremental data???” →

Incremental Refresh with your Warehouse without a date in Microsoft Fabric

Posted on by Annie D

Want to incrementally refresh your data without using a date for your Synapse Data Warehouse in Microsoft Fabric? Patrick gives you a pattern you can leverage!

Alex Powers’ Blog

CHANGE (IN THE HOUSE OF LAKES)
https://itsnotaboutthecell.com/2023/10/16/change-in-the-house-of-lakes/

📢 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 Continue reading “Incremental Refresh with your Warehouse without a date in Microsoft Fabric” →

Offset Magic: Make DAX Time Intelligence Disappear

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Discover – the theory behind offsets and how to generate them
Know – how offsets dramatically simplify DAX by rendering DAX time intelligence functions unnecessary
Learn – how to use offsets to easily Continue reading “Offset Magic: Make DAX Time Intelligence Disappear” →

Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637

Posted on by Annie D

Microsoft Excel Tutorial: Finding best routing for a trip with 148 locations.

Hey Excel fam! 🚀 Bill Jelen here with an epic Excel challenge. 🏋️‍♂️ Joined forces with the Supernatural workout community to optimize a 148-location quest using Excel magic. 🌍 Check out the journey, from Tahiti to Antarctica, and witness the distance-cutting madness unfold. 🌐

💡 First attempt started in Tahiti, but the route was a rollercoaster. 🔄 Tried a radical pivot, starting in Antarctica. 🏔️ Improved the distance to 90,253 miles, but still seeking perfection.

🤔 Experimented with K-Means clustering, exploring different strategies. 🧩 Finally settled on a plan starting in Continue reading “Excel Shortest Route To 148 Locations Around The Supernatural World Using Excel – Episode 2637” →

9 hidden gems about On-Object Editing in Power BI

Posted on by Annie D

On-Object editing in Power BI has had a ton of updates! Adam walks through 9 hidden gems you probably didn’t know about using it. You definitely want to see the last one!

Power BI December 2023 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-december-2023-feature-summary/

Use on-object interaction with visuals in your report (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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 “9 hidden gems about On-Object Editing in Power BI” →

Thinking about your DAX Queries like a SQL Query in Power BI

Posted on by Annie D

Coming to Power BI with SQL experience? Trying to learn DAX? Patrick shows you how to think about your DAX Queries like a SQL Query in Power BI. We hope this helps you to create DAX Queries that are much more accurate and effective!

📢 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 Continue reading “Thinking about your DAX Queries like a SQL Query in Power BI” →