Search

1 to 3 of 3
Sort by

Blog Entry
We Have Machines That Can Do This

There are two basic math problems on the chalkboards of our earthly cosmos: A. Quantification: How much of something there is. B. Qualification: How to set up an equation that helps resolve A. The worlds of finance and budgeting revolve around A. Even the turgid arts of...

Marc Solomon's profile image

Blog Entry
Least Content Denominator

It's 1997 and you just saw the future: your food service specials in your corporate cafeteria for the coming week. Now it's 2004 and the read/writing is on the wall: your file server has been retrofitted into its sparkling new webified front-end. Leapfrog to 2008 and HR's...

Marc Solomon's profile image

Blog Entry
SharePoint Decision Guide – A Best Practices Roadmap and Organizational Strategy by EPC Group - Part 3

The following is an overview of Excel Services 2013 and SharePoint 2013: • Excel Services 2013 is a SharePoint service application that enables the loading, calculation, and browser-based rendering of Excel workbooks (Enterprise Edition only) • Designed to be a scalable, robust, enterprise-class service that provides feature and calculation fidelity with Excel • Delivers rich analysis capabilities that are supported in a zero-footprint web client with a familiar interface • Live connections to data sources are queried to deliver up-to-date data throughout analysis The following is a graphical example of the moving pieces of SharePoint 2013 and how they come together at a very high level: PowerPivot PowerPivot is an add-in for Excel User that provides the ability to create powerful data models that can include calculated fields, reports and scorecards. The following is a summary of PowerPivot and SharePoint 2013: • PowerPivot for SharePoint extends SharePoint 2013 and Excel Services to add server-side processing, collaboration, and document management support for the PowerPivot workbooks published to SharePoint • The PowerPivot Gallery, a special type of document library, is provided to browse published PowerPivot workbooks and to configure automatic data refresh • The PowerPivot Service deploys the embedded data model to an Analysis Service instance within the SharePoint farm, and Excel Services is used to query the deployed data model • Data connections can be defined to query the PowerPivot data model by using the document URL The following screen shot details a PowerPivot Report that I have scheduled to be emailed to me every evening at 6PM Central Standard Time which is also been designed in a way for which I am able to view this on my iPhone: PerformancePoint Services PerformancePoint is one of the most used BI components within SharePoint 2013 and it primarily used to create and share centrally managed dashboards

Errin O'Connor's profile image