Browse by Tags

All Tags » PowerPivot (RSS)

PowerPivot for the DBA: Part 2 by SQL Azure Team Blog

In this article I am going to continue to tie some simple terminology and methodology in business intelligence with Transact-SQL – bring it down to earth for the DBA. This is a continuation in a s eries of blog posts that I started that equates Transact...
Filed under:

Security Considerations with SQL Azure and PowerPivot by SQL Azure Team Blog

In this former blog post I discussed how to enable access to SQL Azure from PowerPivot. Now that access is enabled and the data is available to you, let’s examine how PowerPivot and SQL Azure work from a security perspective. Accessing the Data In order...
Filed under: ,

Managing Connections in PowerPivot by SQL Azure Team Blog

A good friend of mine that analyzes databases with business intelligence for a living has told me that the majority of his job is knowing the data. PowerPivot makes it very easy to add additional tables, and bring together multiple data sources –allowing...
Filed under:

Getting Started With PowerPivot and SQL Azure by SQL Azure Team Blog

PowerPivot is a powerful, downloadable extension to Microsoft Excel 2010 that allows you to perform business intelligence and analytics against known data sources. One excellent data source you can use is your SQL Azure database. This article will talk...
Filed under: ,
Powered by Community Server (Non-Commercial Edition), by Telligent Systems