BI analyst: from zero to middle - course 101,700 rub. from Netology, training 12 months, Date: August 18, 2023.

Developed his own methodology for teaching how to work with the MS Office package. Clients: Sberbank, Raiffeisenbank, Yandex, Megafon and others.

Stage 1. Immersion in the profession
Analytical thinking
Learn to think like an analyst and formulate hypotheses to test. You will understand that analytics is built around data. Get acquainted with the basic analytics tool and be able to conduct simple data analysis in it.
- What is analytical thinking
- Introduction to Google Sheets
- Advanced Google Sheets
- Fundamentals of statistics
- Where does the data come from?
- Advanced data visualization
- Python as a data analysis tool
- Machine learning for life

Data Visualization Basics
You will understand how to create visualizations, where the data for visualization comes from and how to work with it. Learn how to create stories using data.
- How to convey information using images
- Tools, sources and data preparation
- Data research and basic statistics
- Advanced data visualization
- Storytelling in visualization

Metrics, hypotheses, growth points
You will learn to work in a team. You will learn who the analytics customer is in the company and how to work with different types of customers. Gain basic knowledge of the hierarchy of metrics that will allow you to speak the same language with your colleagues, put forward working hypotheses and build clear reporting.
- Financial metrics
- Marketing and product metrics
- Hierarchy of metrics
- Gathering requirements and developing reports
- Formulation of hypotheses. Search for growth points
- Test design, implementation and analysis. Building simple models
- Optimization of reporting

Stage 2. Working with data
Learn how to write SQL queries to retrieve data and prepare it for subsequent analysis. Learn to receive and present insights for decision making. Get familiar with the features and components of Power BI and learn how to write complex queries and reports.

SQL
Learn to write simple SQL queries to retrieve data from a database without wasting developers or administrators' time searching for the right piece of information. You will learn how to create new tables directly in the database without uploading data to Excel - this will allow you to make reports faster.
You will be able to load data into the database and independently deploy a PostgreSQL database to store data in the sections that analysts need. Learn to work with different file formats: create reports in one database with data from web counters, from accounting tables and management reporting.
• SQL Basics
• Deep dive into SQL
• Working with PostgreSQL
• Working with MongoDB

Power BI
You will be able to analyze corporate databases, spreadsheets and text files. Learn to see unobvious patterns between indicators. You will understand how to create visual interactive dashboards for analyzing business metrics online.
Learn to identify key product metrics, create dashboards without programming, optimize your sales funnel, and improve customer experience.
• Loading and converting data
• Modeling and data analysis
• Data visualization. Working with reports
• Publishing data and collaborating with reports

Power Query, Power Pivot, DAX, M
Explore advanced capabilities of Power Query, Power Pivot & DAX tools. Learn to create formulas, functions and visualizations of any complexity, build advanced reports, synchronize with various services - and all this without programming skills.
• The concept of working in Power BI and the basics of working in Power Query
• M language syntax and working with structured data
• Parameterization and work with functions
• DAX Basics
• Context management
• Functions for converting tables and transferring context in the absence of direct communication
• Calculation of subtotals and time analytics functions
• Extracting context information. Formatting the results obtained
• Basics of creating visualizations
• Complex scenarios for creating visualizations
• Expanding Power BI capabilities

Stage 3. BI solutions and soft skills
Learn to make business decisions and track results. Strengthen your soft skills to grow in your profession and achieve greater results.

Selecting and connecting BI solutions
Learn to identify the needs and requirements of business users, choose a solution, an architecture for it, and a scaling strategy for business growth. Get to know Tableau/Power BI. Connect to the data warehouse and transfer data to the template dashboard. Learn to generate reports in real time.
• BI as the heart of analytics
• Multidimensional models
• Real-time reporting

Effective communications and emotional intelligence
Learn to understand the worldview of those around you and build communication based on this. You will understand how to manage your emotions, how to respond to the emotions of others in the process of communication and develop emotional intelligence. Learn how to manage emotions in negotiations. Learn to make useful connections and business acquaintances and present yourself correctly.
• Facilitation
• Personal effectiveness
• Planning
• Prioritization
• Time management
• Delegation
• Concentration and recovery of resources
• Self-motivation
• Emotional intellect. Model and stages of development
• Emotion recognition

Negotiation
Learn to competently organize business meetings and effectively negotiate, achieving mutually beneficial agreements.
• Networking
• How to conduct unequal negotiations
• Objections and arguments
• Preparation for negotiations
• Confident negotiation
• Management duels
• Manipulation in negotiations
• The power of negotiation
• Negotiation structure
• Negotiations online and offline
• Internal negotiations

Public performance
Learn skills that will help you prepare for a pitch, write a speech, put together a presentation, and speak effectively in front of any audience. Learn different approaches to presenting material and you will be able to speak in typical situations or when things don’t go according to plan.
• Preparing for a public speaking
• Typical speech structures
• Speaking to colleagues
• Audience interaction and delivery

Graduation project
This can be an interactive dashboard with visualization of business indicators, a set of proposals for optimizing the company’s strategy, searching and justifying points of business growth. At the end of the training, you will have a ready-made case for finding a job, professional growth, or moving to a new position.
If you have no ideas for your own project or access to the necessary data, we will offer a training case in an area of ​​interest to you based on a real dataset of other companies.
You will be supported by your thesis supervisor: the expert will give detailed comments on the work and help improve the project.