Power Pivot for Microsoft Excel is a great self-service business intelligence (BI) tool that lets Excel power users build pretty sophisticated models that help them and their target audience analyze business data. Consequently, it is very common to see Power Pivot workbooks being distributed among users in an organization. The recommended methodology is to upload the Power Pivot workbook to a Microsoft SharePoint Enterprise site and let users access the file through that site. Another option is to upgrade the Power Pivot model to a tabular model and let users connect to the tabular model through Excel. (more…)
WHAT CAN SOLIDQ DO FOR YOU?
Whether you need to enhance an existing platform or design an entirely new solution, SolidQ offers a suite of services to help you architect, integrate and optimize your Microsoft information platform.