Create a BI4Dynamics instance – D365 FO (AX)
This video guides viewers through creating a new BI4Dynamics instance, covering license addition, data source configuration, financial dimensions setup, and the initial deployment of the BI model.
Low-code / No-code BI Customization and Development – BC (NAV)
Watch the tutorial to see how you can install a complete Business Intelligence solution for Microsoft Dynamics in 5 simple steps. Select Data Source and companies, setup up 20 global dimensions and additional currency for the reporting. BI4Dynamics supports all version of Microsoft Dynamics – Cloud or On-Premises. It comes with predefined Power BI and Excel dashboards.
Create Data Warehouse & Tabular Database
Watch the first episode from BI4Dynamics’ “Data Warehouse in 60 seconds” series. In this episode, the solution architect of BI4Dynamics shows the rapidity of creating a data warehouse-based solution including a tabular database in Power BI service.
Create a Transactional Table (Fact)
Dive into the essentials of setting up your first transactional table in a new application area with our detailed B4 Dynamics tutorial. Discover how to customize and manage transactional data within Dynamics 365, focusing on sales invoicing transactions. This step-by-step guide covers everything from selecting your base table to connecting dimensions and generating your analytical model. Whether you’re new to Dynamics 365 or looking to enhance your data modeling skills, this tutorial provides invaluable insights into Dynamics application development, data structure, and the efficient use of SQL Server for data management. Perfect for Dynamics ERP users aiming to leverage business intelligence tools and Excel integration for comprehensive sales analysis.
Add Measure (Data Warehouse Based)
Discover how to enhance your Dynamics 365 analytics by adding custom measures directly in BI4Dynamics. This tutorial guides you through the process of integrating fields like sales quantity, tax amount, and discount values into your model, optimizing financial reporting and sales analysis. Ideal for Dynamics 365 users seeking to refine their BI capabilities. Learn essential data modeling and reporting tips to fully leverage Dynamics for your business intelligence needs.
Add Measure as DAX Expression (Tabular Database)
Boost your Dynamics 365 analysis with our guide on integrating DAX calculations for sharper BI insights. Learn to calculate average selling prices and sales transactions using DAX, with validation in Power BI before adding to your BI4Dynamics for in-depth sales analysis. Ideal for enhancing sales metrics and analytical skills, this tutorial is a must-watch for those keen on mastering Dynamics 365 analytics and Power BI.
Add Attributes to Existing Dimension
Enhance your Dynamics 365 model with additional attributes in the item dimension using BI4Dynamics. This tutorial shows you how to enrich your data model by integrating more detailed item attributes and extending it with additional tables. Learn to navigate BI4Dynamics to add option fields and establish table relationships, all aimed at improving inventory management and analytics. Ideal for users seeking to deepen their Dynamics 365 customization and reporting capabilities.
Create Dimension and Add It to the Model
Discover how to enrich your Dynamics 365 data model with role-playing dimensions for customer data, using BI4Dynamics. This tutorial walks you through creating and connecting dimensions like ‘Bill to Customer’ and ‘Sell to Customer’ to transactional tables, enhancing your data warehouse for comprehensive customer analysis. Ideal for Dynamics 365 users seeking detailed insights into customer transactions and relationships within their ERP system.
Setting Up Global Dimensions
Streamline complex data processes with BI4Dynamics’ advanced integration techniques. Watch the practical application of integrating Financial Dimensions into transactional tables shown on a demo model. See how to deploy dimensions across multiple companies to numerous transactional tables using BI4Dynamics. We’ll also look at how to define and map global dimensions like department, business unit, and cost centre.
Global (Financial) Dimensions – Business Aspect
This video outlines the application of global (financial) dimensions in BI4Dynamics from the business users’ perspective. It outlines the difference between global dimensions (department, cost centre, business unit) and standard dimensions (customer, vendor, item) in terms of availability by application areas and number of attributes that can be used per dimension. An unlimited number of global dimensions from Finance & Operations and up to 20 dimensions from Business Central can be used in BI4Dynamics. This BI4Dynamics feature demonstrates a critical tool for complex data structuring within Dynamics environments.
Write-back (for business users) – Data Warehouse & Power BI Modeling
Maximize Business Efficiency with BI4Dynamics Writeback. Discover how this tool enhances data management within Power BI, offering real-time data updates for improved decision-making. Learn about its direct query support and intuitive interface, designed for ease of use by both technical and non-technical professionals. This video is ideal for anyone looking to streamline data processes in a business intelligence environment, emphasising practical application and efficiency in data handling with BI4Dynamics Writeback.
Write-back (Technical) – Data Warehouse & Power BI Modeling
Enhance Your Data Management with BI4Dynamics Writeback – In-Depth Technical Guide Dive into the technical background of BI4Dynamics Writeback in this detailed guide. Discover how this tool enhances your data warehouse and tabular database interactions, offering flexibility and control. Ideal for users seeking a comprehensive understanding of BI4Dynamics’ powerful functionality and those aiming to optimize their data handling in BI environments.
How to integrate a data warehouse with 150+ external sources?
Just ONE connector for connecting data warehouse to 150+ data sources? Yes, you read that right. At BI4Dynamics we are revolutionizing integration of external data with a unique approach using Power BI Datamart. Discover how we’re simplifying the complex world of data integration in our video. We walk you through the process of loading and transforming external data using Power BI Datamart and adding them to existing Data Warehouse model.
How to create documentation of BI Project in 60 seconds
It takes only 60 seconds ⌚ to create documentation in PDF format 📑 and includes all the changes that were included in the BI model up to that very moment.
What is Metadata? The hidden secret of No-code development
Unlock the hidden secret of No-code development with Metadata information. In this episode of BI in 60 seconds, you will discover the power of Metadata in our Data Warehouse Automation Solution using BI4Dynamics. See how our application connects to Microsoft Dynamics and provides information about the model, including the number of tables, columns, primary keys, and table relations. Don’t miss out on the key information that can help you design a solution faster.
- Installation
-
Create a BI4Dynamics instance – D365 FO (AX)
This video guides viewers through creating a new BI4Dynamics instance, covering license addition, data source configuration, financial dimensions setup, and the initial deployment of the BI model.
Low-code / No-code BI Customization and Development – BC (NAV)
Watch the tutorial to see how you can install a complete Business Intelligence solution for Microsoft Dynamics in 5 simple steps. Select Data Source and companies, setup up 20 global dimensions and additional currency for the reporting. BI4Dynamics supports all version of Microsoft Dynamics – Cloud or On-Premises. It comes with predefined Power BI and Excel dashboards.
Create Data Warehouse & Tabular Database
Watch the first episode from BI4Dynamics’ “Data Warehouse in 60 seconds” series. In this episode, the solution architect of BI4Dynamics shows the rapidity of creating a data warehouse-based solution including a tabular database in Power BI service.
- Customizations
-
Create a Transactional Table (Fact)
Dive into the essentials of setting up your first transactional table in a new application area with our detailed B4 Dynamics tutorial. Discover how to customize and manage transactional data within Dynamics 365, focusing on sales invoicing transactions. This step-by-step guide covers everything from selecting your base table to connecting dimensions and generating your analytical model. Whether you’re new to Dynamics 365 or looking to enhance your data modeling skills, this tutorial provides invaluable insights into Dynamics application development, data structure, and the efficient use of SQL Server for data management. Perfect for Dynamics ERP users aiming to leverage business intelligence tools and Excel integration for comprehensive sales analysis.
Add Measure (Data Warehouse Based)
Discover how to enhance your Dynamics 365 analytics by adding custom measures directly in BI4Dynamics. This tutorial guides you through the process of integrating fields like sales quantity, tax amount, and discount values into your model, optimizing financial reporting and sales analysis. Ideal for Dynamics 365 users seeking to refine their BI capabilities. Learn essential data modeling and reporting tips to fully leverage Dynamics for your business intelligence needs.
Add Measure as DAX Expression (Tabular Database)
Boost your Dynamics 365 analysis with our guide on integrating DAX calculations for sharper BI insights. Learn to calculate average selling prices and sales transactions using DAX, with validation in Power BI before adding to your BI4Dynamics for in-depth sales analysis. Ideal for enhancing sales metrics and analytical skills, this tutorial is a must-watch for those keen on mastering Dynamics 365 analytics and Power BI.
Add Attributes to Existing Dimension
Enhance your Dynamics 365 model with additional attributes in the item dimension using BI4Dynamics. This tutorial shows you how to enrich your data model by integrating more detailed item attributes and extending it with additional tables. Learn to navigate BI4Dynamics to add option fields and establish table relationships, all aimed at improving inventory management and analytics. Ideal for users seeking to deepen their Dynamics 365 customization and reporting capabilities.
Create Dimension and Add It to the Model
Discover how to enrich your Dynamics 365 data model with role-playing dimensions for customer data, using BI4Dynamics. This tutorial walks you through creating and connecting dimensions like ‘Bill to Customer’ and ‘Sell to Customer’ to transactional tables, enhancing your data warehouse for comprehensive customer analysis. Ideal for Dynamics 365 users seeking detailed insights into customer transactions and relationships within their ERP system.
- Special Features
-
Setting Up Global Dimensions
Streamline complex data processes with BI4Dynamics’ advanced integration techniques. Watch the practical application of integrating Financial Dimensions into transactional tables shown on a demo model. See how to deploy dimensions across multiple companies to numerous transactional tables using BI4Dynamics. We’ll also look at how to define and map global dimensions like department, business unit, and cost centre.
Global (Financial) Dimensions – Business Aspect
This video outlines the application of global (financial) dimensions in BI4Dynamics from the business users’ perspective. It outlines the difference between global dimensions (department, cost centre, business unit) and standard dimensions (customer, vendor, item) in terms of availability by application areas and number of attributes that can be used per dimension. An unlimited number of global dimensions from Finance & Operations and up to 20 dimensions from Business Central can be used in BI4Dynamics. This BI4Dynamics feature demonstrates a critical tool for complex data structuring within Dynamics environments.
Write-back (for business users) – Data Warehouse & Power BI Modeling
Maximize Business Efficiency with BI4Dynamics Writeback. Discover how this tool enhances data management within Power BI, offering real-time data updates for improved decision-making. Learn about its direct query support and intuitive interface, designed for ease of use by both technical and non-technical professionals. This video is ideal for anyone looking to streamline data processes in a business intelligence environment, emphasising practical application and efficiency in data handling with BI4Dynamics Writeback.
Write-back (Technical) – Data Warehouse & Power BI Modeling
Enhance Your Data Management with BI4Dynamics Writeback – In-Depth Technical Guide Dive into the technical background of BI4Dynamics Writeback in this detailed guide. Discover how this tool enhances your data warehouse and tabular database interactions, offering flexibility and control. Ideal for users seeking a comprehensive understanding of BI4Dynamics’ powerful functionality and those aiming to optimize their data handling in BI environments.
How to integrate a data warehouse with 150+ external sources?
Just ONE connector for connecting data warehouse to 150+ data sources? Yes, you read that right. At BI4Dynamics we are revolutionizing integration of external data with a unique approach using Power BI Datamart. Discover how we’re simplifying the complex world of data integration in our video. We walk you through the process of loading and transforming external data using Power BI Datamart and adding them to existing Data Warehouse model.
How to create documentation of BI Project in 60 seconds
It takes only 60 seconds ⌚ to create documentation in PDF format 📑 and includes all the changes that were included in the BI model up to that very moment.
What is Metadata? The hidden secret of No-code development
Unlock the hidden secret of No-code development with Metadata information. In this episode of BI in 60 seconds, you will discover the power of Metadata in our Data Warehouse Automation Solution using BI4Dynamics. See how our application connects to Microsoft Dynamics and provides information about the model, including the number of tables, columns, primary keys, and table relations. Don’t miss out on the key information that can help you design a solution faster.