BI Funcasts : The Mac-Guyver Techniques. This is where we are today.
These sessions will lower the barrier to work with the products itself & deliver an overview of the features & provide basic conceptual guidance that can be used within your current or future BI projects. Each session is recorded & published through different Belgian Bloggers. This initiative is hosted by MSDN/TECHNET Belgium.
14/2 : BI - The Mac-Guyver Techniques : SQL Server Integration Services.
How do you combine the tasks and transforms offered by Microsoft SQL Server 2005 Integration Services (SSIS) into a real extraction, transformation, and loading (ETL) system? In this webcast, we present design patterns for building an application that is maintainable, auditable, and scalable to populate your dimensional Kimball Method data warehouse and Microsoft SQL Server 2005 Analysis Services database.
The ppt I used : http://blogs.msdn.com/gunterstaes/attachment/1714747.ashx
The recording of the webcast : See Recording
28/2 : BI - The Mac-Guyver Techniques : SQL Server Analysis Services.
Microsoft SQL Server 2005 Analysis Services includes new capabilities that enable you to deliver rich and powerful analytics to your organization. In this session, we demonstrate how you can use SQL Server Analysis Services to build a highly scalable, business intelligence (BI) infrastructure that supports the analytics your business needs to improve overall performance. During the discussion, we cover a short conceptual overview on Analysis services as well as a step-by-step demonstration of how to create a Business Model including some tips & trick's.
The ppt I used : http://blogs.msdn.com/gunterstaes/attachment/1781054.ashx
The recording of the webcast : View Recording
14/3 : BI - The Mac-Guyver Techniques : SQL Server Reporting Services.
In this webcast, we introduce Microsoft SQL Server 2005 Reporting Services. You will understand the report life cycle, and see how to create, publish, manage, and deliver reports using the new tools and features in SQL Server 2005 Reporting Services. You'll also discover tips and tricks for creating interactive reports & the integration with Sharepoint.
The ppt I used : http://blogs.msdn.com/gunterstaes/attachment/1926461.ashx
The recording of the webcast : View Recording
21/3 : BI - The Mac-Guyver Techniques : SQL Server Analysis Services & Excel 2007, better together.
This webcast shows how to use Microsoft SQL Server 2005 Analysis Services and Microsoft Office Excel 2007 to build an enterprise-level data analysis solution. We show you how to develop server-side business rules and unified views of business data for one version of the truth, while at the same time providing end users with simple, self-service flexibility user experience in Excel. All this to make accurate decisions quickly.
No ppt used for this session : Pure Demo.
The recording of the webcast : View Recording
4/4 : BI - The Mac-Guyver Techniques : Microsoft Office Sharepoint Server 2007 - Excel Services.
The new Excel Services in Microsoft Office SharePoint Server 2007 puts Excel spreadsheet calculation and rendering on the server. Excel Services enables managed and secure distribution of Excel reports, and the ability to incorporate spreadsheets into business intelligence dashboards and portals, protect the proprietary information in spreadsheets and build custom applications with Excel-based logic. This session explains Excel Services' basic concepts and architecture in combination with Single Sign On (SSO) & Centrally managed Data Connections. After this session you will be able to understand the concepts so that you will be able to set up a Excel Services in a secure & well managed way.
No ppt used for this session : The recording of the webcast :View Recording
