False. Without a graphical query wizard the newest tools from Microsoft are usable for IT only. Super fat end user is typical for Excel we all know, but the best way is a combination fat and thin server but probably you don't know what i'm talking about.
Where is the FileId if there is no column with country id?
Where is SQL's WHERE clause? (criterias)
Where are joins? To take all data onto Excel side and then to filter? We have the XXI century!
See: http://afin.net/webcasts/ABC_ConsolidateExcelFiles.swf and some other webcast there.
Microsoft has no idea how to teach analysts the professional analysis. We do http://www.szkolenia.ue.wroc.pl/117,165,sql_basics_for_excel_users.html
This is a kind of "excel hell" you propose. To make wonderful charts in Excel is very simply, try to professionally include your pivots into live informatic environment.
My answers
Oh, yeah, Excel is dead...
(for 25 years...)
http://afin.net/afinscript
https://www.facebook.com/afinscript/
Enjoy GETDATAGSHEETS() function!
False. Without a graphical query wizard the newest tools from Microsoft are usable for IT only. Super fat end user is typical for Excel we all know, but the best way is a combination fat and thin server but probably you don't know what i'm talking about.
Where is the FileId if there is no column with country id?
Where is SQL's WHERE clause? (criterias)
Where are joins? To take all data onto Excel side and then to filter? We have the XXI century!
See: http://afin.net/webcasts/ABC_ConsolidateExcelFiles.swf and some other webcast there.
Microsoft has no idea how to teach analysts the professional analysis. We do http://www.szkolenia.ue.wroc.pl/117,165,sql_basics_for_excel_users.html
The is no such thing as a BI.
There are only milions of VLOOKUPs.
http://afin.net/webcasts
Childishness....
You are sweet, with that "For kids"... ;)
4 pivot tables for kids? Why not 8 or 23?
This is a kind of "excel hell" you propose. To make wonderful charts in Excel is very simply, try to professionally include your pivots into live informatic environment.
Wojciech G.
www.afin.net
Childishness.
.
Project Gemini - A loss
-- Wojciech G. (www.afin.net)
Excuse me, but The Project Gemini is the next step to make Excel a fat client.
The Project Gemini "PoverPivot" (hidden OLAP under your Excel sheet) is SLOW in comparition to normal usage of ADO technology.
Task:
Refresh a pivot table based on DBF file with over than 3.000.000 records.
Movie:
afin.net/webcasts/Demo_RefreshData_ADO&AfinNet_...
Results:
ADO & AFIN.NET - 32 s
Excel 2010 & PowerPivot - 110 s
More:
http://afin.net/webcasts/Demo_OlapFunctions_AfinNetVsExcel2010.swf
Even more:
http://afin.net/webcasts