<?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 Sumit Sharma on Medium]]></title>
        <description><![CDATA[Stories by Sumit Sharma on Medium]]></description>
        <link>https://medium.com/@sumitsharma_67300?source=rss-7bd42ccea6b8------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*l1ZSrfMOaqAKmu7y.</url>
            <title>Stories by Sumit Sharma on Medium</title>
            <link>https://medium.com/@sumitsharma_67300?source=rss-7bd42ccea6b8------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 07:35:50 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@sumitsharma_67300/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[Storytelling in Tableau: Terrorism through the years (1970–2016)]]></title>
            <link>https://medium.com/@sumitsharma_67300/storytelling-in-tableau-terrorism-through-the-years-1970-2016-d96d05ebe93d?source=rss-7bd42ccea6b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/d96d05ebe93d</guid>
            <category><![CDATA[refugees]]></category>
            <category><![CDATA[violence]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[terrorism]]></category>
            <category><![CDATA[tableau]]></category>
            <dc:creator><![CDATA[Sumit Sharma]]></dc:creator>
            <pubDate>Wed, 29 Nov 2017 11:00:24 GMT</pubDate>
            <atom:updated>2017-11-29T11:00:24.686Z</atom:updated>
            <content:encoded><![CDATA[<p><em>24th November 2017, London</em>. ‘Gunshot claim sparked Oxford Circus security alert, initially assumed to be a terror attack’</p><p><em>26th November 2017. </em>9th Anniversary of the Mumbai Terror Attacks. An incident etched in my childhood memory when I was glued to the television screens watching the drama unfold over 4 days.</p><p>And who can forget 9/11…the worst terror attack in world history!</p><p>It would not be wrong to say that we live in a world of terror threats. This past weekend as I sat wondering how big this problem is, I thought about using Tableau to do some analysis. I set out with these initial questions: How big is the problem? Who does it affect most? How does it affect? What does the future hold?</p><p>A quick Google search revealed that there is an open source database of terror attacks from 1970 to 2016 (apart from 1993), the Global Terrorism Database (GTD) maintained by the National Consortium for the Study of Terrorism and Responses to Terrorism (START) at the University of Maryland, United States. As I started working on this story, I blended data from other sources like 2016 HDR Report by United Nations Development Programme, UNHCR Asylum Seekers Report 2016 and Global Terrorism Index Report 2016, Institute for Economics and Peace.</p><p>I am using Tableau Public to share my analysis with a broader audience and to get suggestions from the community on how to improve this further (my first Tableau Public workbook!). The workbook link is below for everyone to analyse.</p><p><a href="https://public.tableau.com/views/Terrorismthroughtheyears1970-2016/Story-Terrorism?:embed=y&amp;:display_count=yes&amp;publish=yes">Tableau Public</a></p><p><strong>Question 1: How bad is the problem?</strong></p><p>The first page reveals a staggering fact that almost 85% of the world has been affected at some point of time. The casualties from terror attacks have been on the rise, the past 3 years being the worst. Selecting 2016 on the line chart reveals that 92 countries were affected last year, not a small number by any means.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*i1qARmiZXUmlLaMXEXPtIQ.jpeg" /><figcaption>Figure 1: Timeline of events</figcaption></figure><p><strong>Question 2: Are some regions more dangerous?</strong></p><p>Using this bump chart visual, it was easy to see the shift in the terrorism related casualties over the decades. Middle East &amp; North Africa and South Asia are the most dangerous places on the planet currently. On the other hand, Central America &amp; Caribbean region has become safer.</p><p><strong>Question 3: How does the current decade look like?</strong></p><p>This view is filtered to show a map for the 2 most affected regions in the world and the top 10 worst affected countries in them. If needed, one can change the filter selections on the right to view information about any time period, region or target type.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/228/1*FBiOLcmCK3axkuAUizl2Ew.png" /><figcaption>Figure 2: Filters</figcaption></figure><p>Hovering over a country in the chart, we can easily see the split by target types:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*on3hH8iU1dIKAtuTEg838w.jpeg" /><figcaption><em>Figure 3: Top 10 Worst Affected Countries tooltip</em></figcaption></figure><p>Clicking on a country will filter the map to show incidents specific to that country. To view details on incident, hover on the red dots.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uat4GKNqvIqKtoJbeO3kIw.jpeg" /><figcaption><em>Figure 4: Incident map tooltip</em></figcaption></figure><p><strong>Question 4: Does terrorism lead to displacement?</strong></p><p>Well we know it does, but does data support it? I found that 4 of the Top 5 most affected countries in 2015 are in the top 6 source countries of asylum seekers. This view is based on the UNHCR Asylum Seekers Report and is for a single year. We can easily see the Top Sources, Top Destinations and the flow of people from Source to Destination in the map.</p><p>If interested in seeing data for a country, one can filter the country name and select to view the country as origin or destination. Hovering over the lines on map will reveal additional details. An example is below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oJxtSloCpOqLl6lQ_9IFLg.jpeg" /><figcaption><em>Figure 5: Flow Map</em></figcaption></figure><p><strong>Question 5: Does terrorism affect development?</strong></p><p>For this, I used the Global Terrorism Index Report 2016 and the 2016 HDR Report for a sample set of countries. As can be seen clearly, the developed world has a better HDI score while the developing world is still on low to average HDI scores, security being one of the factors affecting development. Due to incidents in the past few years, countries like France, United States and United Kingdom are on a higher GTI ranking.</p><p><strong>Question 6: What does the future hold?</strong></p><p>Doing some forecasting in Tableau, the trend does not look good.</p><p>Developing countries have been affected by terrorism, both internal and international over the past 4 decades, which has led to a multitude of problems for millions of civilians. In recent years, we have seen the effects percolate to the developed world as well. The fact that the total casualties in the developed world (Western Europe and North America were picked for this analysis) have increased by 1697% in the past 2 years is alarming. Terrorism is no longer a third world problem, it touches every nationality and region. It needs a solution.</p><p><strong>To the world who is closing borders on countless immigrants and refugees</strong>, I would question:</p><p>Would people want to migrate and become refugees in a foreign land if their countries were safe?</p><p><strong>To those who do nothing about the terrorism in their countries</strong>, the quote below sums it up:</p><p><em>Terrorism will spill over if you don’t speak up </em>— <strong><em>Malala Yousafzai, Nobel Laureate</em></strong></p><p>The purpose of the above post was to present facts based on data. The choice of red colour, especially on the incident map is intentional. Some would say that we should keep emotions separate from data visualisation. In this case, however I would argue that it is very needed as it would invoke thought even if for half a minute, something if we all do might make the world a better place. One step at a time.</p><p>— — — — — — — — — — — — — — — — — — — — — — — — — — — — — — —</p><p><em>Sumit is a Business Intelligence and Analytics Consultant. Get in touch with me if you would like to discuss anything in this sphere.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d96d05ebe93d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Agile in BI and the VUCA world]]></title>
            <link>https://medium.com/thorogood-associates/agile-in-bi-and-the-vuca-world-8142e54eac9b?source=rss-7bd42ccea6b8------2</link>
            <guid isPermaLink="false">https://medium.com/p/8142e54eac9b</guid>
            <category><![CDATA[scrum]]></category>
            <category><![CDATA[agile]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[Sumit Sharma]]></dc:creator>
            <pubDate>Wed, 12 Apr 2017 13:37:00 GMT</pubDate>
            <atom:updated>2017-04-12T13:37:00.350Z</atom:updated>
            <content:encoded><![CDATA[<p><em>“The need to be Agile is more now than ever in this VUCA world”</em></p><p>Agile came into being way back in 2001 when an enthusiastic bunch of individuals at a Utah ski resort felt the need to come up with an alternative way of traditional software development. Agile is now becoming the buzzword and the need of the hour in the DW/BI world as well. And why? The world is VUCA and the traditional methods present a contradiction to it.</p><p>Requirements, systems, and even entire businesses are prone to changes in a short time and this presents an issue with the traditional development approach where the delivery cycles can be 6 months to 1 year or more. This means that many traditional projects can end up being cancelled mid-way and requirements may not meet the current needs at the time of delivery, even though they were very much applicable at the start of the project (and signed off). Agile, on the other hand, places more power in the hands of the business, to decide the priority based on the importance of features at a given point in time and release them in an incremental manner. Requirements may change based on feedback from users and the feature priority and direction of delivery can be modified accordingly. Agile may also help you to fail faster than in a traditional project.</p><p>The success of a traditional project is judged based on whether it is on time, on budget and to specifications. While this may keep the manager and stakeholders happy, it might not have a direct correlation with user satisfaction. Agile project can never deliver all features (user requirements are never ending), but it delivers the highest quality features, minimizing the cost of delay and maximizing the ROI.</p><p>It is important to remember that Agile is a philosophy that lays emphasis on people, collaboration and values to ensure a sustainable delivery pace. Agile has the following 4 focus areas (from the <strong>Agile Manifesto</strong>):</p><p><em>Individuals and interactions over processes and tools</em></p><p><em>Working software over comprehensive documentation</em></p><p><em>Customer collaboration over contract negotiation</em></p><p><em>Responding to change over following a plan</em></p><p>That is, while there is value in the items on the right, we value the items on the left more. Isn’t it how a system should anyways be developed?</p><p>It is important to acknowledge that BI systems are fundamentally different from application software. Multiple layers of technology are involved (back-end and ETL, OLAP, Reporting), the data architecture is complex, and the data volumes are huge. While BI developers can well appreciate these complexities, the business users are more concerned about the presentation of correct information, possibly in the form of reports, that helps them to make better business decisions or solve a business problem.</p><p>Owing to these complexities, the BI systems cannot be judged by the same scale as application software. Even within the BI landscape, there can be a lot of different types of projects. It is important that we keep the Agile practices and methods that work well, improve those that allow room for improvement, and replace those that are problematic.</p><p>So the question arises as to <strong>how we can apply Agile to a BI project?</strong> Some observations on this are below:</p><p>1. <strong>Complex data architecture</strong></p><p>We can’t design 1/10th of an enterprise data warehouse in a sprint and leave the rest to later sprints. This is an example of the whole being greater than the sum of the parts. At the beginning, we need a holistic view of the business to determine the most appropriate way to use the model and to identify areas of overlap or conflict, so that user stories can be planned better. Having a Sprint 0 in this case will help. Not doing this in the beginning may lead to having to rework the entire architectural slice in subsequent sprints.</p><p>2. <strong>Dependencies between the architecture layers</strong></p><p>Consider this case: ETL development can’t start until source mappings and data model design is completed. Cube development can’t start until ETL has populated the database. Report development can’t start until there is data in the cube. There can also be cases where at a given point of time, only one developer can work on a particular layer. If this is the scenario you foresee, it is best to plan the resourcing appropriately at the beginning of the project so that you don’t have too many underutilised people on the project. As part of the sprint planning, the dependencies should be captured and user stories should be prioritised to keep the entire team busy.</p><p>3. <strong>Huge data volumes</strong></p><p>This is more of an impediment rather than a barrier. We need to creatively think and design in a way that the system will work with increasing production data volumes. Code refactoring should be done every now and then to avoid performance issues as the system evolves.</p><p>This brings us to our next question. <strong>Can Agile be applied to all BI projects? </strong>Well, the answer is “it depends”. Agile is an ideal candidate in the following scenarios:</p><ul><li>Problems are complex, solutions are unknown, and the scope isn’t clearly defined.</li><li>Collaboration with business owner and end users is possible. In most cases, a Product Owner (who represents the business) available full time is a must.</li><li>Releases are regular. Incremental developments have value and will be used by the end users immediately.</li><li>Business processes support the Agile ways of working, be it in terms of infrastructure enhancements or deployments.</li><li>Business understands that the cost may be higher in the beginning (as the team is new and getting used to the process) but over the long term as the team finds its true velocity and reaches the performing stage, there will be less technical debt and more ROI as compared to traditional projects.</li><li>Contracts also support Agile ways of working.</li></ul><p>If you can tick all the boxes above, then your project is a true candidate for Agile. The debate will always be open on whether Agile is better or not. The only answer to that is: “It depends!”.</p><p>Don’t forget to share your comments or feedback below.</p><p>— — — — — — — — — — — — — — — — — — — — — — — — — — — — — — —</p><p><em>Sumit is a Business Intelligence and Analytics Consultant and a Certified Scrum Master. Get in touch with me if you would like to discuss anything in this sphere.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8142e54eac9b" width="1" height="1" alt=""><hr><p><a href="https://medium.com/thorogood-associates/agile-in-bi-and-the-vuca-world-8142e54eac9b">Agile in BI and the VUCA world</a> was originally published in <a href="https://medium.com/thorogood-associates">Thorogood Associates</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>