Microsoft Power BI

Power BI is best known for its ability to allow basically anyone - no matter their skill level - to transform data into meaningful insights with interactive dashboards and reports. Simply the fact that it automatically works with Excel, Azure, and other Microsoft services makes it an ideal match for companies that already value the Microsoft ecosystem, thus taking the work processes to a higher level of efficiency and cross-team collaboration.

There are lots of visually engaging ways to display the data and to connect various portions of the display together so that related portions of the data are kept in sync.

The most valuable aspect of the product is the ability to deliver interactive and real-time dashboards that are easy to share and customize. Power BI enables us to consolidate data from multiple sources. We have loaded multiple sources into our ADLS location and then based on the requirements we are deploying the data into our Power BI dashboard like CC Assist data, data quality reports and data governance reports.

Microsoft Power BI is really high up on my challenge list mostly because of the complicated and advanced features that go along with its learning curve, for example, DAX and complex data modelling which often become a problem for new users or people who do not have a technical background. Although the interface is user friendly for basic tasks, understanding the more complex functionalities still requires a lot of time and training. In addition, the software might work slower when trying to handle a big data set or a model that is not optimized well for which certain visual customization options. Licensing could also be an issue because of the sharing and collaboration features that require Power BI Pro or Premium may not be economically affordable by smaller teams and organizations.

1.) There is no way to subscribe to a report and have the data sent to you. You can subscribe and get a notification that data is there and get an image of the report but the ability to subscribe in the traditional sense is not there. 2.) Permissions aren't granular enough. For someone to be able to use filters, you have to give them the ability to edit the report. There ought to be a way for someone to use a report and be able to filter the data in it without them being able to also edit (and potentially, corrupt) it. 3.) Workspaces need folders. Data organization is a weakness for Power BI. 4.) Report sprawl is definitely a thing. It's hard to see which reports are related and easy to get lost in copies of copies of copies.

1)Complex joins or large data sets will face issues while loading the data which will delay in displaying the data. 2) Fewer visualization and formatting options when compared to other tools in the market 3) Integrating with too many external systems fewer times facing challenges