Blog

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

Power BI Tips: Excluding Top N with DAX

📢 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

Use Source Control with your Power BI Report in Microsoft Fabric!

People have been asking for source control with Power BI reports for a long time. It’s here in Microsoft Fabric! Adam explores how to set this up.

Introduction to Git integration (preview)
https://learn.microsoft.com/fabric/cicd/git-integration/intro-to-git-integration

Manage a workspace with Git (preview)
https://learn.microsoft.com/fabric/cicd/git-integration/git-get-started?tabs=commit-to-git

Power BI Desktop projects (PREVIEW)
https://learn.microsoft.com/power-bi/developer/projects/projects-overview

Git
https://git-scm.com/

📢 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 Continue reading “Use Source Control with your Power BI Report in Microsoft Fabric!”

Using ChatGPT for Data Analytics

A unique opportunity for data professionals, data scientists, analysts, and business leaders to explore the applications of ChatGPT, a powerful language model developed by OpenAI, in the field of data analytics. This initiative will cover various aspects of using ChatGPT for data analytics, including text generation, data exploration, data visualization, and natural language processing (NLP) tasks.

Participants will gain insights into how ChatGPT can be leveraged to enhance their data analytics workflows and drive better decision-making.

#EnterpriseDNA #ai #artificialintelligence #chatgpt #dataanalysis #powerbi #powerbitutorial #chatgpt4 #dataanalytics #datatalks

Where in the world are Adam and Patrick?

Where in the world are Adam and Patrick over the next two months??? From Microsoft Fabric and Power BI to SQL, lots of learning will occur at some great conferences! Will you join us?

Fabric February (Sold Out)
Oslo, Norway
February 7-9, 2024
https://www.fabricfebruary.com/

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

Microsoft Fabric Community Conference
Las Vegas, NV
March 24-29, 2024
https://fabricconf.com
$100 Discount: CUBE100

📢 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: <a Continue reading “Where in the world are Adam and Patrick?”

Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn about how to count assembly line station times that are under 10 seconds using PivotTable, COUNTIFS function, GROUPBY function and Power Query.
Topics:
1. (00:00) Introduction
2. (00:06) Counting Assembly Line Post Times Less Than 10 Seconds
3. (00:43) COUNTIFS
4. (01:54) PivotTable with Helper Column
5. (02:57) GROUPBY Array Function
6. (04:05) Power Query
7. (05:22) Summary
8. (05:35) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #countifs #groupby #pivottable #powerquery #powerquerytutorial

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

Can you use Field Parameters with Direct Lake in Power BI?

We got the question if you could use Field Parameters with Direct Lake in Power BI. The answer is yes? However… Patrick tells more!

Let report readers use field parameters to change visuals (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-field-parameters

Direct Lake
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

Tabular Editor
https://tabulareditor.com/

Tabular Editor Script
https://github.com/tabulareditor/Tabulareditor3/issues/541

📢 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
Continue reading “Can you use Field Parameters with Direct Lake in Power BI?”

Join us at the Microsoft Fabric Community Conference! Get $100 OFF!

We’d love to see you at the Microsoft Fabric Community Conference! From the Power Hour to great workshops and tons of sessions, we want you to soak up all the knowledge. Also make connections with folks to grow your network. And, of course, come say HI (or better yet – YOOO) to Patrick and me!

Register today with discount code CUBE100 at https://fabricconf.com

Power BI Hidden Gems
https://fabricconf.com/#!/session/Power%20BI%20Hidden%20Gems/6320

Power Hour…After Dark!
https://fabricconf.com/#!/session/Power%20Hour…%20After%20Dark!/6379

Jason Himmelstein
https://twitter.com/jasehimm
https://www.linkedin.com/in/jasonhimmelstein/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next Continue reading “Join us at the Microsoft Fabric Community Conference! Get $100 OFF!”

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

Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850

Download Excel File: https://excelisfun.net/files/EMT1850.xlsx
Learn about how to count how many names in a column start with the letters a, b or c. Then make formula dynamic so it can check any set of letters.
Topics:
1. (00:00) Introduction
2. (00:05) Formula that uses LEFT, an array constant {“a”,”b”,”c”} and the SUM function
3. (00:38) Why the two arrays must be in opposite directions
4. (02:22) Dynamic formula linked to a list in the cells.
5. (02:43) Sumamry, Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #count #left #excelfunctions #countifs