Discover the depths of Advanced Data Analysis (ADA) by OpenAI. Dive into a structured learning experience that fuses cutting-edge research with hands-on exercises to provide a comprehensive understanding of Advanced Data Analysis.
Category: Business
Still In Hunt For MLS Supporters Shield As Of Sept 22 2023 Using Excel – Episode 2626 #mls
Microsoft Excel Tutorial: Modeling the rest of the MLS Season 100,000 times.
Which teams are still in the hunt for the MLS Supporters Shield?
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
Editing your Direct Lake Datasets from Tabular Editor? Yes please!
Wanting to edit your Direct Lake Power BI Dataset in Microsoft Fabric? Now writing via the XMLA endpoint is supported. Patrick shows you how to use tools to modify.
Announcing XMLA Write support for Direct Lake datasets
https://blog.fabric.microsoft.com/en-us/blog/announcing-xmla-write-support-for-direct-lake-datasets?ft=All
Dataset connectivity with the XMLA endpoint
https://learn.microsoft.com/power-bi/enterprise/service-premium-connect-tools
📢 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
— <a href="http://www.facebook.com/guyinacube" Continue reading “Editing your Direct Lake Datasets from Tabular Editor? Yes please!”
Using Microsoft Fabric Workspaces (Power BI and more!)
Workspaces are a way to organize and manage content within Microsoft Fabric. This includes Power BI content. Adam walks you through what Workspaces are all about and different options available.
Workspaces
https://learn.microsoft.com/fabric/get-started/workspaces
Roles in workspaces in Microsoft Fabric
https://learn.microsoft.com/fabric/get-started/roles-workspaces
Workspaces in Power BI
https://learn.microsoft.com/power-bi/collaborate-share/service-new-workspaces
📢 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
— <a href="http://www.facebook.com/guyinacube" Continue reading “Using Microsoft Fabric Workspaces (Power BI and more!)”
Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625
Microsoft Excel Tutorial: Microsoft Labs in Cambridge releases a great Python editor for Excel.
Just 27 days after Python preview appears in Excel, Microsoft has added a dramatically better Python editor.
To download the workbook from today: https://www.mrexcel.com/youtube/UKpmNAMjygg/
This new editor in the task pane offers AutoComplete, Intellisense, and automatic code coloring. Take a walkthrough the editor in today’s video.
#excel
#microsoft
#microsoftlabs
#microsoftexcel
#exceltricks
#excelpython
#microsoft365
#walkthrough
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
Table of Contents
(0:00) Python Editor Added to Excel
(0:10) Free Silo Photos
(0:20) Theories on backstory
(0:59) Get Add-Ins moving from Insert to Home tab
(1:22) Update Excel Labs add-in twice
(1:49) Open Excel Labs & Continue reading “Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625”
Deep Dive Into A Telco Company Dataset – Using Advanced Data Analysis (ADA) from Open AI
Join me as I dive into the powerful capabilities of Advanced Data Analysis (ADA), formerly Code Interpreter, a cutting-edge tool designed for advanced data analytics. Whether you’re a seasoned data professional or just dipping your toes into the world of statistics and algorithms, Ada is here to redefine the game.
🔍 What to Expect:
– The transformative power of ADA’s automated suggestions.
– Bridging the gap between ADA and tools like Power BI.
– Anomaly detection, even for the untrained eye.
– The rising significance of Python and why understanding its structure is more important than ever.
– The depth of analysis ADA offers and how Continue reading “Deep Dive Into A Telco Company Dataset – Using Advanced Data Analysis (ADA) from Open AI”
Excel – Oracle Sending Dates as Text MMM-YY Episode 2624 #excel #pivot_table #excelhacks
Microsoft Excel Tutorial: Sorting months in a pivot table when they are alphabetic.
I met people who are downloading data from Oracle through Analysis Services. Their dates are coming in as text in the format of Sep-20 for September 2020. When they create pivot tables, the months are alphabetic instead of sequential.
To download the workbook from today: https://www.mrexcel.com/youtube/BpgjOMlh39E/
There are two ways to solve it:
1) A convolunted method from Sam Radakovitz that you only have to do once
2) A simple method that you will have to do 1000 times a year.
In this episode, I show Sam Rad’s method of Continue reading “Excel – Oracle Sending Dates as Text MMM-YY Episode 2624 #excel #pivot_table #excelhacks”
Excel Hack Use Filter Search Box to Remove Items from Filter! – Episode 2623 #excel #excelhacks
Microsoft Excel Tutorial: How to use Excel’s Filter Search Box to remove items from Filter.
Melvin from Orlando shared a great Excel trick with me during yesterday’s live Power Excel seminar in Daytona Beach.
To download the workbook from today: https://www.mrexcel.com/youtube/Od5IwswzWnI/
We all know you can use the Filter drop-down Search Box to find all cells that contain Apple. But what if you want everything that does not contain Apple? Rather than use the old Text Filters for Does Not Contain, you can use this great trick from Melvin:
1. Search for Apple
2. Uncheck Select All Items
3. Check Add Current Continue reading “Excel Hack Use Filter Search Box to Remove Items from Filter! – Episode 2623 #excel #excelhacks”
My AI and Data Analytics Inflection Point Explained! #codeinterpreter #machinelearning
Diving deep into AI’s transformative power, I share unexpected insights from my personal exploration. Join me as I unveil the revelations from my AI journey!
Modern Analytics Freestyle
Join us for an enlightening virtual event that delves into the transformative power of modern data analysis. Discover how today’s data analysts, equipped with the latest AI tools, can significantly enhance and streamline your workflow. As we collaboratively navigate a real-world data challenge, we’ll unveil a plethora of innovative data analysis techniques that promise to redefine the boundaries of what you believed was possible. Elevate your analytical prowess and extend your capabilities beyond what you thought achievable just a year ago. Don’t miss this opportunity to be at the forefront of the data revolution!
This event will take place on Enterprise Continue reading “Modern Analytics Freestyle”
Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838.
Download Excel File: https://excelisfun.net/files/EMT1838.xlsx
Learn about how to calculate commission for each sales rep who sell multiple products that each have a different commission rate. This is a complicated Lookup Multiplying calculation that is made easy with Microsoft 365 Excel.
Topics:
1. (00:00) Introduction
2. (00:26) Commission Rate Data Table Setup
3. (00:53) Old School Formulas and manual Method
4. (01:09) FILTER, XLOOKUP and SUM Method
5. (03:04) LAMBDA and BYROW Method
6. (04:42) Summary
7. (05:04) Closing, Video Links
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula #commission
Excel Sum Across Sheets When Rows Do Not Line Up – Episode 2622
Microsoft Excel Tutorial: Sum across worksheets when rows do not line up?
Today’s question from Rebaz on podcast 1984 – Excel Sum Across Worksheets: “if we have different cell in different sheet, how can I Sum?”
Download the workbook from today: https://www.mrexcel.com/youtube/UO11Ase1_Ys/
This video shows you an easy way to build a 3-D reference in Excel, also known as a spearing formula. Excel functions include SUM, XLOOKUP, FILTER, SUMIFS, TEXTJOIN, TEXTSPLIT, SUMPRODUCT, Helper Arrays, LET, Python in Excel, and VSTACK.
Table of Contents
(0:00) Problem: Adding Across Sheets that are not lined up
(0:43) How to build a 3-D Reference
(1:19) Does XLOOKUP work Continue reading “Excel Sum Across Sheets When Rows Do Not Line Up – Episode 2622”