Cut Reporting and Analytics Spend by 99% —The Proof

Katherine Rice, Marketing and Events Coordinator

High spend approach to reporting and analytics-week2

Part 4 of 4

We’ve spent the last 3 blog posts of this series exploring the High Spend, Slow Time-To-Value vs. Low Spend, Rapid Time-To-Value approach to reporting and analytics. You’ve seen how the numbers, statistics, facts and examples illustrate the undeniable advantage of using the Low Spend approach with Jet Reports to yield greater return than monetary savings alone. More accurate data. Faster decisions. Increased profitability. Instant changes, upgrades and modifications. Elimination of copy-and-paste Excel mania.

And now my friends? Proof that we weren’t just making this stuff up.

Jet Reports customer Kinsey’s Archery, a wholesale distributor of hunting and fishing equipment for more than 50 years, purchased Microsoft Dynamics NAV and relied on their 2-person IT team to fulfill their reporting needs. It was quickly decided that being entirely dependent on IT was not a sustainable solution and implemented Jet Enterprise to solve the bottleneck. After the initial installation of just two hours, they fully implemented their customized Jet Enterprise BI and analytics solution in under two weeks, and have been leveraging their business data to capture new growth ever since – 32% growth, to be exact.

The overview:

  • Implementation time: less than 2 weeks
  • Total SQL Reports:
    • Before implementation: 127
    • After implementation: 4
    • IT staff time writing reports:
      • Before implementation: 20 hours a month (60 hours per quarter)
      • After implementation: 2 hours per quarter (less than 1 hour per month)
      • Total Time Savings: 99%
      • Revenue Growth since implementation: 32%

Read the full case study to find out more.

 

Low Spend Reporting to the Rescue: Recovering Time, Money and Resources

Katherine Rice, Marketing and Events Coordinator

High spend approach to reporting and analytics-week2

Part 3 of 4

There is a better way

Now that we’ve established that the High Spend, Slow Time to Value approach to reporting and analytics may not be ideal because of its rigid structure, expensive upkeep and time consuming changes that unnecessarily cost tens of thousands (among other things), it’s time to look at the alternative.

The Low Spend, Rapid Time-to-Value approach starts with an out-of-the-box reporting and analytics solution built for your Microsoft Dynamics ERP, inside the Excel application users are already familiar with and ready to use immediately. A solution like Jet Reports.

While the High Spend approach has you spending an average of 25% of your ERP deployment (which can vary greatly, but from $100k-$300k on average) on reporting, that figure drops in half with the low spend approach. And while there are a number of factors are associated with the overall monetary investment for the low spend approach (think number of licenses, legacy or other database connections, and training), your still  only looking at an overall initial investment of $5,000 – $20,000 with Jet Reports.

When your organization requires new reports, changes to the original reports or the inevitable “innocent” modifications that can get requested on a daily basis, you are no longer at the mercy of the programmer availability at a consulting firm or your internal IT bottleneck. Users can create their own reports in a fraction of the time using a familiar interface – Excel.

This also makes changes and updates to reports quick and easy, plus you eliminate the need to copy, paste or export the data into a spreadsheet. Which, let’s face it, you ultimately do with hard coded reports anyway. But when you do, this adds time and an error-prone layer of piecing your report together. Now, with Jet Reports and the Low Spend approach, you are looking at no more than 5-30 minutes per report, versus the 5-21 hours we saw with the High Spend approach, and accurate data directly from your ERP in Excel.

And what about those dreaded ERP upgrades that can require as much as 50-80% of the cost allocated just for reporting updates? They are whittled down to 1%, at most, of your upgrade budget – and that is only if you have moved information in the ERP database, which is rare. In most instances, there is no cost factor at all because Jet Reports automatically and seamless updates with the latest version of your Microsoft ERP.

Using the Low Spend, rapid-time-to-value approach means you’re looking at an average of 80% total savings on reporting spend and up to 97% savings on reporting time when compared directly to the High Spend, Slow Time to Value approach.

The Low Spend approach can be summed up in three quick facts:

  1. Since many of the reports you need are available out-of-the-box, your total cost of reporting goes down, and your time-to-value speeds up rapidly.
  2. Since the interface for reporting is inside Excel, creating and modifying custom dashboards and reports is in a familiar environment, is quick and easy, and eliminates error-prone, time-consuming copy and paste tasks.
  3. When your ERP system is upgraded, Jet Reports automatically upgrades your existing reports.

