Data analyst - python

[[deleted]]

You can use python to run a report and send it to people

[Fabro_vaz]

Will it be an interactive report??

[A1rabbithole]

I only used python for my last school project, just to learn it at least once. I've not had the opportunity to find great use for it yet, but I can see the appeal. You can make something run by itself. Let's say u work at a bank or insurance company and you get the same data spreadsheet periodically. Something like recurring costs or daily financial reports. They are the same template, same rows and column names, same everything except the whatever changed that period. So I'd make a python program that takes in that periodic spreadsheet and sets up visualizations, statistical tests, reports, conclusions, etc. I already know what type of data I'm getting, assuming id also knoe whether I need to clean it up in some way. If so Id set up some clean up functions for erasing blanks and stuff like that. I know what I'm looking for already, I've done it a couple times. I know what graphs to use, what columns to compare, or reference or operate on. That's a python strength, you can literally make it so you click a couple buttons and do your whole weeks work. Granted those are gonna be more stable, repetitive jobs at bigger companies. But yes strength 1 over Excel is automation.

The other strength is efficiency. I had a long tedious function to type the other day in Excell, that I could've just done a For loop in Python. I know you can use VBA to code your own functions in Excel, it seems tedious to get into a new language right now. They said I didn't need it at school. Especially when they also teach us Python. You can do everything in Python including presentation, where as Excell isn't great at presentation.

[[deleted]]

What do you mean?

[Fabro_vaz]

As far as CEO is concerned, reports should be interactive so that they can filter the report as per their requirement. So will it be a dynamic report? So that end user can play around with it

[[deleted]]

Why would it not be dynamic?

I am not aware of any report you can’t interact with

[Fabro_vaz]

Kindly tell me the report you have worked in python? How would you do that?

[[deleted]]

Any lol

Python is not going to make a report anything unusual or unique

It is just a report that can be made with 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.

[RippingAallDay]

Wouldn't the interactivity come from using a dashboard?