An Intelligent Approach to Business Intelligence: Part One

There’s a lot of information about analytics and business intelligence. In fact, you could argue that there is too much information. Business executives and IT professionals scour the internet to research “how to do it” and find everything from relevant blogs to...

Index Health and Data Loads in SQL Server

Most databases have maintenance plans running that monitor the health of the database, including indexes, and perform maintenance tasks as needed. But, what happens when data loads are sufficient enough to fragment the indexes and degrade performance during the data...

Why is it so hard to gain insight?

If you’re finding that it takes too long to get meaningful reports and analysis from your data, you’re not alone. Data Intensity recently conducted a survey of over 200 companies (212 to be precise) to gauge the current state of data analytics and to understand what...

Mining Data Vault Loading Views

I first heard about Data Vault (DV) in late 2011. As I learned about DV, I quickly realized its benefits in the realm of Data Warehousing (DW), however it was not until early 2012, after I had the opportunity to attend Dan Linsted’s 3-day DV “Boot camp” class, when I...

Power to the People…
the Business Intelligence way

When entering into any technology project, the team is typically is comprised of a blend of business and IT professionals. These can be from developers, analysts, business liaisons and business analysts; to the projects sponsors. When looking at a Business...