All Things Data: The reason why ERP’s need Business Intelligence

Jon Oesch, VP, Business Intelligence Sales

We go back to the basics in the fifth installment of the All Things Data video series. We take it for granted that in order to see the data in your ERP system, we have to pull it out and work on it first. Do you ever wonder why that is? Learn with this video.

All Things Data: Why is Everyone Talking about BI Software?!

Jon Oesch, VP, Business Intelligence Sales

Why is everyone talking about BI software? Data and the people who consume it are the most important things in a Business Intelligence project. At Jet Reports we think that talking about software takes the focus off what is really important. In our fourth All Things Data video we what the foundation of a successful BI implementation looks like.

Stay tuned for our next All Things Data blog post where we discuss why ERP’s need Business Intelligence.

All Things Data: Pyramids! Egyptians! Wozniak! Innovation!

Jon Oesch, VP, Business Intelligence Sales

The pyramids were a huge project and a lot of work, but were they innovative? If you think that something must be useful to be innovative, then maybe not. In our third installment of All Things Data, I give my perspective on what pyramids have to do with Data Warehouse Automation.


Be on the lookout for our next All Things Data blog post where I explain why everyone is talking about BI software.

All Things Data with Jet Reports

Jon Oesch, VP, Business Intelligence Sales

The IDC reports that it takes 17 months for BI implementation, and 5 months to get the first report. In the second video of our All Things Data series, I discuss how Data Warehouse Automation can deliver a successful BI Project much faster.



Stay tuned for our next All Things Data blog post where I discuss what pyramids, Egyptians and Steve Wozniak all have in common.

All Things Data: Comparing Business Intelligence Options

Jon Oesch, VP, Business Intelligence Sales

Welcome to our new series – All Things Data. In our recent white paper, Comparing BI Solutions, we ask “Why is it so hard to get data out of the Dynamics ERP?” I received a lot of questions regarding the white paper, and made the video below to follow up. In this video I deep dive into why just having an ERP system does not easily produce BI and reports.



Stay tuned for our next All Things Data blog post where I discuss how Data Warehouse Automation can deliver a successful BI project much faster.

Should You Build BI Before You Clean Your Data?

Jon Oesch, VP, Business Intelligence Sales

A New Look on how Business Intelligence Can Fix Your Data Quality Problems

Implementing a business intelligence environment against data you don’t trust?  Sounds counter-intuitive, some would say: ‘just plain wrong.’  How could you possibly build a data warehouse and cubes on data that might not be accurate?  You shouldn’t of course, and that is the point. Accurate data is the non-negotiable cornerstone of any BI effort.

But accurate data does not happen by itself.  Data needs to be enthusiastically governed to a state of truth and reliability, and this is a big job.  So big in fact, that attempting a global data governance initiative can cost so much time and energy as to obliterate the initiatives it was designed to support in the first place.

If your company has an urgent need to manage to 3 or 4 KPI’s around inventory, the 6 months that it might take to understand your inventory data and make sure it is correct is a very long time.

But there is an even bigger risk.  Think about how you find out that you have bad data.  It is almost never by putting data into a system.  You only find out about bad data when you try to get data out.  So this begs the question – if you are going to embark on a data governance initiative before you roll out BI, what exactly are you going to govern?  How do you know what to fix, if you can’t see that it is broken?

Nothing highlights inconsistencies in your data like trying to build a dashboard against it.  Nothing will focus data governance and cleaning efforts like clearly understanding the numbers you need to drive your business.  Not just the numbers themselves, but what are the components of those numbers?  What were the transactions that placed those numbers into the system?  What are the processes around those transactions? Are they contributing to accuracy, or is there something buried in there that is making the numbers faulty?

There is magic in seeing those imperfect numbers appear in an analysis because now you have a clue about what data is broken. BI will give you an effective data governance roadmap, with the starting point in the form of numbers that your subject matter experts and other stakeholders will recognize as wrong.  It is the BI environment itself that makes your numbers accessible.  And with that accessibility, data quality issues become glaring and the root causes behind them become easier to trace.

