Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

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
Posted by philoj | 2 Comments

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

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
Posted by philoj | 1 Comments

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:
Posted by philoj | 1 Comments
Filed under: ,

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.
Posted by philoj | 1 Comments
Filed under: ,

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
Posted by philoj | 0 Comments

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
Posted by philoj | 1 Comments

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
Posted by philoj | 5 Comments

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. http://channel9.msdn.com/ShowPost.aspx?PostID=344635 In the next few
Posted by philoj | 3 Comments
Filed under: , ,

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
Posted by philoj | 1 Comments

Philo on EDI

I wrote this post on Joel On Software in 2004 in response to a newbie asking about EDI. Since then I have referred several people to it, but a few times I've found the post tricky to find. So, instead of constantly relying on the benevolence of Joel acting
Posted by philoj | 1 Comments
Filed under:

Why InfoPath?

Okay, I'm going to try a different approach on the "why do I care about InfoPath?" issue. I recorded a short screencast and posted it to Channel9: http://channel9.msdn.com/ShowPost.aspx?PostID=343092 In the screencast, I walk through setting up an InfoPath
Posted by philoj | 6 Comments
Filed under:

Urquhart's Avoidance and product futures

I give a lot of product briefings, and of course often get caught between what I know and what I can say. In these cases I often find it useful to use Urquhart's Avoidance, made famous in the BBC miniseries " House of Cards " (which I highly recommend):
Posted by philoj | 0 Comments

"InfoPath isn't part of Office"

Simon said: "Then you find out its not part of the office suite." To be fair, this is somewhat true. At best, it's confusing. With Office 2003, InfoPath wasn't part of the suite you could buy retail or on open license. However, if you bought Office Pro
Posted by philoj | 1 Comments
Filed under:

Why hasn't anyone heard of InfoPath?

I recently wrote a book on InfoPath 2007 . What I find most amazing about the book is that it's evangelizing InfoPath. I've shown a number of developers the book, and when they read the description, their reaction is "wow, InfoPath sounds cool - I should
Posted by philoj | 15 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker