Datenaufbereitung in Excel
Verstehen Sie, wie Sie Excel-Daten mit logischen Funktionen, verschachtelten Formeln, Suchen und PivotTables vorbereiten.
Folgen Sie kurzen Videos, die von erfahrenen Trainern geleitet werden, und üben Sie das Gelernte mit interaktiven Übungen in Ihrem Browser.
Verstehen Sie, wie Sie Excel-Daten mit logischen Funktionen, verschachtelten Formeln, Suchen und PivotTables vorbereiten.
Lernen Sie, Daten aus verschiedenen Quellen wie Excel, SQL, SAS und dem Web in Python zu importieren.
Lernen Sie, schmutzige Daten zu diagnostizieren und zu behandeln, um genaue Einblicke zu gewinnen!
Verbessern Sie Ihre Python-Datenimportfähigkeiten und lernen Sie, mit Web- und API-Daten zu arbeiten.
In diesem interaktiven Power BI-Kurs lernen Sie, wie Sie den Power Query Editor zur Datenaufbereitung nutzen.
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.
In this course, you will learn to read CSV, XLS, and text files in R using tools like readxl and data.table.
Explore Excel Power Query for advanced data transformation and cleansing to boost your decision-making and analysis.
Learn to retrieve and parse information from the internet using the Python library scrapy.
Lernen Sie, Daten schnell und genau zu bereinigen, um Ihr Unternehmen von Rohdaten zu tollen Erkenntnissen zu führen.
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 tame your raw, messy data stored in a PostgreSQL database to extract accurate insights.
Parse data in any format. Whether its flat files, statistical software, databases, or data right from the web.
Learn to use the KNIME Analytics Platform for data access, cleaning, and analysis with a no-code/low-code approach.
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.
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.
Make it easy to visualize, explore, and impute missing data with naniar, a tidyverse friendly approach to missing data.
Advance your Alteryx skills with real fitness data to develop targeted marketing strategies and innovative products!