{"id":842,"date":"2014-12-05T15:18:59","date_gmt":"2014-12-05T20:18:59","guid":{"rendered":"https:\/\/solutionsreview.com\/business-intelligence\/?p=842"},"modified":"2016-10-04T13:14:18","modified_gmt":"2016-10-04T17:14:18","slug":"why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/","title":{"rendered":"Why It’s a Bad Idea to Build a Business Intelligence Platform from Scratch"},"content":{"rendered":"

\"Why<\/a>In the past, I\u2019ve read many articles that support that building BI is actually better than buying it and some of the top reasons for this are 1) company-issued BI do not have all of the data needed 2) Company-issued BI tools don\u2019t have the right models, relationships, attributes, and hierarchies 3) Company-issued BI tools are too restrictive in their data models.<\/p>\n

So when I recently came across an article that contested this idea and supported the idea of\u00a0buying BI versus building it, I felt the need to bring it front and center. The name of the article is \u201cBuild vs Buy: Business Intelligence for Big Data Analytics<\/a>,\u201d written by Dwight deVara. In this article, Mr. deVara cited a large and extensive BI project that resulted in a fairly crude BI application. deVara described,<\/p>\n

+ Check Out a Free\u00a02015 Business Intelligence Tools Buyers Guide<\/a><\/strong><\/p>\n

\u201cA friend of mine is a Python developer for a billion-dollar corporation. His team is building a custom call center reporting app that connects to the company’s cloud data storage via APIs. I’ve seen some of the application and while it’s impressive for a custom system, it’s mostly tables of numbers with the occasional pie chart. This is after 8 months of work, and the only people accessing the system are a select few big data scientists.\u201d<\/p>\n

deVara then goes on to talk about why buying BI is easier and presents steps\u00a0that make building BI cumbersome and difficult. deVara explained,<\/p>\n

\u201cSome companies are going down the road of custom BI platform development, but their efforts are no match for solutions that are already available. Below is a list of what you’d need to do to build a BI platform from scratch. You’ll quickly see why the effort and expense aren’t worthwhile.\u201d<\/p>\n

Step 1: Hire a team<\/p>\n

Step 2: Add security<\/p>\n

Step 3: Build an analytical engine<\/p>\n

Step 4: Use connection pooling<\/p>\n

Step 5: Take out the trash<\/p>\n

Step 6: Add visualization<\/p>\n

Click here<\/a> to read the full article and get full descriptions for steps on this list.<\/p>\n

\t\t\t

\"Insight<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n

<\/h3>\n","protected":false},"excerpt":{"rendered":"

In the past, I\u2019ve read many articles that support that building BI is actually better than buying it and some of the top reasons for this are 1) company-issued BI do not have all of the data needed 2) Company-issued BI tools don\u2019t have the right models, relationships, attributes, and hierarchies 3) Company-issued BI tools […]<\/p>\n","protected":false},"author":1,"featured_media":866,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[4],"tags":[],"acf":[],"yoast_head":"\nWhy It's a Bad Idea to Build a Business Intelligence Platform from Scratch | Solutions Review<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Doug Atkinson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/\",\"name\":\"Why It's a Bad Idea to Build a Business Intelligence Platform from Scratch | Solutions Review\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2014\/12\/Why-Its-a-Bad-Idea-to-Build-a-Business-Intelligence-Platform-from-Scratch.jpg\",\"datePublished\":\"2014-12-05T20:18:59+00:00\",\"dateModified\":\"2016-10-04T17:14:18+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae\"},\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2014\/12\/Why-Its-a-Bad-Idea-to-Build-a-Business-Intelligence-Platform-from-Scratch.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2014\/12\/Why-Its-a-Bad-Idea-to-Build-a-Business-Intelligence-Platform-from-Scratch.jpg\",\"width\":600,\"height\":270,\"caption\":\"Why Its a Bad Idea to Build a Business Intelligence Platform from Scratch\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/business-intelligence\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why It’s a Bad Idea to Build a Business Intelligence Platform from Scratch\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/\",\"name\":\"Best Business Intelligence and Data Analytics Tools, Software, Solutions & Vendors\",\"description\":\"BI Guides, Analysis and Best Practices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/business-intelligence\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae\",\"name\":\"Doug Atkinson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g\",\"caption\":\"Doug Atkinson\"},\"description\":\"An entrepreneur and executive with a passion for enterprise technology, Doug founded Solutions Review in 2012. He has previously served as a newspaper boy, a McDonald's grill cook, a bartender, a political consultant, a web developer, the VP of Sales for e-Dialog - a digital marketing agency - and as Special Assistant to Governor William Weld of Massachusetts.\",\"sameAs\":[\"https:\/\/solutionsreview.com\"],\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/author\/doug-atkinson-4\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why It's a Bad Idea to Build a Business Intelligence Platform from Scratch | Solutions Review","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:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/","twitter_misc":{"Written by":"Doug Atkinson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/","url":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/","name":"Why It's a Bad Idea to Build a Business Intelligence Platform from Scratch | Solutions Review","isPartOf":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2014\/12\/Why-Its-a-Bad-Idea-to-Build-a-Business-Intelligence-Platform-from-Scratch.jpg","datePublished":"2014-12-05T20:18:59+00:00","dateModified":"2016-10-04T17:14:18+00:00","author":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae"},"breadcrumb":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#primaryimage","url":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2014\/12\/Why-Its-a-Bad-Idea-to-Build-a-Business-Intelligence-Platform-from-Scratch.jpg","contentUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2014\/12\/Why-Its-a-Bad-Idea-to-Build-a-Business-Intelligence-Platform-from-Scratch.jpg","width":600,"height":270,"caption":"Why Its a Bad Idea to Build a Business Intelligence Platform from Scratch"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/business-intelligence\/why-its-a-bad-idea-to-build-a-business-intelligence-platform-from-scratch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/business-intelligence\/"},{"@type":"ListItem","position":2,"name":"Why It’s a Bad Idea to Build a Business Intelligence Platform from Scratch"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website","url":"https:\/\/solutionsreview.com\/business-intelligence\/","name":"Best Business Intelligence and Data Analytics Tools, Software, Solutions & Vendors","description":"BI Guides, Analysis and Best Practices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/business-intelligence\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae","name":"Doug Atkinson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g","caption":"Doug Atkinson"},"description":"An entrepreneur and executive with a passion for enterprise technology, Doug founded Solutions Review in 2012. He has previously served as a newspaper boy, a McDonald's grill cook, a bartender, a political consultant, a web developer, the VP of Sales for e-Dialog - a digital marketing agency - and as Special Assistant to Governor William Weld of Massachusetts.","sameAs":["https:\/\/solutionsreview.com"],"url":"https:\/\/solutionsreview.com\/business-intelligence\/author\/doug-atkinson-4\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/842"}],"collection":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/comments?post=842"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/842\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media\/866"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media?parent=842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/categories?post=842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/tags?post=842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}