1 Reply Latest reply on Aug 16, 2018 1:11 AM by meenu choudhary

    ETL Process (SQL + Tableau)

    KUNAL SHAH

      Process of ETL using SQL and Tableau. Below are some of my thoughts and questions regarding the implementation.

       

      below are my questions:

       

      1) In practical scenario, how do companies perform ETL?  (do they create stored procedure or trigger and create a new table ? what is the process)

      2) After table creation in SQL, Do we frequently create tables(Say monthly) in SQL and apply union in tableau ( how to automate this?)

      2) Using tableau - Incremental database + Refresh scheduling ( does the practical scenario requires changing database frequently? Is there a way this can be automated?)

       

      I think this is a great discussion point to understand and deep dive into data analytics.

       

      Thank You