{"id":178678,"date":"2024-03-27T19:25:49","date_gmt":"2024-03-27T18:25:49","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=178678"},"modified":"2024-02-14T21:00:27","modified_gmt":"2024-02-14T20:00:27","slug":"how-does-power-bi-help-smes-and-vses-with-their-monitoring","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring","title":{"rendered":"How does Power BI help SMEs and VSEs with their monitoring?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178678\" class=\"elementor elementor-178678\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c09eb3b e-flex e-con-boxed e-con\" data-id=\"c09eb3b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5bbc682 elementor-widget elementor-widget-heading\" data-id=\"5bbc682\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">After depicting <a href=\"https:\/\/datascientest.com\/microsoft-power-bi-au-service-de-la-fonction-finance\">the digital transformation of the finance function<\/a>, <a href=\"https:\/\/datascientest.com\/microsoft-power-bi-au-service-des-cabinets-dexpertise-comptable\">that of chartered accountancy firms<\/a> and auditing firms, in this article we will attempt to present a concrete example of a real-life situation. The main objective here is to understand how acculturation to a tool such as <a href=\"https:\/\/datascientest.com\/power-bi-pour-les-nuls\">Microsoft Power BI<\/a> redefines the supervision of the commercial performance of an SME or ETI- mid-sized company.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46bb1c0 elementor-widget elementor-widget-text-editor\" data-id=\"46bb1c0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>The term &#8220;<a href=\"https:\/\/datascientest.com\/en\/the-evolution-of-data-insights-data-science-vs-business-intelligence-in-the-big-data-era\">Business Intelligence<\/a>&#8221; first appeared in 1958[1]. It can be defined as &#8220;a technological process for analysing data and presenting information to help (&#8230;) business end-users make informed decisions[2]&#8221;.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d89385c e-flex e-con-boxed e-con\" data-id=\"d89385c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-aaf9c61 elementor-widget elementor-widget-heading\" data-id=\"aaf9c61\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Let's take an example: The company NATIX<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-933067b elementor-widget elementor-widget-text-editor\" data-id=\"933067b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>SME NATIX<\/strong> operates in the industrial sector.<\/p><p>In order to improve the analytical monitoring of the entity&#8217;s sales, a 100% digital and collaborative reporting process is envisaged. It should be noted that within the <a href=\"https:\/\/datascientest.com\/en\/optimizing-financial-insights-with-microsoft-power-bi-finance\">group&#8217;s finance function<\/a>, the financial director works closely with the sales manager, who is responsible for the SME&#8217;s commercial performance.<\/p><p>With this in mind, and as an extension of its office suite, the entity aims to exploit its data via the leading Business Intelligence tool: <a href=\"https:\/\/datascientest.com\/en\/optimizing-financial-insights-with-microsoft-power-bi-finance\">Microsoft Power BI.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e7d6ae7 e-flex e-con-boxed e-con\" data-id=\"e7d6ae7\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a7ba0e9 elementor-widget elementor-widget-heading\" data-id=\"a7ba0e9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Data sources : Which ones to use?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e50393 elementor-widget elementor-widget-text-editor\" data-id=\"7e50393\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <a href=\"https:\/\/datascientest.com\/en\/data-sources-understanding-the-definition-and-inner-workings\">data sources<\/a> to be used by the stakeholders correspond mainly to files from the sales management application used internally. To date, these files correspond to the following elements: N and N-1 files provided by the sales administration and exported from the sales management application.<\/p><p>In addition, and specifically for the second need expressed below, the finance function will use the Fichier des Ecritures Comptables (FEC) produced by the entity. This must be produced in compliance with the standards codified in article A.47 A-1 of the tax procedures book.<\/p><p>To date, the parties envisage updating the various data sources on a monthly basis in order to set up a periodic update of the reporting.<\/p><p>The combination of these different data sources should enable the entity&#8217;s main commercial issues to be resolved.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Tooltips: Discovering the tooltip and its use cases&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-tooltips-discovering-the-tooltip-and-its-use-cases\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-tooltips-discovering-the-tooltip-and-its-use-cases\" target=\"_blank\" rel=\"noopener\">Power BI Tooltips: Discovering the tooltip and its use cases<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI for Retail: what's at stake and what's the outlook?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-for-retail-whats-at-stake-and-whats-the-outlook\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-for-retail-whats-at-stake-and-whats-the-outlook\" target=\"_blank\" rel=\"noopener\">Power BI for Retail: what&#8217;s at stake and what&#8217;s the outlook?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Mobile: Everything you need to know about the mobile version of Power BI&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-mobile-everything-you-need-to-know-about-the-mobile-version-of-power-bi\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-mobile-everything-you-need-to-know-about-the-mobile-version-of-power-bi\" target=\"_blank\" rel=\"noopener\">Power BI Mobile: Everything you need to know about the mobile version of Power BI<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI vs Tableau vs Qlik: Which to choose?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-vs-tableau-vs-qlik-which-to-choose\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-vs-tableau-vs-qlik-which-to-choose\" target=\"_blank\" rel=\"noopener\">Power BI vs Tableau vs Qlik: Which to choose?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Joins in Power BI: mastering the different types&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/joins-in-power-bi-mastering-the-different-types\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/joins-in-power-bi-mastering-the-different-types\" target=\"_blank\" rel=\"noopener\">Joins in Power BI: mastering the different types<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a82a9d5 e-flex e-con-boxed e-con\" data-id=\"a82a9d5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-59b4697 elementor-widget elementor-widget-heading\" data-id=\"59b4697\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Analytical monitoring of sales<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-81b02b4 elementor-widget elementor-widget-text-editor\" data-id=\"81b02b4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>management of an SME or ETI<\/strong> may find it difficult to monitor the quality of the sales generated by the entity&#8217;s various operational activities. Especially if this aggregate is mainly supervised remotely.<\/p><p>Sales represent the commercial performance of an organisation, and the various analytical dimensions available make it possible to improve monitoring.<\/p><p>First of all, a first <strong>level of analysis<\/strong> could be dedicated to customers or related groups (network, brand, etc.) in order to produce rankings in the form of charts or &#8220;top customers&#8221;. Subsequently, a finer mesh would be dedicated to the typology of products sold.<\/p><p>Similarly, if the organisation has several business lines or activities, a more synthetic view is also useful in order to monitor the proportion of each segment over time. Finally, periodic and geographical dimensions are also essential to enable the finance function to investigate the performance achieved both over time and in space.<\/p><p>In addition to this<strong> analytical monitoring,<\/strong> a reconciliation between accounting and management can also be established to ensure that the <a href=\"https:\/\/datascientest.com\/en\/data-quality-10-mistakes-not-to-make\">data is exhaustive and reliable.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-814106b elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"814106b\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Mastering Business Intelligence with Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-069e9a6 e-flex e-con-boxed e-con\" data-id=\"069e9a6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b4df91e elementor-widget elementor-widget-heading\" data-id=\"b4df91e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Differences between accounting and invoicing<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8655289 elementor-widget elementor-widget-text-editor\" data-id=\"8655289\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To guarantee the <strong>financial sustainability<\/strong> of any organisation with commercial activities, the collection of invoices issued is essential.<\/p><p>Commercial management represents the main source of data taken into account for the construction of the target reporting for the NATIX SME. From a treasury point of view, the invoicing process enables the organisation to launch collection campaigns. It is therefore desirable for the organisation to monitor any disparities between general accounting and sales management.<\/p><p>To do this, the complementary use of the entity&#8217;s FEC will enable the accounting data to be compared with the <strong>management data<\/strong>. Automatic reconciliation of these sources will make it possible to check the completeness of the information between the two environments and thus detect any invoicing discrepancies.<\/p><p>Ultimately, the SME&#8217;s reporting can be enriched by additional areas of analysis from the <strong>commercial environment<\/strong>. For example, monitoring prices charged and volumes sold could help the finance function in its task of supervising sales performance.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b80da1e e-flex e-con-boxed e-con\" data-id=\"b80da1e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-83ac510 elementor-widget elementor-widget-heading\" data-id=\"83ac510\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Price and volume effects<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d3414c elementor-widget elementor-widget-text-editor\" data-id=\"6d3414c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In addition to the dimensions mentioned above, other analytical axes can be encountered.<\/p><p>As is the case for NATIX, periodic variations in an industrial activity can be analysed in terms of certain components. From a management control perspective, for example, changes in<strong> sales performance<\/strong> can be broken down into price and volume effects. Sales in this type of sector are most often made up of unit prices and quantities sold. Differences can therefore be observed, particularly between two successive periods:<\/p><p>The price effect, linked to the impact of changes in selling prices on sales and calculated between two periods N and N-1 as follows:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35cfd7b elementor-widget elementor-widget-image\" data-id=\"35cfd7b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/image1-3.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dabcdb0 elementor-widget elementor-widget-text-editor\" data-id=\"dabcdb0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>The volume effect, linked to the impact of changes in quantities sold on sales and calculated between two periods N and N-1 as follows:<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f64efe3 elementor-widget elementor-widget-image\" data-id=\"f64efe3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/image2-3.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd13412 elementor-widget elementor-widget-text-editor\" data-id=\"bd13412\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Please note that the sum of these two effects must correspond to the variation in sales between the two periods being compared. The commercial performance of the <strong>NATIX SME<\/strong> can therefore be steered with full knowledge of the facts. In an increasingly competitive environment, such visibility on the components of sales means that corrective action can be taken if necessary.<\/p><p>In the light of the above developments, sales data would appear to be ideal for feeding into a <strong>digital and collaborative reporting system.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9d40505 e-flex e-con-boxed e-con\" data-id=\"9d40505\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1e5d588 elementor-widget elementor-widget-heading\" data-id=\"1e5d588\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Visualisation and monitoring with Power BI <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5490b75 elementor-widget elementor-widget-text-editor\" data-id=\"5490b75\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>First of all, the <strong>finance function<\/strong> needs to break down the monitoring of NATIX&#8217;s sales using the different analytical axes available.<\/p><p>To do this, it needs to take advantage of the various dimensions derived from sales management. They can then be used by the finance function to analyse the data for reporting purposes. Visuals can be created to provide the finance function with key information that can be read directly.<\/p><p>The figure below shows a breakdown of the<strong> SME&#8217;s sales between its various operational business lines:<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be792de elementor-widget elementor-widget-image\" data-id=\"be792de\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/image12.gif\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Figure 1: Breakdown of sales by business line<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-10b78df elementor-widget elementor-widget-text-editor\" data-id=\"10b78df\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The &#8216;Matrix&#8217; format, also available in Power BI, enables the data to be viewed in several dimensions. In the figure below, different categories of third parties form a hierarchy that can be used to refine the reading of the data as the analysis progresses. For example, by looking at the &#8216;Brittany&#8217; group of operations, a finer breakdown is then available at the &#8216;Customer groups&#8217; level:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b424dc3 elementor-widget elementor-widget-image\" data-id=\"b424dc3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/image6.gif\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Figure 2: Breakdown of sales by Region and Customer<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a5e0b80 elementor-widget elementor-widget-text-editor\" data-id=\"a5e0b80\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>It is also essential to set up a systematic reconciliation between the two main sources used by the finance function in the course of its activities: accounting and invoicing.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1652940 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1652940\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn dataviz with Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8ac9daa e-flex e-con-boxed e-con\" data-id=\"8ac9daa\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6bbd520 elementor-widget elementor-widget-heading\" data-id=\"6bbd520\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Reconciliation between accounting and billing<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5e4c47e elementor-widget elementor-widget-text-editor\" data-id=\"5e4c47e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In order to improve the vision of the finance function, the invoicing process can be made more reliable by reconciling the accounts with <strong>commercial management.<\/strong><\/p><p>In the case of NATIX, this involves the use of the FEC. With this in mind, a reconciliation can be carried out with sales management using a common field corresponding to invoice numbers. To do this, a table of dimensions made up of all the invoices must make it possible to <strong>link the two previous sources:<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c807c7 elementor-widget elementor-widget-image\" data-id=\"0c807c7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/image10-1.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Figure 3: Intermediate table of dimensions linked to invoice numbers<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-580a981 elementor-widget elementor-widget-text-editor\" data-id=\"580a981\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Finally, a reconciliation between accounting and invoicing from sales management can be envisaged by making a distinction between :<\/p><p>invoices issued in management but not yet accounted for,<br \/>and conversely, invoices present in the accounting system but absent from the sales management process.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-804829a elementor-widget elementor-widget-text-editor\" data-id=\"804829a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>By systematically reconciling these two main environments, the finance function can secure the recognition of sales.<\/p><p>By extension, monitoring average prices can also be invaluable.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI waterfall chart: Overview and use cases&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\" target=\"_blank\" rel=\"noopener\">Power BI waterfall chart: Overview and use cases<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Our Guide to Power BI KPI - Definition and Purpose&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/our-guide-to-power-bi-kpi-definition-and-purpose\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/our-guide-to-power-bi-kpi-definition-and-purpose\" target=\"_blank\" rel=\"noopener\">Our Guide to Power BI KPI &#8211; Definition and Purpose<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;The use of Power BI in Start-Ups&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/the-use-of-power-bi-in-start-ups\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/the-use-of-power-bi-in-start-ups\" target=\"_blank\" rel=\"noopener\">The use of Power BI in Start-Ups<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Python: Harnessing the Synergy of tools Data Science&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-python-harnessing-the-synergy-of-tools-data-science\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-python-harnessing-the-synergy-of-tools-data-science\" target=\"_blank\" rel=\"noopener\">Power BI Python: Harnessing the Synergy of tools Data Science<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power Query Date Format: How to change it on Excel and Power BI&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\" target=\"_blank\" rel=\"noopener\">Power Query Date Format: How to change it on Excel and Power BI<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d395055 e-flex e-con-boxed e-con\" data-id=\"d395055\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d8dc121 elementor-widget elementor-widget-heading\" data-id=\"d8dc121\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Monitoring cash flow and financing<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8351c9a elementor-widget elementor-widget-text-editor\" data-id=\"8351c9a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Following on from the previous visuals, and depending on the quality of the data sources obtained, additional indicators can be proposed.<\/p><p>Among these, the notion of &#8220;<strong>average selling price<\/strong>&#8221; (ASP) enables the finance function to monitor the organisation&#8217;s commercial performance on a regular basis. This performance is then broken down into the various analytical areas, in particular by activity, customer or, more precisely, by item.<\/p><p>In addition, in order to refine the<strong> analysis of sales variations,<\/strong> price and volume effects can also be materialised:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bbbb8fc elementor-widget elementor-widget-image\" data-id=\"bbbb8fc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/image5-1.gif\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Figure 4 : Monitoring average prices and volumes sold<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-90a09f5 elementor-widget elementor-widget-text-editor\" data-id=\"90a09f5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In addition, among the standard visuals available in <strong>Power BI<\/strong>, the one that allows data to be represented in space can also help the finance function in its steering role. If <strong>sales management<\/strong> contains a field specific to the delivery town or department, this can be linked to a corresponding analytical table:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-17a6247 elementor-widget elementor-widget-image\" data-id=\"17a6247\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/image15.gif\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Figure 5: Sales by geographical area<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a9673d elementor-widget elementor-widget-text-editor\" data-id=\"6a9673d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Following on from the previous developments, the finance function now has a modern reporting system that meets the needs of sales administration.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5bdc9c1 e-flex e-con-boxed e-con\" data-id=\"5bdc9c1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3c82fdb elementor-widget elementor-widget-heading\" data-id=\"3c82fdb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60a692c elementor-widget elementor-widget-text-editor\" data-id=\"60a692c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In this article, we presented the context of the <strong>NATIX SME<\/strong> in the context of monitoring its commercial performance.<\/p><p>The main issues specific to <strong>SMEs and SMIs<\/strong> were addressed here. Power BI is an invaluable tool for company management and the finance function, providing ongoing qualitative monitoring of sales performance.<\/p><p>In fact, the visuals created to monitor <strong>NATIX&#8217;s sales<\/strong> analytically enable the company to supervise its sales performance. What&#8217;s more, the calculation of average sales is set up in such a way as to be accessible to all analytical <strong>levels of sales management.<\/strong><\/p><p>Finally, the finance function benefits from increased visibility of the geographical distribution of sales and the <strong>potential efforts<\/strong> to be made in terms of commercial development.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31c006d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"31c006d\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Start a Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-dcf49cc e-flex e-con-boxed e-con\" data-id=\"dcf49cc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f9477a7 elementor-widget elementor-widget-menu-anchor\" data-id=\"f9477a7\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\nbody.elementor-page .elementor-widget-menu-anchor{margin-bottom:0}<\/style>\t\t<div id=\"notes\" class=\"elementor-menu-anchor\"><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43853a1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"43853a1\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-divider{--divider-border-style:none;--divider-border-width:1px;--divider-color:#0c0d0e;--divider-icon-size:20px;--divider-element-spacing:10px;--divider-pattern-height:24px;--divider-pattern-size:20px;--divider-pattern-url:none;--divider-pattern-repeat:repeat-x}.elementor-widget-divider .elementor-divider{display:flex}.elementor-widget-divider .elementor-divider__text{font-size:15px;line-height:1;max-width:95%}.elementor-widget-divider .elementor-divider__element{margin:0 var(--divider-element-spacing);flex-shrink:0}.elementor-widget-divider .elementor-icon{font-size:var(--divider-icon-size)}.elementor-widget-divider .elementor-divider-separator{display:flex;margin:0;direction:ltr}.elementor-widget-divider--view-line_icon .elementor-divider-separator,.elementor-widget-divider--view-line_text .elementor-divider-separator{align-items:center}.elementor-widget-divider--view-line_icon .elementor-divider-separator:after,.elementor-widget-divider--view-line_icon .elementor-divider-separator:before,.elementor-widget-divider--view-line_text .elementor-divider-separator:after,.elementor-widget-divider--view-line_text .elementor-divider-separator:before{display:block;content:\"\";border-bottom:0;flex-grow:1;border-top:var(--divider-border-width) var(--divider-border-style) var(--divider-color)}.elementor-widget-divider--element-align-left .elementor-divider .elementor-divider-separator>.elementor-divider__svg:first-of-type{flex-grow:0;flex-shrink:100}.elementor-widget-divider--element-align-left .elementor-divider-separator:before{content:none}.elementor-widget-divider--element-align-left .elementor-divider__element{margin-left:0}.elementor-widget-divider--element-align-right .elementor-divider .elementor-divider-separator>.elementor-divider__svg:last-of-type{flex-grow:0;flex-shrink:100}.elementor-widget-divider--element-align-right .elementor-divider-separator:after{content:none}.elementor-widget-divider--element-align-right .elementor-divider__element{margin-right:0}.elementor-widget-divider:not(.elementor-widget-divider--view-line_text):not(.elementor-widget-divider--view-line_icon) .elementor-divider-separator{border-top:var(--divider-border-width) var(--divider-border-style) var(--divider-color)}.elementor-widget-divider--separator-type-pattern{--divider-border-style:none}.elementor-widget-divider--separator-type-pattern.elementor-widget-divider--view-line .elementor-divider-separator,.elementor-widget-divider--separator-type-pattern:not(.elementor-widget-divider--view-line) .elementor-divider-separator:after,.elementor-widget-divider--separator-type-pattern:not(.elementor-widget-divider--view-line) .elementor-divider-separator:before,.elementor-widget-divider--separator-type-pattern:not([class*=elementor-widget-divider--view]) .elementor-divider-separator{width:100%;min-height:var(--divider-pattern-height);-webkit-mask-size:var(--divider-pattern-size) 100%;mask-size:var(--divider-pattern-size) 100%;-webkit-mask-repeat:var(--divider-pattern-repeat);mask-repeat:var(--divider-pattern-repeat);background-color:var(--divider-color);-webkit-mask-image:var(--divider-pattern-url);mask-image:var(--divider-pattern-url)}.elementor-widget-divider--no-spacing{--divider-pattern-size:auto}.elementor-widget-divider--bg-round{--divider-pattern-repeat:round}.rtl .elementor-widget-divider .elementor-divider__text{direction:rtl}.e-con-inner>.elementor-widget-divider,.e-con>.elementor-widget-divider{width:var(--container-widget-width,100%);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4091ad elementor-widget elementor-widget-heading\" data-id=\"d4091ad\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Notes<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f86adcd elementor-widget elementor-widget-text-editor\" data-id=\"f86adcd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ol><li>LUHN H. P., (1958), A Business Intelligence System, IBM Journal, Vol. 2, p. 314-319.<\/li><li><a href=\"https:\/\/www.oracle.com\/fr\/database\/business-intelligence-definition.html\">https:\/\/www.oracle.com\/fr\/database\/business-intelligence-definition.html<\/a><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41e278d elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"41e278d\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6abe45f e-flex e-con-boxed e-con\" data-id=\"6abe45f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9835673 elementor-widget elementor-widget-html\" data-id=\"9835673\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is a NATIX SME?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The NATIX SME operates in the industrial sector. In order to improve the analytical monitoring of the entity's turnover, a 100% digital and collaborative reporting process is envisaged. It should be noted that within the group's finance function, the finance director works closely with the sales manager, who is responsible for the SME's commercial performance.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Data sources : Which ones to exploit?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The data sources to be used by the stakeholders correspond mainly to the files from the commercial management application used internally. To date, these files correspond to the following elements: files N and N-1 made available by sales administration and exported from the sales management application.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Visualisation and monitoring using Power BI\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"First of all, the finance function needs to break down the monitoring of NATIX's turnover using the various analytical axes available. To do this, they need to take advantage of the various dimensions derived from sales management. They can then be used by the finance function to analyse the data for reporting purposes. Visuals can be created to provide the finance function with key information that can be read directly\".\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>After depicting the digital transformation of the finance function, that of chartered accountancy firms and auditing firms, in this article we will attempt to present a concrete example of a real-life situation. The main objective here is to understand how acculturation to a tool such as Microsoft Power BI redefines the supervision of the commercial [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178698,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How does Power BI help SMEs and VSEs with their monitoring?<\/title>\n<meta name=\"description\" content=\"After depicting the digital transformation of the finance function, that of chartered accountancy firms and auditing firms, in this article we will\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How does Power BI help SMEs and VSEs with their monitoring?\" \/>\n<meta property=\"og:description\" content=\"After depicting the digital transformation of the finance function, that of chartered accountancy firms and auditing firms, in this article we will\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-27T18:25:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-14T20:00:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/03\/power-bi-sme.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"How does Power BI help SMEs and VSEs with their monitoring?\",\"datePublished\":\"2024-03-27T18:25:49+00:00\",\"dateModified\":\"2024-02-14T20:00:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring\"},\"wordCount\":1684,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring\",\"url\":\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring\",\"name\":\"How does Power BI help SMEs and VSEs with their monitoring?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-27T18:25:49+00:00\",\"dateModified\":\"2024-02-14T20:00:27+00:00\",\"description\":\"After depicting the digital transformation of the finance function, that of chartered accountancy firms and auditing firms, in this article we will\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How does Power BI help SMEs and VSEs with their monitoring?","description":"After depicting the digital transformation of the finance function, that of chartered accountancy firms and auditing firms, in this article we will","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring","og_locale":"en_GB","og_type":"article","og_title":"How does Power BI help SMEs and VSEs with their monitoring?","og_description":"After depicting the digital transformation of the finance function, that of chartered accountancy firms and auditing firms, in this article we will","og_url":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-27T18:25:49+00:00","article_modified_time":"2024-02-14T20:00:27+00:00","og_image":[{"width":768,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/03\/power-bi-sme.jpg","type":"image\/jpeg"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"How does Power BI help SMEs and VSEs with their monitoring?","datePublished":"2024-03-27T18:25:49+00:00","dateModified":"2024-02-14T20:00:27+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring"},"wordCount":1684,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring","url":"https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring","name":"How does Power BI help SMEs and VSEs with their monitoring?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-27T18:25:49+00:00","dateModified":"2024-02-14T20:00:27+00:00","description":"After depicting the digital transformation of the finance function, that of chartered accountancy firms and auditing firms, in this article we will","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/how-does-power-bi-help-smes-and-vses-with-their-monitoring"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178678"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=178678"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/178698"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=178678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=178678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=178678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}