Tag Archives: Office Development

How To Really Publish Excel Data To Power BI … Part III

Posted on October 16, 2016 by Biggus Dickus

OK .. Let’s go … Part III … !! In this post I will try to explain how (and especially how not) to get your Excel data into Power BI Desktop in a way that will allow you to schedule refreshes … Continue reading →

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, the Cloud, Uncategorized, VBA | Tagged Excel 2016, Office Development | 4 Comments

Data Access IS The Problem

Posted on October 26, 2011 by Biggus Dickus

I have harped on this here before, but once again my blood-pressure is rising because I have seen a simple, efficient use of the powers of Excel marginalized by a client’s inability to get support and cooperation from the “Gate-Keepers” … Continue reading →

Posted in Uncategorized | Tagged Consulting, Information Worker, Microsoft Excel, Microsoft Excel 2010, Office Development | 15 Comments

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 Access 2010, Access and SQL Server, Cubes, Excel, Excel 2010, Hierarchies, Information Worker, Microsoft Access 2010, Microsoft Excel, Microsoft Excel 2010, Office 2010, Office Development, OLAP, PowerPivot, SQL Server | 3 Comments

Let’s Push Access Services

Posted on September 19, 2011 by Biggus Dickus

The last year and a half hits on my Blog have steadily increased (despite my postings steadily decreasing :-)). There is a simple reason for this…. People are reaching out to find out about Access Services and yet, frankly, there doesn’t … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access Services, Information Worker, Microsoft Access 2010, Office Development, SharePoint 2010 | 10 Comments

What I Did This Summer

Posted on September 7, 2011 by Biggus Dickus

I have now returned home to Canada after an extended stay in the Netherlands over the summer working on an Access Services project. Beyond the fact that there are much worse places to hang out than Holland, I also learned … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access Services, Consulting, Excel 2010, Information Worker, Microsoft Access 2010, Microsoft Excel 2010, Office 2010, Office Development, SharePoint 2010 | 4 Comments

Dutch Treat

Posted on July 13, 2011 by Biggus Dickus

Sorry for not blogging lately (as is if anyone actually comes here – actually quite a few do). I have been busy, busy on a project in Europe while working evenings back in North America. I actually like this double-time … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access Services, Information Worker, Microsoft Access 2010, Office Development, SharePoint 2010, VBA | 6 Comments

Access and Terminal Services May Be The Hot New Thing

Posted on June 12, 2011 by Biggus Dickus

There is an interesting blog post on the Access Team site that discusses and links to another post by Luke Chung over at FMS tat talks about using Access with Terminal Services (TS) and the new RemoteApp technology in Windows … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Access Services, Citrix, Microsoft Access, Microsoft Access 2010, Office Development, RemoteApp, Terminal Services | 7 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 Access, Access 2010, Access Services, Excel, Excel 2010, Information Worker, Microsoft Access, Microsoft Access 2010, Microsoft Excel, Microsoft Excel 2010, Office Development | 3 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 Access, Access 2010, Access and SQL Server, Access Services, Excel, Excel 2010, Information Worker, Microsoft Access, Microsoft Access 2010, Microsoft Excel, Microsoft Excel 2010, Office 2010, Office Development, SharePoint, SharePoint 2010 | 4 Comments

Making Access Forms More Screen Responsive

Posted on April 14, 2011 by Biggus Dickus

I am unfortunately one those developers with a policy of “If it ain’t broke don’t fix it.” Sometimes that’s a good thing but other times that can be a limiter on personal growth. I mean this in the context of … Continue reading →

Posted in Uncategorized | Tagged Access, Access 2010, Microsoft Access, Microsoft Access 2010, Office Development, Screen Resolution, VBA | 1 Comment

Tag Archives: Office Development

Archives

Meta