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 say 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 and DAX language and Vertipaq Storage Engine beneath Power BI anbd 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.
From 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
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 may…
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 table…
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)More date…
What’s Coming in RTM For Power View
We’ve just finished the SQL 2012 Road show featuring Always On, BISM, PowerPivot 2.0 and Power View (formally project crescent). There are a few more features coming in RTM that we could not demo, but be aware that they will…
Where are Power View / Project Crescent Samples
A few people have asked for links to sample BISM data models and reports to demo Project Crescent or Power View. There are two main choices 1. The official site has a Hello World Picnic or Adventure Works examples which…
Using MAP Tool to Analyse IO for SQL Consolidation. Part II – Using Power Pivot
By Bob Duffy6. April 2011 11:43 As mentioned previously (http://blogs.prodata.ie/post/Using-MAP-Tool-and-Excel-to-Analyse-IO-for-SQL-Consolidation-Part-I-e28093-basic-distribution.aspx), the MAP tool has a nice database containing all your disk IOPS data and this is nicely contained in a single table called “performance_disk” We can use PowerPivot to analyse the…
Loading…
Something went wrong. Please refresh the page and/or try again.