Data With Luis

My recommended Tableau learning resources I've consolidated all my recommended Tableau learning resources into this page. From beginners to experts, there is something here for everyone to level up their skills.  Download Tableau Tableau for students (FREE)  Tableau Public download Getting Started/Classroom Training Tableau Starter Kit Hands-On Practice MakeoverMonday Tiktok Video Blog Post WorkoutWednesday YouTube Channels Tableau Tim Andy Kriebel Alex The Analyst DataWithLuis

My recommended SQL learning resources I've consolidated all my recommended SQL learning resources into this page. From beginners to experts, there is something for everyone. SQL Learning  Here are my favorite courses and practice websites if you're just getting started with SQL! Udacity - SQL for Data Analysis Sololearn Sql-practice.com Blog Post TikTok Video SQL Games These two free SQL games will help you level up your SQL Skills! SQL Island SQL Murder Mystery Blog Post TikTok Video SQL Practice Interview Questions Once you are feeling confident with SQL it's time to start doing practice interview questions! All these websites offer robust catalogs of free questions but also offer a premium membership if you are interested in more practice.  Datalemur.com Hackerrank.com Leetcode.com Blog Post TikTokVideo  

Check out these two entertaining websites that teach SQL through interactive games and scenarios. Not only will you have fun playing, but you’ll gain job-ready SQL skills for investigating and making sense of data. SQL Island  SQL Island  provides a visualization game for learning fundamental SQL concepts. You’ve crash-landed on an island and have to query 3 different tables to make your way out. As you progress through the story you’ll learn key statements like SELECT, FROM, WHERE, JOINs, aggregates, and more. With each mission, you’ll need to construct SQL queries to extract and analyze information to uncover insights. This hands-on structure helps you quickly grasp SQL syntax and analytical thinking needed for data analytics roles. You’ll gain essential knowledge of how to investigate and draw conclusions from databases – a must for data-driven jobs, and you even get a completion certificate at the end!  Just make sure to use the 'sprache wechseln' button to chang...

I think I just found my new favorite SQL practice website. The website is called sql-practice.com  and it is completely free.  This all-in-one website offers SQL training, as well as SQL practice questions. SQL Learning SQL-practice.com has a section called "Learning resources" that includes tutorials for basic SQL queries, filtering, functions (Aggregate, Window, String, etc.), and table manipulation. The tutorials are pretty basic, but work great as a refresher. But if you're just starting out, I still recommend starting with an interactive course like Udacity or SoloLearn .  SQL Practice  SQL-practice.com  is also a great place to practice and test your SQL skills.  It lets you write and run SQL code against two different sample databases. One database has data related to hospital patients and has four tables, and the other one has sample sales data for a fictitious company called Northwind Traders and has eleven tables. You're able to see the schemas f...

As a data analyst, you can spend up to 80% of your time working on data preparation tasks. These tasks include but are not limited to data gathering, data cleaning, and data transformation. Therefore if you want to break into data analytics it's a great idea to build learning this skill into your data analytics learning path . Thankfully, Alteryx makes it very easy to learn. Alteryx is a data analytics platform that enables users to prepare, blend, and analyze data from various sources through a user-friendly interface, streamlining the data preparation and analysis process. They have an amazing program called Alteryx for Independent Learners , as part of their Alteryx SparkED program . The Alteryx for Independent Learners program provides you with: Learning modules (learning paths, weekly challenges, videos) Access to engage with an entire community of peers A 90-Day license for Alteryx Designer, which can be renewed if you complete the Alteryx Designer Core certification within ...

 Here is everything I would learn if I were trying to break into an entry-level data analyst role today. Just as a disclaimer, I don't think you necessarily need a college degree to be a data analyst, but a degree (in anything) certainly helps! @datawithluis Replying to @Eljay This is everything I would learn if I were trying to become a data analyst without any experience. -Excel -SQL -Data Visualization -Tableau -Networking All the links are in my bio, let me know if you have any questions, and follow me for more data content #DataAnalytics   #DataAnalyst   #SQL   #Tableau   #alteryx   #python   #PowerBI   #excel #careeradvice #breakintotech #jobtok #STEM ♬ original sound - Luis - Data Analyst Intermediate Excel (Lookups (V, X, H), Pivot Tables, String Functions, Statistical Functions) W3 Schools Excel Tutorial Youtube: FreeCodeCamp TikTok: MissExcel Intermediate SQL (Data Types, Joins, Group By, Aggregate Functions, Window Functions, Data Preparation, Perf...

I didn't originally set out to become a data analyst, but it turned out to be a great career decision that led to a rewarding and fruitful career.  In this blog post, I'll share the story of how I became a data analyst, the challenges I encountered along the way, and the valuable lessons I learned. Let's start with my background. I hold a Bachelor's degree in Management Information Systems (MIS), also known as Computer Information Systems (CIS) or IT Management. During my time in college, I embarked on five diverse internships at different companies to explore the vast field of IT and determine my area of focus. Upon graduating, I landed a position as a Jr IT Business Analyst at a Fortune 50 company. This role involved deploying transportation planning software across various divisions. I performed tasks such as gathering requirements, QA testing, and managing work-intake processes. However, after about a year and a half, I started feeling a sense of monotony. At that p...

Power BI is one of the top data visualization tools to have in your arsenal as a data analyst. By mastering Power BI, data analysts can efficiently process, transform, and visualize data, enabling them to uncover valuable insights and trends. Power BI's interactive dashboards and reports empower analysts to present complex information in a user-friendly manner, fostering effective communication and understanding among stakeholders. Additionally, Power BI's integration with other Microsoft tools and its wide adoption in the industry make it a valuable skill that can boost a data analyst's career prospects and opportunities. Here are my favorite FREE resources to get started with Power BI: Download PowerBI -  Downloads | Microsoft Power BI Microsoft Learn:  Microsoft Learn offers traditional e-learning, finish the following learning paths to learn all the theory and best practices for Power BI directly from Microsoft.  Get started building with Power BI - Training | M...

I am a huge advocate for hands-on practice when it comes to learning data skills. Whether it's SQL , PowerBI , or Tableau , I will always recommend completing hands-on exercises as part of your learning to become a Data Analyst. As I covered in one of my latest posts  Data Preparation is a crucial skill for data analysts to have in their arsenal, and in this post I will be discussing what I believe to be the best website to practice your data preparation skills, Preppindata.com The website offers a range of challenges and exercises that simulate real-world data scenarios, allowing analysts to practice and refine their data preparation techniques. By providing step-by-step solutions and fostering community discussions, preppindata.com creates an environment for learning and collaboration among data professionals. The platform is important for data analysts because it helps them become more proficient in cleaning, formatting, and transforming raw data, which are critical steps in ens...

As a data analyst, your job is to turn raw data into valuable insights that can inform business decisions. However, before you can even begin analyzing the data, you must first prepare it. This process involves cleaning, formatting, and transforming the data to ensure it is accurate and consistent. Without proper data preparation, your analysis could be flawed and unreliable. Therefore, mastering data preparation is a crucial skill for any data analyst. It will not only save you time and frustration but also ensure that your findings are accurate and trustworthy.  Data Preparation can be done in a number of ways, whether it's by using SQL, with tools like Tableau Prep and Alteryx, PowerQuery in PowerBI or Excel, or using Python.  Here are some of the more common tasks that you'll do during data preparation: Changing column names Changing column data types Splitting columns Removing columns Adding/Removing Prefixes/Suffixes to rows Joining Tables Unioning Tables Watch the video...

So you've mastered the SQL Basics . Now what? Now it's time to work on SQL Practice questions.  SQL practice questions are an excellent way to build proficiency in the language by providing a structured approach to learning. These questions are designed to test and reinforce your understanding of SQL concepts and syntax. They help improve problem-solving skills by presenting challenges that require you to think critically and develop creative solutions.  Solving SQL practice questions also prepares you for interviews. SQL is a commonly tested skill in job interviews for data-related positions. Practicing SQL questions beforehand can help you build the confidence to answer technical questions and perform well in interviews. Here are three websites (free and paid) you can use to work on SQL practice questions. They all have beginner to advanced questions that will test your skills!  Leetcode -  SQL - Study Plan - LeetCode   Free & Paid Tiers 33 Free questions...

If you're looking to break into the field of data analytics, networking is essential for success. While having the right skills and education is important, building a strong professional network can help you gain valuable insights, find new job opportunities, and accelerate your career growth. Here are some reasons why networking is crucial when breaking into data analytics: Access to Job Opportunities: more and more job openings  are not advertised and are filled through networking . By building relationships with other professionals in the field, you may gain access to job openings that you wouldn't have found otherwise. Learning About New Trends and Technologies: The field of data analytics is constantly evolving, with new technologies and trends emerging all the time. Networking can help you stay up to date with the latest developments and learn from other professionals who are working on cutting-edge projects.  Getting Advice from Experienced Professionals: Networking pr...

