About the changes in PerformancePoint

If you haven’t heard, Microsoft has made changes to the PerformancePoint product alignment. Basically this means PPS no longer exists as a separate product – the dashboard and analytic (M/A) components are being folded into MOSS, while Planning is being “end of life”d. Effective (almost) immediately, if you own rights to PerformancePoint, you now get…

2

Pro PerformancePoint about to hit the shelves!

Well, it took the better part of a year, but my second book, Pro PerformancePoint Server 2007: Building Business Intelligence Solutions (Pro) (APress) should be rolling off the presses as you read this. It’s almost 500 pages, and I tried to cover Microsoft’s entire business intelligence “stack” – from SQL Server (Integration Services, Analysis Services,…

1

All-up BI VPC

For folks who want to play with our Business Intelligence technologies and don’t want to bother with installing everything, you can download a virtual machine image that has just about everything installed you could want, including demo content.  The “All-up BI VPC” has two parts, available at: Part One (3.4 GB) Part Two (1.0 GB)  Yes –…

1

Transposing rows and columns in SQL Server Integration Services

Okay, this was a rough one. The challenge was that a customer had Excel spreadsheets where we needed to transpose the rows and columns. In other words, the spreadsheet looked like this: But we needed the records to list Program values by date, like this: Of course, I did that by simply copying the cells…

1

A simple conceit vs. questions left unasked

Here’s a fun mental exercise – on the one hand, we have the “everyone is lost but me” syndrome, where someone will charge off on a course of action, despite many many warnings about the perilous nature of his quest, until he runs smack dab into that windmill. And yet we have “there is no…

1

Dimension Security in SQL Server Analysis Services

I know, the mind boggles – a developer writing about security… While I was doing the research for this, I was startled by the number of articles on this topic that immediately talk about using MDX queries for dimension security. While MDX queries offer powerful fine-tuning capabilities for restricting access to data in Analysis Services,…

0

This year’s hammer – voice prompts

“When all you have is a hammer, everything looks like a nail” I use this quote a lot to warn against the tendency we have to overimplement new technologies and solutions. Even as I go through InfoPath and BI solutions, I will warn that while InfoPath is a forms solution, it’s not the solution to…

1

Scorecards – SharePoint, SQL Server, or PerformancePoint?

A few years ago, if you asked Microsoft how to build a scorecard, they may have shrugged. Then we released the “Business Scorecard Accelerator” – a free technology mainly designed to showcase SQL Server Analysis Services. It was so popular that Microsoft made a product out of it – Business Scorecard Manager 2005. While BSM…

5

InfoPath & SharePoint screencast demo

As  follow-up to the “hook InfoPath to a database” demo, here I’m taking a step back to a simpler form – building an InfoPath form to be used on its own in conjunction with SharePoint.  https://channel9.msdn.com/ShowPost.aspx?PostID=344635 In the next few videos I’m going to cover: InfoPath, xml schemas, and xml An advanced InfoPath form connected…

3

SQL Server Analysis Services in ten minutes

Analysis Services has been part of SQL Server for a while, but it’s underappreciated by most. I’ve posted another video on Channel 9 to try to share what a powerful capability this is for understanding large volumes of aggregated data. More than just the simple demo (showing a cube, clicking through some dimensions, pulling the…

1