Category: Business

We’ve been working on something new…

Posted on by Annie D

Join me as I take you on a journey with our new tool, Data Mentor on Enterprise DNA. Dive into the world of AI-enhanced tools from Code Generators, Debuggers to Visualizers, and Advisors. Understand how Data Mentor can transform your data analytics approach and enhance your AI-driven solutions.

🔍 What to Expect:
– A detailed walkthrough of the Data Mentor’s various AI tools.
– Dive into ‘Creators’ tools like the Pseudo Code Generator and Regex Generator.
– Uncover the potential of ‘Debuggers’ such as the Exception Handler and Syntax Corrector.
– Explore the insights offered by ‘Visualizers’ like the Code Simplifier and Logic Visualizer.
– Introduction Continue reading “We’ve been working on something new…” →

Adding a column to your Lakehouse? Where is it in the Semantic Model???

Posted on by Annie D

When you add a column to your lakehouse in Microsoft Fabric, why isn’t is showing up in the Power BI Semantic Model? Patrick shows you how to get it there!

Gaston Cruz
https://twitter.com/GastonFCruz
https://www.linkedin.com/in/gastoncruz/

📢 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***
🛠 Continue reading “Adding a column to your Lakehouse? Where is it in the Semantic Model???” →

Become A Power BI Power User With DAX

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 *****
Control – the Query, Filter, and Row contexts to write DAX expressions
Realize – what you can achieve when you use the CALCULATE function to inject a filter context
Learn – how to Continue reading “Become A Power BI Power User With DAX” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 4, 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.

NOTE: European friends, Time zone trickery is here. It’s an hour different from what it normally is.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 4, 2023)” →

Join us at SQLBits 2024 and save 10%!

Posted on by Annie D

We will be at SQLBits and want to see you there! You can save 10% by using code giac10. Join us to learn great stuff about Microsoft Fabric and Power BI!

SQLBits 2024
Farnborough, UK
March 19-23, 2024
https://sqlbits.com
Theme: Aviation
10% discount: giac10

📢 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 “Join us at SQLBits 2024 and save 10%!” →

REPLAY Starting off 2024! Microsoft Fabric LIVE Q&A (Jan 6, 2024)

Posted on by Annie D

Join us live as we start off 2024 by answering your questions 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 Continue reading “REPLAY Starting off 2024! Microsoft Fabric LIVE Q&A (Jan 6, 2024)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE w/ Kim Manis & Bogdan Crivat (Dec 16, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI) with special guests Kim Manis & Bogdan Crivat from the Fabric Product Team! Get your questions in the chat early as we don’t get to all of them.

This is also the last stream of 2023. It’s time to donate the money in the “It Depends” jar! We have also listed this stream as a fundraiser stream for St. Jude Children’s Hospital. The mission of St. Jude Children’s Research Hospital is to advance cures, and means of prevention, for pediatric catastrophic diseases through research and treatment. Learn Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE w/ Kim Manis & Bogdan Crivat (Dec 16, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 9, 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 9, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 11, 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 (Nov 11, 2023)” →

Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn about how PivotTables cannot include upper limit when grouping number data with decimals. COUNTIFS and FREQUNCY Functions do include upper limits when grouping numbers into upper and lower limit categories.
Topics:
1. (00:00) Introduction
2. (00:06) PivotTable
3. (01:45) COUNTIFS
4. (02:49) Text Labels for Formula Report
5. (03:25) Find Feature to create labels for PivotTable
6. (03:56) FREQUENCY Array Function
7. (05:15) Summary
8. (05:30) Closing, Video Links

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

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

Power BI Tips: Excluding Top N with DAX

Posted on by Annie D

📢 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 – https://guyinacube.com/tools/

#PowerBI #DAX #GuyInACube