{"id":2195,"date":"2014-03-24T11:03:00","date_gmt":"2014-03-24T11:03:00","guid":{"rendered":"https:\/\/www.dab-europe.com\/\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/"},"modified":"2025-03-11T12:41:05","modified_gmt":"2025-03-11T12:41:05","slug":"ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment","status":"publish","type":"articles","link":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/","title":{"rendered":"CCM (Part 5) &#8211; 5 things you should know &#8211; and 2 things you better not forget &#8211; when building a CCM data analytic environment"},"content":{"rendered":"<h2>CCM (Part 5) &#8211; 5 things you should know &#8211; and 2 things you better not forget &#8211; when building a CCM data analytic environment<\/h2>\n<p class=\"align-justify\">This post is part five of a bigger article which is titled \u201c5 things you should know &#8211; and 2 things you better not forget &#8211; when building a data analytic environment\u201d. It is about data analytics in general, but with a focus on building bigger solutions like a CCM (Continuous Controls Monitoring Environment). The full article contains of several parts. The first five describe attention points that you should be aware of: <\/p>\n<ol>\n<li><a href=\"t3:\/\/page?uid=139\">Know what you want to know (aka list analytic questions)<\/a><\/li>\n<li><a href=\"t3:\/\/page?uid=140\">Know your systems (aka identify data sources)<\/a><\/li>\n<li><a href=\"t3:\/\/page?uid=141\">Know your data (aka examine data structures)<\/a><\/li>\n<li><a href=\"t3:\/\/page?uid=142\">Know your Analytic Tools (aka understand technical possibilities and limits)<\/a><\/li>\n<li>Know your customers (aka think about who receives the results and what they will do with it)<\/li>\n<\/ol>\n<p class=\"align-justify\">Part six and seven are about two things that you probably already know, but we emphasize their importance in the context of data analytics: <\/p>\n<ol>\n<li><a href=\"t3:\/\/page?uid=144\">There is a price tag to it (aka budget) <\/a><\/li>\n<li><a href=\"t3:\/\/page?uid=144\">You need someone who can do it (aka resources) <\/a><\/li>\n<\/ol>\n<p class=\"align-justify\">Part 1-4 have already been covered (they are linked above, so you can go back anytime there). This is now part 5, \u201cKnow your customers\u201d: <\/p>\n<h2>Five things you should know, continued (5\/5) <\/h2>\n<p class=\"align-justify\">We do continue with the fifth aspect out of the five things that I see as \u201cessential\u201d. The first step, labeled \u201cKnow what you want to know\u201d, was about a getting proper business understanding and stating as-detailed-as-possible questions that can actually be answered. Only by knowing your business well you can make a good list of analytic questions. The area we were interested in was \u201cCompliance\u201d, the topic \u201cPayments to critical countries\u201d and the detail questions that were raised we stated as follows: <\/p>\n<ul>\n<li class=\"align-justify\">\u201cIdentify payment transactions that have been done in context of partners like vendors, or customers, or even where an expense account is directly debited. <\/li>\n<li class=\"align-justify\">Create a list of these transactions and identify the payee\u2019s bank country for those payments. <\/li>\n<li class=\"align-justify\">Match these detail transactions versus a list of countries that are seen as critical because they are on the embargo list, known as tax haven or having a Corruption Perception Index &gt; x.\u201d   <\/li>\n<\/ul>\n<p class=\"align-justify\">In step two we talked about the importance to \u201cKnow your systems\u201d. We found out that our payment data is on an SAP\u00ae system \u201cSY2\u201d, running SAP\u00ae ERP ECC 6.0, and containing the financial transactions for all companies worldwide. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/2024\/04\/20140318_DA_CCM_5things_2things_Part4_E_01.png\" \/><\/p>\n<p class=\"align-justify\">Based on that we found out about the data ownership and then followed the process of requesting a user with appropriate read-only rights to access the data. <\/p>\n<p class=\"align-justify\">What data actually is necessary, we discovered in chapter \u201cKnow your data\u201d. We went from identifying the tables to finally identifying fields and understanding the logic and relations between the tables.  Part of that was an explanation of different techniques how to find the data, and the top down approach. We ended up with a list of tables and fields, which for our example could look like this: <\/p>\n<table>\n<tbody>\n<tr>\n<td class=\"align-left\"><b>Element \/ Process steps<br \/><\/b><\/td>\n<td class=\"align-left\"><b>Table<br \/><\/b><\/td>\n<td class=\"align-left\"><b>Field(s)<br \/><\/b><\/td>\n<td class=\"align-left\"><b>Comment<br \/><\/b><\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Vendor master data<\/td>\n<td class=\"align-left\">LFA1<\/td>\n<td class=\"align-left\">LIFNR<\/td>\n<td class=\"align-left\">Vendor number<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Vendor master data<\/td>\n<td class=\"align-left\">LFA1<\/td>\n<td class=\"align-left\">LAND1<\/td>\n<td class=\"align-left\">Vendor country of residence<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Vendor bank accounts<\/td>\n<td class=\"align-left\">LFBK<\/td>\n<td class=\"align-left\">LIFNR<\/td>\n<td class=\"align-left\">Vendor number<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Vendor bank accounts<\/td>\n<td class=\"align-left\">LFBK<\/td>\n<td class=\"align-left\">BANKS<\/td>\n<td class=\"align-left\">Vendor bank country<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Customer master data<\/td>\n<td class=\"align-left\">KNA1<\/td>\n<td class=\"align-left\">KUNNR<\/td>\n<td class=\"align-left\">Customer number<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Customer master data<\/td>\n<td class=\"align-left\">KNA1<\/td>\n<td class=\"align-left\">LAND1<\/td>\n<td class=\"align-left\">Customer country of residence<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Customer bank accounts<\/td>\n<td class=\"align-left\">KNBK<\/td>\n<td class=\"align-left\">BANKS<\/td>\n<td class=\"align-left\">Customer bank country<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Customer bank accounts<\/td>\n<td class=\"align-left\">KNBK<\/td>\n<td class=\"align-left\">KUNNR<\/td>\n<td class=\"align-left\">Customer number<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Payment run transactions<\/td>\n<td class=\"align-left\">REGUH<\/td>\n<td class=\"align-left\">LIFNR<\/td>\n<td class=\"align-left\">Vendor number<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">TPayment run transactions<\/td>\n<td class=\"align-left\">REGUH<\/td>\n<td class=\"align-left\">KUNNR<\/td>\n<td class=\"align-left\">Customer number<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Payment run transactions<\/td>\n<td class=\"align-left\">REGUH<\/td>\n<td class=\"align-left\">LAND1<\/td>\n<td class=\"align-left\">Vendor country of residence<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Payment run transactions<\/td>\n<td class=\"align-left\">REGUH<\/td>\n<td class=\"align-left\">ZLAND<\/td>\n<td class=\"align-left\">Payees country of residence<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Payment run transactions<\/td>\n<td class=\"align-left\">REGUH<\/td>\n<td class=\"align-left\">ZBNKS<\/td>\n<td class=\"align-left\">Payees bank country<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">&#8230;<\/td>\n<td class=\"align-left\">&#8230;<\/td>\n<td class=\"align-left\">&#8230;<\/td>\n<td class=\"align-left\">&#8230;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Picture 2 &#8211; Examine data structure: Table and Field list<\/p>\n<p>We know the question, we know where the data for the answer is stored and we are also aware what data is necessary. The attention points regarding the tools for data extraction and the analytic tool are defined as well. The most important aspects are listed in the following checklist:<\/p>\n<p class=\"align-justify\">&nbsp;<\/p>\n<p class=\"align-justify\">\n<table>\n<tbody>\n<tr>\n<td class=\"align-left\"><b>Data Extraction Tool<br \/><\/b><\/td>\n<td class=\"align-left\"><b>Data Analytic Tool<br \/><\/b><\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Mass data capability<\/td>\n<td class=\"align-left\">Mass data Capability<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Performance<\/td>\n<td class=\"align-left\">Performance<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Read-only access<\/td>\n<td class=\"align-left\">Read-only access<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Delta-Downloads<\/td>\n<td class=\"align-left\">Client\/Server capability<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Automization<\/td>\n<td class=\"align-left\">Automization<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Usability<\/td>\n<td class=\"align-left\">Usability<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Correct target formats<\/td>\n<td class=\"align-left\">Transparency<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Data privacy<\/td>\n<td class=\"align-left\">Content<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td class=\"align-left\">Output formats<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Picture 3 &#8211; Checklist for data extraction and analytic tool<\/p>\n<p class=\"align-justify\">&nbsp;<\/p>\n<p class=\"align-justify\">At the end of part four of this series, we briefly discussed the meaning of having different output formats.  As you may get different requirements from different types of \u201cresult consumers\u201d, certain flexibility is important. <\/p>\n<p class=\"align-justify\">You have a manager who only needs KPI information; on the other hand you have an accountant who should look up the details. Which types of result consumers you might encounter, and what this means for our example scenario of \u201cPayments to critical countries\u201d will be looked at in detail now: <\/p>\n<h2>Aspect 5: Know who are the &#8220;internal customers&#8221;<\/h2>\n<p class=\"align-justify\">To start we will describe the potential process of working with data analytic results and its technical aspects. We will use this to approach to the \u201ccustomers\u201d (you could also say, \u201cAudience\u201d) which we might encounter, and label them. <\/p>\n<p class=\"align-justify\">The base for this is still our analytic question \u201ePayments to critical countries\u201c, which creates a table of outgoing payments and matches those with a list of countries that are potentially critical. As this will happen in context of a CCM project, this test will be run regularly (for example on a weekly base). <\/p>\n<p class=\"align-justify\">When it comes to the results that are generated, at least two questions arise: <\/p>\n<ol>\n<li>What to do with the results? <\/li>\n<li>What datasize is expected? <\/li>\n<\/ol>\n<p class=\"align-justify\">The results could be used solely as \u201eFYI\u201c, and\/or as initial point for follow-up actions. These follow-up-actions could be only \u201edescriptive\u201c, or a pile of tasks that actually should be worked off. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/2024\/04\/20140325_DA_CCM_5things_2things_Part5_E_02.png\" \/><\/p>\n<p class=\"align-justify\">If the focus is on the \u201eFYI\u201c aspect, then usually a pretty abstract level is enough for generating an overview. If 263 single payment transactions happened last week, usually those do not need to be listed in detail. It can be enough to state that \u201cIn calendar week 12 in total 263 payment transactions (out of 12.571, so 2.09% of count) to bank accounts in critical countries were recorded with a critical payment volume of 6,4 Million Euros (of a total of 639,9 Million Euros, so around 1,00% of value).\u201d If this information is put on a timeline for every week, meaningful high-level diagrams can be created based on that.  But maybe, in certain constellations, questions may arise that need to be addressed (see \u201cQuestioning\u201d in picture 4). <\/p>\n<p class=\"align-justify\">If however the data analytic results are the base for follow-up actions, those actions can be analytic ones or operative ones. <\/p>\n<p class=\"align-justify\">\u201cAnalytic\u201d (this is labeled in picture 4 as \u201eDigging deeper\u201c) means that the 263 single payment transactions to critical countries are used as base for more in-depth analytics: Who received the money, was it a customer, a vendor, a partner company, employees or a public sector institution? What cost category had been assigned to those liabilities in accounting? <\/p>\n<p class=\"align-justify\">\u201cOperative\u201d means that each single result record actually gets processed and needs to be ticked off (\u201cWorking off\u201d in chapter 4). In our example, for each one of the 263 payment transactions the person who was responsible will need to be identified and the compliance of that business transaction needs to be checked and documented. Only when this is finished, that record gets ticked as \u201cdone\u201d.  <\/p>\n<p class=\"align-justify\">OK, so we have an understanding of the first point regarding the question \u201cWhat to do with the results\u201d. The second point \u201cWhat data size is expected?\u201d may in fact influence that. If the intention is to use the results \u201cFYI only\u201d then it will be irrelevant for if there are 263 or 2630 results in that result set \u2013 it will be summarized to one or two sentences anyway, and that\u2019s it. For the aspect of \u201cdigging deeper\u201d this should not be a problem as well; it only has an impact once the <a target=\"_blank\" href=\"https:\/\/support.office.com\/en-us\/article\/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?CorrelationId=b7b7776c-17c2-481f-9dd4-c37fee300cb2&amp;ui=en-US&amp;rs=en-US&amp;ad=US&amp;ocmsassetID=HP010342495\" rel=\"noopener\">result size is bigger than one a standard tool like Microsoft Excel\u2122 actually is able to handle<\/a>. In that case we still have the option of use our analytic tool here, with which we might be better off for the ad-hoc analytics anyway (Remember: The ability to deal with mass data and good usability were two of the criteria). <\/p>\n<p class=\"align-justify\">The biggest impact of a huge result set will be for the \u201eWorking off\u201c  aspect. <\/p>\n<p class=\"align-justify\">It is difficult (if not impossible) to have an accounting clerk checking thousands of transactions in detail \u2013 keep in mind that new ones will come in every week, as this happens in a CCM environment. In such cases there will be the need for limiting the results. This can happen by filtering it afterwards, and only look at transactions over a certain monetary threshold. It is a matter of taste whether this happens upfront and gets implemented in the analytic logic already, or afterwards when looking at the result. <\/p>\n<p class=\"align-justify\">How to proceed with the results usually is not an either\/or decision. Depending on organizational structure or internal processes often all of the approaches listed above are necessary. This leads us to the different types of (internal) customers. To keep it simple, we differ between three main roles of analytic result consumers: <\/p>\n<ol>\n<li>Manager \/ Decision Maker <\/li>\n<li>Business Analyst <\/li>\n<li>Accounting clerk <\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140325_DA_CCM_5things_2things_Part5_E_03.png\" \/><\/p>\n<ul>\n<li class=\"align-justify\">The <i>Manager \/ Decision<\/i> maker needs information on C-level. The results must enable him to identify trends, recognize and evaluate risks and anomalies and make decisions based on that. Usually he needs a bird\u2019s eye view on the topics. <\/li>\n<\/ul>\n<ul>\n<li class=\"align-justify\">The <i>Business Analyst<\/i> uses the detail records of the results as well, plus uses summarized information. He creates, sometimes based on the demand of the manager, additional aggregations and consolidations. Similar to a controller he answers various questions on and around certain topics, but with a wider focus than just internal and external financial aspects. \u201cWhy do we have a peak of critical transactions in week 10?\u201c, \u201eDoes the result reflect the structure and global allocation of our vendors and customers?\u201c \u201cIs the increasing volume caused by only a few but highly material transactions, or is the count of payment transactions increasing in general?\u201d All these questions can be answered by the business analyst. Standard questions can already be part of the automated CCM analytics, others he might need to do ad-hoc, based on demand. <\/li>\n<\/ul>\n<ul>\n<li class=\"align-justify\">The <i>Accounting Clerk<\/i> mainly works on detail level. He double-checks the paper documentation, audits the authorizations if all has been signed correctly. To do this he usually needs a lot of very specific information.<\/li>\n<\/ul>\n<p class=\"align-justify\">So there are different ways how to deal with the results, and there are different people on different levels working on those. This leads us to the technical aspects: Now that we do know the \u201einternal customers\u201c and their different approaches how to use the results, we can tailor the scope and layout or format of the results for them: <\/p>\n<p class=\"align-justify\">&nbsp;<\/p>\n<p class=\"align-justify\">\n<table>\n<tbody>\n<tr>\n<td class=\"align-left\"><b>Result consumer<br \/><\/b><\/td>\n<td class=\"align-left\"><b>Graphics<br \/><\/b><\/td>\n<td class=\"align-left\"><b>Detail level<br \/><\/b><\/td>\n<td class=\"align-left\"><b>Tools<br \/><\/b><\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Decision Maker<\/td>\n<td class=\"align-left\">Solely<\/td>\n<td class=\"align-left\">Birds view perspective<\/td>\n<td class=\"align-left\">Dashboard<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Business Analyst<\/td>\n<td class=\"align-left\">Partly<\/td>\n<td class=\"align-left\">Summarizes and Details<\/td>\n<td class=\"align-left\">Analytic tool<\/td>\n<\/tr>\n<tr>\n<td class=\"align-left\">Accounting Clerk<\/td>\n<td class=\"align-left\">No<\/td>\n<td class=\"align-left\">Detail level<\/td>\n<td class=\"align-left\">Exception Management, Excel<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Picture 6 &#8211; Result consumer overview<\/p>\n<p class=\"align-justify\">&nbsp;<\/p>\n<p class=\"align-justify\">As we now know about our \u201einternal customers\u201c (audience), we should apply the rule of thumb \u201eReduce to the max\u201c (A marketing slogan of Mercedes-Benz for the SMART) when creating the results. <\/p>\n<p class=\"align-justify\">Our audience needs to get all relevant information which allows them to proceed and use the results as intended. However \u201cinformation overkill\u201d needs to be avoided, which sometimes is not so easy in times of \u201cBig data\u201d. The best idea is probably to put yourself in the position of the different customers types and think through how they have to work with the results: <\/p>\n<ul>\n<li class=\"align-justify\">Would the decision maker only receive the statement  \u201cIn calendar week 12 in total 263 payment transactions to bank accounts in critical countries were recorded.\u201c  he would ask immediately \u201cWhat money are we talking about here? \u201d So it is always a good idea to add the materiality, for example: \u201cIn calendar week 12 in total 263 payment transactions to bank accounts in critical countries were recorded with a critical payment volume of 6,4 Million Euros.\u201d Also, adding ratios can be a very useful thing, and helps to understand what part of the total count and monetary amount of the transaction is concerned: \u201cIn calendar week 12 in total 263 payment transactions (out of 12.571, so 2.09% of count) to bank accounts in critical countries were recorded with a critical payment volume of 6,4 Million Euros (of a total of 639,9 Million Euros, so around 1,00% of value).\u201d <\/li>\n<\/ul>\n<ul>\n<li class=\"align-justify\">The Business analyst needs additional contextual information in his data. What is the country of residence of customers, vendors and partners? What cost types have been assigned to these transactions?  If this is provided, he can perform additional in-depth analytics ad-hoc. <\/li>\n<\/ul>\n<ul>\n<li class=\"align-justify\">To enable the Accounting Clerk to look up a financial document in SAP\u00ae, he needs to have detailed information about company code, fiscal year and document number. He can then directly look at that document, and maybe he is able to access a PDF attachment from that starting point which is stored in the optical archive.<\/li>\n<\/ul>\n<p class=\"align-justify\">Bottom line:  \u201cCorrect output\u201d does not automatically make a \u201cgood result\u201d. A good result gets created by tailoring the correct output for the target audience. To be able to do this, that audience needs to be identified upfront. <\/p>\n<p class=\"align-justify\">If we take our 5 things as checklist, currently we managed to solve all five steps: <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140325_DA_CCM_5things_2things_Part5_E_04.png\" \/>Now that all five prerequisites are covered, we \u201conly\u201d have to implement the CCM project. In the next (and probably last) part of this series we talk about two things that you probably already know, but they are so important that we need to have a closer look at them:<\/p>\n<ol>\n<li>There is a price tag to it (aka budget) <\/li>\n<li>You need someone who can do it (aka resources) <\/li>\n<\/ol>\n<p class=\"align-justify\">I hope you enjoyed this forth part of our CCM articles! For any comments or questions, feel free to write us at <a href=\"mailto:info@dab-gmbh.de\">info@dab-gmbh.de<\/a>.<\/p>\n<p class=\"align-justify\">To contact the author you can also use LinkedIn or XING (you may have to login first before you can access these links). <\/p>\n<p class=\"align-justify\">LinkedIn: <a target=\"_blank\" href=\"http:\/\/de.linkedin.com\/pub\/stefan-wenig\/54\/1b8\/b30\" rel=\"noopener\">http:\/\/de.linkedin.com\/pub\/stefan-wenig\/54\/1b8\/b30 <\/a><\/p>\n<p class=\"align-justify\">XING: <a target=\"_blank\" href=\"https:\/\/www.xing.com\/profile\/Stefan_Wenig2?sc_o=mxb_p\" rel=\"noopener\">https:\/\/www.xing.com\/profile\/Stefan_Wenig2?sc_o=mxb_p <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CCM (Continuous Controls Monitoring) System &#8211; The first five parts describe points that must be familiar with data analysis projects.<\/p>\n","protected":false},"author":2,"featured_media":4694,"template":"","articles_category":[],"articles_tag":[91,92,94,95,99],"class_list":["post-2195","articles","type-articles","status-publish","has-post-thumbnail","hentry","articles_tag-data-analytics","articles_tag-sap","articles_tag-internal-audit","articles_tag-iks","articles_tag-data-extraction"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>CCM \u2013 Five things you should know about CCM part 5<\/title>\n<meta name=\"description\" content=\"CCM data analysis: 5 important things \u2713 2 things not to forget \u2713 Avoid common mistakes \u2713 Optimization tips \u2013 Read part 5!\" \/>\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.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CCM \u2013 Five things you should know about CCM part 5\" \/>\n<meta property=\"og:description\" content=\"CCM data analysis: 5 important things \u2713 2 things not to forget \u2713 Avoid common mistakes \u2713 Optimization tips \u2013 Read part 5!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/\" \/>\n<meta property=\"og:site_name\" content=\"dab\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T12:41:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0396-1024x683.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"683\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/\",\"name\":\"CCM \u2013 Five things you should know about CCM part 5\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0396-scaled.jpg\",\"datePublished\":\"2014-03-24T11:03:00+00:00\",\"dateModified\":\"2025-03-11T12:41:05+00:00\",\"description\":\"CCM data analysis: 5 important things \u2713 2 things not to forget \u2713 Avoid common mistakes \u2713 Optimization tips \u2013 Read part 5!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0396-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0396-scaled.jpg\",\"width\":2560,\"height\":2327},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CCM (Part 5) &#8211; 5 things you should know &#8211; and 2 things you better not forget &#8211; when building a CCM data analytic environment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"name\":\"dab\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\",\"name\":\"dab\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"width\":2560,\"height\":1463,\"caption\":\"dab\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CCM \u2013 Five things you should know about CCM part 5","description":"CCM data analysis: 5 important things \u2713 2 things not to forget \u2713 Avoid common mistakes \u2713 Optimization tips \u2013 Read part 5!","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.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/","og_locale":"en_US","og_type":"article","og_title":"CCM \u2013 Five things you should know about CCM part 5","og_description":"CCM data analysis: 5 important things \u2713 2 things not to forget \u2713 Avoid common mistakes \u2713 Optimization tips \u2013 Read part 5!","og_url":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/","og_site_name":"dab","article_modified_time":"2025-03-11T12:41:05+00:00","og_image":[{"width":1024,"height":683,"url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0396-1024x683.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/","url":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/","name":"CCM \u2013 Five things you should know about CCM part 5","isPartOf":{"@id":"https:\/\/www.dab-europe.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/#primaryimage"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0396-scaled.jpg","datePublished":"2014-03-24T11:03:00+00:00","dateModified":"2025-03-11T12:41:05+00:00","description":"CCM data analysis: 5 important things \u2713 2 things not to forget \u2713 Avoid common mistakes \u2713 Optimization tips \u2013 Read part 5!","breadcrumb":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/#primaryimage","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0396-scaled.jpg","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0396-scaled.jpg","width":2560,"height":2327},{"@type":"BreadcrumbList","@id":"https:\/\/www.dab-europe.com\/en\/articles\/ccm-part-5-5-things-you-should-know-and-2-things-you-better-not-forget-when-building-a-ccm-data-analytic-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dab-europe.com\/en\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.dab-europe.com\/en\/articles\/"},{"@type":"ListItem","position":3,"name":"CCM (Part 5) &#8211; 5 things you should know &#8211; and 2 things you better not forget &#8211; when building a CCM data analytic environment"}]},{"@type":"WebSite","@id":"https:\/\/www.dab-europe.com\/en\/#website","url":"https:\/\/www.dab-europe.com\/en\/","name":"dab","description":"","publisher":{"@id":"https:\/\/www.dab-europe.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dab-europe.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dab-europe.com\/en\/#organization","name":"dab","url":"https:\/\/www.dab-europe.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","width":2560,"height":1463,"caption":"dab"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles\/2195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles"}],"about":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/types\/articles"}],"author":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/users\/2"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media\/4694"}],"wp:attachment":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media?parent=2195"}],"wp:term":[{"taxonomy":"articles_category","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_category?post=2195"},{"taxonomy":"articles_tag","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_tag?post=2195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}