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.
2013-06-13
7,885 reads
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.
2013-06-07
5,306 reads
This article details an Excel 2010 function to return the cell address of min and max functions.
2013-06-04
5,868 reads
In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.
2013-05-24
4,528 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-04-23 (first published: 2013-04-11)
3,302 reads
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.
2013-04-02
3,815 reads
A brief introduction to getting started with QlikView.
2012-12-17
3,638 reads
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.
2022-04-04 (first published: 2012-12-07)
21,817 reads
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
2012-12-04
7,165 reads
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?
2012-10-08
3,887 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