Excel File Data Validation for SQL Server Imports

Jeffrey Yao suggests a solution to validate Excel data via PowerShell and Regular Expressions.

Power tools

Export SQL Server Reporting Services Report Data into Multiple Excel with Worksheets

Sometimes SQL Server Reporting Services users want to export SSRS reports into Excel with multiple sheets, but when the SSRS report data region (Tablix/Matrix) doesn't have any grouping then all the data will be exported into a single sheet. Ghanesh Prasad explains how to export a SSRS report into Excel with multiple sheets.

Data Mining Part 21: Excel and Data Mining,validation methods

This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.

Data Mining Part 21: Excel and Data Mining,validation methods

This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.

Data Mining Part 20: Excel and Data Mining,accuracy, forecasting

In the lesson 18 and 19 we worked with Data Mining Models.
In this new chapter we will work with more algorithms and show how to test the accuracy of the model.

Data Mining Part 20: Excel and Data Mining,accuracy, forecasting

In the lesson 18 and 19 we worked with Data Mining Models.
In this new chapter we will work with more algorithms and show how to test the accuracy of the model.

Data Mining Part 19: Excel and Data Mining, Samples, Queries

This lesson explains how to Clean Data, Explore Data, get Samples of Data, Classify and query a Data Mining Model.

Data Mining Part 19: Excel and Data Mining, Samples, Queries

This lesson explains how to Clean Data, Explore Data, get Samples of Data, Classify and query a Data Mining Model.

Data Mining Part 18: Excel and Data Mining

In this new article, we will introduce you to Microsoft Excel and Data Mining.