August 12, 2013 at 7:14 am
Just wondering, it looks like Excel 2013 is going to be really cool for BI... especially stuff like GeoFlow etc for doing sort of "time lapse" sales analysis. Is it just me, or is it a significant upgrade from 2010?
If it is, what are your favorite new features? I saw Kate & Emil's video on Geoflow, and it was seriously awesome. Any other really cool goodies in there that I'm missing?
thanks!
Pieter
August 12, 2013 at 7:39 am
pietlinden (8/12/2013)
Just wondering, it looks like Excel 2013 is going to be really cool for BI... especially stuff like GeoFlow etc for doing sort of "time lapse" sales analysis. Is it just me, or is it a significant upgrade from 2010?If it is, what are your favorite new features? I saw Kate & Emil's video on Geoflow, and it was seriously awesome. Any other really cool goodies in there that I'm missing?
thanks!
Pieter
To me, Geoflow (called Power Map now) is a cool toy, but that's about it. It's great for demo's, but the real business value is not really clear to me. But cool it is 🙂
I think the inclusion of Power View (if you have Office 2013 Professional Plus) is the most significant change for BI in Excel.
Easy to create reports/dashboards at the fingertips of every Excel power user.
Power Pivot is integrated as well, which is also nice.
But don't forget, the native charting capabilities of Excel have been greatly improved. I'm reading Excel 2013 Charts and Graphs right now, and you can do some great stuff with it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 12:39 pm
Thanks Koen, at least now I know if I need to upgrade yet. (Apparently not!)
One sort of follow-up question... I was looking on here for how to execute a stored procedure with parameters from within Excel... something really simple like:
CREATE PROC GetFilteredResult @StartDate DATE, @EndDate DATE
AS
SELECT <column list>
FROM <mytable>
WHERE SomeDate BETWEEN @StartDate AND @EndDate;
But say I had the StartDate and EndDate values in cells in Excel and I wanted to dump the results to a new sheet. I can connect to SQL Server just fine, but I can specify a stored procedure by using the CommandText option, but how would i pass a value from a cell into the stored procedure? (Or is this really an Excel question and the only relevance is that it's executing a stored procedure?)
Basically what I'm trying to do from within Excel is something like
EXEC GetFilteredResult @StartDate = Sheet1!R1C1, @EndDate=Sheet1!R2C1;
but clearly, that's Excel-speak... (I guess I could use named ranges...)
Do I have to use MS Query for that?
Thanks!
August 12, 2013 at 1:02 pm
Whoa whoa, did this thread suddenly become a VBA thread? How did that happen? 😀
You should be able to get the values out of the cells. I've done it in a previous life.
Maybe you should start a new thread in an appropriate forum, it will get you better answers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 1:52 pm
<screeching tires>
Okay, off to a new thread...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply