We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Self-Service Data Warehousing for Business People with SAP Information Composer
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
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
Timo Elliott
4 Min Read
Self-Service Data Warehousing for Business People with SAP Information Composer
Photo by StartupStockPhotos on Pixabay (https://pixabay.com/photos/student-typing-keyboard-text-849826/)
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.

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.

More Read

Data Governance Capabilities
Data Governance Capabilities
Using Social Monitoring to uncover the Analytics of Geolocation –
New Trends in BI, Analytics and Social Media
Social Business and Digital Strategy
Big Data Analytics: Think Differently To Maximize Value

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

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article connects downstream report failures, data-quality gaps, and conflicting metric definitio
Signs Your Data Architecture Needs an Outside Review
Big Data Exclusive
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Big Data Exclusive
Flat editorial illustration: The article contrasts tools for gathering fresh interviews with tools for analyzing existing qualita
10 AI Market Research Tools That Turn Qualitative Data into Insights
Artificial Intelligence Big Data Exclusive
Flat editorial illustration: The article compares proxy MCP servers by what an AI agent can do through them: manage proxy account
Proxy MCP Servers: 7 Options and What Each Lets an AI Agent Do
Artificial Intelligence Big Data Data Collection

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Who is Your Real Customer: IT or the Business?
Business IntelligenceDecision ManagementInside CompaniesNew Products

Who is Your Real Customer: IT or the Business?

4 Min Read
ai in seo
Artificial IntelligenceExclusive

Can AI Help with Regional Nuances in International SEO?

8 Min Read
Why Mobile BI is becoming the first choice for BI users?
Big DataBusiness IntelligenceCloud ComputingLocation

Why Mobile BI is becoming the first choice for BI users?

7 Min Read
Rexer Analytics Survey – are data miners too focused on their models?
AnalyticsData MiningDecision Management

Rexer Analytics Survey – are data miners too focused on their models?

4 Min Read

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

Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?