Generic Question regarding PowerPivot & MegaData

[James02]

Hi,

I'm decent with Excel but brand new to BI tools. I'm interested in a good starting point for a project I'm looking to undertake.

Project: I'm doing a financial backtest that will contain approximately 12 million data points & will grow each month. I will need to run Pivot Table reports on it, % Rank some columns, and etc.

Is PowerPivot the best starting point for me? To start watching PowerPivot tutorials? Any other suggestions or ideas?

Thank you!!

 

[scottsen]

Well, you certainly aren't going to want to party on 12 million rows directly in Excel... 12 million+ is easily doable in Power Pivot, though... it's into the range where you have to at least vaguely care about performance. Though, honestly... I would ignore it until it becomes a problem, then loop back and care. You can reach out to me when you those barriers -- perf is my fave

Honestly, I believe the best resources are all things Rob Collie. His books, his online training and his website are all amazing.

 

[James02]

Thanks scottsen. I'll focus on PowerPivot for this project. Wanted to be sure before I go down the wrong path. I've checked out Rob Collie as well, he must be the guy whose running the show on Powerpivotpro.com.