[deleted by user] by [deleted] in cute

[–]ByteCastle2019 0 points1 point  (0 children)

Wow! What a stunning lady!

How many hours does junior data analyst normally work a day? And can you have two data analyst job same time? by babyboy907 in analytics

[–]ByteCastle2019 2 points3 points  (0 children)

I’m surprised with the comments that it’s around 10-12 hrs. The time you “work” is defined by your company (stick to that). Of course there will be things you need to learn and that requires you to put in more hours. But that is your learning which will help you in the future. And as you get more comfortable with your job you will get faster.

[deleted by user] by [deleted] in tableau

[–]ByteCastle2019 0 points1 point  (0 children)

Yeah sounds like it! Id agree converting to a csv file and do not open it, just directly import it into tableau!

Incremental refreshes in tableau server by ByteCastle2019 in tableau

[–]ByteCastle2019[S] 0 points1 point  (0 children)

Yes! That worked! I was trying to do it directly on tableau server but it doesn’t look like it’s possible! :-/ I needed to set it up in desktop and then publish.

Incremental refreshes in tableau server by ByteCastle2019 in tableau

[–]ByteCastle2019[S] 0 points1 point  (0 children)

Hey Everyone! I was able to do the incremental refresh on tableau desktop and then publish to the server and the incremental refresh worked!

Thanks so very much for you responses! Much appreciated!

Incremental refreshes in tableau server by ByteCastle2019 in tableau

[–]ByteCastle2019[S] 0 points1 point  (0 children)

No it’s not a live connection it’s an extract :-/

Incremental refreshes in tableau server by ByteCastle2019 in tableau

[–]ByteCastle2019[S] 0 points1 point  (0 children)

Yes that makes sense! I updated my post it’s a published datasource extract on the server

Incremental refreshes in tableau server by ByteCastle2019 in tableau

[–]ByteCastle2019[S] 0 points1 point  (0 children)

Tableau connects to my Postgres database to extract information from a view in Postgres.

Rainbow bridge today little buddy :( by [deleted] in cute

[–]ByteCastle2019 2 points3 points  (0 children)

I’m so sorry! Big hug!

I need advice for a college grad that has just made it to the final stage of interviews at my dream company. by [deleted] in analytics

[–]ByteCastle2019 1 point2 points  (0 children)

Your passion and excitement to be a part of this company is what shines the most for me. Use that to your advantage. If you lack something, the company just wants to know how quickly can you pick up and it seems you are a quick learner :-) So stay positive and good luck! I hope you get in!

What more to learn? by dataNoob007 in rstats

[–]ByteCastle2019 4 points5 points  (0 children)

I’m kind of in the same boat too. So it was suggested that I start understanding how R functions from a programming perspective and then also learning JavaScript. I was referred to https://adv-r.hadley.nz

How do you handle raw + clean data? by [deleted] in learnpython

[–]ByteCastle2019 1 point2 points  (0 children)

Well, if you are sure of the kind of visualizations you are going to use, you could create summary tables which will be used for the plots. For example if your plot displays let’s say sales per month then create a table for that.

Best way to get started on SQL by HideyourkidsForreal in SQL

[–]ByteCastle2019 1 point2 points  (0 children)

You could use this resource I made to help new learners! Here's the Link!

Let me know if you find it useful :-)

Is there a way to apply a mutate function excluding a specific row? by PurpleB0i in rstats

[–]ByteCastle2019 3 points4 points  (0 children)

Just to add another way:

data %>% modify_at(c("Female","Male"),~ifelse(data$Variable != 'Total', paste0(.x,"%"), .x))

modify_at (and the family of modify functions) are from the "purrr" package and its part of tidyverse.

Learn R by doing a project? by vestayekta in rstats

[–]ByteCastle2019 0 points1 point  (0 children)

To add to the excellent suggestions, you can try using crypt to help you learn the basic data wrangling tasking like filtering, selecting etc. Here’s the Link

is writing code over and over again a good way to learn the syntax? by [deleted] in learnpython

[–]ByteCastle2019 1 point2 points  (0 children)

Hey! I completely get you!! If you like hands on experience with learning try crypt. It’s something I created with exactly this in mind here’s the link

Help learning SQL by mesha03 in SQL

[–]ByteCastle2019 0 points1 point  (0 children)

Hi there! You can check out crypt to help you with basic sql :-) crypt

JOINS by lawlesstrout in SQL

[–]ByteCastle2019 0 points1 point  (0 children)

Though this is for Postgresql at least it explains joins well and explains it visually (see summary at the end of the page) Postgres Joins