SQLug.se – Rob Collie – PowerPivot Deep Dive, part 1/4

We found another clip that we felt was worth passing on. It’s ” SQLug.se – Rob Collie – PowerPivot Deep Dive, part 1/4 “.

Read more

SQLug.se – Rob Collie – PowerPivot Deep Dive, part 2/4

We found another clip that we felt was worth passing on. It’s ” SQLug.se – Rob Collie – PowerPivot Deep Dive, part 2/4 “.

Read more

Microsoft SQL Denali: New PowerPivot for Excel Features

Many businesses have been leveraging the power of Microsoft PowerPivot for Excel 2010 since its release almost one year ago. PowerPivot for Excel allows business-level users to pull data from structured sources like SQL, Oracle, and DB2 in order to compare with industry trends. PowerPivot removes the onus of defining relationships from the user and […]

Read more

Excel Report – 10 Golden Formulas For Reporting and Analyzing Business Data

A lot is being said about the Excel inefficiency to store and query data, I have noticed that these comments almost always come from database developers, BI industry guys, or from people who push Excel to the boundaries of dealing with large amount of data. Excel can help you with your reports… It is true […]

Read more

Sensitivity Analysis in Microsoft Excel

One of the finest features in Microsoft Excel is sensitivity analysis using either a table (Excel 2003) or ‘What-if’ in Excel 2007. Suppose you want to start a cybercafe or a restaurant in a new mall. You have done a study on the footfall and the kind of people who visit the mall. You have […]

Read more

Sharepoint 2010 Business Intelligence For Enterprise Solutions

Business Intelligence (BI) software attempts to collect, organize, analyze, and distribute an organization’s business data so as to strengthen key decisions regarding costs, performance, and future ventures. This article focuses on the BI capabilities Sharepoint 2010′s and its attendant software such as Excel, SQL Server PowerPivot, and SQL Server Reporting Services. In conjunction with Sharepoint […]

Read more

Leveraging PowerPivot for SharePoint to Enhance Business Intelligence Solutions

As you may or may not know, Microsoft PowerPivot is a powerful business intelligence tool that can be used with both Microsoft Excel 2010 and Microsoft SharePoint 2010. When used with Excel, PowerPivot can pull data from numerous sources and compile literally millions of rows of data for easy analysis, but those who are pondering […]

Read more

How Can PowerPivot for Excel Improve Your Business Intelligence Experience?

If your business is like many others, it’s reliant on multiple sources of data to make strategic plans and to measure ROI. This could mean spreadsheets, online data feeds, complex reports, or any number of other sources. Typically, this level of diversity creates a mess for users who are trying to manage this data and […]

Read more

Microsoft SQL Denali: New PowerPivot for Excel Features

Many businesses have been leveraging the power of Microsoft PowerPivot for Excel 2010 since its release almost one year ago. PowerPivot for Excel allows business-level users to pull data from structured sources like SQL, Oracle, and DB2 in order to compare with industry trends. PowerPivot removes the onus of defining relationships from the user and […]

Read more