With Jet Reports, you can create, edit and upgrade reports in minutes without calling upon expensive consultants, developers or time-constrained IT professionals to make it happen. By having the ability to not only utilize, but optimize, your corporate data, you’ll experience rapid-time-to-value and unparalleled access to accurate information for smarter decision making.

Are you ready for the proof? In the next, and final, post of this series we will share the staggering returns one Jet Reports customer experienced almost instantly.

High Spend Reporting: Uncovering the Problem

Katherine Rice, Marketing and Events Coordinator

High spend approach to reporting and analytics-week2

Part 2 of 4 special blog series

Of all the line items that go into an ERP investment, report writing accounts for as much as 25% of your total investment. That’s 13% more than data migration, 15% more than design and 20% more than testing of the system itself.

As we mentioned in our first post of this High Spend Reporting series, reporting is both the most valuable piece and single largest expense item in an ERP investment. For good reason. In today’s global marketplace, any advantage a company can have over their competition – including smarter, faster decisions based on accurate analytics and reporting — the better off (more profitable) they will be.

Three things in life are certain: death, taxes and report changes

Now that the ERP system is up and running and you have all the reports you’ve ever dreamed of, it’s smooth sailing. Right? Think again! Inevitably, there will come a time where your organization requires new reports, changes to the original reports, some “innocent” modifications, and report variations. With the high spend, slow time to value approach, you essentially have 3 options for writing, changing and/or upgrading your custom reports:

  1. Contract a consulting and services firm to help ensure you are up and running with the reports you need… for a mere additional investment of $195-$295 USD per hour.
  2. Hire a new programmer that already has the expertise! On a per hour basis, a less expensive approach than option 1. But is hiring someone for only a handful reports really justifiable? And how long will it take to fill that position? Do you have the time?
  3. Have one of your current programmers figure out how to write the reports inside the ERP application. This is assuming they have the bandwidth to take on new projects. Do they have the time?

No matter which option is chosen, having a report hard coded in the ERP application will still take anywhere from 5-21 hours per report. You’re probably already running the math on the cost. The more important question is, can you wait that long for the answers you need?

And let’s not forget ERP upgrades. With those upgrades, comes another round of report writing to make them compatible (aka: actually work) with the shiny new version of your ERP.

The largest portion of time spent when upgrading ERP solutions is the report updates. And it typically costs about the same as when you had it written initially. In fact, it can be 50-80% of the entire upgrade deployment.*

*estimates provided by two independent NAV upgrade solution centers in Eastern Europe

So the questions stands… Why might companies be encouraged to take this high spend approach to reporting and analytics? Some will argue it is a “better way.” Some simply don’t know about any other way. And some are under the advice of those who prefer to optimize their billing and utilization rates, even when they know there are alternatives.

Are you ready to discover a cost-effective, better, faster, more accurate, less time consuming way? In the next post of this series, we will take a closer look at the low spend, rapid time to value approach to reporting and analytics to uncover where you can save up to 80% of your spend, up to 99% of the time to get the data you need, and increase your revenue by 32%.

 

Cut Reporting and Analytics Spend by 80% to Get Data 99% Quicker

Katherine Rice, Marketing and Events Coordinator

High spend approach to reporting and analytics

Part 1 of 4 special blog series

Follow the data, Find the Money

This year IDC announced that “Better, faster decision making as a result of data analysis can capture $2,628 per employee in additional revenue.” I can see you crunching the numbers… $2,628 x 100 employees = $262,000 unseen revenue. Ready to take advantage of those lost dollars? It all comes down to how you utilize, and optimize, a rich resource you already possess: corporate data.

Those statistics illustrate why reporting serves as the most important and impactful component of an ERP outlay like Microsoft Dynamics NAV. Executives and managers demand visibility on the data that goes into the corporate business systems to make quick, informed decisions every day. But at an average of 25% of the initial ERP investment, plus up to 50% of deployment fees during upgrades – reporting and analytics traditionally serve as the biggest upfront and ongoing expense.

That staggering statistic isn’t even taking into account the inevitable changes and needed variations to reports, which can more than double your spend and leave you in the dark for days waiting in line.

It doesn’t have to be this way. When it comes to turning your data into useful reports and dashboards that can uncover hidden revenue, your organization has two options: the high spend, long time to value approach, or the low spend, rapid time to value approach.

Where you’re at now – feeling locked in?

If your company uses Microsoft Dynamics, what are your current reporting options? In Microsoft Dynamics NAV 2013, for example, custom RDLC reports can be created and edited in Microsoft Visual Studio, but that process isn’t easy or fast, and it’s not designed for end users to do themselves. These reports must be hard coded by a programmer, so you’ll either need to contract it out – at up to $295 per hour – or if you’re one of the few companies to have an IT team member on staff with the expertise, consider yourself lucky, but get in line.

Of course, even when you get that part of the equation figured out, there’s more to consider: your hard coded reports aren’t how you want them to look, they have a slow turn-around time, and they aren’t flexible enough to make variations or modifications. Over and over, you will have to open up the pocket book to re-code, or take your IT request ticket number and wait, when the inevitable change requests come in.

There is another way.

Consider this: the time and expertise required to create a report comes from one main source: user interface.

Let’s say there is an option where all the data structure work is done for you already, you can instantly grab the information you need to create any report or analysis you want, and was already in Excel? Variations of your reports take minutes, not hours. And as a user, you can get them when you want, where you want, yourself – without relying on expensive resources and without any special knowledge or expertise.

This, my friend, is the backbone of what translates to a low spend, rapid time to value approach with reporting and analytics that can save you up to 80% of your spend, up to 99% of the time to get the data you need, and increase your revenue by 32%.

These numbers aren’t arbitrary. They are real, and they are demonstrated with real companies like yours. But hold tight, we’ll get to that.

The devil is in the details

You might be thinking, “Okay, how much time and money are we really talking about anyway?

Great question! I’m here to show you not only how to take the low spend, rapid time to value approach, but to prove to you that the payoff is undeniable.

In the next post of this blog series, we’ll take a deeper dive into the high spend, long time to value approach and show you, by the numbers, where money leaks out the door, and where you might get stuck without the data you need.

Using BI to Get the Most out of Account Schedules in NAV

Brandon Boyd, Marketing Programs Manager

Register for this webinar and see how easy it is to create pixel perfect financial statements built on top of a powerful business intelligence solution, all while using NAV for worry-free template maintenance.

About the BI Advantage Webinar Series

It’s proven that data-driven companies consistently outperform their competitors, so how can you become the expert and the hero in a short amount of time?

Join Jet Reports and other Dynamics users to learn how you can leverage technology to gain clear insight and make quick, informed decisions that drive profitable change. Business Intelligence is a hot topic for a reason, and this webinar series will showcase practical demonstrations of BI in action.

While you are here, don’t forget to register ahead for these other exciting online events in the BI Advantage Webinar Series.

 

Top Jet Reports Videos and White Papers of 2015

Brandon Boyd, Marketing Programs Manager

Jet-Reports-2015-header-blog

Most popular white papers of 2015

Comparing BI Solutions White Paper
Microsoft Dynamics ERP systems include powerful BI and reporting capabilities and third-party solutions offer some distinct advantages. Where should you start? Here’s a guide that contains critical questions to ask to ensure you make the right decision for your company.

Data Migration White Paper
This must-read white paper from the Jet Reports business intelligence team explores the latest thinking on how to change your ERP system and still keep your data (and your money, and your sanity).

Top 10 Reporting Best Practices Guide
Whether you’re a spreadsheet expert, or just getting started creating business reports, we created this guide to help simplify your report creation process.

Most Popular videos of 2015

BI and Reporting from Jet Reports
Every day the market discovers new things about data. New ways to explore it, present it and manage it. Here’s how Jet Reports can help your business grow.

Power BI – Aggregate Data by Time, Using Date Tables in Power BI Desktop
This Power BI tutorial video shows you how to add a table to your Power BI data model and aggregate your data by time for deeper analysis.

Excel Quick Tip- Manipulate the layout of your Pivot Tables with Design Features
Learn how to manipulate and organize Pivot Table data in Excel so you can improve the clarity and usability in your reports.

Business Intelligence is Like a Restaurant

Brandon Boyd, Marketing Programs Manager

Check out our new infographic that helps make explaining Business Intelligence easier by relating it to something everyone loves – FOOD!”


BI is Like a Restaurant Preview
(more…)

The 5-Minute Dashboard Webinar

Brandon Boyd, Marketing Programs Manager

Register for this webinar and you’ll see how quick and easy it is to create powerful, rich dashboards in Excel and deliver them to business users throughout your organization.

About the BI Advantage Webinar Series

It’s proven that data-driven companies consistently outperform their competitors, so how can you become the expert and the hero in a short amount of time?

Join Jet Reports and other Dynamics users to learn how you can leverage technology to gain clear insight and make quick, informed decisions that drive profitable change. Business Intelligence is a hot topic for a reason, and this webinar series will showcase practical demonstrations of BI in action.

While you are here, don’t forget to register ahead for these other exciting online events in the BI Advantage Webinar Series.

 

Join Jet Reports in Reno for NAVUG Summit 2015

Tara Grant, Vice President of Marketing

We invite you to join us at NAVUG Summit 2015 in Reno next month and have some exciting news if you are attending! As a valued Jet Reports customer, there are unique training opportunities, exclusive discounts, and valuable resources available at the show.

Simply tell us if you are going, or might be, by filling out this quick, 20 second form and you will get immediate access to a $100 off registration code* and key information to plan the most valuable show experience ever. Access exclusive Jet training classes along with Excel, BI and reporting sessions hosted by Jet Reports team members.

This event is a fantastic opportunity to learn in a collaborative environment, share Dynamics knowledge, and take advantage of unrivaled networking opportunities. But hurry, the registration discount expires September 30, 2015 and our classes are filling up.

We look forward to seeing you #INReno. Be sure to stop by booth number 210 during the evening receptions and join our beer pong tournament.

Business Intelligence Webinar Series with MSDynamicsWorld.com

Brandon Boyd, Marketing Programs Manager

Jet Reports is pleased to announce that we are pairing up with MSDynamicsWorld.com for a whole week of Jet Reports webinars. The series features three, hour-long webinars, each focusing on an important topic in business intelligence.

Sign up for one or all three!

BI for Dynamics AX: The Path to Project Success

Sept 29 at 11:00am PT

Dashboards, Analytics, Reporting: Oh My!  This session will uncover some main roadblocks to your BI project and show you how to quickly overcome them to focus on the important stuff, like getting dashboards, reports and analytics into your users’ hands! You’ll hear firsthand from a Jet Reports client how Jet Enterprise has changed their business, and then look at a live demo that shows you how rapidly you can have a powerful BI solution working for you in your own organization.  Topics covered include:

  • How quickly you can expect to implement
  • How easy is it to make changes once everything is ‘all set’
  • The best way to make your BI solution match your business model
  • A Real BI story from a fellow Dynamics AX user
  • A Live demonstration of BI in action

The 5 Minute NAV Dashboard: It’s Easier than you Think

September 30 at 12pm PT

Dashboards, Analytics, Reporting: Oh My!  See how quick and easy it is to create powerful, rich dashboards and deliver them to business users throughout your organization. Understand why industry leaders choose Jet Reports over all other Business Intelligence solutions in the market.  You’ll hear firsthand from a Jet client how Jet Reports has changed their business, and then look at a live demo of how easily and quickly you can create reports & dashboards for your own organization.  Topics covered will include:

  • How to quickly and easily create a NAV Dashboard
  • Why not every BI solution is “the same”
  • The reason analytics plus full-featured operational reporting in one solution matters
  • A Real BI and reporting story from a fellow Dynamics NAV user

How to Sell BI to Your Customers…and Why You Should.

October 1 at 12pm PT

Your customers demand business visibility, so why is it difficult to help them understand business intelligence, and why should you bother? In this session, we will cover the quickest, most effective way to show and communicate the value of BI with your customers. You’ll hear firsthand how Jet Reports has redefined the sales process for a successful NAV partner, and how it has helped them grow their business. Topics covered will include:

  • How to use dashboards and reports to sell new NAV deals
  • The benefits of showing BI vs. traditional reporting methods
  • Out-of-the-box capabilities and ROI
  • What is the target market for a BI tool?
  • How Jet makes it easy for our partners

 

Excel QuickTips: Using design features to format PivotTables

Tara Grant, Vice President of Marketing

Today’s installment of Excel QuickTips is all about formatting your PivotTables using the Design Features. This video shows you how to quickly change the layout of PivotTables to make them easier to read, including how to remove subtotal rows.

Watch this video to learn how.

 

Stay tuned for more QuickTips from Jet Reports on our blog or subscribe to our YouTube Channel.

All Things Data: Distinct Threats to Your BI Implementation Part IV

Jon Oesch, VP, Business Intelligence Sales

Hello and welcome to the final installment of “9 Threats to Your BI Implementation”! So far I’ve covered everything from ‘How does your IT group fit in’, to: ‘How might you evaluate pre-built reports’. In the final video I’ll cover:

  • #8: Why is my gross profit figure different from yours?
  • #9: Strategy? That sounds like overkill

Watch our latest video to find out how these are threats to your business intelligence implementation.

Thanks for watching the “9 Distinct Threats to Your BI Implementation” series. Stay tuned to our blog for more “All Things Data” videos.

 

All Things Data: Distinct Threats to Your BI Implementation Part III

Jon Oesch, VP, Business Intelligence Sales

Welcome back to the third installment of the “9 Threats to Your BI Implementation”. Today’s video continues our series about the nine threats to your BI implementation. So far I’ve covered everything from ‘How does your IT group fit in’, to: ‘What to look for in an implementation partner.’

In today’s video, I jump into the next two threats:

  • #6: Finally, it’s perfect
  • #7: Just give me a dashboard. Now!

Watch our latest video to find out how these are threats to your business intelligence implementation.

Stay tuned to the Jet Reports blog to make sure you don’t miss out on the final video where I’ll talk about the mystical “one version of the truth”.

 

The Top 10 Best Practices Guide to Reporting

Tara Grant, Vice President of Marketing

Sure-fire tips for writing stunning reports

Whether you’re a spreadsheet expert, or just getting started creating business reports, we created this guide to help simplify your report creation process.

A recent research study found that over 88% of spreadsheets contain some kind of error. In some large spreadsheets, there will be dozens of undetected errors. Learn more about how to prevent unwanted mistakes in your reports by downloading the free guide today.

Inside you’ll learn:

  • How to make reports more interactive
  • Secrets to increased report usability
  • How to tune reports for performance
  • How to tailor a report for your audience
  • The power of summarized data

Download the free guide now to learn from our business reporting experts


All Things Data: Distinct Threats to Your BI Implementation Part II

Jon Oesch, VP, Business Intelligence Sales

The latest installment of “All Things Data” continues our series about the nine threats to your BI implementation. Last time I talked about the real role of IT in your BI effort, and about how Excel, as great as it is, can sometimes hurt you. In today’s video, I jump into the next three threats:

• #3: Data quality issues
• #4: There are way too many options out there
• #5: Let’s just use our current IT partner to do this

Watch our latest video to find out how these are threats to your business intelligence implementation.

Stay tuned to the Jet Reports blog to make sure you don’t miss out on the next video where I’ll discuss how long BI implementations should really take.

Shorter BI Implementations: What You Need to Know

Tara Grant, Vice President of Marketing

White Paper: Shorter BI Implementations:

In this white paper we will explore some ways to get to the desired state: BI up and running with the ‘right’ data. We will highlight some key strategies for accelerating implementation time for BI projects and the ancillary benefits these approaches bring to an organization.

Download this free white paper now.

Excel QuickTips: Grouping Data with PivotTables

Brandon Boyd, Marketing Programs Manager

Today’s installment of Excel QuickTips is about grouping by date with PivotTables. In this video, you will learn to group information by months, quarters or years in an Excel PivotTable.

Watch this three-minute video to learn how.

 

Stay tuned for more QuickTips from Jet Reports on our blog or subscribe to our YouTube Channel.

 

All Things Data: Distinct Threats to Your BI Implementation

Jon Oesch, VP, Business Intelligence Sales

The latest installment of “All Things Data” starts a new series about the nine threats to your BI implementation. In today’s video, we’ll cover the first two threats – and they might surprise you:

  • #1: If you build it they will come
  • #2: Your culture of Excel

Watch our latest video to find out how these are threats to your business intelligence implementation.



Stay tuned to the Jet Reports blog to make sure you don’t miss out on the next seven threats!

The Big Secret to Painless Data Migration

Tara Grant, Vice President of Marketing

White Paper: The Big Secret to Painless Data Migration

Companies often face difficult and expensive choices when it comes time to migrating legacy data into a new ERP system. Do you leave your transactional data behind or spend the time and money to plan, post, validate and test?

A new, must-read white paper from the Jet Reports Business Intelligence team explores the latest thinking on how to change your ERP system and still keep your data (and your money, and your sanity).

Download this free white paper now.

 

Excel QuickTips: Undocking a PivotTable

Brandon Boyd, Marketing Programs Manager

Welcome back to the Excel QuickTips series. Today, we are talking about undocking a PivotTable. In this video you’ll learn how to reposition, undock and create more space for your PivotTables. Undocking a PivotTable can be a useful tool to give you space to view a full list of PivotTable Fields without scrolling.

 
Watch this video to learn how.

 

 

