Problem solve

Data warehouse software

• Why data silos matter: Settling ownership of data issues

  Data management is often still seen as an IT task, but that can lead to data silos. Find out why the business should be in charge of its data as part of a governance process. Continue Reading

• Dimension tables vs. fact tables: What's the difference?

  Fact tables and dimension tables are used together in star schemas to support data analytics applications. But they play different roles and hold different types of data. Continue Reading

• Operational data store vs. data warehouse: How do they differ?

  Operational data stores and data warehouses both store operational data, but the similarities between them end there -- and they both have a role to play in analytics architectures. Continue Reading

• Imhoff: Data warehouse architecture must go beyond the traditional

  In a video interview, consultant Claudia Imhoff discusses the increasing need to augment data warehouses with technologies such as Hadoop and real-time analytics systems. Continue Reading

• Big data, fast: Avoiding Hadoop performance bottlenecks

  A variety of performance issues can bog down Hadoop clusters. But there are ways to sidestep the pitfalls and keep your big data environment humming. Continue Reading

• Database administration best practice: Balance DBA team skills

  Balancing development and operations skills is a first step to achieving database administration best practices in-house.Continue Reading

• Why IT departments should consider a large data warehouse system

  Find out how a large data warehouse system can benefit companies. Learn how enterprise data warehouses help meet business needs. Get tips on operational considerations for a central data warehouse.Continue Reading

• Key issues to consider when building a data warehouse

  There are numerous issues, both technical and cultural, that organizations need to consider before building a data warehouse. Learn what they are from our data warehousing expert.Continue Reading

• Common enterprise information management strategy mistakes to avoid

  Learn about four common mistakes that companies make when creating an enterprise information management strategy and starting an EIM program.Continue Reading

• Six tips for improving data warehouse performance

  Get six expert tips for improving data warehouse performance. Learn how database engines, SSDs and MOLAP cubes can affect your data warehouse performance.Continue Reading

• Key components of enterprise information management programs

  Learn which three components of enterprise information management programs are most important for a successful EIM strategy.Continue Reading

• What is the main use of a DBMS and what is the main use of a data warehouse?

  There are distinct functions for a database management system (DBMS) and a data warehouse. Learn how to use a DMBS and how to use a data warehouse to manage data in your organization.Continue Reading

• Definition of operational data store vs. persistent staging area

  Discover the definition of operational data store vs. persistent staging area, including how to use the operational data store and the persistent staging area effectively.Continue Reading

• How to choose between the Inmon vs. Kimball approach for data warehouse design

  Get an overview of Inmon v. Kimball approaches to data warehouse design and business intelligence and find a checklist to help you decide on an architecture approach.Continue Reading

• Three data warehouse project management metrics

  Data warehouse project management requires careful planning. So learn three data warehouse project management metrics that just might make things run smoother.Continue Reading

• How to evaluate data warehouse software in five steps

  Get five steps to evaluating data warehouse software from a data warehouse expert.Continue Reading

• Data quality management for data warehouses

  Learn how to evaluate the risks of poor data quality in data warehouses -- and how good data quality management practices help mitigate risks.Continue Reading

• Can a dimension table be a fact table for another data mart?

  Find out if a dimension table can be a fact table for another data mart -- and get an explanation of the answer.Continue Reading

• Data modeling for data warehouse projects

  Learn how to begin a data warehouse project and why creating a data model is an important step.Continue Reading

• Data warehouse development: Four strategic steps

  Learn the basics of data warehouse development in four strategic steps, from expert William McKnight.Continue Reading

• Why you should build a data warehouse

  Learn the argument for building a data warehouse, why building one takes time and how to sharpen your data warehousing skills.Continue Reading

• Business intelligence and data warehousing team structure

  Business intelligence and data warehousing teams are constructed differently, but most are placed within the IT department and include some basic, common roles.Continue Reading

• Operational data stores: ODSs join the debate between data marts and data warehouses

  The main feature of operational data stores is the real-time nature of the data. However, our expert advises that ODSs are not for everyone.Continue Reading

• Data mart vs. data warehouse

  Craig Mullins explains various definitions of a data mart and sheds some light on the complexity of its relation to a data warehouse.Continue Reading

• How to define business requirements for data warehousing projects

  Using the Business Requirements Definition, the authors define the process of gathering business requirements, which begins with interviewing IT and business professionals, in order to organize and analyze data into a DE/BI system strategy to make ...Continue Reading

• Ralph Kimball vs. Bill Inmon approaches to data warehouse design

  Learn about the debate between the Ralph Kimball and Bill Inmon approaches to data warehouse design.Continue Reading

• SQL Server and business intelligence: Plan ahead

  Here are some key planning concepts to keep in mind whenever you use SQL Server as a solution to a particular business problem.Continue Reading