<?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 Lokeswari Gedela  on Medium]]></title>
        <description><![CDATA[Stories by Lokeswari Gedela  on Medium]]></description>
        <link>https://medium.com/@lokeswariamarapu?source=rss-b938cae0390a------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*dmbNkD5D-u45r44go_cf0g.png</url>
            <title>Stories by Lokeswari Gedela  on Medium</title>
            <link>https://medium.com/@lokeswariamarapu?source=rss-b938cae0390a------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 07:17:35 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@lokeswariamarapu/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[“Visualizing Monthly Sales: A Guide to creating a Calendar Circle Chart in Tableau”]]></title>
            <link>https://medium.com/@lokeswariamarapu/visualizing-monthly-sales-a-guide-to-creating-a-calendar-circle-chart-in-tableau-09f098f7b520?source=rss-b938cae0390a------2</link>
            <guid isPermaLink="false">https://medium.com/p/09f098f7b520</guid>
            <dc:creator><![CDATA[Lokeswari Gedela ]]></dc:creator>
            <pubDate>Mon, 19 Feb 2024 10:20:50 GMT</pubDate>
            <atom:updated>2024-02-20T06:59:55.816Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/659/1*ohv3MlfQE0TFBCdKmtKGkg.png" /><figcaption>Image by Author</figcaption></figure><p>In the realm of data visualization, Tableau is a very powerful data visualization and analysis tool that was designed to enable you to perform complex data analysis tasks and create powerful, interactive visualizations that communicate the analysis. One such visualization is the Calendar Circle Chart, an effective way to showcase monthly sales over time from the renowned Sample Superstore dataset.</p><p>In this blog post, we’ll explore how to leverage Tableau’s capabilities to craft a Calendar Circle Chart that vividly displays monthly sales data. Whether you’re a seasoned Tableau user or just starting your data visualization journey, this guide will provide step-by-step instructions to create a visually compelling representation of your sales performance throughout the year. Let’s dive in and unlock the potential of Tableau to transform your data into actionable insights.</p><p><strong>Step 1</strong>: Open Tableau → Microsoft Excel → Sample Superstore dataset</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mApTlpUvUavXU8jlZibGlQ.png" /><figcaption>Image by Author</figcaption></figure><p><strong>Step 2</strong>: Go to Sheet 1 &amp; Create Parameters as shown below.</p><p>The Depth parameter with value 7 is created to adjust the depth of the calendar view indicating the number of days.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*yaeuWfc0Sw4bwg_hy0LTDw.png" /><figcaption>Parameter (Depth)</figcaption></figure><p>The Distance from center parameter is created to adjust the distance of the circles representing the data points from the center of the chart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/563/1*NlQj7IgmdKWy13bwt4ahAQ.png" /><figcaption>Parameter (Distance from center)</figcaption></figure><p><strong>Step 3:</strong> Create Calculated fields as shown below.</p><ol><li>INDEX () -1 is created so that the indexing of the dates starts from 0 instead of 1 which is the indexing convention.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/505/1*AgqfJVEKDRPUwgNVBdltcg.png" /><figcaption>Calculated Field (Index)</figcaption></figure><p>2. Multiplier (360/53) is created to determine the scaling factor, which ensures the visual representation of each data point is scaled uniformly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/496/1*dd4-ZZ_E8EllyCAD_UB2AA.png" /><figcaption>Calculated Field (Multiplier)</figcaption></figure><p>3. The purpose of creating Item is to distribute data points into different groups based on their position in the index and the depth parameter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/506/1*uv_ph7wXQkp_orf0ZJVxog.png" /><figcaption>Calculated Field (Item)</figcaption></figure><p>4. Distance is created to determine the radial distance of each circle from the center of the chart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/499/1*46DVBx4aQZoZDuDhk9YvZw.png" /><figcaption>Calculated Field (Distance)</figcaption></figure><p>5. X-coordinate represents the plotting of points on the circle. This calculation is used to determine the vertical position of each data point.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/496/1*76CpARiF-XSzjWQkGoDcqA.png" /><figcaption>Calculated Field (X)</figcaption></figure><p>6. Y-coordinate represents the plotting of points on the circle. This calculation is used to determine the horizontal position of each data point.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/497/1*oUC2wjYkQPDx1aOPUs3Ixw.png" /><figcaption>Calculated Field (Y)</figcaption></figure><p><strong>Step 4</strong>: Filtering → Drag Order Date to Filters → Select Year → Next → Select 2021</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/668/1*LK7d0w688lAn836SPYiaxg.png" /><figcaption>Filter applied on Order Date</figcaption></figure><p><strong>Step 5:</strong> Drag Order Date to Rows → Select Exact Date, Discrete &amp; Show missing values → Drag Order Date to Detail</p><p><strong>Step 6: </strong>Drag X field to Columns &amp; Y field to Rows → Right click on X &amp; Y → Select Compute using Order Date for both X &amp; Y</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/474/1*qG5d1aYe1F4o5xfNOo-bug.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/465/1*QlUHu-UEj7V32i4W9wpORg.png" /></figure><p><strong>Step 7:</strong> Drag Order Date to Colors → Select Month → Select Size &amp; slightly increase the size of the circle → Select Shapes &amp; click on Filled Circle</p><p>A vibrant Calendar Circle will be created.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*xl1-tQr-zjjZX-pm6v1T5w.png" /></figure><p><strong>Step 8:</strong> Formatting</p><p>Right click on the chart → Select Format → Select Lines → Select None for both Grid Lines &amp; Zero Lines</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/264/1*g8yvn5B27abzh1z6u76tEQ.png" /></figure><p><strong>Step 9:</strong> Right click on both X Axis &amp; Y Axis → Uncheck Show Header to hide them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/499/1*vaqfw6yrnX7KGDr5nk8Znw.png" /></figure><p><strong>Step 10:</strong> Drag Sales to Tool tip → Click on Tool tip → Delete X along Order Date &amp; Y along Order Date</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/1*oZM1nvC1ciQSr0sYWkHeGQ.png" /></figure><p><strong>Step 11:</strong> Month wise Sales can be seen by selecting the month</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9X2XCKF5CvHY8cuT0B1H7A.png" /></figure><p>Tadaa!! Our Calendar Circle Chart is ready. Let’s create vibrant visualizations in Tableau to explore, analyze and derive actionable insights from the data.</p><p>I hope this blog helps you and encourages you to play around the visuals. Thank you!!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=09f098f7b520" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Dashboard: The Foundation of Data Visualization]]></title>
            <link>https://medium.com/@lokeswariamarapu/dashboard-the-foundation-of-data-visualization-e77f674335dd?source=rss-b938cae0390a------2</link>
            <guid isPermaLink="false">https://medium.com/p/e77f674335dd</guid>
            <dc:creator><![CDATA[Lokeswari Gedela ]]></dc:creator>
            <pubDate>Fri, 16 Feb 2024 21:21:37 GMT</pubDate>
            <atom:updated>2024-02-20T04:54:53.185Z</atom:updated>
            <content:encoded><![CDATA[<h3>Dashboard Essentials: The Foundation of Data Visualization</h3><p>Dashboards are currently experiencing unprecedented popularity. We have more data available to us all the time and better visualization tools than ever before. Essentially, a dashboard comprises charts, yet its essence extends far beyond mere data visualization. If you add some charts on a page, you would technically have a dashboard, but it might not be very effective. Creating a good dashboard takes some preparation, knowledge, and skill. Here, I introduce you to dashboards and the concepts, skills, and best practices you will need to create them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*6deVAK9088WmtG7H" /><figcaption>Image from <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><strong>What is a Dashboard?</strong></p><p>A dashboard is one or more visual elements that tell a story about related data. A report that aggregates data isn’t a dashboard because it’s not telling a story. That’s typically called a report to table, although these terms are often used to mean the same thing. For our purposes, a dashboard must contain visual elements and not just a list of data. You may improve the clarity and impact of the dashboard by using the correct visualization approaches. Effective visualization types include bar charts, line graphs, heat maps and scatter plots. It is important to select a chart or graph that effectively shows the data and support the desired findings.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4D_zeiLB2WKWXBtMIS8ZQw.png" /><figcaption>Image by Author</figcaption></figure><p>The above is an example of Tableau dashboard from the health care data, which combines a range of actionable data types, professional design with gentle-to-the eyes colors, and deep analytical view.</p><p><strong>Key Performance Indicators(KPIs)</strong></p><p>The story is the most important aspect of a dashboard. It comes from analyzing the data to determine what’s important about it. Key performance indicators (KPIs) are commonly displayed on dashboards. KPIs are ready-made stories for your dashboard to tell. The management will craft KPIs based on their understanding of the organization. If you are running a commercial business, net income is an important measurement and you don’t have to analyze the data to know that it’s something you’ll want to look at. KPIs are unique to each organization, but similar organizations will have similar KPIs. Finance departments are interested in net income, free cash flow, and working capital. And manufacturers are interested in units produced and line utilization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/821/1*M6FzJgdFq0bamncPU3JDgg.png" /></figure><p><strong>Establishing User Requirements</strong></p><p>It’s not advisable to start building a dashboard without proper planning. Similar to constructing a house, initiating dashboard development without a plan may result in the need to tear it down and restart again. To make your plan, start by finding out what the end users need. There are at least 3 users you’ll want to talk to before you begin: the person requesting the dashboard, the person providing the data, and the end user.</p><p>Finding out where the data is extracted from and if it’s already been aggregated or analyze is required. If you don’t have the data you need, your dashboard project might turn into two projects: a data-collection project and a dashboard project.</p><p><strong>Types of End Users</strong></p><p>You can divide end users by how they intend to use the dashboard to get a better understanding of how to construct it. A dashboard presented at a shareholder meeting may be used to simply give shareholders information they don’t see day to day.</p><p>It’s ideal to track the dashboard-building process from inception to completion. You don’t need fancy software for this, just a text document or a spreadsheet. Record the information about the users and the data that you’ve already discovered.</p><p>Plan on iterating through the dashboard design process. When you get a usable draft, send it to the stakeholders for input. Continue to send iterations for input throughout the process. Each iteration may involve making changes to the layout, visualizations based on the feed back from stakeholders. You can continue to work on the next stage while you wait for input, but if there are problems, you’ll save yourself a lot of rework compared to handing over a final design that’s not right. Finally, plan to review the results after the dashboard is complete.</p><p>Keep exploring, experimenting, and refining your dashboards to continuously enhance their impact and value.</p><p>“If you enjoyed reading this blog and found helpful, Please give it some applause and hit on the follow button for more insightful content on Data Visualization. Thank you!”</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e77f674335dd" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>