Juan Martínez II
Juan Martínez II
  • 172
  • 164 222

Video

Dealing with tendinitis as a musician and programmer
zhlédnutí 24Před měsícem
can't play instruments nor type on the keyboard...
I failed as a Data Analyst...
zhlédnutí 2,7KPřed měsícem
It's hard
Learn SQL with excercises - Full Course
zhlédnutí 189Před 11 měsíci
Learn SQL with excercises - Full Course
4 Data Analysis Portfolio Full Projects
zhlédnutí 3KPřed rokem
In this video I'll walk you through 4 Full projects for data analysis. This projects include the use of Python(pandas, numpy, beautifulsup), Google's BigQuery SQL, Power BI, and Looker Studio I'm currently available to work full time/half time as a junior data analyst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76...
Practice Hard SQL Problems Full Tutorial
zhlédnutí 380Před rokem
In this video tutorial I'll walk you through how to solve many different hard SQL problems for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently available to work full time/half time as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM...
Solving hard SQL problems #10
zhlédnutí 38Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Solving hard SQL problems #9
zhlédnutí 8Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Solving hard SQL problems #8
zhlédnutí 13Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Solving hard SQL problems #7
zhlédnutí 7Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Solving hard SQL problems #6
zhlédnutí 11Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Solving hard SQL problems #5
zhlédnutí 26Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Solving hard SQL problems #4
zhlédnutí 13Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Solving hard SQL problems #3
zhlédnutí 30Před rokem
In this video tutorial I'll teach you how to solve an intermediate SQL problem for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently looking to work as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/document/d/104FM76Kmr-tjAwttAbSRnnetsGFwKUF8zBAYCj...
Practice Intermediate SQL Problems Full Tutorial
zhlédnutí 48Před rokem
In this video tutorial I'll walk you through how to solve many different intermediate level SQL problems for those who want to become data analysts/data scientists. SQL practice website: www.sql-practice.com/ I'm currently available to work full time/half time as a junior data anayst/business analyst. Contact me: www.linkedin.com/in/juan-carlos-martinez-peña-082b2394/ Resume: docs.google.com/do...
Solving hard SQL problems #2
zhlédnutí 8Před rokem
Solving hard SQL problems #2
Solving hard SQL problems #1
zhlédnutí 19Před rokem
Solving hard SQL problems #1
Intermediate SQL problem #23
zhlédnutí 7Před rokem
Intermediate SQL problem #23
Intermediate SQL problem #22
zhlédnutí 15Před rokem
Intermediate SQL problem #22
Intermediate SQL problem #21
zhlédnutí 4Před rokem
Intermediate SQL problem #21
Intermediate SQL problem #20
zhlédnutí 4Před rokem
Intermediate SQL problem #20
Intermediate SQL problem #19
zhlédnutí 6Před rokem
Intermediate SQL problem #19
Practice Easy SQL Problems Full Tutorials
zhlédnutí 52Před rokem
Practice Easy SQL Problems Full Tutorials
Intermediate SQL problem #18
zhlédnutí 7Před rokem
Intermediate SQL problem #18
Intermediate SQL problem #17
zhlédnutí 3Před rokem
Intermediate SQL problem #17
Intermediate SQL problem #16
zhlédnutí 12Před rokem
Intermediate SQL problem #16
Intermediate SQL problem #15
zhlédnutí 3Před rokem
Intermediate SQL problem #15
Intermediate SQL problem #13
zhlédnutí 5Před rokem
Intermediate SQL problem #13
Intermediate SQL problem #14
zhlédnutí 5Před rokem
Intermediate SQL problem #14
Intermediate SQL problem #12
zhlédnutí 3Před rokem
Intermediate SQL problem #12

Komentáře

  • @consios
    @consios Před 3 dny

    No way bro do not give up. When you are a junior you are supposed to get paid to learn. I have seen your videos you are more than good enough to be at the junior level. Do not give up. Make sure you have money saved so you are not scared to be unemployed. Do not let toxic managers break you down. Keep learning other tools and even data science.

  • @jonplaud
    @jonplaud Před 3 dny

    1:20:29 I keep getting an error saying Keyerror: 'activity_level'

  • @jonplaud
    @jonplaud Před 4 dny

    I love this!

  • @AdityaSingh-zw5ev
    @AdityaSingh-zw5ev Před 4 dny

    Hi Juan great work I just have a question 1)It is very hard to find correlation between data points in this and also other different datasets provided by Coursera because I was analyzing minutes_sleep dataset and its very confusing did you also had problems analyzing those datasets ?

  • @kmh9817
    @kmh9817 Před 19 dny

    Don't get me wrong but after getting your dream job why commit half! While knowing that you were not the 1st pick of your senior you should have given your full time there.

  • @MowMiNubas
    @MowMiNubas Před 20 dny

    Start ups are very hard environments to start, try a company with more grounded position so they have time and resources to teach u the job. Dont worry to much, keep trying.

  • @yuejiang5759
    @yuejiang5759 Před 21 dnem

    I live in a different country from yours, but the same thing is happening here. The employment status is just horrible. So many competitors are in the market, and so many qualified candidates could not get a job. Damn......everything was just fine when the economy was growing

  • @KELLY2NE1
    @KELLY2NE1 Před 23 dny

    I am also studying to become a data analyst and your story resonates with me so much!. I've also gone through some job interviews but because of my lack of experience I haven't gotten the job yet. I almost did one time, they even talked about giving me an offer after multiple intervies and technical tests, but they ended up ghosting me. It made me feel awful about myself and I even hated myself for a few days telling myself how ignorant and worthless I was and that I had made a fool of myself when I put myself out there. But im doing better now, I'm just confusing on learning and practicing more and i truly believe that eventually someone will give me a chance to prove myself. Btw, the inpostor syndrome can be a real son of a b!sh sometimes. You're worth so much more than those negative thoughts

    • @Thumper_boiii_baby
      @Thumper_boiii_baby Před 20 dny

      Bro give me a roadmap please

    • @KELLY2NE1
      @KELLY2NE1 Před 20 dny

      @@Thumper_boiii_baby What for? I'm genuinely curious

    • @Thumper_boiii_baby
      @Thumper_boiii_baby Před 20 dny

      @@KELLY2NE1 I'm starting my journey to become a data analyst. So if u give any ideas like suggests some good CZcams channels or best courses like that.

    • @KELLY2NE1
      @KELLY2NE1 Před 18 dny

      @@Thumper_boiii_baby I took the IBM Python for data science, AI course on Coursera and it was great for a beginner like myself. I've also watched several YT videos from "Bro Code" and "Programming with Mosh". Udemy has also been awesome for learning SQL. Hope this helps!

  • @NinoMakesGains
    @NinoMakesGains Před 24 dny

    You fail when you quit

  • @Zuranthus
    @Zuranthus Před 25 dny

    you didn't fail, this guy set you up. probably gave you a task that wasn't even possible

  • @datawithtess
    @datawithtess Před 26 dny

    I remember you. I love your Tableau dashboards. I saw your portfolio it's very great. Where do you leave??

  • @mehg8407
    @mehg8407 Před 28 dny

    You shouldn't have quit. You were basically being paid to learn. You should have continued taking their money. You are on a learning path. You didn't fail. lol Also, startups are all like that. People are just making stuff up on the fly. Keep looking for more data analyst jobs. Forget about these people and for god's sake....don't be afraid to get fired.

  • @coolk3809
    @coolk3809 Před 29 dny

    You look like a great guy, I would definitely hire you if I was a manager

  • @sujarahaman2475
    @sujarahaman2475 Před 29 dny

    You did great brother. It is not easy to transition into a new job sector and environment. You should be proud of yourself for how far you have come and the fact that you managed to share your story with all of us. It takes real courage to recognize your fault. Dont be sad when you know you gave your best. But i will tell you something, it might also just be possible that the company you worked for was not suitable for a fresher. I dont want you to pin this on the impostor syndrome you seemed to have, but not all companies hire people keeping in mind that you are new to the industry. In my opinion the colleague you had, was very unprofessional with you, and you deserved better. If you have genuine interest in the field of data analytics, I would say you could possibly give it another shot (no pressure tho my friend, you did well as is). I wish you all the best for you future :).

  • @stevensmith3523
    @stevensmith3523 Před měsícem

    We are here for you brother. That sucks, it just sucks. Some people will never be able to change the way that they think about their career and they will bring other people down to prevent change. But people entering the field have to be the ones to change it. I used to work in restaurants as a cook with a very toxic environments that seems to be similar to this start-up's. I figured that I would have to bring the positivity to the position. Never let someone like that senior analyst stop you from pursuing your interests. We are all cheering for you. We are all wishing you the best, keep pushing forward.

  • @cosmenaskincarenatural5283

    Hola, me encontré tu video. Puede que suene como una opinión poco popular, pero sí debes trabajar más en tu mente y tus prioridades. Como lo explicaste, la verdad es que no tuviste tiempo suficiente para hacer el ejercicio que te pidieron, y por eso fallaste. Tu manager te regañó porque realmente en la industria nadie te va a dar palmadas en la espalda cuando te equivocas, más bien, esperan que detectes el error y propongas estrategias para mejorar. En este caso tú tuviste la culpa y debiste soportar el regaño y seguir adelante. Ahora tienes la experiencia, úsala para encontrar una mejor oportunidad y no te conformes con un trabajo que no te hace crecer, un trabajo que no te reta de vez en cuando solo te hace conformista. Y claro, todo es dependiendo de tus objetivos, pero una vez que te pongas las metas, cumple.

    • @cosmenaskincarenatural5283
      @cosmenaskincarenatural5283 Před měsícem

      Y aclarando, no es hate, solamente que tampoco creo que sea positivo tomar una mentalidad de víctima y solamente te sientas mal por lo que paso. Recuerda ver el lado positivo y buscar como conseguir lo que quieres.

  • @radiocruz2010
    @radiocruz2010 Před měsícem

    Hey Juan. Years ago, I worked for an e-commerce startup, and I can attest that some startup cultures push their employees to the brink. It's unclear if they aim to mirror leaders like Steve Jobs, Jeff Bezos, or Elon Musk. Regardless, I've experienced what you're feeling now questioning my sanity, taking work home, arriving early, and staying late to satisfy my manager. I found myself doing the work of three people without extra pay because it was expected. I aspired to be an outstanding employee, but eventually, I realized the toll it took on me without genuine support. The lack of support stemmed from the startup's frugality and unwillingness to invest. Such underhanded tactics are common in startups that are barely afloat. My health deteriorated, leading to eczema breakouts on my torso and legs, so I resigned for my well-being. I experienced a gamut of emotions-anger, frustration, betrayal. I left without a formal exit interview. In retrospect, it was the right decision, and it taught me to stand up to anyone who treats me as less than human. This seems to occur more often to kind individuals than to the unkind. My advice is to take a break, regroup, and stay positive. Something good will come your way. You're truly skilled. Keep your spirits high.

  • @shizaanwar4466
    @shizaanwar4466 Před měsícem

    it's not only you bro. in my career during four years. i face almost 5 similar situations with toxic seniors which left me questioning myself for months. so. yyeah

  • @skyscreemz
    @skyscreemz Před měsícem

    It’s not you- it’s the toxic micromanager. It’s a freaking start-up, everything is trail n error. The organization is still in amateur cycle. Their loss buddy.

  • @ahmanidoctor9716
    @ahmanidoctor9716 Před měsícem

    You did not deserve that. Believe in yourself and things will get better for you.

  • @anirudhr4710
    @anirudhr4710 Před měsícem

    stay strong brother we love you

  • @maryllianvieira0667
    @maryllianvieira0667 Před měsícem

    I don't think you failed. Unfortunately, you worked with a bad person. All these feelings about not being good enough is our mind lying to us. Your videos are an inspiration to me and I'm sure that you be hired again, working in a better company ❤ Stay strong 💪🏽

  • @goatedasparagus
    @goatedasparagus Před měsícem

    Stay strong bro. I remember using one of your videos as an insipiration for my project. Things will get much better for you,my friend.

  • @channelwhoa66
    @channelwhoa66 Před měsícem

    Oye Juan, aprendiste Data Analyses solo? Osea, estudiando videos y registrandote en classes?

    • @juanmartinezii5677
      @juanmartinezii5677 Před měsícem

      Aprendí haciendo el certificado de Data Analytics de Google en Coursera y practicando bastante

    • @channelwhoa66
      @channelwhoa66 Před měsícem

      @@juanmartinezii5677 Sabiendo eso me da mas fé en que yo tambien puedo! Gracias amigo!

  • @channelwhoa66
    @channelwhoa66 Před měsícem

    I just completed this with your walkthrough! Thank you for this! It really helped my understanding much better for working with Python, but in DA in general? Can I ask, this is Python. Yes? And where do people go to learn the code to do different things? How did you learn and memorize how to write all that code in that way?! where do we learn this! Thank you Juan!

  • @channelwhoa66
    @channelwhoa66 Před 2 měsíci

    Why would you use Python if it wasn’t a tool used in the course?!? Also did u get hired?

    • @juanmartinezii5677
      @juanmartinezii5677 Před 2 měsíci

      Because I believe Python is a more well rounded tool which you can use for other purposes, whereas R is mainly only used for data analysis and data science.

    • @juanmartinezii5677
      @juanmartinezii5677 Před 2 měsíci

      Yes, I did get hired with this and my other projects in my portfolio

    • @channelwhoa66
      @channelwhoa66 Před 2 měsíci

      @@juanmartinezii5677 Is it possible to complete this particulat case Study using excel or sheets?

    • @juanmartinezii5677
      @juanmartinezii5677 Před 2 měsíci

      @@channelwhoa66 I recommend doing as many projects as you can, and not only copying and pasting projects, but doing projects about topics you are interested in. Also keep practicing and learning because at the end what matters the most to employers is that you are capable of doing the job

    • @channelwhoa66
      @channelwhoa66 Před měsícem

      @@juanmartinezii5677 michisimas gracias Juan!! Last question…. For note😁 Should I wait to apply to entry level jobs while I work on portfolio? Or wait till I have a project? Thanks again Juan! 🍻

  • @felixjones4522
    @felixjones4522 Před 2 měsíci

    I'm new to data analytics do u have videos explaining the basics on becoming a data analyst

  • @mercyokwoli6837
    @mercyokwoli6837 Před 2 měsíci

    Thank you so much

  • @josealdrete2963
    @josealdrete2963 Před 3 měsíci

    I really like your videos they are very informative. Keep up the good work!

  • @GastonG-uj1tv
    @GastonG-uj1tv Před 3 měsíci

    0:35 disminuido 1:06 aumentado.

  • @sourach6325
    @sourach6325 Před 4 měsíci

    hi, i am taking the same course and i am doing the case study but i am lost about how the case study should look like at the end, so after i went to your portfolio i saw that you did the both case studies that are on the google course project and i saw that you write each step and what you did in it, so i want to ask you about the steps of finishing this project so i need first to analyze and then put is in Kaggle as you did and this how i am done from the project?? plz tell me i really need your help

    • @juanmartinezii5677
      @juanmartinezii5677 Před 2 měsíci

      You can download the files and do the analysis locally on your machine with Jupyter notebooks or on Google Collab and upload the project files on your GitHub profile or do the analysis directly on kaggle

  • @cadenaughton8873
    @cadenaughton8873 Před 4 měsíci

    Loved the project! I was looking deeper into the dataset, and I had a question that I noticed when in Looker. I see that there were a few years when Captain Morgan and other liquors were listed at zero. Given that Captain Morgan is one of the more popular liquors, can you explain why this value was found at zero?

  • @JohnDows
    @JohnDows Před 4 měsíci

    Perfecto senor!

  • @user-tz5cq6vh5k
    @user-tz5cq6vh5k Před 4 měsíci

    Excellent project. You are truly the best for me.

  • @johnadoga9765
    @johnadoga9765 Před 5 měsíci

    Thanks for the video Juan, please can you make a video on how you built and designed your portfolio? it's really nice... thank you

  • @ragulmarley4900
    @ragulmarley4900 Před 5 měsíci

    Really nice 🙂 explanation please make sql video all functions

  • @asp4628
    @asp4628 Před 5 měsíci

    Sir, do some real world project end to end.

  • @carloanimationTV
    @carloanimationTV Před 5 měsíci

    can i do this in anaconda?

  • @Serigne111
    @Serigne111 Před 6 měsíci

    I love it 🥰🥰

  • @Sirigineedi_Navann
    @Sirigineedi_Navann Před 6 měsíci

    Nice one dude 😊

  • @osoriomatucurane9511
    @osoriomatucurane9511 Před 6 měsíci

    Awesome tutorial. Select category_col, count(*) From table Groupby category It is equivalent to df.category_col.value_counts() in Pandas. Itwould be interesting to display the final results as percentagens for better readibility and comparison. Could you kind shed some lights on how to get a percentage column along the count values?? Thank u

  • @MrTiagoGregori
    @MrTiagoGregori Před 7 měsíci

    I'm on this course and they aren't using python but R.

    • @damilo7404
      @damilo7404 Před 6 měsíci

      You can use any tool at your disposal

  • @pablodaniellp.akabarklas7690

    Hola, yo soy músico productor! Y quiero vender mi música en la plataforma, cómo hago para que no me roben mi música? Por qué se, que se tiene que subir el tema completo

  • @TheCarocornExists
    @TheCarocornExists Před 8 měsíci

    Thank you so much! It's all coming together now😅

  • @c.b.5535
    @c.b.5535 Před 8 měsíci

    This was great!! It really helped me, to learn what to do for a project. Can you please turn up the volume in future videos? You sound a bit low.

  • @prajwalshetty646
    @prajwalshetty646 Před 9 měsíci

    I enjoyed the project, learned a lot. I suggest you to keep the audio a bit high in your future videos. Your channel subscriber count will soon be in 100k!!!

  • @ashumatak
    @ashumatak Před 9 měsíci

    Hi, Thank you for the video, can we use the same set of code for R programming?

    • @JohnDows
      @JohnDows Před 4 měsíci

      What's the trouble to use the same data-set with R?

  • @yairich_
    @yairich_ Před 9 měsíci

    Cuánto tiempo se demoró en qué se viera reflejado en tu cuenta de Paypal ?

    • @hankeoutofcontext3478
      @hankeoutofcontext3478 Před 6 měsíci

      Supuestamente demora entre 24 y 48hs, pero hace 4 días compraron mi música y aún nada. Tuviste alguna respuesta?

  • @OttomanSmack44
    @OttomanSmack44 Před 9 měsíci

    Is it possible to do this in python? Or are there any videos utilizing python?

    • @MDCRITICA
      @MDCRITICA Před 7 měsíci

      If I'm not wrong, you might find Python cases in Kaggle itself. Take a look. I'm pretty sure I saw someone that did it with Python.

    • @channelwhoa66
      @channelwhoa66 Před měsícem

      My undersanding is that this is Python!

    • @OttomanSmack44
      @OttomanSmack44 Před měsícem

      @@channelwhoa66 after months Thank God I now know sql python Tableau/Looker and sheets/excel keep the hustling. You’re right it is Python.

  • @aminamoallim9121
    @aminamoallim9121 Před 9 měsíci

    Hi Juan, great video thank you for sharing your work. I have a question, could the calories column in that data is related to calories intake rather than the calories born?