{"id":1895,"date":"2021-01-19T10:32:43","date_gmt":"2021-01-19T10:32:43","guid":{"rendered":"https:\/\/www.metaoption.com\/blog\/?p=1895"},"modified":"2021-05-07T19:39:45","modified_gmt":"2021-05-07T19:39:45","slug":"analyze-business-data-with-dyn365bcs-business-intelligence","status":"publish","type":"post","link":"https:\/\/www.metaoption.com\/blog\/dynamics-365-business-central\/analyze-business-data-with-dyn365bcs-business-intelligence\/","title":{"rendered":"Analyze Business Data with Dyn365 BC&#8217;s Business Intelligence"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.metaoption.com\/blog\/wp-content\/uploads\/2021\/01\/1611053831975-1024x683.jpeg\" alt=\"Analyze Business Data with Dyn365BC&#039;s Business Intelligence\" class=\"wp-image-1901\" title=\"\" srcset=\"https:\/\/www.metaoption.com\/blog\/wp-content\/uploads\/2021\/01\/1611053831975-1024x683.jpeg 1024w, https:\/\/www.metaoption.com\/blog\/wp-content\/uploads\/2021\/01\/1611053831975-300x200.jpeg 300w, https:\/\/www.metaoption.com\/blog\/wp-content\/uploads\/2021\/01\/1611053831975-768x512.jpeg 768w, https:\/\/www.metaoption.com\/blog\/wp-content\/uploads\/2021\/01\/1611053831975-1536x1025.jpeg 1536w, https:\/\/www.metaoption.com\/blog\/wp-content\/uploads\/2021\/01\/1611053831975-660x440.jpeg 660w, https:\/\/www.metaoption.com\/blog\/wp-content\/uploads\/2021\/01\/1611053831975.jpeg 2003w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>A feature called Business Intelligence is used by<a rel=\"noreferrer noopener\" aria-label=\" Dynamics 365 Business Central (opens in a new tab)\" href=\"https:\/\/www.metaoption.com\/dynamics-365-business-central\/?utm_source=MO&amp;utm_medium=Blog&amp;utm_campaign=BC\" target=\"_blank\"> Dynamics 365 Business Central<\/a> to assist end-users in data analysis and reporting. This works mainly with the help of dimensions. These dimensions in Business Central are custom attributes that can be assigned to a variety of different entry records. Also, it can then be grouped by similarities such as a region or product, and with reporting via account schedules. Business Intelligence accomplishes a variety of tasks including:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Comparing actual v\/s budgeted amounts<\/li><li>Set up analysis views using dimensions<\/li><li>Create analysis reports for sales, purchases,\nand inventory<\/li><li>Establishing KPIs and analyzing financial\nperformance<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Budget_VS_Actual_Amount_Analysis\"><\/span><strong>Budget V\/S Actual Amount\nAnalysis<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This comparison of analyzing\nbudget, actual amounts make use of G\/L Budgets. These budgets can be seen by\nentering G\/L Budgets in the search function. After opening the desired budget,\nthere are filter fields at the top that allow for the definition of which data\nis shown. These actual and budgeted amounts can be viewed for all accounts by\nnavigating to the Chart of Accounts page and selecting the G\/L Balance\/Budget\naction.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Analyzing_by_Dimension\"><\/span><strong>Analyzing by Dimension<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>It can be done through the \u2018Analysis Views\u2019 page of <a href=\"https:\/\/www.metaoption.com\/dynamics-365-business-central\/?utm_source=MO&amp;utm_medium=Blog&amp;utm_campaign=BC\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Dynamics 365 BC (opens in a new tab)\">Dynamics 365 BC<\/a>. When opening an analysis view, there is an \u2018Analysis by Dimensions\u2019 function. After applying the desired filters and dimensions, the left columns will contain the information defined by the \u2018Show as Lines\u2019 field. The right columns will have the data from the Show as Columns field.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating_Analysis_Reports\"><\/span><strong>Creating Analysis Reports<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Analysis reports assist in the creation of customized reports on the records of transactions. It can be personalized to focus on key accounts to examine things like profits, sales, and turnover to then compare with previous months or years and calculate differences. This is all done within the same view and gives the ability to easily jump to areas that are posing problems. There are a few analysis report templates that come with Business Central, but they can be further customized to fit each business\u2019s individual needs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Financial_Reporting_with_Account_Schedules\"><\/span><strong>Financial Reporting with Account\nSchedules<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Account schedules are mainly used to help generate information of financial data stored into the pieces within the chart of accounts. They analyze data within G\/L accounts and compare entries on the general ledger with G\/L budgets. There are a few default accounts schedules that come with Dynamics 365 Business Central, but new columns and rows can be created to provide more customization and serve different functions like calculating profit margins by the department.<\/p>\n\n\n\n<p>To learn more about Dynamics 365 <a href=\"https:\/\/www.metaoption.com\/dynamics-365-business-central\/?utm_source=MO&amp;utm_medium=Blog&amp;utm_campaign=BC\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Business Central\u2019s business intelligence (opens in a new tab)\">Business Central\u2019s business intelligence<\/a> capabilities and a personalized demo <a href=\"https:\/\/www.metaoption.com\/contact-us\/?utm_source=MO&amp;utm_medium=Blog&amp;utm_campaign=BC\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"contact us (opens in a new tab)\">contact us<\/a> today at MetaOption.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A feature called Business Intelligence is used by Dynamics 365 Business Central to assist end-users in data analysis and reporting. This works mainly with the help of dimensions. These dimensions in Business Central are custom attributes that can be assigned to a variety of different entry records. Also, it can then be grouped by similarities\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.metaoption.com\/blog\/dynamics-365-business-central\/analyze-business-data-with-dyn365bcs-business-intelligence\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[629],"tags":[672,640,448,729,590,596,613,702,675,698,674,689,731,703,699,176,638,725,726,728,727,701,700,694],"class_list":["post-1895","post","type-post","status-publish","format-standard","hentry","category-dynamics-365-business-central","tag-advanced-warehouse-management","tag-advanced-warehouse-solution","tag-business-intelligence","tag-d365ug","tag-document-management-add-on-for-dynamics-nav","tag-document-management-solution-for-dynamics-nav","tag-dynamics-365-business-central","tag-dynamics-business-central-nav-add-ons","tag-dynamics-nav-2018-advanced-warehouse-management","tag-dynamics-nav-magento-connector","tag-dynamics-nav-warehousing","tag-dynamics-new-york-solutions","tag-lifehacks365","tag-manufacturing-solution","tag-metamagento-connector-add-on-of-business-central","tag-microsoft-dynamics","tag-microsoft-dynamics-365-business-central","tag-msdyn365bc","tag-msdynnav","tag-mspartner","tag-msuspartner","tag-pharma-track-and-trace","tag-quality-control-software","tag-supply-chain-management-software"],"featured_image_src":false,"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"MetaOption","author_link":"https:\/\/www.metaoption.com\/blog\/author\/admin\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.metaoption.com\/blog\/category\/dynamics-365-business-central\/\" rel=\"category tag\">Dynamics 365 Business Central<\/a>","rttpg_excerpt":"A feature called Business Intelligence is used by Dynamics 365 Business Central to assist end-users in data analysis and reporting. This works mainly with the help of dimensions. These dimensions in Business Central are custom attributes that can be assigned to a variety of different entry records. Also, it can then be grouped by similarities\u2026&hellip;","_links":{"self":[{"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/posts\/1895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/comments?post=1895"}],"version-history":[{"count":6,"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/posts\/1895\/revisions"}],"predecessor-version":[{"id":2162,"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/posts\/1895\/revisions\/2162"}],"wp:attachment":[{"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/media?parent=1895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/categories?post=1895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.metaoption.com\/blog\/wp-json\/wp\/v2\/tags?post=1895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}