Summary
Keywords
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about the Excel Data Analysis Features: Sort, Filter, Pivot Tables: 1) (00:13) Intro 2) (00:30) Concept of “How to sort on 2 columns” 3) (01:20) Sort Dialog Box Method 4) (02:36) Sort Buttons Method 5) (03:50) Filter to “Query a Proper Data Set” to Extract records based on two conditions/criteria (AND Logical Test / AND Criteria) 6) (07:02) Pivot Table Notes 7) (07:22) Basic PivotTable with Proper Report Layout and Number Formatting 8) (09:31) PivotTable to Count Sales: Frequency Table 9) (10:29) PivotTable to Count a Field with a Categorical Data Type (Text Data Type in Excel) 10) (11:38) What happens if Number Data Type Field has an Empty Cell. 11) (12:44) Grouping Dates in a PivotTable 12) (14:13) What happens if there is an inconsistent Data Type when Grouping in a PivotTable 13) (16:00) Understanding how the Grouping Feature treats Numbers (Continuous Quantitative Data) that have decimals and Numbers (Continuous Quantitative Data) that do not have decimals. 14) (16:48) Grouping Decimal Numbers example: Ambiguous Labels 15) (18:43) Two Methods for fixing Ambiguous Labels in a PivotTable: Replace feature or new label in PivotTable 16) (20:13) Grouping Numbers with no Decimals (Whole Number / Integer): Nonambiguous labels 17) (21:11) Conclusion 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.
