Dynamics NAV with Power BI


Dynamics NAV with Power BI

I spoke recently of using NAV with Power BI, currently this topic (NAV integration with Power BI) is current and widely discussed, many questions about “How-to” integrate new and old releases on NAV with Power BI. I have collected a series of posts videos on Power BI and about integration with NAV (the most interesting that I fond).

MICROSOFT POWER BI

Best Definition by Microsoft: “Microsoft Power BI is a Microsoft’s Business Analytics service for Visualizing, exploring and deriving insights from data!”

Power BI Portal

https://powerbi.microsoft.com

Power BI Features

https://powerbi.microsoft.com/it-it/features/

“HOW-TO “GET STARTED

Get Started

https://powerbi.microsoft.com/it-it/documentation/powerbi-service-get-started/

https://powerbi.microsoft.com/it-it/get-started/

Power BI Free ebook

https://robertostefanettinavblog.com/2016/06/18/introducing-microsoft-power-bi-free-ebook-from-sqlbi/

Power BI Developer

https://powerbi.microsoft.com/it-it/documentation/powerbi-developer-overview-of-power-bi-rest-api/

https://powerbi.microsoft.com/it-it/get-started/

Nice series of pages about power BI on EID Site (NAVlab Partner)

http://www.eid.it/microsoft-powerbi/

ABOUT DYNAMICS NAV CONTENT PACK & CONNECTOR

Power BI Integration

https://robertostefanettinavblog.com/2016/03/15/power-bi-integration-microsoft-dynamics-nav-microsoft-power-bi/

https://powerbi.microsoft.com/en-us/integrations/microsoft-dynamics-nav/

Microsoft Dynamics NAV with PowerBI.com

https://suvidhablogpost.wordpress.com/2015/10/13/microsoft-dynamics-nav-with-powerbi-com/

Dynamics NAV Content Pack

https://powerbi.microsoft.com/it-it/documentation/powerbi-content-pack-microsoft-dynamics-nav/

https://robertostefanettinavblog.com/2016/02/04/connecting-dynamics-nav-20132015-to-the-nav-content-pack-in-powerbi-com/

Microsoft Dynamics NAV and Power BI (with O365) – Schedule Report Refresh

https://suvidhablogpost.wordpress.com/2014/12/09/microsoft-dynamics-nav-and-power-bi-better-together/

BEST CONNECTORS FOR DYNAMICS USERS

BEST VIDEOS

Power BI Desktop for Beginners: Create your first Power BI report and dashboard in 10 minutes

https://www.youtube.com/watch?v=h6AIAxMEDiw

Webinar Basics of Power BI for NAV users

https://www.youtube.com/watch?v=v9VIfrXwAfo

Power BI and Microsoft Dynamics NAV by Steven Renders

https://www.youtube.com/watch?v=u_nWPvBkU9w

Power BI and Microsoft Dynamics NAV 2016

https://www.youtube.com/watch?v=Qbx0FdlZDBk

Enjoy!

Advertisements

Datazen with Dynamics NAV and BI Integrations


About Datazen
“Microsoft Acquires Datazen, Microsoft accelerates its strategy to help every company create a data culture and ensure insights reach every individual in every organization.”
Datazen solution is now available with the latest version of SQL Server 2014 Enterprise (free to use, embedded on SQL Server)

datazen 4

Datazen Topics
KPI Repository
For quick, timely insights
– Showing the latest values and trends
– Related dashboards provide detailed analysis

BI Dashboards
Data visualization and analysis
– Interactive visualizations
– Detailed analysis and drill-throughs
– Perfect scaling to any screen form-factor

Team Collaboration
Stay on top of BI hub activity
– Participate in KPI & dashboard conversations
– See when new dashboards & KPIs are published
– Collaborate on the go from any device

Single Point of Publishing
– Connect to your data sources via the Datazen Publisher app, create dashboard layouts for master, tablet & phone views, then publish to all devices

“NB: ALL Content is accessible via the mobile clients, IOS, Windows Phone or Android, and web browsers !! ..great !”

Datazen is working with NAV ?  … sure !!
.. you can use NAV “OData” publishing technology to connnect Datazen Server to NAV Server
.. you can also use SQL Native (and ODBC) connectors.

NAV and Datazen Integration

Excellent presentation of NAV and Datazen Integration during yesterday’s event @MicrosoftItaly NAV 2016 What’s New” by SQL MVP Davide Mauri.

Microsoft “to-be Dashboarding & Mobile BI” Integration Scenario

bi e datazen

Applications Integration “Scope”

  • Reporting Services (Paginated Reports) MAIN REPORTS\DASHBOARDS\KPI OBJECTS  REPOSITORY (also on SharePoint if necessary…)
  • Power BI (Interactive Reports and ETL Scheduling)
  • Datazen (Mobile reports.dashboard & KPI)
  • Excel (Power Pivot, Power Query etc. ) Analitycal and charts

Links
Datazen
http://www.datazen.com/

Datazen Publisher (and Viewer) APS
https://www.microsoft.com/it-it/store/apps/datazen-publisher/9wzdncrdkv41

… nice post here
The Future of Power BI Looks Bright!
http://www.erpsoftwareblog.com/2015/06/future-power-bi-looks-bright/

My Video in Youtube