Is PowerPivot the Next Access? – SQLServerCentral
Is PowerPivot the Next Access? – SQLServerCentral.
I have tried using PowerPivot as an alternative to the dreadful, antiquated MS Query, and it does very well, and it can be a decent replacement for Analysis Services when the cube that is needed doesn’t already exist.
PowerPivot needs support from a well-organized data mart/warehouse where the data can be found and related without too much trouble (via star schema). I have been using Master Data Services to help bring that about.
So I wouldn’t exactly think of it as “the next Access,” with Access’ user interface & report builder features, but I do think of PowerPivot as a next-generation query tool for advanced users.
Comments
Is PowerPivot the Next Access? – SQLServerCentral — No Comments
HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>