Data analytics basics, SQL and IDE Basics
SELECT, ORDER, GROUP BY
Operators (>,<, =,+, *) + filtering Case/Subquery Inner/Left/Right/Outer Join Substring/Locate/Replace/Length (data manipulation) Creating/Inserting/Deleting tables and content Repetition exercises (joins, subqueries, select, group by, creating tables) Final SQL Examt

Introduction to Business Intelligence tools, Power BI IDE, visualisation types
Creating visualsiations, formatting, filtering
Calculated measurements and calculated columns (distinct, max, min, sum, calculate)
Data transformation layer using M Language and Power Query
Pritaikymas mobiliems įrenginiams, bookmarks, drillthroughs
Dimensional modelling (star schema), fact and dimensional tables
Repetition exercises (measurements, bookmarks, drillthroughs, Power Query)
Final project

Introduction to Python, Jupyter IDE, Basics of programming
Variables, data types, data output
Data input, if statements
For loops and while loops
Lists (data input, output, manipulation)
Vocabularies (input of information, output, mathematical operations, connecting if condition)
Working with files (open, close, read, write, edit)
Repetition exercises (basics)
Numpy/Try/Except
Pandas (working with dataframes, filtering, basic calculations)
Matplotlib (creating and formatting different visuals)
Pandas and SQL (writing queries, manipulating data and basic calculations)
Natural Language Processing basics and NLTK
Repetition exercises (different libraries)
Final project (theory and practice part)