- 54
- 80 045
The Analyst's Playbook
Israel
Приєднався 16 сер 2019
The Analyst's Playbook helps analysts learn new skills and provide more value to the businesses they support.
Introduction to Data Types (string, date, datetime, integer, float, & boolean)
In this video Justin provides a detailed introduction to data types.
Justin explains how data types are relevant for business analysts, and how they can be viewed in the schema of a database (BigQuery was used in the video).
The following data types are covered in the video:
1. String
2. Date
3. Datetime
4. Integer
5. Float
6. Boolean
Justin explains how data types are relevant for business analysts, and how they can be viewed in the schema of a database (BigQuery was used in the video).
The following data types are covered in the video:
1. String
2. Date
3. Datetime
4. Integer
5. Float
6. Boolean
Переглядів: 25
Відео
Introduction To Business Intelligence Infrastructure (ETL, Warehouse, Modeling & Visualization)
Переглядів 14421 день тому
In this video you'll learn about the 4 main building blocks in a business intelligence setup. The "Big 4" are: 1. ETL - Fivetran 2. Data Warehouse - Google BigQuery 3. Data Modeling - dbt 4. Data Visualization - Tableau This video is aimed at junior analysts, heads of analytics and anyone who wants to make their businesses more data-driven.
How to create views within Google BigQuery in 2024
Переглядів 4421 день тому
In this video you'll learn how to create database views within Google BigQuery. Justin shares the step-by-step process to create an SQL query which can then be saved as a view.
The Building Blocks of Tableau: Workbook vs Worksheet vs Dashboard vs Story
Переглядів 48Місяць тому
In this video I go into detail on the different building blocks within Tableau. The video covers the differences between workbooks, worksheets, dashboards and stories in Tableau desktop.
What Is ETL (extract, transform, load)?
Переглядів 105Місяць тому
In this video you'll learn what ETL means, it's definition, where it fits in the modern data stack, and get introduced to some popular ETL providers. The ETL providers I listed in the video are: Stitch - www.stitchdata.com/ Fivetran - www.fivetran.com/ Portable - portable.io/ Glew - glew.io/ If you found this video helpful, please consider hitting the like button and subscribing.
eCommerce Flash Report Demo
Переглядів 2503 місяці тому
In this video, Justin Butlion, the founder of projectBI shows a demo of the Flash Report, a powerful aggregated custom Tableau dashboard for DTC businesses. The dashboard was built using the following BI stack: 1. Fivetran 2. BigQuery 3. dbt 4. Tableau For more info on this report and how you can acquire it for your eCommerce business, visit www.projectbi.net.
How can I become a better analyst? Think like a SF commander, chef and entrepreneur
Переглядів 55Рік тому
In this video I share a mental framework that analysts can use to become better in the eyes of their peers. The special forces commander, Michelin star chef, and entrepreneur are three personas that analysts should adopt and keep in the back of their minds. Each of these personas will help the business analyst counteract common weaknesses and therefore become better analysts. In this video you'...
How to stop checking email after work
Переглядів 89Рік тому
I had a horrible habit of constantly checking my email outside of working hours. I've struggled with this issue for years but thankfully I've solved it. In this video you'll learn how exactly I used Boomerang for Gmail to better control the flow of inbound email and kill my bad habit. I feel a lot less anxious and more productive since setting up this process. Controlling what enters our line o...
How to build a dashboard in Tableau
Переглядів 96Рік тому
In this instructional video you'll learn how to build a dashboard in Tableau Desktop. In the video I build a dashboard containing 3 single-metric sheets, and a table. I also demonstrate how to add a floating and static filter which affects all the sheets in the dashboard.
How to create Asana tasks in Slack
Переглядів 2,6 тис.2 роки тому
In this video I demo the integration between Asana and Slack. The Asana app in Slack is really useful, especially for service providers that have their clients listed in their Slack accounts via Slack Connect. To install the Asana app in your Slack account, visit slack.com/apps/A01734836JY-asana.
How to get started with Tableau
Переглядів 1112 роки тому
In this video you'll learn some key tips for getting started with Tableau. In the video I cover Tableau desktop vs. Tableau Online / Tableau Server, how best to learn Tableau, why getting certified in Tableau is not necessary, and how much time is needed to learn the fundamentals of Tableau.
How I use Asana & Zapier to make the start of my work day hyper productive
Переглядів 4982 роки тому
In this video I'll teach you my Asana Zapier productivity hack this helps make the start of my work day productive. In this video you'll learn how to use Zapier's chrome extension to trigger a multi-step zap that creates a series of Asana tasks which will keep you focused and productive. This method, combined with the pomodoro technique is how I start my work days running a remote agency.
How to create a dynamic x/y axis matrix report in Tableau
Переглядів 2,9 тис.2 роки тому
In this detailed tutorial I'll show you how to create a dynamic matrix view where the x-axis, y-axis, color, size, and dimension shown in the report can be dynamically programmed, and selected by users. This video covers the parameter calculated field combo which is one of Tableau's most powerful set of features. The dynamic matrix report can be used to show the performance of dimensions, and p...
Introducing Nomadlist, the #1 online community for remote workers and digital nomads
Переглядів 1,6 тис.2 роки тому
A lot of analysts and data professionals are starting to work for remote companies which are open to their employees traveling, and spending time away from their home countries. In this video I talk about Nomadlist, the largest online community for digital nomads. I've been a member for over 4 years and highly recommend it to any analyst that is considering working remote and traveling even par...
Google Cloud Functions + Cloud Scheduler: How analysts can send automated alerts via Slack or email
Переглядів 4,2 тис.2 роки тому
In this video I cover the power of combining Google Cloud Functions and Cloud Schedular to trigger data-driven alerts to email (via Sendgrid), or Slack (via webhooks). This setup can be used by analysts with some python experience to provide more value to their businesses. *I decided in the end not to post the script since it was not optimized and it would be good practice for you to piece it t...
Project management tips for business analysts: How to stay organized and deliver excellent analyses
Переглядів 1892 роки тому
Project management tips for business analysts: How to stay organized and deliver excellent analyses
Data Deduplication Basics: How to spot and remove duplicated rows in a dataset
Переглядів 3632 роки тому
Data Deduplication Basics: How to spot and remove duplicated rows in a dataset
A Smart Way To Analyze End-of-Funnel Metrics
Переглядів 392 роки тому
A Smart Way To Analyze End-of-Funnel Metrics
How to analyze the eCommerce Shopping Stages Funnel in Google Analytics using Tableau
Переглядів 5872 роки тому
How to analyze the eCommerce Shopping Stages Funnel in Google Analytics using Tableau
Introduction to SQL: A non-technical guide for beginners
Переглядів 3412 роки тому
Introduction to SQL: A non-technical guide for beginners
How to visualize the median in a list in Tableau
Переглядів 3,7 тис.2 роки тому
How to visualize the median in a list in Tableau
How to set up scheduled queries in BigQuery and send the results to Slack
Переглядів 8 тис.2 роки тому
How to set up scheduled queries in BigQuery and send the results to Slack
How To Read A Data Visualization - Tips for junior analysts
Переглядів 722 роки тому
How To Read A Data Visualization - Tips for junior analysts
How to create a dynamic table in Tableau
Переглядів 9 тис.2 роки тому
How to create a dynamic table in Tableau
The Core Funnel: A Powerful Product Analytics Concept For Early-Stage Startups
Переглядів 752 роки тому
The Core Funnel: A Powerful Product Analytics Concept For Early-Stage Startups
Analyzing the projectBI YouTube channel's metrics
Переглядів 242 роки тому
Analyzing the projectBI UA-cam channel's metrics
How to create a retention curve graph using Tableau
Переглядів 5 тис.2 роки тому
How to create a retention curve graph using Tableau
eCommerce Metrics 101: Revenue Per Session
Переглядів 4903 роки тому
eCommerce Metrics 101: Revenue Per Session
Building moving windows In Tableau using the window sum function
Переглядів 1,2 тис.3 роки тому
Building moving windows In Tableau using the window sum function
Business Intelligence for Startups [Webinar Recording]
Переглядів 1293 роки тому
Business Intelligence for Startups [Webinar Recording]
Thank you for sharing.
It was my pleasure. Thanks for the comment.
@@theanalystsplaybook welcome
Thanks for sharing! I learned three things / commands SELECT, FROM, LIMIT 🙂
Awesome! So happy to hear.
thanks😇
Welcome 😊
hey how do you show where you going on nomadlist, is there a place to input your travel dates and location ?
This was really helpful. I just tried it now and it worked
very new to Tableau and this function literally saved my life, I still don't know what it's doing but it works
Please share the code!
Still this the best way to connect search console to tableau ?
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
Great work, super helpful!
Can this be done using the slack mobile app, or it only works on desktop?
Only desktop.
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?
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.
Really insightful video man! Im trying to combine a daily management task monitor and project tracker through Notion
Great video, thanks!
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
Does this work for Google chat webhook... I'm getting 500 error
Hi ProjectBI, Thank you for the walk through. Can you suggest me " How to deal, when the Scheduled Query does not work properly ? "
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.
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.
Can you please share the code
Great video, very helpful!!
I'm glad you found it useful João. Thanks for the comment. -Justin
@@theanalystsplaybook Just joined Nomad List! 🇧🇷✅
@ Great decision:) -Justin
I love how you explained it! It was just what I need 😁😁😁😁😁😁
I'm really glad to hear that the video was helpful to you Maximilliano. Thanks for your comment and support for the channel. -Justin
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
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
really helpful and easy to follow thx for sharing this vid 🙂
Thanks for the comment! I'm glad you found the video helpful. -Justin
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
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.
This is the best explanation of how the FIXED LOD works. Thank you.
I'm glad you found it useful Scott. Thanks for the comment. -Justin
Goood night!ProjectBI. Like!useful -:)
⭐ ᎮᏒᎧᎷᎧᏕᎷ
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 🙌
Hey Irene. Thanks for the nice comment, it made my day. Good luck with your career switch. Justin
Would it work with the basic asana plan?
Yes, this automation flow will work with Asana's free plan.
This was a lot more calm is clear than anything else I've seen at a level generally skipped over, thanks!
I'm glad you found the video helpful Gregori. Thanks for the comment.
Many thanks!
You're welcome!
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!
Hey Aviv. I'm glad you found the video helpful. Thanks for the support.
@@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?
@@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.
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%
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.
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 :)
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.
yo bro please reply man
i need yo help like rn 1
can you please tell how you made that retention graph of starting
cohort i mean
@@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.
@@theanalystsplaybook Would it be possible to be more specific on the exact formula you used?
@@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
Thank you a lot for this great information Justin
Thanks Ayoub.
Is it possible to trigger a video player to play at a schedule time?
Yes, I believe this is possible using javascript. It's not part of the scope of my video though. I suggest using UA-cam or Google to track down a tutorial that can help you with that.
Zapier is cool but I find Integromat to be more powerful in terms of what type of automations you want to build.
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.
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.
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?
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.
Thanks for sharing, very useful
I'm glad you liked it Carlos, thanks for the comment.
Helpful. Thank you.
I'm glad you found the content helpful Mellany.
@@theanalystsplaybook :))
This was super helpful! Thank you so much for posting this
I'm really glad you found it helpful.
@@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!
@@jasperb6191 Good luck! Keep us updated.
@@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
@@jasperb6191 I'm really happy to hear that Jasper, congrats! Keep on pushing!
Thank you for sharing this useful tableau tips
You are most welcome
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?
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