Join me as I dive into the powerful features of the DAX query view in Power BI, showcasing how it revolutionizes data discovery and insights. Learn how to efficiently explore data sets and enhance your understanding using table functions.
Examples of tables functions you could use.
FILTER
TOPN
ADDCOLUMNS
CALCULATETABLE
VALUES
SUMMARIZE
and much more!
In the video, I dive into the differences between ChatGPT and Advanced Data Analysis within ChatGPT, comparing them to Power BI. I highlight the potential benefits of using both tools despite challenges, showcasing how they can complement each other. I demonstrate creating a data set in ChatGPT, discuss the future of data analysis, and compare the analysis process in ChatGPT and Power BI.
00:00 Introduction
05:48 Data Exploration in ChatGPT
11:07 AI Tools Usage
14:22 Comparison Analysis in Power BI
18:11 Data Verification
Thanks for the amazing 16.25 years here at YouTube!!! 16.25 more to go.
Go Team!!!
Download files: https://excelisfun.net/files/DAMEwithMPT07.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about the guidelines for how to build effective dashboards. See three examples in Power BI.
Topics:
1. (00:00) Introduction
2. (00:27) Guidelines for how to build effective dashboards
3. (09:03) Files to build Three Dashboards.
4. (09:35) Dashboard #1: Average Daily & Monthly Metrics across various attributes
5. (19:33) Dashboard #2: Grade Analysis Dashboard
6. (26:42) Dashboard #3: YOY Sales Dashboard
7. (31:27) Summary
8. (31:40) Conclusion
#dashboard #powerbi #powerbidesktop #visualization
Want to get started with Power BI but not sure how? Start by installing Power BI Desktop! Adam walks you through how to install it and some things to do immediately after!
📢 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 “Install Power BI Desktop the RIGHT WAY! (2024)”
Microsoft Excel Tutorial: Make workbook calculate faster by toggling off the ForceFullCalculation setting.
Welcome back to MrExcel! Today, I’ve got an incredible tip that can make your Excel workbooks run dramatically faster. Have you ever heard of ActiveWorkbook.ForceFullCalculation = False? Probably not, because it’s a setting that’s rarely documented. But it can make a huge difference in calculation speed, as shown in this example sent by Matt from Chicago, a member of the MrExcel message board.
Matt provided us with a file containing 7,000 rows and 27 columns, which is just a fraction of the size of his client’s actual files. With Continue reading “Excel Slow Workbook Speeds Up Instantly With ForceFullCalculation Toggled Off – 2644”
Do you have on-premises data like a SQL Server? Want to leverage a pipeline within Data Factory in Microsoft Fabric? Patrick shows you have to get going and set that up!
How to access on-premises data sources in Data Factory for Microsoft Fabric
https://learn.microsoft.com/fabric/data-factory/how-to-access-on-premises-data
📢 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
— Continue reading “On-premises data with Data Factory in Microsoft Fabric”
Use Enterprise DNA examples and Google Collab to create your first simple machine learning model. It’s not hard at all
Summary
In this video, I discuss the OpenAI API and how it has amplified what we can do with AI tools. I share my belief that anyone can learn Python quickly by following the steps in the video. I also highlight the benefits of on-demand learning and provide examples of using libraries like pandas and NumPy. No specific action is requested from the viewers, but the video aims to inspire and educate them on the possibilities of AI and Python.
00:00 Introduction
03:25 Utilizing Code and Learning Python
07:14 Working with Pandas
12:03 Data Manipulation with Pandas
14:20 NumPy and Matplotlib
19:48 Exploring More Python Features
24:03 Troubleshooting Continue reading “How To Learn Python Fast As A Beginner Today”
Download files: https://excelisfun.net/files/DAMEwithMPT06.zip, pdf notes: https://excelisfun.net/files/06-DAMEMPT.pdf
This video teaches how the fundamentals of Columnar Database, DAX Calculated Columns, DAX Measures, Row Context, Filter Content, Context Transition, Overwrite Operation, DAX X Iterator functions, DAX CALCULATE function and much more!
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about
This video covers.
1. (00:00:00) Introduction and video topics
2. (00:00:25) Topics in Video
3. (00:01:49) Why we use DAX, M Code & Worksheet Formulas: What makes Each Special?
4. (00:05:30) Review data, data structure, Excel Continue reading “DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class”
Microsoft Excel Tutorial: Learning the Building Blocks for RegEx in Excel
Learn the basic building blocks of RegEx in Excel.
To download the RegEx Cheat Sheet and workbook from today: https://www.mrexcel.com/youtube/fbHQgDM0P1E/
Welcome back to MrExcel’s YouTube channel! In this video, we’ll dive into the building blocks for mastering Regular Expressions (RegEx) and their integration in Excel. If you find this video helpful, don’t forget to click the Like button below – it helps us reach more viewers. We’ve got over 2,500 videos on various Excel topics, so there’s plenty to explore!
Our focus today is on RegEx, specifically the new functions Continue reading “Excel – RegEx Building Blocks – 2643”
Microsoft Excel Tutorial: Excel Adds RegEx Support for Pattern Matching in Excel.
🎥 Unlocking the Power of RegEx in Excel: New Features Explained! 📊
Hey Excel enthusiasts! 🌟 In today’s video, we’re diving into an exciting new feature: RegEx support in Excel for pattern matching. If you enjoy exploring new Excel functionalities, this is a must-watch! Don’t forget to Like this video to help it reach more people. 👍
🔥 What’s New? 🔥
Excel has introduced three powerful RegEx functions: RegExTest, RegExReplace, and RegExExtract. These functions are set to revolutionize how we handle data patterns. Plus, there are updates to XLOOKUP and XMATCH functions Continue reading “Excel RegEx Support For Pattern Matching – Episode 2642”