Stay tuned for more QuickTips from Jet Reports on our blog our subscribe to our YouTube Channel.

Using the Best Tools for Your BI

Tara Grant, Vice President of Marketing

What Everybody Ought to Know About the Microsoft BI Stack

In this guide, we review the BI and reporting tools provided by Microsoft to help you gather the facts. We’ll also share the right questions to ask BI solution providers for a successful evaluation.

  • Why is it so hard to get data out of Dynamics ERP?
  • Why is the out-of-the-box BI system so difficult to use?
  • How to avoid dependence on costly BI experts
  • Questions to ask about any BI solution

Business Intelligence is a dynamic process. Companies and environments change constantly. If a solution is not able to be quickly installed, customizations take too long to configure and user requests too long to incorporate – your investment is at risk. Read this white paper now to prepare for success.

Download this free guide now to help you choose the right BI tools

 

Excel QuickTips: Pinning

Tara Grant, Vice President of Marketing

Welcome back to Excel QuickTips from Jet Reports. For the second installment in our video series, we’ll be talking about Pinning. Pinning is a useful tool in Microsoft Excel that allows you keep track of files you use frequently for easy access. If you’re a Jet Reports user, you can use Pinning as a way to keep track of your reports. This is a bonus tip – it also works with Microsoft Word and Microsoft PowerPoint files as well.

Check out this two-minute video to learn how.

Stay tuned for more tips from Jet Reports!

Data Discovery and the New New Thing

Brandon Boyd, Marketing Programs Manager

White Paper: Data Discovery and the New New Thing

Data Discovery vs. Business Intelligence

Both Data Discovery and BI tools enable business users to make better decisions by using data. BI reinforces agreed-on KPIs and metrics to help your organization move in the right direction, while Data Discovery tools widen access to data.

Interested in learning the pros and cons of both? Read about the difference between BI and Data Discovery tools for a deeper understanding on the latest technology trends.

Download the Free White Paper Today.


Excel QuickTips: PivotTables

Brandon Boyd, Marketing Programs Manager

Welcome to Jet Reports new video series, Excel QuickTips! In this series, we’ll share short tips about Excel. Today’s tip is all about PivotTables. We’ll discuss what PivotTables are, how to create them and what they are good for. We’ll walk you through it in this short, four-minute tutorial.
 

 
Stay tuned for more QuickTips from Jet Reports!

Implementing Business Intelligence

Tara Grant, Vice President of Marketing

White Paper: Implementing Business Intelligence

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 Business Intelligence effort.

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?

In this free white paper, we’ll cover these four steps to implementing Business Intelligence:

  • Identifying and Establishing the Vision
  • Appointing Your House of Representatives
  • Building the Process
  • Policing the State

Download the full white paper now.

Build BI Faster, Cheaper and Better

Tara Grant, Vice President of Marketing

A New White Paper From Jet Reports

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

  • 17 months is the average implementation time for a BI project
  • 5 months needed to deploy the first usable BI artifact
  • $1.1m is the mean, annual cost for 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 an organization that builds and deploys BI environments for hundreds of companies each year, we work with IT groups and business users who come to us facing them all the time. This has been a longstanding problem with BI implementations and that is why Data Warehouse Automation (DWA) is such an exciting concept.

The idea behind DWA is that if you can automate these time-consuming tasks, then the project team can focus on the components that require more intellectual input than raw technological horsepower. In this white paper, we’ll explore Data Warehouse Automation so you can learn about the common pitfalls and how to embrace and profit from this emerging trend.

Download the white paper now to read more.

 

 

All Things Data: KPI’s – You might be doing it wrong…

Jon Oesch, VP, Business Intelligence Sales

One of the benefits of a BI system is that you can monitor your Key Performance Indicators. But are you doing it right? In our sixth installment of the “All Things Data” series, Jon Oesch talks about what a real KPI is (including his favorite definition) and how to use them. Watch this video to learn more.

New Power BI Sessions Included in Business Intelligence Education Webinar Series

Tara Grant, Vice President of Marketing

The most popular webinar series in Jet Reports’ history has been expanded to include three additional webinars focusing on Power BI. The new sessions will cover an overview of Power BI, using Excel with Power BI and using the Power BI Designer app.

Join our BI experts for 30 minute, informative, online sessions to learn about latest topics in Business Intelligence. Check out the complete list of topics and register for your spot now on the BI Education Series page, where you can also view any of the previous webinars on-demand.

Join us for BI School with these upcoming webinars:

