Channel Title: Penguin Analytics Channel Description: Talk data, better. Penguin Analytics creates content to help data folks understand business and business folks understand data. The OG videos - Tableau in Two Minutes - present complex concepts about Tableau and data visualization, data calculation and similar subjects in a time-efficient way, along with practical, grounded advice to apply to your own work. <video> Add Interactivity To Tableau With Dashboard Actions - Tableau in Two Minutes Description: Master the art of creating engaging and powerful Tableau dashboards through interactivity! This comprehensive tutorial covers the five essential Tableau dashboard actions that will transform your data visualizations and dashboards: 1. Filter actions 2. Highlight actions 3. Navigation actions 4. Set actions 5. Parameter actions Learn how to use these dynamic tools to customize your dashboards, enhance flexibility, and extend the user experience beyond basic visualizations. Discover techniques to change displayed data, highlight similar items, set up benchmarks, create references, and more. Perfect for both beginners and advanced users, this video will show you step-by-step how to set up and customize each action type. Apply these skills to create interactive data storytelling experiences that captivate your audience. Real-world applications: - Use filter actions to create drill-down reports for sales analysis - Implement highlight actions to showcase related data points across multiple charts - Benchmark one set of stores or products against another - Create calculations to total sales numbers across a dynamic set of territories or products. Video Timeline: 00:00 Introduction 00:46 Filter Actions 04:45 Highlight Actions 06:50 Navigation Actions 08:41 Set Actions 12:59 Parameter Actions Elevate your Tableau skills and start building dynamic, user-friendly dashboards today! Don't forget to like, subscribe, and share your own Tableau action tips in the comments below. </video> <video> I Cheated On Tableau with Power BI Description: 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 Introduction 00:27 Data Connections 01:42 Visualization Options 02:26 Calculations 03:16 Analysis 04:08 Dashboard Layout 04:36 Learning Curve 05:28 Conclusion </video> <video> Four Common Data Job Titles Explained! Description: In this video, we'll break down four of the most common roles and job titles within data analytics/data science. We'll explain the similarities and differences between these job titles: - Business intelligence analyst - Data analyst - Data scientist - Data engineer Every one plays a critical role in data operations and the impact data science and data analytics can have on a business or organization. We'll discuss the responsibilities, the type of work they do, they programs and skills they use, as well as how close they are to the business. When you're looking at roles in data analytics, the different job titles can be very confusing - who is doing what? Even though is a lot of overlap between them, there are some themes we can use to conceptualize the type of work each does. 00:00 Introduction 01:02 Business Intelligence Analyst 01:55 Data Analyst 02:55 Data Scientist 03:42 Data Engineer 04:56 Quick Review </video> <video> 3 Ways To Do Time Series Analysis In Tableau - Tableau in Two Minutes Description: 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: https://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! </video> <video> Test Your Data Literacy - Which Company is More Sustainable? Description: Want to test your data literacy? Which of the two companies do you think is most sustainable? This is a test of your data literacy. Can you see what's missing from information on the slide before we tell you at the end of the video? This is something that seems obvious at first, but if you look deeper, you'll find it's more challenging than you expected! </video> <video> The two types of data you need for good storytelling! Description: Good data storytelling needs numbers from the data, but it also needs qualitative data. Details from conversations, context and other information that explains the why behind the trends and movement we see in the numbers. #datascience #datastorytelling #dataanalytics #dataliteracy </video> <video> How to Create a Data Story in Tableau - Tableau in Two Minutes Description: 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 what the data is telling them and what our story is about. Here's a link to the data we used in this video: https://data.world/makeovermonday/2024w16-airhelp-global-airport-rankings 00:00 Introduction 00:25 Examining the Dataset 01:36 Thinking About The Audience 02:38 Picking an Audience For Our Story 03:30 Exploring the Data in Tableau - Bar Chart 04:43 Exploring the Data in Tableau - Map 06:15 Exploring the Data in Tableau - Scatter Plot 08:55 Sketching the Dashboard Design 11:38 Building the Dashboard in Tableau 12:10 Creating the Final Bar Charts 13:52 Creating the Final Scatter Plots 15:16 Calculated Field to Highlight Top and Bottom Airports 19:00 Laying Out the Dashboard 21:39 Removing Visual Clutter from Bar Charts 25:13 Removing Visual Clutter from Scatter Plots 28:21 Removing Visual Clutter from Map 30:17 Why we Add Commentary 32:28 How to Find Commentary 32:31 Commentary on the Dashboard 36:37 Wrap Up and Review 37:56 Thanks for Watching! </video> <video> SQL Tutorial for Beginners: Master the Basics in 20 Minutes! Description: Unlock the power of SQL with this comprehensive beginner's tutorial! In just 20 minutes, you'll gain a solid foundation in SQL. This concise SQL tutorial is tailored for beginners, covering key concepts that data analysts and scientists use daily. You'll learn: 1. What SQL is and its real-world applications 2. Basic SELECT statements for data retrieval 3. Filtering data with WHERE clauses 4. Data aggregation using GROUP BY and aggregate functions 5. The four fundamental types of JOINs with practical examples Each concept is explained clearly with hands-on examples using the Stack Overflow database, which you can access for free to practice your new SQL skills. Access the Stack Overflow database here: data.stackoverflow.com Video Timeline: 00:00 Introduction 00:32 SQL Fundamentals 01:59 Practice Environment Setup 02:59 SELECT Statements 04:33 WHERE Clauses 06:02 Comparison Operators 06:35 Aggregation and GROUP BY 09:47 Aggregate Function Types 10:17 SQL Comments 11:52 JOIN Operations 15:35 Practical JOIN Example 19:55 Database Documentation 20:59 Conclusion and Next Steps Whether you're aspiring to become a data analyst, preparing for a technical interview, or simply curious about SQL, this tutorial provides the perfect starting point. By the end, you'll have the confidence to write basic SQL queries and a clear path for further learning. Start your SQL journey today with this beginner-friendly tutorial and take the first step towards mastering database manipulation! </video> <video> Top 3 Soft Skills for Data Analysts Description: Take your career to the next level by mastering these 3 soft skills. I've been in analytics over a decade, and the analyst that can do these things well are the ones who get the best reviews and get promoted first. We'll talk about what the skills are, why they're important, and how you can give yourself opportunities to practice them1 Learn how to be the best analyst on your team! Discover the 3 essential soft skills for data analysts that can accelerate your career. With over a decade of experience in analytics, I reveal the three key abilities that set top-performing analysts apart: - Understanding the business and stakeholders - Communicating data to non-technical audiences - Tailoring your message to your audience Learn why these soft skills are crucial and how you can develop them. Whether you're new to the field or looking to advance, mastering these skills will help you stand out and fast-track your promotions. 00:00 Introduction 00:06 Understanding Your Stakeholders 01:13 Talking Data to Non-Data People 03:05 Tailoring Your Message To Your Audience 04:21 Conclusion </video> <video> Build An Interactive Tableau Dashboard - Start to Finish Description: Master the art of building an Interactive Tableau Dashboard from Start to Finish in this comprehensive tutorial! Perfect for beginners, this step-by-step guide will transform you from a Tableau novice to a dashboard pro. Interactive dashboards outshine static infographics and empower users to explore data like never before. Discover how actions and filters can bring your visualizations to life and hook your audience! What You'll Learn in This Tableau Dashboard Tutorial: 1. Connect to data sources. 2. Craft three visualizations. 3. Design and layout an eye-catching dashboard 4. Implement filters and interactivity that wow your audience 5. Master layout containers to polish the look 6. Introduce advanced interactivity features Take the first steps towards making your dashboards responsive, interactive and user-friendly! The data I'm using is here: https://www.kaggle.com/datasets/mojtaba142/hotel-booking 00:00 Introduction 00:20 Connect to Data 00:53 Data Fields and Dimensions vs Measures 01:50 Planning The Dashboard 02:15 Create Line Graph 03:51 Create Bar Chart 1 04:19 Create Bar Chart 2 04:50 Create Dashboard with Floating Layout 07:05 Adding Filter Actions to the Viz's 07:51 Adding Filters (aka Quick Filters) 08:35 Applying Filters to Multiple Sheets 09:23 Adding Filters to Dashboard 10:05 Formatting Filters 11:41 Adding Viz Titles 13:13 Add Dashboard Title 13:30 Adding Layout Containers 21:11 Other Ways To Add Interactivity With Actions 23:30 Conclusion Take Your First Steps in Tableau Dashboard Creation - By the end of this tutorial, you'll have the skills to create responsive, interactive, and user-friendly Tableau dashboards that stand out from the crowd! #TableauDashboard #InteractiveTableau #DataVisualization #TableauTutorial </video> <video> Learn Power BI! A Tutorial for Beginners Description: Looking to learn Power BI? This tutorial for beginners will guide you through the basics of this powerful data visualization tool step by step. Go from knowing nothing to building your first Power BI visualizations and dashboard in just a few minutes! We walk through how to connect to data, create calculations, create visualizations and lay out your dashboards, all in a few minutes and using the 2024 version of Power BI. Connect Power BI to a CSV file with hotel booking data from Kaggle, preview in Power Query, create new columns to calculate some things missing from the dataset, calculate an aggregated field and create a visualizations to explore the data. We demonstrate some calculations with the date and show you how to drill up and drill down a date hierarchy, create a line graph, and finally add a filter and header to finish off our first Power BI dashboard! 00:00 Introduction 00:28 Connecting Power BI to Data 01:02 Transform Data in Power Query 01:50 Power BI Main Screen 02:33 Creating a New Column 04:20 Creating a Measure 06:17 Creating a Table 06:41 Changing The Aggregation of a Field 07:18 Difference Between Columns and Measures 08:04 Creating a Bar Chart 09:06 Changing the Chart Type 09:27 Aligning Charts in the Dashboard 10:08 Creating a Date Field 12:41 Drilling Up and Down With Dates 14:07 Cross Filtering in Power BI 14:33 Adding a Filter 15:05 Adding a Header 16:20 Conclusion </video> <video> How To Get Unlimited Practice SQL Problems! Description: Get an UNLIMITED number of SQL practice questions from ChatGPT you can use to build your SQL skills online for free! If you want to practice your SQL, but don't have access to a data warehouse, you don't have to come up with your own business questions to answer. Use this quick trick to get as many practice problems as you want! Video Timeline: 00:00 Stack Overflow Database 00:23 Finding the Documentation 00:51 Prompting ChatGPT 1:07 The Results! </video> <video> Top 3 Hard Skills To Be A Data Analyst Description: Become the data rockstar you've always been by mastering the three core technical skills every successful data analyst needs: SQL: The language of databases Data Visualization Tools: Bringing insights to life Excel: The versatile analyst's swiss army knife I have a decade of experience in the field, and I've found the analysts who excel in these areas consistently outperform their peers. Whether you're starting your journey or looking to refine your skillset, this video breaks down why these technical skills are crucial for data analysts and how you can develop them. Learn how mastering SQL, data visualization, and Excel can make you a better analyst and propel your career forward. 00:00 Introduction 00:10 SQL 02:17 BI/Dashboard Tool 03:46 Excel 05:06 Conclusion </video> <video> Speed Up Your Tableau Workbooks Description: Do you have a slow Tableau Workbook you'd like to speed up? This video will walk you through how you can troubleshoot and speed up Tableau workbooks that are running slowly. We'll talk through how to do performance testing, make changes in the data source, on dashboards and in the worksheets, as well as share tips to design for performance from the beginning so you can avoid slowness in the future! Your stakeholders will love your fast, optimized Tableau workbooks and dashboards when you use the Tableau performance tricks you'll learn in this video! 00:00 Introduction 00:21 What Impacts Performance? 02:01 Workbook Optimizer 02:45 Performance Recorder 03:25 Data Source Filters 04:05 Moving Filters to Context 05:18 Limit Data You Load 05:40 Optimize Data Structure 06:15 Assume Referential Integrity 06:39 Use a Data Extract 07:45 Hide Unused Fields 08:38 Materialize Calculations/Compute Calculations Now 09:10 Minimize Sheets, Filters and Containers 10:05 Optimizing Filters 11:14 Simple Views are Fast 12:12 Optimizing Calculations 13:20 Optimal Data Types 13:52 Move Complex Calcs to Data Source 14:05 Listen to Warnings! 14:30 Marks on Map </video> <video> Sort a Tableau Table on ANY Column! Description: Sorting a table in Tableau can be frustrating... but you CAN sort on any column you want! The solution is a little funky, but dynamic sorting in Tableau is possible. In this Tableau in Two Minutes video, I'll show you how to use a parameter and a calculated field to set the sort order of a table to whichever field you want, even if what you're using other fields in the table! Data is from Makeover Monday and is Available here: https://data.world/makeovermonday/2024w16-airhelp-global-airport-rankings 00:00 Introduction 00:12 Whats the Problem? 01:09 Creating the Parameter 01:54 Creating the Calculated Field 03:24 Conclusion Learn how to easily sort a Tableau table on any column with this quick and simple tutorial. Master dynamic sorting in Tableau and make your data analysis a breeze! </video>

Contacts and Links

Description

Talk data, better.

Penguin Analytics creates content to help data folks understand business and business folks understand data.

The OG videos - Tableau in Two Minutes - present complex concepts about Tableau and data visualization, data calculation and similar subjects in a time-efficient way, along with practical, grounded advice to apply to your own work.

Videos from channel