The basics of improving BI performance

Home
Topics
Business intelligence management
Business intelligence best practices
The basics of improving BI performance

The basics of improving BI performance

Brian Jordan, CEO, BIT Solutions

What are some basic ways of improving BI performance?

Requires Free Membership to View

Login

When you register, you'll receive targeted emails designed to keep you informed of the latest BI, analytics, corporate performance management (CPM) trends and more.

Hannah Smalltree, Editorial Director

By submitting your registration information to SearchBusinessAnalytics.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchBusinessAnalytics.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

If you mean the speed at which reports and other types of business intelligence data get to the users, there are several ways to improve that.

The first option is to aggregate your data; that automatically produces better performance. In addition, you can scale back the amount of data you let users query and analyze. For example, even though you have 10 years of historical data in your data warehouse, only two years might be used for day-to-day analysis, with archived tables for the data from the other eight years.

A popular approach these days is to use columnar databases vs. traditional databases with a row orientation. Columnar software typically indexes and compresses data, which can significantly increase performance.

In-memory analytics is another BI trend that leverages a system's memory cache to load, index and compress data, giving users access to high volumes of data with nearly instant response rates on queries. Those are some of the most common ways of improving BI performance.

Dig Deeper

People who read this also read...

Related glossary terms

Terms for Whatis.com - the technology online dictionary

Show me more

This was first published in April 2011

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Data Management
Data Management UK
Content Management
CRM
Oracle
SAP
SQL Server

Data Management
- As data demands speed up, information management tools pave road ahead
  
  New research shows data virtualization, data governance and master data management initiatives provide higher levels of satisfaction with data quality and data integration.
- Bank of America IT exec: EIM drivers key to shaping project plans
  
  Enterprise information management programs should be molded around clear business objectives, says a senior information architect at Bank of America.
- In-memory database caching helps AltEgo bring online avatars to life
  
  In-memory database caching technology is helping gamers take charge of their online identities.
DataManagement UK
- Podcast: How to craft an effective MDM strategy
  
  In this podcast interview, Andy Hayler gives advice on how to create and implement an MDM strategy that is ruthlessly focused on business value.
- Jill Dyché: CEO big data focus good news and bad news for IT
  
  Jill Dyché, a data management expert, sees CEO interest and scepticism as both an opportunity and a threat. Avoid the big data 'gotchas', and don't mistake data warehousing for big data.
- Infostrada teams up with Roambi, mobile sports analytics at Olympics
  
  Dutch media sports information provider Infostrada has teamed up with mobile BI company Roambi to create an iPhone and iPad app for the Olympics. It will predict medal counts.
Content Management
- Cimarex picks Accellion enterprise collaboration platform over SharePoint
  
  Cimarex Energy replaced its SharePoint system with Accellion’s enterprise collaboration platform for secure mobile file sharing and uses it to recruit graduate geology students.
- Paper originals still needed when using a document management system?
  
  Get expert advice on whether it’s necessary to keep paper or other forms of original materials once a company implements an electronic document management system.
- Out with old: Effective records management begins with losing useless data
  
  An effective records management program is one that not only knows what to keep – but which expired data can be removed to save time and money, said consultant Randolph Kahn.
CRM
- Call center agents’ behavior should be focus -- not clunky metrics
  
  A consultant at the recent ACCE call center expo urged call centers to drop the glut of performance metrics and favor a human approach.
- Health care reform catalyst for customer service improvements
  
  Although many don’t immediately think of CRM and health care together, recent U.S. legislative changes to health care standards are causing organizations to think of patients as customers
- Mobile CRM apps aim to connect smartphones, contact centers
  
  Customers won’t start from scratch with new mobile app “bridge” programs that transfer their information to contact centers.
Oracle
- Implementing a Hyperion system in 3 weeks -- it can be done
  
  An Oracle Hyperion system implementation in three weeks? Yes, it can be done. Communications firm Neustar implemented Hyperion in less than a month and gained efficiencies in the process.
- Las Vegas expands its Oracle business intelligence horizons for better government transparency
  
  The city of Las Vegas underwent a three-year Oracle business intelligence project to bring more data to its employees and the public. The city's IT manager explains how it happened.
- Midmarket companies find JD Edwards upgrades a good fit
  
  At some point, your JD Edwards shop will have to decide whether to switch to a different product, upgrade or stay where you are. Learn what two other organizations did when working through JD Edwards upgrades.
SAP
- SuccessFactors now leading SAP cloud strategy, but questions remain
  
  SAP has placed a huge bet on a new executive “born in the cloud” and on a company that will now guide both companies’ roadmap for existing products.
- SAP tells of a future built on in-memory, mobile, and cloud
  
  SAP outlined its cloud strategy at the SapphireNow conference in Orlando. Are customers genuinely interested, or is it just SAP hype?
- Spinnaker to fight Rimini Street for third-party SAP support market
  
  It was only a matter of time before SAP third-party support and maintenance provider Rimini Street had some competition from other vendors. That time has come.
SQL Server
- More T-SQL statements in SQL Server 2012 you need to know about
  
  In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more.
- Three new T-SQL commands in SQL Server 2012 to make your life easier
  
  Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors.
- Configuring SSRS the easy way
  
  Demystify the SQL Server Reporting Services (SSRS) configuration process. Get an overview of this tool and guidelines for how to set up each screen in SSRS from industry professional Roman Rehak.

All Rights Reserved, Copyright 2010 - 2012, TechTarget