Overview of Microsoft BI Components SQL 2000 Vs 2005 – I know pretty old!

ByDr. SubraMANI Paramasivam

Overview of Microsoft BI Components SQL 2000 Vs 2005 – I know pretty old!

The following table presents an overview of the components of a business intelligence system, and the corresponding Microsoft SQL Server 2000 and SQL Server 2005 components.

Component SQL Server 2000 SQL Server 2005
Extract, transformation, and load Data Transformation Services (DTS) SQL Server 2005 Integration Services
Relational data warehouse SQL Server 2000 relational database SQL Server 2005 relational database
Multidimensional database SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services
Data mining SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services
Managed reporting SQL Server 2000 Reporting Services SQL Server 2005 Reporting Services
Ad hoc reporting SQL Server 2005 Reporting Services
Ad hoc query and analysis Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)
Database development tools SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other SQL Server 2005 Business Intelligence Development Studio (New!)
Database management tools Enterprise Manager, Analysis Manager SQL Server 2005 SQL Server Management Studio (New!)

I will get back to you in my next post. All the best for your definition PLUS hunt.

About the Author

Dr. SubraMANI Paramasivam administrator

Dr.SubraMANI Paramasivam is a Data Platform MVP, Power BI Group Leader, International Speaker, Microsoft Certified Trainer and Principal Solutions Architect at DAGEOP Ltd, having 20+ years of DB, BI & Analytics experience. Dr.SubraMANI Paramasivam is a frequent speaker in SQLBITS, PASS Summit, PASS SQL Saturdays, SQLRelay, Data Platform Summit, MCT Summit, SQLServerGeeks Summit, INSIDESQL UK, Data Awareness Programmes, Data Day Events. He likes to enlighten the education & data and started his own journey with FREE Data Awareness Programme (www.dataap.org), in remote areas who are in need. Mani speaks a lot about Visualization, Data Science, R Analytics, Azure concepts, Performance Tuning, DB & SQL Server Architecture, DBA, Partitioning, Resource Governor, Disaster Recovery, High Availability, Development, T-SQL Programming and Microsoft certifications.

Comments Are Closed!!!