Power BI Part I: The Basics

Are you ready to get the most value out of Microsoft’s Power BI? In this webinar, you will see an overview of the Power BI components and learn how to use them to create a self-service BI solution.

Debunking 3 Common Myths about BI and Cubes

While undisputedly useful, over the years cubes have gained a reputation for being expensive, resource-intensive tools only fit for large companies with infinite IT resources. This session with cover the top 3 myths about cubes and how the latest technology in BI can help you gain all the benefits cubes have to offer, without any of the common pitfalls.

Power BI Part II: Using Excel

While organizations look for more visibility on operations, they are also seeking ways to bring additional value and usability with the tools they already have. This webinar provides you with a unique opportunity to see how a real business story unfolds through the use of Excel and its power add-ins.

Data Warehouse Automation

As organizations continue to look for ways to shorten and improve the process of getting the data they need through Business Intelligence, the subject of Data Warehouse Automation (DWA) surfaces more and more often. This session will review exactly what Data Warehouse Automation is, how it looks, and the role it plays in speeding up all BI processes, without increasing costs.

Power BI Part III: Using the Designer

Looking for a deeper understanding on how to design dashboards and unlock the mystery of Microsoft’s Power BI? This webinar will show you how the new Power BI Designer app can tell a business story utilizing its BI functions.

Build vs. Buy: BI Implementation

Review the key differences between using the tools that come with SQL Server to build an in-house BI solution versus using an ETL and Data Warehousing automation tool to deliver successful BI projects.

 

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.

Author:

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.

jono@jetreports.com

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, Marketing Programs Manager

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, Marketing Programs Manager

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 2015 Certifications Accepting New Members Now

Sarah Kloser, Services Manager

Prove your knowledge

If getting to the next level in your career is part of your plans, here’s something that has helped others become the go-to reporting expert in their companies and beyond.

The Jet Reports Certification program is a skills-based program designed by our in-house experts to help you learn and validate your expertise across the spectrum of reporting and Business Intelligence.

A series of tests help you track your knowledge in every aspect of the Jet Reports portfolio of solutions with the backing of a company that is well-respected in the Microsoft Dynamics community.

To make this as easy as possible for you certification is free. (more…)

Taking Business Analytics beyond the Golf Course: What it Really Means to “Go Mobile”

Tara Grant, Vice President of Marketing

It shouldn’t come as any shock that the era of running businesses or departments by being chained to a desk is quickly fading. But what you might not see is how the concept of “remote” is expanding beyond the capability of working from a different location than the headquarter office. What you will see is the evolution of “Going Mobile”. (more…)

The ‘Amazon Effect’: Why Companies who Need Marketing also Need BI

Tara Grant, Vice President of Marketing

According to Gartner, by the year 2017 CMOs will outspend CIOs in IT investments. That is a staggering prediction about the evolution of business: you can’t survive today without knowing your customers. Intimately. (more…)

Jet Enterprise 2014 Service Release 1 (SR1)

Brian Petersen, Director of Business Intelligence Solutions

As both the largest and fastest growing Business Intelligence (BI) and Reporting provider in the Microsoft Dynamics ecosystem, Jet Reports is proud to announce the global release of Jet Enterprise 2014 Service Release 1 (SR1). A number of valuable new features and substantial performance improvements have been added to our flagship BI platform. (more…)

Meet us in St. Louis!

Brandon Boyd, Marketing Programs Manager

Join Jet Reports and thousands of Microsoft Dynamics® users at Summit 2014, October 14-17, in St. Louis, MO. Jet Reports is excited to partner with Summit to offer learning opportunities on a variety of topics from Excel to Business Intelligence. Check out our full session schedule to find out where to catch us. After sessions, come meet the Jet team at our booth #1017 and get a live demo of Jet Mobile, an interactive enterprise Business Intelligence application for mobile devices, and Jet Express for Word, a free document reporting solution for Microsoft Dynamics® NAV. (more…)

Jet Reports Releases Jet Essentials 2015

Brandon Boyd, Marketing Programs Manager

Jet Essentials 2015 introduces compatibility for Microsoft Dynamics NAV 2015, OAuth authentication and reporting performance improvements.

Jet Essentials 2015 is fully compatible with Microsoft Dynamics NAV 2015. This version introduces OAuth authentication for NAV 2015 data sources. OAuth is an authorization method commonly used to log into third-party websites using Office 365, Facebook or Twitter accounts, allowing users to not worry about their access credentials being compromised. (more…)

