Over the past years, Power BI became a widely used BI tool for lot controllers and business analysts. One of the key factors of its popularity is user-friendliness. To improve that, a lot of external tools can be used together with Power BI (Desktop). In this article, we are highlighting the most useful ones.
DAX Studio by SQLBI
DAX Studio can be used to analyze and test DAX queries. Once it is installed, you can open it from the “External Tools” ribbon in Power BI Desktop.
We use DAX Studio primarily to analyze DAX queries generated by the performance analyzer in Power BI and to create calculated tables.
Recently a query editor was added which makes it very easy to create your own DAX queries.
You can find more information on DAX Studio via this link.
Tabular Editor by SQLBI
Since September 2020 it is possible to connect Tabular Editor to Power BI Desktop or a published Power BI Premium data model (Enhanced Dataset Metadata).
With Tabular Editor, you can create calculation groups (explained in a separate article), create and edit measures, and format these measures with DAX formatter.
The advantage of using Tabular Editor is, next to Calculation Groups, that you don’t have to wait for your measures to be evaluated every time you add one. The evaluation time can take up to 10-15 seconds for large models.
You can find more information on Tabular Editor via this link.
ALM Toolkit by SQLBI
ALM Toolkit is a feature that is also available for Power BI since September 2020. This toolkit enables you to compare 2 datasets. The comparison is done for Power Query expressions, relationships, and DAX expressions. This analysis is very useful for version management en tracking changes.
If you are connecting to Power BI Desktop models, you can push updates to measures from one model to the other.
You can find more information on ALM Toolkit via this link.
More information on external tools can be found on the website of SQLBI and Microsoft.
Related content
-
Article
Balancing personalization and risk sharing: the future of the Belgian non-life Insurance Industry in the Age of AI
-
Article
Expanding Enterprise Performance Management across the company
-
Reference case
Designing a harmonized business process for ERP readiness
-
Blog
The impact of Artificial Intelligence on Financial Institutions
-
Reference case
Proactive mindset, maintaining continuity in the bookkeeping department and looking for connection between different processes at LBC Tank Terminals
-
Reference case
Getting the team back on track
-
Career as Consultant
Data Engineering Manager
-
Career as Consultant
Enterprise Performance Management Consultant
-
Career as Consultant
Finance Consultant
-
Career as Consultant
Risk advisory consultant
-
Career as Consultant
Project Manager Finance
-
Freelance opportunities
Interim Manager Finance | Wallonia