Denis Semenov

I'm a Power BI developer, trade analyst and consultant with more then 10 years experience. I have my own project in outsourced analytics and dozens of successful projects in analytics development and implementation.

But at now this is my first experience in using such platform as Upwork.

Skills:

• Data modelling from scratch

• Advanced Power Query user

• Complicated DAX Queries generating

• SQL

• Designing report pages and dashboards with tables, visualizations, dynamic filters and measures

• Multi-lingual and multi-currencies reports

• Huge experience in data preparation and data gateways

• More than 10 years’ experience in trade analytics, budgeting and accounting

• Huge experience in Power BI analytics development and implementation for various business purposes (Wholesale and retail trading, Production, HoReCa, Logistics, GameDev and so on), as a consultant (business requirements research and analysis) and developer

• Creating tools for forecasting and modelling

Huge experience in:

• development and implementation of the automated reporting

system;

• budgeting automation;

• short- and long-term forecasting and planning of KPI;

• all kinds of analysis support GMROI, ABC-XYZ, RFM, Compare analysis, Like-4-like Analysis and so on

• correlation coefficient insights

• coefficient of variation insights

• new and returning customers analytics

• customer base segmentation

• dynamic rankings

• basket analysis

• cohort analysis

• customer lifetime analysis

• commercial potential assessment of the implemented programs of demand stimulating and customer loyalty increase, technological innovations, etc.;

• retail spaces effectiveness analysis;

• commercial and marketing department business processes optimization;

• product matrix development

• trade and products movement analytics (turnover, revenue, sales)

• Inventory analysis and Logistics (stocks, turnover, efficiency)

• receipt and order analytics and qualitative indicators (average order, order frequency, customer segments)

• modeling, planning and forecasting (price modeling, expected order modeling, cross selling)

• product matrix development

• increasing of the warehouse staff efficiency (staff workload and optimization)

• customers delivery schedule optimization, increasing the efficiency of transport use

• retail loyalty program analytics, personalization of customers according to their needs

• automated system of recommendations for the rotation of the assortment in product matrix

• the impact of changes to the overall financial performance

modeling and forecasting

• automation of the following processes: ordering goods for retail

outlets, reassessing the assortment, moving goods between retail

outlets