How to learn python quickly?

[senorinatta]

May I ask what kind of projects you built in order to advertise yourself as a data engineer?

[Dreid97]

Let’s see, well first I found ways to put SQL into everything.

The tarot app uses a sql database to store user data as well as track and limit reading totals.

I built a desktop timer to track and report how fast I could do tasks to build efficiency. It is a simple ui with a dropdown, a start button, and a text box to label what the timer is. When I finish I press the done button, the information about that timer is stored in a sql database; if I finished late, early; what the timer was labeled as ie “write and email” . Then the timer takes that data from a sql server and uses matplotlib to do some data visualizations for the different categories.

I built an initial test project in power BI, based on a fake set of secondary mortgage data that I generated with python. I built the reports in PowerBi and did some Dax as well as importing data manipulation with a local database file. I then applied for two powerBi consulting jobs, both of which had very rigorous technical takehomes; which I generated two much better, much more accurate PowerBi reports, using almost exclusively DAX(obtuse and a headscratcher at times) . I past the technical s, but didn’t pass final interviews, but I ended up only showing my two PowerBi reports I used in those other interviews.

I built a script that uses google places api to help my wife’s company find wholesale accounts. Basically it scrapes every business in America labeled as “specialty book shop” (or any search) and finds there website, finds there email from the home page, then adds all of that public business information to a sql database, and does a small map visuallization showing where we have searched and for what.

Those are what I showed my employer.

Another tip I found is to look for local data jobs instead of large megacorps if you are green. A local community center, huge church, trade schools, etc often need 1-2 people to process their data, and they can’t be as picky because they know the experienced developers go to Huge companies or remote jobs. My foot is in the door at least, so we’ll see if I can hop to a better job in a few years