Month: September 2023

Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627

Posted on by Annie D

Microsoft Excel Tutorial: Calculate Average Cost per Year in Excel.

Derek has a fleet of vehicles and a list of all repairs made in the last 20 years. He wants to figure out how the annual repair and maintenance costs change as the vehicle ages.

In this video, MrExcel discusses how to calculate annual repair costs based on the age of a vehicle. He provides a data set of repairs made on a fleet of vehicles and explains how to determine the first date each vehicle was placed in service. He suggests using an approximation for vehicles without records by subtracting Continue reading “Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627” →

Mastering Power BI Desktop: A Deep Dive into the Pane Switcher

Posted on by Annie D

On-Object Editing has been out for a bit in Power BI Desktop, and it came with a cool pane switcher! Adam walks through how to use the pane switcher and talks about some recent updates.

Use on-object interaction with visuals in your report (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube

Using WORKOUTS to Master Data Skills

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Editing your Direct Lake Datasets from Tabular Editor? Yes please!

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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