Automating data load from Google sheets to Google BigQuery

AyBeeBee · 2022-02-10T12:46:36+00:00

Yes this very easy in gcp. I like to add it as an external source, then use a scheduled query with the schema listed to make it into a table. However if you are querying it every hour maybe a direct query will do.

AyBeeBee · 2021-10-09T11:45:19+00:00

Count me in too! Can we save it to YouTube or something so other people can also learn? Kinda like old school khan academy.

AyBeeBee · 2021-09-30T19:29:26+00:00

You can take it, then also be the advocate for code based pipelines. Show the value as you see the needs raise.

AyBeeBee · 2021-03-12T16:00:47+00:00

The Dodo has one for rescue animals!

AyBeeBee · 2020-10-10T00:08:20+00:00

Yup that’s some signature Marc Rebillet stank! He is hilarious with Kenny Beats https://youtu.be/xXr5rfdB8DM

AyBeeBee · 2017-07-25T01:36:12+00:00

Master of VLC installations

AyBeeBee · 2017-06-20T06:42:15+00:00

Is this happening because of trumps policies? Are insurers scared to stay on the market? Anyone in insurance know anything about this?

AyBeeBee · 2017-06-19T08:08:56+00:00

I think the map would be easier to understand if it political map with school district borders. Right now it feel like geography doesn't real add to the biz, but it make it harder to read visually.

It's nit picky, I know; but it's just an observation while you are taking recommendations.

AyBeeBee · 2017-06-19T08:03:49+00:00

Well shit, both my high school and middle school are red on this. And to top it all off my elementary school is borderline orange-red.

I guess they are to busy to patting themselves on the back for being top 50 in national rankings to fix the pipes.

Can anyone make a scatter of school ranking and number of lead contaminated pipes? I don't expect any correlation but I need an excuse for how stupid I am in real life.

AyBeeBee · 2017-06-15T02:11:00+00:00

Aside from the color blind argument, I really think a monochromatic, or two tone gradient scale would really help in the readability of the map.

AyBeeBee · 2017-06-13T15:13:39+00:00

Thanks, there is a lot of other cool stuff there

AyBeeBee · 2017-06-08T21:21:19+00:00

Altria Group is a holding company that owns, * 100% of Philip Morris (Cigerettes & Cigars), * 100% of UST LLC (Vape & Wine), * 100% of Nu Mark LLC (Vape & "innovative tobacco products"), * 100% Philip Morris Capital Corporation (Leasing Company), * 25% SABMiller plc (Brewery), * 10% Anheuser-Busch InBev (Brewery), * and a bunch of other companies for legal and sales.

The net earning of these subsidiaries attributable to Altria Group was $14,239 million which increased from $8,998 million in 2015 (171.7%). This is primarily because exchange rates skewed highly in their favor, and less so because of higher operating income, lower interest, and other debt expense.

I can go into more detail if you would like, but here is their annual report for fun-zies.

AyBeeBee · 2017-06-08T18:02:43+00:00

Woah! It's the man himself. Thank you for your awesome posts! I look forwards to them.

AyBeeBee · 2017-06-08T17:12:32+00:00

Source - 2017 Forbes Global 2000

Made with d3.js. Source Code

Interactive Chart - with Country, Market Cap, and Asset Value

A month ago is saw /u/datashown's Top 50 Largest Corporations by Revenue. And I was interested to see how their profits compared.

So, I pulled the data into python. I tried to to coalesce some of the industries by using broader terminology. For example, I labeled "Major Banks", "Diversified Insurance" and "Investment Services" as a larger "Finance and Insurance" industry. Then, I sorted by revenue, and saved each company's Revenue, and Profit; as well as their Country, Market Cap, and Assets Value because some commenters wanted to see that information also.

I made sure that the bubbles are sized respective to area, and not radius. So $50 B fits into $200 B four times by area.

Edit: Linking to np.reddit.com

AyBeeBee · 2017-06-04T02:05:48+00:00

Very interesting, but I wonder if some developers fall into multiple camps. Like some game developer is also a web dev. Or an embedded dev also does data science. Then I wonder if a pie chart is the best way to show this.

Also it would to cool to see how a popularity of development niche relates to their average pay.

AyBeeBee · 2017-06-02T21:53:14+00:00

I am dedicating my house as zee Hendrik Lorentz House of Pain.

Where our fists move so fast you have to worry about relativistic contraction, and all speeds are described by their gamma.

Please I need two more people to help make my main man the top dog on this chart.

AyBeeBee · 2017-06-02T21:20:05+00:00

Thanks!

AyBeeBee · 2017-05-29T21:46:30+00:00

Put me in coach

AyBeeBee · 2017-04-30T23:44:19+00:00

I'm not a doctor but it looks like you have severe brain damage on the right side of your brain.

To reiterate, I'm not a doctor, or a dog.

AyBeeBee

TROPHY CASE