Пікірлер

• 
  @digitalmarketingservice376315 күн бұрын

  Thank you for sharing.

• 
  @theanalystsplaybook15 күн бұрын

  It was my pleasure. Thanks for the comment.

• 
  @digitalmarketingservice376314 күн бұрын

  @@theanalystsplaybook welcome

• 
  @fromroots2 ай бұрын

  Thanks for sharing! I learned three things / commands SELECT, FROM, LIMIT 🙂

• 
  @theanalystsplaybookАй бұрын

  Awesome! So happy to hear.

• 
  @avilipsapadhi77453 ай бұрын

  thanks😇

• 
  @theanalystsplaybook2 ай бұрын

  Welcome 😊

• 
  @frenchmike4 ай бұрын

  hey how do you show where you going on nomadlist, is there a place to input your travel dates and location ?

• 
  @iwuchukwusylvia9224 ай бұрын

  This was really helpful. I just tried it now and it worked

• 
  @panic_seller7 ай бұрын

  very new to Tableau and this function literally saved my life, I still don't know what it's doing but it works

• 
  @shivayshakti65758 ай бұрын

  Please share the code!

• 
  @ArbFoods-xc3ev10 ай бұрын

  Still this the best way to connect search console to tableau ?

• 
  @nathanthreeleaf453411 ай бұрын

  I had never heard of the FIXED function being explained as a "For Each" iteration, which makes a lot of sense to me having Python experience. This really helped me grasp the concept of how and when to use it. Nice work

• 
  @mikulaskarger322911 ай бұрын

  Great work, super helpful!

• 
  @africanthings9281 Жыл бұрын

  Can this be done using the slack mobile app, or it only works on desktop?

• 
  @theanalystsplaybook Жыл бұрын

  Only desktop.

• 
  @kruthikasulghur1764 Жыл бұрын

  Hey, The video is informative. Thank you for that. I am receiving a warning in Mixpanel saying "ID merge Delay". Not able to find any preloaded steps or not getting any data for the steps I have added in funnel. Could you please help?

• 
  @user-bi2sm9hp3m Жыл бұрын

  Hi, Very helpful tips. Question, does the GTM tag work on successful submission only? will it fire if someone accidentally hits the submit button, without providing the required detail.

• 
  @GbV5511 Жыл бұрын

  Really insightful video man! Im trying to combine a daily management task monitor and project tracker through Notion

• 
  @miguelmartindelcampo4364 Жыл бұрын

  Great video, thanks!

• 
  @sachinthakur186 Жыл бұрын

  for someone who is unable to utilize None , click on your column name in table (e.g dimension selector lvl-1 in video) and select hide field labels for rows

• 
  @suhasudaykumar3691 Жыл бұрын

  Does this work for Google chat webhook... I'm getting 500 error

• 
  @hemdatascience369 Жыл бұрын

  Hi ProjectBI, Thank you for the walk through. Can you suggest me " How to deal, when the Scheduled Query does not work properly ? "

• 
  @theanalystsplaybook Жыл бұрын

  Hey Hem. I'm not sure what you mean exactly. What do you mean by "does not work properly"? The process will fail if the query does not successfully run. If you notice that you are not receiving a message to Slack, then you would revisit the scheduled query and troubleshoot the failing query. BigQuery gives you a lot of indicators for why a query is failing.

• 
  @LaureanVincent5 Жыл бұрын

  thanks! I was able to create the query I need, but I need a sample of your code for EMAIL. I can't seem to find anything that takes the CONTENT of query and drops it into the body of the email via SendGrid. All the sample code i've found attaches a CSV file. A bit overkill when you want one piece of data.

• 
  @krishsingh111 Жыл бұрын

  Can you please share the code

• 
  Жыл бұрын

  Great video, very helpful!!

• 
  @theanalystsplaybook Жыл бұрын

  I'm glad you found it useful João. Thanks for the comment. -Justin

• 
  Жыл бұрын

  @@theanalystsplaybook Just joined Nomad List! 🇧🇷✅

• 
  @theanalystsplaybook Жыл бұрын

  @ Great decision:) -Justin

• 
  @maximilianodelatorre2513 Жыл бұрын

  I love how you explained it! It was just what I need 😁😁😁😁😁😁

• 
  @theanalystsplaybook Жыл бұрын

  I'm really glad to hear that the video was helpful to you Maximilliano. Thanks for your comment and support for the channel. -Justin

• 
  @purneshakella8399 Жыл бұрын

  It’s a great video I have one question Suppose if I have more than 100 columns and I wanted to have same thing which you have shown in the video, how can I achieve? One more thing instead of having 3 parameters, can we have 1 parameter with multi select of dimensions

• 
  @theanalystsplaybook Жыл бұрын

  I believe Tableau has a limit on the number of columns you can have in a table. A quick Google search would be able to check that. Also, a table with 100 columns wouldn't be readable so you'd be better off building it using SQL as a view or using something like dbt, and then making it accessible within the database to end-users. Yes, you could go with 1 parameter which allows you to switch between dimensions. This is the classic approach. My method is a bit more advanced. Thanks for the questions. -Justin

