Analytics: the art of data management - course RUB 76,800. from Innopolis University, training 5.5 months, date of November 28, 2023.
Miscellaneous / / November 29, 2023
For those who want to move into IT and have knowledge of applied mathematics.
The program is suitable for those who want to dive into analytics from scratch. You will gain a technical background and skills in using data science tools. Upon completion of the course, you will be able to make forecasts based on data and help businesses make decisions. These skills will help you get your first job in IT.
For those who are just starting their journey in analytics.
You will receive useful knowledge and effective tools that will help you upgrade your professional skills. After training, you will begin a new career development trajectory: you will be able to solve more complex and interesting problems, and you will become a more marketable specialist.
An expert in the field of production automation, winner of international and Russian competitions in the field of computer control systems. Winner of the Russian Government Prize in the field of science and technology for youth. I have over 10 years of teaching experience. Implemented projects for the development and implementation of control systems for machine tools and control centers at machine-building enterprises. Entered the super final of the intensive course on working with projects in the field of AI “Archipelago 20.35” with a project to create a digital platform for collecting and analyzing information from technological equipment.
Deputy Director of the Institute of Social and Technological Management MSTU "STANKIN", Associate Professor of the Department of Financial Management
20 years of experience in IT. 6 years of experience in data architecture. I develop and teach courses on big data (Innopolis University, School 21, Gazprom Neft, Rostelecom). Participated in the audit of the domestic operating system Aurora, in projects of the Analytical Center under the Government of the Russian Federation.
Module 1: Introduction to Analytics, Tabular Data, Databases
Basic Analytics Tools
— What is analytics?
— Introduction to Google Sheets
— Advanced google tables
— Fundamentals of Statistics
— Advanced statistics
- Data collection
— Data visualization
SQL and data retrieval
- Database
— Query language
— Complex queries
— Query optimization
— Working with PostgreSql
Interim certification
Module 2: Python as a Data Tool
Python for data analysis
— Basics of the Python language and basic algorithmic constructs (data types, branching, loops and basic operators)
— Working with lists. Practice on numpy basics
— Loading/uploading data in various formats: xlsx, csv, json, xml
— Using IPython, Jupyter
- Using Git for version control and collaboration
Working with data sets
— Data preparation for analysis, cleaning and normalization, filling in gaps
— Grouping data (using dictionaries, using functions), iterating over grouped data
— Basic principles of visual presentation of information
— Data visualization methods. Practice on matplotlib, seabor
- Advanced numpy features: Broadcasting
Statistics in Python
— Descriptive statistics and exploratory data analysis in Python. Correlation. SciPy Workshop
— A/B testing
— Working with time series in Python. Moving average. ARIMA. Decomposition of time series. Workshop on statsmodels
Interim certification
Module 3: Big Data
Big Data
— What is big data?
— Machine methods in data processing
— Acceleration of data processing. pandas practice
— Motivation and big data tools
— NoSQL approach to working with big data
- MapReduce
— Culture of data collection and sources
— PySpark Practice
Interim certification
final examination
Protection of project work