M20779B: Data analysis using Excel tools - course 42,490 rub. from Specialist, training 24 academic hours, date of October 22, 2023.

Want to better understand the basics of business analytics? “M20779B: Data Analysis with Excel Tools” is an authorized Microsoft course that covers key analytical tools of Excel (add-ins Power Query, Power Pivot) and a separate Power system B.I.

This course is for those who already know how to work with pivot tables, build models and queries.

This course is for you if you:

- have experience analyzing data in Excel and want to learn more about business analytics methods
- interested in modern BI tools

Course modules cover classic data analysis using Excel (pivot tables, creating and customizing pivot tables) charts), using the DAX query language in Power Pivot, loading data into Excel using Power Query, importing from databases data. Thus, thanks to the course, you will structure your knowledge of standard Excel data analysis tools and will be ready to take the exam.

To study these business analytics methods in detail and develop practical skills, we recommend taking the Microsoft Excel 2019/2016 courses. Level 6. Business analytics using Power Pivot, Power Query and 3D Map, Microsoft Excel 2019/2016. Level 7. Power Query in Microsoft Excel and Microsoft Excel 2019/2016. Level 8. In-depth study of DAX and Excel PowerPivot.

You will learn:
- create data models in Excel
- load data from different files into Excel
- load tables from databases into Excel
- change table structure in Power Query
- create measures using DAX functions
- create Power BI dashboards