<?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 Deepal Dsilva on Medium]]></title>
        <description><![CDATA[Stories by Deepal Dsilva on Medium]]></description>
        <link>https://medium.com/@dsilvadeepal?source=rss-6aeae833fda6------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*UsN1v555xm83T8gFi8Um8w.jpeg</url>
            <title>Stories by Deepal Dsilva on Medium</title>
            <link>https://medium.com/@dsilvadeepal?source=rss-6aeae833fda6------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 13:08:34 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@dsilvadeepal/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[Let’s Build A Cumulative Time Series Line Chart]]></title>
            <link>https://medium.com/tech-career-nuggets/lets-build-a-cumulative-time-series-line-chart-62cce6e7a754?source=rss-6aeae833fda6------2</link>
            <guid isPermaLink="false">https://medium.com/p/62cce6e7a754</guid>
            <category><![CDATA[salesforce]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[einstein-analytics]]></category>
            <dc:creator><![CDATA[Deepal Dsilva]]></dc:creator>
            <pubDate>Wed, 27 May 2020 20:13:19 GMT</pubDate>
            <atom:updated>2020-06-12T23:48:36.911Z</atom:updated>
            <content:encoded><![CDATA[<h3>Let’s Build A Cumulative Time Series Line Chart <em>with Einstein Analytics</em></h3><p><em>A Step-by-Step Guide</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*JMx9G7X2GwUh_tR1" /><figcaption>Photo by <a href="https://unsplash.com/@campaign_creators?utm_source=medium&amp;utm_medium=referral">Campaign Creators</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h4>What is a Cumulative Chart?</h4><p>It is a line chart of a metric you want to show on the y-axis that is summed across time on the x-axis.</p><p>Here I chose spending amount vs months to create a line chart vs a cumulative chart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6QsJWaqd_T7RzSwCHBIbeA.png" /><figcaption>Cumulative Line Chart vs Line Chart</figcaption></figure><h4>Where can I use it?</h4><p>Some examples are tasks completed over months, spending analysis over time, tracking goal metrics towards a target date, tracking project budgets, inventory levels etc. Almost anything you want to measure over time can be displayed in a cumulative chart.</p><h4>Data Prep</h4><p>To start with let’s look at the data we have. I created some sample data using <a href="https://mockaroo.com/"><strong>Mockaroo</strong></a>. If you are new to Mockaroo <a href="https://www.instagram.com/p/CAVEuFOILZ1/">check this post out</a>.</p><p>Here we have data on number of visitors at a branch spread across a year.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/394/1*F51Qy7N9IsZsiuq_eVAY_A.png" /><figcaption>Sample data</figcaption></figure><p>We want to create a cumulative chart to see the number of visitors at the branch for the year.</p><h4>Let’s Build</h4><ul><li>Go to dashboard and create a <strong>new chart</strong>.</li><li>Choose number of visitors for the bar length and date(year-month-day) for the bars.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dYmVABFug3hObJekv6FWKw.png" /></figure><ul><li>Next go to Table Mode and select <strong>Compare Table</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*QJWgq8eq5aksq5jVqQ7XbA.png" /></figure><ul><li>Then select the column Sum of Number of Visitors and <strong>Clone Column</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/424/1*pS14Pv0n_0gmc-IaUlcoNQ.png" /></figure><ul><li>Next we will edit the new column we created. Select the column and click <strong>Edit</strong> <strong>this</strong> <strong>Column</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/516/1*LLAmP1ddBPDredwGznXAJA.png" /></figure><ul><li>Select function and then choose <strong>Running Total</strong>. Leave the column and reset group dropdown as is. Give the new column a name &amp; header and <strong>apply</strong> your changes.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1oUQJXakYYra_0CtV94wuA.png" /></figure><ul><li>Click <strong>Close</strong> to go back and then select the chart mode. Now that we have our cumulative total all that we have to do is some cleaning up to get the chart in order. Here’s how it will look right now.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wWK3Da9KYaxT6enFKFtgzQ.png" /></figure><ul><li>Go the the original column and <strong>hide</strong> it. You cannot delete it since it is being referenced by the cumulative chart.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/492/1*EQUbCBaISHGm6jQYNSEiRw.png" /></figure><ul><li>Now go to charts and select <strong>timeline chart</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/458/1*Ry6HOpXkuEFz_T5m0Fhhog.png" /></figure><ul><li>This will now provide you a day wise cumulative of the number of visitors at a branch.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BIFwvb-b6IhoEqMv1lSUmw.png" /><figcaption>Timeline Chart</figcaption></figure><p><strong>Here’s how a cumulative line chart compares to a simple line chart.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0jO3rFVQA8VHTnc6gdvOiA.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=62cce6e7a754" width="1" height="1" alt=""><hr><p><a href="https://medium.com/tech-career-nuggets/lets-build-a-cumulative-time-series-line-chart-62cce6e7a754">Let’s Build A Cumulative Time Series Line Chart</a> was originally published in <a href="https://medium.com/tech-career-nuggets">Tech &amp; Career Nuggets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Strategy for your Organization- Why’s and How’s]]></title>
            <link>https://medium.com/tech-career-nuggets/data-strategy-for-your-organization-whys-and-how-s-2e3125aaa08c?source=rss-6aeae833fda6------2</link>
            <guid isPermaLink="false">https://medium.com/p/2e3125aaa08c</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[business-strategy]]></category>
            <category><![CDATA[data-strategy]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[organizational-change]]></category>
            <dc:creator><![CDATA[Deepal Dsilva]]></dc:creator>
            <pubDate>Wed, 17 Apr 2019 21:22:57 GMT</pubDate>
            <atom:updated>2020-05-27T19:53:17.022Z</atom:updated>
            <content:encoded><![CDATA[<p>These days most organizations have jumped on the bandwagon of hiring data scientists, data engineers, data analysts and the never-ending jumble of titles referring to data people.</p><p>Ever since Big Data flooded the scene, organizations have been collecting vast amounts of data from multitudes of sources, not to mention the amounts of unstructured data that gets generated.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vtsRvMpdP_IY56ni5Xm3dg.jpeg" /><figcaption>Data Strategy for your Business</figcaption></figure><p><strong>Why you need a data strategy for your organization:</strong></p><ul><li><strong>Increase business value</strong> — Data collected must help business reach it goals and visions. Data collected across the organization should have a common goal. Eg. Marketing and sales data should be in sync to enable business to grow.</li><li><strong>Improve data accuracy</strong> — Having a proper data discovery pipeline enables organizations to collect accurate data. They can hence draw actionable insights from data with having to worry about the veracity or the shelf-life of the data.</li><li><strong>Increase work turnaround time</strong> — Employees can focus on garnering insights and stakeholder on making decisions rather than spend hours/days identifying the right data source and gathering data.</li></ul><p><strong>Two key ways I see that would enable organizations to adopt a data driven path are:</strong></p><ul><li><strong>Have a Chief Data Officer</strong> — They would be entirely responsible for the organization wide adoption and use of data. They would have to be in line with the organization’s vision and goals to develop a data strategy for the organization.</li><li><strong>Educate employees to be data literate</strong> — Employees should have ready access to data (rather than put in a request or have someone else pull it for them). They should also be able to make sense of the data and be able to dig deeper if required to check for any anomalies.</li></ul><p>To get your organization thriving in this era where the amount of data being generated is increasing exponentially, get started with a Data Strategy!</p><h4>If you enjoyed this story, please click the 👏 button and share to help others find it!</h4><p><em>Follow me on </em><a href="https://www.instagram.com/deepaldsilva/"><em>instagram</em></a><em> at for my weekly learning progress and study resources I use.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2e3125aaa08c" width="1" height="1" alt=""><hr><p><a href="https://medium.com/tech-career-nuggets/data-strategy-for-your-organization-whys-and-how-s-2e3125aaa08c">Data Strategy for your Organization- Why’s and How’s</a> was originally published in <a href="https://medium.com/tech-career-nuggets">Tech &amp; Career Nuggets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Ham or Spam? SMS Text Classification with Machine Learning]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/tech-career-nuggets/sms-text-classification-a51defc2361c?source=rss-6aeae833fda6------2"><img src="https://cdn-images-1.medium.com/max/600/1*7LNPizh5WswwxwGzMT1YOg.jpeg" width="600"></a></p><p class="medium-feed-snippet">A Naive Bayes Implementation in R</p><p class="medium-feed-link"><a href="https://medium.com/tech-career-nuggets/sms-text-classification-a51defc2361c?source=rss-6aeae833fda6------2">Continue reading on Tech &amp; Career Nuggets »</a></p></div>]]></description>
            <link>https://medium.com/tech-career-nuggets/sms-text-classification-a51defc2361c?source=rss-6aeae833fda6------2</link>
            <guid isPermaLink="false">https://medium.com/p/a51defc2361c</guid>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Deepal Dsilva]]></dc:creator>
            <pubDate>Tue, 14 Aug 2018 22:04:03 GMT</pubDate>
            <atom:updated>2019-04-17T00:13:30.038Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[How To Identify The Best Resources To Be A Self-Taught Data Scientist]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/tech-career-nuggets/how-to-identify-the-best-resources-to-be-a-self-taught-data-scientist-33f954f67f69?source=rss-6aeae833fda6------2"><img src="https://cdn-images-1.medium.com/max/1920/1*biz45ojDGZrpw4eN_d5RUQ.jpeg" width="1920"></a></p><p class="medium-feed-snippet">And Some Resources I Love</p><p class="medium-feed-link"><a href="https://medium.com/tech-career-nuggets/how-to-identify-the-best-resources-to-be-a-self-taught-data-scientist-33f954f67f69?source=rss-6aeae833fda6------2">Continue reading on Tech &amp; Career Nuggets »</a></p></div>]]></description>
            <link>https://medium.com/tech-career-nuggets/how-to-identify-the-best-resources-to-be-a-self-taught-data-scientist-33f954f67f69?source=rss-6aeae833fda6------2</link>
            <guid isPermaLink="false">https://medium.com/p/33f954f67f69</guid>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[education]]></category>
            <dc:creator><![CDATA[Deepal Dsilva]]></dc:creator>
            <pubDate>Wed, 18 Jul 2018 13:09:07 GMT</pubDate>
            <atom:updated>2020-05-27T19:56:42.896Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Learn To Create Your Own Datasets — Web Scraping in R]]></title>
            <link>https://medium.com/tech-career-nuggets/learn-to-create-your-own-datasets-web-scraping-in-r-f934a31748a5?source=rss-6aeae833fda6------2</link>
            <guid isPermaLink="false">https://medium.com/p/f934a31748a5</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[r-programming]]></category>
            <category><![CDATA[web-scraping]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Deepal Dsilva]]></dc:creator>
            <pubDate>Fri, 04 May 2018 13:39:08 GMT</pubDate>
            <atom:updated>2020-05-27T19:55:30.495Z</atom:updated>
            <content:encoded><![CDATA[<h3>An rvest tutorial</h3><p>I was recently looking for a dataset to perform sentiment analysis on popular pop song lyrics. I went through a lot of sites providing free datasets but didn’t find any that met my need. This prompted me to create my own dataset.</p><blockquote>If you can’t find a way, create one.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NSN1a2xVtV1exzcD8fpzhA.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/photos/p-xSl33Wxyc?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Farzad Nazifi</a> on <a href="https://unsplash.com/search/photos/computer-headphone-lyrics?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><h4>What is Web Scraping?</h4><p>There is a lot of data on websites, but not always will you find a way to download this data. Web scraping is a process of extracting unstructured data from websites into a structured format so that you can perform further analysis on it.</p><h4>What is the rvest package?</h4><p><a href="https://github.com/hadley/rvest"><strong>rvest</strong></a> is a R package created by Hadley Wickham to scrape information from web pages. It is mainly inspired from the popular Python library <a href="https://www.crummy.com/software/BeautifulSoup/">beautiful soup</a>.</p><p>In this example I followed a two part process to get the lyrics of the most popular songs from the top 10 artists:</p><ol><li>I used <strong>rvest</strong> to extract the Top 10 Pop Artists of All Time from <a href="https://www.billboard.com/charts/greatest-of-all-time-pop-songs-artists">billboard.com</a> .</li><li>Then I used these artists to extract their popular songs and lyrics from <a href="https://genius.com/">genius.com</a> .</li></ol><h4>Follow me on a step by step walk-through</h4><p>First of course you will need to install and load the following packages.</p><pre>library(tidyverse)<br>library(rvest)</pre><p><strong>PART 1 : Extracting the Top 10 Pop Artists of All Time</strong> — Source: <a href="https://www.billboard.com/charts/greatest-of-all-time-pop-songs-artists">www.billboard.com</a></p><ul><li>Identify the url from which you want to extract data. Then use the read_html() function to create an html document from the url.</li><li>Next you need to identify the CSS selector which points to the data you want to extract. It’s helpful if to have a little knowledge on HTML and CSS. Else you can use the handy Chrome extension <a href="http://selectorgadget.com/"><strong>SelectorGadget</strong></a> to find the CSS selector. The easiest way I found is to right-click on any page element in Chrome and select <strong>Inspect</strong> <strong>Element</strong>.</li><li>You can then use the html_nodes() function with the CSS selector to extract the data you want.</li><li>Then all you need is to save your results into a data frame. I’ve used tibbles here to store the data as it is a little easier to work with them than data frames. You can read more about the difference between data frames and tibbles <a href="http://r4ds.had.co.nz/introduction-2.html#tibbles-vs.data-frames">here</a>.</li></ul><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/ff84b9878a17e3fc250862b62211e051/href">https://medium.com/media/ff84b9878a17e3fc250862b62211e051/href</a></iframe><p><strong>PART 2 : Extracting Popular Songs and Lyrics of the top 10 Artists</strong> — Source: <a href="https://genius.com/">www.genius.com</a></p><p>Now that you have the Top 10 Pop Artists, you can use the genius.com website to identify the most popular songs and extract their lyrics.</p><ul><li>First identify the url to the artist’s webpage. A little bit of research on the website showed that all the webpages followed the below format. <em>https://genius.com/artists/&lt;artistname&gt;</em></li><li>Then use a nested for loop to extract the songs and their lyrics. Here again, I used SelectorGadget to identify the right CSS selector for the job.</li><li>Next store the results into a tibble.</li><li>And finally, don’t forget to include a random sleep interval between each loop to prevent you from getting booted from the website.</li></ul><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/c6bbd8eac0b62e75cee65eea410d523c/href">https://medium.com/media/c6bbd8eac0b62e75cee65eea410d523c/href</a></iframe><p>And here’s a snapshot of what your dataset will look like.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/691/1*kfzzwLk_fVpz97jsajXULw.png" /><figcaption>artist_lyrics tibble</figcaption></figure><p>That’s all you need to know to create your own dataset. Thus giving you endless possibilities to experiment with data you want.</p><p>Hope you enjoyed this tutorial and are now inspired to create your very own dataset.</p><p>Thanks for reading!</p><p><em>Follow me on </em><a href="https://www.instagram.com/deepaldsilva/"><em>instagram</em></a><em> at for my weekly learning progress and study resources I use.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f934a31748a5" width="1" height="1" alt=""><hr><p><a href="https://medium.com/tech-career-nuggets/learn-to-create-your-own-datasets-web-scraping-in-r-f934a31748a5">Learn To Create Your Own Datasets — Web Scraping in R</a> was originally published in <a href="https://medium.com/tech-career-nuggets">Tech &amp; Career Nuggets</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to visualize what you have been tweeting]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/tech-career-nuggets/how-to-visualize-what-you-have-been-tweeting-81c75f00546d?source=rss-6aeae833fda6------2"><img src="https://cdn-images-1.medium.com/max/940/1*c4JfsP1tnptisFAUvMMVJg.png" width="940"></a></p><p class="medium-feed-snippet">A wordcloud experiment in R</p><p class="medium-feed-link"><a href="https://medium.com/tech-career-nuggets/how-to-visualize-what-you-have-been-tweeting-81c75f00546d?source=rss-6aeae833fda6------2">Continue reading on Tech &amp; Career Nuggets »</a></p></div>]]></description>
            <link>https://medium.com/tech-career-nuggets/how-to-visualize-what-you-have-been-tweeting-81c75f00546d?source=rss-6aeae833fda6------2</link>
            <guid isPermaLink="false">https://medium.com/p/81c75f00546d</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[technology]]></category>
            <dc:creator><![CDATA[Deepal Dsilva]]></dc:creator>
            <pubDate>Wed, 18 Apr 2018 15:46:11 GMT</pubDate>
            <atom:updated>2018-04-23T23:27:12.615Z</atom:updated>
        </item>
    </channel>
</rss>