Power BI

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

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…

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…

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…

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…


Something went wrong. Please refresh the page and/or try again.