<?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 Amrita Rout on Medium]]></title>
        <description><![CDATA[Stories by Amrita Rout on Medium]]></description>
        <link>https://medium.com/@amritarout.as?source=rss-62d4370f4da1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*v_KB2hmEr-evFKfcGsmm4Q.png</url>
            <title>Stories by Amrita Rout on Medium</title>
            <link>https://medium.com/@amritarout.as?source=rss-62d4370f4da1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 07:54:54 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@amritarout.as/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[Forecasting in Tableau]]></title>
            <link>https://medium.com/@amritarout.as/forecasting-in-tableau-ac44ff19165b?source=rss-62d4370f4da1------2</link>
            <guid isPermaLink="false">https://medium.com/p/ac44ff19165b</guid>
            <dc:creator><![CDATA[Amrita Rout]]></dc:creator>
            <pubDate>Sat, 17 Feb 2024 01:19:35 GMT</pubDate>
            <atom:updated>2024-02-17T01:19:35.574Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*b8TAwXlxMs1O48Rj.jpg" /></figure><p>In simple word forecasting means predicting future based on current trend. In Tableau forecasting algorithms try to find a regular pattern that can be continued into the future. These algorithms are not so simple, Tableau uses these algorithms considering various factors such as seasonality, trend, and data patterns to make predictions.</p><p>Let’s see with an example. Here we are taking the famous Sample superstore dataset :)</p><h3><strong>Steps</strong></h3><ol><li>We have to connect to the data source. Once data is loaded into Tableau we will start our exploration.</li><li>For forecasting we need Date field in column. Drag Order Date into column.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GD0AXGNXb2AIRvEmay8ISQ.png" /></figure><p>3. Let’s change year to month by clicking right click on order date and also change the values from Continuous to Discreate. Then it will look like this.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DGrN8Vsg1n3fWyy37rjAHQ.png" /></figure><p>4.Place Measure in Rows. Here we are taking Category wise sum of sales in the Rows. The line chart is showing sum of sales over the year from Jan 2018 to Dec 2021.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uV7MfjopDsbXnEIEYWGZcw.png" /></figure><p>5. Now let’s try to do forecasting for next one year for these category of products. Click on Analytics in the top menu, then select Forecast then drag forecast to the middle . That&#39;s it forecasting is done. The red line and the red area is showing forecasting for next one year.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BJjW2ptnJ9C6p9VpEUZQ1w.png" /></figure><p>Do you know you can fine tune your forecasting!!Let’s know how.</p><p>1.You can adjust the forecast options by right-clicking on the forecast axis and selecting Forecast Options. Here, you can adjust the forecast period, confidence level, and other settings as needed.</p><p>2. Here we can choose between different forecasting models. We are selecting custom from the dropdown option and then we are selecting trend and seasons as multiplicative .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/417/1*AlL3JP7N7x1xplf4kjc9ZA.png" /></figure><p>Here is the out put</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WnLRJUHd3bAi4kA2jzRAVg.png" /></figure><p>We can see the clear difference between previous out put and this one.</p><h3><strong>Additional Tips</strong></h3><p>When forecasting is enabled if you do right click then <strong>Forecast</strong> and<strong> Describe Forecast</strong>. You will get summery of the forecast.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AOWPd7r2dUpKRtOT9EZefw.png" /></figure><p>Explanation of each column of this result will be lengthy for this blog .But this gives clear summery of the forecast.</p><h3><strong>Conclusion</strong></h3><p>By experimenting with different forecasting models, parameters, and data preprocessing techniques ,we can find the optimal approach for our specific use case . Tableau offers powerful forecasting capabilities that enable users to predict future trends and make data-driven decisions with confidence. It can be sales or demands or resources, allocation of forecasting can help us to stay ahead of the curve and drive businesses into success in today’s dynamic marketplace.</p><h3><strong>References</strong></h3><p><a href="https://help.tableau.com/current/pro/desktop/en-us/forecast_how_it_works.htm">How Forecasting Works in Tableau — Tableau</a></p><p><a href="https://help.tableau.com/current/public/desktop/en-us/forecast_describe.htm?source=productlink">Describe Forecast Dialog Box — Tableau</a></p><p>Image Reference:<a href="https://images.search.yahoo.com/search/images;_ylt=AwrFEiefB9BlGgQAsoxXNyoA;_ylu=Y29sbwNiZjEEcG9zAzEEdnRpZAMEc2VjA3BpdnM-?p=forecasting&amp;fr2=piv-web&amp;type=E210US885G0&amp;fr=mcafee#id=5&amp;iurl=https%3A%2F%2Fmartech.org%2Fwp-content%2Fuploads%2F2015%2F11%2Fgraph-line-trend-analytics-magnifying-glass-ss-1920.jpg&amp;action=click">https://images.search.yahoo.com/search/images;_ylt=AwrFEiefB9BlGgQAsoxXNyoA;_ylu=Y29sbwNiZjEEcG9zAzEEdnRpZAMEc2VjA3BpdnM-?p=forecasting&amp;fr2=piv-web&amp;type=E210US885G0&amp;fr=mcafee#id=5&amp;iurl=https%3A%2F%2Fmartech.org%2Fwp-content%2Fuploads%2F2015%2F11%2Fgraph-line-trend-analytics-magnifying-glass-ss-1920.jpg&amp;action=click</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ac44ff19165b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power Query Basics: Duplicate vs Reference]]></title>
            <link>https://medium.com/@amritarout.as/power-query-basics-duplicate-vs-reference-22f2406d1d0f?source=rss-62d4370f4da1------2</link>
            <guid isPermaLink="false">https://medium.com/p/22f2406d1d0f</guid>
            <dc:creator><![CDATA[Amrita Rout]]></dc:creator>
            <pubDate>Wed, 14 Feb 2024 16:23:08 GMT</pubDate>
            <atom:updated>2024-02-14T16:23:08.021Z</atom:updated>
            <content:encoded><![CDATA[<h3>Power Query Basics: Reference vs Duplicate</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-KYCre9yypTJPSAK.jpg" /></figure><p>When you work with tables and queries in Power Query , you can copy them As a Duplicate, or Reference them. What is the actual difference between these two actions. The explanation is simple but very important to understand. Because when you know the difference, you will use it properly and get optimum result. Let’s know all about it in this short blog.</p><h3><strong>Duplicate</strong></h3><p>When you duplicate a table you are coping the entire query with all its steps. Let’s understand it through an example. Suppose we have two different column in the main table we want to merge these two columns to create an unique column for the table and later we can use this unique column as primary key to join the main table to the other table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vYPMJlOsHdOr2eGZalaGTw.png" /></figure><p>After merging we get Unique ID column.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NDD9UbKpTl0oME1GV0_LhQ.png" /></figure><p>In Applied step pane we end up with a number of steps for this query.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*utOsxj-mfKvGEwABjbNyOQ.png" /></figure><p>Let’s say you want to do all those steps that you have done for the next steps in querying the table. To do that; you can leverage Duplicate.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/859/1*V5JBzAblTttq2lUAsUGbkw.png" /></figure><p>When you create the Duplicate query, it will be an exact copy of the first query, with all steps of it. These two queries are exactly like each other.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EISUuVSAymhiEr2PQw2Q-g.png" /></figure><p>Using Duplicate, you managed to copy a query with all steps in it, and then make changes in your new query. Your original query stays intact.</p><p>Note: Duplicate is the option to choose, when you want to copy a query, but do a different configuration in steps.</p><h3><strong>Reference</strong></h3><p>Reference is another way of copying a query. The main and only difference between Duplicate and Reference is that When you reference a query the new query will have only one step i.e sourcing from the original query. A referenced query dose not have the applied steps of the original query in the Applied step pane. Let’s go back to the example.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/339/1*LKDhAqAKicVzEfTqeHM8hw.png" /></figure><p>Reference will create a new query which is a copy of the Consolidation but only contains one single step</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KX3ELm3MvjVmEe8jD1RclQ.png" /></figure><p>Reference will create a new query which has only one step i.e Getting data from the original query.Reference is a good choice, when you want to branch a query into different pathes. One path that follows a number of steps, and another that follows a different steps, and both are sharing some steps in the original query. It means if you make changes in the original query, then this new query will be impacted.</p><h3><strong>Conclusion</strong></h3><p>Duplicate creates a new copy with all the existing steps. If you make changes in old table it will not affect the new one and vise versa . Reference, on the other hand, is a new copy with only one single step: getting data from the original query. If you make a change in the original query, the new query will be impacted. For example; If you remove a column from the original query, the new query will not have it if it used the Reference method for copying.</p><p>Reference</p><ul><li><a href="https://learn.microsoft.com/">Microsoft Learn: Build skills that open doors in your career</a></li><li><a href="https://radacad.com/">Home</a></li></ul><p>Image Reference</p><p><a href="https://images.search.yahoo.com/search/images?p=power+BI+image&amp;fr=mcafee&amp;type=E210US885G0&amp;imgurl=https%3A%2F%2Fwww.prajwaldesai.com%2Fwp-content%2Fuploads%2F2017%2F11%2FpowerBI_desktop.jpg#id=2&amp;iurl=https%3A%2F%2Fwww.jeveuxetredatascientist.fr%2Fwp-content%2Fuploads%2F2021%2F04%2Fpower-bi-logo.jpg&amp;action=click">https://images.search.yahoo.com/search/images?p=power+BI+image&amp;fr=mcafee&amp;type=E210US885G0&amp;imgurl=https%3A%2F%2Fwww.prajwaldesai.com%2Fwp-content%2Fuploads%2F2017%2F11%2FpowerBI_desktop.jpg#id=2&amp;iurl=https%3A%2F%2Fwww.jeveuxetredatascientist.fr%2Fwp-content%2Fuploads%2F2021%2F04%2Fpower-bi-logo.jpg&amp;action=click</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=22f2406d1d0f" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>