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 70    Older >>
 

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 | 2,380 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 | 2,870 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 | 4,707 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 | 5,843 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,642 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,490 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 | 253 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,652 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,247 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,624 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 | 9,026 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,090 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,168 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,532 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,924 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,910 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,749 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,793 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 | 2,040 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,766 reads
   Items 1 to 20 of 70    Older >>
 
Tags
integration services (ssis) (12)    
data mining (9)    
reporting services (ssrs) (7)    
t-sql (5)    
blogs (4)    
analysis services (ssas) (3)    
extract, transform, load (etl) (3)    
monitoring (3)    
powerpivot (3)    
video (3)    
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)    
classification (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)    
profit (1)    
qlikview (1)    
schedulers (1)    
sheet (1)    
software development (1)    
stairway series (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
validation (1)    
visualizations (1)