Month: July 2022

How To Avoid Errors When Integrating Python Scripts In Power BI

Posted on by Annie D

In this video, Gaelim is going to demonstrate how you can avoid and solve errors when integrating Python scripts in your Power BI reports that are usually caused by some discrepancies in the Python environment and Power BI.

***** Video Details *****
00:00 Introduction
00:51 Options
01:13 Anaconda prompt
01:27 Python environment
02:00 Activating an environment
03:35 Creating a new environment
05:05 Installed packages
06:11 Installing a package
07:06 Launching an instance

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – <a Continue reading “How To Avoid Errors When Integrating Python Scripts In Power BI” →

Excel Formulas & Functions, PivotTables, Slicers & Charts – M365 Excel Video 2

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/02-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/02-M365ExcelClass.pdf
Comprehensive introduction to what Excel can do with Worksheet Formulas & Functions, PivotTables, Slicers, Charts and Excel Tables. This is M365 Excel Video 2.
Topics in video:
1. (00:00) Introduction
2. (00:56) Calculations in Excel
3. (02:25) Worksheet formulas definition and elements
4. (03:00) Example of Number Formula
5. (05:07) ROUND function
6. (09:18) How Number Formatting Interacts with Numbers and Formulas
7. (13:22) Example of Text Formula
8. (14:01) TEXTBEFORE function
9. (18:02) FORMULATEXT function
10. (19:02) IFNA function
11. (19:37) Show Nothing with a Formula using Zero Length Text String “”
12. (20:44) Example of Logical Formula using Continue reading “Excel Formulas & Functions, PivotTables, Slicers & Charts – M365 Excel Video 2” →

Validation BUG & More on Excel Shapes & VBA

Posted on by Annie D

Episode 2493
Why is the drop-down arrow not showing up when I create the Excel validation with VBA? It appears after I click Save. But I don’t want to save since these numbers are a temporary scenario and I plan on closing without saving.
Also: Using the Selection Pane in Excel to see all shape names
How Excel names shapes.
Why Excel renames Shapes during workbook copy
How to use VBA to detect which shape was selected.

Table of Contents
(0:00) Bug with Shapes in VBA
(0:31) Excel Validation drop-down arrow missing
(3:05) VBA code to delete shapes
(4:07) How Excel Names Shapes
(4:44) Selection Pane in Excel
(5:47) First Validation arrow Continue reading “Validation BUG & More on Excel Shapes & VBA” →

Enterprise DNA Challenge 20 – Judging Of Entries

Posted on by Annie D

Another edition of the Enterprise DNA Challenge has just wrapped up, and we’re so amazed by the sheer number of brilliant entries we have received! What a remarkable Challenge 20 it has been:

✓ Over 1,000 members in EDNA Challenges group in LinkedIn
✓ 47 final entries
✓ Over 211 analysis pages
✓ More than 600+ DAX measures
✓ Over 400+ navigation buttons, bookmarks, and tooltips

In this video, watch as our panel of judges consisted by Enterprise DNA Experts Brian Julius, Federico Pastor, Tim Weinzapfel and Paul Gerber go through and share their insights on the top 3 nominees per category as well as the Continue reading “Enterprise DNA Challenge 20 – Judging Of Entries” →

How I learn things

Posted on by Annie D

People have asked how we know what we know about Power BI and other items like Video Editing or YouTube. In this video, I let you in on my process!

📢 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 – <a Continue reading “How I learn things” →

Power BI Self-service Implementation: What Is Required to Ensure Success With Lars Schreiber

Posted on by Annie D

If you are working in the BI & Analytics field, you may have heard of self-service business intelligence (BI). In fact, you might also have a strong interest in implementing Self-service BI into your organization.

Self-service BI systems like Power BI allow you to put your data models into the hands of many users and let them analyze their own data without the involvement of developers. While every organization is different, there are some general guidelines that can ensure a successful implementation.

Lars Schreiber is an independent consultant for Self-Service BI with Microsoft Power BI. He has more than 11 years Continue reading “Power BI Self-service Implementation: What Is Required to Ensure Success With Lars Schreiber” →

Dynamic X and Y Axis in Power BI visuals? Yes please!

Posted on by Annie D

Have you wanted both dynamic X and Y axis within a Power BI visual? Patrick shows you how you can use Field Parameters to accomplish it!

Let report readers use field parameters to change visuals
https://docs.microsoft.com/power-bi/create-reports/power-bi-field-parameters

📢 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***
🛠 Continue reading “Dynamic X and Y Axis in Power BI visuals? Yes please!” →

🔴 Power BI tips from the Pros – LIVE (July 16, 2022) (Member Chat 2nd Half)

Posted on by Annie D

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

💥 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 take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (July 16, 2022) (Member Chat 2nd Half)” →

How To Put Thick Borders On Matrix Visualizations In Power BI

Posted on by Annie D

The matrix visual is a great data visualization technique when you need to to display categorical variables with text labels in your Power BI report, while being able to specify multiple variables in rows and columns. In this video, Greg is going to share some formatting tricks for matrix visualizations.

***** Video Details *****
00:00 Introduction
00:34 Data model
01:37 The dilemma
04:34 Customizing the visual

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – <a href="http://www.enterprisedna.co/power-bi-resources" Continue reading “How To Put Thick Borders On Matrix Visualizations In Power BI” →

Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1794.xlsx
Learn how to lookup cell address to maximum value with 12 different formulas.
Topics:
1. (00:00) Introduction
2. (00:15) Conditional Formatting for Biggest Value.
3. (00:36) Formula #1 with the functions: MAX, ADDRESS, XMATCH, ROW and COLUMN.
4. (01:56) Formula #2 with the functions: MAX, ADDRESS, XMATCH and COLUMN.
5. (02:24) Formula #3 with the functions: XLOOKUP, MAX and CELL.
6. (03:34) Formula #4 with the functions: LET, XLOOKUP, MAX, ADDRESS, ROW and COLUMN.
7. (03:56) Formula #5 with the functions: LET, INDEX, XMATCH, MAX, ADDRESS, ROW and COLUMN.
8. (04:06) Formulas #6-10 with the functions: Old School Formulas that will work Continue reading “Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794” →

An Introduction to Deneb: Declarative Visualization In Power BI – New Course!

Posted on by Annie D

Deneb is a custom visual for Power BI, which allows the use of declarative JSON syntax of the Vega or Vega-Lite languages to build custom data visualizations, without having the need to learn web development. 

In this video, Brian chats with our resident Deneb expert, Greg Philps, as they introduce and give an overview on our newly released course titled “An Introduction to Deneb: Declarative Visualization in Power BI”. Watch to know what this new course is all about, how to make the best out of it, the major advantages of Deneb, and more!

Know more about the An Introduction to Deneb: Continue reading “An Introduction to Deneb: Declarative Visualization In Power BI – New Course!” →

How To Access Excel F Keys on Laptop Computer – Huge List of Function Keys too – 365 MECS 01 Part 2

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/01-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/01-M365ExcelClass.pdf
Learn how to access the F Keys (Function Keys) on a laptop computer. This tip comes from Radoslaw at YouTube. Also see a list of useful F Keys in Excel.
Topics in video:
1. (00:00) MECS Song
2. (00:08) Introduction
3. (00:24) Radoslaw gives helpful tip
4. (00:43) Keyboard toggle to activate or deavtivate F Keys on Laptop: Fx + Esc or Fn + Esc
5. (01:3) List of Functions Keys (F Keys)
6. (01:44) Summary and Closing

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. Continue reading “How To Access Excel F Keys on Laptop Computer – Huge List of Function Keys too – 365 MECS 01 Part 2” →