Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag excel Rss

Search for any content tagged excel

   Items 1 to 20 of 65    Older >>
 

How to read data from multiple Excel worksheets with SQL Server Integration Services

Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,669 reads

Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.  Read more...
By Stan Kulp 2016/01/22 (first published: 2014/02/11) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 14,315 reads

Excel File Data Validation for SQL Server Imports

Jeffrey Yao suggests a solution to validate Excel data via PowerShell and Regular Expressions.  Read more...
By Additional Articles 2015/09/14 | Source: MSSQLTips.com | Category: excel
Rating: (not yet rated)  Rate this |   Briefcase | 3,155 reads

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.  Read more...
By Additional Articles 2015/06/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 1,671 reads

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.   Read more...
By Daniel Calbimonte 2014/11/18 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 3,103 reads

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.  Read more...
By Daniel Calbimonte 2014/11/11 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 3,551 reads

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.  Read more...
By Daniel Calbimonte 2014/10/28 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 6,199 reads

Data Mining Part 18: Excel and Data Mining

In this new article, we will introduce you to Microsoft Excel and Data Mining.  Read more...
By Daniel Calbimonte 2014/10/08 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 7,364 reads

Percentile calculations in DAX

It is not always easy to do what Excel does with PERCENTILE.INC. Learn what formulas to use in this article.  Read more...
By Antonio Abalos Castillo 2014/04/28 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 2,703 reads

Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.  Read more...
By Stan Kulp 2016/01/22 (first published: 2014/02/11) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 14,315 reads

Uncontrolled Code

Excel is used quite often to build software, or at least, it's worksheets and formulas simulate software. Steve Jones notes there are lots of problems with this practice.  Read more...
By Steve Jones 2014/01/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 261 reads

Getting Started with Microsoft Power Query for Excel

Power Query, provided as part of Microsoft Power BI self-service solution, is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of Excel add-ins. Read on to learn how to install and get started using it.  Read more...
By Additional Articles 2013/12/04 | Source: Database Journal | Category: power query
Rating: (not yet rated)  Rate this |   Briefcase | 2,963 reads

SSRS Reports as a Data Source in Excel 2013

DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To properly administer them, it certainly helps to understand the technology from the point of view of the user. By using an existing SSRS report as a data feed for Excel, Rodney Landrum explains how these users can now take advantage of development efforts in new ways.  Read more...
By Additional Articles 2013/10/09 | Source: SimpleTalk | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 4,027 reads

Stairway to DAX and Power BI - Level 2: The DAX COUNTROWS() and FILTER() Functions

Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.  Read more...
By Bill Pearson 2013/09/11 (first published: 2012/12/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,168 reads

Getting Data between Excel and SQL Server using ODBC

With ODBC, you can summarise, and select just the data you need, in an Excel workbook before importing it into SQL Server. You can join data from different areas or worksheets. You can even get data from the result of a SQL Server SELECT statement into an Excel spreadsheet. Phil Factor shows how, and warns of some of the pitfalls.  Read more...
By Additional Articles 2013/09/05 | Source: SimpleTalk | Category: odbc
Rating:  Rate this |   Briefcase | 4,364 reads

Moving Data From Excel to SQL Server - 10 Steps to Follow

SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates the advantages of the graphical approach of SSIS. Andy Brown explains.  Read more...
By Additional Articles 2013/06/13 | Source: SimpleTalk | Category: excel
Rating: (not yet rated)  Rate this |   Briefcase | 7,280 reads

More Uses for Data Explorer for Excel

Microsoft has introduced a new BI product that will help simplify the data discovery phase for Excel users. “Data Explorer” is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Data Explorer is a preview product so these features may appear differently in the final release.  Read more...
By Additional Articles 2013/06/07 | Source: MSSQLTips.com | Category: data explorer
Rating: (not yet rated)  Rate this |   Briefcase | 5,118 reads

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.  Read more...
By Russ Mulkey 2013/06/04 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,771 reads

Using source data from an SSRS report in PowerPivot for Excel

In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.  Read more...
By Additional Articles 2013/05/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,125 reads

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...
By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,778 reads
   Items 1 to 20 of 65    Older >>