- Aby wziąć udział w tym kursie, nie trzeba spełniać żadnych szczególnych wymagań.
Analityka danych jest dziś kluczowym narzędziem w biznesie. Skoncentrujemy się na rozwijaniu umiejętności praktycznej analizy danych. Celem kursu jest pomoc uczestnikom w udzielaniu opartych na dowodach odpowiedzi na pytania:
Co się stało?
- przetwarzanie i analizowanie danych
- tworzenie informacyjnych wizualizacji danych
Co się wydarzy?
- prognozowanie przyszłych wyników
- ocena prognoz
Co powinno się wydarzyć?
- przekształcanie danych w decyzje biznesowe oparte na dowodach
- optymalizacja procesów
Sam kurs może być prowadzony w formie 6-dniowego kursu stacjonarnego lub zdalnie przez okres kilku tygodni, jeśli wolisz. Możemy współpracować z Tobą, aby zapewnić kurs najlepiej odpowiadający Twoim potrzebom.
Podstawowy Excel
- Nawigacja
- Manipulowanie danymi
- Praca z formułami i adresami
- Wykresy
Zaawansowane Excel
- Funkcje logiczne
- Analiza scenariuszy
- Solver
- Makra
- Pierwszy rzut oka na kod: VBA
VBA
- Typy danych
- Pisanie funkcji
- Kontrolowanie programu: ocena warunkowa i pętle
- Techniki debugowania
Analiza danych z Python
- Wprowadzenie Python
- Zmienne i typy
- Manipulowanie danymi w Python przy użyciu Pandas
- Pisanie funkcji
- Wizualizacja danych przy użyciu Matplotlib i Seaborn
- Zarządzanie danymi za pomocą Pandas
Wprowadzenie do Machine Learning z Python
- Regresja liniowa przy użyciu scikit-learn
- Drzewa klasyfikacyjne i regresyjne z Python
- Klasyfikacja przy użyciu maszyn wektorów nośnych i Random Forest
- Techniki klastrowania przy użyciu scikit-learn
United Arab Emirates - Data Analytics with Excel, VBA and Python - From the Ground Up
Qatar - Data Analytics with Excel, VBA and Python - From the Ground Up
Egypt - Data Analytics with Excel, VBA and Python - From the Ground Up
Saudi Arabia - Data Analytics with Excel, VBA and Python - From the Ground Up
South Africa - Data Analytics with Excel, VBA and Python - From the Ground Up
Brasil - Data Analytics with Excel, VBA and Python - From the Ground Up
Canada - Data Analytics with Excel, VBA and Python - From the Ground Up
中国 - Data Analytics with Excel, VBA and Python - From the Ground Up
香港 - Data Analytics with Excel, VBA and Python - From the Ground Up
澳門 - Data Analytics with Excel, VBA and Python - From the Ground Up
台灣 - Data Analytics with Excel, VBA and Python - From the Ground Up
USA - Data Analytics with Excel, VBA and Python - From the Ground Up
Österreich - Data Analytics with Excel, VBA and Python - From the Ground Up
Schweiz - Data Analytics with Excel, VBA and Python - From the Ground Up
Deutschland - Data Analytics with Excel, VBA and Python - From the Ground Up
Czech Republic - Data Analytics with Excel, VBA and Python - From the Ground Up
Denmark - Data Analytics with Excel, VBA and Python - From the Ground Up
Estonia - Data Analytics with Excel, VBA and Python - From the Ground Up
Finland - Data Analytics with Excel, VBA and Python - From the Ground Up
Greece - Data Analytics with Excel, VBA and Python - From the Ground Up
Magyarország - Data Analytics with Excel, VBA and Python - From the Ground Up
Ireland - Data Analytics with Excel, VBA and Python - From the Ground Up
Luxembourg - Data Analytics with Excel, VBA and Python - From the Ground Up
Latvia - Data Analytics with Excel, VBA and Python - From the Ground Up
España - Data Analytics with Excel, VBA and Python - From the Ground Up
Italia - Data Analytics with Excel, VBA and Python - From the Ground Up
Lithuania - Data Analytics with Excel, VBA and Python - From the Ground Up
Nederland - Data Analytics with Excel, VBA and Python - From the Ground Up
Norway - Data Analytics with Excel, VBA and Python - From the Ground Up
Portugal - Data Analytics with Excel, VBA and Python - From the Ground Up
România - Data Analytics with Excel, VBA and Python - From the Ground Up
Sverige - Data Analytics with Excel, VBA and Python - From the Ground Up
Türkiye - Data Analytics with Excel, VBA and Python - From the Ground Up
Malta - Data Analytics with Excel, VBA and Python - From the Ground Up
Belgique - Data Analytics with Excel, VBA and Python - From the Ground Up
France - Data Analytics with Excel, VBA and Python - From the Ground Up
日本 - Data Analytics with Excel, VBA and Python - From the Ground Up
Australia - Data Analytics with Excel, VBA and Python - From the Ground Up
Malaysia - Data Analytics with Excel, VBA and Python - From the Ground Up
New Zealand - Data Analytics with Excel, VBA and Python - From the Ground Up
Philippines - Data Analytics with Excel, VBA and Python - From the Ground Up
Singapore - Data Analytics with Excel, VBA and Python - From the Ground Up
Thailand - Data Analytics with Excel, VBA and Python - From the Ground Up
Vietnam - Data Analytics with Excel, VBA and Python - From the Ground Up
India - Data Analytics with Excel, VBA and Python - From the Ground Up
Argentina - Data Analytics with Excel, VBA and Python - From the Ground Up
Chile - Data Analytics with Excel, VBA and Python - From the Ground Up
Costa Rica - Data Analytics with Excel, VBA and Python - From the Ground Up
Ecuador - Data Analytics with Excel, VBA and Python - From the Ground Up
Guatemala - Data Analytics with Excel, VBA and Python - From the Ground Up
Colombia - Data Analytics with Excel, VBA and Python - From the Ground Up
México - Data Analytics with Excel, VBA and Python - From the Ground Up
Panama - Data Analytics with Excel, VBA and Python - From the Ground Up
Peru - Data Analytics with Excel, VBA and Python - From the Ground Up
Uruguay - Data Analytics with Excel, VBA and Python - From the Ground Up
Venezuela - Data Analytics with Excel, VBA and Python - From the Ground Up
Polska - Data Analytics with Excel, VBA and Python - From the Ground Up
United Kingdom - Data Analytics with Excel, VBA and Python - From the Ground Up
South Korea - Data Analytics with Excel, VBA and Python - From the Ground Up
Pakistan - Data Analytics with Excel, VBA and Python - From the Ground Up
Sri Lanka - Data Analytics with Excel, VBA and Python - From the Ground Up
Bulgaria - Data Analytics with Excel, VBA and Python - From the Ground Up
Bolivia - Data Analytics with Excel, VBA and Python - From the Ground Up
Indonesia - Data Analytics with Excel, VBA and Python - From the Ground Up
Kazakhstan - Data Analytics with Excel, VBA and Python - From the Ground Up
Moldova - Data Analytics with Excel, VBA and Python - From the Ground Up
Morocco - Data Analytics with Excel, VBA and Python - From the Ground Up
Tunisia - Data Analytics with Excel, VBA and Python - From the Ground Up
Kuwait - Data Analytics with Excel, VBA and Python - From the Ground Up
Oman - Data Analytics with Excel, VBA and Python - From the Ground Up
Slovakia - Data Analytics with Excel, VBA and Python - From the Ground Up
Kenya - Data Analytics with Excel, VBA and Python - From the Ground Up
Nigeria - Data Analytics with Excel, VBA and Python - From the Ground Up
Botswana - Data Analytics with Excel, VBA and Python - From the Ground Up
Slovenia - Data Analytics with Excel, VBA and Python - From the Ground Up
Croatia - Data Analytics with Excel, VBA and Python - From the Ground Up
Serbia - Data Analytics with Excel, VBA and Python - From the Ground Up
Bhutan - Data Analytics with Excel, VBA and Python - From the Ground Up
Nepal - Data Analytics with Excel, VBA and Python - From the Ground Up
Uzbekistan - Data Analytics with Excel, VBA and Python - From the Ground Up