Penguin Analytics
Penguin Analytics
  • 102
  • 4 123 245
3 Ways To Do Time Series Analysis In Tableau - Tableau in Two Minutes
Learn how to do time series analysis three different ways in this Tableau in Two Minutes video. We'll walk you through how to build a classic line chart, a slope chart and a cycle plot in Tableau. You can use these to understand trends overtime, changes between the first and last points, and overall seasonality in your time series data. The dataset we use is from data.gov and you can access it here:
catalog.data.gov/dataset/border-crossing-entry-data-683ae
00:00 Introduction
00:08 Data Overview
00:33 Transforming the Date
01:43 Building a Line Chart
02:22 Adding a Trending Line
02:55 Adding a Forecast
03:43 Slope Chart For Changes from Start to End
07:27 Cycle Plot for Seasonality - Version 1
09:24 Cycle Plot - Version 2
11:00 Conclusion
11:39 Thanks for Watching!
zhlédnutí: 73

Video

How to Create a Data Story in Tableau - Tableau in Two Minutes
zhlédnutí 192Před 14 dny
Learn data storytelling in Tableau with this example! Walk through the whole process of creating and telling a data story in Tableau in this long-form tutorial. We'll take a look at a dataset, determine our audience and analyze the data with the audience in mind. Then we'll create a dashboard, clean up the clutter and come up with some details and context that will help our audience understand ...
I Cheated On Tableau with Power BI
zhlédnutí 204Před 14 dny
For years I've been a Tableau advocate, resisting the ease of access to Power BI and pooh poohing those who developed in it as "not real analysts." Over the last few months, I've been testing it, and boy has the platform improved over the last few years. In this video, find out my impressions and which one I think is best across several key factors for any BI/Dashboarding tool. 00:00 Introducti...
Power BI Basics for Beginners - Updated 2024!
zhlédnutí 165Před 21 dnem
Learn the basics of Power BI in this video aimed at beginners and go from nothing to building your first dashboard in just a few minutes! Just like in our Tableau videos, we walk through how to connect to data, create calculations, create visualizations and layout your dashboards, all in a few minutes and using the 2024 version of Power BI. The first step is connecting to a CSV file with hotel ...
Tableau Basics for Beginners - Updated 2024! - Tableau in Two Minutes
zhlédnutí 855Před 21 dnem
This video is aimed at beginners and covers the basics of Tableau, updated for 2024! This long form video covers everything you need to know to go from opening Tableau for the first time to creating your first visualization. Along the way, take a look for other videos explaining some of the Tableau concepts in more detail! Here's the data used in the video: www.kaggle.com/datasets/mojtaba142/ho...
5 Step-Process to Improve Your Data Storytelling
zhlédnutí 113Před 28 dny
Level up your data storytelling with a five step process for gathering data, building your story, analyzing your audience to make sure your presentation is laser focused on what your audience cares about. You don't need to be a master presenter to present your data science projects if you've set yourself up for success by creating the right presentation with the right flow. Wow your audience th...
How to Build A Data-Driven Culture
zhlédnutí 85Před měsícem
Organizations with a data-driven culture have a competitive advantage over those that don't, but a lot of companies think data driven means "looking at a lot of metrics" or "having a lot of dashboards." In this video we walk through what building a data driven culture means, the elements that support it, and the steps leaders can take to build a data driven culture in their organization. 00:00 ...
How to Pick the Right KPI - Are You Measuring The Right Things?
zhlédnutí 69Před měsícem
How to Pick the Right KPI - Are You Measuring The Right Things?
A Data Literacy Crash Course
zhlédnutí 377Před měsícem
A Data Literacy Crash Course
How and Why to use Dynamic Parameters - Tableau in Two Minutes
zhlédnutí 75KPřed 3 lety
How and Why to use Dynamic Parameters - Tableau in Two Minutes
Relationships, Joins and Unions in Tableau 2020.2 - Tableau in Two Minutes
zhlédnutí 103KPřed 3 lety
Relationships, Joins and Unions in Tableau 2020.2 - Tableau in Two Minutes
A Beginners Course in Machine Learning - Machine Learning in Minutes
zhlédnutí 2,7KPřed 4 lety
A Beginners Course in Machine Learning - Machine Learning in Minutes
How to Export Data from Tableau to Excel - Tableau in Two Minutes
zhlédnutí 72KPřed 5 lety
How to Export Data from Tableau to Excel - Tableau in Two Minutes
Asterisks when Blending and How to Avoid Them - Tableau in Two Minutes
zhlédnutí 20KPřed 5 lety
Asterisks when Blending and How to Avoid Them - Tableau in Two Minutes
How to use Set Actions to Create Dynamic Sets - Tableau in Two Minutes
zhlédnutí 44KPřed 5 lety
How to use Set Actions to Create Dynamic Sets - Tableau in Two Minutes
Tableau Dimensions vs Measures and Discrete vs Continuous? Tableau in Two Minutes
zhlédnutí 20KPřed 5 lety
Tableau Dimensions vs Measures and Discrete vs Continuous? Tableau in Two Minutes
Cross Database Joins - Tableau in Two Minutes
zhlédnutí 13KPřed 5 lety
Cross Database Joins - Tableau in Two Minutes
Creating Complex Joins In Your Data Source - Tableau in Two Minutes
zhlédnutí 11KPřed 5 lety
Creating Complex Joins In Your Data Source - Tableau in Two Minutes
Using the Data Interpreter to Clean Data - Tableau in Two Minutes
zhlédnutí 57KPřed 5 lety
Using the Data Interpreter to Clean Data - Tableau in Two Minutes
Using Excel as a Tableau Data Source - Tableau in Two Minutes
zhlédnutí 89KPřed 5 lety
Using Excel as a Tableau Data Source - Tableau in Two Minutes
How to Pivot Data in the Data Source - Tableau in Two Minutes
zhlédnutí 62KPřed 5 lety
How to Pivot Data in the Data Source - Tableau in Two Minutes
Replicating an Excel Pivot Table in Tableau - Tableau in Two Minutes
zhlédnutí 34KPřed 5 lety
Replicating an Excel Pivot Table in Tableau - Tableau in Two Minutes
Tableau Basics for Beginners - Tableau in Two Minutes
zhlédnutí 1,8MPřed 5 lety
Tableau Basics for Beginners - Tableau in Two Minutes
Building a Tableau Dashboard from Scratch for #MakeoverMonday - Tableau in Two Minutes
zhlédnutí 10KPřed 5 lety
Building a Tableau Dashboard from Scratch for #MakeoverMonday - Tableau in Two Minutes
How to Dynamically Hide NULLs in Table Calculations - Tableau in Two Minutes
zhlédnutí 18KPřed 5 lety
How to Dynamically Hide NULLs in Table Calculations - Tableau in Two Minutes
Creating a Bullet Graph - Tableau in Two Minutes
zhlédnutí 29KPřed 5 lety
Creating a Bullet Graph - Tableau in Two Minutes
Using Context Filters and Improving Dashboard Performance - Tableau in Two Minutes
zhlédnutí 98KPřed 5 lety
Using Context Filters and Improving Dashboard Performance - Tableau in Two Minutes
Data 640 - Logistic Regression in Python
zhlédnutí 529Před 5 lety
Data 640 - Logistic Regression in Python
DATA 640 - SVMs in Python
zhlédnutí 262Před 5 lety
DATA 640 - SVMs in Python
Basic Data Cleaning with Python & Pandas - Machine Learning without Math
zhlédnutí 12KPřed 5 lety
Basic Data Cleaning with Python & Pandas - Machine Learning without Math

