Month: August 2023

Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function?

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1835-1837.xlsx
Learn about how to lookup a row using CHOOSECOLS, INDEX, FILTER or XLOOKUP functions.
Topics:
1. (00:00) Introduction
2. (00:19) Viewer Question
3. (00:38) CHOOSEROWS and XMATCH
4. (01:23) XLOOKUP
5. (02:06) INDEX and XMATCH
6. (03:00) FILTER
7. (03:37) See that all these methods work in SUM function to add sales for the month
8. (04:01) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula

Get your measures organized in Power BI

Posted on by Annie D

As you make more measures in your Power BI Dataset, it can get hard to find the one you need. Sure you can use search… But you can also organize your measures to make it easier to find them. Patrick shows you how!

📢 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
— <a Continue reading “Get your measures organized in Power BI” →

Enhancing Analytics with AI: A Deep Dive into Power BI, Excel, and Code Interpreter

Posted on by Annie D

In this video, we explore the world of analytics tools, comparing traditional platforms like Power BI and Excel with the cutting-edge capabilities of AI using Code Interpreter. Discover the power of combining these tools to unlock deeper insights, streamline your analysis, and get AI-assisted recommendations that elevate your reporting game. By the end, you’ll understand the true potential of an AI-assisted analytics workflow and how to harness it for yourself.

#Analytics #PowerBI #Excel #CodeInterpreter #AIAssistedAnalytics #DataVisualization #DataInsights #DataStorytelling #AIRecommendations #AnalyticalToolsComparison

Want to dive deeper into AI-enhanced analytics? Subscribe now for more tutorials, comparisons, and tips to revolutionize your data game.

www.enterprisedna.co

Get and use Python Libraries within Microsoft Fabric

Posted on by Annie D

Sometimes you need python libraries that aren’t present by default in Microsoft Fabric. Patrick walks you through how to manage your python libraries, so they are available when you need them.

Manage Python libraries in Microsoft Fabric
https://learn.microsoft.com/fabric/data-science/python-guide/python-library-management

wget 3.2
https://pypi.org/project/wget/

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Get and use Python Libraries within Microsoft Fabric” →

Python In Excel – Getting Started – 2614

Posted on by Annie D

Microsoft Excel Tutorial – Using Python in Excel.

Today, August 22, 2023, Microsoft will release a preview of Python in Excel. It is a big day for me… I’ve been trying unsuccessfully to learn Python for ten years. Once Microsoft added it to Excel, I finally have some cool things working.

To download this workbook: https://www.mrexcel.com/youtube/KIhDQDtvZPg/

In this video: a getting started with Python in Excel tutorial.
How to open the Python editor in Excel
Ctrl+Enter versus Enter in the Python Editor in Excel
Returning a Value or a Python Object
Referring to an Excel range in Python
Using Variables in Python in Excel
Plotting Continue reading “Python In Excel – Getting Started – 2614” →

Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1835-1837.xlsx
Learn about how to lookup a column using CHOOSECOLS, INDEX or XLOOKUP functions.
Topics:
1. (00:00) Introduction
2. (00:10) CHOOSECOLS and XMATCH
3. (01:10) XLOOKUP
4. (01:43) INDEX and XMATCH
5. (03:20) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula

Saying goodbye…

Posted on by Annie D

It’s time to say goodbye and move on.

📢 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/

#GuyInACube

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Aug 19, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric including Power BI!

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 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 to Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Aug 19, 2023) (Member Chat 2nd Half)” →

Excel Stale Value Formatting – Episode 2613

Posted on by Annie D

Microsoft Excel Tutorial: Which values are not yet calculated in Manual Calculation Mode?

In August 2023, Microsoft is adding a new feature to Microsoft 365 Excel. The Format Stale Values will alert you when a cell needs to be recalculated. This is an application-level setting. When you turn it on, it will work for all open workbooks.

To download this workbook: https://www.mrexcel.com/youtube/LPyYLqq72wI/

Table of Contents
(0:00) Excel Stale Value Formatting
(0:23) Excel Manual Calculation Mode
(0:36) Stale Value Markers
(0:56) On-Grid UI choices
(1:09) Customize Stale Value Formatting?
(1:47) Why are new values stale?
(3:14) Stale Value in Automatic Mode
(3:40) Excel interrupt calculation with Esc
(4:25) What’s your Continue reading “Excel Stale Value Formatting – Episode 2613” →

Using Figma to wireframe your Power BI reports

Posted on by Annie D

You care about how your Power BI reports look. Sekou joins us to explore using Figma to wireframe your report design and get that look you want before doing all the hard work in Power BI Desktop!

Figma
https://www.figma.com/

Connect with Sekou Tyler
https://www.youtube.com/@SQLSekou
https://www.linkedin.com/in/sekoutyler/
https://twitter.com/sqlsekou
https://lovelytics.com/power-bi/

📢 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
— <a href="http://twitter.com/awsaxton" Continue reading “Using Figma to wireframe your Power BI reports” →

Enabling Power BI Paginated Report Drill!

Posted on by Annie D

Power BI paginated reports support drillthrough! Patrick walks you through how to configure the reports within Report Builder to get them working.

Drillthrough reports in a paginated report (Power BI Report Builder)
https://learn.microsoft.com/power-bi/paginated-reports/report-design/drillthrough-reports-report-builder

📢 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 Continue reading “Enabling Power BI Paginated Report Drill!” →

Is Data Wrangler the Power Query of Python?

Posted on by Annie D

Have you tried Data Wrangler within Microsoft Fabric or Visual Studio Code? It’s a great way to start cleaning your data and have it write your python code for you! Really getting the Power Query vibes and we love it!

How to accelerate data prep with Data Wrangler in Microsoft Fabric
https://learn.microsoft.com/fabric/data-science/data-wrangler

Introducing the Data Wrangler extension for Visual Studio Code
https://devblogs.microsoft.com/python/data-wrangler-release/

Connect with Eren Orbey:
https://www.linkedin.com/in/orbey/
https://twitter.com/erenorbey

📢 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 Continue reading “Is Data Wrangler the Power Query of Python?” →