According to the results of the course, specialists will receive the competence of Junior Data Analyst / BI Analyst (Freelance/Remote).
(26 weeks)
There is a possibility of free training under the TechOrda program on a competitive basis.
- Azat YesenovСЕО Yessen&Company
2. VLOOKUP formulas, SUMIF(S) formulas, Pivot Tables
3. ABC analysis in in Excel
4. Advanced analysis and working with arrays in Google Sheets
5. XYZ analysis in Excel, part 1
6. Cohort analysis in Google Sheets
2. Visualization and interactivity
3. Work on a real case. Analysis of monthly retail sales in Power BI
4. Advanced DAX in Power BI
5. Cloud Power BI. Working in the cloud and publishing
2. Year-over-Year analysis in Looker Studio
3. Parameterization and data combination in Looker Studio
2. Advanced level in Yandex Data Lens
2. SQL - ERD Diagrams, Normalizations
3. SQL - DDL 2, DML
4. SQL - Joins
2. Case study: Accounts receivable analysis for a Telecom company
3. Case study: deep analytics for a construction company
4. Training "Finance for non-financiers"
5. Overview of current projects and clients on Upwork.com
2. Customer Development training
2. Search and responses to Upwork.com
3. Profile design
4. Verification, rating and trust
5. Conflict resolution and profile development
6. Practical workshops on writing a Cover Letter and
completing projects on upwork
Admission of students for training under the TechOrda program will be carried out on a competitive basis. The competition will be held in 2 stages:
1. Open test.
The purpose of the test is to determine the candidate's current level of knowledge in the field of information technology, his ability to solve logical and mathematical problems. The test contains up to 30 questions and tasks. Each answer will be evaluated by the admissions committee according to a 3-point system from 0 to 2. In this case, 0 is the absence of an answer or a completely incorrect answer, 1 is not a complete or accurate answer, 2 is an accurate, complete answer. The total score for the test consists of summing up the scores for all questions.
2. The interview.
The purpose of the interview is to determine the level of personal motivation, the seriousness of the attitude to learning, attitude, interest and the opportunity to complete the training. At the end of the interview, the student's readiness to complete the course in the binary system is assessed: ready – not ready.
-
Portfolio of cases: retail, construction, telecom, finance - Customer development skills and positioning yourself as an expert
- Confident knowledge of tools: Excel/Sheets, Power BI, Looker Studio, PostgreSQL, Superset, etc.
- Participation in real projects and possible access to the first clients
- Ready-made profile on Upwork, Cover Letter templates, and verification hacks