Microsoft BI - A diamond in the rough

Dashboarding with simple data relationship.

In the oil and gas industry, it's common to be analyzing geospatial items along with cross-sectional data, and this can easily go over the row limit that Microsoft BI has for its map visualization; this is a shortfall.

For high-level dashboarding, say, aggregated data for management reporting, Microsoft BI is perfectly suited due to its professional layout and ease of deployment. The data modeling aspect in Microsoft BI leaves much to be desired as it doesn't allow for many relationships which are rather common in the data used in our industry; this forces users to create a unique key by having to concatenate columns of interest, which tend to result in untidy data and make maintenance difficult.