United States Change | All Microsoft Sites
Microsoft Home | Servers and Tools
SQL Server 2008 provides a scalable BI platform optimized for data integration, reporting, and analysis enabling organizations to deliver intelligence where users want it.
Learn to prepare your Excel data; build, explore, and evaluate mining models in Excel 2007; apply the mining model to a new data set; and view the results in Excel.
After completing this lab, you will be better able to prepare Excel and your data for table analysis, use the Key Influencers tool and interpret the reports generated, use the Detect Categories tool, the Fill from Example tool, the forecasting tool (to predict future sales), and the Highlight Exceptions tool to locate possible data outliers or corruption. Additionally, you will become more familiar with the Scenario Analysis tool to analyze what demographics changes increase a customer’s probability of buying a product, use the Prediction Calculator tool to determine the risk and profitability in marketing to potential customers with a set of particular demographic features, and use the Shopping Basket Analysis tool to determine products that are frequently purchased together.
Discover how to visualize your SQL Server 2008 data mining models, annotate the visualization using Visio, and effectively share the document with other users.
Learn manage reporting services configuration, manage security roles, and configure reports by using subscriptions.
After completing this lab, you will be able to launch the Report Designer Preview, create a data source and a data set, design a new report using the Report Designer of SQL Server 2008 Reporting Services (in CTP4, called "Report Designer Preview"), preview your report, enhance your report layout by working with Tablix functionality, and enrich your report using charts.
SQL Server 2008 Analysis Services and its deep integration with Microsoft Office enables every user to drive actionable insights. This lab walks you through some key scenarios to utilize this powerful integration.
Better manage a Microsoft SQL Server Analysis Services instance and database, secure analysis services, and monitor analysis services performance.
This lab walks you through some key data mining scenarios that will enable predictive analysis across the enterprise.
Create a decision tree and naïve bayes data-mining models, view mining accuracy charts, create a prediction query, and create a Time Series model.
Resources for IT Pros
SQL Server 2008
Resources for Developers
