Written on Dec, 02, 2015 by in | Leave a comment

How to speed up performance of Excel Reduce Operations The number of cell references and operations has the biggest impact on workbook performance, not the number of formulas. A few smaller helper formulas are usually more efficient than one enormous formula. If possible, avoid the use of the same formula repeatedly in multiple cells by taking it out and using …

Continue Reading...
Written on Nov, 11, 2015 by in | Leave a comment

This is a second blog in a four-part series dedicated to building efficient Excel models. Here, I’ll discuss some general recommendations for building lean and mean (and small) Excel models. Although you can build large Excel models, there are several reasons not to. Large Excel models containing multitudes of tables and columns are overkill for most analysis and consume large …

Continue Reading...
Written on Nov, 10, 2015 by in | Leave a comment

When clients think of digital agencies, they are often not sure what to expect. But the one word that jumps out to them is ‘Creative’. This is not necessarily what agencies are about though, or the service they offer. We have this at BlueMetal, an Insight company, where we have ‘creative’ employees and a ‘creative’ department, which we have structured to …

Continue Reading...
Written on Nov, 03, 2015 by in | Leave a comment

Building Efficient Excel Models (part 1 of 4) Recent economic developments across the globe have added to the uncertainty that fueled the recent stock market turbulence as demonstrated by the VIX above reflecting implied volatility of traded option contracts on S&P 500 stocks. The index peaked on Monday, August 24 (otherwise known as “Black Monday” due to the global sell-off …

Continue Reading...
Written on Nov, 03, 2015 by in | Leave a comment

Digital Showrooms are big business now – Tommy Hilfiger and Neiman Marcus have started installing them into select stores to gain insight into consumer appetite. Audi launched a successful digital showroom in London. A heightened digital customer experience that saves on floor-plan because stock is virtually presented has clear business benefits. It works for specific use cases such as a …

Continue Reading...
Written on Oct, 27, 2015 by in | Leave a comment

Retailers have long held for a dream of a connected experience – the idea that you can create a tether between your brand and customers. But technology has never been quite at that point to achieve this vision. Until now. Several factors have combined to now fulfill the tethered brand. The cloud: The cloud has finally reached its original promise …

Continue Reading...
Written on Oct, 20, 2015 by in | Leave a comment

You may have heard recently about LinkedIn being ordered in court to pay $13m in damages as a result of its bad user experience which forces, or tricks, its newly signed users to spamming their contacts without their knowledge. The figure comes from 10 dollars in damages charged to every user. If this had been proved to cause mental anguish, …

Continue Reading...
Written on Oct, 19, 2015 by in | Leave a comment
BobF book

This book provides practical guidance for adopting a high velocity, continuous delivery process to create reliable, scalable, Software-as-a-Service (SaaS) solutions that are designed and built using a microservice architecture, deployed to the Azure cloud, and managed through automation. Microservices, IoT, and Azure offers software developers, architects, and operations engineers’ step-by-step directions for building SaaS applications—applications that are available 24×7, work …

Continue Reading...
Written on Oct, 15, 2015 by in | Leave a comment

The software development landscape has changed dramatically over the past decade. Disruptive technologies and design approaches have introduced entirely new types of applications and methods for building them. There is also a deep desire to move away from big bang releases of software products that take many years to design and build and instead move to a cloud hosted Software-as-a-Service …

Continue Reading...
Written on Oct, 07, 2015 by in | Leave a comment

As many of you know, Insight recently invested heavily in BlueMetal (you can find the press release here). One of the core reasons cited by Insight’s president for investing in us was design, referring to several award-winning projects we had delivered (including EnerNOC). Our strategy and design team is proportionally small (approx 6% of BlueMetal’s workforce) but the impact the team …

Continue Reading...