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
π¦ (E18) Sharing: short link, slack, download, access control, versioningβ
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.
For youβ
Curious about other scenarios? Make your suggestions to support@columns.ai! π€