Microsoft Power BI for Dynamics GP

Microsoft Power BI for Dynamics GP

Quick insights and analytics allow for better decisions

Power BI is Microsoft's flagship analytics platform for KPIs and dashboard reporting.  The GP Support North team as Endeavour can work with you to create a "Data Culture" where end-users are encouraged to make better decisions based on quick insights and analysis based on real-time data.   Guiding principles for Power BI include:

Self-serve analytics for everyone
Unified platform for enterprise Business Intelligence
Big data analytics with Azure Data Services (including IoT and Dynamics 365)
Pervasive artificial intelligence for BI

Endeavour deploys Power BI as a means to extend Dynamics GP (Great Plains) with online cloud-based analytics available anytime-anywhere.   Power BI is also a great tool for consolidation and assembling multiple datapoints into a single dashboard or graph.

Power BI can connect to over 200 different data-sources and serves as a streamlined means of aggregating data and information across multiple systems including Dynamics GP and SQL Server.

Based on your needs, Endeavour can deploy Power BI as a robust Cloud application integrated via the Power BI Gateway to your on-premise SQL Server databases, Dynamics CRM on-premise, or Microsoft Dynamics GP ERP.

The posted 2022 price for Power BI Pro in Canada is $12.80/user per month via Endeavour.

Power BI Premium is a viable option for larger Enterprise organizations with 500 BI users or more, and or those who strive to integrate massive datasets from IoT, Big Data and high volume transactions.

Venture Capital KPI
Getting Started with Power BI

There are dozens of sample datasets, add on visualizations and templates to accelerate your next BI project

Endeavour Solutions is in the top 5% of Microsoft Partners worldwide with Canadian offices in: TorontoHalifax (Bedford), LondonOttawaEdmonton and Montréal with remote support to the USA.

Our success is due to our focus on our customers, our people and our core values of
integrity, trust, and accountability

Contact us for Free Sample Data-sets for Microsoft Power BI (viewed online or downloaded *.PBIX file)

  • Sales and Marketing 
  • Opportunity Tracking
  • Customer Profitability
  • Retail
  • Supplier Quality
  • Human Resources 
  • IT Spend Analysis
  • Procurement Analysis
  • Financial Analysis
Getting Started with Power BI

Free PDF Download: OKR Cheat Sheet for top KPI and ORKs

2023 Update for Power BI

Start your own PoC with Power BI for Dynamics GP - How to connect to your data

Power BI video by Endeavour Solutions - Power BI Consulting for Great Plains

Contact Endeavour today.

Steve Ewing VP Endeavour

Steve Ewing

Vice President - ERP, CRM & Cloud

Contact Steve and his team to talk about your Business Needs.

"Let's find a fit between your needs and our Professional Services for Microsoft Dynamics GP, CRM & Cloud solutions."

1 (888) 257-3577 x 213


Need a new Microsoft Partner?

Maybe it's time to hit reset.
Let's get started

Pro-Tips & Tricks on using Visualizations in your Dashboards and Presentations.

The Prophix team has shared the following tips & tricks for effective presentations.

Data visualization tips

The best charts are the ones that share key metrics and business trends in the simplest way. The goal is to share pertinent information but not overwhelm meeting participants with unnecessary nuances. If it’s going to trigger more questions than insights, leave it out of your presentation.

Design for data visualization

When it comes to data visualization, keep it clean. Opt for simple charts that allow the numbers to be the stars. Choose colors with sufficient contrast to provide visual pop and to emphasize key points. It is also key to steer clear of visual distractions such as shading, borders, gridlines, and 3-D perspective. But don’t let your quest for sterility impede clarity: be sure to include descriptive titles, simple legends, and trendlines to aid in understanding.

Types of data best suited to which type of visualization

While it may be tempting to experiment with chart types, it’s usually better to stick with the basics. In most cases, simple line and bar graphs will suffice. They are not only effective for plotting key data but are easily understood by most professionals. Here are the most common chart types and best use cases:

  • Bar graphs are the go-to for single data series, such as customer orders by day.
  • Line graphs are optimal for for multiple series of closely related data. For example, one application may be to show monthly spend by division.
  • A combo chart that overlays a line graph on a bar chart is an effective way to combine two very different data sets—such as dollars and percentages—into a single chart.
  • Area graphs can be compelling when showing cumulative data for several data series. A typical application may be to show product line revenue against the overall revenue.

Learn more about GP Support North and Corporate Reporting