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 current spring 2021 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.
Getting Started with Power BI
There are dozens of sample datasets, add on visualizations and templates to accelerate your next BI project
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
- Supplier Quality
- Human Resources
- IT Spend Analysis
- Procurement Analysis
- Financial Analysis
May 2021 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
Additional Product Info
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