PowerBI

Hello everyone,

My team and I are currently in the process of selecting a Business Intelligence (BI) tool for our actively developing company, which has over 500 employees. We are considering open-source options.

We are keen to connect with a Head of Analytics or BI Analytics professional who has extensive experience working with any of these systems and is willing to share their insights. Ideally, we would like to speak with someone from companies that have transitioned from proprietary BI tools (such as PowerBI, Qlik, or Tableau) to open-source BI tools, or vice versa.

If you have any contacts or recommendations for individuals we could reach out to regarding this matter, we would greatly appreciate it. Additionally, if you are personally willing to share your experiences, please feel free to reach out to me directly. Thank you!

We're looking for a better way to gather complex data from our members and provide visualisations in a PDF report or online dashboard. Currently, we use Stacker to collect data, Airtable to store it, and PowerBI Desktop to build reports.

The data we collect is greenhouse gas emissions data, including several years of utility data, vehicle consumption data, waste production, paper consumption, and so on. Hundreds of possible data points for each member with a large degree of variation and dependency within those data points. One member might have a fleet of a hundred vehicles, and we need to know the make/model/year/fuel type of each one, plus the actual fuel consumption, while another member doesn't have any fleet emissions, but produces a large amount of refrigerants, and so on.

Stacker does not give us the dynamic flexibility we need for this ingestion project. Airtable Interfaces could potentially get us there, but we're not sure if it is as sophisticated as we need it to be especially with all the conditionals. We haven't explored Jotform or Appscript or other options yet.

Thanks!

Hi!,

Current status:

I designed an online assessment questionnaire. The application is written with PHP server-side scripting and an Oracle MySQL backend database. The data visualisation is utilising PowerBI connecting via the app using the PowerBI API. The application is hosted on a Linux server with the capacity to scale for larger groups available when required.

Future Needs:

I want to automate the processing of the results in the backend database and create individual and organisation results.

Can you advise how best to do this? Regards and thanks. John Conway

We need to perform ETL from several databases into a data warehouse or data lake. We want to

• keep raw and transformed data available to users to draft their own queries efficiently
• give users the ability to give custom permissions and SSO
• move between open-source on-premises development and cloud-based production environments

We want to use inexpensive Amazon EC2 instances only on medium-sized data set 16GB to 32GB feeding into Tableau Server or PowerBI for reporting and data analysis purposes.