{"id":3160,"date":"2019-12-23T16:46:14","date_gmt":"2019-12-23T16:46:14","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3160"},"modified":"2024-05-17T01:52:13","modified_gmt":"2024-05-17T01:52:13","slug":"introduction-to-analyzing-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/introduction-to-analyzing-data\/","title":{"raw":"Introduction to Analyzing Data","rendered":"Introduction to Analyzing Data"},"content":{"raw":"<h2>What you'll learn to do: Analyze data<\/h2>\r\nIn this section we will explore a variety of topics that support data analysis. First, data must be \"cleaned\" in order to be useful. This process is known as data transformation and Access has several features that aid in preparing data for analysis purposes. Next, we will explore the rich set of calculations built-in to Access to be used for data analysis. Finally, we will touch on some more complex topics: conditional analysis and subqueries\u2014very powerful tools of relational databases to get the most of data analysis.","rendered":"<h2>What you&#8217;ll learn to do: Analyze data<\/h2>\n<p>In this section we will explore a variety of topics that support data analysis. First, data must be &#8220;cleaned&#8221; in order to be useful. This process is known as data transformation and Access has several features that aid in preparing data for analysis purposes. Next, we will explore the rich set of calculations built-in to Access to be used for data analysis. Finally, we will touch on some more complex topics: conditional analysis and subqueries\u2014very powerful tools of relational databases to get the most of data analysis.<\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-3160\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Introduction to Analyzing Data. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":14,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Introduction to Analyzing Data\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"f92d00e2-b587-46e4-bff2-3cc40f9de00d","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3160","chapter","type-chapter","status-publish","hentry"],"part":2775,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":8,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3160\/revisions"}],"predecessor-version":[{"id":5986,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3160\/revisions\/5986"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2775"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3160\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3160"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3160"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3160"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}