Komentáře

  • @sumeetkeluskar5589
    @sumeetkeluskar5589 Před 3 dny

    if it works in tableau desktop? have used this not working actually filters are not working is there any restriction in desktop

    • @penguinanalytics1984
      @penguinanalytics1984 Před dnem

      Hi there - this should work in any version of Tableau wehre you can build visualizations.

  • @dalesmf4310
    @dalesmf4310 Před 3 dny

    feels like you're going much quicker....haha....i'm trying to follow your Cursor to watch your prompts/clicks in tutorials

    • @penguinanalytics1984
      @penguinanalytics1984 Před dnem

      Some of the shorter videos I sped up a little to try and keep them short - this one might have been sped up a little too much! :) Sorry!

  • @dalesmf4310
    @dalesmf4310 Před 3 dny

    THANNNNNK YOU.

  • @riyarajani6930
    @riyarajani6930 Před 4 dny

    nice video. kuch smj ni aaya

  • @societalm9nace99
    @societalm9nace99 Před 4 dny

    Hello, I cannot find the link to the used dataset in the video description

    • @penguinanalytics1984
      @penguinanalytics1984 Před 4 dny

      Goodness - what an oversight on my part. Here's the link to the data. You'll have to cop/paste because CZcams. :) data.world/makeovermonday/2024w16-airhelp-global-airport-rankings

  • @priteshkhilnani
    @priteshkhilnani Před 5 dny

    Saw the full 2 mins, thanks!

  • @milosZcr
    @milosZcr Před 17 dny

    Thanks for the video. I actually saw the old one first. I wish i did two days ago when struggling with Tableau for the first time. You got a new sub here, studying to become a data scientist with a flavor of data analyst.

    • @penguinanalytics1984
      @penguinanalytics1984 Před 17 dny

      Thank you - the old one is very popular, and does the job, but there are a handful of small changes though, hence the update! Glad it helped! :)

  • @ericsbrennan
    @ericsbrennan Před 18 dny

    Can you also compare Tableau to PowerBI from a corporation deployment standpoint? How does each stack up when administering the corporate site. User login, Folder management and protection. Tableau has a really robust server and then site admin options. I can lock folders by groups or individuals. Each project then has a large array of settings to allow or limit users from filtering, downloading, editing, Saving. Tableau also has their subscriptions and alert messages that can be sent to anyone that subscripts to them when data meets and certain criteria. Everyone always compares the building piece, but it is difficult to find the consumption comparison.

    • @penguinanalytics1984
      @penguinanalytics1984 Před 17 dny

      I'll see what I can do - I work with corporate implementations of both, but I can't show any videos of the actual implementations because it's all proprietary. I'll see what I can find elsewhere though. :) The short answer is they're pretty similar, but Tableau is more centralized, whereas Power BI is more distributed. You can do a lot of the same things. I get the impression a lot of the Power BI development over the last few years has been catching up with what Tableau already does well.

  • @midunsathiyamoorthy593

    Thanks

  • @AnkurSharma-pl5zv
    @AnkurSharma-pl5zv Před 20 dny

    the speaker(creator) should use a better microphone or at least use the microphone away from his neck. the sound of taking a gulp of his own saliva is so annoying. arghhh!

  • @gohitoyo7280
    @gohitoyo7280 Před 20 dny

    How can I have the datasheet?

    • @penguinanalytics1984
      @penguinanalytics1984 Před 19 dny

      Hi there - the data for this dashboard is from Kaggle. This link is in the video description, but you'll need to copy/paste because CZcams doesn't allow live links. :) www.kaggle.com/datasets/mojtaba142/hotel-booking

  • @officesuperhero9611
    @officesuperhero9611 Před 23 dny

    Bro, I think you’re adding an extra T to your pronunciation of qualitative.

    • @penguinanalytics1984
      @penguinanalytics1984 Před 20 dny

      Ba - Apparently I am. I call that creative pronunciation, and apparently I did it all the way though. :D

  • @StellarXloudz
    @StellarXloudz Před měsícem

    I did not get that

    • @penguinanalytics1984
      @penguinanalytics1984 Před 17 dny

      It's all to do with how much they sell. If a few products make up most of their profit, they could have a large number of products that are sustainable, but those products only make up a small number of sales. Basically, the sustainable products are they sell very often. :)

  • @ShortalayPlays
    @ShortalayPlays Před měsícem

    The volume of products they make could be an important factor I am presuming.

    • @penguinanalytics1984
      @penguinanalytics1984 Před měsícem

      Bingo! No context to the numbers! Part 2 is coming tomorrow. I got the dates wrong. :D

  • @ladyashephd727
    @ladyashephd727 Před měsícem

    Key Point Indicators are the key to sound Business decisions.

  • @jameseichinger7262
    @jameseichinger7262 Před měsícem

    Thank you for changing my perspective on KPI formulation. I’m in Higher-Ed fundraising and our focus is entirely on gift officer goals without any consideration of KPIs or OKRs. I’m struggling to get people interested in the discussion.

  • @nclimey
    @nclimey Před měsícem

    First, you do not pay an extra $12,000. As you pay off the principal the interest payment gets smaller. For $30,000 at 8% for 5 years you actually pay about $6,500... So, yes you are paying an additional 13% over the 50k. But that allows you to get something beyond your immediate cash assets for $108 per month. The extreme of this is buying a house, and getting a mortgage where you can end up paying twice the purchase value over 25+ years. But without a mortgage only a tiny percentage of people would have enough liquid assets to pay for a house.

    • @penguinanalytics1984
      @penguinanalytics1984 Před měsícem

      I'm not suggesting you not finance a car or a house, just that you understand the cost of the financing. Often people look at the monthly payment in isolation and don't realize what they're paying for. All data needs context. :)

    • @nclimey
      @nclimey Před měsícem

      @@penguinanalytics1984 I don't know where you live, lots of places use dollars. In the US it is a requirement that a lender tells you the total cost of the loan, although I suspect some places are more upfront with this information than others. But people should also know how the interest on a loan works. Your example would be accurate on an interest only payment, but those are very unusual, and I doubt anyone would use one to buy a car. But I think it is almost as bad to overestimate the interest cost as not factoring it in. The formula for loan payments is not friendly....M = P [ i(1 + i)^n ] / [ (1 + i)^n - 1]. Gives you the monthly payment. But there are hundreds of loan calculators on the Internet which take care of the math for you. Suggest one of those rather than doing the math wrong.

  • @MEGABOBOBOXZGT
    @MEGABOBOBOXZGT Před měsícem

    The price ya pay for not having 50k, its how they make money giving you money. Can try for a better rate but if you need that car and theres nothing cheaper. Thats the price.

    • @penguinanalytics1984
      @penguinanalytics1984 Před měsícem

      Of course - but people don't realize what they're paying for or how much you really pay to lose someone else's money. It's not a scam, but people should be making an informed choice. :)

  • @DaleTarianJesdro
    @DaleTarianJesdro Před měsícem

    People are going to see this and say "It's a scam!" But in reality, that's a business.

    • @penguinanalytics1984
      @penguinanalytics1984 Před měsícem

      Totally - it's a business, but people should be making an informed choice. Most people don't understand how much they're paying or what they're paying for.

    • @nclimey
      @nclimey Před měsícem

      ​@@penguinanalytics1984Except you got the amount wrong. You are about 185% of the actual interest paid

    • @DaleTarianJesdro
      @DaleTarianJesdro Před měsícem

      @@penguinanalytics1984 100%, I just know there is always that one guy!

  • @DC-ut4hg
    @DC-ut4hg Před měsícem

    If you titled the sheets beforehand, could you still change the title in the dashboard independently?

    • @penguinanalytics1984
      @penguinanalytics1984 Před 17 dny

      Yes you can - I give my sheets meaningful names for the workbook, but titles that make sense to the audience in the dashboard.

  • @StellarXloudz
    @StellarXloudz Před měsícem

    The 75 percent

  • @tigerstallion
    @tigerstallion Před měsícem

    theyre both full of shit

  • @samamor575
    @samamor575 Před měsícem

    Thanks for this bro ❤

  • @viviwang8101
    @viviwang8101 Před měsícem

    why using inner join? shouldn't it be left join?

  • @juicepotter2967
    @juicepotter2967 Před měsícem

    can i know where to download the data

  • @hosseinbakhshian9602
    @hosseinbakhshian9602 Před měsícem

    Thanks for the perfect explanation, can you please share a direct link to the data used, I could not find it in the website

  • @Strongguy94
    @Strongguy94 Před měsícem

    Wtf 😂 this aint 2 mins

  • @jericsayson5073
    @jericsayson5073 Před měsícem

    File?

  • @miamac63
    @miamac63 Před 2 měsíci

    I was about to begin an online course, 'Creating Data Visualizations using Tableau' and learned that basically I needed to 'learn Tableau on my own' BEFORE taking the class! I was stunned. I didn't recall learning Tableau was a pre-requisite for the class. I mean, what purpose is the class except to 'teach you Tableau?' I felt assured I could go to CZcams and find videos that allow me to self learn and this video did not disappoint. Great job!! I learned so much and now I wish i could cancel the class altogether. What a waste of money and time.

  • @InHomeTutoringHonolulu
    @InHomeTutoringHonolulu Před 2 měsíci

    If you create a new sheet using the same data source after you've selected in your filter to apply to the same data source, is the new sheet automatically filtered as well? Great video thank you!

  • @IshanMurjhani
    @IshanMurjhani Před 2 měsíci

    Awesome

  • @alexgeld7173
    @alexgeld7173 Před 2 měsíci

    This isn't a histogram mate, it's a Barchart

  • @Shapiro-bn6mb
    @Shapiro-bn6mb Před 2 měsíci

    Tableau is so exceptionally odd to understand vs how simple powerbi is....thank you

  • @radish550
    @radish550 Před 2 měsíci

    Does the Excel file(s) need to be closed prior to connecting it to Tableau or it does not matter whether it is open or closed?

    • @penguinanalytics1984
      @penguinanalytics1984 Před 19 dny

      When I made this video it didn't, but these days it does seem to need to be closed before you can connect to it.

  • @aathiabithap8184
    @aathiabithap8184 Před 2 měsíci

    Thank you for this video. You made it very clear and easy to understand. It helped me to gain the basics :) I subscribed to your channel and going to start with your tableau videos list.

  • @mayanksahai942
    @mayanksahai942 Před 3 měsíci

    Two three twenty three minutes yaa yaa pretty close not a problem

  • @Mycatz
    @Mycatz Před 3 měsíci

    I'm working on a project and I uploaded two CSV files both have the same column names but if I add churn then switch over to the other dataset and click the link icon it's still not giving me the total count of churn from both databases.

  • @GUMB4LL3OOO
    @GUMB4LL3OOO Před 3 měsíci

    Thats not really 2 minutes mate 😅😅😅

  • @user-zl6pj4ro9j
    @user-zl6pj4ro9j Před 3 měsíci

    a life saver

  • @user-vo5qy3fi5e
    @user-vo5qy3fi5e Před 4 měsíci

    I am using tableau public and when I create the set the window doesnot open. It just creates a set without giving any option. Can someone plz help me?

  • @bubblebath2892
    @bubblebath2892 Před 4 měsíci

    I tried 720p but still cant see clearly the screen

  • @jrt2007gjdje
    @jrt2007gjdje Před 4 měsíci

    Your HD 1080p is 360p.

  • @lyekahkit9366
    @lyekahkit9366 Před 4 měsíci

    It didnt work out.

  • @r16099
    @r16099 Před 4 měsíci

    best video on the point and easy to grasp

  • @user-vo5qy3fi5e
    @user-vo5qy3fi5e Před 4 měsíci

    Plz share these excel files to practice

  • @ambreenjaved9113
    @ambreenjaved9113 Před 4 měsíci

    Can someone please help with the dataset?

  • @user-vo5qy3fi5e
    @user-vo5qy3fi5e Před 4 měsíci

    I have watched so many tutorials on youtube, no one shared this much detail. Thank you so much

  • @KseniaGerm
    @KseniaGerm Před 4 měsíci

    Great video! It took me 10 mins to notice its actually longer than 2 minutes :D yet very clear and helpful content!

  • @mariasylviaa7320
    @mariasylviaa7320 Před 4 měsíci

    Hai sir... can we import a excel file into tableau desktop and is sample superstore available in tableau desktop 2021 or should we have to install any package

  • @user-sv4ty1du1g
    @user-sv4ty1du1g Před 4 měsíci

    Thanks a lot