Columns

Data storytelling has become increasingly important in today's data-driven landscape, but creating compelling narratives from complex datasets can be challenging. To help users overcome these challenges, Columns has developed a powerful data storytelling platform that combines sophisticated analytics with intuitive visualization tools. This platform enables users to transform raw data into engaging stories that resonate with their audience, while maintaining the accuracy and relevance of the information. Through advanced features like AI-driven insights and automated scheduling, Columns helps users make informed decisions based on their data, whether they're analyzing marketing performance, tracking business metrics, or uncovering trends in their industry. In this article, we'll explore how Columns helps users turn data into storytelling masterpieces, from connecting to their data sources and creating visualizations to sharing their stories with the world.

Data Storytelling Platform Features

Data storytelling in Columns begins with a clear narrative structure that follows a three-part arc: beginning, middle, and end. The process starts by introducing the context and main question or problem (beginning), followed by presenting the data and providing insights (middle), and concluding with the implications of the data and a call to action (end). To make data relatable, the platform encourages incorporating human elements through stories and examples that illustrate how the data affects real people, giving background information to explain its relevance to the audience, and using techniques to evoke emotions.

The platform supports multiple data sources including Google spreadsheets, CSV/TSV files, and various data warehouses. Users can connect live data from sources like Snowflake, Databricks, or BigQuery, upload data through HTTP connections, or stream data from Kafka. Once connected, users benefit from auto-visual recommendations powered by AI, allowing them to perform multi-dimensional analysis through a drag-and-drop interface.

Visual elements in Columns include charts, infographics, and maps, with options to customize axis ticks, hide/show gridlines, and adjust chart themes. The platform enables users to create professional-grade stories through features like custom themes generated by its Magic Theme feature, smart titles, and detailed graph APIs for developers. Users can schedule visual stories to update automatically, with options ranging from hourly to monthly intervals, and share stories through channels including Slack, email, and public publishing platforms.

Data Integration and Visualization

Data connections in Columns support multiple formats including Google spreadsheets, Microsoft Excel files, and cloud storage uploads for CSV/TSV files. The platform handles data from various sources like Snowflake, Databricks, BigQuery, Kafka, and general HTTP connections, enabling users to perform live data analysis and visualization.

The built-in AI assists users in discovering insights through natural language queries and generates smart title suggestions based on the data analysis. For data transformation, the Columns Pivot Table feature provides one-click functionality to organize data into meaningful metrics. The system supports various visualization types including area, line, and dot charts, while also offering advanced features like auto-visual recommendations and drag-and-drop multi-dimensional analysis.

Additional customization options include detailed chart settings for colors, palettes, backgrounds, fonts, and formats. Result transforms allow users to present data in different storytelling views, and the platform enables users to highlight specific data points for emphasis. Visual storytelling options extend to the creation of annotated charts, infographics, and smart maps, with the ability to incorporate images, arrows, and shading effects for enhanced presentation.

Collaboration and Sharing

Columns streamlines the collaborative process through several key features. Teams can work together on projects directly within the platform, benefiting from real-time updates and simultaneous editing capabilities. The system supports sub-domain setups for team plans, allowing multiple users to work on the same project while maintaining organization and access controls.

The platform integrates seamlessly with popular communication channels, enabling users to start insights discovery directly from Slack messages. This feature allows team members to share and discuss data analytics within their existing workflow, fostering better collaboration and quicker decision-making. Users can publish stories for wider sharing purposes, including presentations, directly from within the Columns editor.

Sharing and Publication

For broader distribution, Columns enables sharing through multiple channels. Stories can be published for public viewing or embedded in websites for wider accessibility. The platform supports direct messaging of stories from Columns to Slack, making it easy to share insights with team members or stakeholders. This comprehensive sharing functionality helps ensure that valuable data insights reach the right people at the right time.

AI and Automation

AI-driven features in Columns help users discover insights more efficiently through various automated processes. Upon connecting a dataset, AI generates smart titles based on the analysis, creating compelling story titles quickly. The system also provides insight summaries, explaining what the data reveals in clear, accessible language.

The platform employs a process called "Magic," which allows users to freeze the AI learning process during story creation. This feature lets users refine and perfect their visual narratives before the AI continues its analysis. Columns incorporates user feedback to improve these AI-driven processes continuously, ensuring the software evolves with user needs.

Columns enhances data storytelling through automated scheduling capabilities that keep visual stories up-to-date. The platform allows users to set update frequencies from hourly to monthly intervals, with detailed instructions available in the documentation. This feature maintains current data accuracy while reducing manual update requirements.

The system supports multiple automation workflows through its graph scheduling feature. From the visual story menu, users can select Schedule or Page options to activate automated updates. The platform handles live data connections and processing efficiently, maintaining performance even with large Google Sheets files.

Users can maintain brand consistency through customizable visual designs, including color schemes and backgrounds. The platform's open-source graph API enables developers to build and host their data stories, with integration options for third-party applications like Notion. This feature allows for greater flexibility in content distribution and management.

The platform's performance metrics demonstrate its effectiveness in diverse professional applications. By combining data analysis with engaging visual storytelling techniques, Columns helps users make proactive decisions based on up-to-date information. Real-time data updates maintain the accuracy of marketing campaign measurements and performance metrics, crucial for corporate agility and responsiveness.

Customization and Design

From basic data analysis to sophisticated visual storytelling, Columns' customization options help users create professional-grade presentations with ease. The platform's color and palette customization allows users to highlight key metrics through contrast colors and adjust opacity for better visibility. Users can add annotations, images, icons, and emojis to enhance their stories, while shapes and resized charts enable detailed visual presentations.

A range of customization options extends to basic chart settings including background, font, and format choices. The platform supports advanced visual transformations through result customization, allowing users to present data in multiple storytelling views. The Columns Pivot Table feature provides one-click functionality for organizing data into meaningful metrics, similar to Excel's pivot table capabilities.

For interactive elements, users can apply smart data markers to highlight specific points of interest. The platform's image integration capabilities enable the addition of logos, icons, and other visual elements to maintain brand consistency. Additional features include arrow and shading options for enhanced chart presentations, with the ability to create annotated charts and smart maps for geographical data visualization.

Sharing and access control features ensure that stories reach the intended audience while maintaining data security. Users can publish presentations for public viewing or embed them in websites using the platform's publishing tools. Communication is streamlined through Slack integration, allowing users to start insights discovery directly from team messages and share stories within their existing workflow.