Business intelligence is awash in so many products, buzzwords and technologies that it is often hard to see the forest for the trees. It is at times like this that I put on my industry analyst's cap and muse, "Hmm, what is this: manage, monitor or model?" This tripartite way of looking at the world has served my clients well, and I thought I'd pass it along.
2005-02-02
2,090 reads
A basic look at how you can start to build a data warehouse. This has some basics you need to do the design of the various fact and dimension tables.
2004-09-27
5,004 reads
A look at how OLAP and Anlysis services might fit into your business and some things to think about when a business intelligence system might be right for you.
2004-09-22
2,400 reads
This article written by Don Church discusses how to optimize your cubes schema, its worth a read.
2002-03-26
9,229 reads
Creating even the simplest of cubes has its pitfalls. This article by Daniel Gallager steers you through the sometimes treacherous world of OLAP.
2002-02-04
11,217 reads
Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.
2001-06-14
1,671 reads
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Comments posted to this topic are about the item Having a Little Fun at...
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers