Category Archives: PowerPivot

Write SQL Query using Table Import Wizard in PowerPivot

Posted on August 10, 2012 by

Query builder helps us to design SQL queries with simple steps and it is less time-consuming. We also have Query designer in Excel PowerPivot that helps user to design SQL queries to import data easily. Table import wizard query designer is slightly different from … Continue reading →

Posted in PowerPivot | Tagged , , , , , | Leave a comment

Tweets and hashTag Stats in Excel

Posted on June 12, 2011 by

Today, I am going talk about an analytics for Twitter application. It is a PowerPivot application that connects to tweeter within Excel 2010 and gives your tweet statistics. I found it very interesting because, we can pass our own tweet account and … Continue reading →

Posted in Application, PowerPivot | Tagged , | 1 Comment

SharePoint List Data Source in PowerPivot

Posted on June 10, 2011 by

One of the many features of Microsoft SQL Server PowerPivot is the range of data sources that can be used to import data. Anything, from Microsoft SQL Server relational databases, Oracle databases, and Microsoft Access databases, to text documents, can … Continue reading →

Posted in PowerPivot, Whitepaper | Tagged , | 3 Comments

PowerPivot Sample data

Posted on May 20, 2011 by

Hello Reader, People often facing new technologies and happen to work with it. They have enough tutorials and examples to learn the technology very easily. Especially, when it comes to Microsoft technologies then people need not worry about learning. Because, … Continue reading →

Posted in PowerPivot | Tagged , | 2 Comments

Know 10 things about PowerPivot

Posted on May 5, 2011 by

  10 things you can talk about PowerPivot. Click here to Participate PowerPivot Quiz and win an Xbox 360 Thanks to Microsoft PowePivot team.  

Posted in PowerPivot | Leave a comment