By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Self-Service Data Warehousing for Business People with SAP Information Composer
Share
Notification Show More
Latest News
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Warehousing > Self-Service Data Warehousing for Business People with SAP Information Composer
Business IntelligenceData Warehousing

Self-Service Data Warehousing for Business People with SAP Information Composer

Timo Elliott
Last updated: 2011/11/08 at 1:18 PM
Timo Elliott
4 Min Read
SHARE

infocomposerbanner

infocomposerbanner

I started my career talking about self-service BI, with a product called “Skipper SQL” that let business people flexibly access information using the “objects” of their business: – sales, revenue, products, customer, etc. (you can probably guess what the product name changed to). For the first time, you didn’t need to be a computer expert to access data.

More Read

ai in ppc advertising

5 Proven Tips for Utilizing AI with PPC Advertising in 2023

5 Ways AI Technology Has Disrupted Website Development
Fortifying Enterprise Digital Security Against Hackers Weaponizing AI
10 Ways How Artificial Intelligence Is Changing the Content Writing Landscape
How IoT Can Be Connected to Business Intelligence

But on the back end, it has always been the job of an  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…). In large part, this has been because of the complexity of creating a data warehouse that is robust enough to provide fast, convenient access.

But newer in-memory architectures like SAP HANA are eliminating a lot of the need for redundant layers, 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.

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 “rogue” 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’s bad for us in the long term, but they are at least better than going hungry.

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 “sandboxes” or “user areas” that let business people upload and manage their own data on the same system. This has been a recurring theme in my “BI of the future” presentations over the years, and it’s not a new idea, as Mark Madsen pointed out in a recent TDWI video. 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.

The next version of SAP HANA (SP3) delivers a first version of “self-service data warehousing”. It includes a new web-based application called “Information Composer” that lets business people clean, upload, and model their own data, and combine it with trusted corporate sources. There hasn’t yet been a lot of communication about the product, but there’s a fifteen-minute walkthrough video available on the Experience SAP HANA website and you can read the Information Composer documentation.

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.

Here are a few examples screenshots from the video. Cleansing data:

cleansing-data

Finding suitable corporate data:

corporate-data

Choosing how to combine different sources

joins

Adding new calculated fields

calculations

Timo Elliott November 8, 2011
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

ai in ppc advertising
Artificial Intelligence

5 Proven Tips for Utilizing AI with PPC Advertising in 2023

10 Min Read
ai in web design
Artificial Intelligence

5 Ways AI Technology Has Disrupted Website Development

7 Min Read
Digital Security From Weaponized AI
Security

Fortifying Enterprise Digital Security Against Hackers Weaponizing AI

11 Min Read
AI-powered content writing tools
Artificial Intelligence

10 Ways How Artificial Intelligence Is Changing the Content Writing Landscape

8 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?