As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...  Read more...

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...

A brief introduction to getting started with QlikView.  Read more...

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...

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...

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...

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...

So you want to group your data for charting in Excel? Here's how, the easy way!  Read more...

Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...  Read more...

A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.  Read more...

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...

Today Steve Jones talks about a new use for cloud computing with Excel to analyze large sets of data.  Read more...

Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.  Read more...

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...

This article demonstrates using SQL Server's data mining capabilities with the Excel.  Read more...

It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed  Read more...

The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.  Read more...

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...

Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.  Read more...

We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.  Read more...