@peterjones
Active 2 months, 1 week ago-
Peter Jones started the topic PBI0013 – Power BI – Star schema or single table in the forum 4-Power BI 2 months, 1 week ago
This article comes to the conclusion to use star schema always.
https://www.sqlbi.com/articles/power-bi-star-schema-or-single-table/
-
Peter Jones started the topic PBI0012 – Data types in Power BI Desktop in the forum 4-Power BI 3 months, 1 week ago
Data types in Power BI Desktop
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
-
Peter Jones started the topic FA0002 – Get certified in Microsoft Fabric—for free! in the forum 4-Fabric 3 months, 1 week ago
Get certified in Microsoft Fabric—for free!
-
Peter Jones started the topic FA0001 – Welcome to the Fabric Community in the forum 4-Fabric 3 months, 1 week ago
Welcome to the Fabric Community
This is the entry point to the Fabric Community.
https://community.fabric.microsoft.com/ -
Peter Jones started the topic AZ0005 – Get certified in Microsoft Fabric—for free! in the forum 1-Azure 3 months, 1 week ago
Get certified in Microsoft Fabric—for free!
-
Peter Jones started the topic ES0002 – Business Central Flow Fields in the forum 2-Extract And Staging 4 months ago
-
Peter Jones started the topic ES0001 – Extracting data from Business Central Cloud to Data Lake in the forum 2-Extract And Staging 4 months ago
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
-
Peter Jones started the topic AZ0004 – Direct Lake overview in the forum 1-Azure 4 months, 2 weeks ago
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]
-
Peter Jones started the topic PBI0011 – Use locale values in multiple-language Power BI reports in the forum 4-Power BI 6 months, 1 week ago
This is also very interesting.
https://learn.microsoft.com/en-us/power-bi/guidance/multiple-language-locale
-
Peter Jones started the topic PBI0010 – Create multiple-language reports with Translations Builder in the forum 4-Power BI 6 months, 1 week ago
This is a very interesting article.
https://learn.microsoft.com/en-us/power-bi/guidance/translation-builder
-
Peter Jones started the topic DB0009 – Introducing AI/BI: Intelligent Analytics for Real-World Data in the forum 6-Data Bricks 8 months ago
-
Peter Jones started the topic BC001 – How To Use Account Schedules In Business Central in the forum 1-General Discussion 8 months, 4 weeks ago
-
Peter Jones started the topic P0002 – Microsoft Cloud for Retail: retail data solutions in Microsoft Fabric in the forum 1-General Discussion 9 months ago
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
-
Peter Jones started the topic DM0001 – Dimensional Modeling Techniques in the forum 2-Dimensional Modeling 9 months ago
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.
-
Peter Jones started the topic P0044 – CAST and CONVERT (Transact-SQL) in the forum 2-SQL Server 9 months, 3 weeks ago
Always handy to have a short cut to this.
-
Peter Jones started the topic P0043 – Grouping for Totals for direct query into the GL in the forum 2-SQL Server 9 months, 3 weeks ago
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
-
Peter Jones started the topic P0042 – Direct Query Against The BC Underlying Database in the forum 2-SQL Server 9 months, 3 weeks ago
I put this query on the BC Forums.
https://community.dynamics.com/forums/thread/details/?threadid=1f0d5fdf-68fe-ee11-a1fe-7c1e5219011a
Raul found this.
I know scenarios where cross or outer apply are good to use simply for row by row processing or sometimes performance, but I searched and here are the results that might answer the use of outer…[Read more]
-
Peter Jones started the topic XL0023 – Introducing Python in Excel in the forum 3-Excel 9 months, 3 weeks ago
-
Peter Jones started the topic P0041 – WITH common_table_expression (Transact-SQL) CTEs in the forum 2-SQL Server 9 months, 3 weeks ago
-
Peter Jones started the topic P0040 – Using Outer Apply In SQL Server in the forum 2-SQL Server 9 months, 3 weeks ago
Worth a read.
- Load More