Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Excel Rss

   Items 1 to 20 of 66    Older >>
 

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,601 reads

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

Excel spreadsheets are useful for distributing data generated by SQL Server, but SSIS lacks direct support for writing Excel files. 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 2014/02/11 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 9,347 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 | 251 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,605 reads

Convert int to Excel column name

This script converts a numeric column index to an Excel column name (ex: AC)  Read more...
By Peter Diplaros 2013/11/07 | Source: SQLServerCentral.com | Category: excel
Rating: (not yet rated) |  Discuss |   Briefcase | 1,215 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 | 3,529 reads

Stairway to PowerPivot and DAX - 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 | 8,577 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,035 reads

Exploring Excel 2013 for BI Tip #11: Color Scales

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...  Read more...
By DataOnWheels 2013/09/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,122 reads

Why the MS Power Query (PQ) for Excel is an invaluable Business Intelligence tool

Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings...  Read more...
By Ziek's SQL Blog 2013/08/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,373 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 | 6,868 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 | 4,875 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,743 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 | 3,735 reads

Exploring Excel 2013 for BI Tip #6: GeoFlow–The Latest Excel Visualization

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...  Read more...
By DataOnWheels 2013/04/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,965 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,718 reads

QlikView for Beginners - An Introduction to QlikView

A brief introduction to getting started with QlikView.  Read more...
By Mark O'Donovan 2012/12/17 | Source: SQLServerCentral.com | Category: qlikview
Rating: |  Discuss |   Briefcase | 3,108 reads

Stairway to PowerPivot and DAX - 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 | 8,577 reads

Using SSIS to export data from a 64 bit server to Excel 2007

Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel  Read more...
Rating: |  Discuss |   Briefcase | 5,814 reads

Importing Data From Excel Using SSIS - Part 1

Recently while working on a project to import data from an Excel worksheet using SSIS, I realized that sometimes the SSIS Package failed even though when there were no changes in the structure/schema of the Excel worksheet. I investigated it and I noticed that the SSIS Package succeeded for some set of files, but for others it failed. I found that the structure/schema of the worksheet from both these sets of Excel files were the same, the data was the only difference. How come just changing the data can make an SSIS Package fail? What actually causes this failure? What can we do to fix it?  Read more...
By Additional Articles 2012/10/08 | Source: MSSQLTips.com | Category: etl
Rating: (not yet rated)  Rate this |   Briefcase | 3,106 reads
   Items 1 to 20 of 66    Older >>
 
Tags
integration services (ssis) (12)    
reporting services (ssrs) (7)    
data mining (5)    
t-sql (5)    
blogs (4)    
extract, transform, load (etl) (3)    
monitoring (3)    
powerpivot (3)    
video (3)    
analysis services (ssas) (2)    
business intelligence (2)    
dax (2)    
editorial (2)    
etl (2)    
power query (2)    
sql server (2)    
sql server 2005 (2)    
sqlclr (2)    
stored procedures (2)    
administration (1)    
affinity (1)    
base 26 (1)    
bcp (1)    
blg (1)    
c# (1)    
column (1)    
cpu (1)    
cross join (1)    
csv (1)    
data dictionary (1)    
data explorer (1)    
data warehouse (1)    
databases (1)    
development (1)    
epplus (1)    
excel 2013 (1)    
export (1)    
extended properties (1)    
geoflow (1)    
graphs (1)    
histogram chart (1)    
insert (1)    
internals (1)    
iterative (1)    
odata (1)    
odbc (1)    
opendatasource (1)    
percentile.inc (1)    
perfmon (1)    
performance tuning (1)    
pivottable (1)    
qlikview (1)    
schedulers (1)    
sheet (1)    
software development (1)    
ssas (1)    
stairway series (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
visualizations (1)