Forum Discussion
BI Tools Comparison
i have prepared below questionnaire to identify factors (example performance, data volume etc) which needs to be considered while doing comparison of BI Tools available in the market, are there questions fine or i am missing anything?
- Kindly share the key business objectives you are looking to achieve uisng the new BI Platform or To be BI Platform
- What are the current challenges you are facing with existing BI Platform ?
- What is the budget you are looking for new BI Platform?
- Approximately how many users would be using new BI Platform , how many of them want to create reports on their own, how many report developers and how many viewers
- Approximately how many users are expected to access the reports or dashboards at the same time during peak hours?
- Are you currently using any Cloud Platform such as AWS, Azure or GCP?
- Are you specifically looking for SaS or Cloud BI Platform , or an On-Premises BI Platform?
- The new BI Platform would connect to which database or data warehouse for reporting?. Example Snowflake, Data bricks etc
- What is the current size of the data (GB/TB) that will be used for reporting, and how much is it expected to grow monthly or annually?
- What are the typical security requirements such as row or column level security (data visiability on reports based on user preference)?
- In which format users would require report extracts , example excel, csv or pdf?
- What are the typical security requirements to expect from BI Tool
- Do we need reports which can ready for print with data displayed in tables or sections and split across multiple pages, example contracts or bank statements?
- Are you currently facing any performance challenge with existing reports?
- What is the expected data latency for real-time or near real-time reporting, e.g., less than 5 minutes, 5–10 minutes etc. in order to display data on dashboards?
- Do you to anticipate to use advance charts such as sunburst , wordcloud , sankey or custom visuals for reporting purpose or reports can be handled using basic charts such as table, pivot, bar , line etc
- Would there be a need to view reports or dashboards on mobile or tablet devices?
- Is there a requirement to view reports or charts Titles or Labels in other language apart from English?
- Is there a requirement to perform self-service analytics or create ad hoc reports using new BI Platform?
- Are there any specific AI/ML use cases or advanced analytics capabilities that you anticipate in near future ?
Your question is fine, but consider adding these aspects
Data Refresh Frequency (Real time, Hourly, Daily)
Data Connectivity (Import, Direct query, Live connection, APIs)
Expected number of reports/dashboards
Data governance aspects (Catalog, lineage, certified data sets)
Requirement for embedded analytics
Report Scheduling and Subscriptions
Dev, Test, Prod and Version Control
Migration of existing reportsSolid list. Main gaps to add:
Data refresh frequency and scheduling.
Team skills (SQL, DAX, Python) since this drives tool fit.
Licensing model: per-user vs capacity pricing.
Embedding needs (reports inside another app or portal).
Non-database sources (APIs, Salesforce, flat files).
4 Replies
- Shahid12523Community Champion
Your question is fine, but consider adding these aspects
Data Refresh Frequency (Real time, Hourly, Daily)
Data Connectivity (Import, Direct query, Live connection, APIs)
Expected number of reports/dashboards
Data governance aspects (Catalog, lineage, certified data sets)
Requirement for embedded analytics
Report Scheduling and Subscriptions
Dev, Test, Prod and Version Control
Migration of existing reports - Kedar_PandeSuper User
Solid list. Main gaps to add:
Data refresh frequency and scheduling.
Team skills (SQL, DAX, Python) since this drives tool fit.
Licensing model: per-user vs capacity pricing.
Embedding needs (reports inside another app or portal).
Non-database sources (APIs, Salesforce, flat files). - v-hashadapuCommunity Support
Hi powerbiexpert22 , Thank you for reaching out to the Microsoft Community Forum.
We find the answer shared by Shahid12523 is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you Shahid12523 for your valuable response.
- v-abhinavmuCommunity Support
Hi powerbiexpert22,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you