SQL
WarehouseWarehouse.csv484 Bytesdownload-circleOrdersOrders.csv352 KBdownload-circle HAVING function Allows you to add a filter to your query instead of the underlying table that can only be used with aggregate functions CASE function Returns records with your conditions by allowing you to include if/then statements in your query Aliasing When you
SQL
Master SQL subqueries to refine your data analysis on New York Citi Bikes and support sustainable urban transport initiatives.
Data aggregation
Master SQL JOINs with our guide! Learn how to connect tables effectively and enhance your database skills for better data management.
Data aggregation
Unlock insights with effective data aggregation! Learn how to combine data sources for powerful analysis and trend identification.
Data aggregation
Master VLOOKUP to effortlessly find and aggregate data in your spreadsheets. Unlock the power of efficient data analysis today!
Unlock the power of Exploratory Data Analysis (EDA)! Learn essential techniques for cleaning, visualizing, and interpreting your datasets effectively.
Data Analytics
Unlock your potential with the Google Advanced Data Analytics Certificate! Dive into Python and master data preparation for impactful insights.
Learn how to format and adjust data effectively, ensuring accuracy and consistency in your analysis with practical tips and functions.
Master data organization for analysis! Learn key phases to identify trends and enhance decision-making skills effectively.
Learn to document your data-cleaning process effectively, recover errors, and ensure data quality with practical changelog strategies.
SQL
Master manual data cleaning with proven strategies! Learn how to verify accuracy and build trust in your data analysis process.
Product management
Discover strategies to boost sales and retain customers through the transaction game. Unlock your business's potential today!