Data Preparation in Excel
Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.
Follow short videos led by expert instructors and then practice what you’ve learned with interactive exercises in your browser.
Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.
Learn to import data into Python from various sources, such as Excel, SQL, SAS and right from the web.
Learn to diagnose and treat dirty data and develop the skills needed to transform your raw data into accurate insights!
In this interactive Power BI course, you’ll learn how to use Power Query Editor to transform and shape your data to be ready for analysis.
Improve your Python data importing skills and learn to work with web and API data.
Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.
Enter the world of Alteryx Designer and learn how to navigate the tool to load, prepare, and aggregate data.
Explore Excel Power Query for advanced data transformation and cleansing to boost your decision-making and analysis.
In this course, you will learn to read CSV, XLS, and text files in R using tools like readxl and data.table.
Learn to retrieve and parse information from the internet using the Python library scrapy.
Learn to clean data as quickly and accurately as possible to help you move from raw data to awesome insights.
Learn to connect Tableau to different data sources and prepare the data for a smooth analysis.
Learn to acquire data from common file formats and systems such as CSV files, spreadsheets, JSON, SQL databases, and APIs.
Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
Learn how to clean data with Apache Spark in Python.
Master data preparation, cleaning, and analysis in Alteryx Designer, whether you are a new or seasoned analyst.
Learn to use the KNIME Analytics Platform for data access, cleaning, and analysis with a no-code/low-code approach.
Parse data in any format. Whether its flat files, statistical software, databases, or data right from the web.
Learn to tame your raw, messy data stored in a PostgreSQL database to extract accurate insights.
Explore Alteryx Designer in a retail data case study to boost sales analysis and strategic decision-making.
Learn how to efficiently collect and download data from any website using R.
Make it easy to visualize, explore, and impute missing data with naniar, a tidyverse friendly approach to missing data.
Master marketing analytics using Tableau. Analyze performance, benchmark metrics, and optimize strategies across channels.
Develop the skills you need to clean raw data and transform it into accurate insights.
Advance your Alteryx skills with real fitness data to develop targeted marketing strategies and innovative products!