Course
Data Analyst
Who is
Data analyst?
Data scientist who effectively structures and analyzes data, plans business metrics and makes recommendations to increase company profits
Apply for vacancies data analytics post-course
2,580 open positions
Data analytics according to HH.ru for the last month
Business Process Analyst
from ₽ 200 000
Data Analyst
from 100,000 ₽
Lead Business Analyst
from ₽ 180 000
Your future summary
You will get career advancement and start earning more. After completing the program, you can include the following skills
My skills:
Handled a variety of analytics requests from the business. Presented them skillfully
Summary Data analytics
I am confident in using analytics services: Ya.Metric and Google Analytics. I am skilled in presenting data in one window
Based on a study of 2,580 hh.ru vacancies, we highlight the most important skills that clients learn on the course
Engaged in solving complex problems and testing hypotheses with analytical tools
Performed analysis of financial and product metrics and search for "weaknesses"
Performed processing of massive data sets and highlighted important information from Big Data
I am proficient in 5 programming languages: SQL, Python, R, Power Bi and Power Query.
Built business models, conducted financial planning and performance evaluation of business processes
Carried out the full cycle of data work: from receiving to organization of reception and processing
Created detailed analytical reports using Google and Excel spreadsheets
Changed the monetization model of the platform with tests and tasks
Wrote and minimized SQL queries to calculate user activity and balance metrics on the platform
Prepared a visualization of the resulting store assortment analytics
Selected the correct values from the data set and created summary tables. I recreated the most illustrative example for presenting information about the status of goods in stores
Technical Tools. Additional skills
Power BI
Excel
Google Sheets
VBA
Power Point
Power Query
SQL
Python
R language
Table
BPMN
Numpy
Pandas
Seaborn
Plotly
PLO
CRM/Trello
Yucasse
Who we train in this profession
Data analysts
Learn how to use your analysis to create reports, dashboards, and visualize data to help you make informed decisions
Professional development
They come to training to learn a related or new skill. They are bored with routine tasks and want to continually expand their area of expertise
Re-qualification
They want to increase their area of expertise, begin to engage in more diverse tasks, and gain hands-on experience in our program-professional program
Modern educational approach
At the heart of the course is practice
Python development types and styles, using the above example to practice the acquired knowledge of object-oriented programming in an online simulator
Webinars and online cases
We organize webinars and online case studies almost every week. You can attend an event as part of your own or another course free of charge. Networking with experts is valuable for developing
professional skills
Quick feedback
Core instructors are on the course chat room and are available to answer any questions you may have. You will have a personal tutor who communicates 1-on-1 and helps you with your individual study
plan
Video tutorials
Together with experts, recall and systematize theory while focusing on practical skills. Learn to use tools for data analysis, computation and visualization
Game-based learning
We understand that learning engagement is important, so we incorporate game mechanics into the process. Take courses and earn medals and SF Coin!
SF Coin is an in-game currency that can be spent on bonus lessons, tutor consultations, or turned into a discount on the next course
SF Coin is an in-game currency that can be spent on bonus lessons, tutor consultations, or turned into a discount on the next course
It's easy to start learning!
The assistant we have developed will show you in detail how SF Education online university education works. Get to know our platform and all its mechanics
13
of modules in four months
59
practical exercises
246+
practicum hours
15
hours per week
- Become familiar with the Business Analyst position and her role in the organization;
- Learn what a business analyst's career ladder looks like and what opportunities are in front of them;
- Understand what skills you need to develop first and what knowledge will help you grow faster;
- Learn how and where to look for open positions, what to expect in interviews, and how to prepare for technical interviews.
- Learn the Excel interface thoroughly;
- Learn how to perform basic financial, mathematical and logical calculations;
- Explore key math and text functions;
- Learn how to work with filters and document formatting.
37 lessons / 4 practical assignments / 6 hours of theory / 2 hours of practice
- Learn advanced data manipulation, including arrays, smart tables, and cleansing;
- You will begin to professionally visualize data using different types of charts and graphs;
- You will be able to build summary tables of varying levels of complexity.
- Take a thorough look at the Google spreadsheet interface;
- Learn how to work with files, including collaborative filing;
- Explore different options for sorting, filtering, validating and protecting data;
- You will be able to build beautiful charts and dynamic graphs;
- You'll start building summary tables quickly.
- Take your first steps in Power BI and Power Query;
- Examine calculated columns, calculated measures, and the rules for how measures work;
- Master the Calculate (), ALL(), and FILTER () functions;
- You will start working with linked and unlinked tables;
- Become familiar with Time Intelligence features and begin using them for custom calendars;
- Study condition functions and cyclic functions;
- Understand the use of Power Query tools in Excel, Power Pivot, Power BI Desktop Plus, Power Query plus and Power BI Service;
- Dive into the nuances of filter and string context;
- At the advanced level, study the Calculated Pillars;
- You will begin to work with variables in DAX formulas.
- Introduction. Basic data import;
- Learn about the concept of data cleansing;
- Practice #1. Import, process, upload, make a summary table;
- Learn how to merge tables and change the data structure;
- M language, general concepts;
- Import files from a folder;
- PQ Objects and Parameters in PQ;
- Accelerate queries, reduce working file size;
- You will make a final PQ course task with an upload to Power Pivot and a final summary.
- Gain a complete understanding of the structure and types of data in a database;
- You will start working with popular features and operators;
- Be able to apply knowledge in analyzing financial data from banks and other organizations.
- You will start working with the Pandas and Numpy libraries;
- Be able to visualize data in Mathplotlib, Seaborn, and Plotly;
- Gain a basic understanding of object-oriented programming.
- An introduction to one of the most popular programming languages, the R language.
- Refresh your knowledge in probability theory, mathematical statistics, linear algebra, and mathematical analysis;
- Learn to apply your knowledge of math to solve problems in finance and business;
- Learn which math topics to dive into further for professional and general development.
- Find out what unit economics is right for you;
- Create a financial model for a digital product;
- Learn how to calculate key unit-economy metrics;
- Learn how to calculate your product budget;
- Master the basic approaches to product analytics.
- Understand who a business analyst is, learn the differences from other analysts;
- Learn the "5 Why's" technique;
- Work out how to conduct an interview;
- Be able to review basic tools;
- Learn what holistic solutions are (impact mapping, buttons).
- Identify your strengths and learn how to properly present them to employers;
- Work with a career counselor to put together a selling resume;
- Write a cover letter that will get you screened into a dream company.
- Learn what the market research process is, what information is used to analyze the market;
- Learn how to form and understand the terms of reference for market research;
- Break down all the methods of analyzing the market.
- Learn how to load and process data in Tableau;
- Explore the program interface and see examples of graphing;
- Learn how to perform calculations in Tableau;
- After training, you will start creating simple and advanced dashboards in Tableau.
- Learn to write macros of varying levels of complexity;
- Gain skills to automate routine processes related to working in Excel;
- Be able to integrate Excel with Word, PowerPoint, and Internet programs.
- Learn what role organizational design plays in project management;
- Immerse yourself in the project lifecycle: from planning and start-up to project implementation and finalization;
- Learn how Agile, Scrum and Kanban methodologies can accelerate your work as a project manager and improve its quality.
- Learn about the purpose of business process analysis;
- Become familiar with business process analysis tools;
- Dive into the BPMN business process description system and break down example notations;
- Familiarize yourself with sample tasks from interviews for positions in systems analytics.
- Learn about the purpose of business analysis and business analysis tools;
- You will start qualitative data collection and processing;
- Learn how to visualize and interpret data;
- You will begin to interpret predictive models;
- Break down a few business models from the practice.
- Learn how to integrate third-party services;
- Examples of integration of UCass, CRM-system and mailing list services will be analyzed;
- Will choose the right microservices and monolith solutions for their company.
- Learn about the purpose of budgeting and types of budgets;
- Dive into the behavioral aspects of budgeting;
- Designate centers of budgetary responsibility in your company;
- Learn how to build functional budgets.
- Learn the vocabulary and grammar of business English with a bias toward finance;
- You'll start practicing conversational English in online meetings with our English-speaking experts.
- Find out what the presentation is for exactly what you need it for;
- Break down what presentations are (e.g., annual report, Big4 presentation, McKinsey & Company, personal resume);
- Presentation Structure;
- Learn how to professionally place text, images, icons, align objects, use fonts and more;
- Break down the design trends of 2023;
- Prepare for the performance;
- Clean up your appearance.
- Understand how daily transactions affect the financial statements of the entire company;
- Understand the purposes for which different financial reporting forms are needed;
- Learn the differences between IFRS and RAS and understand how each standard is applied;
- Prepare three reporting forms for several companies from different industries based on primary documents.
Access to the course, course updates and course chat stays forever !
Effective study format
Reinforce the skill with practice
A format that allows you to master 2-3 related topics within a module. After the significant lessons you take tests, and at the end of the module you solve a practical assignment
Use the end-to-end project
A cross-cutting project allows us to immerse the client in a situation closer to real work. Our projects are shaped by experts from their practice, which they package for our clients
Individual work with each client
We create individual training plans on request. Our expert trainers are ready to answer all questions of our clients, both on the subject of the course and on any other practical issues
Cost of training
Beginner Plan
- Access to introductory video lessons
- Basic data analysis templates
- Certificate of course completion
- Access to a learning community forum
- Monthly quizzes to test your knowledge
Advanced Plan
- Everything from the Beginner Plan
- Live workshops on data visualization
- Access to datasets for hands-on projects
- Feedback on your data analysis assignments
- Step-by-step tutorials on SQL and Excel
- Introduction to Python and R for data analysis
- Recorded expert webinars
- Networking with other professionals
- Resume-building tips for data analysts
- Access to advanced data visualization tools
Expert Plan
- Everything from the Advanced Plan
- One-on-one mentoring sessions with data scientists
- Access to real-world data analysis case studies
- Guidance on building a personal data portfolio
- Unlimited access to advanced workshops
- Preparation for top data analyst certifications
- Lifetime access to all course materials
- Exclusive job interview prep sessions
- Hands-on projects with company datasets
- Access to industry-level data tools and software
Doing the training accessible
0 - 0 - 24
Installment payment without interest, first installment in one month
13%
Tax deduction for all our courses
up to 70% savings
Beneficial training under our Trade-In program
3 days for free
Access to the entire course for 3 days - free of charge
How we help with employment
SF Education Career Center is about building your individual career track based on your experience, skills, and goals. We will help you build a winning resume and thoroughly prepare you for the tasks that
will be encountered at the job interview
Consultation
We form an individual career profile according to the author's methodology and give recommendations on the following steps
We form an individual career profile according to the author's methodology and give recommendations on the following steps
Preparing for the interview
We deal with all types of potential questions and help you to present yourself in a winning way at the interview stage
We deal with all types of potential questions and help you to present yourself in a winning way at the interview stage
Communicating with partners
We develop a community of our alumni who recruit people to join their teams, as well as exchange experiences and share market specifics
We develop a community of our alumni who recruit people to join their teams, as well as exchange experiences and share market specifics
We'll help you choose
We are ready to evaluate offsets with you and decide on the best offer for your career prospect
We are ready to evaluate offsets with you and decide on the best offer for your career prospect
1
3
2
Working with resumes
We engage HR specialists from our partner companies to adjust your resume
We engage HR specialists from our partner companies to adjust your resume
4
5
Answers FAQs
The course is suitable for beginners, school knowledge and responsible approach to lectures and practical assignments will be enough for you to master the material.
The program is weekend-oriented, with approximately 15 hours per week. You will be able to allocate these hours on your own, taking into account your workload and schedule.
You must pass all course assignments, defend the cross-curricular project (if assigned), and pass the final test with at least 60% correct answers.
Webinar recordings are always posted on the course platform. If you are unable to attend the case studies or practical assignments online, you will be able to complete the assignments yourself
and submit them to the instructor for review, if applicable.
According to the Law on Education No. 273-FZ of 29.12.2012, specialists with secondary vocational and (or) higher education are entitled to receive additional professional education. Persons
who have successfully mastered the relevant additional professional program and passed final certification are issued a certificate of professional development and (or) a diploma of
professional retraining.
To support students, we have created a special course chat in Telegram. There you can ask questions and get help from teachers and experts.
Our career center helps with resumes and cover letters, provides career counseling (where to go, career path options, which offer to choose, etc.). We can conduct a mock interview to simulate
real-world conditions. You will also get access to our closed career channel, where vacancies from partner companies are regularly published.
You can take 3 days of training for free or leave a request for a free consultation. The manager will tell you in detail about the training and answer all your questions.