Фриланс бурж

Фриланс бурж

Константин Рогожкин

UPWORK

Hello, my name is Konstantin.

I have experience in data analytic in PowerBI, SQL.

I can do different integrations with API of all services and collect data from it.

I have a 10-years working with web/sql/php technologies.

I have experience in design web-sites and UI interface.

I have management experience to control and find command to work IT services.


I have used Power BI now:

This my own report for company in PowerBI:

https://app.powerbi.com/view?r=eyJrIjoiMGM0MmIyODYtYTA3NC00MmY2LWIyYzQtMzIwMTBiZDdmOWM1IiwidCI6IjEwMGVkZDg5LThmY2EtNDQ3OC05ZTYwLTMyOTExYTBmNWEyOSIsImMiOjl9


This report show us profit and loss company splitted by Day/Month. This data is calculated from SQL database and Google Spreadsheet and we have integration with CRM.


First, we look a lead counts in table. We have a calculated CR - rate and total profit by day.

http://joxi.ru/752abef4lW5KA0.png


Second, we have a calculated difference in profit by day (today) and day today -1 month.

http://joxi.ru/Y82Q04Ij8Z00md.png


Every day we have calculated total incoming by this month from 1st day to now (cumulative):

http://dl3.joxi.net/drive/2017/01/06/0000/0837/837/37/df996614f2.png


Next, we have a calculated total incoming profit in previous month from 1st day to this day month ago:

http://joxi.ru/j1A5dJsn4Z3O2E.png


Profit graph by day:

http://joxi.ru/qVrwXehOo5ERmX.png


Graph by difference this month and previous.

http://joxi.ru/el2ZbYfwlav72J


This is statistics by our clients. 

http://joxi.ru/BLmGJpseBpojrl.png


Average sales by week day

http://joxi.ru/NDrl6MFvKJwY2P.png




Project: sales manager dashboard


https://app.powerbi.com/view?r=eyJrIjoiYTAyM2VjYjYtZmRiYi00YTg3LTgxNWYtYTQ3MjlhOTA3ZGIwIiwidCI6IjEwMGVkZDg5LThmY2EtNDQ3OC05ZTYwLTMyOTExYTBmNWEyOSIsImMiOjl9


This is my commented version:

http://joxi.ru/vn2Yb0fokRNkA6.png


Data to this dashboard collected from 3 sources:


1) VOIP phone system (minutes of talk)

2) CRM system (leads and sales)

3) HR SQL database


All data connected to PowerBI and compose in one dashboard.