DAX Is Easy, CALCULATE Makes It Hard

Innovations In Power BI & Power Platform Summit are action-packed live events showcasing a variety of beginner to advanced data analytics and innovations. Summit sessions have a unique focus on how anyone can build and develop analytical solutions that will solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

The future of learning and being more productive with Enterprise DNA!

In this video, I provide a comprehensive overview of DataMentor, our powerful learning tool. I showcase the AI tools and libraries within the platform, explain how to create and manage queries, folders, and favorites, and demonstrate the integration of data flows and skills advisor. I also highlight the customization and individualization features of DataMentor, as well as its seamless integration with Enterprise DNA’s online learning platform. Watch this video to learn how DataMentor can enhance your data analysis skills and streamline your workflow.

00:00 Introduction
01:05 AI Tools and Libraries
01:45 Queries and Libraries
02:48 Analyst Hub Application
04:52 Sharing and Collaboration
05:31 Free Tier and Continue reading “The future of learning and being more productive with Enterprise DNA!”

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

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 (Jan 20, 2023) (Member Chat 2nd Half)”

Power BI Tutorial for Beginners (2024)

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

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

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)

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

What happens to the incremental data???

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

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

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”

9 hidden gems about On-Object Editing in Power BI

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

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”