Indexing data warehouse tables Too many or too few indexes hurt performance. Not active indexes may disturb SQL server in generating the optimal execution plan. Managing indexes can become 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, so…
Introduction This post describes the data transformation process from Microsoft Dynamics D365 BC SaaS to visualization tools (Power BI, Excel). It includes also total monthly cost for the project. Data transformation diagram Data transformation is done in the following steps Export BC data to Azure Data Lake Load data to Data Warehouse staging area Process…
Please leave this field empty Oh hi there It’s nice to meet you. If you are using any version of Microsoft Dynamics, sign up to receive awesome content in your inbox, every month. Email Address * We don’t spam! Read our privacy policy for more info. You’ve been successfully subscribed to our newsletter!
Data Warehouse Automation (DWA) is the latest buzz word in analytics. DWA tools are DW solutions where development cycles are fully automated (all the code is generated automatically) thus improving productivity, reducing cost, and improving overall quality. This is exactly what BI4Dynamics delivers. BI4Dynamics makes a data warehouse leaner, more flexible, and less expensive with…
Normally when an SMB hears a phrase like ‘Data Warehouse’ the first thing that comes to mind is prohibitive costs. Also, there are horror stories about the implementation process due to the rigidity of the data modeling, which is measured in months, not days. What makes a data warehouse the preferred choice for enterprises is…
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…
