How to Choose the Right Azure Virtual Machine for Data Warehousing

How to Choose the Right Azure Virtual Machine for Data Warehousing With over 600 virtual machines available on Microsoft Azure, selecting the right one can be challenging. In this guide, we will explore the parameters of VM needed for data transformation and the number of cores needed to increase throughput and processing speed. When it…

Read article

How to choose the right business intelligence tool

What we need to consider when deciding on the type of analytics project to start within a business is to look at the factors that affect the scope of the project. These could be as simple as the available budget or resources that we have to devote to the project, though other factors that may…

Read article

Ensuring Data Quality in Business Intelligence with BI4Dynamics

A Comprehensive Guide to Data Validation and Model Health Checks Introduction to Data Quality Greetings, Business Intelligence enthusiasts! Welcome to another episode of “BI in 60 Seconds.” Today, we will delve into the critical topic of data quality, specifically when using BI4Dynamics. We will discuss the importance of data validation and model health checks to…

Read article

Data Warehouse – Advantages and Threats

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…

Read article

The Significance of Metadata in BI Projects

This blog post will explore the importance of metadata in designing a Business Intelligence (BI) project, and how BI4Dynamics leverages it to automate data warehousing Firstly, let’s define metadata. It refers to the additional information and descriptions of data. For instance, when taking a picture using an iPhone, the metadata information includes the geolocation and…

Read article

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.…

Read article

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…

Read article

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 Export Business Central (BC) data to Azure Data Lake Load data to the Data…

Read article