Indexing
Indexing Data Warehouse Tables Too many or too few indexes can hurt performance. Non-active indexes may disturb SQL server in generating the optimal execution plan. Managing indexes can become an art that only experienced professionals can make right. Not accidentally, models in BI4Dynamics data warehouse are know to the same engine that generates the indexes. […]
The Significance Of Metadata In BI Projects
In the realm of Business Intelligence (BI) projects, metadata plays a pivotal role. It provides essential information that enhances the speed, accuracy, and efficiency of data warehousing processes. In a BI project, particularly when integrating large-scale systems like Microsoft Dynamics, metadata isn’t just a helpful asset—it’s the foundation that allows for streamlined automation and accurate […]
Microsoft Power BI Advantages And Threats
Microsoft Power BI has lent itself well to the SMB space because it supports a variety of data sources, it is relatively easy to create data models and it enables simple deployment with immediate results. Its usage, at least at the beginning of a project does not require specialist BI knowledge. If your main data source […]
Business Central (BC) Cloud BI4Dynamics Data Transformation
Introduction This post describes the data transformation process from Microsoft Dynamics D365 BC SaaS to visualization tools (Power BI, Excel). It includes also the total monthly cost for the project. Data transformation diagram Data transformation is done in the following steps Data transformation process BC database BI4Dynamics reads data from a BC replica; […]
