Month: February 2024

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

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

Posted on by Annie D

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

Posted on by Annie D

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