The Analyst's Playbook
The Analyst's Playbook
  • 54
  • 82 500
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
-----------------------------------------------------------------------------------------
Subscribe to The Analyst's Playbook newsletter - analystsplaybook.substack.com/
มุมมอง: 56

วีดีโอ

Introduction To Business Intelligence Infrastructure (ETL, Warehouse, Modeling & Visualization)
มุมมอง 177หลายเดือนก่อน
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. Subscribe to The Analyst's Playbook newsletter - analy...
How to create views within Google BigQuery in 2024
มุมมอง 1312 หลายเดือนก่อน
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. Subscribe to The Analyst's Playbook newsletter - analystsplaybook.substack.com/
The Building Blocks of Tableau: Workbook vs Worksheet vs Dashboard vs Story
มุมมอง 922 หลายเดือนก่อน
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. Subscribe to The Analyst's Playbook newsletter - analystsplaybook.substack.com/
What Is ETL (extract, transform, load)?
มุมมอง 1432 หลายเดือนก่อน
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. Subscribe to T...
eCommerce Flash Report Demo
มุมมอง 2674 หลายเดือนก่อน
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. Subscribe to The Analyst's Playboo...
How can I become a better analyst? Think like a SF commander, chef and entrepreneur
มุมมอง 582 ปีที่แล้ว
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
มุมมอง 922 ปีที่แล้ว
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
มุมมอง 982 ปีที่แล้ว
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. Subscribe to The Analyst's Playbook newsletter - analystsplaybook.substack.com/
How to create Asana tasks in Slack
มุมมอง 2.7K2 ปีที่แล้ว
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. Subscribe to The Analyst's Playbook newsletter - analystsplaybook.substack.com/
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. Subscribe to The Analyst's Playbook newsletter - analystsplaybook.substack.com/
How I use Asana & Zapier to make the start of my work day hyper productive
มุมมอง 5102 ปีที่แล้ว
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. Subsc...
How to create a dynamic x/y axis matrix report in Tableau
มุมมอง 3K2 ปีที่แล้ว
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.6K2 ปีที่แล้ว
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.4K2 ปีที่แล้ว
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
มุมมอง 1932 ปีที่แล้ว
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
มุมมอง 3772 ปีที่แล้ว
Data Deduplication Basics: How to spot and remove duplicated rows in a dataset
A Smart Way To Analyze End-of-Funnel Metrics
มุมมอง 412 ปีที่แล้ว
A Smart Way To Analyze End-of-Funnel Metrics
How to analyze the eCommerce Shopping Stages Funnel in Google Analytics using Tableau
มุมมอง 6102 ปีที่แล้ว
How to analyze the eCommerce Shopping Stages Funnel in Google Analytics using Tableau
Introduction to SQL: A non-technical guide for beginners
มุมมอง 3642 ปีที่แล้ว
Introduction to SQL: A non-technical guide for beginners
How to visualize the median in a list in Tableau
มุมมอง 3.7K2 ปีที่แล้ว
How to visualize the median in a list in Tableau
How to set up scheduled queries in BigQuery and send the results to Slack
มุมมอง 8K2 ปีที่แล้ว
How to set up scheduled queries in BigQuery and send the results to Slack
How To Read A Data Visualization - Tips for junior analysts
มุมมอง 852 ปีที่แล้ว
How To Read A Data Visualization - Tips for junior analysts
How to create a dynamic table in Tableau
มุมมอง 9K2 ปีที่แล้ว
How to create a dynamic table in Tableau
The Core Funnel: A Powerful Product Analytics Concept For Early-Stage Startups
มุมมอง 982 ปีที่แล้ว
The Core Funnel: A Powerful Product Analytics Concept For Early-Stage Startups
Analyzing the projectBI YouTube channel's metrics
มุมมอง 243 ปีที่แล้ว
Analyzing the projectBI TH-cam channel's metrics
How to create a retention curve graph using Tableau
มุมมอง 5K3 ปีที่แล้ว
How to create a retention curve graph using Tableau
eCommerce Metrics 101: Revenue Per Session
มุมมอง 4953 ปีที่แล้ว
eCommerce Metrics 101: Revenue Per Session
Building moving windows In Tableau using the window sum function
มุมมอง 1.2K3 ปีที่แล้ว
Building moving windows In Tableau using the window sum function
Business Intelligence for Startups [Webinar Recording]
มุมมอง 1313 ปีที่แล้ว
Business Intelligence for Startups [Webinar Recording]