• 
  @user-nv2oc3jv8m Жыл бұрын

  really helpful and easy to follow thx for sharing this vid 🙂

• 
  @theanalystsplaybook Жыл бұрын

  Thanks for the comment! I'm glad you found the video helpful. -Justin

• 
  @katerynaherashchenko17182 жыл бұрын

  is there any way to select a cohort automatically for every conversion? I mean some way to represent correct retention for every recur without selecting right cohorts manually

• 
  @theanalystsplaybook2 жыл бұрын

  Hey Kateryna. Yes, you could do this by working backwards and starting with a retention curve which includes all available data, and then segmenting the lines by the relevant cohort grouping (signup month for example). This will result in a multi-line graph where each line represents a cohort. The issue is that such views can be difficult to read sometimes, and may create confusion since not all cohorts will be equal in age.

• 
  @scottstewart16602 жыл бұрын

  This is the best explanation of how the FIXED LOD works. Thank you.

• 
  @theanalystsplaybook2 жыл бұрын

  I'm glad you found it useful Scott. Thanks for the comment. -Justin

• 
  @eprohoda2 жыл бұрын

  Goood night!ProjectBI. Like!useful -:)

• 
  @bartholomewhorrocks37502 жыл бұрын

  ⭐ ᎮᏒᎧᎷᎧᏕᎷ

• 
  @ireneangelina88662 жыл бұрын

  Hi Justin, greetings from Indonesia. Thank you so much for posting this video. As a career switcher to marketing from project management with non IT background, this video is really helpful for my first stepping stone. I was overwhelmed when came across SQL at the first time, but you explained in the most 'human' way possible. Really appreciate this 🙌

• 
  @theanalystsplaybook2 жыл бұрын

  Hey Irene. Thanks for the nice comment, it made my day. Good luck with your career switch. Justin

• 
  @johelbrayansaavedrachoque66352 жыл бұрын

  Would it work with the basic asana plan?

• 
  @theanalystsplaybook2 жыл бұрын

  Yes, this automation flow will work with Asana's free plan.

• 
  @lotter30082 жыл бұрын

  This was a lot more calm is clear than anything else I've seen at a level generally skipped over, thanks!

• 
  @theanalystsplaybook2 жыл бұрын

  I'm glad you found the video helpful Gregori. Thanks for the comment.

• 
  @lalaaskarova76592 жыл бұрын

  Many thanks!

• 
  @theanalystsplaybook2 жыл бұрын

  You're welcome!

• 
  @AVIVRO22 жыл бұрын

  tenx I'm looking for something like that in the web and I don't find any tortorial that are tech how to trigger segment event easly!

• 
  @theanalystsplaybook2 жыл бұрын

  Hey Aviv. I'm glad you found the video helpful. Thanks for the support.

• 
  @AVIVRO22 жыл бұрын

  @@theanalystsplaybook I am looking for some more technical help in implementing a segment on a client's site (server side) Can you help me for a fee?

• 
  @theanalystsplaybook2 жыл бұрын

  @@AVIVRO2 I'm afraid I'm no longer providing consulting services in that area. I recommend checking out www.measurematch.com. I'm confident you'll find the needed support through their marketplace. James, the co-founder of MeasureMatch knows me well.

• 
  @jessicaanne65602 жыл бұрын

  hello, can i check with you why even though i followed all your steps, for the last step when your graph splits into the different weeks, mine does a cumulative value instead. so instead of 100% as the starting point for week 0 for every cohort, the week 0 is split by proportion for all the cohorts to = to 100%

• 
  @theanalystsplaybook2 жыл бұрын

  Hey Jessica. I think you're using the percentage of total table calculation instead of dividing by window_max. You want to use the window max function to divide the number of users that are left at each point by the total number you started with. I hope that helps. Thanks for watching.

• 
  @vivicawong63892 жыл бұрын

  hi there, this is super helpful! i was wondering if you’d know how i could do a window sum (shown as a graph) using table across? would be great if you could advice based on your expertise!! thank you :)

• 
  @theanalystsplaybook2 жыл бұрын

  Hey Vivica. I'm not sure I fully understand your question. The window sum function is essentially calculated as "table across" since it takes the last X data points. Since it's a table calculation, you aren't going to be able to do any additional manipulation like running sum etc on top of it. If you expand on your question, I'll try and help.

• 
  @devanshbhardwaj59552 жыл бұрын

  yo bro please reply man

• 
  @devanshbhardwaj59552 жыл бұрын

  i need yo help like rn 1

• 
  @devanshbhardwaj59552 жыл бұрын

  can you please tell how you made that retention graph of starting

• 
  @devanshbhardwaj59552 жыл бұрын

  cohort i mean

• 
  @theanalystsplaybook2 жыл бұрын

  @@devanshbhardwaj5955 To build such a cohort table you need to create a calculated field which uses the datediff and IF functions in Tableau. You create custom buckets of X days (between 0 and 6 equals 1 would be the first bucket of 7 days, 7 - 13 would be the second bucket etc) and then set the calculated field as a dimension. When you place the field on the columns you will get columns for each bucket like shown in my video. You then need a date field for the rows, and then can use either countd for absolute values, or countd/window_max to calculate percentages.

