Data Visualization
Welcome to Digital Alex, where you'll get Actionable Advice for Better Internet Marketing. If you're new, explore my archives and subscribe to my RSS feed.
Web Analytics and Customer Insight | Data Visualization | Competitive Intelligence and Context | A/B & Multivariate Testing | Search Marketing | User Experience | Blogging and Social Media
Data Visualization
A lot of web analytics involves storytelling to convey the insights and actions from the data to a non-technical audience. Transforming the data into meaningful visualizations, often on a dashboard in Excel, can go a long way toward stimulating your audience into action. I mean, we all like pretty pictures, right?
MicroCharts by BonaVista Systems
- This is a quick and easy tool to integrate sparklines, column charts, win/lose charts, area charts and bullet graphs into Excel. Free to try, $50-$150 to buy
- This is a competitor of MicroCharts best known for their Crystal Excelsius software designed to pretty up your spreadsheets. It’s also free to try.
Create bullet graphs (via ExcelUser)
- A bullet graph is an elegant way to show a target (say 25% profit) and chart your progress against that target.
- Quick and easy pivot tables/data exploration
- Exploring data with “timeboxes” that let you quickly zoom in on a time period of interest
- For the social data visualization geeks among us to admire and share their handiwork. It’s great to get ideas!
- Get some inspiration from the web analytics graphs collection over at eSnips.com
Web Analytics and Customer Insight | Data Visualization | Competitive Intelligence and Context | A/B & Multivariate Testing | Search Marketing | User Experience | Blogging and Social Media
