<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[eyeful - Medium]]></title>
        <description><![CDATA[We visualize data to help businesses make smarter decisions. Get in touch. 👇 https://eyeful.us - Medium]]></description>
        <link>https://medium.com/eyeful?source=rss----c39493e6b6ed---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>eyeful - Medium</title>
            <link>https://medium.com/eyeful?source=rss----c39493e6b6ed---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 17:02:48 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/eyeful" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How to Automate Data-Driven Presentations]]></title>
            <link>https://medium.com/eyeful/how-to-automate-data-driven-presentations-b012c97622c7?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/b012c97622c7</guid>
            <category><![CDATA[automation-tools]]></category>
            <category><![CDATA[powerpoint]]></category>
            <category><![CDATA[presentation-design]]></category>
            <category><![CDATA[data-reporting]]></category>
            <category><![CDATA[google-slides]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Thu, 18 May 2023 02:11:50 GMT</pubDate>
            <atom:updated>2023-06-27T17:28:14.081Z</atom:updated>
            <content:encoded><![CDATA[<h4>Seamlessly update your slides with the latest, most relevant information.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*70KkMbwnAuoYUrgJTE-5dA.jpeg" /></figure><p>Data plays a vital role in presentations; you can’t show benchmarks, trends, or growth without it. Yet the process of adding data to slides often makes it feel more like a burden rather than an asset. Apart from being tedious, these edits can be repetitive — especially for QBRs and other reports that require regular updates.</p><p>These tasks basically amount to manual data entry, and you can ditch them by connecting your presentation to a live data source. It’s possible to have a series of slides that automatically refresh like a <a href="https://medium.com/p/1f1bddceda0e">dashboard</a>.</p><p>On that note, sometimes you can embed a dashboard into a slide (see <a href="https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-install?tabs=share">Microsoft PowerBI and PowerPoint</a> as one example). But while you can take advantage of dashboards and their live connections to data, their <a href="https://medium.com/p/4f9e1584b9b9">self-service</a> nature isn’t well-suited to presentations. Dashboards don’t relate insights in plain English, nor do they put numbers in context. That’s a job for presentations.</p><p>Your application will mainly determine how to connect your presentation to a live data source. Certain methods work for <a href="https://www.microsoft.com/en-us/microsoft-365/powerpoint">PowerPoint</a>, whereas others work for <a href="https://www.google.com/slides/about/">Google Slides</a>. Plus, you can exchange either of these applications for a product with built-in data automation. Read on to find the right solution for you.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>METHODS FOR POWERPOINT</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*C8cQmE9kZayWNliQ8gfOfQ.png" /></figure><p><a href="http://www.thielsch.org/download/paper/Thielsch_Perabo_2012.pdf">With a market share reported to be as high as 95%</a>, Microsoft PowerPoint has been the leading presentation software for over 20 years. It’s typical for users to create tables and charts in Microsoft Excel and add them to PowerPoint. This tactic alone may be enough for some people, however you can step up your game with special settings and add-ins.</p><p><a href="https://www.microsoft.com/en-us/microsoft-365/p/excel/"><strong>Microsoft Excel</strong></a>: Whenever you copy an item from Excel and paste it into PowerPoint, it’s important to insert it as a <a href="https://www.howtogeek.com/358832/how-to-link-or-embed-an-excel-worksheet-in-a-powerpoint-presentation/">Microsoft Excel Worksheet Object</a>. This format keeps the files in sync so you only have to update the spreadsheet with new results. The changes will reflect on your existing charts and tables, it won’t be necessary to replace them. You can automate things even further with <a href="https://supermetrics.com/products/excel">Supermetrics</a> and <a href="https://www.analyticsedge.com/">Analytics Edge</a>, two add-ins that can schedule data imports into Excel.</p><p><a href="https://www.think-cell.com/en"><strong>think-cell</strong></a>: Are you unsatisfied with Excel and PowerPoint’s available charts? <a href="https://www.think-cell.com/">think-cell</a> may be a great fit for you. This add-in can elevate your presentations with better graphics and styling. All think-cell users have the flexibility to <a href="https://slidescience.co/update-chart-dynamically-excel/#:~:text=Click%20and%20hold%20the%20left,in%20a%20Think%2DCell%20chart.">link and visualize data from their Excel files</a>, and Tableau customers have the bonus option to <a href="https://www.think-cell.com/en/resources/manual/tableaudata#chap_tableaudata">tap into data from their workbooks</a>.</p><p><a href="https://www.presentationpoint.com/software/datapoint/"><strong>DataPoint</strong></a><strong>:</strong> This add-in is a tried-and-true mechanism for automating reports in PowerPoint. <a href="https://www.presentationpoint.com/software/datapoint/">DataPoint</a> connects the application to an array of data sources, allowing you to forgo the workarounds in Excel (or Tableau). On top of embedding data straight into slides, it can generate presentations in bulk with a <a href="https://www.presentationpoint.com/blog/mail-merged-powerpoint-presentations-4-types/">mail merge</a> tool</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><h4><strong>METHODS FOR GOOGLE SLIDES</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QEUG0_5ENoLPmIUg4StrBQ.png" /></figure><p>Google Slides is a free, cloud-based alternative to Microsoft PowerPoint. Perhaps not surprisingly, the service can load data from Google Sheets and Google BigQuery. That being said, external platforms aren’t off limits either — users can set up other integrations using third-party add-ons.</p><p><a href="https://www.google.com/sheets/about/"><strong>Google Sheets</strong></a><strong>:</strong> Anyone can embed their tables and charts from <a href="https://www.google.com/sheets/about/">Google Sheets</a> into Google Slides. The <a href="https://support.google.com/docs/answer/7009814">process</a> just takes a few clicks, and unlike Excel and PowerPoint, the files are linked from the start. Consider introducing more automation with <a href="https://supermetrics.com/products/google-sheets">Supermetrics</a> <a href="https://medium.com/eyeful/5-alternatives-to-supermetrics-for-google-sheets-e77835581fdd">or one of its competitors</a>. These add-ons can schedule data imports into your spreadsheets and eliminate your manual updates altogether.</p><p><a href="https://cloud.google.com/bigquery"><strong>Google BigQuery</strong></a>: If your organization uses <a href="https://cloud.google.com/bigquery">Google BigQuery</a> to warehouse your data, the following method may come in handy. <a href="https://www.youtube.com/watch?v=ZpCQXqiq6P0&amp;t=17s">Thanks to Google Apps Scripts, you can configure Google Slides to display results from Google BigQuery</a>. This technique involves a lot of programming and templatizing, but when done properly, it can crank out new reports at lightning speed.</p><p><a href="https://vizzlo.com/"><strong>Vizzlo</strong></a><strong>:</strong> With <a href="https://vizzlo.com/">Vizzlo</a>, you can create beautiful, on-brand charts and infographics for Google Slides. Use their online editor to visualize data from Google Sheets and insert live embeds into your presentations. Vizzlo is also available for PowerPoint as a clean and modern alternative to think-cell.</p><p><a href="https://sparrowcharts.com/"><strong>Sparrow</strong></a> &amp; <a href="https://dokin.co/"><strong>Dokin</strong></a>: These two add-ons can import live sales data into Google Slides without a “middleman” spreadsheet. Given that <a href="https://www.sparrowcharts.com/">Sparrow</a> and <a href="https://www.dokin.co/">Dokin</a> have similar functionality, the decision to adopt which one will ultimately come down to your integration requirements. Sparrow connects with marketing platforms, while Dokin connects with CRM or financial software.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><h4><strong>OTHER METHODS</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pOCa8hBts2qOTqkUjtsaYA.png" /></figure><p>Both Microsoft PowerPoint and Google Slides tend to be the go-to presentation solutions since they come with major software suites. But despite their convenience, they largely rely on extensions to automate content. As a result, their configurations are more prone to breaking — and when they do, they can be harder to restore. So if you have heavy automation needs, you may be better off using a specialized application with native capabilities.</p><p><a href="https://evidence.dev/"><strong>Evidence</strong></a>: Are you a software developer or analytics engineer? <a href="https://evidence.dev/">Evidence</a> may be the perfect match for you, especially if you’re willing to drop the traditional 16x9 slides. The open-source platform takes a “Business Intelligence as code” approach to report creation, enabling you to script data-driven summaries with SQL and markdown. You can build reusable components and templates that work with variables and loops. All of your development is backed up with version control to ensure stable and consistent updates.</p><p><a href="https://www.rollstack.io/"><strong>Rollstack</strong></a>: Nothing takes on the Sisyphean chore of updating presentations quite like <a href="https://rollstack.io/">Rollstack</a>; this application is designed to keep data current in the same location where it’s presented. And because it has advanced automation features, it requires absolutely no engineering expertise to use. Rollstack can embed and sync data from a wide range sources including spreadsheets, BI tools, SaaS products, and data warehouses. It integrates with Microsoft PowerPoint and Google Slides, along with Microsoft Word and Google Docs.</p><p><a href="https://matik.io/"><strong>Matik</strong></a><strong>:</strong> If you’re ready for an all-in-one enterprise platform, look no further than <a href="https://matik.io/">Matik</a>. The product provides a simple yet sophisticated framework for creating and automating data-driven content. Matik supports both PowerPoint and Google Slides as output formats, making it possible to continue editing files outside of the platform. Furthermore, it’s optimized to issue presentations at scale. Users can easily adapt their material for different groups and send out emails with personalized attachments.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><h4><strong>LET YOUR DATA DO THE TALKING</strong></h4><p>Besides automating updates, you can utilize a live data connection to blend numbers into your commentary. This means you’re not limited to charts or scorecards, you can share data in written format as well.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bAbR__4eapSzdf0bRx_Z_w.png" /></figure><p>Check out the below slide template from Matik. All of the text in double curly brackets {{ }} are variables for specific data points. Upon exporting the presentation, these variables will display the relevant results for each recipient of the report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kZj1BY8nUkzHBfmaZcf2vQ.png" /></figure><p>Notice how the notes beneath the purple values are also coded with variables; they’re in place to add helpful context and elaborate on the presentation’s findings. These statements don’t merely cite data, they directly address the reader and set a conversational tone.</p><p>Not only can you verbalize results, you can mention reader details like their name and location. This is particularly useful for client-facing reports such as proposals and account reviews.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><h4><strong>CLOSING THOUGHTS</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OjPN27KDsRP6zw6ig_Ix_A.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@alexlitvin?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Alex Litvin</a> on <a href="https://unsplash.com/@eyeful/likes?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Automation can’t succeed without a lot of upfront planning. Moreover, you shouldn’t expect it to do everything for you. While it can save a lot of time with updating results, there’s no way to automate a thoughtful analysis. Any presentation you create must have tailored observations. Your readers won’t be persuaded or fooled by generic messaging, even if it references their own data.</p><p>Although automation may take a little extra effort to implement, it can pay off in the long term. In addition to boosting your team’s productivity, it can standardize your presentation structure and layout. Automation has the potential to transform your presentations for the better and make a lasting impression on internal and external audiences alike.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=presentationAutomations&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a data and analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b012c97622c7" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/how-to-automate-data-driven-presentations-b012c97622c7">How to Automate Data-Driven Presentations</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Alternatives to Supermetrics for Google Sheets]]></title>
            <link>https://medium.com/eyeful/5-alternatives-to-supermetrics-for-google-sheets-e77835581fdd?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/e77835581fdd</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[supermetrics-alternative]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-analytics-tools]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Thu, 04 May 2023 05:09:34 GMT</pubDate>
            <atom:updated>2023-05-18T01:25:23.655Z</atom:updated>
            <content:encoded><![CDATA[<h4>Check out these substitutes for the popular data extraction plugin.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1DPDCTt-LRKIriGUyIA4qQ.jpeg" /></figure><p>Before <a href="https://supermetrics.com/products/google-sheets?utm_source=google&amp;utm_medium=cpc&amp;utm_campaign=Global_Brand_GS_Marketplace&amp;utm_adgroup=brand-googlesheets&amp;utm_category=search-brand&amp;utm_term=supermetrics%20for%20google%20sheets&amp;location=&amp;google_ads_redirect=true&amp;gclid=Cj0KCQjw6cKiBhD5ARIsAKXUdyb8DUbLZNZkk5h1TuoKVwpxwm9iWsuix4wORrnB7uy54O2ub1ytiWQaArMUEALw_wcB"><strong>Supermetrics for Google Sheets</strong></a>, most users had no choice but to manually import entire datasets into their spreadsheets. If they ever had to update their results with new information, they were forced to repeat the process all over again.</p><p>Apart from taking extra time and effort, manual work is more prone to errors. And while some <a href="https://www.google.com/script/start/">scripts</a> can automate these tasks and directly connect with reporting APIs, they require technical knowledge to implement. Enter <strong>Supermetrics</strong>.</p><p>First introduced as a data extraction add-on back in 2013, <strong>Supermetrics</strong> enabled anyone to make complex API calls through a user-friendly interface. Plus, it gave people the ability to schedule data refreshes down to the day, time, and frequency.</p><p><strong>Supermetrics</strong> remains the leading solution for importing data into Google Sheets. But today, there are many alternatives that appeal to different budgets and connection needs. Read on for our recommendations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>1: <a href="https://dataslayer.ai/">DATASLAYER</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mTvlMGhdTe2RO7CKV7_Mmg.png" /></figure><p>In terms of appearance and functionality, <a href="https://dataslayer.ai/"><strong>Dataslayer</strong></a> is the closest lookalike to <strong>Supermetrics</strong>. Although its <a href="https://dataslayer.ai/connectors-dataslayer">integration library</a> is not as extensive, they already support key platforms and routinely release new connections. Moreover, their payment plans are highly flexible.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>2: <a href="https://kpibees.com/">KPIBEES</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aFyIpbdt31zy_JgtRRdCxA.png" /></figure><p>With a similar user interface and capabilities, <a href="https://kpibees.com/"><strong>KPIBees</strong></a> is another pared down substitute for <strong>Supermetrics</strong>. The service currently has a free tier which makes it a solid choice for users with light reporting needs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>3: <a href="https://apipheny.io/">APIPHENY</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vY_DtaFDqePg47oPIraTVg.png" /></figure><p><a href="https://apipheny.io/"><strong>Apipheny</strong></a> is a cost-effective option for anyone who’s willing to spend a little extra time fine-tuning their API calls. It certainly helps to have some developmental expertise, however the service provides extensive documentation to guide users.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>4: <a href="https://mixedanalytics.com/">MIXED ANALYTICS</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*55yW3sSuZpmrWZkcKwuiUQ.png" /></figure><p><a href="https://mixedanalytics.com/"><strong>Mixed Analytics</strong></a> touts connections for <a href="https://mixedanalytics.com/integrations/">hundreds of data sources</a>, making it a robust alternative to <strong>Supermetrics</strong>. Along with its broad range of support, it has the special ability to handle paginated APIs. Like <strong>KPIBees</strong>, it also offers a free tier.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>5: <a href="https://coefficient.io/">COEFFICIENT</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8whgEzsERsmdrqh7tCyr_w.png" /></figure><p>Despite its limited <a href="https://coefficient.io/integrations">integration library</a>, <a href="https://coefficient.io/"><strong>Coefficient</strong></a> has more built-in collaboration features compared to <strong>Supermetrics</strong>. For instance, users can trigger alerts over email or Slack whenever their results meet certain thresholds.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><h4>BONUS ADD-ONS</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0tQkUhWvIf85KOKwdTgdDg.png" /></figure><p>If you only need to integrate with a single data source, look into whether or not the product comes with its own Google Sheets add-on. This is the case for <a href="https://workspace.google.com/u/0/marketplace/app/google_analytics/477988381226">Google Analytics</a>, <a href="https://support.google.com/docs/answer/9702507?hl=en">Google Big Query</a>, and <a href="https://workspace.google.com/u/0/marketplace/app/salesforce_connector/857627895310">Salesforce</a> — all of which happen to have free extensions that connect to Google Sheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><h4>THINGS TO CONSIDER</h4><p>Make sure you choose the right tool (and plan) by taking full advantage of the trial period and considering for the following things:</p><ul><li>Does the service offer monthly or annual payment terms? Which one do you prefer?</li><li>Will your plan cover all of the necessary data integrations, account connections, and update frequencies?</li><li>If the add-on supports your data integration, can it retrieve all of the columns you need?</li><li>Are your API calls manageable? If they fail, try applying filters that limit the volume of data you’re requesting.</li></ul><p>None of these add-ons are inherently superior to one or the other. Just like with any product, the best fit for you will always depend on your specific criteria.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*7nS0TwUQV6lIUJBnvVAhMQ.png" /></figure><h4>LOOKING AHEAD</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wsc0yLf7ZCh6c4NaNA9k8Q.jpeg" /></figure><p>Users typically adopt a product like <strong>Supermetrics</strong> because they’re not ready to use an <a href="https://medium.com/eyeful/do-you-need-an-etl-tool-f963a317cb9a">ELT</a> platform or a data warehouse. But if they ever do level up their game, don’t expect them to drop spreadsheets altogether.</p><p>Nothing beats getting “hands on’’ with data in a spreadsheet; the format helps users of all kinds organize information and run calculations at will. Spreadsheets are so useful, many analysts prefer working with them over querying a data warehouse.</p><p>And while tools like <strong>Supermetrics</strong> can always play a role in a Modern Data Stack, they’re merely add-ons. Eventually, teams may need to upgrade to a solution like <a href="https://www.mozartdata.com/"><strong>Mozart Data</strong></a> or <a href="https://www.funnel.io/"><strong>Funnel</strong></a>. In addition to having advanced ELT and data storage capabilities, both of these products can export results to Google Sheets.</p><p>Nonetheless, all of these options provide a convenient method for syncing spreadsheets with live data sources.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=Supermetrics&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a data and analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e77835581fdd" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/5-alternatives-to-supermetrics-for-google-sheets-e77835581fdd">5 Alternatives to Supermetrics for Google Sheets</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Do You Need an ETL Tool?]]></title>
            <link>https://medium.com/eyeful/do-you-need-an-etl-tool-f963a317cb9a?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/f963a317cb9a</guid>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Mon, 13 Apr 2020 12:21:01 GMT</pubDate>
            <atom:updated>2023-05-04T04:49:58.433Z</atom:updated>
            <content:encoded><![CDATA[<h4>ETL can be a game changer for your data preparation. Just be certain you’re ready to make the investment.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ktvyF0cs9094uJ2_WE3zpQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@scottwebb?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Scott Webb</a> on <a href="https://unsplash.com/s/photos/network?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Analysts can easily spend more time on data preparation than actual data analysis. If they want to get an overall view of how their business is doing, they usually have to collect and combine data from several sources. It’s a slow and laborious task when it’s done manually, and the resulting reports are likely to have mistakes. Plus, analysts can’t get any new information unless they redo everything from scratch.</p><p>ETL is a technology that automatically routes various streams of data into a one place for analysis. Simply put, it’s more efficient and reliable than manual data preparation. It can also give businesses a data-driven growth spurt, enabling their analysts to focus more on finding insights rather than filling out spreadsheets.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>WHAT IS ETL?</h4><p>ETL is an acronym for Extract, Transform, and Load. Each term represents a different phase of the ETL workflow.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qqHJMx5v1HMP05EV1x6IaQ.png" /><figcaption>A simple breakdown of the ETL workflow</figcaption></figure><p>In the first phase, data is <strong>extracted</strong> from a source. Then it gets <strong>transformed</strong> through server-side scripting that may add extra fields or remove irrelevant details. Lastly, it gets <strong>loaded</strong> into a central location — ideally a cloud-based data warehouse.</p><p>Unlike a standard database, a data warehouse is optimized for querying. Plus, it can directly connect to a BI platform (e.g. <a href="https://www.tableau.com/">Tableau</a>, <a href="https://datastudio.google.com/">Google Data Studio</a>, <a href="https://www.klipfolio.com/">Klipfolio</a>, <a href="https://www.zoho.com/analytics/">Zoho Analytics</a>, <a href="https://looker.com/">Looker</a>, <a href="https://www.sisense.com/">Sisense</a>, <a href="https://www.yellowfinbi.com/">Yellowfin</a>, <a href="https://www.domo.com/?pid=cvlev">Domo</a>) where users can share and <a href="https://medium.com/eyeful/paint-by-numbers-how-to-color-your-data-visualizations-79d38b024ea2">visualize</a> the information in <a href="https://medium.com/eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboards</a>.</p><p>An ETL tool can extract, transform, and load data from multiple sources at once. Moreover, it runs periodically to keep your reports up to date.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>WHY USE AN ETL TOOL?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*rqBFnIC2CWZ0Tv0d6qaO6w.png" /><figcaption>Photo by <a href="https://unsplash.com/@marcobian?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Marco Bianchetti</a> on <a href="https://unsplash.com/s/photos/tunnel-fast?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>ETL takes the manual work out of data preparation, and it’s especially useful for enterprises who want to establish a <a href="https://medium.com/eyeful/5-mistakes-to-avoid-in-your-bi-44f1b89b8681">single source of truth</a>. Since a key feature of ETL is information consolidation, it can feed into a main site where everyone can get answers to their business questions. Otherwise, different departments may get their data from unvetted outlets.</p><p>In addition to centralizing your reporting, an ETL tool can make your data conform to your own business logic. For instance, a retailer may use a specific formula to track their profits. An ETL tool can automate this calculation, allowing them to look at their total profits alongside their total sales. It can also convert fields with formal names like “stock_keeping_unit_id” into something more intelligible like “Product Number.”</p><p>Data in its original format isn’t always optimal for analysis, and ETL can apply the changes that turn it into actionable information.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>A FEW TYPES OF ETL TOOLS</h4><p>A system will surely break down and produce errors if it’s not set up properly. Some organizations may set out to build their own ETL pipeline, but in most cases, everyone’s better off working with a specialist. Fortunately, any business can find a good match; the market is full of potential partners at different price points and capabilities.</p><p>Two leading providers in the ETL space are <a href="https://www.informatica.com/">Informatica</a> and <a href="https://www.talend.com/">Talend</a>. Both services were originally developed to populate on-premise data warehouses, but they now provide support for cloud-based infrastructures. The technology behind these ETL tools was pioneered by giants like IBM and Microsoft, and they each have large customer bases considering they’ve been around for so long.</p><p>Informatica and Talend offer high-performing ETL tools, but as incumbent enterprise solutions, they can come with expensive fees and a steep learning curve. Therefore, they’re typically out of scope for smaller businesses who have limited funds or data engineering expertise.</p><p>Yet with the rise of cloud computing and big data, new providers are lowering the barrier of entry to ETL adoption. One such example is <a href="https://www.alooma.com/">Alooma</a>, Google’s cloud-based data pipeline platform. It’s a scaleable ETL tool with the ability to cater to a wide range of companies — from startups to Fortune 500 corporations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VRN-AGFxqX60857_qDuTnw.png" /><figcaption>Photo by <a href="https://unsplash.com/@jakubkriz?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Jakub Kriz</a> on <a href="https://unsplash.com/s/photos/clouds?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>A primary benefit of ETL is data aggregation, meaning that it can merge similar data points from different sources. This is particularly convenient when it comes to advertising analytics, given that marketers always have to analyze campaign performance across several channels (e.g. Google Ads, Bing, Facebook Ads, Instagram, and more).</p><p><a href="https://improvado.io/">Improvado</a> and <a href="https://funnel.io/">Funnel</a> are specialized ETL tools for advertising data, so marketers can easily monitor their spending and conversion activity in a single report. Without an ETL tool, they’d have to pull data from each outlet and map every metric together by hand. And of course this manual work makes it nearly impossible for anyone to act quickly and optimize campaigns.</p><p>Products like <a href="https://airbyte.com/">Airbyte</a>, <a href="https://hevodata.com/">Hevo</a>, <a href="https://fivetran.com/">Fivetran</a>, <a href="https://www.xplenty.com/">Xplenty</a>, and <a href="https://www.dataddo.com/">Dataddo</a> are some relatively recent alternatives to ETL tools. All of them are cloud-based applications with pre-built connectors to many popular data sources. Known as ELT tools, they simply extract and load data into a data warehouse. The transformation phase comes last and users handle it themselves; after their data is imported, they can modify the information using custom SQL in their data warehouse or BI platform.</p><p>ELT tools are generally more affordable than their ETL counterparts, and they can have a shorter implementation. That being said, they tend to require more oversight from analysts because their workflow isn’t fully automated.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>THINGS TO CONSIDER</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KlQ6_m5r-8qFLcv07MzLdQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@cadop?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Mathew Schwartz</a> on <a href="https://unsplash.com/s/photos/data?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>It’s important to remember that that an ETL tool is only one component of a data stack. It doesn’t store information like a data warehouse and it doesn’t create dashboards like a BI platform. Nonetheless, it plays a critical role giving context to your data and making it accessible.</p><p>Like any data product, the effectiveness of an ETL tool ultimately depends on how well it’s configured and maintained. And before you can even transform your data according to your business logic, you have to define it first. Don’t begin working with an ETL tool until you have all the developmental and financial resources you need.</p><p>As you gain more data sources and expand your business logic, your organization becomes a better candidate for adopting an ETL tool. Thankfully, there’s no shortage of options to choose from when the time is right. Just confirm that your final choice is compatible with all of data sources as well as your budget.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f963a317cb9a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/do-you-need-an-etl-tool-f963a317cb9a">Do You Need an ETL Tool?</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Eyeful LLC Is a Zoho Analytics Partner! ]]></title>
            <link>https://medium.com/eyeful/eyeful-llc-is-a-zoho-analytics-partner-2b84d0c9afe9?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/2b84d0c9afe9</guid>
            <category><![CDATA[zoho-integrations]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[eyeful-announcement]]></category>
            <category><![CDATA[zoho]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Fri, 03 Apr 2020 20:31:03 GMT</pubDate>
            <atom:updated>2020-04-13T13:43:19.497Z</atom:updated>
            <content:encoded><![CDATA[<h3>Eyeful Is a Zoho Analytics Partner! 🎉</h3><h4><em>We’re joining forces with the SaaS pioneer to help businesses get more value out of their data.</em></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*pHdw3QFpkcdv7PzRA5nUsw.png" /><figcaption>Eyeful now provides consulting and implementation services for Zoho Analytics</figcaption></figure><p>For decades, the online office suite Zoho has powered businesses with its word processing, CRM, web conferencing, and project management apps. Already a leader in productivity tools, the software giant has grown aggressively in the <a href="https://medium.com/eyeful/5-mistakes-to-avoid-in-your-bi-44f1b89b8681">business intelligence</a> space since adding <a href="https://www.zoho.com/analytics/">Zoho Analytics</a> to its line of products.</p><p>Zoho Analytics is a cloud-based reporting platform that can sync with an array of APIs, databases, and data warehouses. It can transform raw data into <a href="https://medium.com/eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboards</a> and enable users to easily analyze their activity. With Zoho Analytics, any organization can uncover sharper insights faster.</p><p>Not only does Zoho Analytics support a wide range of data connections and <a href="https://medium.com/eyeful/a-cheat-sheet-for-choosing-the-right-data-visualizations-8f63a6242f1e">customizable charts</a>, but it also offers competitive <a href="https://medium.com/eyeful/think-ahead-boost-your-bi-with-ai-d8df8f64851f">AI features</a>. “Ask Zia” is the platform’s chatbot that can interact with users and answer specific questions about their data. It even has a powerful forecasting engine that can project trends and predict outcomes.</p><p>Eyeful is pleased to announce that we are now a Zoho Authorized Partner who can customize, integrate, and implement Zoho Analytics for any enterprise.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/426/1*-KoJk5uaFs52O-pl-YTrBQ.png" /></figure><p>We can optimize Zoho Analytics for your specific tracking needs, design impressive dashboards, and plan a successful roll out of the product at your organization. Additionally, we can stay on board to handle any ongoing maintenance or train new users.</p><p>With Eyeful, you’ll get the highest return out of your Zoho Analytics investment and pave the way for data-driven growth.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2b84d0c9afe9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/eyeful-llc-is-a-zoho-analytics-partner-2b84d0c9afe9">Eyeful LLC Is a Zoho Analytics Partner! 🎉</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Dashboards for Tracking COVID-19]]></title>
            <link>https://medium.com/eyeful/5-dashboards-for-tracking-covid-19-1d6bf2891724?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/1d6bf2891724</guid>
            <category><![CDATA[disease-prevention]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[covid19]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[coronavirus]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Fri, 20 Mar 2020 02:19:54 GMT</pubDate>
            <atom:updated>2020-04-13T17:16:50.664Z</atom:updated>
            <content:encoded><![CDATA[<h4>You can monitor the global pandemic using these easy to access reports of vetted data.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*e234SATF5h8IIu9AtQObCQ.jpeg" /><figcaption>A close-up of the <a href="https://coronavirus.jhu.edu/map.html">John Hopkins University’s <strong>Coronavirus Resource Center</strong></a><strong> </strong>| Photo by <a href="https://unsplash.com/@martinsanchez?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Martin Sanchez</a> on <a href="https://unsplash.com/collections/749927/my-first-collection/53b1bd5966969569f089421916972107?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>COVID-19 is a novel virus — in other words, it hasn’t been seen before. <a href="https://www.cdc.gov/coronavirus/2019-ncov/faq.html#anchor_1584386215012">The disease was first identified in 2019 when it caused an outbreak of respiratory illness in Wuhan, China.</a> As a result, scientists are still learning about its transmissibility, severity, and other basic traits. A vaccine is not yet available.</p><p>One certainty about COVID-19 is that it can spread person-to-person, and now it’s reached pandemic proportions. Cases have been reported in every continent <a href="https://www.cnn.com/2020/02/25/asia/novel-coronavirus-covid-update-us-soldier-intl-hnk/index.html">except for Antartica</a>. Most patients recover from the disease, but it can be fatal. <a href="https://www.cdc.gov/coronavirus/2019-ncov/cases-updates/summary.html#risk-assessment">Increased age and chronic medical conditions like Heart Disease, Diabetes, and Lung Disease are some risk factors for the virus.</a></p><p>The first step anyone can take towards containing a virus is to remain informed and understand its scale, and <a href="https://medium.com/eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboards</a> can help people do both.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4><strong>COVID-19 BY THE NUMBERS</strong></h4><p>The following <a href="https://medium.com/eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboards</a> track the presence of COVID-19 in different regions; all of them present an ongoing tally of deaths and recoveries. Their data is sourced from institutions like the <a href="https://www.who.int/">World Health Organization (WHO)</a>, the <a href="https://www.cdc.gov/">US Centers for Disease Control and Prevention (CDC)</a>, the <a href="https://www.ecdc.europa.eu/en">European Centre for Disease Prevention and Control (ECDC)</a>, and the <a href="http://www.nhc.gov.cn/xcs/yqtb/list_gzbd.shtml">National Health Commission of the People’s Republic of China (NHC)</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4><strong>1. </strong><a href="https://ncov2019.live/"><strong>nCoV2019.live</strong></a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wxbSAscDFXhUhMi-Jxax3g.png" /></figure><p>Avi Schiffmann, a 17-year-old high school student from Seattle, WA, released this website in late December 2019. At the time, there were less than 1,000 reported cases of COVID-19 and most were confined to Wuhan. He maintains that <a href="http://ncov2019.live/"><strong>nCoV2019.live</strong></a> has <a href="https://www.youtube.com/watch?v=AXFm2u4EHrs">reached over 35 million viewers to date</a>. Schiffmann’s dashboard features several tables with basic figures about the disease.</p><ul><li><strong>Author:</strong> Avi Schiffmann, with engineering support from <a href="https://ko-fi.com/jensennn">Jensen</a></li><li><strong>Data Sources:</strong> <a href="https://www.who.int/">WHO</a>, <a href="https://www.cdc.gov/">CDC</a>, and <a href="https://bnonews.com/index.php/2020/01/the-latest-coronavirus-cases/">BNO News</a></li><li><strong>Update Frequency:</strong> Updates daily, data refreshes around midnight EST</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4><strong>2. </strong><a href="https://www.trackcorona.live/"><strong>TrackCorona</strong></a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dHN_WCYDFxJKPm_911oumg.png" /></figure><p><a href="https://www.virginia.edu/">University of Virginia</a> students James Yun and Soukarya Ghosh launched <a href="https://www.trackcorona.live/">TrackCorona</a> in February 2020 as a personal project. Now, they average <a href="https://news.virginia.edu/content/student-coronavirus-tracking-website-tops-nearly-14-million-views-193-countries">more than 40 thousand viewers per day</a>. The site’s homepage provides high level stats about the spread of the virus, and users have the option to browse additional data visualizations.</p><ul><li><strong>Authors:</strong> James Yun and Soukarya Ghosh</li><li><strong>Data Sources:</strong> <a href="https://www.who.int/emergencies/diseases/novel-coronavirus-2019/">WHO</a>, <a href="https://www.cdc.gov/coronavirus/2019-ncov/index.html">CDC</a>, <a href="https://www.ecdc.europa.eu/sites/default/files/documents/Risk-assessment-pneumonia-Wuhan-China-22-Jan-2020.pdf">ECDC</a>, <a href="https://ncov.dxy.cn/ncovh5/view/pneumonia">DXY</a>, <a href="https://covid19japan.com/">COVID19Japan</a>, <a href="https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6">JHU</a>, and <a href="https://en.wikipedia.org/wiki/2019%E2%80%9320_coronavirus_pandemic">Wikipedia</a></li><li><strong>Update Frequency:</strong> Almost real time, the website displays a timestamp for the last data refresh</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4><strong>3. </strong><a href="https://coronavirus.jhu.edu/map.html"><strong>Coronavirus Resource Center</strong></a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LqGuKnnUG9Rrvc-XM0xIYg.png" /></figure><p>The <a href="https://coronavirus.jhu.edu/map.html">Coronavirus Resource Center</a> was a collaboration between Lauren Gardner, a civil and systems engineering professor at <a href="https://www.jhu.edu/">Johns Hopkins University</a>, and her graduate student, Ensheng Dong. The pair wanted to track the pandemic, and in the process, they created a user-friendly tool that can be used by both health experts and laypersons alike.</p><ul><li><strong>Organization:</strong> <a href="https://www.hopkinsmedicine.org/som/">The Johns Hopkins University School of Medicine</a></li><li><strong>Authors:</strong> <a href="https://engineering.jhu.edu/case/faculty/lauren-gardner/">Lauren Gardner</a> and Ensheng Dong</li><li><strong>Data Sources:</strong> <a href="https://www.who.int/emergencies/diseases/novel-coronavirus-2019/situation-reports">WHO</a>, <a href="https://www.cdc.gov/coronavirus/2019-ncov/index.html">CDC</a>, <a href="https://www.ecdc.europa.eu/en/geographical-distribution-2019-ncov-cases">ECDC</a>, <a href="http://www.nhc.gov.cn/xcs/yqtb/list_gzbd.shtml">NHC</a>, <a href="https://ncov.dxy.cn/ncovh5/view/pneumonia?scene=2&amp;clicktime=1579582238&amp;enterid=1579582238&amp;from=singlemessage&amp;isappinstalled=0">DXY</a>, media reports, and regional health departments</li><li><strong>Update Frequency:</strong> Almost real time, the website displays a timestamp for the last data refresh</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4><strong>4. </strong><a href="https://nssac.bii.virginia.edu/covid-19/dashboard/"><strong>COVID-19 Surveillance Dashboard</strong></a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wqqt_v602gKGAaYPuKsCHw.png" /></figure><p>Like <a href="https://www.trackcorona.live/">TrackCorona</a>, the <a href="https://nssac.bii.virginia.edu/covid-19/dashboard/">COVID-19 Surveillance Dashboard</a> is another interactive report from the <a href="https://www.virginia.edu/">University of Virginia</a>. Their <a href="https://nssac.github.io/covid-19/dashboard/">Biocomplexity Institute</a> curates all of the data behind this dashboard, so viewers can rest assured they’re analyzing information from credited researchers. Interestingly, this dashboard offers a date filter which allows people to see historical snapshots of the disease’s spread.</p><ul><li><strong>Organization:</strong> <a href="https://biocomplexity.virginia.edu/">University of Virginia Biocomplexity Institute and Initiative</a></li><li><strong>Data Sources:</strong> <a href="https://www.who.int/emergencies/diseases/novel-coronavirus-2019/situation-reports/">WHO</a>, <a href="https://www.cdc.gov/coronavirus/2019-ncov/index.html">CDC</a>, <a href="https://www.ecdc.europa.eu/en/geographical-distribution-2019-ncov-cases">ECDC</a>, <a href="http://www.nhc.gov.cn/yjb/new_index.shtml">NHC</a>, <a href="https://3g.dxy.cn/newh5/view/pneumonia">DXY</a><strong>, </strong><a href="https://www.1point3acres.com/">1point3acres</a><strong>,</strong> <a href="https://news.qq.com/zt2020/page/feiyan.htm">QQ</a>, <a href="https://github.com/CSSEGISandData/COVID-19">JHU CSSE</a>, and <a href="https://www.adci.com/adc-worldmap/">ADCi</a></li><li><strong>Update Frequency:</strong> Unspecified</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4><strong>5. </strong><a href="https://bing.com/covid"><strong>COVID-19 Tracker</strong></a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0WOlPX6krYCmLAj_0SNd_Q.png" /></figure><p>In March 2019, Microsoft unveiled the <a href="https://bing.com/covid">COVID-19 Tracker</a> on <a href="https://www.bing.com/">Bing</a>. This light-weight dashboard is responsive across mobile and desktop, and viewers can tap into specific regions to check their latest COVID-19 news.</p><ul><li><strong>Organization:</strong> <a href="https://www.microsoft.com/en-us/">Microsoft</a></li><li><strong>Data Sources:</strong> <a href="https://www.who.int/emergencies/diseases/novel-coronavirus-2019/situation-reports/">WHO</a>, <a href="https://www.cdc.gov/coronavirus/2019-ncov/index.html">CDC</a>, and <a href="https://www.ecdc.europa.eu/en/geographical-distribution-2019-ncov-cases">ECDC</a></li><li><strong>Update Frequency:</strong> Unspecified</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4>Additional Resources</h4><p>In the United States, local health agencies in <a href="https://www.nj.gov/health/cd/topics/covid2019_dashboard.shtml">New Jersey</a>, <a href="http://www.vdh.virginia.gov/coronavirus/">Virginia</a>, <a href="https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429">Florida</a>, and <a href="http://www.ldh.la.gov/coronavirus/">Louisiana</a> are also sharing dashboards that monitor the pandemic in their areas. All of them include breakdowns by their counties and major cities.</p><p><a href="https://www.knowi.com/">Knowi</a>, an augmented analytics platform based in Oakland, CA, recently launched a <a href="https://www.knowi.com/coronavirus-dashboards/">COVID-19 Data Hub</a>. This destination features a wide assortment of dashboards that monitor different aspects of the COVID-19 spread — from regional testing activity to how well each country is containing the disease and flattening the curve.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*LOoBjln4CB1OPTuj_lZkJw.png" /></figure><h4><strong>FLATTEN THE CURVE</strong></h4><p>As people seek more information about COVID-19, they increasingly turn to data in its various forms.</p><p>While dashboards track the spread of COVID-19, a widely shared data visualization demonstrates how to slow its progression. The “<a href="https://www.fastcompany.com/90476143/the-story-behind-flatten-the-curve-the-defining-chart-of-the-coronavirus?fbclid=IwAR1CrKbvtDLv1gz2rdSIMHlnwSutKaQTS_jDjHdzIfkx32KRS40fiaapaV4">Flatten the Curve</a>” chart compares 2 lines — one where the public takes protective measures like <a href="https://www.hopkinsmedicine.org/health/conditions-and-diseases/coronavirus/coronavirus-social-distancing-and-self-quarantine">social-distancing and self-quarantines</a>, and another where it doesn’t.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9JMbqyLKayFNr0MNyFDFtg.jpeg" /><figcaption>SOURCE: <a href="https://www.cdc.gov/mmwr/volumes/66/rr/rr6601a1.htm#_blank"><em>CDC</em></a><em>, </em><a href="https://twitter.com/drewaharris/status/1233267475036372992"><em>Drew Harris</em></a><em>, </em><a href="https://www.npr.org/sections/health-shots/2020/03/13/815502262/flattening-a-pandemics-curve-why-staying-home-now-can-save-lives">NPR</a></figcaption></figure><p>Protective measures may seem excessive, but they effectively combat contagions like COVID-19 and allow health care systems to operate at capacity. Hospitals can deal with a steady flow of patients, however they can be easily overwhelmed during an outbreak when there’s a sudden influx of sick people. “Flatten the Curve” plainly shows a best case and worst case scenario; our collective habits can determine which one we experience.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1d6bf2891724" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/5-dashboards-for-tracking-covid-19-1d6bf2891724">5 Dashboards for Tracking COVID-19</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[6 Mistakes to Avoid In Your BI Strategy]]></title>
            <link>https://medium.com/eyeful/5-mistakes-to-avoid-in-your-bi-44f1b89b8681?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/44f1b89b8681</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[business-analytics]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Wed, 02 Oct 2019 18:32:04 GMT</pubDate>
            <atom:updated>2020-04-03T20:29:41.483Z</atom:updated>
            <content:encoded><![CDATA[<h4>Get the foresight you need to become a successful data-driven enterprise.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Xm72ucTsCVFEzoozrvkujg.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@rawpixel?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">rawpixel.com </a>from <a href="https://www.pexels.com/photo/person-using-laptop-computer-on-brown-wooden-table-1323592/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>Any company can have a roadmap to success, but only if they can transform their raw data into useful information. Business intelligence (BI) is the technology that makes this possible.</p><p>BI is an umbrella term for any analytical method or tool that can improve business performance. It enables companies to look up their past activity, monitor their current status, and plan for growth.</p><p>You can leverage BI to increase your revenue, as well as decrease your risks and costs. Nonetheless, you have to do it the right way or else you’ll create more problems than benefits. Here are some common mistakes to avoid in your BI strategy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>1: YOU DON’T KNOW WHAT YOU NEED TO MEASURE</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HPfJ13h-LuJyCuhW76RYzg.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@wwarby?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">William Warby</a> on <a href="https://unsplash.com/search/photos/measure?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>A BI report gives organizations an overview of their KPIs. Short for key performance indicators, KPIs are measurable values that track business goals. These numbers can reflect achievement, stability, or lack of progress. If you want to ramp up your customer acquisition, you should probably analyze KPIs like total leads, lead-to-sale conversion rate, or monthly revenue.</p><p>Different businesses depend on different metrics, so you must understand your own objectives before you can determine your own KPIs. Once you’ve established them, confirm that you have the data collection in place to capture everything you need.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>2: YOU DON’T CHECK YOUR DATA FOR ACCURACY</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fukmG3OEijFx5kP-dOERTw.jpeg" /><figcaption>© <a href="https://stock.adobe.com/contributor/204136066/elena-abrazhevich?load_type=author&amp;prev_url=detail">Elena Abrazhevich</a> / Adobe Stock</figcaption></figure><p>Data doesn’t lie…at least not intentionally. It’s important to remember that data is an artificial output — it’s not a natural byproduct of system processes. People define the events they want to track, and they build the infrastructure to record and store these events. Regardless if it’s set up correctly from the start, the technology can still break or develop bugs at any time. This is why you must routinely <a href="https://medium.com/eyeful/qa-your-data-or-die-d1c54fcd1562">test and QA your BI data</a>.</p><p>Data directly impacts bottom-line revenue and no one is immune to error. Major institutions like <a href="https://www.computerworld.com/article/2533631/desktop-apps/excel-error-leaves-barclays-with-more-lehman-assets-than-it-bargained-for.html">Barclays Capital</a> and <a href="http://www.businessinsider.com/excel-partly-to-blame-for-trading-loss-2013-2">JP Morgan</a> suffered multi-million dollar losses due to flawed intelligence. You cannot make smart decisions and properly allocate resources unless you have accurate information.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>3: YOU‘RE MISSING A SINGLE SOURCE OF TRUTH</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ILL1XYvBuw8Pgge3LAfX0Q.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@aluengo91?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Alejandro Luengo</a> on <a href="https://unsplash.com/s/photos/source?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Data regulation is just as crucial as data accuracy. All of your users should refer to a “single source of truth” (SSoT), which is basically the same pool of vetted information. Without an SSoT, various departments might interact with separate data sources and promote conflicting ideas. They may use invalid metrics or KPI formulas.</p><p>In order to have an SSoT, you should appoint a <a href="https://dataschool.com/data-governance/defining-a-data-govenor/">data governance</a> team. These specialists will manage your information, ensuring it conforms to any business logic or compliance rules. From a technical standpoint, an SSoT also streamlines maintenance given that one location is easier to QA than several.</p><p>An SSoT allows your BI to be factual and consistent, and it’s integral to reaching a consensus about the direction of your organization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>4: YOU DIDN’T CHOOSE THE RIGHT BI TOOL</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7B_79EVXkqnmwjwqDHu2aQ.jpeg" /><figcaption>© <a href="https://stock.adobe.com/contributor/206354353/farknot-architect?load_type=author&amp;prev_url=detail">Farknot Architect</a> / Adobe Stock</figcaption></figure><p>With over <a href="https://excelwithbusiness.com/blog/microsoft-excel-versus-apples-numbers-who-prevails/">750 million global users</a>, the spreadsheet program <a href="https://products.office.com/en-us/excel">Microsoft Excel</a> is the leading BI product. Yet despite its huge market share, its popularity is waning. More companies are utilizing its Web-based alternative <a href="https://www.google.com/sheets/about/">Google Sheets</a>, and new competitors are constantly emerging.</p><p><a href="https://www.tableau.com/">Tableau</a>, <a href="https://looker.com/">Looker</a>, <a href="https://www.sisense.com/">Sisense</a>, <a href="https://www.domo.com/">Domo</a>, and <a href="https://yellowfinbi.com/">Yellowfin</a> are some examples of <a href="https://medium.com/eyeful/talk-data-to-me-the-case-for-self-service-analytics-4f9e1584b9b9">self-service analytics</a> platforms that serve as BI tools. They equip non-analysts to run complex queries and uncover insights. A BI tool can boost productivity, however it’s critical to choose one that meets all of your financial and technical requirements. Can you commit to the license fees? Does it support your KPI tracking? How will your users interact with it? It’s essential to have a thoughtful evaluation period; after all, an incompatible BI tool can result in low user satisfaction and missed opportunities.</p><p>If you need any assistance with selecting a BI tool, <a href="https://eyeful.us/">schedule a free consultation with <strong>eyeful</strong></a> or complete their <a href="https://docs.google.com/forms/d/e/1FAIpQLSdwJhbHacAji0SXaW_C4ehOXjTajp-xMx193jl4VdQ5J_Ts8Q/viewform">BI Discovery Survey</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>5: YOUR REPORTS ARE INEFFECTIVE</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RKas2LHiz4Qc3rLJ3pu-Vg.png" /><figcaption>Photo by <a href="https://www.pexels.com/@rawpixel?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">rawpixel.com </a>from <a href="https://www.pexels.com/photo/person-s-hand-on-top-of-laptop-while-working-938963/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>You must always present your BI in a readable report. Additionally, it should focus on the KPIs that are relevant to your audience. The aim is for users to quickly assimilate the data they need to take action. This is true for any BI report — whether it’s in a document, a slide deck, or a <a href="https://medium.com/eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboard</a>. That being said, a dashboard has further considerations.</p><p>Dashboards are interactive reports that have a live connection to your data and update automatically. On top of curating and checking their information, you have to optimize them for performance. Dashboards need to be connected to a fast and responsive database, otherwise they’ll be slow. <a href="https://neilpatel.com/blog/loading-time/">Users are more likely to abandon pages that take over three seconds to load</a>, so speed is a big factor in the efficacy and adoption of dashboards.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>6: YOU USE THE WRONG DATA VISUALIZATIONS</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jD1HXYT3eg6dRNW6JoOFAw.png" /><figcaption>Photo by <a href="https://www.pexels.com/@goumbik?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Lukas </a>from <a href="https://www.pexels.com/photo/person-holding-chart-and-bar-graph-669612/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p><a href="https://medium.com/eyeful/a-cheat-sheet-for-choosing-the-right-data-visualizations-8f63a6242f1e">Data visualizations</a> are common elements of BI reports. They’re designed to help people absorb information, but the wrong one can slow down (and potentially misguide) their analysis.</p><p>Take for example the pie chart and bar chart below; both visualize the same sales lead data and sort it by quality.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*F5hk5LZFH5MExv786ilt-Q.png" /><figcaption>Example from <a href="https://www.amazon.com/Information-Dashboard-Design-Effective-Communication/dp/0596100167">Information Dashboard Design: The Effective Visual Communication of Data</a> by Stephen Few</figcaption></figure><p>Although the <a href="https://medium.com/eyeful/the-right-way-to-make-a-pie-chart-7852f568eaa9">pie chart</a> appropriately shows parts of a whole, it’s not ideal in this case. It has too many similar angles and viewers have to read each value to grasp their differences. Meanwhile, the bar chart is much better at displaying this breakdown with its linear segments. It makes the slight disparity between “Very High” and “High” clearer, along with the almost insignificant blip for “Field Sales: Very High.”</p><p>Humans are more adept at perceiving length than angles, and this is one aspect of visual communication that can inform your <a href="https://medium.com/eyeful/a-cheat-sheet-for-choosing-the-right-data-visualizations-8f63a6242f1e">chart selection</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>SET YOURSELF APART</h4><p>According to <a href="https://go.forrester.com/blogs/hadoop-is-datas-darling-for-a-reason/">Forrester Research</a>, up to 73 percent of all data within an organization goes unused for analytics. Plus, a survey from <a href="https://www.fastcompany.com/3065294/why-executives-dont-trust-their-own-data-and-analytics-insights">CapGemini and EMC</a> revealed that only 38 percent of executives are confident in their analytical findings.</p><p>Data is an untapped resource in many enterprises, and even fewer of them get any value out of their BI practices. Therefore, a well implemented BI strategy will surely give your business a competitive edge.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=44f1b89b8681" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/5-mistakes-to-avoid-in-your-bi-44f1b89b8681">6 Mistakes to Avoid In Your BI Strategy</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Right Way to Make a Pie Chart]]></title>
            <link>https://medium.com/eyeful/the-right-way-to-make-a-pie-chart-7852f568eaa9?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/7852f568eaa9</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[statistics]]></category>
            <category><![CDATA[pie-charts]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Tue, 03 Sep 2019 13:51:50 GMT</pubDate>
            <atom:updated>2020-04-03T20:29:54.038Z</atom:updated>
            <content:encoded><![CDATA[<h4>These are the do’s and don’ts for designing the familiar data visualization.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zJfiVggLBX7ZbxCMx2ZiDQ.png" /><figcaption>© <a href="https://stock.adobe.com/contributor/200913340/fufunteg?load_type=author&amp;prev_url=detail">fufunteg</a> / Adobe Stock</figcaption></figure><p>The pie chart is so popular that it’s the default data visualization in <a href="https://medium.com/the-mission/to-pie-charts-3b1f57bcb34a">Microsoft Excel and PowerPoint</a>. It’s certainly charming how it calls to mind a dessert being served. Yet despite its wide recognition and adoption, it’s not always an appropriate design. Misconceptions about pie charts abound and even analysts can share bad examples.</p><p>At best, a poorly made pie chart underwhelms viewers. At worst, it confuses them and sabotages their decision-making. Every successful pie chart plays into human instincts. Once you understand some basics about visual perception, you’ll master this <a href="https://medium.com/eyeful/a-cheat-sheet-for-choosing-the-right-data-visualizations-8f63a6242f1e">data visualization</a> and reserve it for the perfect situations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>WHAT IS A PIE CHART?</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/680/1*HUx6yzrWKW1BEHmKa7UXow.png" /><figcaption>William Playfair and his first pie chart, Wikimedia</figcaption></figure><p>In 1801, the Scottish engineer and political economist <a href="https://www.nytimes.com/2012/04/22/magazine/who-made-that-pie-chart.html">William Playfair introduced the world to pie charts</a>. He invented the data visualization to demonstrate parts of a whole; each part has its own color and all of their values total 100 percent.</p><p>Pie charts use angles to represent quantity, but humans struggle with measuring them at a glance. Research has found that we generally <a href="https://www.tandfonline.com/doi/abs/10.1080/01621459.1984.10478080">underestimate the size of acute angles (&lt;90°) and overestimate the size of obtuse ones (&gt;90°)</a>. Therefore, it’s good practice to mark the values in your pie charts — particularly if they have segments with similar amounts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OzZ1ww4MPMggCJ6EZ37Tqw.png" /><figcaption>Which segment is larger, A or B? Without marked values it’s hard to say for sure.</figcaption></figure><p>The more angles a pie chart contains, the more challenging it is for viewers to interpret. Multiple segments also lead to longer legends, which force people to constantly look up labels. As a result, the ideal pie chart should not exceed five slices.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>DON’T ASSUME IT’S EASY AS PIE</strong></h4><p>Pie charts are a well-known data visualization, however they’re rarely implemented properly. This diagram features some typical mistakes in designing pie charts and outlines the rules for formatting them correctly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6j60d8CQ7PHrEZSqa9gucA.png" /><figcaption>Your pie chart should follow all of the guidelines under the “Ancestry Composition” example (far right).</figcaption></figure><p>Aside from observing these principles, you should take further steps to ensure that your pie charts are readable.</p><p>For starters, you should never create a 3D data visualization. This effect produces extra angles and colors that will only make your information harder to analyze. When it comes to pie charts, 3D inevitably misleads viewers about the size of each part.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UEiV5h2ZrkXpueQxalitqQ.png" /><figcaption>A <a href="https://en.wikipedia.org/wiki/Misleading_graph">3D perspective</a> skews item D to look substantially larger than item B, it even suggests that item A and item C are nearly equal.</figcaption></figure><p>Moreover, you should consider your <a href="https://medium.com/eyeful/paint-by-numbers-how-to-color-your-data-visualizations-79d38b024ea2">color choices</a> when you design a pie chart. Almost every sighted individual can discern red from green, except for 4.5 percent of the population with red-green color blindness. This group sees these colors as brownish-green hues that could be hard to tell apart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sPrjniWyz7ePvM6BmK-keg.png" /></figure><p>If you’re concerned about accessibility, you can upload your pie chart to an online simulator like <a href="https://www.color-blindness.com/coblis-color-blindness-simulator/">Coblis</a> and check how it appears to color blind viewers. Alternatively, you can apply a single color to your pie chart and adjust its saturation. Just note that humans naturally equate greater saturation with greater volume, hence your biggest slices should have the richest hues.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*73kXfCy9172NjOvSNEp-VA.png" /></figure><p>Grading the saturation in your segments is a simple approach that can work for all sighted individuals.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>KEEP YOUR OPTIONS OPEN</strong></h4><p>A pie chart isn’t the only data visualization that can break down parts of a whole. You can also try a bar chart, especially if you have to split a measure into more than five segments.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6TCnDgzFi3Asb98ZMjr3xg.png" /><figcaption>Example from <a href="https://www.amazon.com/Information-Dashboard-Design-Effective-Communication/dp/0596100167">Information Dashboard Design: The Effective Visual Communication of Data</a> by Stephen Few</figcaption></figure><p>Both of the above data visualizations classify new opportunities by lead quality. The pie chart isn’t a suitable choice since it has too many slices. Plus, the angles have subtle variations and they’re indistinguishable without marked values. Nonetheless, the bar chart effectively displays this data. Whereas a pie chart uses angles to represent quantity, a bar chart uses length — which humans can easily interpret. It’s much better at showing small increments, like the minor gap between “Very High” and “High”. The 0.10 percent for “Field Sales: Very High” is detectable as well.</p><p>On the other hand, your data may meet all of the pie chart criteria but you may want to emphasize its differences. In this case, you should create a donut chart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vLIIzS-2I1uYe7Fz28XGxg.png" /><figcaption>Donut charts don’t necessarily require marked values because they can make differences more pronounced.</figcaption></figure><p>A donut chart adds another dimension, allowing viewers to scan the length of each part for comparison. It marries the circular shape of a pie chart with the linear quality of a bar chart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>PIE CHARTS ARE IN OUR DNA</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/370/1*QK3BP4F4XnMed1v3wbxjuA.jpeg" /><figcaption>Edward Tufte, photo by <a href="https://www.flickr.com/photos/centralasian/">cea +</a> / Flickr</figcaption></figure><p>The pie chart isn’t an optimal data visualization unless it falls under a specific set of circumstances. For this reason, eminent statisticians have dismissed pie charts and encouraged the use of bar charts instead. Edward Tufte, a modern thought leader in data visualization, is definitely in this camp. He has argued, <a href="https://infogram.com/blog/the-infamous-pie-chart-history-pros-cons-and-best-practices/">“the only worse design than a pie chart is several of them.”</a></p><p>Regardless, pie charts are classic components of BI <a href="https://medium.com/eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboards</a>, presentations, and reports. While statisticians seem to avoid them, business managers seem to love them. One explanation for the pie chart’s appeal may have to do with its contours; evolution has conditioned people to <a href="https://www.smithsonianmag.com/science-nature/do-our-brains-find-certain-shapes-more-attractive-than-others-180947692/">associate sharp edges with danger and round curves with wellness</a>. From Africa to the Americas, some of the earliest figures that ancient humans ever drew were <a href="https://blog.usejournal.com/why-humans-love-pie-charts-9cd346000bdc">concentric spirals and sectioned circles</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*z4l90A-_tBLx6X0CgWJuIQ.png" /></figure><p>Although a chart’s primary purpose is to communicate data effectively, aesthetics are still hugely important. You need compelling graphics to draw an audience and engage viewers. Pie charts can be impactful data visualizations, as long as you design them according to the right standards.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! We are </em><strong><em>Eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7852f568eaa9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/the-right-way-to-make-a-pie-chart-7852f568eaa9">The Right Way to Make a Pie Chart</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Think Ahead: Boost Your BI with AI]]></title>
            <link>https://medium.com/eyeful/think-ahead-boost-your-bi-with-ai-d8df8f64851f?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/d8df8f64851f</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[eyeful-trends]]></category>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[artificial-intelligence]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Tue, 20 Aug 2019 18:12:12 GMT</pubDate>
            <atom:updated>2020-04-03T20:30:05.808Z</atom:updated>
            <content:encoded><![CDATA[<h4><em>You may be overlooking lucrative business insights. Artificial intelligence can change that.</em></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tt0WH39PzIi7OPA5Qwk90Q.png" /><figcaption>Photo by <a href="https://unsplash.com/@rocknrollmonkey?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Rock’n Roll Monkey</a> on <a href="https://unsplash.com/collections/8249232/ai?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Thanks largely to pop culture, artificial intelligence (AI) is an intimidating topic for many people. It can evoke sinister images of supercomputers like <a href="https://www.youtube.com/watch?v=Wy4EfdnMZ5g">HAL 9000</a> or apocalyptic scenarios like the <a href="https://www.vice.com/en_us/article/qbnk77/how-scared-should-i-be-of-the-singularity">Singularity Hypothesis</a>. Realistically though, AI can be our friend — especially during the current information boom. <a href="https://www.forbes.com/sites/bernardmarr/2018/05/21/how-much-data-do-we-create-every-day-the-mind-blowing-stats-everyone-should-read/#50e5ad4860ba">In the last two years alone, we created 90 percent of the world’s data</a>.</p><p>AI is essentially a piece of software that replaces human labor. Whenever you run spell-check to proofread a document, you’re engaging with AI. The technology intersects with data through machine learning (ML), the practice of building and training statistical models to understand information. It basically gives computers “thinking” ability, enabling them to make decisions without being explicitly programmed to do so.</p><p>Businesses inevitably reach a point where they have too much activity to look at; their existing staff can’t analyze everything, and it becomes impractical to hire more resources. Fortunately, now it’s easier for companies of all sizes to turn to AI for help. AI-powered analytics can scan millions of rows of data and dig up interesting insights in seconds. They can even improve data quality, reveal untapped potential, and predict outcomes. Discover how different AI features can elevate your business intelligence (BI) to increase efficiency and decrease costs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>1: DATA TRANSFORMATION</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9w6GnJU_8r-XaVAvw4KHWQ.png" /><figcaption>Photo by <a href="https://unsplash.com/@martinadams?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Martin Adams</a> on <a href="https://unsplash.com/collections/8249232/ai?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>It’s not possible for ML models to produce accurate results unless they’re trained on valid information. Before you can analyze your data or explore it with AI, you’ll have to transform it into a proper format. You should check for errors, but you may also need to clean up event names, apply extra labels, or combine multiple data sources together. Data transformation is a tedious task that can take up to 80 percent of an analyst’s time. It requires a lot of focus, however <a href="https://medium.com/@eyeful/qa-your-data-or-die-d1c54fcd1562">it’s a critical step that ensures maximum data quality</a>. <a href="https://fivetran.com/">Fivetran</a>, <a href="https://www.trifacta.com/">Trifacta</a>, <a href="https://improvado.io/">Improvado</a>, and <a href="https://funnel.io/">Funnel.io</a> are a few services that can speed up the process with automation. And since they forego manual work, they’re less prone to mistakes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>2: ANOMALY DETECTION</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GyiL9xYePQdDgVpuJfjbeA.png" /><figcaption>Photo by <a href="https://unsplash.com/@erwanhesry?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Erwan Hesry</a> on <a href="https://unsplash.com/search/photos/traffic-light?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>As you accrue data, ML models learn your metrics’ typical behavior and set baselines for them. They can understand seasonal trends, and more importantly, they can identify outliers and other unusual objects. Companies often employ anomaly detection to catch fraudulent transactions or system malfunctions. Some medical devices use this technology to flag health problems in patients. <a href="https://www.anodot.com/autonomous-detection/">Anodot</a> is one AI product that can quickly detect and alert you to anomalies in your data. Plus, it can link any issues to root causes so you can readily resolve them. Anomaly detection prevents bad situations from going unnoticed and making things worse.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>3: EVENT CORRELATION</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MiF6mlv63LmBRnvcgeAwLA.png" /><figcaption>Photo by <a href="https://unsplash.com/@worldsbetweenlines?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Patrick Hendry</a> on <a href="https://unsplash.com/search/photos/parallel?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>An analyst’s primary responsibility is to observe patterns and locate opportunities. Yet even experts can overlook trends or misinterpret results, particularly if they have to sift through a lot of information. Consequently, more businesses are enhancing their data analysis with ML. In addition to detecting anomalies, ML models can detect meaningful event correlations — some of which businesses can exploit for big wins. For instance, a brand’s emails could have the strongest open rates when they go out on Wednesday mornings and their subject lines contain emojis. This detail is useful to marketers because it can help them strategically plan their campaigns. Nonetheless, it could’ve been missed with ordinary data analysis. ML can return sharper insights in less time, and it’s not as likely to exhibit bias as a human analyst.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>4: NATURAL LANGUAGE PROCESSING</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*p7Du2qmjEV7yNbecsB9XGw.png" /><figcaption>Photo by <a href="https://unsplash.com/@kelseycurtis?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Kelsey Curtis</a> on <a href="https://unsplash.com/collections/8249232/ai?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p><a href="https://support.google.com/analytics/answer/7411707?hl=en">Google Analytics</a> has a built-in AI function that can correlate events and auto-generate insights. Enterprise BI tools like <a href="https://www.yellowfinbi.com/suite/signals">Yellowfin</a> and <a href="https://www.thoughtspot.com/">ThoughtSpot</a> use similar technology to uncover any hidden wisdom in their customers’ data. Interestingly, all of these products harness Natural Language Processing (NLP) to communicate their findings and make data conversational. They can display insights in plain English, as in “25.33% of your site traffic is from the Referral channel.” Additionally, some of these NLP programs let users submit questions and receive answers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*HNTgPpeLojboIp1czzz8og.gif" /><figcaption>A demo of how <a href="https://www.thoughtspot.com/">ThoughtSpot</a> implements NLP. A user types in a specific question and gets an answer.</figcaption></figure><p>NLP can transform a <a href="https://medium.com/@eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboard</a> into a virtual analyst; it lowers the barrier of entry to BI so anyone can stay in the know about their business. Users don’t have to deal with spreadsheets, <a href="https://medium.com/@eyeful/a-cheat-sheet-for-choosing-the-right-data-visualizations-8f63a6242f1e">charts</a>, or SQL queries to get the information they need. Instead, they can interact with software that analyzes the data for them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>5: PREDICTIVE ANALYTICS</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*g6_6j-pO9T8gaFiPGZtLsQ.png" /><figcaption>Photo by <a href="https://unsplash.com/@dylan_nolte?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">dylan nolte</a> on <a href="https://unsplash.com/search/photos/game-show?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>AI can illuminate the past and present, but it can also offer a vision of things to come. Predictive analytics leverages ML to find regular patterns in data and carry them into the future. These projections are common in financial and weather forecasting, and they’re increasingly relevant to BI. Case in point, any retailer who can anticipate product demand will promote higher rates of customer satisfaction. In other words, they’ll have enough of an item in stock when consumers want it the most. Predictive capability comes with a competitive advantage, and more businesses can acquire it via platforms like <a href="https://www.ibm.com/watson">IBM Watson</a> or <a href="https://www.datarobot.com/">DataRobot</a>. The popular BI tool <a href="https://www.tableau.com/">Tableau</a> includes a <a href="https://help.tableau.com/current/pro/desktop/en-us/forecast_how_it_works.htm">forecasting feature</a> too.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>IT’S NEVER TOO EARLY TO START</h4><p>AI products will get even better at delivering warnings, correlations, and predictions. While the best is yet to come, you should embrace this technology now. Like many businesses, your competition may depend on humans to conduct their entire analytics operation. You immediately stand out from them once you begin automating your BI. The benefit of being an early adopter is that you’re already proficient by the time most people are just starting out. Prepare for the next wave of innovation, otherwise it’ll sweep you away rather than lift you up.</p><p>Always remember that AI isn’t perfect, it’s only as reliable as the data it’s based on. <a href="http://nymag.com/intelligencer/2018/01/waze-app-directs-driver-to-drive-car-into-lake-champlain.html">Back in 2018, Waze directed a user to drive his car into a lake and he complied</a>. He assumed the app was correct, despite common sense and his obvious surroundings. In this case, the GPS navigation didn’t give the right instructions because it didn’t have the right information. Moral of the story: never follow AI blindly. The results from your ML models should enhance your judgment, not replace it altogether.</p><p>Similarly, AI isn’t a substitute for data analysts or data scientists. We still need specialists to oversee and validate research, except now they can do this work faster and more effectively with AI.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d8df8f64851f" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/think-ahead-boost-your-bi-with-ai-d8df8f64851f">Think Ahead: Boost Your BI with AI</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[QA Your Data or Die ]]></title>
            <link>https://medium.com/eyeful/qa-your-data-or-die-d1c54fcd1562?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/d1c54fcd1562</guid>
            <category><![CDATA[qa]]></category>
            <category><![CDATA[eyeful-trends]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[quality-assurance]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Tue, 20 Aug 2019 18:11:19 GMT</pubDate>
            <atom:updated>2020-04-03T20:30:16.039Z</atom:updated>
            <content:encoded><![CDATA[<h4><em>Mistakes in your business intelligence are practically unavoidable — but when you know better, you do better.</em></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mnhrF_M6OtbzozaOd4Znmg.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@ihasdslr?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Vitaly Vlasov</a> from <a href="https://www.pexels.com/photo/person-pointing-numeric-print-1342460/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>Early sailors navigated the water with <a href="https://en.wikipedia.org/wiki/Dead_reckoning#Marine_navigation">“dead reckoning.”</a> Using this technique, they would assess their distance from a known point of origin in order to reach their destination. Dead reckoning could be effective, however it depended on frequent and exact measurements of a vessel’s direction and speed. One missed reading or poor judgement could throw a crew hopelessly off course.</p><p>The sailors who tracked their ship’s movements for dead reckoning were essentially collecting data. While modern-day businesses may not face the same life or death implications, they also rely on data to determine where they’re going. An accumulation of errors can set any organization adrift, which is why data integrity should never go unchecked.</p><p>Whether your users view data in a spreadsheet, a <a href="https://medium.com/@eyeful/a-cheat-sheet-for-choosing-the-right-data-visualizations-8f63a6242f1e">chart</a>, or a <a href="https://medium.com/@eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboard</a>, they expect to see an accurate display of activity. Otherwise, the information is useless to them; it can’t help with making better decisions or plans. Given that issues can arise anytime, you must routinely assure the quality of your data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sIg_u7DqAzDaKj-m0YFnCw.png" /><figcaption>Photo by <a href="https://unsplash.com/@fairfilter?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Oliver Roos</a> on <a href="https://unsplash.com/search/photos/yacht-aerial?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><h4>MISTAKES HAPPEN</h4><p>Businesses of all industries and sizes struggle with data, and reporting errors can result in everything from <a href="https://www.huffpost.com/entry/skyscanner-47-year-layover_n_57c588fae4b0664f13ca6723">temporary embarrassment</a> to major damages. Even if you work with an enterprise analytics team, you’ll inevitably have setbacks.</p><p>Data glitches caused <a href="https://petapixel.com/2017/08/03/amazon-honoring-500-pricing-error-2200-sony-lens/">Amazon</a>, <a href="http://www.cnbc.com/2013/11/06/wal-mart-accidentally-slashes-prices-blames-glitch.html">Walmart</a>, and <a href="https://www.architecturaldigest.com/story/anthropologie-couches-accidentally-marked-down-0-dollars">Anthropologie</a> to sell products for little to no money. And banks like <a href="https://www.computerworld.com/article/2533631/desktop-apps/excel-error-leaves-barclays-with-more-lehman-assets-than-it-bargained-for.html">Barclays Capital</a> and <a href="http://www.businessinsider.com/excel-partly-to-blame-for-trading-loss-2013-2">JP Morgan</a> suffered multi-million dollar losses due to mistakes in their Excel files. Bad data certainly impacts employees, and the effects often go beyond a single organization.</p><p><a href="https://www.wsj.com/articles/facebook-overestimated-key-video-metric-for-two-years-1474586951">Facebook actually re-shaped an entire market because of bad data.</a> In 2014, the platform touted an upswing in video consumption across their network. These claims spurred the “pivot to video” and online publishers immediately prioritized making videos over articles. But two years later, Facebook admitted that they inadvertently added an extra 60–80 percent to their video retention metric. Not surprisingly, the “pivot to video” never met industry expectations. The media eventually <a href="https://adage.com/article/media/pivot-video-failed/310675">abandoned the strategy</a> and <a href="https://gizmodo.com/advertisers-suing-facebook-allege-it-may-have-committed-1829830311">advertisers sued Facebook</a> over the exaggerated KPI.</p><p>Facebook’s a huge player with limitless resources, yet they still produced bad data and unknowingly misled the public. The same thing can easily happen to your business.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>GARBAGE IN, GARBAGE OUT</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ycxGziOqN3AMMy_S8WGm3Q.png" /><figcaption>Photo by <a href="https://unsplash.com/@kor4insky?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Evgeny Karchevsky</a> on <a href="https://unsplash.com/collections/6799514/qa?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>The quality of your data ultimately depends on how well it’s captured. GIGO is shorthand for “garbage in, garbage out.” It’s a programming expression that emphasizes attention to detail because one typo or omission could skew your findings. For instance, if a supermarket doesn’t thoroughly classify products in their database, their sales of Dove soap could show up as sales of Dove chocolate.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*TE2cyho6eX5STxLHh4ihHw.png" /><figcaption>A TALE OF TWO DOVE BARS: A database may not be able to differentiate between these items unless they’re adequately tagged.</figcaption></figure><p>Since people ultimately design the data collection process, it’s susceptible to failure and bias. Therefore, you must scrutinize how you’re gathering your business intelligence. Are you measuring everything you want to track? Is your methodology correct?</p><p>Once you answer these questions, you should establish a <a href="https://medium.com/@elisavaccaro/single-source-of-truth-and-why-it-matters-a68e28b8c175">“single source of truth”</a> (SSOT) to guarantee all of your users interact with the same vetted information. An SSOT consolidates all of your data in one place; it’s less prone to error and it comes with the bonus of standardizing metrics.</p><p>Whenever an organization has issues with collecting data, it has issues with making decisions based on reality. Flawed information can misguide your users about what’s best for their business. Plus, users who lose faith in your data will stop engaging with it and fall back on guesswork.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4>THE BEST DEFENSE IS A GOOD OFFENSE</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PiW631M1TkJN5EG2NT9NQQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@usinglight?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Stefan Steinbauer</a> on <a href="https://unsplash.com/collections/6799514/qa?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>You can avoid a lot of obstacles with early testing and continuous monitoring of your data. Google Analytics offers <a href="https://chrome.google.com/webstore/detail/google-analytics-debugger/jnkmfdileelhofjcijamephohjechhna?hl=en">Google Analytics Debugger</a>, a free Chrome extension that flags problems on any website that uses its tracking code. Alternatively, <a href="https://www.anodot.com/autonomous-detection/">Anodot</a> is a sophisticated <a href="https://medium.com/@eyeful/think-ahead-boost-your-bi-with-ai-d8df8f64851f">AI product</a> that integrates with other analytics platforms to report bug-related anomalies in real-time.</p><p>You also minimize your risk of error when you eliminate manual data preparation. Spreadsheets in Excel and Google Sheets may be useful for doing a one-time analysis, but they can’t provide any ongoing visibility into your business. You have to fill them out by hand and they lack a direct connection to your data source(s). As a result, they’re especially vulnerable to miscalculations and misspellings. Services like <a href="https://supermetrics.com/">Supermetrics</a>, <a href="https://fivetran.com/">Fivetran</a>, <a href="https://www.trifacta.com/">Trifacta</a>, <a href="https://improvado.io/">Improvado</a>, and <a href="https://funnel.io/">Funnel.io</a> automate data preparation so you can spend less time building reports and more time analyzing data you can trust.</p><p>Like any technology, data infrastructures can spontaneously break or develop bugs. What’s most important is that you can quickly pinpoint and address these glitches. Furthermore, you should always inform your stakeholders about any issues and keep them updated on their resolution.</p><p><a href="https://www.fastcompany.com/3065294/why-executives-dont-trust-their-own-data-and-analytics-insights">Only 33 percent of senior executives express strong confidence in their business analytics.</a> If you want a higher rate of satisfaction within your own organization, you need to be vigilant about the accuracy of your data.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>Eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d1c54fcd1562" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/qa-your-data-or-die-d1c54fcd1562">QA Your Data or Die 💀</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Paint by Numbers: How to Color Your Data Visualizations]]></title>
            <link>https://medium.com/eyeful/paint-by-numbers-how-to-color-your-data-visualizations-79d38b024ea2?source=rss----c39493e6b6ed---4</link>
            <guid isPermaLink="false">https://medium.com/p/79d38b024ea2</guid>
            <category><![CDATA[charts]]></category>
            <category><![CDATA[eyeful-how-to]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[dashboard-design]]></category>
            <dc:creator><![CDATA[Therese Moriarty]]></dc:creator>
            <pubDate>Tue, 20 Aug 2019 18:09:44 GMT</pubDate>
            <atom:updated>2020-04-09T14:47:25.077Z</atom:updated>
            <content:encoded><![CDATA[<h4><em>Presentation is everything and color can make or break your delivery.</em></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JdaBFpeagOedAm6PjRAolw.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/photos/VvEWpYu1yIo?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Dmitry Bayer</a> on <a href="https://unsplash.com/collections/3146414/my-first-collection/524d97cb338fa97fe96042a38bf0029b?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Color imparts meaning to data visualizations. It’s the element that encodes value and indicates the metric on display. When you’re visualizing data, choosing the right palette is just as crucial as <a href="https://medium.com/@eyeful/a-cheat-sheet-for-choosing-the-right-data-visualizations-8f63a6242f1e">choosing the right chart</a>.</p><p>It’s paramount that viewers peruse your data visualization with an open mind. Furthermore, they should readily absorb any information you put before them. Color has the power to direct their gaze, and a misuse of color can slow down or warp their analysis.</p><p>Once you grasp the nature of color and its role in visual perception, you begin to make better decisions about designing your data visualizations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>WHAT IS COLOR?</strong></h4><p>Color has three properties: hue, saturation, and brightness. Hue refers to the wavelength that people see and it’s what everyone interprets as color (e.g. red, blue, yellow). Saturation measures intensity and reflects how much of a hue is present. Lastly, brightness is the degree to which a hue is dark or light. A hue with 0% saturation appears white, whereas a hue with 0% brightness appears black.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ct3BMo_oPcLdgamXbWoSeg.png" /></figure><p>All of these circles have the same hue, but note how different levels of saturation or brightness can alter their appearance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>HOW WE PERCEIVE COLOR</strong></h4><p>Color is an attribute that sighted individuals process preattentively, meaning that they recognize it without any conscious thought. To observe this principle in practice, try scanning this sequence of numbers and count every instance of three. How many are there?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*s0T2hy8hwUL7TWANVcUS3A.png" /></figure><p>The correct answer is that there are nine instances of three. Now repeat the same exercise with this sequence of numbers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GqdXJ4BBBuk6ny3DJF-Isw.png" /></figure><p>Whether you got the answer right or wrong the first time, surely it was easier to count every instance of three in red. As you can see, the shape of each number is too elaborate to process preattentively — but not the color. Humans subconsciously group things together based on preattentive attributes like color; understanding this instinct is key to producing effective data visualizations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>6 TIPS FOR USING COLOR</strong></h4><p>There isn’t a universal approach to coloring data visualizations; various metrics, charts, and audiences all require their own considerations. In any case, a lot of the best practices are easy to remember because they appeal to our basic impulses. Armed with the right techniques, you can turn any blank canvas into a visually compelling chart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>1. Lighten Up Your Axes &amp; Gridlines</strong></h4><p>Axes and gridlines provide the structure for data visualizations like bar charts and line charts. Axes define the area of the graph and gridlines mark the intervals where you plot the data. Although they’re essential components, they should always be muted.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*beQ1XyOUum_zvLpCr1H8NA.png" /></figure><p>Black axes and gridlines can distract from the data, hence their color and stroke weight should be as light as possible. The same rationale applies to any labeling, particularly if it’s on a light dashboard. People are more likely to develop eyestrain from reading high contrast pairings like black text on a white screen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>2. Give Your Bar Charts One Color</strong></h4><p>Believe it or not, this emoji is a poorly designed data visualization: 📊.</p><p>Any bar chart that visualizes one metric must have one color. It shouldn’t have multiple colors or even a gradient since these effects can mislead viewers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pHLDmnf0caOCnHRcopTQlw.png" /></figure><p>This is because we preattentively assign different colors to different groups. Yet these bars don’t belong to different groups, they actually belong to different categories within the same group. Gradients have more subtle color variations, but they can still interfere with our preattentive processing.</p><p>There are merely two exceptions to this “one color” rule: a bar chart should have multiple colors if it’s stacked or if it visualizes more than one metric together (like spend and conversions).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>3. Be Purposeful with Brightness</strong></h4><p>Bright colors are attention-grabbing, but only when they stand out in contrast to softer colors. Otherwise, they become overwhelming and meaningless. If everything in your data visualization is bright and bold, your viewers won’t be able to notice anything significant.</p><p>This isn’t to suggest that you shouldn’t use brightness at all, just use it sparingly and reserve it for special cases. Bright colors can emphasize importance or urgency, which is why they’re ideal for alerts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XkwaNPIqCkwd1Ov5ezd5KQ.png" /><figcaption>From <a href="https://www.amazon.com/Information-Dashboard-Design-Effective-Communication/dp/0596100167">Information Dashboard Design: The Effective Visual Communication of Data</a> by Stephen Few</figcaption></figure><p>These bullet charts represent the same information, but the set on the left uses bright colors to highlight almost everything. Conversely, the set on the right is more restrained and therefore easier to digest. It also removes all of the alert icons except for the ones in red, making it obvious that “Profit” and “New Customers” are the main metrics to focus on.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>4. Never Go 3D!</strong></h4><p>A 3D effect may look impressive at first glance, however it’s a really terrible format for data visualization. Given that it illustrates depth with different shades and tints, 3D adds superfluous colors. Plus, a third dimension can hide data from your viewers like in this comparison.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*v42KQGxnQueW0SULX0kWfQ.png" /></figure><p>The 3D bar chart on the left has overlapping bars that block some of the values. It’s pretty much useless without extensive labeling. If you redesign it as a 2D stacked bar chart like the one on the right, the information becomes much clearer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>5. Don’t Make Everything a Traffic Light</strong></h4><p>Most people encounter traffic lights in their daily life. As a result, they’re socialized to interpret red as “stop”, yellow as “proceed with caution”, and green as “go”. Many designers apply the same pattern to data visualizations, especially those with “bad”, “satisfactory”, and “good” ranges.</p><p>These three colors are the norm for regulating traffic, but they’re not always practical for visualizing data. Keep in mind that traffic lights use brightness purposefully, and they don’t show each signal at once. If they did, they would confuse drivers⁠ — so why should we expect concurrent displays of bright red, yellow, and green to work in data visualizations?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lJbdv4BWwi53bdia-LZ2jg.png" /></figure><p>Gauges are common on reporting <a href="https://medium.com/@eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboards</a> because they evoke the literal dashboards in cars. Designers tend to iterate on the driving metaphor by coloring them like traffic lights. Gauges may be standard for measuring speed or fuel, but they’re not a good fit for every metric. A bullet chart with mellow colors is usually a better alternative.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>6. Design for Color Blindness</strong></h4><p>Another issue with traffic light-inspired color schemes is that they alienate 4.5 percent of the population with red-green color blindness. These individuals have trouble distinguishing between red and green, sometimes they perceive them as similar brownish hues.</p><p>Therefore, you should always check if your colors are readable to everyone. Note how the red and green segments in this <a href="https://medium.com/eyeful/the-right-way-to-make-a-pie-chart-7852f568eaa9">pie chart</a> are barely discernible to most color blind viewers. Of course, the legend can’t assist them at all since it exhibits the same problem.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sPrjniWyz7ePvM6BmK-keg.png" /></figure><p>In addition to choosing safe color combinations, you can ensure that your pie chart is accessible by giving it a single hue and grading its saturation. People naturally equate more saturation with more volume, so it’s a nice solution as long as your greater values are richer in hue.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*73kXfCy9172NjOvSNEp-VA.png" /></figure><p><a href="https://www.color-blindness.com/coblis-color-blindness-simulator/">Coblis</a> is a portal where you can upload your images and simulate how they appear to color blind viewers. It can also mimic rarer forms of the condition like blue-yellow color blindness.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1/1*ka0QNdK7bL0NBeUBbGJmsw.png" /></figure><h4><strong>COLOR MADE EASY</strong></h4><p>There are several resources that can streamline your color selection process. <a href="https://color.adobe.com/create">Adobe Color Picker</a> features an interactive color wheel that can generate an entire scheme for you. Meanwhile, <a href="https://flatuicolors.com/">Flat UI Colors</a> is a destination that has tasteful palettes; in fact, all of the options are specially curated for 2D designs. And if you’re creating data visualizations for a company <a href="https://medium.com/@eyeful/10-principles-for-building-effective-dashboards-1f1bddceda0e">dashboard</a>, consider seeking inspiration from the brand’s style guidelines.</p><p>One thing you can count on is that an abundance of color will bombard your viewers rather than captivate them. When in doubt, use the minimum amount of color and employ brightness to highlight what’s truly important.</p><p>All said, you don’t have to remember every single best practice in order to properly color your data visualizations. Simply remind yourself that a little bit always goes a long way.</p><p><a href="https://eyeful.us/?utm_source=Medium&amp;utm_medium=SSA&amp;utm_campaign=contentMarketing"><em>Thank you for reading! I’m the founder and principal of </em><strong><em>eyeful</em></strong><em>, a self-service analytics consultancy based in NYC. Visit our website for more information.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=79d38b024ea2" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eyeful/paint-by-numbers-how-to-color-your-data-visualizations-79d38b024ea2">Paint by Numbers: How to Color Your Data Visualizations</a> was originally published in <a href="https://medium.com/eyeful">eyeful</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>