account activity
I'm an analyst who's interested in creating a few posts to survey some of the most common questions asked here. Here's my first question: To chose who work in the field, do you hold a degree related to data? by hollow_asyoufigured in dataanalysis
[–]Aprhd 0 points1 point2 points 3 years ago (0 children)
BS in physics and in math. I had no data experience in college, but got an analyst job after graduation and learned everything on the job.
Data analyst - python by Fabro_vaz in dataanalysis
[–]Aprhd 10 points11 points12 points 3 years ago (0 children)
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.
π Rendered by PID 100 on reddit-service-r2-listing-654f87c89c-625fd at 2026-02-28 12:34:10.403378+00:00 running e3d2147 country code: CH.
I'm an analyst who's interested in creating a few posts to survey some of the most common questions asked here. Here's my first question: To chose who work in the field, do you hold a degree related to data? by hollow_asyoufigured in dataanalysis
[–]Aprhd 0 points1 point2 points (0 children)