ESA #4: PivotTable Grouping to Build Frequency Distributions & Power Query to Import CSV Data ESA #4: PivotTable Grouping to Build Frequency Distributions & Power Query to Import CSV Data Download Excel File: https:\/\/excelisfun.net\/files\/Ch01-ESA.xlsm Download CSV File: https:\/\/excelisfun.net\/files\/Ch01-ESA-AutoData.csv Learn about how to use Power Query to import and transform CSV File data<\/p>\n","protected":false},"author":3,"featured_media":2951,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/11\/af5lXnidEwA.jpg?fit=480%2C360&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-LA","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2950"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=2950"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2950\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2951"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nDownload Excel File: https:\/\/excelisfun.net\/files\/Ch01-ESA.xlsm<\/a>
\nDownload CSV File: https:\/\/excelisfun.net\/files\/Ch01-ESA-AutoData.csv<\/a>
\nLearn about how to use Power Query to import and transform CSV File data and use the PivotTable to create Frequency Distributions for Categorical and Quantitative Data.
\nTopics:
\n1. (00:00) Introduction to topics in video
\n2. (00:53) Tabular Reporting goals for this video: 4 Different Frequency Distributions
\n3. (01:31) PivotTable to create Frequency Distribution from Nominal Data that is located in the worksheet
\n4. (02:52) What is the PivotTable Cache?
\n5. (03:19) Introduction to PivotTable User Interface
\n6. (05:07) Change calculation in PivotTable with: Summarize Values By and Shows Values As
\n7. (06:07) Alt Keyboard Efficiency Tricks to create PivotTable and other features
\n8. (09:48) Power Query to Import & Transform CSV file with table of data
\n9. (11:30) What is a CSV File? What is a Delimiter?
\n10. (12:38) Where is the Power Query tool in Excel?
\n11. (14:30) What are Data Types in Power Query? And why are they Important!
\n12. (15:40) Merge two fields to create one element field
\n13. (16:44) Load Power Query Table to Excel Worksheet
\n14. (17:57) Edit Query after it has been loaded
\n15. (19:30) Terms to describe the table, fields and data.
\n16. (20:07) Frequency Distributions for different types of data
\n17. (20:34) Frequency Distributions defined
\n18. (20:47) Frequency Distribution for Nominal Data, using a PivotTable.
\n19. (21:23) Frequency Distribution for Discrete Quantitative Data, using a PivotTable and the Grouping Feature
\n20. (22:47) How to Group in a PivotTable and create Upper and Lower Limits for Counting Categories.
\n21. (23:49) Use Field Settings to show categories without data.
\n22. (25:05) Change Grouping Categories
\n23. (25:36) Grouping Categories Created for Discrete Quantitative Data
\n24. (26:08) Frequency Distribution for Continuous Quantitative Data, using a PivotTable and the Grouping Feature
\n25. (27:11) Grouping Categories Created for Continuous Quantitative Data
\n26. (28:14) What happens to PivotTable when Source Data Changes?
\n27. (28:32) Refreshing a PivotTable to allow new data into Report
\n28. (29:04) Fixing Ambiguous Grouping Categories in a PivotTable with Decimal Number Data. Three Methods.
\n29. (31:30) How Grouping works with PivotTable Cache.
\n30. (32:33) How to create Multiple Grouping Categories from a Single Data Source using PivotTable Wizard QAT Button or Keyboard: Alt, D, P.
\n31. (33:53) Summary of video
\n32. (34:40) How to Printout Notes from Excel Workbook File
\n33. (35:13) Homework files to download from in Canvas
\n34. (36:12) Closing and Video Links<\/p>\n","protected":false},"excerpt":{"rendered":"