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