{"id":50486,"date":"2024-09-05T20:36:47","date_gmt":"2024-09-05T18:36:47","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=50486"},"modified":"2024-09-05T20:36:47","modified_gmt":"2024-09-05T18:36:47","slug":"lagregation-des-donnees","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/data-science\/data-aggregation\/","title":{"rendered":"Qu'est-ce que l'agr\u00e9gation de donn\u00e9es ?  (Types, cas d'utilisation et outils)"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">Carly Fiorina once said, \u201cThe goal is to transform data into information, and information into insight.\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Explanation: the real power of data is how it\u2019s used to create meaningful information that leads to practical actions and decisions. And one of the best ways to achieve this is to use data aggregation.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">What is data aggregation, and what tools should you use to aggregate data?<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><b><\/b><\/p>\n<p><b>Key takeaways:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data aggregation is the <\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/productivity-tips\/what-is-a-business-process\/\"><span style=\"font-weight: 400;\">process<\/span><\/a><span style=\"font-weight: 400;\"> of collecting and <\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/data-science\/what-is-data-consolidation\/\"><span style=\"font-weight: 400;\">combining data<\/span><\/a><span style=\"font-weight: 400;\"> from multiple sources to create a summary or a more comprehensive dataset.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data aggregation is used in business analytics, market research, healthcare, financial reporting, and more.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">There are mainly two types of data aggregation: time and spatial aggregation and manual and automated aggregation.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.sheetgo.com\/\"><span>Sheetgo<\/span><\/a><span> is a tool that automates data aggregation.<\/span><\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;2_5,3_5&#8243; _builder_version=&#8221;4.24.1&#8243; background_color=&#8221;#fffbf1&#8243; background_image=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/workflow_build-workflow.webp&#8221; background_size=&#8221;contain&#8221; background_position=&#8221;center_left&#8221; background_horizontal_offset=&#8221;-40%&#8221; max_width_tablet=&#8221;&#8221; max_width_phone=&#8221;&#8221; max_width_last_edited=&#8221;on|desktop&#8221; custom_margin=&#8221;40px||40px||true|false&#8221; custom_padding=&#8221;20px|30px|30px|30px|false|true&#8221; link_option_url=&#8221;https:\/\/www.sheetgo.com\/products\/workflows\/&#8221; background_last_edited=&#8221;on|desktop&#8221; background_enable_image_tablet=&#8221;off&#8221; border_radii=&#8221;on|10px|10px|10px|10px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; background_image=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/02\/workflow-page-sheet.webp&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;bottom_right&#8221; background_horizontal_offset=&#8221;-36%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; background_enable_image=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; header_4_text_color=&#8221;#071623&#8243; custom_margin=&#8221;0px|0px|0px||false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4 style=\"text-align: center;\"><strong>Transform your data, improve efficiency<\/strong><\/h4>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/www.sheetgo.com\/products\/workflows\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;START WITH SHEETGO&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; hover_enabled=&#8221;0&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><b>What is data aggregation?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Data aggregation is the process of collecting and combining data from multiple sources to create a summary or a more comprehensive dataset.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>How does data aggregation work?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Let\u2019s use a simple example to understand how data aggregation works.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Imagine you want to know the number of apples 100 people in your neighborhood have. You can go to each person\u2019s house and count all the apples one by one. But this is not productive; you still have 99 people to visit.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">What\u2019s the best solution?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You ask each person to count their apples alone (before you visit them) and give you the <\/span><i><span style=\"font-weight: 400;\">total<\/span><\/i><span style=\"font-weight: 400;\"> number. Then, you add up all those totals to get one big number that represents all the apples in the entire neighborhood.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Data aggregation works the same way. It gathers information from many websites, databases, or other data sources and then combines it into a single report or dataset. Businesses, researchers, or anyone else can analyze this report and make important decisions.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><b>4 Use cases of data aggregation<\/b><\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>1. Business analytics<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In a company, different departments like sales, marketing, and customer service often work in their own silos. Each of them collects data relevant to their specific operations.<\/span><span style=\"font-weight: 400;\"><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sales might track the number of products sold,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Marketing might monitor the performance of advertising campaigns, and<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Customer service might log customer complaints and feedback.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">While each department generates important data, analyzing these data sets separately can be difficult. It\u2019s also difficult to get a complete picture of the business&#8217;s overall health.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This is where data aggregation comes in. When the company combines this data, they can see the number of products sold, how marketing helped them sell these products, and what customers think about the products.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>2. Market research<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Companies do market research to understand what customers want and how they behave and find new trends. To do this, they gather information from many places. This information can include<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Customer surveys,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Social media activity,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Competitor analysis,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sales data,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">and more.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">However, chances are the company will have one customer survey report, competitor report, sales report, and so on. Just imagine the nightmare trying to analyze each of them. If you aggregate the data, you\u2019ll create one single report that combines this information.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>3. Healthcare<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Hospitals and clinics collect patient data from electronic health records, lab tests, and imaging reports. With <\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/business-processes\/what-is-data-integration\/\"><span style=\"font-weight: 400;\">data<\/span><\/a><span style=\"font-weight: 400;\"> aggregation, they can get a view of a patient\u2019s health and better diagnose and treat patients.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">It also helps in research, like tracking the spread of diseases or the effectiveness of treatments.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>4. Financial Reporting<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Companies often collect data from many departments, such as sales, marketing, and customer service. When they aggregate this data, they can know the overall business performance.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For example, combining sales data from different regions helps a company understand which areas are performing best and where improvements are needed.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>Types of data aggregation<\/b><\/h3>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>1. Time and spatial aggregation<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Time aggregation is about collecting data points for a single source over a defined time period. So, if you wanted to track how much your favorite store sold each day for the past month, that would be time aggregation.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">On the other hand, spatial aggregation is a method used to collect data points for a group of resources over a given time period. For example, you use it to know how much all the stores in your neighborhood sold last month.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><b>2. Manual and automated aggregation<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In manual data aggregation, individuals collect, organize, and analyze data manually. They often use tools like spreadsheets or databases. While this approach is flexible and gives more control, it\u2019s time-consuming and prone to errors. The larger the datasets, the more challenging the task is.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">With automated data aggregation, you use software tools (like <\/span><a href=\"https:\/\/www.sheetgo.com\/\"><span style=\"font-weight: 400;\">Sheetgo<\/span><\/a><span style=\"font-weight: 400;\">) to collect, process, and analyze data automatically. This approach is more efficient, accurate, and scalable. It\u2019s the best for handling large and complex datasets.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Now that you understand data aggregation and its various types, you might want to know how to aggregate data. So, how about we see a more practical example? We will focus on automated data aggregation and use <\/span><a href=\"https:\/\/www.sheetgo.com\/\"><span style=\"font-weight: 400;\">Sheetgo<\/span><\/a><span style=\"font-weight: 400;\">, a tool that can save time and money. <\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><b>How can Sheetgo help with data aggregation?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Sheetgo can help with data aggregation by collecting data from various spreadsheets (Google Sheets and Excel) and combining it into one or multiple spreadsheets.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let\u2019s say an HR department needs to monitor 37 employee attendance status for one day. They want to know which employee clocked in today.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">When clocking in and out, employees press a button in an online tool, which adds the information to a Google Sheet. And if, for some reason, they cannot work, they need to use the \u201cAbsent\u201d status.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In total, we have 4 Google Sheets (IT, Sales, Marketing, and Customer Support), and each sheet has the following columns: ID, name, department, check-in, check-out, leave, and attendance status.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_1.webp&#8221; title_text=&#8221;what-is-data-aggregation_1&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">The HR department wants to collect each document&#8217;s information into one master sheet. If an HR member has to manually scan each data point, it will take hours. However, using an automated data aggregation tool like <\/span><a href=\"https:\/\/www.sheetgo.com\/\"><span style=\"font-weight: 400;\">Sheetgo<\/span><\/a><span style=\"font-weight: 400;\"> will dramatically improve productivity.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here is how:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">1. Log into your Sheetgo account, click \u201cNew\u201d then \u201cBlank Workflow\u201d. You can create a free account <\/span><a href=\"https:\/\/app.sheetgo.com\/sign-in\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">here<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_2.webp&#8221; title_text=&#8221;what-is-data-aggregation_2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">2. Choose \u201cCreate an automation.\u201d<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_3.webp&#8221; title_text=&#8221;what-is-data-aggregation_3&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">3. Select \u201cMultiple files.\u201d<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_4.webp&#8221; title_text=&#8221;what-is-data-aggregation_4&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">4. Click \u201cSelect File.\u201d<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_5.webp&#8221; title_text=&#8221;what-is-data-aggregation_5&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">5. Choose the spreadsheets you want to gather data from and click \u201cDone.\u201d<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_6.webp&#8221; title_text=&#8221;what-is-data-aggregation_6&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">6.\u00a0 Click the \u201cNext step\u201d button.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_7.webp&#8221; title_text=&#8221;what-is-data-aggregation_7&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">7. Now, choose \u201cCondition\u201d to filter data from the four data sources.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_8.webp&#8221; title_text=&#8221;what-is-data-aggregation_8&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">8. In the next tab, select the column you want to get the information from. Choose \u201cText is exactly,\u201d and enter the name of the text Sheetgo needs to filter. In my case, I set \u201cColumn G: Attendance Status,\u201d and the text is \u201cAbsent.\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Click \u201cConfirm\u201d and \u201cNext step.\u201d<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_9.webp&#8221; title_text=&#8221;what-is-data-aggregation_9&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">9. Click \u201cGoogle Sheets.\u201d<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_10.webp&#8221; title_text=&#8221;what-is-data-aggregation_10&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">10. Next, select or create the destination file. Sheetgo will use this file or spreadsheet to report all \u201cAbsent\u201d attendance statuses. Click \u201cFinish and save.\u201d<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_11.webp&#8221; title_text=&#8221;what-is-data-aggregation_11&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">11. Sheetgo will now automatically scan your departments to track attendance, as you can see in the image below.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/what-is-data-aggregation_12.webp&#8221; title_text=&#8221;what-is-data-aggregation_12&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">12. Finally, Sheetgo will create a report displaying the attendance from each department.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Did you see how automated data aggregation works? Thanks to this <\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/google-sheets-automations\/\"><span style=\"font-weight: 400;\">Google Sheet automation<\/span><\/a><span style=\"font-weight: 400;\">, you can focus on more important tasks while tracking attendance status in your company.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can use Sheetgo with Google Sheets and Excel to automate your <a href=\"https:\/\/www.sheetgo.com\/solutions\/finance\/\">finance<\/a>, <a href=\"https:\/\/www.sheetgo.com\/solutions\/hr\/\">HR<\/a>, <a href=\"https:\/\/www.sheetgo.com\/solutions\/crm\/\">CRM<\/a>, <a href=\"https:\/\/www.sheetgo.com\/solutions\/supply-chain\/\">supply chain<\/a>, and more.<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;2_5,3_5&#8243; _builder_version=&#8221;4.24.1&#8243; background_color=&#8221;#f0f6ff&#8221; background_image=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/02\/connect-sources.webp&#8221; background_size=&#8221;custom&#8221; background_image_width=&#8221;40%&#8221; background_position=&#8221;bottom_left&#8221; background_horizontal_offset=&#8221;3%&#8221; background_vertical_offset=&#8221;50%&#8221; max_width_tablet=&#8221;&#8221; max_width_phone=&#8221;&#8221; max_width_last_edited=&#8221;on|desktop&#8221; custom_margin=&#8221;40px||40px||true|false&#8221; custom_padding=&#8221;20px|30px|30px|30px|false|true&#8221; link_option_url=&#8221;https:\/\/www.sheetgo.com\/products\/connect\/&#8221; background_last_edited=&#8221;on|tablet&#8221; background_enable_image_tablet=&#8221;off&#8221; border_radii=&#8221;on|10px|10px|10px|10px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; background_image=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/02\/connect-sources.webp&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;bottom_right&#8221; background_horizontal_offset=&#8221;-36%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; background_enable_image=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; header_4_text_color=&#8221;#071623&#8243; custom_margin=&#8221;0px|0px|||false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4 style=\"text-align: center;\"><strong>Make your data work together<\/strong><\/h4>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/www.sheetgo.com\/products\/workflows\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;START WITH SHEETGO&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; hover_enabled=&#8221;0&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><b>FAQ<\/b><\/h2>\n<p><b>Why should data be aggregated?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Data should be aggregated to simplify large datasets, uncover patterns, and support decision-making. It transforms scattered information into meaningful insights.<\/span><\/p>\n<p><b>Why is data aggregation important?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Data aggregation is important because it helps businesses understand trends, make informed decisions, and improve overall performance.<\/span><\/p>\n<p><b>How can you aggregate data?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">You can aggregate data through methods like summing, averaging, counting, and grouping, and using tools like spreadsheets, databases, and specialized software.<\/span><\/p>\n<p><b>What are the best data aggregation tools?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The best data aggregation tools are 1. Sheetgo, 2. Looker Studio, 3. Stata, 4. Google Analytics, and 5. Alteryx.<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Carly Fiorina once said, \u201cThe goal is to transform data into information, and information into insight.\u201d Explanation: the real power of data is how it\u2019s used to create meaningful information that leads to practical actions and decisions. And one of the best ways to achieve this is to use data aggregation. What is data aggregation, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":44466,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[31],"tags":[],"class_list":["post-50486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/50486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=50486"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/50486\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44466"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=50486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=50486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=50486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}