DATA WAREHOUSE AUTOMATION




CUSTOMIZATION AND DEVELOPMENT WIZARD
1
/
3


Create a cube

Wizard AX - Build New Cubes - GL

Wizard AX - Manage Metadata

Wizard AX - Edit Cubes and Data Warehouse - Retail

Create cube based MDX measure

Wizard AX - Manage Dimensions
1
/
3

1
/
2


Create a new cube - NAV Wizard

Manage Metadata - NAV Wizard

Manage existing dimension - NAV Wizard

Add custom DW based measure - NAV Wizard

Add MDX and Distinct count measures - NAV Wizard

Preview field values before using them in solution
1
/
2

CONTENT – APPLICATION AREAS
POWER BI
1
/
2


Inventory Analysis - BI for Microsoft Dynamics

Sales Analysis - BI for Microsoft Dynamics

Receivables Analysis - BI for Microsoft Dynamics

Retail - Business area

All-in-one Analytics for Retailers on Microsoft Dynamics ERP

Delivery performance in BI4Dynamics
1
/
2

1
/
3


New Power BI Portal from BI4Dynamics

Advantages and handicaps when getting data from different sources

How to change connection of Power BI reports to BI4Dynamics

How to implement Power BI in your organization?

How to implement Power BI to Microsoft Dynamics ERP?

How to prepare Microsoft Dynamics data for Power BI?
1
/
3

SET-UP AND CONFIGURATION
FORECASTING WITH R
1
/
2


BI4Dynamics - Wizard driven Installation Tutorial

Edit Process flow - Part 1

Add SSIS Package to Process Flow - Part 2

Partition based processing

Change display language in Excel reports

Setting up roles and permissions in Microsoft SQL Server Managment Studio
1
/
2



Introduction to R

Getting started with Forecasting in R

Example - R Correlation - Car

Example - R Forecast - King

Comparison R project - Power BI - Cortana

Forecast on Microsoft Dynamics AX / NAV with R and Power BI
