{"id":187893,"date":"2022-12-03T17:14:55","date_gmt":"2022-12-03T16:14:55","guid":{"rendered":"https:\/\/loudavymkrokem.cz\/?p=187893"},"modified":"2026-08-01T12:57:05","modified_gmt":"2026-08-01T10:57:05","slug":"business-intelligence-data-training","status":"publish","type":"post","link":"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/","title":{"rendered":"How to Make Sense of Your Business Data? Get Proper Data Training"},"content":{"rendered":"\n<!-- lk-tldr -->\n<div class=\"lk-tldr\" style=\"background:#f7f5f0;border-left:4px solid #c39f76;border-radius:0 10px 10px 0;padding:14px 18px;margin:0 0 26px;font-size:15px;line-height:1.65;\"><strong style=\"display:block;font-size:12px;text-transform:uppercase;letter-spacing:.06em;color:#a9885a;margin-bottom:5px;\">TL;DR<\/strong>The most effective way to get fluent in company data is a dedicated Business Intelligence course, like the one run by <strong>P\u0159emek Hor\u00e1\u010dek<\/strong> called &#8220;Take Your Data Analysis Beyond Excel&#8221; \u2013 it runs 8 hours and covers the basics of tools such as <strong>Keboola<\/strong>, Google BigQuery, PowerBI and Looker. The key skill is linking up scattered data sources (think Shoptet, Flexibee, Google Analytics, Facebook Ads) into one reporting system using SQL or R, both of which get covered on the course, and you&#8217;ll walk away with a handy command cheat sheet. That means you can build reports like RFM analysis, a cashflow dashboard or margin calculations for individual orders, without needing to become a programmer.<\/div>\n<!-- \/lk-tldr -->\n\n\n\n<p class=\"wp-block-paragraph\">I don&#8217;t attend training sessions often. Spending eight hours locked in a classroom is something I&#8217;d normally consider a waste of time. But that doesn&#8217;t apply to specialised data training that solves a concrete problem \u2014 and I definitely had one of those.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/#My_Problem_Loads_of_Business_Data_No_Idea_How_to_Work_With_It\" >My Problem: Loads of Business Data, No Idea How to Work With It<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/#Business_Intelligence_Running_a_Company_Based_on_Data\" >Business Intelligence: Running a Company Based on Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/#Keboola_A_Data_Extractor_for_Any_System\" >Keboola: A Data Extractor for Any System<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/#What_can_you_use_it_for\" >What can you use it for?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/#How_do_you_transform_the_data\" >How do you transform the data?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/#How_to_Visualise_Your_Data\" >How to Visualise Your Data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/loudavymkrokem.cz\/en\/business-intelligence-data-training\/#Links\" >Links<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"My_Problem_Loads_of_Business_Data_No_Idea_How_to_Work_With_It\"><\/span>My Problem: Loads of Business Data, No Idea How to Work With It<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">At <a href=\"https:\/\/www.nanospace.cz\" target=\"_blank\" rel=\"noopener\"><strong>nanoSPACE<\/strong><\/a>, our entire company is stitched together from dozens of separate tools \u2014 we don&#8217;t have a centralised system (like an ERP) running the show. <strong>This patchwork approach works well, handling tens of thousands of orders per month at a fraction of the cost of heavyweight solutions, but it comes with its own headaches.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The biggest one is data fragmentation.<\/strong> Orders land in Shoptet, returns go into Retino, email campaigns are sent via Ecomail, accounting documents flow into Flexibee, Amazon is managed through Expando, project management runs through <a href=\"https:\/\/loudavymkrokem.cz\/en\/freelo-review-project-management-tool\/\"><strong>Freelo<\/strong><\/a>, B2B orders are split between Shoptet and direct invoicing\u2026 I could keep going for a while.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And that&#8217;s without mentioning that <strong>Shoptet has no suitable module for deeper analysis of order or customer data<\/strong> \u2014 we can forget about RFM analysis entirely.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>All of this makes evaluating overall company performance incredibly difficult<\/strong>, and it&#8217;s led to us having at least a hundred Excel and Google Sheets files where we track various performance metrics separately, then painstakingly try to connect the dots.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After the last COVID wave, when things calmed down a bit, I had more time for analytics and started digging deeper into various reports, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Revenue \/ profit per marketing channel, adjusted for returns and refunds<\/li>\n\n\n\n<li>Tracking margin trends over time, down to individual product level<\/li>\n\n\n\n<li>Automated allocation of discount coupons and performance tracking<\/li>\n\n\n\n<li>RFM analysis, customer segmentation, cohorts\n<ul class=\"wp-block-list\">\n<li>Identifying traffic builders, etc.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Financial analysis, cost breakdown, cash flow monitoring and forecasting (e.g. automatically calculating the value of delivered but not yet paid cash-on-delivery orders)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Every single report meant hours of exporting and merging mismatched data in Excel \u2014 and even then, I couldn&#8217;t fully trust the results.<\/strong> I knew there was a proper way to build this from the ground up: connect data from all systems, clean out outliers, and report into PowerBI or Looker. <strong>But how on earth do you actually do that?<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Business_Intelligence_Running_a_Company_Based_on_Data\"><\/span>Business Intelligence: Running a Company Based on Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Right around that time, an invitation landed in my inbox for a data training course called <a href=\"https:\/\/academy.taste.cz\/posunte-svou-datovou-analyzu-za-hranice-excelu\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Take Your Data Analysis Beyond Excel<\/strong><\/a>. The course promised I&#8217;d finally learn how to bring order to my business, marketing, customer, and financial data. So off I went \ud83d\ude0e<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The training was spot-on for me!<\/strong> I&#8217;m not a complete data novice \u2014 we already have our own data warehouse, and we&#8217;d already built a few custom reports with <a href=\"https:\/\/digitalniarchitekti.cz\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Digit\u00e1ln\u00ed architekti<\/strong><\/a>. What I was missing was the bigger picture: an overview of what&#8217;s actually possible with the data flowing through our systems. And that&#8217;s exactly what I got from the course.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The training is led by <a href=\"https:\/\/academy.taste.cz\/premysl-horacek\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>P\u0159emek Hor\u00e1\u010dek<\/strong><\/a>, a seasoned Business Intelligence specialist. He makes a living connecting data sources for companies and uncovering the relationships hidden within them, helping his clients shift from gut-feeling decisions to data-driven management.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Keboola_A_Data_Extractor_for_Any_System\"><\/span>Keboola: A Data Extractor for Any System<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If I could take away just one thing from the training, it would be this: <strong>sign up for Keboola<\/strong>! Keboola is the tool I&#8217;d been searching for. It allows you to regularly pull data from virtually any source. Here&#8217;s what I connected:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Google Analytics<\/li>\n\n\n\n<li>Google Ads<\/li>\n\n\n\n<li>Facebook Ads<\/li>\n\n\n\n<li>Sklik<\/li>\n\n\n\n<li>Shoptet<\/li>\n\n\n\n<li>Flexibee<\/li>\n\n\n\n<li>Marketing Miner<\/li>\n\n\n\n<li>Google Sheets<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Keboola connects to each source via API and pulls the data you need.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once inside Keboola, you can transform the data (using SQL or R \u2014 P\u0159emek covers the basics during the training) and then save or export it to a storage solution. I export to Google BigQuery, but Google Sheets works too.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Transformations might include cleaning out extreme values (removing test orders, one-off orders worth \u20ac20,000, etc.), joining data from different tables using a shared ID, or any other manipulation your dataset needs.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_can_you_use_it_for\"><\/span><strong>What can you use it for?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For preparing data for virtually any report you can imagine. Here&#8217;s what I&#8217;ve done or have planned:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cleaning ad platform data by removing cancelled \/ returned orders<\/li>\n\n\n\n<li>Building an automated coupon report that calculates actual discounts given and resulting margins<\/li>\n\n\n\n<li>Calculating margins per order and bucketing them (grouping orders by size \/ profitability)<\/li>\n\n\n\n<li>RFM analysis on customer data pulled from Shoptet<\/li>\n\n\n\n<li>A cash flow dashboard enriched with cash-on-delivery data<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em>The training also covers Google BigQuery, a similar tool for data extraction and transformation. It may be better suited for certain use cases, but it&#8217;s not as intuitive for the average user.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_do_you_transform_the_data\"><\/span><strong>How do you transform the data?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Unfortunately, there&#8217;s no avoiding a bit of coding.<\/strong> Big data means big tables, so you&#8217;ll need at least basic SQL or R skills. Both are covered during the training, and afterwards we received a handy cheat sheet of essential commands. I have no ambition to master these languages in depth, but thanks to the course I now have enough understanding to know what to ask our data analysts for \u2014 and what&#8217;s realistic.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Keboola is also preparing templates for easy data extraction.<\/strong> This feature is still in beta, but it already offers several basic schemas for merging data from ad platforms and sending it to Google Sheets or PowerBI. <strong>For the most common use cases, you won&#8217;t need any coding at all in the near future.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Visualise_Your_Data\"><\/span><strong>How to Visualise Your Data?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once your data is prepped, you&#8217;ll want to visualise it \u2014 that&#8217;s the whole point, after all. Marketers will likely know Looker (formerly Google Data Studio), which I use extensively for all sorts of marketing reports.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">What impressed me more, though, was PowerBI, which I&#8217;d successfully ignored until now (mostly because it doesn&#8217;t run natively on Mac \ud83d\ude0e). After the training, I realised that Looker is essentially a demo version of PowerBI. While both platforms are constantly converging, PowerBI still has the edge.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a7bcdcdbb4e7&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a7bcdcdbb4e7\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.loudavymkrokem.cz\/wp-content\/uploads\/2023\/05\/bc-hospodareni-spolecnosti.png\" alt=\"Example of data visualisation in PowerBI\" class=\"wp-image-58411\" title=\"\"><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><figcaption class=\"wp-element-caption\">Example of data visualisation in PowerBI<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">I spent a total of 8 hours at the data training, and I consider it a solid investment. I walked away with a completely new perspective on business data and how to work with it. In my spare time, I&#8217;ve been experimenting with building my own reports and gradually preparing a new brief for <a href=\"https:\/\/digitalniarchitekti.cz\" target=\"_blank\" rel=\"noopener\">Digit\u00e1ln\u00ed architekti<\/a>, because I can feel it&#8217;s time to take our analytics to the next level \ud83d\ude0e<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Links\"><\/span>Links<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/academy.taste.cz\" target=\"_blank\" rel=\"noopener\"><strong>Taste Academy<\/strong><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/academy.taste.cz\/posunte-svou-datovou-analyzu-za-hranice-excelu\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Link to the course and upcoming dates<\/strong><\/a><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/www.linkedin.com\/company\/tastecz\/\" target=\"_blank\" rel=\"noreferrer noopener\">Taste LinkedIn<\/a><\/strong><\/li>\n\n\n\n<li><a href=\"https:\/\/www.linkedin.com\/in\/p\u0159emysl-hor\u00e1\u010dek-1ab6a3139\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>P\u0159emek Hor\u00e1\u010dek<\/strong><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I don&#8217;t attend training sessions often \u2014 spending eight hours locked in a classroom usually feels like wasted time. But specialised data training that solves a real problem? That&#8217;s a completely different story.<\/p>\n","protected":false},"author":2,"featured_media":59692,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","rank_math_title":"Business Intelligence Data Training: A Hands-On Review","rank_math_description":"Struggling with fragmented business data? Discover how data training helped me build better reports with Keboola and PowerBI. Read my honest review here!","rank_math_focus_keyword":"data training","rank_math_seo_score":""},"categories":[324],"tags":[],"class_list":["post-187893","post","type-post","status-publish","format-standard","has-post-thumbnail","category-marketing"],"acf":[],"featured_image_src":"https:\/\/loudavymkrokem.cz\/wp-content\/uploads\/2023\/05\/bc-hospodareni-spolecnosti.png","author_info":{"display_name":"Luk\u00e1\u0161 Kone\u010dn\u00fd","author_link":"https:\/\/loudavymkrokem.cz\/en\/author\/lukas-konecny\/"},"_links":{"self":[{"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/posts\/187893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/comments?post=187893"}],"version-history":[{"count":0,"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/posts\/187893\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/media\/59692"}],"wp:attachment":[{"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/media?parent=187893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/categories?post=187893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/loudavymkrokem.cz\/en\/wp-json\/wp\/v2\/tags?post=187893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}