Beschreibung
Data Analyst with Python
Ziel
1. The Python guide for beginners
- Working with the Data Lab
- Basics and concepts in Python
- Saving numbers and texts as variables
- Bundling variables as groups in lists
- Reading and understanding error messages correctly
2. Programming basics
- Programming basics for data analysts
- Using functions and methods
- Process controls with the help of conditions
3. Loops and functions with Python
- Flow control with the help of loops
- Extending the functional scope of the code
- Importing additional Python packages
- Programming concepts for data analytics
4. Create data pipelines with pandas
- Get to know and use pandas
- Importing CSV files correctly
- Cleaning and aggregating data
5. Exploring data with matplotlib
- Visualizing different levels of data
- Displaying numerical data as histograms
- Displaying numerical data as scatter plots
- Visualizing categorical data as column and pie charts
6. Making statistically based predictions
- Overview of statistical principles
- Understanding and using medians and quartiles correctly
- Identifying outliers
- Predictions with linear and logistic regression
7. Incorporating internal data from SQL databases
- Important queries with SQL
- Making your own selections
- Reading data using the example of a personnel database
8. Incorporating external data via APIs
- Reading data from online databases
- Scraping data from websites
- Reading data via APIs
9. Data visualization with Advanced Jupyter
- Advanced functions in Jupyter Notebooks
- Presenting data in Jupyter Notebooks
- Dashboards with live updates and interactive features
10. Exercise project
- Complete data project from data cleansing to visualization
- Data analysis with professional data set (with over one million cab rides in New York)
- Analysis task for independent implementation
11. Final project
- Audit project on customer churn in a telecommunications company
- Independent analysis of the data project
- Presentation of results and 1:1 feedback meeting with mentoring team
- Receipt of the certificate for Data Analyst with Python
Kommende Starttermine
Inhalte / Module
In this practice-oriented training course, you will learn how to carry out data analyses with large data sets independently.
You will learn how to use Python competently, how to use the programming language for data analysis and how to create effective visualizations.
You will learn how to connect different data sources, filter and merge data from them.
After the training, you will be able to visualize company data in a meaningful way and make it interactively accessible in dynamic dashboards.
The technical entry hurdles are minimized by the use of Jupyter Notebooks, with which you can carry out the programming exercises directly in the browser.
Zielgruppe / Voraussetzungen
The online training course to become a Data Analyst with Python is suitable for anyone who wants to learn Python as a programming language and use it to carry out data analyses independently. No special requirements need to be met. The course is also suitable for career changers.
Infos anfordern
Haufe Akademie
Die Haufe Akademie setzt Standards im Bereich Weiterbildung im deutschsprachigen Raum und richtet sich an Fach- und Führungskräfte, die zukunftsorientiert denken. Unsere modernen Lerntechnologien und innovativen L&D Procurement Plattformen sind darauf ausgerichtet, Lernprozesse perfekt auf die dynamischen Anforderungen von heute...
Erfahren Sie mehr über Haufe Akademie GmbH & Co. KG und weitere Kurse des Anbieters.