Data Mining Part 18: Excel and Data Mining
In this new article, we will introduce you to Microsoft Excel and Data Mining.
2014-10-08
7,477 reads
In this new article, we will introduce you to Microsoft Excel and Data Mining.
2014-10-08
7,477 reads
It is not always easy to do what Excel does with PERCENTILE.INC. Learn what formulas to use in this article.
2014-04-28
3,835 reads
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.
2016-01-22 (first published: 2014-02-11)
18,085 reads
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.
2014-01-21
266 reads
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.
2013-12-04
3,337 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,704 reads
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.
2013-10-09
4,530 reads
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.
2013-09-05
4,816 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-09-04 (first published: 2013-08-28)
2,103 reads
Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings...
2013-08-22 (first published: 2013-08-19)
4,878 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers