The need for organizations to have sound business intelligence and data warehousing solutions is becoming more critical by the day. Microsoft has recognized this by adding several SQL Server Business Intelligence (BI) enhancements to the latest editions of its database management system, SQL Server. From seasoned business intelligence tools like SQL Server Analysis Services and Reporting Services, to important add-ons like SQL Server Business Intelligence Studio and Visual Studio, to brand new features like Master Data Services, there is plenty terms of business intelligence with Microsoft SQL Server. This topic page provides links to tutorials, news and other resources on data warehousing and business intelligence with Microsoft SQL Server environments. Here you'll find information on the latest BI features from Microsoft and third-parties, along with advice on implementation strategies, data visualization techniques, and more.
-
BI Strategies
For SQL Server DBAs and developers, business intelligence (BI) is far more than just a job function – it's a career opportunity. The growing reliance on critical data has made business intelligence an in-demand specialty, and IT professionals working with Microsoft SQL Server are... -
Analysis Services
SQL Server Analysis Services (SSAS) is a business intelligent tool that is part of the Microsoft SQL Server database management system. SSAS originally debuted in 2000, having been built on Microsoft's OLAP Services architecture first seen with SQL Server 7. Since then, Microsoft has... -
Integration Services
SQL Server Integration Services (SSIS) is a data management and business intelligence tool included with the standard and enterprise editions of the Microsoft SQL Server database management system. Integration Services replaced Data Transformation Services with the release of SQL Server... -
Reporting Services
Microsoft SQL Server Reporting Services (SSRS) is the company's report generation software, as part of Microsoft's business intelligence (BI) platform for SQL Server. First introduced in 2004, SSRS has come as an install option with every version from Microsoft SQL Server 2005 Reporting... -
Data Warehousing
In IT, data warehousing is a critical component of any business intelligent (BI) strategy. Not only does a data warehouse need to be adequately scalable and secure enough to house an organization's data, it also has to be equipped to assist in the reporting and analysis of that data. The... -
Data Visualization
Data visualization is a key aspect of business intelligence, as the proper use of data visualization techniques and tools is the best way to make reports more useful and effective. Microsoft has created many data visualization features for SQL Server – particularly in the latest...