In this session, Steven will introduce you in the world of Power BI for Dynamics NAV.
You will see what it takes to develop a dashboard in Power BI Desktop. Starting from getting the data out of Dynamics NAV, we will create a data model.
On one hand we will see how to achieve this using Power Query, which we will enhance with measures, calculated columns and tables using DAX. On the other hand we will use OLAP Cubes, connected to Dynamics NAV and other sources, to build the data model.
Based upon this data model we will then create reports that visualize the information, which we will use to create a dashboard. Next we will demonstrate how you can share, consume and refresh the datasets, reports and dashboard.
We will look at the Power BI tool stack from a technical point of view. What are these strange languages meant for: DAX, M and R? How can you connect to Dynamics NAV? What knowledge do I need and how do I get started?
When do I use OLAP Cubes to build a Data Warehouse for Power BI and how does that compare to using ODATA Web Services?