1 Reply Latest reply on Aug 13, 2018 6:35 PM by lei.chen.0

    Need guidance for building Sales Forecasting and Visulaization in Tableau Desktop

    Navya Basavaraju

      Hi,

       

      I am new to Tableau and need help urgently to build forecasting and viz for Sales Data. So, if someone can help me out for Rossman Sales data, it would be greatly appreciated.

      I want following visualizations:

      1. Effect of Day of the Week on Sales

      2. Effect of state holidays on Sales

      3. Effect of competition distance on sales for a particular store

      5. Forecasting model with multiple parameters

       

      Thanks in advance for helping me!!! Any other suggestion is welcome too

        • 1. Re: Need guidance for building Sales Forecasting and Visulaization in Tableau Desktop
          lei.chen.0

          Hello Navya,

           

          Depends on the requirements on the "Forecasting model", approaches are quite different.

           

          1. Manual Formula

           

          The main processes are,

           

          1) Created the mentioned 1-3 vizzes

          2) Observe the relationships

          3) Figure out a forecast formula like Sales = f (day of the week, state holidays, competition distance)

          4) Calculate the forecast with the above formula

           

          2. Tableau Analytics -> Model -> Forecast

           

          It not possible to assign which variables should be used to forecast.

           

          3. Tableau Integration with R/Python

           

          The main processes are,

          1) Created the mentioned 1-3 vizzes

          2) Train the model by means of R or Python

          3) Use Tableau to integrate with R or Python and viz the result in Tableau

           

           

          Regards

          Lei