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.

1: Esta es su ventaja absoluta. Conecta a Azure SQL Database, Sypnapse, Dataverse o incluso una simple tabla de Excel es SharePoint Online es cuestión de clics 2: A pesar de su curva de aprendizaje intermedia, DAX (Data Analysis Expressions) es un lenguaje increíblemente potente y flexible. 3: La publicación de informes desde el Desktop al Service es sencilla y abre un mundo de posibilidades: dashboards interactivos accesibles desde cualquier navegador o la app móvil, alertas de datos, actualizaciones programadas y, sobre todo, una colaboración excelente.

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: El entorno de desarrollo (Desktop) puede volverse muy lento e inestable cuando se trabaja con modelos que superan varios gigabytes o tienen relaciones complejas y mucha tablas. 2: Si bien DAX es una fortaleza, también es una gran barrera de entrada. Para ir más allá de los informes básicos, es necesario entender conceptos de modelado tabular (herencia de DataVertis), contextos de filtro (contexto de fila vs. contexto de filtro) y funciones complejas. 3: La estructura de licencias puede ser confusa y costosa a escala empresarial. La diferencia entre capacidades PRO (por usuario) y Premium (por capacidad o por usuario) es significativa .