{"id":4829,"date":"2019-11-15T10:02:26","date_gmt":"2019-11-15T10:02:26","guid":{"rendered":"https:\/\/www.pkfscs.co.uk\/?post_type=solution&#038;p=4829"},"modified":"2021-09-01T14:44:44","modified_gmt":"2021-09-01T13:44:44","slug":"microsoft-power-bi-for-sage-200","status":"publish","type":"solution","link":"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/","title":{"rendered":"Microsoft Power BI"},"content":{"rendered":"\n<p>Power BI is a business analytics service by Microsoft. It aims to provide interactive visualisations and business intelligence capabilities with an interface simple enough for end-users, who are already familiar with Microsoft Excel tools such as Pivot Tables, to create their own reports and dashboards.<\/p>\n\n\n\n<p>At PKF Smith Cooper Systems, we have been integrating Sage 200 SQL data with Power BI since its launch, but now Sage has provided a connector its easier than ever to connect to your data, start analysing and create your own dashboards.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div class=\"is-layout-flex wp-container-3 wp-block-columns\">\n<div class=\"is-layout-flow wp-block-column\">\n<p>Power BI is connected to SQL and, in this example, we have pulled the customer account, address information, Customer Turnover and Sales Order tables direct from the Sage 200 database. <\/p>\n\n\n\n<p>Once connected you can now start to utilise the tables to build your dashboard.<\/p>\n\n\n\n<p>The dashboards themselves are made up of visualisations which can be tables, charts, maps or any other visual representation of data that can be downloaded from the Microsoft marketplace.<\/p>\n<\/div>\n\n\n\n<div class=\"is-layout-flow wp-block-column\">\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/BI-2.jpg\" alt=\"\" width=\"669\" height=\"419\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>In the dashboard, below, the following data is displayed:<\/p>\n\n\n\n<div class=\"is-layout-flex wp-container-6 wp-block-columns\">\n<div class=\"is-layout-flow wp-block-column\">\n<ul><li>Debtors showing a real-time breakdown of customer balances. This is from the customer accounts.<\/li><li>Monthly turnover with a trend line showing the performance of the company over time across the customer base.<\/li><li>Top Customers based on Turnover as a list.<\/li><li>Top 10 customers based on Turnover as a pie chart.<\/li><li>The geographic location of each customer based on their postcode.<\/li><\/ul>\n<\/div>\n\n\n\n<div class=\"is-layout-flow wp-block-column\">\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/BI-1-1000x640.jpg\" alt=\"\" class=\"wp-image-4834\" width=\"500\" height=\"320\" srcset=\"https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/BI-1-1000x640.jpg 1000w, https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/BI-1-768x491.jpg 768w, https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/BI-1.jpg 1560w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure><\/div>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div class=\"is-layout-flex wp-container-9 wp-block-columns\">\n<div class=\"is-layout-flow wp-block-column\">\n<p>What makes Power BI truly powerful is its ability to drill into data. <\/p>\n\n\n\n<p>For example, if you want to see what is making up the black section of my pie chart you can right-click on it and select Drill through.<\/p>\n\n\n\n<p>This opens up a whole new set of data, pre-filtered by your selection, where you can see the account information, sales by product as a list, Top 10 products based on Turnover and Quantity.<\/p>\n\n\n\n<p>At any point, the user can drill back to the parent dashboard and interrogate another clients data.<\/p>\n<\/div>\n\n\n\n<div class=\"is-layout-flow wp-block-column\">\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/BI-4.jpg\" alt=\"\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>If you would like to arrange an onsite demonstration of how Microsoft Power BI  can work for you, an initial WebEx overview or would simply like to find out a little more, then do not hesitate to&nbsp;<strong>contact us via&nbsp;<a href=\"mailto:sage@smithcooper.co.uk\">sage@pkfscs.co.uk<\/a>&nbsp;or give us a call on 01332 959008<\/strong> <\/p>\n","protected":false},"featured_media":3244,"parent":0,"menu_order":11,"template":"","solution_type":[50],"add_on_brand":[43],"add_on_industry":[],"add_on_purpose":[],"add_on_compatibility":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.10 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Power BI | Sage 200 | PKF Smith Cooper Systems<\/title>\n<meta name=\"description\" content=\"Microsoft Power BI for Sage 200 is here! PKF Smith Cooper Systems are Sage 200 experts. Contact us about connecting Power BI to your Sage 200 data 01332 959008\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Power BI | Sage 200 | PKF Smith Cooper Systems\" \/>\n<meta property=\"og:description\" content=\"Microsoft Power BI for Sage 200 is here! PKF Smith Cooper Systems are Sage 200 experts. Contact us about connecting Power BI to your Sage 200 data 01332 959008\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/\" \/>\n<meta property=\"og:site_name\" content=\"PKF Smith Cooper Systems\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-01T13:44:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/sage-live-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"911\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/\",\"url\":\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/\",\"name\":\"Microsoft Power BI | Sage 200 | PKF Smith Cooper Systems\",\"isPartOf\":{\"@id\":\"https:\/\/www.pkfscs.co.uk\/#website\"},\"datePublished\":\"2019-11-15T10:02:26+00:00\",\"dateModified\":\"2021-09-01T13:44:44+00:00\",\"description\":\"Microsoft Power BI for Sage 200 is here! PKF Smith Cooper Systems are Sage 200 experts. Contact us about connecting Power BI to your Sage 200 data 01332 959008\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pkfscs.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage Add Ons\",\"item\":\"https:\/\/www.pkfscs.co.uk\/sage-solutions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pkfscs.co.uk\/#website\",\"url\":\"https:\/\/www.pkfscs.co.uk\/\",\"name\":\"PKF Smith Cooper Systems\",\"description\":\"The Midlands&#039; leading Sage Strategic Partner\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pkfscs.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Power BI | Sage 200 | PKF Smith Cooper Systems","description":"Microsoft Power BI for Sage 200 is here! PKF Smith Cooper Systems are Sage 200 experts. Contact us about connecting Power BI to your Sage 200 data 01332 959008","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:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/","og_locale":"en_GB","og_type":"article","og_title":"Microsoft Power BI | Sage 200 | PKF Smith Cooper Systems","og_description":"Microsoft Power BI for Sage 200 is here! PKF Smith Cooper Systems are Sage 200 experts. Contact us about connecting Power BI to your Sage 200 data 01332 959008","og_url":"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/","og_site_name":"PKF Smith Cooper Systems","article_modified_time":"2021-09-01T13:44:44+00:00","og_image":[{"width":1280,"height":911,"url":"https:\/\/www.pkfscs.co.uk\/wp-content\/uploads\/sage-live-2.png","type":"image\/png"}],"twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/","url":"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/","name":"Microsoft Power BI | Sage 200 | PKF Smith Cooper Systems","isPartOf":{"@id":"https:\/\/www.pkfscs.co.uk\/#website"},"datePublished":"2019-11-15T10:02:26+00:00","dateModified":"2021-09-01T13:44:44+00:00","description":"Microsoft Power BI for Sage 200 is here! PKF Smith Cooper Systems are Sage 200 experts. Contact us about connecting Power BI to your Sage 200 data 01332 959008","breadcrumb":{"@id":"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pkfscs.co.uk\/sage-solutions\/microsoft-power-bi-for-sage-200\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pkfscs.co.uk\/"},{"@type":"ListItem","position":2,"name":"Sage Add Ons","item":"https:\/\/www.pkfscs.co.uk\/sage-solutions\/"},{"@type":"ListItem","position":3,"name":"Microsoft Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.pkfscs.co.uk\/#website","url":"https:\/\/www.pkfscs.co.uk\/","name":"PKF Smith Cooper Systems","description":"The Midlands&#039; leading Sage Strategic Partner","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pkfscs.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/solution\/4829"}],"collection":[{"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/solution"}],"about":[{"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/types\/solution"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/media\/3244"}],"wp:attachment":[{"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/media?parent=4829"}],"wp:term":[{"taxonomy":"solution_type","embeddable":true,"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/solution_type?post=4829"},{"taxonomy":"add_on_brand","embeddable":true,"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/add_on_brand?post=4829"},{"taxonomy":"add_on_industry","embeddable":true,"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/add_on_industry?post=4829"},{"taxonomy":"add_on_purpose","embeddable":true,"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/add_on_purpose?post=4829"},{"taxonomy":"add_on_compatibility","embeddable":true,"href":"https:\/\/www.pkfscs.co.uk\/wp-json\/wp\/v2\/add_on_compatibility?post=4829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}