Working with ssas Data mining in C#.NET

Painting USS Code 128 in C#.NET Working with ssas Data mining

Before You Begin. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 372 Lesson 1: Preparing and Creating Data Mining Structures . . . . . . . . . . . . 372 Understanding the Data Mining Project Life Cycle 373 Preparing Data for Data Mining 374 Creating Data Mining Models 376 Selecting Data Mining Algorithms 377 Understanding the Data Mining Tools 380 Practice: Preparing Data for Data Mining and Creating Predictive Models 384 Lesson 2: Creating Models and Applying Algorithms . . . . . . . . . . . . . . . .394 Mapping Mining Structure Attributes to Source Columns 394 Using Case Table Definitions and Nested Tables 395 Using Cube Sources 397 Configuring Algorithm Parameters 398 Practice: Creating Mining Models and Setting Algorithm Parameters 399 Lesson 3: Validating Models, Using DMX Queries, and Using Prediction Queries in Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .408 Validating Predictive Models 408 Measuring the Accuracy of Other Models 414 Creating Data Mining Queries and Reports 419 Creating Prediction Queries in BIDS and SSMS 419 Understanding the DMX Language 421

Using Prediction Queries in Reports Practice: Testing Model Accuracy, Creating a DMX Report, and Using DMX Queries

423 424

Lesson 4: Securing and Processing Data Mining Models . . . . . . . . . . . . . . 431 Configuring SSAS Properties 432 Configuring SSAS Roles, Permissions, and Data Sources 433 Processing Data Mining Objects 435 Processing Mining Structures and Models 436 Practice: Securing and Processing Data Mining Models 437 Case Scenario: Working with SSAS Data Mining . . . . . . . . . . . . . . . . . . . . .443 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .443

Before You Begin. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .445 Lesson 1: Creating SSRS Projects and Reports in BIDS . . . . . . . . . . . . . . . .446 Understanding the SSRS Report Templates 446 Using the Report Wizard 447 Modifying Project Properties 448 Modifying Report-Level Properties 449 Developing Report Objects with the Report Designer 451 Adding Report Objects to a Report 453 Practice: Creating and Modifying a Report 458 Lesson 2: Creating a Dataset from a Data Source . . . . . . . . . . . . . . . . . . . .464 Creating a New Report Dataset 465 Working with an SSAS-Based Dataset 466 Practice: Creating Report Datasets 468 Lesson 3: Working with Advanced Report Object Properties . . . . . . . . . . 471 Toggling Object Visibility 471 Defining Report Actions 473 Adding Bookmarks 474 Practice: Modifying Advanced Report Object Properties 474 Lesson 4: Applying Dataset Filters and Groups . . . . . . . . . . . . . . . . . . . . . . 478 Assigning Datasets to Data Regions 478 Applying Filters, Groups, and Sorts to Data Regions 481 Applying Aggregates to Data Regions 484 Practice: Creating Advanced Data Regions 484 Case Scenario: Building Reports for the AdventureWorks Intranet . . . . .488 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .489