Month: September 2022

Answering your questions about the new App Experience!

Posted on by Annie D

So many questions about the new Power BI App experience! Going through a few of the themes that came out of last week’s video to get you some answers! What other questions do you have that weren’t covered?

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

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

#PowerBI #Apps #GuyInACube

Excel VBA User Defined Function To Generate A Dynamic Array – 2516

Posted on by Annie D

Can Excel VBA return a dynamic array from a user defined function to the grid?
Can you repeat each cell in column A based on the number in column B?

Check out the amazing answers from Smozgur and XLLambda here:
https://www.mrexcel.com/board/threads/repeatbynumber.1216836/

Table of Contents
(0:00) Two titles
(1:11) Using VBA
(2:05) How many cells to return
(2:50) Building the array
(3:22) Return array to grid
(4:00) Using Hash array operator

Design Psychology in Data Visualization with Thomas Watkins

Posted on by Annie D

Do you know what design psychology is? Thomas Watkins describes it as taking what we know about psychology and applying it to technology. Incorporating our knowledge of sensory perception and cognition into the product in order to ensure that it resonates with users.

In this episode of the podcast, Sam McKay speaks with Thomas Watkins about design psychology and how it can be incorporated into techniques and frameworks in Power BI.

Thomas Watkins is a thought leader, speaker, and industry practitioner located in Houston TX. He is a life-long learner who has a passion for bringing greater clarity to the Continue reading “Design Psychology in Data Visualization with Thomas Watkins” →

Storytelling with Power BI and PowerPoint

Posted on by Annie D

Give up those static images of your reports in PowerPoint! Learn how to integrate your Power BI report to help tell your story directly within PowerPoint!

Tell a story with your data. Announcing the all-new Power BI integration for PowerPoint
https://powerbi.microsoft.com/blog/tell-a-story-with-your-data-announcing-the-all-new-power-bi-integration-for-powerpoint/

About Power BI in PowerPoint
https://docs.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-about

📢 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
— Continue reading “Storytelling with Power BI and PowerPoint” →

Excel Insert Blank Row After Every Two Data Rows #Shorts

Posted on by Annie D

LC has 4000 rows of Excel data. After every two rows, he wants to insert a blank row. How can he quickly insert 2000 blank rows in the data? My solution today involves a formula to create alternating cells with text and numbers. Then Home, Find & Select, Go To Special. Select all Formula cells that result in Text. This selects every other row. You can then Insert Sheet Rows and you are done in less than 60 seconds.

How To Create Complex Visuals In Power BI With A Single Line Of Code Using R

Posted on by Annie D

In today’s video, Brian continues his discussion of “speed build” techniques for creating great-looking custom visuals incredibly quickly.

While the first video focused on SVG visuals, the technique discussed today involves the use of R visuals, specifically the GGPUBR package, which can be used to create complex visuals difficult to do in any other way, using just a single simple line of R code.

***** Video Details *****
00:00 Introduction
02:29 R packages
04:41 Data set
06:25 Box plot 1
11:18 Box plot 2
11:58 Histogram 1
13:20 Histogram 2
13:57 Histogram 23
14:44 Q-Q plot

***** Related Links *****
How To Quickly Add Dynamic SVG Visuals To Your Power BI Continue reading “How To Create Complex Visuals In Power BI With A Single Line Of Code Using R” →

Excel FILTER To 2 conditions with LEFT #Shorts

Posted on by Annie D

Keith wants to use the Excel FILTER function to get all names where two conditions are true: Status is A and the Project does not start with 22-05. This video shows how to combine 2 conditions in an Excel FILTER formula.

excel filter function
why excel filter not working
excel can you filter columns
excel can you filter with LEFT
excel can you filter to two conditions

Talking DATA end to end with Buck Woody

Posted on by Annie D

Where does your data come from? What do you need to consider with your data? Buck Woody explored the world of data and how services like Azure Synapse Analytics and Power BI can help you in your journey!

Connect with Buck:
https://twitter.com/BuckWoodyMSFT
https://www.linkedin.com/in/buckwoody/

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

#AzureSynapse #PowerBI #GuyInACube

Excel Dynamic Charts Based On Dynamic Arrays – 2515

Posted on by Annie D

Brand new in Excel Insiders Beta:
A chart can be based on an entire dynamic array in Excel.
In this first iteration, the chart has to point to the entire array. If you have columns in your array that you don’t want to chart, you should use =CHOOSECOLS to get a smaller subset of the array for charting.

The DATEADD Function – The Best and Most Versatile Time Intelligence Function In DAX [2022 Update]

Posted on by Annie D

In this tutorial, Sam demonstrates how you can use the DATEADD function — likely the most versatile time intelligence function in DAX. See how you can apply this to complete a huge range of time related calculations in your analysis.

***** Video Details *****
00:00 Introduction
00:54 Creating A Table With Total Sales Measure
01:36 Comparing Current Sales With Sales Last Year Using DATEADD Function
03:21 Other Time Periods That Can Be Used For Comparison
04:15 Calculating The Difference In Sales
05:24 Other Calculations To Branch Into Using DATEADD Function

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – rel=”nofollow”>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 – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #TimeIntelligence

Why We Love Dataflows In Power BI And Why You Should To

Posted on by Annie D

In this video, Sam is going to talk about something that he thinks has become a key feature in a successful organisation-wide implementation of Power BI — dataflows.

***** Video Details *****
00:00 Introduction
00:55 What is a dataflow
02:37 Creating dates table
05:14 Queries
08:14 Connecting dataflows to workspaces
08:54 Dedicated workspaces

***** 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 – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – rel=”nofollow”>https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial

🔴 Power Platform Conference LIVE!!! (Sept 21, 2022)

Posted on by Annie D

Join us live as we talk Power BI from the Power Platform Conference in Orlando, Florida! We are bound to have a special guest or two and hopefully a live audience.

Power Platform Conference: https://powerplatformconf.com

📢 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 “🔴 Power Platform Conference LIVE!!! (Sept 21, 2022)” →