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.
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]
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]
How can I find the average of multiple columns in excel without selecting each individual row that I want averaged? [more inside]
Quickbooks vs. Excel? My business partner needs some convincing. [more inside]
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]
Excel - Pivoting With Dates [more inside]
My friend works in database applications each day to create in house reports. He's bored and wants to go it alone.
Excel/Graphing - Time vs. usage (y/n) graph [more inside]
How do I sort a column of birthdates in Excel to by month and NOT year? [more inside]