Looking for the best analytics software for a medium-large-sized firm. We currently use a Microsoft SQL Server database that is analyzed in Tableau desktop/published to Tableau online for users to access dashboards. Is it worth the cost savings/time to switch over to using SSRS or Power BI? Does anyone have experience migrating from Tableau to SSRS /or Power BI? Our other option is to consider using Tableau on-premises instead of online. Using custom SQL with over 3 million rows really decreases performances and results in processing times that greatly exceed our typical experience. Thanks.
You need to start using Datawarehouse (DWH) solution and then feed data to tableau. For that you need to setup data pipelines and then transform data in the DWH, move all the custom queries into the DWH. This process is called ELT. You need AWS Redshift or Google Bigquery, a serverless scalable solution, this is the bottle-neck on your current SQL, not meant for processing millions of rows of data. A team of Data engineers can help you to setup these solutions.
Agree with Parth this sounds like an architecture issue not a tool problem.
Tableau is a great Analytics tool but if you keep utilising large extracts with lots of filters there will be performance hits.
Try switching from a mass extract filter exclude model to direct connect, include model. For performance I can highly recommend Snowflake as the DWH platform which has been a game changer for us. Good luck.
BI tools are only as good as the data they're connected to. If you're already experiencing performance issues, you might want to consider a cloud database like Snowflake.
In my experience, there isn't a whole lot of a difference in PBI vs Tableau, for the vast majority of analysis. Personally, I favor Tableau because you can make really fancy/pretty things, but most business don't require that level. Most of the time I've seen people choose PBI due to cost or their team is already familiar with the platform.
I also recommend checking out Sigma Computing (sigmacomputing.com), they are a BI tool built like a spreadsheet so it's easy for people to learn and understand, and they're specifically built to optimize Snowflake connections.