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!
Improve your Python data importing skills and learn to work with web and API data.
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.
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.
Enter the world of Alteryx Designer and learn how to navigate the tool to load, prepare, and aggregate data.
Learn to clean data as quickly and accurately as possible to help your business move from raw data to awesome insights.
Learn to acquire data from common file formats and systems such as CSV files, spreadsheets, JSON, SQL databases, and APIs.
Explore Excel Power Query for advanced data transformation and cleansing to boost your decision-making and analysis.
Learn to connect Tableau to different data sources and prepare the data for a smooth analysis.
Learn how to clean data with Apache Spark in Python.
Learn to tame your raw, messy data stored in a PostgreSQL database to extract accurate insights.
Learn how to efficiently collect and download data from any website using R.
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
Parse data in any format. Whether it's flat files, statistical software, databases, or data right from the web.
Make it easy to visualize, explore, and impute missing data with naniar, a tidyverse friendly approach to missing data.
Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery
Develop the skills you need to clean raw data and transform it into accurate insights.
Master data preparation, cleaning, and analysis in Alteryx Designer, whether you are a new or seasoned analyst.
Master marketing analytics using Tableau. Analyze performance, benchmark metrics, and optimize strategies across channels.