@sql_troubles

IT guy: 25y+ in BI/Analytics/Dataviz PowerBI/Synapse/Fabric SSIS/SSRS, ERP/migrations/support/PM/DataMgmt, D365FO/HR/CRM, SQLServer/Oracle, Ops/Soft-Eng, O/M365

 Cologne
sql-troubles.blogspot.com/
Joined December 2009
  • Tweets649
  • Following2.2K
  • Followers454
Do you remember when you joined X? I do! #MyXAnniversary
29
Microsoft works on a Metrics Layer in Fabric and the beginning looks promising. An overview of the functionality based on the information made available. Many thanks to @PowerBITips and Carly Newsome sql-troubles.blogspot.com/20… #Fabric #metrics #DataAnalytics #powerbi #MetricsLayer
The Metrics Layer in Microsoft Fabric (adapted diagram)

ALT The Metrics Layer in Microsoft Fabric (adapted diagram)

66
Many of the #dataviz on #ExchangeRates resume to a few bar #charts or line #plots that barely reflect the complex #behavior of the #data. There are other alternative ways of representing the same, which offer fresh and complementary #perspectives. sql-troubles.blogspot.com/20…
Exchange rates represented from different complementary perspectives.

ALT Exchange rates represented from different complementary perspectives.

30
"Data mesh is what comes after an #inflection point, shifting our approach, #attitude, and #technology toward #data." (Zhamak Dehghani, 2021) An inflection point should be the effect of a data mesh implementation and not vice versa. sql-troubles.blogspot.com/20… #datamesh #datadriven
Example of Inflection Points in R Language

ALT Example of Inflection Points in R Language

1
160
One can think of a #dataproduct within a #datamesh as a box (or Lego piece) which takes data as inputs, performs several #datatransformations on the data from which result several output data (#600words 3 minutes read) sql-troubles.blogspot.com/20… #dataanalytics #datadriven #domains
Data Products within a Data Mesh with Lego pieces

ALT Data Products within a Data Mesh with Lego pieces

47
Am I the only one who feels that the role of #boxplots is underappreciated in #datavisualizations? See the link for the code: sql-troubles.blogspot.com/20… #dataviz
Iris features by species (visualization in R language)

ALT Iris features by species (visualization in R language)

46
Testing #CRUD basic operations in #MicrosoftFabric's #DeltaTable via #notebooks seems to be straightforward, as long one knows the #SQL dialect used by #SparkSQL: sql-troubles.blogspot.com/20…
CRUD operations against a delta table in Microsoft Fabric via notebooks

ALT CRUD operations against a delta table in Microsoft Fabric via notebooks

54
The process diagram attempts to depict the main steps performed in Invoice Capture Power App available in Dynamics 365 #CRM and integrated with #Finance. sql-troubles.blogspot.com/20… #ProcessManagement #InvoiceCapture #D365FO #process #AccountsPayable
Accounts Payable - Capture Vendor Invoices process diagram

ALT Accounts Payable - Capture Vendor Invoices process diagram

51
If you're wondering what's good or wrong about these alternative data visualizations on Discount Rates, just check my blog post: sql-troubles.blogspot.com/20… #datavisualization #principles #tables #charts #excel
Alternative data visualizations for a dataset based on Discount rates.

ALT Alternative data visualizations for a dataset based on Discount rates.

46
I took the #AzureDiagrams Architecture Advisor for a #testdrive. Here's a diagram created with it for a serverless #DataLakehouse based on the Microsoft technology stack. Here's the blog post: sql-troubles.blogspot.com/20… #azuresynapse #SynapseInfluencers #lakehouse #architectures
2
92
Load more