Microsoft BI - A diamond in the rough
Rating: 7 out of 10
IncentivizedUse Cases and Deployment Scope
Data modeling, visualization, and analytics.
Microsoft BI is currently only used for dashboarding (descriptive analytics), where data relationship is simple, while most of the predictive analytics are done in other tools.
Microsoft BI is currently only used for dashboarding (descriptive analytics), where data relationship is simple, while most of the predictive analytics are done in other tools.
Pros
- Easy integration with other Microsoft products.
- Great integration with R/Python.
Cons
- Map visualization limit on data count
- Inability to model data relationship with multiple non unique keys
Likelihood to Recommend
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.
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.
IL
Ivan Leung
Data Analytics in Engineering at Oxy (10,001+ employees)
Vetted Review
1 year of experience