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: What to look for in a new data warehouse
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 > What to look for in a new data warehouse
Business IntelligenceData Warehousing

What to look for in a new data warehouse

LyndsayWise
Last updated: 2010/05/24 at 11:32 PM
LyndsayWise
4 Min Read
SHARE

Using dashboards to get broad visibility into business is gaining popularity.  Because of advancements in technology, organizations can use BI without a full business intelligence infrastructure.  For organizations that want to keep historical records of operations, meet compliance, identify risk, implement governance initiatives, etc. implementing a data warehouse becomes essential.  When companies look for their first data warehouse, they may not know where to start. Some general considerations include:

  1. Identifying the business purpose – Any BI project or data warehouse evaluation needs to start with a business pain or the identification of a gap within the business.  Whether this includes the ability to identify trends over time, increase analytics capabilities, or meet compliance requirements, it is impossible to successfully implement a data warehouse without defining a business need. 

  1. Data sources – Looking at where data comes from and…

More Read

business dashboards and big data

Leveraging Big Data With State-Of-The-Art Business Dashboards

Web Tracking and Analytics Data in Salesforce: Why They’re Necessary
The Emailed Dashboards School of Management
6 Must-See Usability Testing Videos
Salesforce Struggles to Deliver on the Dream of Analytics

Using dashboards to get broad visibility into business is gaining popularity.  Because of advancements in technology, organizations can use BI without a full business intelligence infrastructure.  For organizations that want to keep historical records of operations, meet compliance, identify risk, implement governance initiatives, etc. implementing a data warehouse becomes essential.  When companies look for their first data warehouse, they may not know where to start. Some general considerations include:

  1. Identifying the business purpose – Any BI project or data warehouse evaluation needs to start with a business pain or the identification of a gap within the business.  Whether this includes the ability to identify trends over time, increase analytics capabilities, or meet compliance requirements, it is impossible to successfully implement a data warehouse without defining a business need. 

  1. Data sources – Looking at where data comes from and how many sources are required may affect overall solution choice. In addition to the purposes behind implementing a data warehouse mentioned above, many companies require a full view of what is happening within the organization that the use of operational systems doesn’t give them.  For instance, information related to customers and their overall lifecycle might reside in multiple systems.  Within a data warehouse, this data can be consolidated so that decision makers can see customer actions over time and link them to marketing campaigns, identify general trends in demographics, or identify potential gaps in operations.

  1. Data volumes – How much data and how often data needs to be updated can affect solution choice.  Some data warehousing solutions are optimized for larger data sets, while others pride themselves on query performance.  There really is no one size fits all solution when it comes to data warehousing so organizations should try to match their business requirements to the solutions available in the market without trying to implement something that is outside the scope of their needs.

  1. Outputs – Identifying the output required means looking at whether the data warehouse will be used as a business intelligence back-end, to stream operational data for general analytics, or to perform extensive analytics.  Information requirements for general reporting or dashboards will be different than those used for predictive analytics or risk identification and mitigation.

These four items don’t represent all of the considerations when looking at a data warehousing solution, but do identify some preliminary requirements that should be considered to identify the right solution for the organization.

Link to original post

TAGGED: dashboards
LyndsayWise May 24, 2010
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

business dashboards and big data
Big DataBusiness IntelligenceExclusive

Leveraging Big Data With State-Of-The-Art Business Dashboards

8 Min Read

Web Tracking and Analytics Data in Salesforce: Why They’re Necessary

10 Min Read

The Emailed Dashboards School of Management

8 Min Read

6 Must-See Usability Testing Videos

2 Min Read

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

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

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?