ความคิดเห็น

  • @cujo3097
    @cujo3097 19 วันที่ผ่านมา

    this is great, but is there a way to have the column not show at all if you select "None" in your parameter?

    • @theanalystsplaybook
      @theanalystsplaybook 19 วันที่ผ่านมา

      If you only wanted one column then instead of switching the values in the column, you could instead use "sheet swapping" and create different sheets for each value you would show. In the case of "none", the sheet wouldn't have a column at all. This would get increasingly complicated if you wanted to not show a column at all but wanted more than one column in the table.

  • @digitalmarketingservice3763
    @digitalmarketingservice3763 หลายเดือนก่อน

    Thank you for sharing.

  • @fromroots
    @fromroots 3 หลายเดือนก่อน

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

  • @avilipsapadhi7745
    @avilipsapadhi7745 4 หลายเดือนก่อน

    thanks😇

  • @frenchmike
    @frenchmike 5 หลายเดือนก่อน

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

  • @iwuchukwusylvia922
    @iwuchukwusylvia922 5 หลายเดือนก่อน

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

  • @panic_seller
    @panic_seller 8 หลายเดือนก่อน

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

  • @shivayshakti6575
    @shivayshakti6575 9 หลายเดือนก่อน

    Please share the code!

  • @ArbFoods-xc3ev
    @ArbFoods-xc3ev 11 หลายเดือนก่อน

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

  • @nathanthreeleaf4534
    @nathanthreeleaf4534 ปีที่แล้ว

    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

  • @mikulaskarger3229
    @mikulaskarger3229 ปีที่แล้ว

    Great work, super helpful!

  • @africanthings9281
    @africanthings9281 ปีที่แล้ว

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

  • @kruthikasulghur1764
    @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
    @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
    @GbV5511 ปีที่แล้ว

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

  • @miguelmartindelcampo4364
    @miguelmartindelcampo4364 ปีที่แล้ว

    Great video, thanks!

  • @sachinthakur186
    @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
    @suhasudaykumar3691 ปีที่แล้ว

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

  • @hemdatascience369
    @hemdatascience369 ปีที่แล้ว

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

  • @LaureanVincent5
    @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
    @krishsingh111 ปีที่แล้ว

    Can you please share the code

  •  ปีที่แล้ว

    Great video, very helpful!!

  • @maximilianodelatorre2513
    @maximilianodelatorre2513 ปีที่แล้ว

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

  • @purneshakella8399
    @purneshakella8399 2 ปีที่แล้ว

    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

  • @user-nv2oc3jv8m
    @user-nv2oc3jv8m 2 ปีที่แล้ว

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

  • @katerynaherashchenko1718
    @katerynaherashchenko1718 2 ปีที่แล้ว

    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

    • @theanalystsplaybook
      @theanalystsplaybook 2 ปีที่แล้ว

      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.

  • @scottstewart1660
    @scottstewart1660 2 ปีที่แล้ว

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

  • @eprohoda
    @eprohoda 2 ปีที่แล้ว

    Goood night!ProjectBI. Like!useful -:)

  • @bartholomewhorrocks3750
    @bartholomewhorrocks3750 2 ปีที่แล้ว

    ⭐ ᎮᏒᎧᎷᎧᏕᎷ

  • @ireneangelina8866
    @ireneangelina8866 2 ปีที่แล้ว

    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 🙌

    • @theanalystsplaybook
      @theanalystsplaybook 2 ปีที่แล้ว

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

  • @johelbrayansaavedrachoque6635
    @johelbrayansaavedrachoque6635 2 ปีที่แล้ว

    Would it work with the basic asana plan?

  • @lotter3008
    @lotter3008 2 ปีที่แล้ว

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

    • @theanalystsplaybook
      @theanalystsplaybook 2 ปีที่แล้ว

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

  • @lalaaskarova7659
    @lalaaskarova7659 2 ปีที่แล้ว

    Many thanks!

  • @AVIVRO2
    @AVIVRO2 2 ปีที่แล้ว

    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!

    • @theanalystsplaybook
      @theanalystsplaybook 2 ปีที่แล้ว

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

    • @AVIVRO2
      @AVIVRO2 2 ปีที่แล้ว

      @@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?

  • @jessicaanne6560
    @jessicaanne6560 2 ปีที่แล้ว

    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%

  • @vivicawong6389
    @vivicawong6389 2 ปีที่แล้ว

    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 :)

    • @theanalystsplaybook
      @theanalystsplaybook 2 ปีที่แล้ว

      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.

  • @devanshbhardwaj5955
    @devanshbhardwaj5955 2 ปีที่แล้ว

    yo bro please reply man

  • @devanshbhardwaj5955
    @devanshbhardwaj5955 2 ปีที่แล้ว

    i need yo help like rn 1

  • @devanshbhardwaj5955
    @devanshbhardwaj5955 2 ปีที่แล้ว

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

    • @devanshbhardwaj5955
      @devanshbhardwaj5955 2 ปีที่แล้ว

      cohort i mean

    • @theanalystsplaybook
      @theanalystsplaybook 2 ปีที่แล้ว

      @@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
      @stayriddi5094 ปีที่แล้ว

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

    • @theanalystsplaybook
      @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

  • @ayoubyoussfi8821
    @ayoubyoussfi8821 2 ปีที่แล้ว

    Thank you a lot for this great information Justin

  • @GodSentV
    @GodSentV 2 ปีที่แล้ว

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

  • @wayneg4628
    @wayneg4628 2 ปีที่แล้ว

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

  • @kasperbirkelund4347
    @kasperbirkelund4347 3 ปีที่แล้ว

    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.

  • @hannadmytriieva8414
    @hannadmytriieva8414 3 ปีที่แล้ว

    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?

  • @bastiasi
    @bastiasi 3 ปีที่แล้ว

    Thanks for sharing, very useful

    • @theanalystsplaybook
      @theanalystsplaybook 3 ปีที่แล้ว

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

  • @mellanytravers6544
    @mellanytravers6544 3 ปีที่แล้ว

    Helpful. Thank you.

  • @jasperb6191
    @jasperb6191 3 ปีที่แล้ว

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

    • @theanalystsplaybook
      @theanalystsplaybook 3 ปีที่แล้ว

      I'm really glad you found it helpful.

    • @theanalystsplaybook
      @theanalystsplaybook 3 ปีที่แล้ว

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

  • @beginnerpython6183
    @beginnerpython6183 3 ปีที่แล้ว

    Thank you for sharing this useful tableau tips

  • @doron3463
    @doron3463 4 ปีที่แล้ว

    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?

    • @theanalystsplaybook
      @theanalystsplaybook 4 ปีที่แล้ว

      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