Faculty of BI Analytics - course 95,000 rub. from GeekBrains, training 11 months, Date: June 10, 2023.
Miscellaneous / / December 03, 2023
Who is the course suitable for?
For beginners
Master BI analytics from scratch and gain the skill set necessary for a junior specialist.
Analysts
You will be able to use BI tools and develop your career in a promising direction.
Heads of departments
Learn to set up the right analytics to track key business indicators.
Preparatory block
Courses
Video course on working in Excel
Learn to create reports, analyze and present data in Excel and Google Sheets. Learn how to effectively summarize data and work with formulas.
Video course “The most important thing about business presentations”
You will learn how to prepare a presentation for a business task: determine the audience and purpose, develop a plan, choose a structure and storyline, create clear slides.
I quarter
Introduction to BI
Courses
Introduction to BI
Study the key concepts, the general structure of building a BI system, and form a high-level understanding of the BI software available on the market.
Introduction to Power BI: first dashboard and common mistakes
Launch the software, configure the appearance and parameters of the dashboard page. You can select a relevant visual element to display data and build a dashboard.
Power Query
Get data from different sources, learn to work with large data sets in PowerQuery and create a data set, get acquainted with the M language.
DAX
Learn the DAX language, master key functions for creating dashboards, and apply statistical and mathematical methods to process data. Learn to publish a dashboard in Power.com, configure updates and access to it.
II quarter
BI in business and Google Data Studio
Courses
Google Data Studio Basics
You will be able to work in the new BI software: from launching and studying elements, to obtaining data from sources, processing it and administering the published dashboard.
BI systems
Learn to work as a user in popular BI systems, learn their strengths and weaknesses.
Introduction to the Business Model
Get introductory information about the business: what goals the company has, what a business analyst does, what tasks he solves, what is included in his area of responsibility.
Implementation of BI systems
After the course, you will be able to conduct interviews with the customer, draw up technical specifications for obtaining a proposal as part of a tender for the implementation of a BI system in the company.
III quarter
SQL and MySQL
Courses
Fundamentals of relational databases. MySQL
Get familiar with the SQL query language. Learn to write queries, do calculations and work with tables. Learn the main limitations of SQL. You will work with MySQL and get acquainted with alternative databases: MongoDB, Redis, ElasticSearch and ClickHouse.
IV quarter
Python for Analysts and OLAP
Courses
Python Basics
You will go from the basics of programming to automation, collection, processing, analysis and visualization of data.
Python for systems and business analysts
Learn to automate data collection, processing, analysis and visualization. Master libraries for working with data: NumPy, matplotlib, SciPy, pandas.
OLAP BI
Learn to arrange and visualize data using OLAP cubes.
V quarter
Tableau, Qlik View and graduation project
Courses
Tableau Data Visualization
Learn to analyze product metrics and customer data, visualize them and build interactive reports in the Tableau BI tool.
Qlik View
Learn to visualize them and build dashboards
in the Qlik View BI tool.
Graduation project
Get source data from different systems, create a single database and several reports in one of the systems to choose from: Power BI, Tableau, Quick View, Google Data Studio.
Courses with a free start date
Preparing for an interview
GIT. Basic course
JIRA and Confluence Basics