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.
Blog
Using WORKOUTS to Master Data Skills
An outline of this event:
In the rapidly evolving field of data analytics, it is crucial for professionals to continuously upgrade their data skills to stay relevant and competitive. WORKOUTS is an innovative approach that combines hands-on exercises, practical applications, and collaborative learning to help data practitioners master data skills effectively.
In this virtual event, participants will engage in interactive and immersive learning experiences through a series of WORKOUTS sessions designed to enhance their data skills in a practical and engaging manner. The event will cover various data-related topics, tools, and techniques, and provide participants with opportunities to apply their learning in Continue reading “Using WORKOUTS to Master Data Skills”
How AI Is Changing Everything For Data Professionals
An outline of this event:
AI has emerged as a game-changer, transforming the way organizations analyze, interpret, and leverage data to drive insights, make informed decisions, and gain a competitive edge. Join us as we delve into the various aspects of AI and its profound implications for data professionals.
Whether you’re a data scientist, data analyst, or data engineer, this webinar will provide valuable insights and practical examples of how AI is changing the landscape for data professionals.
Details of what you will learn in this event:
– Highlighting the benefits and challenges of AI adoption in data-related work
– Understanding the role of AI Continue reading “How AI Is Changing Everything For Data Professionals”
Using ChatGPT To Supercharge Power BI Development
Leverage the power of ChatGPT to enhance your Power BI development process.
Details of what you will learn in this event series:
– Understand the potential of ChatGPT in enhancing Power BI development
– Learn how to integrate ChatGPT into your Power BI workflow
– Discover real-life examples of how ChatGPT can automate and streamline data analysis tasks
– Gain insights into best practices and tips for effective usage
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!