Product Management
12 – Eco-Social Benefits
Discover how eco-social benefits enhance your business model. Learn to create value through sustainability and improve community well-being today!
Latest
Product Management
13 – KPI (Key Performance Indicators)
Discover how to set and track key performance indicators (KPIs) to enhance your product management and drive business success.
Visualization considerations
Master effective data visualization with essential guidelines and pro tips to ensure clarity and elegance in your presentations.
Data Visualisation
Unlock the power of data visualization! Learn how to transform complex data into clear, engaging visuals that drive better business decisions.
SQL
Types of data validation
Discover the six types of data validation to enhance data integrity and ensure accurate analysis. Master these techniques for better datasets!
Get started with data calculations
* As a data analyst, familiar tools and processes are frequently used, but learning new ones is essential for growth. * SQL can significantly improve efficiency when pulling data and conducting analysis. * Spreadsheets, conditional formulas, the SUMPRODUCT function, and pivot tables are useful tools for performing calculations in data analysis. * Pivot tables
SQL
Use subqueries to aggregate data {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
Use subqueries to refine data {SQL}
Master SQL subqueries to refine your data analysis on New York Citi Bikes and support sustainable urban transport initiatives.
Data aggregation
Explore how SQL JOINs work
Master SQL JOINs with our guide! Learn how to connect tables effectively and enhance your database skills for better data management.
Data aggregation
Aggregate data for analysis
Unlock insights with effective data aggregation! Learn how to combine data sources for powerful analysis and trend identification.
Data aggregation
VLOOKUP {data aggregation}
Master VLOOKUP to effortlessly find and aggregate data in your spreadsheets. Unlock the power of efficient data analysis today!
Exploratory data analysis or EDA
Unlock the power of Exploratory Data Analysis (EDA)! Learn essential techniques for cleaning, visualizing, and interpreting your datasets effectively.