Tag Archives: Excel

‘Real-Enough-Time’ Data

Posted on April 2, 2018 by Biggus Dickus

I see and hear a whole lot of noise and effort around the acquisition of “Real-Time” data in their Power BI Reports and Dashboards. I argue here that most times this is simply not necessary nor preferred and that it … Continue reading →

Posted in Excel, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Self-Service BI, Spreadsheets, the Cloud, Uncategorized, XLPublish, XLPublish.com | Tagged , , , , , , | Leave a comment

UK Excel User Conference

Posted on December 1, 2011 by Biggus Dickus

My pal Simon Murphy, aka Smurf, is hosting another Excel User Conference in January in London on Wednesday, Jan 25th, 2012. Here is a link to info on this session.  I think if you’re in the London area and you … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

PowerPivot CTP3 Hierarchies Make All The Difference

Posted on September 26, 2011 by Biggus Dickus

I have been around OLAP databases since 1994.  By “around” I mean that I have used them off and on for all those years without actually becoming a true BI dev – rather I am an occasional consumer. This is … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | 3 Comments

No Mention Of Excel Or Access … Hmmm …

Posted on June 9, 2011 by Biggus Dickus

I just saw an interesting article in the Seattle Times where they interviewed somebody named Kurt DelBene who is apparently the President of the Microsoft Business Division.  From the article (linked below) it seems that this guy DelBene is responsible … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , | 3 Comments

Dynamic Range Names And Charts In Excel 2010

Posted on May 19, 2011 by Biggus Dickus

(Update 05/27/11)  Please be advised that there is a more recent post than this that completely negates the need for the technology mentioned in this Post.  It does not mean this is not a Cool solution (IMHO) but it is … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , | 20 Comments

The Perfect Storm

Posted on April 27, 2011 by Biggus Dickus

For years I have been arguing that the combination of Excel and Access is the strongest “story” in Microsoft Office – and the most ignored.  I have used these two products together and separately to deliver solution after solution that … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | 4 Comments

Excel Careers

Posted on March 21, 2011 by Biggus Dickus

Great post over on friend Simon Murphy’s site about Excel careers (or lack thereof).  Check it out: http://smurfonspreadsheets.wordpress.com/2011/03/21/excel-careers/ Dick

Posted in Uncategorized | Tagged , , , , , | Leave a comment

What Does The Lack Of Microsoft Office Seminars Mean ?

Posted on February 6, 2011 by Biggus Dickus

I just bumped into the SharePoint Conference 2011  on the Internet today ( http://www.mssharepointconference.com/Pages/default.aspx ).  I remember not too long ago that this conference was the Office Developer Conference (maybe 2 years back) and now I see not one reference … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , | 8 Comments

Is Excel 2010 Kinda Fragile ?

Posted on December 28, 2010 by Biggus Dickus

I have once again run into a major probem in Excel 2010 related to doing major surgery on a large file and ending up with it being unwilling to Save and requiring me to perform some serious “sleight-of-hand” to save … Continue reading →

Posted in Uncategorized | Tagged , , , , | 4 Comments

I Didn’t Follow My Own Rules

Posted on December 22, 2010 by Biggus Dickus

I am currently involved deeply in a project that replaces an exisiting spreadsheet-based production-planning system.  The existing user-maintained document is one of the most dangerous spreadsheets I have ever seen. But when contacted to help on this I made a terrible … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , | 5 Comments