Top 5 Myths about Jet Reports and Power BI

insightsoftware -
June 16, 2016

insightsoftware is a global provider of reporting, analytics, and performance management solutions, empowering organizations to unlock business data and transform the way finance and data teams operate.

Top Five Myths

There is a lot of noise out there about how Power BI impacts reporting and analytics for Microsoft Dynamics. Some of the information is helpful, some of it is confusing and other parts are just plain wrong. We’re here to help you make sense of it all!

Myth #1 – With Power BI you don’t need Jet Enterprise: Power BI is a fantastic data visualization tool, but many business users get stuck from the start by having to build their own data models or waiting for an IT team (that doesn’t have the time) do it for them. Having a highly structured data warehouse and cubes already built for Dynamics simplifies everything to maximize value allow users to create their own dashboards with Power BI from Day 1.

Myth #2 – A content pack from Microsoft is the same as Jet Enterprise: The content packs that come with Power BI are a way to get started, but what happens when you need more than the basics or need to include data from systems outside of what the content pack was built for?

Myth #3 – Power BI can do financial statements: While Power BI is a fantastic tool for dashboards, paginated reports are another story. Financial statements, receivable reports and anything showing more than basic detail requires a completely different set of skills.

Myth #4 – Having business users bring all of their various data sources into Power BI is fast and easy: Clarification. Adding a data source is simple; having your data sources link together is actually quite difficult. Things like item numbers, customer numbers and GL account don’t always align perfectly across systems which can cause huge headaches for those not intimately familiar with data modeling.

Myth #5 – Creating custom calculations are quick and simple with Power BI: In order to use any sort of date calculations, such as MTD or YTD, there needs to be a date calendar built into Power BI and this isn’t standard. Otherwise, a custom table or DAX is needed to build this, and that isn’t for the faint of heart. Jet Enterprise comes standard with these and customizing or building more is 5x faster than the alternative.

Ready to learn more about using Jet Enterprise with Microsoft’s Power BI? Register today for our upcoming BI Education Series Webinar “How to Begin Using Power BI in 5 Minutes with Jet Enterprise” on July 12th.