If you run powerBI in a VM, and you’re working with a large dataset, there are a couple of optimizations you may want to consider. The tabular database within PowerBI is an in memory database, and it can be computationally …..
Recently, I’ve been working with a large inventory dataset (1.8M transactions), and trying to find ways to identify the sequence of transactions. The dataset is very simple, with an assetID, a transaction date, and a transaction ID. The latter is …..
Data quality assessment is a task that I find I frequently need to do quickly and efficiently as I work with new data. Say I get two tables with ID’s with different attributes. It’s common to check how many of …..
Lately, several clients have been curious what the difference is between PowerBI and Microsoft SSAS. These points are basic guidelines for business users, and not technical users. MS BI Blog has a more technically geared analysis of what your options …..
I’ve been working on a project that has a rather large model, composed of a couple larger datasets (260,000 rows x 10 columns) and (270,000 rows x 25 columns). So not large at all, nothing the tabular model in powerBI …..
Enterprise report delivery with powerBI One of the lessons most people will learn while enterprising cloud solutions is that you will trade off the cost, security, and convenience of a cloud application for the lack of control around it. Microsoft …..
Lately, in solving a simple problem, I’ve discovered something about powerBI that offers enormous potential. I found that the data model within powerBI is available as a tabular model in the cloud, leading to a visualized modelling environment that has …..
PowerBI has a unique foothold among the other BI tools operating in it’s space. Leveraging the dominance of the office suite of tools, power BI is literally standing on the shoulders of a giant. Consider the gartner magic quadrant for …..
This seems like it should be straight forward, but it’s not. The documentation on the TOTALYTD function is not great. Suppose I have a fact table with monthly revenue, and a standard date dimension. The date dimension has a date …..
I’ve been working on a big powerBI dog and pony show lately, and have discovered a couple things in my haste. (Not really when I want to be discovering them) Filtering over a summarize or crossjoin is a terribly inefficient …..