• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

Why I beleive the Microsoft BI Stack seems unfinished

September 4, 2009 by John Sansom 1 Comment

Simon Sabin shared a great post with the SQL Server Community recently where he asked Where is the intelligence in Business Intelligence? This really got me thinking and I wanted to share some further thoughts with you on the subject.

To me it seems as if the Business Intelligence solution stack is only three quarters finished.

We have all these powerful tools that allow us to extrapolate data from various systems and processes throughout the organisation (for example SSIS). We also have a means to centralise the data in a standardised and optimised structure to fuel analysis (for example Analysis Services), but we are missing the simple/easy to use interface in order to expose the data to end users that require it. Reporting Services is certainly not up to job in my opinion. It is just not flexible enough in terms of features and more importantly it is not accessible to a typical business user.

At present a skilled analyst is necessary in order to provide a business user with access to the specific metrics/analysis that they require.

If this knowledge gap can indeed be bridged in the future, then the power to extrapolate business insight will finally be placed in the hands of the users that actually need it.

Filed Under: Reporting Services Tagged With: Microsoft BI

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy