Summary
Keywords
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn: 1) (00:19) Introduction to what we did in last two videos and what we will do in this video: Frequency Distributions & Histograms with different methods. 2) (01:11) Use PivotTable to create Frequency Distribution by Grouping our Revenue Field 3) (02:53) Discussion of difference in Frequency Counts when you use a PivotTable as compared to the FREQUENCY Array Function and Data Analysis Histogram feature. 4) (05:10) Use “Show Values As”, “Running Total In” feature to calculate Cumulative Frequency Total 5) (06:17) Use “Show Values As”, “% Running Total In” feature to calculate % Cumulative Frequency Total 6) (06:47) Compare creating charts with PivotTable as compared to the FREQUENCY Array Function and Data Analysis Histogram feature. 7) (08:13) Create Histogram and % Cumulative Frequency Line Chart from PivotTable. See many important tricks to get the chart to do what you want. 8) (11:05) Why the PivotTable Rules over other methods for creating Frequency Distributions for Continuous Quantitative Data such as FREQUENCY Array Function and Data Analysis Histogram feature. The reason is that we can do “on the fly” Data Analysis much more easily when you add a Slicer and filter the PivotTable and Chart. 9) (11:56) Adding Criteria or Filters to a PivotTable and Chart with the Slicer feature. 10) (12:33) Filtering PivotTable and Chart with the Slicer feature for “on the fly” Data Analysis is why PivotTables Rule!!! 11) (13:17) After Filtering, we see that we should change the chart to better fit our Data Analysis Reporting needs. Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
