Skip to main content

BI Tools

https://www.toptal.com/business-intelligence/interview-questions

PowerBI vs Google Data Studio​

Overall, both Power BI and Google data studio are similar when it comes to data integration, Power BI has better ease of working(given our understanding of Microsoft tools such as Excel) and functionality whereas Google data studio requires significant learning and workaround to achievesimilar visualizations. Please find below details for the same.

  • Data Integration
    • Both the tools connect to various data sources without much issues (In few instances, third party tools might be required for Google Data Studio).
    • However, Data studio has an edge when connecting with Google services. Google services like AdWords, Google Sheets and Google Analytics are natively fully integrated with Google Data Studio.
    • Google data studio might need third party applications such as Supermetricsfor adding few data sources.
  • Functionality
    • Power BI has a large functionality with sophisticated functions. For example, basic functionality such asline, bar and pie chartsare available in both the tools, sophisticated functions suchCohort analysis, standard funnelare not available in Google data. However, I believe these visualizations could be achievedby modifying data using SQL queries.
    • Power BI is superior to Google data studio in processing data visualization with large data.
  • Ease of working
    • Power BI's DAX functions being similarto Excel formulas (which most of the team members have experience on), is a bit easier to work on.
    • Working on Google data studio would be a learningcurve.
  • Pricing
    • Power BI costs $10 per user while Google data studio is free of cost.
    • However, adding few data sources to Google data studio needs third party applications such as Supermetrics which costs between $20 - $50.
    • Given Google data studio is a cloud based application, it would eliminate the need for AWS machine(needed to build Power BI report)to builtthe reports.

QlikView​

Others​

  1. QlikView

  2. Klipfolio

  3. Geckoboard

  4. Google Data Studio

  5. Domo

  6. SSRS (Sql Server Reporting Services)

    SQL Server Reporting Services(SSRS)is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

  7. Sisense - https://www.sisense.com

image

https://medium.com/activewizards-machine-learning-company/a-comparative-analysis-of-top-6-bi-and-data-visualization-tools-in-2018-658490665973

Redash​

Redash was built to allow fast and easy access to billions of records, that we process and collect using Amazon Redshift ("petabyte scale data warehouse" that "speaks" PostgreSQL). Today Redash has support for querying multiple databases, including: Redshift, Google BigQuery, PostgreSQL, MySQL, Graphite, Presto, Google Spreadsheets, Cloudera Impala, Hive and custom scripts.

Redash consists of two parts​

  1. Query Editor: think of JS Fiddle for SQL queries. It's your way to share data in the organization in an open way, by sharing both the dataset and the query that generated it. This way everyone can peer review not only the resulting dataset but also the process that generated it. Also it's possible to fork it and generate new datasets and reach new insights.
  2. Visualizations and Dashboards: once you have a dataset, you can create different visualizations out of it, and then combine several visualizations into a single dashboard. Currently Redash supports charts, pivot table, cohorts and more.

https://github.com/getredash/redash

https://redash.io

https://hub.helm.sh/charts/redash/redash

Rive​

Rive is a real-time interactive design tool that allows you to design, animate, and immediately integrate your assets into any platform thanks to our open source runtimes

https://rive.app

AWS QuickSight​

Amazon QuickSight is built with "SPICE" -- a Super-fast, Parallel, In-memory Calculation Engine. Built from the ground up for the cloud, SPICE uses a combination of columnar storage, in-memory technologies enabled through the latest hardware innovations and machine code generation to run interactive queries on large datasets and get rapid responses. SPICE supports rich calculations to help you derive valuable insights from your analysis without worrying about provisioning or managing infrastructure. Data in SPICE is persisted until it is explicitly deleted by the user. SPICE also automatically replicates data for high availability and enables QuickSight to scale to hundreds of thousands of users who can all simultaneously perform fast interactive analysis across a wide variety of AWS data sources.

Amazon Q in Quicksight​

Topics​

Getting started with Amazon QuickSight Q - Amazon QuickSight

  • Exclude unused fields
  • Verify friendly field names
  • Add synonyms to fields
  • Review field configurations

DataIQ​

DataIQ is a business intelligence platform designed to help organizations manage, analyze, and derive insights from their data. It typically combines data governance, analytics, and data science capabilities to enable companies to become more data-driven. DataIQ allows users to access and analyze large datasets, create predictive models, and generate actionable insights, often with a focus on improving business outcomes. It can integrate with various data sources and tools to provide a unified view of data across an organization. The platform is used by data professionals, including data scientists, analysts, and business users, to streamline data operations and decision-making processes.

DataIQ - Collaboration and intelligence for data leaders.

Others​

https://www.talend.com/

GitHub - finos/perspective: A data visualization and analytics component, especially well-suited for large and/or streaming datasets.

ThoughtSpot | The AI-Powered Analytics Platform

Reporting and embedded business intelligence software | Jaspersoft