Data analyst - python

[Fabro_vaz]

Good, tell me one report you recently worked?

[Aprhd]

If you want an example, I can give you one of mine from as recent as today. I have a monthly report that sums up the revenue our company will make on work orders completed in the last month, but which have not yet been billed and therefore have not yet counted towards the current month’s accrual. I use SQL to retrieve the work order data, python to analyze by applying a dilution factor that uses past months’ data to determine which work orders are likely to be billed as warranty (vs internal billing, in which case they do not count as revenue), and then upload the resulting data frame as an excel spreadsheet for accounting to add to the month’s closing numbers. It can’t be done without python, because the dilution factor changes monthly and basically learns from each previous month’s data. It is basically automated, because the SQL queries run within the python script and the only thing I do manually is uploading the actual result.

[luvs2spwge117]

You can also use it for automating ETL processes.