Enterprise Level Power BI Expertise
Prodata have been helping enterprise customers in Ireland with large scale Power BI implementations from 10 to 10,000 users. Whether you are using Prodata to build your reports or build a managed self service data platform with the correct security and governance we can help.
A special focus for Prodata is designing data security models to support multi division or multi country access to corporate data via PowerBI, and if needed, SSAS.
Below are some of our award winning presentations on Power BI
CashFlow Modelling in Power BI for the Enterprise
The Irish Economic Crisis Visualised in Power BI
https://tecflix.com/knowledge/irish-economic-crisis-visualised-in-power-bi-video
DAX Internals and Performance Experts
Prodata bring a world class understanding of the Internals of the DAX language and Vertipaq Storage Engine beneath Power BI and its big brother, SSAS. All our consultants attend and follow training from the world leaders in DAX Tuning at https://www.sqlbi.com/
If you need a partner who deeply understands performance and DAX tuning, then talk to us
Community Recognition
Here at Prodata we help run the SQL Ireland User Group including PowerBI Content. With initiatives such as SQL MasterClass, regular meetups and annual conferences such as SqlSaturday and Data Ceili.
Since 2008 Bob Duffy has been awarded MVP in Data Platform from Microsoft for community services such as speaking at International / local events and organizing events for the Irish data community.
Power BI Blog Posts
How to create a service principal to automate Fabric
Service Principals are essential to using the Fabric REST API for automation. In this blog well show you how to create a service principle that can be used to automate API calls to PowerBI such as refresh. Once you have…
Success with Azure Synapse Analytics: Mastering Data Warehousing
In today’s data-driven world, organizations must effectively manage and utilize vast amounts of information to gain insights and stay competitive. To achieve this, companies are increasingly turning to data warehouses, a centralized repository that stores and organizes structured and unstructured…
How to Refresh Fabric Datasets using Python API
If you are like me and wants to automate the task to refresh Fabric datasets to report latest data to users then this article is for you. The automation can be done using Python REST API and the article will…
Power BI- Data Connectivity Modes
Import Data This connection means that Power BI will cache the data meaning Pulling data from Data Source and into Power BI Desktop File. Advantages: Caching the data makes you take full advantage of Vertipaq Engine. Report Performance will be…
Sample Financial Reports for Adventureworks (Updated)
** Update 29/05/2021 – Newer samples are now available on GitHub at https://github.com/ProdataSQL/FinancialModelling The PBIX is preloaded, so you don;t need to load files, but if you don want to, you will need to change file locations to match where…
Cashflow using M2M Rules Tables in Power BI
Here is my video on implementing cashflow using M2M Rules Tables in PowerBI
Using Many to Many for Running Sum
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…
Using Many to Many for Financial Reporting
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…
Why Chart of Accounts doesn’t work 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…
Financial Modelling in PowerBI – Downloads
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…
Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)
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…
Gotchas on PowerPivot for SharePoint to 2012 RC0
If there is one product in the MS BI stack that is worth upgrading as soon as possible then it is PowerPivot. The 2012 version offers lots of new features such as: Lots of new features: Diagram View (at last)…
Loading…
Something went wrong. Please refresh the page and/or try again.