Portfolio of the younger analyst
SQL
- Technical task in the bank
- Request to create a database
- Setting the problem
- Solution
- Technical interview in Glowbyte
- Database, ER diagram
- Setting the problem
- Solution
- Terms of reference in MTS
- Database Description, Request for the Creating of Database, Database
- Setting the problem
- Solution
MS Excel
Setting tasks
- Test assignment for the post of analyst
- Those. Assignment for the post of interim an analyst
- Those. Assignment Analytics Assignment
- Comparison of data from two tables
- Testing
Tableau
Python
- Python Parser is a Python script that receives data from HTML tables with birth rate in Russia, and then visualizes them on the graphics.
Courses
The Excel Power Tools for Data Analysis folder contains the results of the course on Coursera. During the training were produced
- import, combination, transformation and data reduction using the Power Query superstructure,
- obtaining access to a data model using Power Pivot and analytical functions (cube functions),
- Using DAX for a powerful data analysis,
- Data visualization using Power Bi.