As part of the data cleaning process, you will most likely run into a situation where you will have to merge data that is stored in multiple columns.  Some common scenarios I have seen are: Merging separate First Name, and Last Name columns into one "Full Name" or "Customer Name" Column. Creating a "Full Address" column out of separate "Street Address", "City", "State", and "ZipCode" columns. Merging a "CustomerID" column and an "OrderID" column to create a unique identifier. Watch the video below to learn how to merge multiple columns using PowerQuery in PowerBI. @datawithluis How merge in columns in PowerBI. #DataAnalyst #analyst #powerbi #analytics #dashboard #powerquery #powerbitips #datavisualization #businessintelligence ♬ original sound - Luis - Data Analyst Leave me a comment on TikTok if you have any questions! 

PowerQuery has a great set of tools called the "Data Profiling" tools that allow you to quickly understand the quality, distribution, and profile (descriptive statistics) of your dataset.  The Column Quality tool allows you to see the percent rows that are valid, blank, or have errors (typically an error row doesn't match the column data type). The Column Distribution tool gives you a quick visual of the value distribution in each column, along with a count of distinct and unique values contained in every column. I find this tool to be super helpful for data validation as you can use it to quickly spot data errors like 'USA' and 'USA ', where the second one has an extra blank. The Column Profile tool gives you a summary of all the statistics regarding your column sample, it includes the minimum value, max value, standard deviation, unique values, distinct values, and the number of values. It can be very helpful when trying to spot outliers or wrong values....

 Watch the video below to learn how to use parameters in Tableau to switch measures and titles in your visuals. This is a quick and easy skill you can practice and add to your Tableau portfolio . @datawithluis How to swap measures and titles in tableau using Parameters. Follow me for more Data Analytics content. #DataAnalyst #Analyst #Tableau #Analytics #Dashboard #DataTok #BusinessIntelligence #DataVisualization #DataHelp #TableauHelp #TableauTips ♬ original sound - Luis - Data Analyst Leave me a comment on TikTok if you have any questions!  

As a Data Analyst, you will use a visualization tool like Tableau to show off your analysis or build dashboards for your stakeholders to slice and dice their data.  That’s why building a Tableau portfolio is so important to land your next opportunity. It shows potential employers that you have the visualization skills they need and also shows your approach to getting insights from data.  Thankfully, Tableau makes it easy to build and host a portfolio to show off to potential employers with their Tableau Public website. With it, you can make a profile and host your work. Here are some great examples. I recommend you follow all of them. Andy Kriebel | Tableau Public Kevin Flerlage | Tableau Public Ken Flerlage | Tableau Public Eva Murray | Tableau Public Before we get started on building your own portfolio you need to get your own copy of Tableau Desktop or Tableau Public. If you don't have access to Tableau Desktop, download the free Tableau Public tool. It's completely free...

I think SQL is the most important tech skill for a Data Analyst to know. It allows you to find and manipulate data without waiting on an IT team or a Data Engineer to find and manipulate data for you. You can watch this video to learn more about why SQL is so important for a Data Analyst.  Below are my favorite FREE  SQL learning resources: SQL for Data Analysis | Free Courses | Udacity : This free course from Udacity covers everything a beginner Data Analyst should know. It covers SQL Basics (SELECT, FROM, WHERE), Joins, Aggregations, Data Cleaning, and Window Functions. It has a mix of video and written lectures along with quizzes to help you master the content. They advertise that it takes about 4 weeks to complete the course, but I think it's completely worth the time investment.  Sololearn: Introduction to SQL : Sololearn offers a great introductory SQL course that covers all the basics from SELECT statements to SQL best practices and creating/deleting tables....

While I'm always a huge advocate for hands-on practice when it comes to your journey to become a Data Analyst, you do have to know the theory behind the best practices for data analytics. Here are some of the books I find myself recommending time and time again, to help you become the best data analyst you can be. Try to find these for free at your local library, or I've included Amazon links to all, note that as an Amazon associate, I can earn a commission from purchases made using the links below . Storytelling With Data  - I recommend this to anyone working with data. Whether you are a professional or just starting your Analytics journey, this book will improve your reporting and presenting skills. And most importantly, it will teach you how to pick effective visuals for your data and the best way to format them. Storytelling with Data: Let's Practice  - The sequel to 'Storytelling with data', It offers hands-on exercises and challenges designed to reinforce th...