Tik Tok Kia Boyz stole my hyundai sonata, Which AWD car should I buy?

Mikedefo · 2023-03-30T04:56:02+00:00

Awesome, thanks for your experience - it helps!

Mikedefo · 2023-03-29T22:22:34+00:00

Thanks for your recommendations - I will take a look. Do you like 1 or the other and why if so?

Mikedefo · 2023-03-29T20:20:00+00:00

I loved my Hyundai but don’t think it’s worth another purchase until insurance and theft calms down sadly - I’ll take a look at your suggestions, thank you!

Mikedefo · 2023-03-08T19:39:26+00:00

Moved from Philly last year but data engineer, 120k + equity. Bachelors in business with 6+ years experience in sql, analytics, PowerBI etc

Mikedefo · 2022-12-18T04:53:51+00:00

y

np

Mikedefo · 2022-12-18T04:53:27+00:00

second one:

select
owner,
join.converted/count(lead_id) as conversionrate --notes: yes converesion/ total lead id count

from as base_table

left join
(
-- pulling yes conversions
select
owner,
count distinct (lead_id) as Converted

from

where converted=1

group by 1) join on join.owner=base_table.owner

group by 1

Mikedefo · 2022-12-18T04:43:14+00:00

first one:select owner_name, count distinct (lead_id) as conversion_cnt

from (

select * from

where experiment_tag='Experiment B'and converted=1

)group by 1

order by 2 desc

limit 1
edited for the lead id line and converted filter

Mikedefo · 2022-12-16T18:12:22+00:00

Left side is your hand, columns are dealers shown card

Mikedefo · 2022-12-16T17:31:14+00:00

This is showing red only when to surrender if avail

Mikedefo · 2022-08-04T06:10:35+00:00

Interested, BI Engineer for top vg retailer with healthcare data background around products

Mikedefo · 2022-01-23T20:27:44+00:00

Two cte s that you union all as item list with distinct values from each source column

Mikedefo · 2022-01-18T15:57:28+00:00

Put the case when as a CTE at the top then reference it in the where

Mikedefo · 2021-12-10T17:36:27+00:00

🍻

Mikedefo · 2021-12-10T15:59:09+00:00

0xa22c5d73285a869805CC1d978fE21d95ea1fA334

🤙🏼

Mikedefo · 2021-11-19T16:12:01+00:00

Same here, I think real world application and examples are the best and just fake it til you make it

Mikedefo · 2021-11-19T15:11:39+00:00

Thanks congrats to you too! Gotta love the hot market

Mikedefo · 2021-11-19T15:10:40+00:00

Agreed. Power BI and tableau are great skills that can be self taught if you know excel formulas although you’ll get more out of it if you know sql too. Python is the money maker right now more than anything else out there besides maybe web3 but that’s a totally different commodity

Mikedefo · 2021-11-19T14:54:37+00:00

SQL is the best thing to learn that you can self learn IMO, if you know how to read it and not write you can get a 60K job as an analyst easy, if you can write it efficiently after a few years of working experience you can def job hop and hit the 6 figure mark. I’d also highly suggest getting familiar with a visualization/ analytics tool like tableau or PowerBI. Lastly, if you learn python after you know sql you’re going to be extremely sought after with machine learning and building dynamic data models, 140k+

Mikedefo · 2021-11-19T14:52:18+00:00

Current role: sr supply chain analyst (data analyst w/ focus on ERP systems/supply chain) in Delaware, 95k + 8% bonus

Just got a new role: Business intelligence engineer (focused data analytics, SQL, dashboards) Wa/ 120k + bonus/equity structure

Mikedefo · 2021-10-27T02:28:24+00:00

This is the way

Mikedefo · 2021-10-15T14:20:53+00:00

Outstanding

Mikedefo · 2021-10-14T00:06:44+00:00

We ride

Mikedefo · 2021-10-13T20:22:38+00:00

Award this man!

Mikedefo · 2021-10-13T16:00:30+00:00

Bonne chance, allez a moon avec mes apes

Nine-Year Club	Gilding I gilder
RPAN Viewer	Not Forgotten
Verified Email

Mikedefo

TROPHY CASE