Skip to main content

Topic: Tools

The Tools category brings together content about the tools used to represent data: Excel, Power BI, Vega, online applications, and AI. Here, we explore the potential and limitations of each tool, providing practical examples, comparisons, and strategies to transform data into clear and effective charts.

A collection of 38 posts

Imagem de cabeçalho ilustrativa de um post: Mapa de NUTS3 simplificadas da Península Ibérica
Topic: Tools

The new silver route

Experimenting with simplified NUTS3 regions showing the proportion of the elderly population in each region of the Iberian Peninsula.

· Jorge Camões

I asked ChatGPT to make a chart
Topic: Tools

I asked ChatGPT to make a chart

An attempt to create a chart with ChatGPT. Clearly aligned with some somewhat outdated ideas, it failed to understand what was intended.

· Jorge Camões

Imagem de cabeçalho ilustrativa de um post: Gráfico de linhas com 438 séries, ultrapassando o máximo que o Excel permite
Topic: Visuaization Design

Number of series in Excel line charts

Qual o máximo número de séries num gráfico? Leia sobre uma combinação de boas práticas de visualização de dados com a sua aplicação em Excel.

· Jorge Camões

Excel: sort + COUNTIF() = utter mess
🕰️Topic: Legacy

Excel: sort + COUNTIF() = utter mess

· Jorge Camões

Comparing Tableau and PowerBI visuals
🕰️Topic: Legacy

Comparing Tableau and PowerBI visuals

· Jorge Camões

Excel user's guide to make charts in Tableau
🕰️Topic: Legacy

Excel user's guide to make charts in Tableau

· Jorge Camões

10 reasons why you should take Excel dashboards seriously
🕰️Topic: Legacy

10 reasons why you should take Excel dashboards seriously

· Jorge Camões

Bullet charts: an easy way to make them in Excel [Data at Work series]
🕰️Topic: Legacy

Bullet charts: an easy way to make them in Excel [Data at Work series]

· Jorge Camões

Excel vs. Tableau vs. PowerBI
🕰️Topic: Legacy

Excel vs. Tableau vs. PowerBI

· Jorge Camões

Excel 2016: the elephant (not) in the room
🕰️Topic: Legacy

Excel 2016: the elephant (not) in the room

· Jorge Camões

Easy way to make bullet charts and boxplots in Excel
🕰️Topic: Legacy

Easy way to make bullet charts and boxplots in Excel

· Jorge Camões

Excel dashboard: Using Excel for catchment area analysis
🕰️Topic: Legacy

Excel dashboard: Using Excel for catchment area analysis

· Jorge Camões

Making Excel maps without VBA
🕰️Topic: Legacy

Making Excel maps without VBA

· Jorge Camões

Qlikview vs Tableau? I have to choose and I'm not sure
🕰️Topic: Legacy

Qlikview vs Tableau? I have to choose and I'm not sure

· Jorge Camões

Making maps in Excel: cross-stitching edition
🕰️Topic: Legacy

Making maps in Excel: cross-stitching edition

· Jorge Camões

Excel Charts meet William Playfair
🕰️Topic: Legacy

Excel Charts meet William Playfair

· Jorge Camões

Excel Dashboards: Who Needs Them, Anyway?
🕰️Topic: Legacy

Excel Dashboards: Who Needs Them, Anyway?

· Jorge Camões

In London for the Tableau 6.0 Tour (Part II)
🕰️Topic: Legacy

In London for the Tableau 6.0 Tour (Part II)

· Jorge Camões

In London, for the Tableau Tour
🕰️Topic: Legacy

In London, for the Tableau Tour

· Jorge Camões

How Do You Sell an Excel Dashboard?
🕰️Topic: Legacy

How Do You Sell an Excel Dashboard?

· Jorge Camões

Want to Improve Your Excel Skills? Learn Access
🕰️Topic: Legacy

Want to Improve Your Excel Skills? Learn Access

· Jorge Camões

Animation, Interaction and Dynamic Excel Charts
🕰️Topic: Legacy

Animation, Interaction and Dynamic Excel Charts

· Jorge Camões

Are Excel Charts Hurting Your Business? 10 Mistakes You Should Avoid.
🕰️Topic: Legacy

Are Excel Charts Hurting Your Business? 10 Mistakes You Should Avoid.

· Jorge Camões

Excel Charts: If It Isn’t Broken…
🕰️Topic: Legacy

Excel Charts: If It Isn’t Broken…

· Jorge Camões

How a Bad Excel Dashboard Made me a More Skilled Excel User
🕰️Topic: Legacy

How a Bad Excel Dashboard Made me a More Skilled Excel User

· Jorge Camões

Fighting IT? Prototype an Executive Dashboard in Excel
🕰️Topic: Legacy

Fighting IT? Prototype an Executive Dashboard in Excel

· Jorge Camões

Can Too Much Excel Harm your Career?
🕰️Topic: Legacy

Can Too Much Excel Harm your Career?

· Jorge Camões

Learn Excel, Spend More Time with the Kids
🕰️Topic: Legacy

Learn Excel, Spend More Time with the Kids

· Jorge Camões

Excel chart gallery: a difficult equilibrium
🕰️Topic: Legacy

Excel chart gallery: a difficult equilibrium

· Jorge Camões

Creating a VBA-free Excel dashboard
🕰️Topic: Legacy

Creating a VBA-free Excel dashboard

· Jorge Camões