{"id":3198,"date":"2017-03-21T11:10:19","date_gmt":"2017-03-21T14:10:19","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=3198"},"modified":"2026-05-18T21:31:22","modified_gmt":"2026-05-18T19:31:22","slug":"google-sheets-business-intelligence","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/business-processes\/google-sheets-business-intelligence\/","title":{"rendered":"Intelligence \u00e9conomique sur Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”||0px|||” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”27px|0px|0px|0px” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”||0px|||” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n

Business Intelligence is\u00a0the collective knowledge of the hive. It\u00a0is a technology-driven process of analyzing existing data and organizing actionable information. It is used to help managers and executives make strategic decisions for a firm. Google Sheets business intelligence refers to the analysis and organization of data on spreadsheets.<\/p>\n

Where is Business Intelligence?<\/h3>\n

Despite heavy investment in Enterprise Resource Planning (ERP) software, most Business Intelligence resides in or is downloaded to spreadsheets.<\/p>\n

ERPs are excellent for retaining large repositories of data. They are also a means of implementing and enforcing processes and procedures that maintain coherence and control of how data enters the databases.<\/p>\n

All ERPs generate reports. However, a one-size-fits-all solution for data analysis and reports is impossible. Companies and managers have specific preferences for what data to analyze and how.<\/p>\n

A new report will probably be required when a new manager joins the firm. This becomes impractical because most ERPs require a paid consultant to modify or create reports in the system.<\/p>\n

However, practically everybody in the organization shares their know-how on a spreadsheet. The data required for each report is extracted from the ERP to a spreadsheet (usually by clicking a button), where it is manipulated according to the user’s needs and the required results.<\/p>\n

\n

“The hype around Big Data is misplaced \u2013\u00a0small connected data is where the real value lies.”<\/p>\n<\/blockquote>\n

Rufus Pollock – Open Knowledge Foundation<\/span><\/p>\n

Why Google Sheets business intelligence?<\/h3>\n

The principal advantage of Google Sheets is that it’s\u00a0in the CLOUD.<\/p>\n

As a Google Sheets user, this means you don’t have to worry about access to shared drives or, worse yet, failures of the local drive. Leaving the firm to go on a business trip does not limit your access to the data.<\/p>\n

Sharing data in the cloud is also much easier. With offline solutions, you likely save a copy on your hard drive, email it to a colleague who makes edits and saves it on their hard drive with a different name, and then email it to someone else. Pretty soon, you have dozens of copies of the same file, and no one knows which one is correct. With cloud-based solutions, everyone who needs access has access and knows which version is the latest.<\/p>\n

Finally, because it’s easy to share data between Google Sheets (no #REF errors if someone moves a sheet from one folder to another) it allows you to segregate your data better peruse.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”||0px|||” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n

Interconnecting Google Sheets<\/h3>\n

Google Sheets can\u00a0be interconnected<\/a> to facilitate\u00a0the sharing of information via the use of Add-ons such as Sheetgo.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/05\/post_interconnecting-google-sheets.jpg” alt=”Business Intelligence in Google Sheets: Connecting Files” title_text=”google-sheets-business-intelligence-connect” _builder_version=”4.23.1″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n

Get creative and see what you can come up via connecting sheets. To install\u00a0Sheetgo, click the button below:<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/04\/google-workspace-add-on.svg” alt=”Get Sheetgo on Google Workspace Marketplace” title_text=”google-workspace-add-on” url=”https:\/\/workspace.google.com\/marketplace\/app\/sheetgo\/94172092257″ url_new_window=”on” admin_label=”B \/ CTA \/ SHEETS \/ CENTER” module_class=”add-n-button” _builder_version=”4.27.4″ _module_preset=”default” min_height=”60px” height=”60px” hover_enabled=”0″ saved_tabs=”all” global_colors_info=”{}” global_module=”225051″ theme_builder_area=”post_content” align=”center” sticky_enabled=”0″][\/et_pb_image][et_pb_button _builder_version=”4.16″ global_colors_info=”{}” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Business Intelligence is\u00a0the collective knowledge of the hive. It\u00a0is a technology-driven process of analyzing existing data and organizing actionable information. It is used to help managers and executives make strategic decisions for a firm. Google Sheets business intelligence refers to the analysis and organization of data on spreadsheets. Where is Business Intelligence? Despite heavy investment […]<\/p>\n","protected":false},"author":2,"featured_media":3789,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Business Intelligence is\u00a0the collective knowledge of the hive. It\u00a0is a technology driven process of analyzing existing data and organizing actionable information. It is used to help managers and executives make strategic decisions for a firm.\n

Where is Business Intelligence?<\/span><\/h2>\nDespite heavy investment in Enterprise Resource Planning (ERP) software most Business Intelligence resides in, or is downloaded to spreadsheets.\n\nERPs are exellent for retaining\u00a0large repositories of data. They are also a means to implement and enforce processes and procedures, that maintain coherence and control of how data enters the databases.\n\n \n\n\"Business<\/span>\n\n \n\nAll ERP\u00b4s generate reports.\u00a0However, its impossible to have a one size fits all solution for data analysis and reports. All companies and managers have their own specific preferences of what data to analyze and how.\n\nWhen a new manager joins the firm, a new report will probably be required. Given that most ERP\u00b4s require a paid consultant to modify or create reports in the system, this becomes impractical.\n\nA spreadsheet, however, is where practically everybody in the organization splashes their know-how. The data required for each report is extracted from the ERP to a spreadsheet (usually by clicking a button)\u00a0to then be manipulated according to the user's needs and the required results.\n

\"The hype around Big Data is misplaced \u2013\u00a0small connected data is where the real value lies<\/span>.\" \u00a0<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/span><\/p>\n

Rufus Pollock - Open Knowledge Foundation<\/span><\/p>\n \n

Why Google Sheets?<\/strong><\/span><\/h2>\nThe principal advantage of Google Sheets is that it's\u00a0in the CLOUD.\n\nAs a user of Google Sheets this means you don't have to worry about access to shared drives or, worse yet, failures of local drive.\u00a0Leaving the firm to go on a business trip does not limit your access to the data.\n\nSharing data in the cloud is also much easier. With offline solutions you likely save a copy on your hard drive, email it to a colleague who makes edits and saves on their hard drive with a different name, then emails on to someone else.\u00a0Pretty soon you have dozens of copies of the same file and no one know which one is correct. With cloud based solutions everyone who needs access has access and knows which version is latest.\n\nFinally, because its easy to share data between Google Sheets (no #REF errors if someone moves a sheet from one folder to another) it allows you to segregate your data better per use.\n

Interconnecting Google Sheets<\/strong><\/span><\/h3>\nGoogle Sheets can\u00a0be interconnected to facilitate\u00a0sharing of information via the use of Add-ons such as <\/span>Sheetgo.<\/span>\n\n \n\n\"Business<\/span>\n\n \n\nA few simple use cases of organizing data via connected sheets:\n