Data With Luis

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 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!