Power Pivot 101

Hello all. In this section let’s look at the basics of power pivot. Power pivot is one of the powerful tools which can help in getting multiple data source and create a pivot table out of it. The data source can be data thru ODBC, from database (like SQL, Access), Azure, Teradata, other excel sheetsContinue reading “Power Pivot 101”

Pivot Table – Advanced Part 02

Hello all. This is the 2nd part of advanced pivot table section. If you missed reading the introduction and 1st part of advanced, check here and here. Let’s use the same data set, as in the previous sections. Let’s look at how sales has happened for the company month on month in terms of %Continue reading “Pivot Table – Advanced Part 02”