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.

* Capability of some other products that you will find here making your time to market improve. * If you want to start you do not have to pay, it's reachable for everyone just searching on store. * A lot of documentation and community with years of experiences.

Couple of things which I liked the most: 1) You have multiple options of data sources where you can connect your data to build dashboards 2) Second thing which I like most is that you can work on the dashboard with the desktop feature and when you are ready with the dashboard you can publish it on the web where everyone can see it. 3) Third thing is the App feature introduced by power bi where you can collate multiple dashboards in one place and you can even access the dashboard through with the mobile devices which is very useful.

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.

* Using it is like having some excel with visualization and relational model, it's not something that helps you to talk easily with data just easy to use and connect. * It's pretty difficult to understand licenses if you are looking for it. * Some features and changes will just happen with no alert or communication.

These are the places where I realised they have to improve: 1) underlying data you can't access within the dashboard - I think this should be required because if you see that a metric has dipped then you can just click on that metric and see the underlying data to see who is contributing to the dip so you do not have to download raw data and apply multiple filters to see who is contributing to the dip in that metric. 2) Some pre-formatted graphics need to exist in power bi so that let's say if I have created a dashboard with multiple widgets and visualizations and apply that format it will make our whole dashboard in a better way. 3) When the dashboard file is exceeding more than 400 mb it will be very slow in responding if we are doing any changes which is very painful for us to work.