Implementing BI typically comes in the form of setting priorities:  ‘we need to gain visibility and control over our AR balances first.’  ‘Next we need to tackle inventory, then sales.’  It is an iterative approach to requirements gathering and BI artifact delivery where you see the data flowing out of the system in report form, so you know what to tackle, piece by piece, in terms of data quality.

When companies install a BI solution, they should be prepared to discover that it will highlight all the inconsistencies in their data.  A common one is sales orders that are posted without being attributed to either a customer or a salesperson – revenue is unaccounted for.

‘How can this be?!!” is the usual refrain.  ‘We have business rules around posting invoices that are supposed to prevent this from happening.’

Whether it was an innocent work-around or a full-on policy breach, something, somewhere caused those business rules to be violated.  What once was a hard-to-unravel mystery is now easy to spot, and easy to solve.

These types of discoveries are very hard to make otherwise, where the tendency is to look at data governance as a whole and try to fix the data in the same holistic way.  That becomes an overwhelming project that can stop other initiatives in their tracks.

To read more about how Business Intelligence can help drive data governance take a look at our whitepaper; Implementing Business Intelligence – Why You Should Build BI Before You Clean Your Data. In it we share 4 steps on how to conduct a Data Governance initiative, and highlight one of our favorite management tools – the RACI matrix.


Jonathan Oesch

Loves ERP, Loves Data. Loves what happens when data from a transaction processing system gets turned into usable information that people can rely on; “It’s like that chemistry lab in college where you walk in with your raw supplies and leave with a perfectly round rubber ball.”

VP of Business Intelligence Sales at Jet Reports. Speaks, writes, blogs and tweets about BI strategy – sometimes in his sleep.

New Buzzword! Data Warehouse Automation

Jon Oesch, VP, Business Intelligence Sales

A survey by IDC and DM Review gives us these scary statistics:

  • 17 months is the average implementation time for a BI project
  • 5 months needed on average to deploy the first usable BI artifact
  • $1.1m is the mean, annual expenditure on a BI project for companies with more than 1,000 employees
  • 31% of BI projects are declared successful
  • 36% confidence rate that the right data is available to the right people at the right time

Those numbers seem unrealistically horrible, yet as a company that builds and deploys BI environments for hundreds of companies each year, we see IT groups and business users facing them all the time. That is why Data Warehouse Automation (DWA) is such an exciting concept. (more…)

Business Intelligence Education Series

Brandon Boyd

The Jet Reports Business Intelligence Education Series is back by popular demand. Join Jet Reports’ own Business Intelligence experts, Brian Petersen and Lars Rasmussen, and fellow Microsoft Dynamics Users for 30 minute, informative webinars to learn and collaborate on the latest topics in BI.

Our Director of Business Intelligence, Brian Petersen will lead the US webinars. Brian has been with Jet Reports for almost 9 years and manages our team of BI consultants. Lars Rasmussen, Jet Reports Senior BI Analyst, is based out of our European office and he will lead the webinars in the UK time zone. (more…)

Happy Holidays!

Brandon Boyd

Happy holidays from your friends at Jet Reports! It’s been a great year, thanks to our wonderful customers and partners. Please enjoy this holiday animation we created for you.

We wish you a prosperous 2015 filled with new insight and endless possibility.


Thinking About Upgrading to NAV 2015? Checkout This New eBook for a Definitive Guide

Janice Taylor, Jet Reports Canada

Catapult, a Microsoft Dynamics NAV partner, has teamed with Jet Reports and other industry experts to create a resource for companies that are looking to upgrade their Dynamics NAV systems to NAV 2015, and want some guidance about where to start and how to manage the process.

Free to download on the Catapult website, the eBook, titled “Planning Your Upgrade to Dynamics NAV 2015: The Definitive Guide” provides a comprehensive framework for completing a successful NAV upgrade. (more…)

Jet Reports Blog Jet Reports Facebook Jet Reports Twitter Jet Reports Company Profile LinkedIn