I am excited by the developments of BI capabilities in excel this year and I want to use the power explorer, view, mapping tools with my sql database.
I have two questions really...
1. Can I extract individual calculations and data from the sql/data model rather than always through a pivot
2. If yes, or no, what would be the best way to build a control excel spreadsheet which monitors performance across key criteria (leads per day, orders per day, cancellations, etc) across regions so that I can see where the business is not operating as expected and act accordingly.
posted by trashcan
on Aug 3, 2013 -
I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
posted by reenum
on Sep 14, 2012 -
Android/cloud-based note app query. I'm looking for recommendations for an Android app that'll accept the large chunk of csv data I have and keep it synced with my PC. [more inside]
posted by jonathanbell
on Jul 23, 2012 -
What efficient systems can one use to report different internal working data generated in a small / medium sized business - excel is too clumsy and a customized database based application feels like an overkill? [more inside]
posted by shalam
on May 17, 2009 -