If you need trustworthy, reliable freelancer, just push the button "hire me" and you will not be disappointed.
- Power BI (PBI Service, Increment Refresh)
- Power Query (M language, datasets, APIs with auth)
- DAX (advanced CALCULATE, SUMMARIZE etc.)
- Data Warehousing, ETL
- SQL (Data Engineering, Analytics, Reporting)
- Python (Automation, Machine Learning)
- MS Excel, Access + VBA
- Git, GitHub, Bitbucket
- Bash, PowerShell
I assure high-quality work.
I love what I do and I always do my best to deliver a great work.
I was very happy to work with Andrei. I requested Andrei to help me on an Excel task. He pro-actively suggeted a Power BI solution, which was much better. He delivered the solution fast, not only living up to my requirements, but also coming up with improvement suggestions. The front-end looks super good, and the back-end is clean.
Very talented person with great skills, he was able to do what other BI expert freelancers told me impossible to do.
Very patient and friendly , I recommend his work without hesitation, he is now my main collaborator on Power BI
- Solid understanding of the Microsoft Excel
- Learned the most common Excel functions used in the Office
- Harnessed the full power of Microsoft Excel by automating day to day tasks through Macros and VBA
- Maintained large sets of Excel data in a lists and tables
- Created dynamic reports by mastering one of the most popular tools, PivotTables
- Created dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many more
Data analysis with Microsoft Power BI
Moscow Institute of Physics and Technology
Microsoft Power BI components and key methods of working with the platform functionality. The course taught how to get, clean, process, and visualize data, as well as how to design reports and publish them in the Power BI service.