{"id":883,"date":"2020-05-01T14:44:24","date_gmt":"2020-05-01T14:44:24","guid":{"rendered":"https:\/\/i-spark.nl\/?p=883"},"modified":"2026-01-02T11:01:27","modified_gmt":"2026-01-02T11:01:27","slug":"your-sap-data-in-an-easy-to-use-klipfolio-dashboard","status":"publish","type":"post","link":"https:\/\/i-spark.nl\/en\/blog\/your-sap-data-in-an-easy-to-use-klipfolio-dashboard\/","title":{"rendered":"Your SAP data in an easy to use Klipfolio dashboard"},"content":{"rendered":"

Do you use SAP Business One? Is it working for you on an operational level, but do you need to click 20 times before you get to the information you need to run your daily business? Would you like these insights in a light-weight, easy-to-use dashboard with a collection of graphs and tables of your choice? And would you be interested in having this dashboard up and running in a few weeks, instead of starting a business intelligence project that takes months and needs corporate budgets?<\/span><\/p>\n

Good news, we\u2019ve got you covered!<\/strong><\/span><\/h3>\n

We have designed and implemented several dashboards in Klipfolio<\/a> for clients running SAP Business One, both nationally and internationally. We have plenty of experience in determining the appropriate KPI\u2019s and designing the corresponding dashboards. And we also have knowledge of and over 15 years of experience in the SAP database specifically. We are aware it is huge and complex. Fortunately, we are familiar with the tables and relationships between these tables that are the bases of the most common KPI\u2019s, so we are confident we can help you quickly and efficiently.<\/span><\/p>\n

What might the project look like?<\/strong><\/h3>\n

If you know what KPI\u2019s you\u2019d like to report on, that\u2019s great. You could provide us with a list of your requirements and or wireframes and we can give you a quote. If you\u2019re not sure yet, we are happy to set up workshops with you to design the ultimate dashboard for your business.<\/span><\/p>\n

Then, from a technical point of view, we\u2019d need to connect Klipfolio to the database. The preferred route would be if you have an analysis database of SAP that we can connect to. This might be a copy of the production database that is updated every night. This copy might be stripped from personal identifiable information.<\/span>
\n<\/span>Next step is that we prepare the data by writing SQL queries to join all the necessary tables together. In this step we iterate back and forth until we get the right result to answer 1 or a few business questions.\u00a0<\/span><\/p>\n

The final step is to we use these queries in Klipfolio to create the data sources. Finally, we built the tables and graphs as designed in the design phase.<\/span><\/p>\n

How long does this take?<\/strong><\/h3>\n

It\u2019s a cliche, but it\u2019s true: it strongly depends on the requirements. If your requirements are clear and straightforward and the (anonimized) analyses database is accessible for us, and we have the right input for testing, we sometimes can get your first dashboard up and running in only a few days<\/strong>! <\/span><\/p>\n

Sounds interesting? Please feel free to contact us<\/a> to get acquainted and discuss your case. <\/span><\/p>\n

\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Do you use SAP Business One? Is it working for you on an operational level, but do you need to click 20 times before you get to the information you need to run your daily business? Would you like these insights in a light-weight, easy-to-use dashboard with a collection of graphs and tables of your […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[8],"tags":[296,184,295],"class_list":["post-883","post","type-post","status-publish","format-standard","hentry","category-blog","tag-dashboard-2","tag-klipfolio-2","tag-sap"],"acf":[],"_links":{"self":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts\/883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/comments?post=883"}],"version-history":[{"count":22,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts\/883\/revisions"}],"predecessor-version":[{"id":10170,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts\/883\/revisions\/10170"}],"wp:attachment":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/media?parent=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/categories?post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/tags?post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}