tailieunhanh - Wiley - Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies (2008)02

Wiley - Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies (2008)02 | Business Intelligence 19 Figure 2-2 Creating a new project in Visual Studio. Book I Chapter 2 SQL Server Architecture and Key Concepts Business Intelligence In the not-too-distant past only the largest enterprises could take advantage of the proven benefits from complex business intelligence analysis. The software and hardware necessary to run these computations was simply out of reach of most organizations. The past few years have seen the price of hardware and software fall at a steady pace bringing these kinds of solutions to a new audience. Microsoft has done its part as well delivering highly capable business intelligence technology in conjunction with its database framework. Known as SQL Server Analysis Services these technologies which seamlessly integrate with the Microsoft Office suite make it possible to develop and deliver robust analytic solutions without the need for expensive software and consulting services. Figure 2-3 highlights how again the Visual Studio development environment is the foundation for developing a SQL Server-related solution. In this case designing and creating a multidimensional cube. 20 Reporting Figure 2-3 Configuring business intelligence. Reporting SQL Server s Reporting Services SSRS aim to offering the IT organization a single source for creating maintaining and delivering reports on information stored in the database. Well-integrated with Microsoft Office as well as SharePoint Server 2007 SSRS reduces the need to purchase and master third-party reporting solutions. Instead application designers and developers can work within the same set of tools to deliver the information their users require. For example Figure 2-4 shows the user interface for the Microsoft Report Designer. Integration Several new industries are addressing the ever-multiplying challenges of tying information together from multiple silos. Unfortunately from the perspective of most IT organizations this leads to purchasing and administering an increasing .