1/09/2014

Business Intelligence has Evolved

Business Intelligence and Data Warehousing is actually more complicated than most people think.

Just grab some data, create a query, throw it in a report, run and send to user.

Truth is, that's only part of it.

In the Microsoft BI stack, for SQL Server 2012, there's lots to know.

You have DBA administration, T-SQL, SSIS, SSAS, SSRS, Cubes, MDX, Pivot Tables in Excel, Indexes, Indexed Views, Clustered Indexes, Data Modeling.  You have to know how to deploy to the SSIS Catalog, set up users to run jobs, Virtual Machines, networking, ports, Active Directory, you have to become business knowledge experts, how to relate to Executives and understand how data flows through each of the system.

You also have to know about Data Quality Services, Master Data Services, Change Data Capture.

Data Quality Services allows people to clean the data before it's imported into the database.  It requires administration, setup, user roles and permissions, installing clients, and then actually using the application.  You have new roles such as Data Steward, Information Workers and Data Governance.

Master Data Services also requires installation, setup, user roles, permissions, creating web sites which point to MDS database, you have to learn about Models, Entity's and Attributes, how to Insert, Update and Delete data, create views and how to integrate the centralized master data into your Data Warehouse.

Change Data Capture basically captures data as it's inserted, updated and deleted in your database, so you can keep track of who did what when.

And then you can do these tasks in SSIS through components.

Suffice to say, Business Intelligence developers really have their work cut out and perhaps it explains why they are in demand.

We've moved away from simple Select * From Table queries we did back in the 90's.

We ain't in Kansas anymore Toto!

No comments:

Post a Comment

Babalon