<?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[Stories by Rémy DAVID on Medium]]></title>
        <description><![CDATA[Stories by Rémy DAVID on Medium]]></description>
        <link>https://medium.com/@remy_david?source=rss-74a2acdf7f3e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*zWqyLjamhbSJq6nkz9b8XA.jpeg</url>
            <title>Stories by Rémy DAVID on Medium</title>
            <link>https://medium.com/@remy_david?source=rss-74a2acdf7f3e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 11:33:57 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@remy_david/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[What’s Wrong with COVID-19 Data Visualizations, and How to Fix it]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/whats-wrong-with-covid-19-data-visualizations-and-how-to-fix-it-3cdc9adc774d?source=rss-74a2acdf7f3e------2"><img src="https://cdn-images-1.medium.com/max/2600/1*vfoaP3sCPIXZrkKKtH6kkw.png" width="2697"></a></p><p class="medium-feed-snippet">Since the beginning of the Coronavirus outbreak I have been puzzled at the way data is presented to us by the media and even specialists.</p><p class="medium-feed-link"><a href="https://medium.com/data-science/whats-wrong-with-covid-19-data-visualizations-and-how-to-fix-it-3cdc9adc774d?source=rss-74a2acdf7f3e------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/whats-wrong-with-covid-19-data-visualizations-and-how-to-fix-it-3cdc9adc774d?source=rss-74a2acdf7f3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/3cdc9adc774d</guid>
            <category><![CDATA[coronavirus]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[covid19]]></category>
            <category><![CDATA[medium]]></category>
            <dc:creator><![CDATA[Rémy DAVID]]></dc:creator>
            <pubDate>Sun, 05 Apr 2020 12:11:23 GMT</pubDate>
            <atom:updated>2020-04-05T19:04:47.873Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Why Feminist Education Is Important, even for Boys]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@remy_david/why-feminist-education-is-important-even-for-boys-274838d4fa4b?source=rss-74a2acdf7f3e------2"><img src="https://cdn-images-1.medium.com/max/2600/1*KT4a8QU8vRSLugtT9dEy7Q.jpeg" width="3161"></a></p><p class="medium-feed-snippet">A real life exemple with my son</p><p class="medium-feed-link"><a href="https://medium.com/@remy_david/why-feminist-education-is-important-even-for-boys-274838d4fa4b?source=rss-74a2acdf7f3e------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@remy_david/why-feminist-education-is-important-even-for-boys-274838d4fa4b?source=rss-74a2acdf7f3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/274838d4fa4b</guid>
            <category><![CDATA[children]]></category>
            <category><![CDATA[parenting]]></category>
            <category><![CDATA[education]]></category>
            <category><![CDATA[feminism]]></category>
            <category><![CDATA[life]]></category>
            <dc:creator><![CDATA[Rémy DAVID]]></dc:creator>
            <pubDate>Fri, 03 Apr 2020 19:31:15 GMT</pubDate>
            <atom:updated>2020-04-04T22:34:53.242Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[4 Data Studio tricks for nice-looking reports]]></title>
            <link>https://medium.com/google-cloud/4-data-studio-tricks-for-nice-looking-reports-422cfc1657d6?source=rss-74a2acdf7f3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/422cfc1657d6</guid>
            <category><![CDATA[gcp]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <dc:creator><![CDATA[Rémy DAVID]]></dc:creator>
            <pubDate>Fri, 09 Aug 2019 14:53:56 GMT</pubDate>
            <atom:updated>2019-09-06T10:29:28.469Z</atom:updated>
            <content:encoded><![CDATA[<h3>4 Data Studio tricks</h3><p>I regularly build or help people build Data Studio reports, with a focus on good UX and polished UI. Doing so I started compiling a list of tips that can help improve Data Studio reports. Here are four:</p><ul><li>Transparent clickable zones</li><li>Dimension colors for 1-dimension charts</li><li>Objective display (constant calculated fields)</li><li>Zoomed maps</li></ul><h3>Transparent clickable zones</h3><p>Currently the only way to create links in Data Studio is by using the text element:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ynn8VTzDTb23eR8p696x5w.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/1*Ri9RHNRlzO0mfns_Ifo6Xw.png" /></figure><p>That’s nice but there is a couple of problems:</p><ul><li>The style of links in Data Studio cannot be changed, whatever color and font style we choose in the style panel, the link will always display in the default 1990&#39;s hyperlink underlined blue style:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/434/1*TIyOrcNqOtdz6pc3RMqYIA.png" /><figcaption>Yiiiiiiks !</figcaption></figure><ul><li>What if we want to create link on other elements?</li></ul><p>The solution is to create a link on big empty characters (say, some spaces):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lBOjsREjpdGHYDHBuOuq_A.png" /></figure><p>Then, set the overflow setting to hidden and, voilà! we have a transparent clickable zone that can be put on top of any element.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/786/1*LpCpvNA311ibOhcuqPxHCw.png" /><figcaption>A transparent clickable zone</figcaption></figure><h3>Dimension colors for 1-dimension charts</h3><p>Data Studio has a feature that allow to display a color based on <a href="https://support.google.com/datastudio/answer/9210313#color-by-value">dimension value</a>. For a reason that is beyond my understanding, this option is only available for charts that have a breakdown dimension.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pN4cn4aJiUiRZPwfENS4GA.png" /><figcaption>1-dimension chart : no dimension color : (</figcaption></figure><p>To enable the feature for 1-dimension charts, create a “fake” dimension containing a constant label identical for all the rows. Then use this in the dimension setting while putting the “true” dimension in the breakdown setting:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ySM-b4i8SMYW2Fh4cqouMA.png" /><figcaption>Added a constant label dimension (here value = “BU”), now there is colors on my dimensions : )</figcaption></figure><h3>Objective display (constant calculated fields)</h3><p>Displaying data is good, but being able to tell if the data is good or bad is better. The best way to do that is by displaying a reference along the data on the charts as much as possible. This reference is often an objective. Sometime the objective is in the Data Source and can be displayed with the data. But when it’s not, we can add it manually with a calculated field. The thing is calculated fields do not accept constant values:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VHT3ARV4IHzbruOYY-VR8w.png" /><figcaption>Attempt to add a 200$ objective: fail</figcaption></figure><p>The trick is to multiply any metric by 0 and add the constant value:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rOqSH5ba_T1DQJWsJg05EQ.png" /><figcaption>What do you think of this Data Studio ?</figcaption></figure><p>Pay attention that to display the objective correctly its aggregation needs to be set as MAX, MIN or AVG (because max, min or average of a constant equals the constant).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9S7qgnQ_zdH3hv9x70w4sg.png" /><figcaption>Result</figcaption></figure><p>More complex objectives can be defined based on the CASE function.</p><h3>Zoomed maps</h3><p>Data Studio maps minimum zoom level is limited. Sometime we just want to focus on a part of a region. We can workaround this by increasing the size of the map and moving most of it outside of the report canvas, leaving only the interesting part inside the canvas, e.g. :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RUI0zcQJx61u3-kpcCw85w.png" /><figcaption>Most part of the Massachusetts map is outside of this report, on the left, we focus on the est side of the state.</figcaption></figure><p>We can also combine this with elements order (send to back / move to front) to hide part of the map with rectangle forms of the same color as the report background for exemple:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ruuRzGoUopxXtpgSIQkq0w.png" /><figcaption>Rectangle forms of same color as report background hide part of the map and gaph on top.</figcaption></figure><p>And you, what are your favorite Data Studio tricks ?</p><p><strong>UPDATE : </strong>as mentioned in the comments and on Twitter some tricks described here were already published, although the solutions differ a little, by another user <a href="https://medium.com/u/6c55cf407ca4">Mehdi Oudjida</a> on his blog (<a href="https://www.wissi.fr/blog/analytics/20190529/google-data-studio-internal-links/">here</a> and <a href="https://www.wissi.fr/blog/analytics/20190527/google-data-studio-create-a-single-dimension-bar-chart-with-color-by-dimension-value/">here</a>) which I was not aware at the time of writing.</p><h3>Thanks for reading ! If you enjoyed this article, don’t hesitate to share it.</h3><p><em>I am learning everyday, if I made any mistake please feel free to correct me and add your suggestions in the comment section.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=422cfc1657d6" width="1" height="1" alt=""><hr><p><a href="https://medium.com/google-cloud/4-data-studio-tricks-for-nice-looking-reports-422cfc1657d6">4 Data Studio tricks for nice-looking reports</a> was originally published in <a href="https://medium.com/google-cloud">Google Cloud - Community</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Which BI tool for BigQuery ?]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/google-cloud/which-bi-tool-for-big-query-d9eb838ff7ad?source=rss-74a2acdf7f3e------2"><img src="https://cdn-images-1.medium.com/max/2600/0*SG8i2SuSrJwmi7x6" width="3008"></a></p><p class="medium-feed-snippet">How do the most popular BI tools compare when it comes to Google powerful analytics engine&#xA0;?</p><p class="medium-feed-link"><a href="https://medium.com/google-cloud/which-bi-tool-for-big-query-d9eb838ff7ad?source=rss-74a2acdf7f3e------2">Continue reading on Google Cloud - Community »</a></p></div>]]></description>
            <link>https://medium.com/google-cloud/which-bi-tool-for-big-query-d9eb838ff7ad?source=rss-74a2acdf7f3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/d9eb838ff7ad</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[tableau]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <dc:creator><![CDATA[Rémy DAVID]]></dc:creator>
            <pubDate>Thu, 04 Apr 2019 20:43:20 GMT</pubDate>
            <atom:updated>2019-08-06T07:12:15.713Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Organize your spreadsheets for Data Analysis and Visualization]]></title>
            <link>https://medium.com/data-science/organize-your-spreadsheets-for-data-analysis-and-visualization-b1985a31523a?source=rss-74a2acdf7f3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/b1985a31523a</guid>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[google-cloud-platform]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Rémy DAVID]]></dc:creator>
            <pubDate>Mon, 04 Mar 2019 15:40:23 GMT</pubDate>
            <atom:updated>2020-04-07T20:58:22.278Z</atom:updated>
            <content:encoded><![CDATA[<h3>Organize Your Spreadsheets for Data Analysis and Visualization</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*NF-W26R476glLpsZ" /><figcaption>Photo by <a href="https://unsplash.com/@mbaumi?utm_source=medium&amp;utm_medium=referral">Mika Baumeister</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Spreadsheet softwares allow us to analyse large amount of data to get new insights on process or business. We all have tons of spreadsheets full of data sitting on our hard drives, but it is not always easy to exploit this data. The main reason is that we often tend to organize our spreadsheets for <em>human </em>analysis.</p><p>The thing is, computers do not think the same ways as we do, us mere humans. In this article I will give you some best practices to organize your spreadsheet for data analysis and visualization with your favorite spreadsheet software or, better, with external tools such as <a href="https://datastudio.google.com/u/0/">Data Studio</a>.</p><h3>Dimensions and Metrics</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FUzAyngspqDFJxBxllkyUA.png" /><figcaption>Dimensions and Metrics (ruler by monkik on FlatIcon)</figcaption></figure><p>It is important to understand that any data can be divided between <em>Dimensions</em> and <em>Metrics.</em></p><p><em>Metrics</em> <strong>measure</strong>, well, things. Metrics are always numbers and can be aggregated using formulas such as sums, average, etc. You will also sometime come across the term <em>fact </em>or<em> measure,</em> which are synonyms<em>.</em></p><p><em>Dimensions</em> are used to <strong>describe</strong> your metrics. Dimensions can be any kind of data, but is generally a date or some text (e.g. a property like color, a category like gender, etc.). You will also sometime come across the term <em>segment</em>.</p><p><em>Dimension values</em>, the data contained by the dimension, are names, descriptions or other characteristics of a category (e.g. for the color dimension: red, blue, yellow).</p><p>Good spreadsheet design is all about storing your dimensions and metrics in a way that will allow easy filtering and pivots on your dimensions and easy aggregation for your metrics.</p><h3>Unpretty your spreadsheets</h3><p>Before studying how to store the data let’s first look at the spreadsheet organisation. Designing for data analysis by automated tools is not the same as for sharing some graph to your favorite colleague from the marketing department.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fFUFSeEyv1vT_GQPWSo9ug.png" /><figcaption>Step 1 : unpretty your spreadsheets</figcaption></figure><ul><li>Remove merged cells : merged cells can’t be used in pivot and are not well supported by external tools</li><li>Remove multi-line headers</li><li>Remove titles, formatting, file version, date and authors (use the <a href="https://support.google.com/docs/answer/190843?co=GENIE.Platform%3DDesktop&amp;hl=en">file history and versioning</a> for that)</li></ul><h3>Untidy your data</h3><p>Now let’s take a look at the way to store your data :</p><ul><li>Each row must represent one <strong>unaggregated</strong> measure</li><li>Each cell must contain only one dimension or measure</li><li>Each column must have a unique name</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/550/0*uH58gkZlDU8BgDij" /><figcaption>Step 2 : Untidy your data (credit : Ethan P. White et al. in Ideas in Ecology and Evolution)</figcaption></figure><p>We also naturally tend to store our data already pivoted, because it often makes sense for what we are doing or it saves us from some repeated data. However, the key to fully exploit your data is to store it unprocessed in the <strong>rawest possible way</strong>, and that means unpivoted.</p><p>If you are not sure what that means, just remember to <em>use one and </em><strong><em>only one </em></strong><em>column for each type of dimension and metric</em>.</p><p>In the exemple above, <em>HabitatX</em>, <em>HabitatY</em> and <em>HabitatZ</em> are dimension values of the same dimension : they must be stored in the same column. The thing they measure, abundance, must also be stored in the same column. After unpivot we are able to filter and pivot on the habitat dimension and aggregate the abundance metric, which was not possible with the original format.</p><h3>Separate source data from analysis</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/826/1*5cXcgKnuL-UP-sGhJWc7OA.png" /><figcaption>Step 3 : separate data from analysis</figcaption></figure><p>You should keep your raw source data in one tab, untouched, then in one or several other tabs, have the views and analysis of the original data. To import data from another tab, use the following import statement :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/471/1*2mvMAPyHOwG2nl59X-wogg.png" /><figcaption>Import data from another tab</figcaption></figure><p>Or inside a formula :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/532/1*kGkojM2nG9I0H3plx5UV8A.png" /><figcaption>Import data from another tab in a formula</figcaption></figure><h3>Wrap up</h3><p>Following those steps, here is the transformation of my sample sheet :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RLO1n5VUM4uD6BL_nVBU1Q.png" /></figure><p>When using the pivot function we go from this situation where pivot dimensions are named from cryptic column letters :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-zY3z-kqKQS4XZWaOuP9fg.png" /></figure><p>To this much meaningful situation :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ILD-I--xb09KHwFgt-ZGHQ.png" /></figure><p>Notice how automated suggestions also now make much more sense and how we separated raw data from analysis in different tabs.</p><p>We are now also able to filter and aggregate by site and KPI dimensions which was not possible before :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DUAxvtRhBSlWqAwOA4-HDg.png" /></figure><p>To go a step further, the data is now ready to be analysed or exposed to the world using a data visualization tool like Data Studio !</p><h4>Thanks for reading ! If you enjoyed this article, don’t hesitate to share it.</h4><p><em>I am learning everyday, if I made any mistake please feel free to correct me and add your suggestions in the comment section.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b1985a31523a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/organize-your-spreadsheets-for-data-analysis-and-visualization-b1985a31523a">Organize your spreadsheets for Data Analysis and Visualization</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Serverless Chrome automation with GCP]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/google-cloud/serverless-chrome-automation-with-gcp-849e5c7b16f4?source=rss-74a2acdf7f3e------2"><img src="https://cdn-images-1.medium.com/max/1920/1*xL6TURKo80XR2SPWvTsYiw.jpeg" width="1920"></a></p><p class="medium-feed-snippet">Google Data Studio is an amazing free tool allowing anyone to quickly build nice and easy to share dashboards out of pretty much any kind&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/google-cloud/serverless-chrome-automation-with-gcp-849e5c7b16f4?source=rss-74a2acdf7f3e------2">Continue reading on Google Cloud - Community »</a></p></div>]]></description>
            <link>https://medium.com/google-cloud/serverless-chrome-automation-with-gcp-849e5c7b16f4?source=rss-74a2acdf7f3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/849e5c7b16f4</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[nodejs]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[google-cloud-platform]]></category>
            <category><![CDATA[javascript]]></category>
            <dc:creator><![CDATA[Rémy DAVID]]></dc:creator>
            <pubDate>Tue, 04 Dec 2018 12:45:10 GMT</pubDate>
            <atom:updated>2019-03-06T21:01:27.897Z</atom:updated>
        </item>
    </channel>
</rss>