Entries by James Beresford

Data Quality: Enter the 4th Dimension

Data quality a uniform cause of deep pain in BI projects. The more systems that are involved the harder it gets to clear it up, before you even start accounting for how old they are, how up to speed the SME’s are, how poor front end validation was – there’s a host of potential problems. […]

How do you make sure your BI Strategy works?

The beauty of “strategies” for some is that a strategy – unlike a tactic – often doesn’t come with any clear success / fail KPI’s. It allows a lot of wriggle room for ambiguous assessments of whether it worked or not. However any self-respecting BI strategy should not allow this. After all, it is in […]

PowerPivot Succinctly – free Book by Agile BI Director James Beresford

Want to learn more about PowerPivot? Syncfusion have published a free new eBook “PowerPivot Succinctly” written by Agile BI Director James Beresford. Did you know you can handle millions of rows of data on your desktop? Build interactive charts and tables that analyse that data instantly? Create dashboards that bring together related data without needing […]

What makes BI different from an Agile perspective?

Let’s start with a bold proposition: Waterfall doesn’t work for BI. Agile doesn’t work for BI. Why doesn’t Waterfall work? On the face of it, the reasons for Waterfall not working for BI are easy to tease out for those familiar with the field. Waterfall requires fixed inputs and outputs with a high degree of […]

The fine art of starting to adopt Agile with a Zero sprint

Agile methodologies have a patchy track record in BI/DW projects. A lot of this is to do with adopting the methodologies themselves – as I’ve alluded to in prior posts there are a heap of obstacles in the way that are cultural, process and ability based. I was discussing agile adoption with a client who […]

Productivity issues for Agile in BI/DW – Part 2: Technology

Agile in a BI/DW environment faces a unique set of challenges that make becoming productive more difficult. These issues fall into a couple of categories. First are the difficulties in  getting the team to the productivity nirvana promised, which I covered in this post. Second are the difficulties posed by technology and process, which I’ll […]

Productivity issues for Agile in BI/DW – part 1: People

Agile in a BI/DW environment faces a unique set of challenges that make becoming productive more difficult. These issues fall into a couple of categories. First are the difficulties in getting the team to the productivity nirvana promised. Second are the difficulties in simply being productive. Today I’ll focus on the first case. Productivity nirvana […]