![\"infocomposerbanner\"](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2011\/11\/infocomposerbanner.jpg?resize=690%2C310&ssl=1\" "\\"infocomposerbanner\\"")
<\/p>\n<\/p>\n
I started my career talking about self-service BI, with a product called \u201cSkipper SQL\u201d that let business people flexibly access information using the \u201cobjects\u201d of their business: \u2013 sales, revenue, products, customer, etc. (you can probably guess what the product name changed to). For the first time, you didn\u2019t need to be a computer expert to access data.<\/p>\n
But on the back end, it has always been the job of an\u00a0 expert to actually gather the data and put it in a format that people could use to access the data (data mart, data warehouse, OLAP cube\u2026). In large part, this has been because of the complexity of creating a data warehouse that is robust enough to provide fast, convenient access.<\/p>\n
But newer in-memory architectures like SAP HANA<\/a> are eliminating a lot of the need for redundant layers<\/a>, and making it easy to analyze detailed, on-optimized data sets. This, in turn, makes it easier to allow business people and departments to gather their own data, upload it, and combine\/compare it with corporate sources.<\/p>\n Some of these solutions are separate, add-on solutions to the central corporate environment (such as Excel or PowerPivot). These meet the basic business need, but create new problems in the form of new data silos that have to be managed and secured. These types of solutions have resulted in business-led \u201crogue\u201d BI implementations, created when central BI is too slow to provide more central solutions. These are the BI equivalent of fast-food: we know it\u2019s bad for us in the long term, but they are at least better than going hungry.<\/p>\n The better solution would be a “balanced diet” — to provide a centralized, corporate environment that not only provides trusted, secure corporate data, but also provides \u201csandboxes\u201d or \u201cuser areas\u201d that let business people upload and manage their own data on the same system. This has been a recurring theme in my \u201cBI of the future\u201d presentations over the years, and it\u2019s not a new idea, as Mark Madsen<\/a> pointed out in a recent TDWI video<\/a>. He talks about about the origins of data warehousing as envisaged by Barry Devlin and others, and pointed out that this type of personal store was very much part of that original vision.<\/p>\n The next version of SAP HANA (SP3) delivers a first version of \u201cself-service data warehousing\u201d. It includes a new web-based application called \u201cInformation Composer\u201d that lets business people clean, upload, and model their own data, and combine it with trusted corporate sources. There hasn\u2019t yet been a lot of communication about the product, but there\u2019s a fifteen-minute walkthrough video<\/a> available on the Experience SAP HANA website<\/a> and you can read the Information Composer documentation<\/a>.<\/p>\n Because the underlying platform is HANA, data access is already available through the full range of SAP BusinessObjects products. Information Composer is a great opportunity for organizations to regain control over BI installations, allowing the optimal combination of central administration and low total costs of ownership without having to sacrifice the flexibility required by business people.<\/p>\n Here are a few examples screenshots from the video. Cleansing data:<\/p>\n Finding suitable corporate data:<\/p>\n Choosing how to combine different sources<\/p>\n Adding new calculated fields<\/p>\n The next version of SAP HANA (SP3) delivers a first version of \u201cself-service data warehousing\u201d. It includes a new web-based application called \u201cInformation Composer\u201d that lets business people clean, upload, and model their own data, and combine it with trusted corporate sources. <\/p>\n","protected":false},"author":2,"featured_media":3534,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-12225","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2011\/11\/infocomposerbanner.jpg?fit=690%2C310&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3X9RF-3bb","_links":{"self":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/comments?post=12225"}],"version-history":[{"count":0,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12225\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media\/3534"}],"wp:attachment":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media?parent=12225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/categories?post=12225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/tags?post=12225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"cleansing-data\"](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2011\/11\/cleansing-data.jpg?resize=690%2C388&ssl=1\" "\\"cleansing-data\\"")
<\/p>\n![\"corporate-data\"](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2011\/11\/corporate-data.jpg?resize=690%2C388&ssl=1\" "\\"corporate-data\\"")
<\/p>\n![\"joins\"](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2011\/11\/joins.jpg?resize=690%2C388&ssl=1\" "\\"joins\\"")
<\/p>\n![\"calculations\"](\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2011\/11\/calculations.jpg?resize=690%2C388&ssl=1\" "\\"calculations\\"")
<\/p>\n","protected":false},"excerpt":{"rendered":"