I'm not sure about best, but there was an interesting article on GigaOM last week about BeyondCore, which has an interesting take on analytics.
I think the biggest weakness is that open source BI software doesn't always have the best maintenance & support to back them up. If your needs are pretty basic, though, you can't beat the fact that open source options are free and easy to implement.