Categorical variables measure “what kind of something,” whether it’s a customer’s buying state, country of origin or something else. To summarize these types of variables, we can count the frequencies of each type, comparing quantities in frequency tables. But sometimes it helps to compare these values as percentages, and that’s where proportion tables come in.
In this video, George shows how to do both in Excel with the help of PivotTables, along with the pros and cons of comparing raw quantities of categories versus their proportions.
***** Video Details *****
00:00 Introduction
00:38 Categorical variables
02:25 Date set
04:00 Pivot table
04:32 One-way frequency table
05:23 Two-way frequency table
10:24 Recap
***** 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://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial