Skip to main content

#Dataanalytics0 人正在讨论

Hi Tableau Community 👋

 

I’m currently working with a table called "Original", which contains around 1 billion rows of historical data. I’ve already pulled this data into Tableau and built dashboards based on it.

Recently, I was given a new requirement:

The data source gets frequent updates, and now I only need to refresh the last 7 days of data to keep my dashboards up to date.

🔁 Because updates happen quite often and the dataset is huge, I’m looking for a way to avoid using a full refresh every time — it’s not efficient or practical.

My question is: How can I design a Tableau Prep flow that automatically filters and processes only the last 7 days of data whenever the flow runs?

Any ideas or suggestions from those who’ve faced a similar scenario would be greatly appreciated!

Thanks in advance 🙏

 

#Tableau #TableauPrep ⌗DataPreparation ⌗ETL ⌗Automation ⌗DataAnalytics ⌗IncrementalRefresh

2 个回答
  1. 2025年4月10日 07:20

    IF NOT 'Prep' THEN 'Incremental Refresh' END ;-)

    IF NOT 'Prep' THEN 'Incremental Refresh' END ;-)

0/9000

⌗PreppinData 2023 Week 38 Sustainable Development Goals | Changing field names manually vs. using formulas vs. using 2 pivot values -> The SDG headings are combined into 2 columns, the color indicator, and the arrow. Arrow fields need to be renamed | #TableauPrep #Tableau #DataAnalytics ⌗DataFam | Thanks @_Lorna_Brown @JennyMartinDS14 @Datajedininja & @TomProwse1⌗PreppinData 2023 Week 38 Sustainable Development Goals | Changing field names manually vs. using formulas vs.Picture W38-2

0/9000

⌗PreppinData 2023 Week 37 Order Sequence Analysis | Absolutely thrilled with the latest addition to Tableau Prep 2023.2 - the "Multi-row calculations" feature is a game-changer! 🚀 | Thanks @JennyMartinDS14 @Datajedininja & @TomProwse1 | #TableauPrep #DataAnalytics #Tableau ⌗DataFam | (Update 9/14/2023)⌗PreppinData 2023 Week 37 Order Sequence Analysis | Absolutely thrilled with the latest addition to Tableau Prep 2023.

0/9000

I've decided I want to start posting more about the day-to-day work I'm doing in my job as a remote Salesforce Administrator.

 

This job has introduced me to a lot of tools that are new to me and I'd like to highlight some of them and discuss with other folks in the Salesforce Admin space.

 

One tool I've been using a lot recently is Cloud4J, which we use to send out report data, including to external email addresses. It's really easy to use, but the UI is a bit clunky. I'm curious if anyone else has experience with this tool and if there are better options out there.

 

Oh, and a pro-tip for anyone using Cloud4J with multiple orgs: I've found that on chrome if I log into the SF instance that I'm trying to use Cloud4J with right before logging into Cloud4J, the sign-in process is pretty seamless. Our company uses SSO so that may be a factor as well.

 

#salesforce #salesforceadmin #cloud4j #dataanalytics

0/9000

Hi everyone. Hope you are having a great summer. We are planning on extending the sunshine by announcing that we have two veritable rays of light as speakers for our next TUG Ireland (staying virtual) on September 7th.

 

It gives us great pleasure to announce that our guest speakers for the next Tableau User Group Ireland are Andy Kriebel & Avinash Reddy Munnangi.

 

The event takes place virtually and you can find out more & register for the event right here: https://lnkd.in/e6z9tm7Y

 

⌗TUGIreland #Tableau ⌗DataViz ⌗DataVizualization ⌗LoveData ⌗treatyourselftotime #dataanalyticsHi everyone. Hope you are having a great summer.

lnkd.in

1 条评论
0/9000

Hi everyone. Hope you are having a great summer. We are planning on extending the sunshine by announcing that we have two veritable rays of light as speakers for our next TUG Ireland (staying virtual) on September 7th.

 

It gives us great pleasure to announce that our guest speakers for the next Tableau User Group Ireland are Andy Kriebel & Avinash Reddy Munnangi.

 

The event takes place virtually and you can find out more & register for the event right here: https://lnkd.in/e6z9tm7Y

 

⌗TUGIreland #Tableau ⌗DataViz ⌗DataVizualization ⌗LoveData ⌗treatyourselftotime #dataanalyticsHi everyone. Hope you are having a great summer.

lnkd.in

0/9000

It gives us great pleasure to announce that our guest speakers for the next Tableau User Group Ireland are Andy Kriebel & Avinash Reddy Munnangi.

 

The event takes place virtually and you can find out more & register for the event right here: https://lnkd.in/e6z9tm7Y

 

⌗TUGIreland #Tableau ⌗DataViz ⌗DataVizualization ⌗LoveData ⌗treatyourselftotime #dataanalyticsIt gives us great pleasure to announce that our guest speakers for the next Tableau User Group Ireland are Andy Kriebel & Avinash Reddy Munnangi.

0/9000