Jet Reports Releases Jet Mobile for Jet Enterprise

Brandon Boyd, Marketing Programs Manager

Jet Mobile gives Jet Enterprise users the freedom to access Business Intelligence on mobile devices

Portland OR – October 8, 2014 – Jet Reports is pleased to announce the release of Jet Mobile, an interactive enterprise Business Intelligence application for mobile devices. Designed to meet the demands of the modern mobile workforce, Jet Mobile gives you the power to access your Jet Enterprise Business Intelligence data where you need it, when you need it. With a touch of your fingertips, your company’s key performance data can be accessed at home, in a lunch meeting, or on the golf course. (more…)

From Reporting to Analytics: 5 Eye-Opening Examples of How Business Intelligence Fuels Profitable Change

Tara Grant, Vice President of Marketing

There comes a time for every growing business when reporting alone can’t provide the deeper insight needed to make decisions that build a better future.

The journey from reporting to Business Intelligence (BI) is an evolution. As your business grows, reports raise questions about underlying causes that are no longer simple to track down. BI empowers users to find correlations, patterns and outliers. As your organization matures, BI provides new perspectives that can fine tune operations and uncover new opportunities – to fuel profitable change. (more…)

Announcing: The Free Document Reporting Solution for Microsoft Dynamics NAV

Brandon Boyd, Marketing Programs Manager

Portland OR – October 1, 2014 – Jet Reports is pleased to announce the release of Jet Express for Word, a free document reporting solution available in partnership with Microsoft.

Jet Express for Word is a new feature available to Microsoft Dynamics users which makes it easy for end users to design documents in Microsoft Word. This feature is part of Jet Express for Microsoft Dynamics NAV and is available to Microsoft Dynamics NAV 2015 users.

Modify Reports in Microsoft Word
Make changes to an invoice or credit memo in Microsoft Word — no programming required. You can use document templates that we provide, templates from the Office Store, or create a document from scratch. Add company logos, change fonts, modify fields and customize for multiple regions easily. (more…)

Business Intelligence Education Series

Paul Hollcraft, Global Partner Manager

Join Jet Reports’ own Business Intelligence expert, Lars Rasmussen, and fellow Microsoft Dynamics users for these short, informative webinars on the latest topics in Business Intelligence.

Webinars:

Consolidating Data Systems
September 30, 2:00 PM – 2:30 PM BST
Learn how bringing disparate information into a single place with a Business Intelligence solution can lower data analysis costs, decrease upgrade expenses and lead to happier users.

Register Now

Link between ERP and BI
October 28, 2:00 PM – 2:30 PM BST
Why is it hard to get data out of your ERP system? And what can you do about it? Deep dive into why business systems are designed to provide optimum value with a Business Intelligence solution built to leverage their data in order to make it easily accessible and consumable for users.

Register Now (more…)

Five Steps for a Stronger Password

Brandon Boyd, Marketing Programs Manager

Let’s face it – with so many software products and apps, it’s hard to keep passwords straight, not to mention secure. And the information changes. Passwords that worked yesterday don’t always work  well with today’s security risks. Password crackers and methods are more sophisticated than ever before. To help you stay current, here are a few tips, outlined by Hubspot that can help you write a stronger password that may be a little easier to remember as well.

1. Different account? Different password

A research study of over 300 college students found that nearly 75% reused at least one password. What’s the big deal? When you reuse a password, and a hacker accesses one of your accounts, the others fall like dominos. Many websites ask you to login with your email address, giving you the same username across multiple accounts, which amplifies the problem. (more…)

Why Do We Need Business Intelligence?

Brian Petersen, Director of Business Intelligence Solutions

What if you found yourself needing to present a solid case in front of your boss for why you want to purchase a Business Intelligence solution? What would you say? Anything that involves asking your boss to spend money might cause you to begin to sweat.

You may never have to face this situation but, frankly, this scenario is making me nervous. So to help us both feel better, I’ve laid out a few points to help you understand a few advantages of BI.

A streamlined structure for reporting and analytics

Having a Business Intelligence solution with a data warehouse and cubes generally presents a very streamlined way for our users to get access to data. It’s widely known that ERP systems are designed and optimized for inputting information, but they are not built with the end-user in mind for getting information back out in an intuitive or user-friendly manner. A Business Intelligence solution helps ease the process of getting the data out, making it very, very easy to create stunning reports and dashboards. And most importantly, we can structure the data in a way that makes sense for the end users.

(more…)

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