Business Intelligence Tools Investigation

Finding which tools makes sense depends on a few factors

  • Do the people who will use the tools know SQL?
  • Is the tool SOC2 compliant?

SQL BI Tools

If the users are proficient in SQL there are a few tools that could be pretty inexpensive or free if you hosted it yourself. Some of these tools include:

  • Metabase
  • Redash

However, these do not appear to be SOC2 compliant either

SOC2 Compliant Tools

With SOC2 compliance, which we will probably need the number of tools narrows:

  • Power BI
  • Looker Free
  • Tableau cloud

Tool Pricing

Tableau

  • $115/month for a creator
    • Someone who does data administration
  • $70/month for an explore
    • Who does data analyst work’
  • $35/month for a viewer

Power BI Online

  • $10/month Power BI Pro (Basic)
    • Can create reports? Need to investigate
  • $20/month Power BI Premium
    • Can use larger model sizes
    • More frequent refreshes

Looker Studio

  • Free
  • Has size limitations

Fiverr Hourly Rates

Using these three tools, the average hourly rates to hire a data analyst on average

  • Power BI: $50-100/hourly
  • Tableau: $50-100/hourly
  • Looker: $100-500/hourly, few choices