By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
    hire a marketing agency with a background in data analytics
    5 Reasons to Hire a Marketing Agency that Knows Data Analytics
    7 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
Aa
SmartData CollectiveSmartData 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 low code frameworks

AI Can Help Accelerate Development with Low-Code Frameworks

Tackling Bias in AI Translation: A Data Perspective
How AI is Boosting the Customer Support Game
AI-Based Analytics Are Changing the Future of Credit Cards
Enterprises Are Leveraging the Benefits of AI-Driven ERPs

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

smart home data
7 Mind-Blowing Ways Smart Homes Use Data to Save Your Money
Big Data
ai low code frameworks
AI Can Help Accelerate Development with Low-Code Frameworks
Artificial Intelligence
data Analytics instagram stories
Data Analytics Helps Marketers Make the Most of Instagram Stories
Analytics
data breaches
How Hospital Security Breaches Devastate Local Communities
Policy and Governance

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

ai low code frameworks
Artificial Intelligence

AI Can Help Accelerate Development with Low-Code Frameworks

12 Min Read
data perspective
Big Data

Tackling Bias in AI Translation: A Data Perspective

9 Min Read
How AI is Boosting the Customer Support Game
Artificial Intelligence

How AI is Boosting the Customer Support Game

6 Min Read
AI analytics
AnalyticsArtificial IntelligenceExclusive

AI-Based Analytics Are Changing the Future of Credit Cards

6 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 in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
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.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?