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

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

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

In last month’s Business Intelligence Summit, one of our speakers, Greg Deckler, presented about DAX counterculture wherein he talked about alternative uses on DAX. One of his key topics is all about the DAX function CALCULATE and why you should avoid using it especially if you’re new to DAX. In this tutorial, Greg is going to pick up on that discussion and delve into another Microsoft quick measure —Average Per Category.

***** Video Details *****
00:00 Introduction
01:54 The goal
02:07 Data model
02:55 Average per Category measure
06:00 Better Average per Category measure

***** Related Links *****
Better Average per Category – https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Average-per-Category/td-p/2758871
—

***** Continue reading “How To Get Better Average Per Category In DAX – Why You Should Not Use CALCULATE” →

The ALL function is particularly useful for removing filters and creating calculations on all the rows in a table. In this video, Sam shows how you can use the ALL function in Power BI with DAX with specific use cases.

***** Video Details *****
00:00 Introduction
01:05 Total sales of each customer
02:04 ALL sales
03:45 Replacing customer names with customer index
04:01 Referencing the entire table instead of column name
04:32 Percent of sales

***** 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 Continue reading “How To Use The ALL Function In Power BI And DAX [2022 Update]” →