Configuration Steps Create a Azure Data Lake Storage Gen 2 storage account, make sure to enable Hierarchical namespace. Read Microsoft KB here. Create a Synpase workspace and select newly created data lake storage as Account name and blob container as … Continue reading Synapse workspace: Load data using Polybase and Managed Identity
In data engineering a common challenge is to securely establish communication between different services. By providing an Azure resource identity in Azure AD and using it to obtain Azure Active Directory (Azure AD) tokens, Managed identities (formerly known as Managed … Continue reading How to configure Manage Identity in Synapse Analytics Workspace?
When working with synapse as a TSQL developer, it does feel like you’ve gone in a time warp back to SQL 7.0 in terms of whats supported and whats not. Luckily most of the TSQL patterns not supported have some … Continue reading Synapse TSQL: variable assignment in SELECT statement cannot be included
I updated my AdventureWorks Sample Report to include CashFlow, so we now have the three core areas of GL in one PBIX. Profit and Loss Balance Sheet Cash Flow You can download the PBIX from below link https://1drv.ms/u/s!Aquy5jaDyEyihsVDWoQ9TKyGRzwWSA?e=O4VkYr You can … Continue reading Sample Financial Reports for Adventureworks (Updated)
There are some well known design patterns and blogs for handling running sum commonly used on reports such as Profit and Loss Statements.https://www.daxpatterns.com/cumulative-total/ I’ll show here an alternative approach that I commonly sue when we have a Many to Many … Continue reading Using Many to Many for Running Sum
1) For multiple Reports and Report Variations As discussed in a previous blog article, simple Profit and Loss may assume a single reportinghierarchy rolling up account numbers into a reporting line and heading. As this starts to break down we … Continue reading Using Many to Many for Financial Reporting
For financial reporting, can we use the Chart of Accounts as a hierarchy for all our reporting needs ? The short answer is: In the ideal world – Yes. In the not ideal world – No. The Chart of Accounts provides us … Continue reading Why Chart of Accounts doesn’t work for Financial Reporting
For my session in SQL bits on Financial Modelling in PowerBI there are couple of useful downloads if you want to follow or dissect at home. 1) AdventureWorksDW2017This data warehouse has an albeit basic data warehouse version of an accounting … Continue reading Financial Modelling in PowerBI – Downloads
While the Matrix Control does has some new features for automatically handling ragged hierarchies as described by Reza Rad and others (https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual), it falls short of what we want to achieve on most of my projects and still doesn’t come … Continue reading Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)
Coming off the tails of the hugely successful SQL Saturday Dublin events, Data Ceili – Dublin 2020 is shaping up to be Irelands largest Microsoft Data Platform event. We still have till then end of Jan 2020 for speaker submissions … Continue reading Why I’m looking forward to Data Ceili–Dublin 2020
Inspired by the DBA tools (https://dbatools.io/) library for automating all things SQL Server DBEngine I created some Powershell Library functions to automate SSIS Build and Deployment. We use this on projects to move SSIS closer to the world of DevOps … Continue reading Automating SSIS Build and Deployment with Powershell
Something went wrong. Please refresh the page and/or try again.