Data analyst
The program of this course considers the use of SQL and Tableau software, as well as Excel and Python language, to implement statistical analysis. Concepts associated with descriptive and inferential statistics, data visualization, data preprocessing, how to summarize and report data in interactive visualizations, and written reports will be addressed.
Required hours:165
PROGRAM EDUCATIONAL OBJECTIVES
Special emphasis is placed on everything related to data extraction, cleaning, and preparation. This work is essential for any insights reporting project. Within this, relational databases are considered and how to work with them for the analysis to be performed later.
PROGRAM OF STUDY
MODULE 1
FUNDAMENTALS OF DATA WORK WITH EXCEL
Through this module, participants will be able to build data reports using data cleaning techniques, manipulation, visualization, pivot tables, and macros for the presentation of information according to Excel spreadsheets.
- 16 hours.
MODULE 2
PYTHON PROGRAMMING FUNDAMENTALS
Through this module the participants will be able to code low/medium complexity pieces of software in Python language, to solve a problem according to Industry Best Practices.
- 20 hours.
MODULE 3
DATA ACQUISITION AND PREPARATION
Through this module, participants will be able to apply data collection, cleaning, and preparation techniques, using imputation criteria and manipulating data structures as appropriate to meet the information needs according to the Python language.
- 20 hours.
MODULE 4
EXPLORATORY ANALYSIS AND STATISTICAL PROGRAMMING
Through this module, participants will be able to analyze data using Python language, and descriptive statistics concepts for the exploration and characterization of information.
- 16 hours.
MODULE 5
STATISTICAL INFERENCE
Through this module, participants will be able to draw statistical inferences to a sample, for the estimation of a population.
- 20 hours.
MODULE 6
STRUCTURED QUERY LANGUAGE (SQL)
Through this module, the participants will be able to build queries to a database using the structured query language to obtain information and generate insights.
- 24 hours.
MODULE 7
DATA: INTERPRETATION AND VISUALIZATION
Through this module, participants will be able to generate valid representations of data using narrative and visualization concepts for an effective presentation of information.
- 12 hours.
MODULE 8
INTERACTIVE VISUALIZATION ELEMENTS WITH TABLEAU
Through this module, participants will be able to implement interactive data visualizations using the Tableau environment for data analysis.
- 36 hours.
REQUIREMENTS FOR APPLICATION
- To be Chilean or foreigner with definitive permanence in the country.
- Be a technician, professional, or graduate in specific careers associated with the course to which you are applying.
- Have specific and accredited work experience associated with the type of ICT specialization to which they are applying.
- Technical, professional, or university degree in a technological, commercial, industrial, mathematical, statistical, or engineering career.
- At least 2 years of work experience.
- Test of basic knowledge of statistics and programming taken at www.becascapitalhumano.cl
- It is important to note that the specialization courses in technology consider the submission of a test of specific knowledge related to the course.
- In the case of the Digital Marketing, E-Commerce, and Creative Services courses, those who are owners, partners, shareholders, and/or employees of a company may also apply.
Characteristics of Scholarship
- Talento Digital courses are online, mixing asynchronous content with synchronous distance classes, with direct assistance from the designated instructor.
- Tuition fee $210,000.
- Developed by Universidad del Desarrollo.