• 
  @stayriddi5094 Жыл бұрын

  @@theanalystsplaybook Would it be possible to be more specific on the exact formula you used?

• 
  @theanalystsplaybook Жыл бұрын

  @@stayriddi5094 The formula I used to create the columns in the table is made up of datediff and fixed. Calculated field #1: {fixed user_id: min(event_created_at)} --> This gives you the first event performed by the user. Calculated field #2: datediff('week',CALCULATED FIELD #1,event_created_at) --> This gives you the number of weeks between the first event and the current event. You'll then turn this into a dimension and add it to the columns shelf. You then use countd(user_id)/window_max(countd(user_id) for your values. This will give you the percentage of the users which did activity in the given cell, compared to the total # of users. I'll just add that this is a tough concept to grasp and you're better off trying to understand the approach first before trying to build it. Try it first on paper or in excel and once you grasp it, building it in Tableau isn't too difficult. Good luck. -Justin

• 
  @ayoubyoussfi88212 жыл бұрын

  Thank you a lot for this great information Justin

• 
  @theanalystsplaybook2 жыл бұрын

  Thanks Ayoub.

• 
  @GodSentV2 жыл бұрын

  Is it possible to trigger a video player to play at a schedule time?

• 
  @theanalystsplaybook2 жыл бұрын

  Yes, I believe this is possible using javascript. It's not part of the scope of my video though. I suggest using KZread or Google to track down a tutorial that can help you with that.

• 
  @wayneg46282 жыл бұрын

  Zapier is cool but I find Integromat to be more powerful in terms of what type of automations you want to build.

• 
  @kasperbirkelund43472 жыл бұрын

  Thanks. I was just creating something like this actually. I was searching to find a solution to the first part of the graph that is not a full window range. Nice trick with the IFF function, however for my use I really need to have it filled in with the window values. Do you know how to do this? So the window values are not affected by the time filter you have in the Viz? So basically allowing it to aggregate further back than what you are showing. Cannot find a good solution to this online I think.

• 
  @theanalystsplaybook2 жыл бұрын

  Hey Kasper. If you want to show all your data points in the viz, then you can simply use the window_sum function on it's own without including the IIF piece.

• 
  @hannadmytriieva84143 жыл бұрын

  Hi Justin, thanks for the video. Trying to calculate days between orders and group customers, on how many days it took them to do second, third.. order. But do not get it how to do it. Can you help please?

• 
  @theanalystsplaybook3 жыл бұрын

  Hey Hanna. Unfortunately you can't do that using the fixed function. You'll first need to rank the orders per customer which you'll need to do outside of Tableau. Once you've added the rank as a new column, you could then use fixed, rank and datediff to calculate time between first order and 2nd, 3rd, 4th order etc. This is a tricky one. The hardest part is adding the rank. If you're using the super store data set then you may need to import it into a database so you could then run some SQL on it. Might be able to do it in Excel but I'm not familiar with ranking in Excel, it's been a long time since I did that.

• 
  @bastiasi3 жыл бұрын

  Thanks for sharing, very useful

• 
  @theanalystsplaybook3 жыл бұрын

  I'm glad you liked it Carlos, thanks for the comment.

• 
  @mellanytravers65443 жыл бұрын

  Helpful. Thank you.

• 
  @theanalystsplaybook3 жыл бұрын

  I'm glad you found the content helpful Mellany.

• 
  @mellanytravers65443 жыл бұрын

  @@theanalystsplaybook :))

• 
  @jasperb61913 жыл бұрын

  This was super helpful! Thank you so much for posting this

• 
  @theanalystsplaybook3 жыл бұрын

  I'm really glad you found it helpful.

• 
  @jasperb61913 жыл бұрын

  @@theanalystsplaybook I will update you if i pass the job interview for a data analyst position. If I do get in a big part of it is due to you!

• 
  @theanalystsplaybook3 жыл бұрын

  @@jasperb6191 Good luck! Keep us updated.

• 
  @jasperb61913 жыл бұрын

  @@theanalystsplaybook I got the job man! Ive been coding Python since August and I got accepted in the best Data Science company here in the Philippines

• 
  @theanalystsplaybook3 жыл бұрын

  @@jasperb6191 I'm really happy to hear that Jasper, congrats! Keep on pushing!

• 
  @beginnerpython61833 жыл бұрын

  Thank you for sharing this useful tableau tips

• 
  @theanalystsplaybook3 жыл бұрын

  You are most welcome

• 
  @doron34634 жыл бұрын

  Hey, first thank you very much for the video it's really great and helpful. i have a question: how can i use mixpanel if i want to know how much time a user spend on specific page?

• 
  @theanalystsplaybook4 жыл бұрын

  Hey Doron, I'm glad you liked the video. You can't use Mixpanel to know how much time a user spends on a specific page. To do that I'd recommend Google Analytics or a tool like Hotjar (video record your sessions and view them). -Justin