Peter Jones

I found this training. It seems worth while going through.

https://learn.microsoft.com/en-us/sql/integration-services/integration-services-tutorials?view=sql-server-ver17

I found his video worth watching as well.

https://www.youtube.com/watch?v=qmSsZhaFcZw

I found a good playlist of how to get started with SSIS. This is worth watching if you want to learn SSIS.

https://www.youtube.com/watch?v=t21pgetDdFM&list=PLGRC5URwOfb_2ah6cqh9A81-BCnZ_rbx-

I asked this question on the BC forums. And got the following answers.

https://community.dynamics.com/forums/thread/details/?threadid=417d7614-810a-f011-bae3-7c1e520dbb77

There is very good documentation on this link to show the enumeration of type fields in Business…[Read more]

This article comes to the conclusion to use star schema always.

https://www.sqlbi.com/articles/power-bi-star-schema-or-single-table/

Data types in Power BI Desktop

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

Get certified in Microsoft Fabric—for free!

https://community.fabric.microsoft.com/t5/Community-Blog/Get-certified-in-Microsoft-Fabric-for-free/ba-p/4254931

Welcome to the Fabric Community
This is the entry point to the Fabric Community.
https://community.fabric.microsoft.com/

Get certified in Microsoft Fabric—for free!

https://community.fabric.microsoft.com/t5/Community-Blog/Get-certified-in-Microsoft-Fabric-for-free/ba-p/4254931

FlowFields overview

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-flowfields

Bertverbeek4PS / bc2adls

This project is the git project to extract data from BC to the cloud

https://github.com/Bertverbeek4PS/bc2adls?tab=readme-ov-file

Direct Lake is a storage mode option for tables in a Power BI semantic model that’s stored in a Microsoft Fabric workspace. It’s optimized for large volumes of data that can be quickly loaded into memory from Delta tables, which store their data in Parquet files in OneLake—the single store for all analytics data. Once loaded into memory, the s…[Read more]

This is also very interesting.

https://learn.microsoft.com/en-us/power-bi/guidance/multiple-language-locale

This is a very interesting article.

https://learn.microsoft.com/en-us/power-bi/guidance/translation-builder

Worth a read.

https://www.databricks.com/blog/introducing-aibi-intelligent-analytics-real-world-data

These two links are well worth reading.

https://businesscentralgeek.com/how-to-use-account-schedules-in-business-central

https://learn.microsoft.com/en-us/dynamics365/business-central/bi-how-work-account-schedule

This video is worth watching.

https://www.youtube.com/watch?v=gU0k29UcRXA

It goes through to this page.

https://www.microsoft.com/en-us/industry/retail/microsoft-cloud-for-retail

I found this post on Ralphs site that summarises all the types of modeling techniques.

It’s quite a nice summary.

Of course, we recommend his book.

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/

Always handy to have a short cut to this.

https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16

This is the post on the BC forums.

In this post I decode the totaling field and then summ the values in the GL accounts to their parents.

Not a bad bit of SQL even if I have to say so myself.

https://community.dynamics.com/forums/thread/details/?threadid=0cb056d2-d5ff-ee11-a1fd-7c1e52184eaf