tom@gobansaor.com
Excel automation, reporting,
and general data fetching
and cleansing (ETL) services.
+353 87 2055018
Skype: TomGleeson
Eadestown, Naas,Co Kildare, Ireland
www.gobansaor.com
Microsoft has, with Excel 2010, introduced an extremely powerful end-user pivoting tool, the free PowerPivot add-in. The world of self-service data analysis has changed for ever; not only can PowerPivot handle enormous amounts of data but it enables end-users and data analysts alike to build highly complex analytical models at a fraction of their previous cost.
Excel PowerPivot BI/ETL consultancy and development services
Convert database tables, spreadsheets, CSV files, XML files etc. into another format (pivot tables, PowerPivot cubes, PALO cubes, one-to-many, many-to-one, XML to CSV, XML to SQL, etc.). Delivered either as a ...
SERVICE: Send the data to me, I'll return the finished dataset or...
DIY: I'll send you the "code" - usually an Excel Add-in - which you can then apply locally to transform your data.
For more information & prices see
Tom's Micro ETL Service
I've been building Excel-based "Time Assets" for myself and others for nearly 15 years. I can save you time & money by building or helping you build: user defined functions, VBA add-ins,.NET add-ins, reporting & process automation routines, data transformation scripts, in fact any problem you come up with.
For more details and rates see ...
Hello Tom,
There is new release 0.48 on Sourceforge.net . It contains archive with all libraries included, and one small sqlite3 database. Hopefully it’s close enough for one-click install.
For Python versions prior to 2.5 py-sqlite must be installed separately. Also MySQLdb (contains binary code, platform dependent). Sqlite database is not very scalable, the real thing is MySQL 5.1 beta (supports partitioning and is quite stable in spite of “beta”).
Memcached is also _STRONGLY_ recommended ; otherwise for every page submit all cells will be queried over and over again.
Links: online demo : http://alxtoth.webfactional.com/ , source code : http://sourceforge.net/projects/cubulus/ , presentation material : http://cubulus.sourceforge.net/
If you have troubles importing a schema, send the CREATE statements, and estimation of nr rows in each table.
Best Regards, Alexandru
Thanks Alexandru,
I’ve downloaded it and will look at it over the next few days.
Tom
It seems that there is no update recently…
@zz
Yep, no sign of activity since the Oct/Nov of last year.
Tom
Hey Tom
Cubulus ..
Found a link to this – looked like something to play with but seems to be a dead project. Then I found your post!
Do your recent python dabblings dovetail with this in any way?
Could we do anything with it? Get intouch with the author, restart the project?
The idea of running this against my postgreSQL data in a browser is appealing.
Tom
Well….
Your comment about BI being for civilians is true enough – and yeah, cubulus is most definitely heavy artillery
But ……
This ‘civilian’ just got it working against SQLite (latest download version 0.57). Now to hack below the surface to see what gives.
Never thought of writing a ‘PT-alike’ for the web in python – here goes!
Martyn