Skip to main content

Columns 101

Pick a scenario to learn​

This is a list of short demos to show some basic features that Columns enable you to accomplish! If you find it useful, all the videos linked in this page could be found in this Youtube playlist.

Does the emoji have any meaning? Nope, they are randomly picked, :)

🏞️ (E1) Natural language to query​

Inspect your data schema and type a natural language question to Columns for a query.

Video: https://youtu.be/TmPvVLV4qXQ

⚜️(E2) Flexible timeline & forecasting​

Specify a time column in the data connection to enable flexible timeline analysis. Also, you get a 1-click future prediction.

Video: https://youtu.be/kTx4yq9JnU4

πŸ˜€ (E3) Smart widget​

The smart widget can be placed in any position in the graph to run a quick summary of the query results. Also setting goals for each metric to track progress.

Video: https://youtu.be/raUpkJc1yMQ

πŸ›©οΈ (E4) Smart data marker​

Smart data markers automatically summarize a data point in a floating pop box to help highlight a specific point you want to draw your audience’s attention.

Video: https://youtu.be/DnVCjXExBeY

πŸ›ƒ (E5) Customize metrics with alias, color, and currency​

Every metric can be customized, today Columns support alias, color, and currency format.

Video: https://youtu.be/-X3PfXDgXZo

🌨️ (E6) Color, palette, background, font, format​

These are basic general settings, almost all charts/widgets use them.

Video: https://youtu.be/RgD7XVjf0HY

⚧️ (E7) Result transform​

Sometimes, you want to present your data in a different way - a specific comparison way for better data storytelling, transform gives a different view of your data.

Video: https://youtu.be/REO_yP7SZWY

⛏️ (E8) Pivot data into different metrics​

The time you want to break down one property by another, you need to pivot. Similar to Excel pivot table, Columns gives you a one-click experience.

Video: https://youtu.be/7UgXKmqJCLQ

🌺 (E9) Highlight some bars​

As part of data storytelling, creating a comparison view is one important technique that draws your audience's attention to focus on a point you’re making. Bar highlighting is one outstanding way.

Video: https://youtu.be/mYDNxBT_fgo

🎨 (E10) Area, Line, Dot​

The line graph is used common widely, choosing different styles for line graphs to meet the best effect for your scenarios, dots for differentiation, lines for clear trending, and areas for a beautiful look and feel.

Video: https://youtu.be/gkc2xXWJN6U

πŸ‘Ό (E11) Any web page to a word cloud​

Quickly turn any web page into a beautiful word cloud to share. This is a convenient tip for you!

Video: https://youtu.be/Me0b9a1e6SA

πŸͺ“ (E12) Customize axes​

Many graphs have axes, such as the most popular ones like bars, and lines. Columns offer extensive customizations on Axes, check them out!

Video: https://youtu.be/gNcDS5GMatU

πŸ“ (E13) Fancy table​

Tables are not used that often, but when you really want to style them, they could be super fancy!

Video: https://youtu.be/WmBTvQFBIGc

πŸ—ΊοΈ (E14) Really smart map (US)​

Maps are great to display geo-location info, and metrics distributed by geo location. And smart maps sometimes make it easy for you, such as per capita analysis!

Video: https://youtu.be/v_JZ7hlpM2M

πŸ§™ (E15) Quick queries and wizard​

Take advantage of quick queries that are recommended by Columns, also use the wizard to get a specific chart quickly, take a look at how they help!

Video: https://youtu.be/1V7hhZd9kVA

βš“ (E16) Annotation, Image, Arrow, Shade,​

Great design tools make storytelling easy, you can not miss them if you are really doing data storytelling: annotations, images, arrows, shades, and many more to come!

Video: https://youtu.be/MkECHyYXUI8

πŸ§‘β€πŸ’» (E17) Personalization​

We know you have your own branding information, such as logo, font, color, and palette. In your profile preferences, you can set these properties that are applied as default settings for all new visual stories you’re going to create!

Video: https://youtu.be/djIbIxL1vXM

Columns support a big variety of ways to share - publish, embed, snapshot link, slack, download, sharing with specific people with access control, and control which version in sharing. And more importantly, everything is live, which means you don’t repeat these process again!

Video: https://youtu.be/oKwsXwxNQIQ

⛓️ (E19) In-place chat​

Collaboration and communication are the main themes Columns want to streamline for our users. As a team, you want to start conversations for any details. In-place chat is your neat tool for that!

Video: https://youtu.be/Tw7OL7nl0vQ

☎️ (E20) Team management​

Manage your team on Columns, and collaborate on data storytelling with your team!

Video: https://youtu.be/qlWBIzO1XpQ

πŸ“ƒ (E21) Pages​

Columns Page is a super lightweight dashboard that allows you to organize your scenarios on one page, you have a lot of options to customize your page and share it.

Video: https://youtu.be/sEzkpr5pl0w

🎒 (E22) Quick Theme​

You may want to get beautiful story in 5 seconds. Quick themes are built-in theme templates that you can quickly select and apply to your story.

Video: https://youtu.be/M38JQZb7k0Ms

For you​

Curious about other scenarios? Make your suggestions to support@columns.ai! 🀝