BI analytics - course 51,800 rub. from Otus, training 4 months, date September 28, 2023.
Miscellaneous / / December 02, 2023
Required knowledge
- knowledge of Python and SQL at a basic level;
- understanding what data analysis is and why it is needed.
Now the market is in demand for analysts who can visualize metrics and data using BI tools. The course will help you master modern methods of working with Big Data to build interactive dashboards and analytical panels to identify “insights” that can help make decisions based on data.
Students will work with modern platforms for creating dashboards, such as Power BI, Tableau, Qlik Sense. At the same time, the course will provide in-depth knowledge of working with Power BI: methods of connecting to data sources, principles of processing and transformation will be discussed in detail data in Power Query, creating a data model in Power Pivot, customizing and interacting visuals, and creating advanced visualizations using DAX formulas
The course will also allow you to create custom dashboards of any complexity to suit the specific needs of a customer or employer using Python and the Dash library.
Alexandra has been working in the field of analytics and BI since 2019. By this time, she received a bachelor's degree in Software Engineering from St. Petersburg State University of Aviation Administration, and then a master's degree. First steps in...
Alexandra has been working in the field of analytics and BI since 2019. By this time, she received a bachelor's degree in Software Engineering from St. Petersburg State University of Aviation Administration, and then a master's degree. The first steps in his career were taken at the American company Intermedia Cloud Communications as a junior data analyst, and by 2021 he managed to become the head of the analytics team. This whole year was devoted to a new cross-team project for international financial management on the Microsoft stack (MS SQL Server, SSRS, SSIS, Power BI). Since March 2022, he has been working in the Tinkoff Bank group of companies as a warehouse analyst data. Provides support to top management of the financial department in building prototypes of ETL processes using Greenplum, ad-hoc analytics in Python, reporting and visualization in Tableau. In 2020, she received additional education in the direction of Project Management Manager in IT. He is a staunch supporter of flexible development methodologies. Believes that the most profitable investments are investments in one's own development. Stack: SQL, SAS DIS, SSIS, Tableau, Power BI, Python
Currently engaged in user analytics in projects of the Moscow Government, such as Our City, Active Citizen, City of Ideas, Million Prizes, etc.
He worked in the executive authorities of the city of Moscow, subordinate institutions of the Municipal Economy Complex and Social Protection. He headed the work of the monitoring and analytical department, which monitored the operation of municipal cleaning equipment. Currently, I am implementing projects related to the digitalization of targeted social assistance for the 65+ population of Moscow.
Among the projects being implemented is the Contact Center “Social Protection” information system, which allows remotely receive targeted assistance in the form of medicines, food and emergency goods necessary.
Program Manager
Big Data Analyst/System Analyst/Python Development 8+ years. I am engaged in user analytics in projects of the Moscow Government. He worked in the executive authorities of the city of Moscow, and was a project manager for monitoring the operation of municipal equipment. Developed methodology and algorithms...
Big Data Analyst/System Analyst/Python Development 8+ years. I am engaged in user analytics in projects of the Moscow Government. He worked in the executive authorities of the city of Moscow, and was a project manager for monitoring the operation of municipal equipment. Developed methodology and algorithms for identifying cases of inappropriate use of equipment. Developed systems for optimizing the expenditure of budget funds. I am also engaged in the implementation of integration mechanisms for building centers for monitoring the activities of city services. Technologies used: - python, java, git, pl/sql - oracle, postgresql, hadoop, airflow - ms office (inc. VBA) Teacher
Module 1. Introduction to BI analytics
-Topic 1.Introduction to BI analytics. What is a dashboard
-Topic 2. Analysis of the main metrics and requirements for building visualizations
-3.Python theme for analytics. Basic Data Types in Python
-Topic 4. Conditional statements, loops, functions in Python
-Topic 5.Python Libraries. Numpy and Pandas
-Topic 6.Python Libraries. Advanced Pandas
-Topic 7.Python Libraries. Visualizations in Python: Matplotlib, Seaborn, Plotly
SQL and working with databases
-Topic 8.Principles of working with relational databases
-Theme 9.SQL. Tables, views, simple selections, functions
-Topic 10.Deepening into SQL. Join, Exists, nested queries, group by, having. Indexes and Query Plan
-Topic 11.Window functions in SQL, types and scope
Practices of working with popular BI platforms
-Topic 12.BI platform: purpose, properties
-Topic 13.Qlik Sense technologies. Review of features and construction of a dashboard
-Topic 14.Tableau Technologies. Review of capabilities, data preparation
-Topic 15.Tableau Technologies. Working with visualizations and building a dashboard
-Topic 16.Tableau Technologies. Advanced dashboard techniques
-Topic 17.Working with Power BI. Loading and transforming data. Power Query
-Topic 18.Building a data model in Power BI. working with Power Pivot
- Topic 19. Continued work with Power BI. Building a dashboard. Customization and interaction of visual elements
-Topic 20. Continued work with Power BI. Creating calculated members using DAX formulas
-Topic 21.Customer and marketing analytics in Power BI
Creating custom BI solutions in Dash
-Topic 22. Dash Library. Review and creation of simple graphs
-Topic 23.Dash Library. Filters and callbacks
-Topic 24. Dash Library. External design of the dashboard. Using Bootstrap
-Topic 25.Dash Library. Use cases for various dash core components (dcc)
-Topic 26. Dash Library. The final version of the dashboard. Dashboard output in production
Project work
-Topic 27. Selection of topic and organization of project work
-Topic 28. Consultation on projects and homework
-Topic 29.Protection of design work. summing up the course