Tools for Data Analyticss
BI tools are applications such as Power BI, Tableau, Looker Studio and Metabase that connect to data, model it and publish interactive dashboards. They add filters, refresh schedules and sharing on top of charts. This unit follows visualisation principles on the Data Analytics path and compares how the main tools differ in cost and depth.
Stage: Visualisation and BI · Part of the Data Analytics roadmap · Last reviewed 19 November 2026
What to learn in Tools
- Connect Power BI to a CSV file or database and shape data in Power Query
- Create DAX measures such as total sales and year-to-date sales
- Build a Tableau dashboard with filters and a drill-down
- Publish a Looker Studio report on a Google Sheets source
- Pick a BI tool by budget, data source and audience
Tools interview questions
What is the difference between a calculated column and a measure in Power BI?
A calculated column is computed row by row when data loads and stored in the model. A measure is evaluated at query time in the context of filters and slicers, so it can show different totals for different selections. Use measures for aggregates.
Why might a team choose Metabase or Looker Studio over Power BI or Tableau?
Metabase is open source and lets non-technical people ask questions of a database, and Looker Studio is free and fits Google data such as Sheets and BigQuery. Power BI and Tableau offer deeper modelling and enterprise features but cost more and need more setup.
Where Tools fits in the Data Analytics roadmap
Tools belongs to the Visualisation and BI stage (beginner level), which takes about 5 hours. Make insight obvious.
Other units in this stage
Back to the full Data Analytics roadmap