How I use SQL as a Data Analyst

Поділитися
Вставка
  • Опубліковано 21 лис 2024

КОМЕНТАРІ • 886

  • @LukeBarousse
    @LukeBarousse  2 роки тому +140

    Data Nerds!! I'm thinking about starting a video series on: "How I use ________ as a Data Analyst"
    🛠 What tools/skills would you want me to make videos on?

  • @jacknelson7516
    @jacknelson7516 2 роки тому +343

    This was one of the most comprehensive explanations of how to start with SQL I have seen yet! Great channel mate and love the content.

    • @LukeBarousse
      @LukeBarousse  2 роки тому +5

      Aw thanks for noticing this Jack!! 🙌🏼🙌🏼

    • @hamzamehalli2825
      @hamzamehalli2825 2 роки тому +1

      @@LukeBarousse ​ I'm very bad at mathematical, i'm wondering if its possible for me to became a data analyst? even with my low level in math?

    • @Hellios92
      @Hellios92 2 роки тому +5

      @@hamzamehalli2825 You do need a basic understanding of maths, especially statistics, but not too much.

    • @LukeBarousse
      @LukeBarousse  2 роки тому +5

      @@hamzamehalli2825 I would agree with Ravioli on this one!

    • @Iose88
      @Iose88 2 роки тому

      For me too, finally I understand what is data analyst doing and relationship between SQL and individual database. Thank you.

  • @thelee3105
    @thelee3105 2 роки тому +39

    I recently graduated and was happy I was able to get a job working with data. So much exposure with SQL makes me so happy because this is my foundation of experience towards furthering my career. Your channel helped me!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +2

      Heck yeah!! Congratulations on landing the new role, this is so awesome to hear!! So glad the channel could help 🙌🏼

  • @Freeflier1978
    @Freeflier1978 2 роки тому +175

    Had my 1st interview with a NAVSEA contractor that is modernizing data analytics programs. SQL and viz were all we talked about. He stressed it's more important to under SQL and viz fundamentals, and the rest will come with time and training. 2nd interview is next week. The 20 years of ship maintenance availabilites and navigating NAVSEA while active duty finally paid off. The domain experience is 100% why they called me 1 day after submitting my resume.

    • @LukeBarousse
      @LukeBarousse  2 роки тому +14

      Congrats on passing the 1st interview!! good to hear they are using the core tools for the job!!
      Good luck on round 2, you got this!

    • @TinMaN01803
      @TinMaN01803 2 роки тому +4

      soooo how did it go?! You have the internet behind you waiting for an update!

    • @jbyanx
      @jbyanx 2 роки тому +2

      Wow congrats 👏 .

    • @christhesoftwareguy5672
      @christhesoftwareguy5672 2 роки тому +18

      I just got a job with NAVSEA as well in the DC area

    • @LukeBarousse
      @LukeBarousse  2 роки тому +7

      @@christhesoftwareguy5672 Heck yeah; congrats on the new role!

  • @newenglandnomad9405
    @newenglandnomad9405 6 місяців тому +4

    OMFG, been studying sql for a while. This video is the first one to get to the damn point with a real work work query question. I'm so tired of fake example queries and practice tests.

  • @shresthaditya2950
    @shresthaditya2950 Рік тому +22

    0:50-Adhoc analysis
    1:09-Descriptive Analysis
    1:15-Diagonstic Analysis
    1:45-Giving analysis to non technical people
    7:45-SQL course

  • @ibrahimarif3144
    @ibrahimarif3144 Рік тому +4

    This is the best video I have ever seen on SQL. I'm a complete beginner and this has given me the direction I need to start my journey! More like this!!!!

  • @stockmarcuslittle6359
    @stockmarcuslittle6359 11 місяців тому

    Thank you for your service! I was an Avionics Tech in the Marine Corps, spent a lot of time around sailors. I have been studying SQL for an upcoming business intelligence position for my employer. Your videos have been awesome! Keep it up!

    • @LukeBarousse
      @LukeBarousse  11 місяців тому

      Thanks for sharing, and keep up the studies shipmate!

  • @michaelangello9209
    @michaelangello9209 Рік тому +7

    Detailed in depth without 'big words' for a beginner. I just started SQL, thanks for informing me why I need to immerse myself in it

  • @TonyFaustino
    @TonyFaustino 2 роки тому +22

    Luke, thank YOU for the inspiration and teaching you provide to your subscribers/students with every video you publish! I'm currently finishing Course 6 in the Google Data Analytics Certification (aka The Tableau Data Visualization section). I started DataCamp's SQL Fundamentals Track about two weeks ago for two reasons: (1) I didn't want to lose the SQL knowledge I worked hard to learn in Courses 3-5. (2) Every reason you described in your amazing video. I have a family relative who is a data scientist, and he reinforced the importance of SQL skills in a data science career. 90% of the real, daily, and unglorified work of a data science professional is the processing, the cleaning, and the preparation of the data in SQL BEFORE analysis (whether it's in R, Power BI, or Python). The 10% sexy stuff is the analysis (aka the stuff most people want to talk and brag about). Thank you for presenting in your work what's real and for keeping it real. All the best to you in 2022 and Keep Doing What You're Doing!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +2

      You are so right about the 90/10 rule... the unglorified work is definetly in the cleaning and SQL is so important for this. Interesting to hear your using another course to supplement your SQL knowledge while also pursuing the Google Data Analytics Certificate!! Too cool! I love me some datacamp as well, so I think you made a good choice!!
      Thanks again for the kind words

  • @RESIDENTEVIL1256
    @RESIDENTEVIL1256 2 роки тому +3

    I have been on my Data journey for a few years now and I have a decent grasp of all the skills independently. This video, especially the last portion truly helped me get an idea of how I would orchestrate these skills to fulfill actual job roles.

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      So glad this video was helpful in helping you understand that!

  • @dantarradellas7351
    @dantarradellas7351 Рік тому +12

    Awesome! As an sql veteran, this was essential and a fantastic connectivity overview for ‘new’ tools. Thanks. 👍

  • @seanmcgrady8688
    @seanmcgrady8688 2 роки тому +4

    Initially, I thought I'd try for a data scientist role, but after encountering your video and channel, it seems like working as a data analyst, developing my skills & experience to level up sounds like the best plan for me. I've about finished the Dataquest plan for Data Analyst. Afterward, I'm going to work through a solid Excel project & Power BI or Tableau project. I'm nearly at the application stage, and I've got 20+ projects in Python, and ~3 in SQL. I just need to make something decorative, and I'm applying!
    I discovered your channel late in my development, but it has been invaluable in helping me reach its end. Thank you.

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Hey Sean! I think you made the right choice (obviously I'm biased) BUT I truly do believe its a great role to start in this field and dive right in! Good luck with your projects, you seem like you are on a great path!

    • @seanmcgrady8688
      @seanmcgrady8688 2 роки тому

      @@LukeBarousse Thanks, Luke. It means more than you know.

  • @olexandertverdohleb9874
    @olexandertverdohleb9874 2 роки тому +2

    Working as data analyst over the last five years in Dubai. Using SQL for the last 3 years. Regret that didn't start learning this tool before. It is so easy, universal and practical, that I applied it at almost every single project: CRM system, marker share calculation system, data warehouse, data orchestration, automatic import / export, calculation tools etc. I am using SQLite, Python, Excel and Power BI mostly.
    Ps. Thanks Luke for your channel. It helps me to structure my existing knowledge + inspirational for new ways of using it.

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Heck yeah, glad this could help, Olexander; and thanks for sharing your experience with SQL!

    • @ldld7210
      @ldld7210 2 роки тому

      How is the devOps & Cloud sector over in the Gulf?

  • @bigpp3397
    @bigpp3397 2 роки тому +3

    THIS IS IT! That's what I needed to see to understand what a data analyst does. I would love to see going through a project that's asked and how do you solve it (mayde a description of the meeting with manager too). If someone has a video in mind I would love to watch it

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      This comment means a lot!! Thanks so much for this and so glad this video could help!
      Let me see what I can do about the project video, there seems to be a lot of curiosity on this topic so stay tuned!

    • @probico
      @probico 2 роки тому

      I 2nd that

  • @MemeVibesCentral
    @MemeVibesCentral Рік тому

    I'm love sql, I was learn through Google data analyst and try deeper in SQl for data science. My journey just started

  • @michaelghabour5547
    @michaelghabour5547 2 роки тому

    From all data analyst videos I ever seen while learning SQL… plus my love for data… that’s the best video I ever seen hands down

  • @kashifaliazim8367
    @kashifaliazim8367 8 місяців тому

    I have watched so many videos so many lectures but the way you explain all those things it's just wow!! I am glad you are my mentor
    Thank you Sir
    A lot of respect from Pakistan!

  • @Gutsberkman
    @Gutsberkman 2 роки тому +1

    That unboxing part was so awesome! Cheers to the guys who made this poster

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      🙌🏼 thank you!!And i'm blessed with some good friend and subscribers!

  • @danhvokhanhtoan2984
    @danhvokhanhtoan2984 Рік тому

    This is the most useful and simple SQL and DA workflow video I've found on the internet.

  • @yawmanuel9758
    @yawmanuel9758 2 роки тому +2

    This video shows how deep you are in the data field
    Though a short video, but deep explained.

  • @John-Walker
    @John-Walker 2 роки тому

    Love DBeaver! Been using it for 6 months on a work project and have now moved to using it on personal projects. It is such a powerful tool for writing SQL
    Recently started using Python for SQL templating with Pandas and JinjaSQL

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Good to hear someone else's experience with DBeaver, thanks for sharing this John!

  • @JAndersonThe2nd
    @JAndersonThe2nd 2 місяці тому

    Thank you so much. Im curently taking the Google Data Analytics Professional Certificate and this video answered a lot of questions i was curois about. And the way you visualized this video is great, I had to leave a like and comment.

  • @Thuvu5
    @Thuvu5 2 роки тому +37

    Woah.. such an awesome video Luke!! It's easily the best introduction to SQL and databases for data analysts! I thought I knew some SQL but really learned a lot from your explanation and enjoyed it. Thank you for querying my name, that's so sweet 🤩

    • @LukeBarousse
      @LukeBarousse  2 роки тому +2

      Aw thanks so much for this and I've learned a lot from your videos as well!!
      BTW,now that you commented, I gotta go update my database... again 😂🤣

    • @Thuvu5
      @Thuvu5 2 роки тому +1

      @@LukeBarousse Hahaha very well. Be careful, next time I might add some secret code that would corrupt your subscriber database.. jk🤣

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      @@Thuvu5 you would never 😜😂

  • @benjamin4206
    @benjamin4206 2 роки тому +2

    Yo! I can’t believe I made it into your vid. Thanks. Now I am a certified Data Nerd!

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Heck yeah you did!! Always love reading your comments so had to throw ya in!! #DataNerd

  • @brownbear8936
    @brownbear8936 Рік тому

    The gifts from the subscribers were hilarious! had a blast. good to see, that data nerds have a decent sense of humor :D

  • @tonepoet
    @tonepoet 2 роки тому +46

    Super timely as always, Luke. Into the SQL portion of the Google Data Analytics certification and a bit perplexed at the formatting. I get the importance, but it's French (so far) to me. Your videos are really pulling me through this and I can't thank you enough for these!!!!!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +5

      Aw thanks so much for this! Good luck with the Certification, you got this!

    • @probico
      @probico 2 роки тому

      How much time the Google certificate will take to finish?

    • @tonepoet
      @tonepoet 2 роки тому +3

      @@probico From what I've heard, it's normally a 6 month course, but you can finish it much quicker. There are 8 modules (with the capstone project). I'm at the beginning of module 4 and I started at the end of November, so I've done 3 modules in 2 months. The 6 months spreads the learning out pretty well and makes it very comfortable and manageable.

    • @5orrowonthevibe
      @5orrowonthevibe 2 роки тому +3

      @@probico The course intro says it's around 6 months, but you can actually do it mush faster. From my personal experience, the time wasn't a problem but to truly understand the concepts in every single chapter.

  • @Amb3rjack
    @Amb3rjack 2 роки тому +1

    Excellent! I got an awful lot out of this video as I am just dipping my toes in the water with SQL and Python - this video kind of put everything into perspective for me. Superb!

  • @KenJee_ds
    @KenJee_ds 2 роки тому +59

    That surprise at the end is AMAZING lol

    • @LukeBarousse
      @LukeBarousse  2 роки тому +3

      😂 I was a little nervous to show this TBH 🤣

  • @abdullahadwani422
    @abdullahadwani422 5 місяців тому

    The way you talk is so good 👍🏻it is so clear and doesn’t bored one off

  • @ww2hungary827
    @ww2hungary827 2 роки тому

    A beautiful video, I have subscribed Luke. I just finished a degree in data analysis and this brought back the joys of me first understanding the power behind SQL and my dislike for using MS Access.

  • @andreayomalan9528
    @andreayomalan9528 2 роки тому

    You don't know how much this video helped me. There was too much useless theory in the class that I took and I was stressed sbout how I was gonna use it in the workplace but this gave me a clearer path for my researches. Thank you!

  • @lucidviolin1298
    @lucidviolin1298 Рік тому

    Finally a video that touched on the real-life situation of a data analyst job. no other video showed such a simple benefit within a video... now to binge your other videos jhah

  • @muhammadmannan8621
    @muhammadmannan8621 2 роки тому

    This year I recently committed myself about going on a path to become a data analyst and finding this channel has done nothing but deepen and excite my desire to achieve that goal! The content you make is dope!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      My dude, thanks so much for this. This comment made my day!! Keep up the hard work 🙌🏼

    • @Applefanboy2012
      @Applefanboy2012 2 роки тому

      How is it going?

  • @siranxie844
    @siranxie844 Рік тому +1

    Such a nice and one of the most comprehensive explanations on how to start with SQL!

  • @bansalsaurabh7
    @bansalsaurabh7 Рік тому

    Finally, finally someone explained me SQL form basics and its uses.

  • @gogokostadinov
    @gogokostadinov Рік тому

    That guy is born to teach, super easy to understand

  • @StevenPham2310
    @StevenPham2310 Рік тому

    Thank you for sharing! I’m starting my Data Analyst journey today. 🎉🎉🎉

  • @mounikasomayajula8759
    @mounikasomayajula8759 Рік тому

    Awsomeeee pretttyyy clearrr it was. i got so much clarity by you no one taught me these keypoints in my career

  • @casualrich-lifeiseasy4921
    @casualrich-lifeiseasy4921 2 роки тому +3

    randomly found this video, and was surprised. Your explanation on databases is so well-put and informative!

  • @hyggeasian
    @hyggeasian 2 роки тому +3

    Man you are incredible, explaining with live examples 🙌🏻🙌🏻🙌🏻

  • @nikitakhd7586
    @nikitakhd7586 2 роки тому +2

    So simple and clear. Thank you so much! Haven’t found the UA-camr who can break down things in such an easy-to-understand way! Really well done for that! Examples and boss-employee scenes really help too

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Thanks for noticing this Nikita!! 🙌🏼 Glad to hear that this was helpful!!

  • @automanie
    @automanie 2 роки тому +2

    Another great video. For my new job interview I need prepare some tasks in SQL and I solve the tools for that. Great timing. Thanks 🙏😄👍

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Thanks for this!! and also what great timing for this to drop!

  • @leslielebrasia
    @leslielebrasia 2 роки тому +1

    Trying to be more engaged in the UA-cam community 😊 GREAT video I was terrified of SQL until I watched this video. Grasped the concept perfectly. THANK YOU!

  • @bassemtrad3824
    @bassemtrad3824 2 роки тому

    normally I don't comment on videos, but I'm amazed by the way you show data and tech, amazing man, really amazing

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      thank you for this! And glad you commented it helps!

  • @makeuplily
    @makeuplily Рік тому

    Wow... I came in for a brief overview on SQL and I got much more. Thank you a bunch for sharing Coursera! I was able to find additional free courses that will be beneficial in my career advancement. Blessings to you Luke

  • @alberttu8120
    @alberttu8120 Рік тому

    It opens the requirements for some basic data warehousing processes. While SQL Server (or any db) isn't data warehousing proper infastructure, projects or org that don't have large data requirements can use the DB as a place for processed historical data. Knowing and using SQL for this purpose will bring alot of value and elevate you as a data analyst.

  • @jlmoramora
    @jlmoramora Рік тому

    Thank you man. I’m getting started in data analysis and this blazed the trail. 🙏🏻

  • @chacmool2581
    @chacmool2581 2 роки тому +4

    A neat trick is that you can query an SQL database from within R or Python onto a dataframe with the RODBC and SQLite packages, respectively.

    • @syhusada1130
      @syhusada1130 2 роки тому

      but that still need SQL syntax

    • @chacmool2581
      @chacmool2581 2 роки тому

      @@syhusada1130 Yes. Of course! How else would one query SQL databases if not with SQL?

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Heck yeah, I also like doing this with Pandas in Python!!

    • @kendra850
      @kendra850 2 роки тому

      I love connecting to SQL via vscode. I find vscode to work better then R. If I have an error, then vscode well tell me the rewrite whereas R just says error without feedback

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      @@kendra850 the joys (and pains of R)

  • @stephanieloeffler4581
    @stephanieloeffler4581 2 роки тому +2

    Thanks Luke! I've finished the SQL course on the Google analytics certificate and I'm looking to develop my skills. I'll be checking out more of your videos!

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Congrats on finishing up the SQL course! I think it's a great intro into this field 🙌🏼

  • @peternguynguyen5208
    @peternguynguyen5208 2 роки тому

    Absolutely awesome! You have inspired me as I prefer using SQL to analyze and transform data for reporting over other tools

  • @tanueiloyd6561
    @tanueiloyd6561 Рік тому

    Wow, this is awesome for a fresher like me and I will follow you always to learn more using SQL as a Data Analyst

  • @katherinecaro8820
    @katherinecaro8820 2 роки тому +5

    Thank you so much! Here is a data nerd starting the data analysis path :) and your videos have helped me a lot.

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      No problem at all Katherine!! You got this! 🙌🏼

  • @eduardodeluna8245
    @eduardodeluna8245 2 роки тому +2

    This is some amazing content! I'm just done learning SQL's essentials but couldn't really see the value of learning it, it is much more clear now!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Glad this was helpful for you Eduardo!!

  • @jessehenderson836
    @jessehenderson836 2 роки тому +4

    This is great! I’ve recently started learning SQL and I have plenty of experience in tableau, R, python, and ArcGIS. Your explanation of how SQL interfaces with other software was way helpful. This’ll help me a lot going forward with how powerful I’m realizing SQL is.

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Such a powerful tool and can be integrated so well with the other skills you already have. Glad this helped!!

  • @MoeDavinci
    @MoeDavinci 2 роки тому +1

    Great explanation of SQL and the impact it has in relation to other topics.

  • @Seftehandle
    @Seftehandle Рік тому

    Thanks a lot for this video I am completing the capstone project currently, the rest of the specialization I have finished! I am very thankful for this recommendation. Looking for one for Python next :)

  • @tombachdev618
    @tombachdev618 2 роки тому

    This is the best "Data Analyst job in a nutshell" video I have ever seen! Luke is the boss!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      That's interesting, I didn't really see this as that type of video, but know that I reflect on it... it kind of is 🤣
      Thanks for the kind words!! 🙌🏼

  • @Lavishlyashleyy
    @Lavishlyashleyy 2 роки тому +2

    The joy this video brought me as an aspiring data analyst is indescribable! Thanks for explaining everything so well!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Aw hech yeah! Glad it was inspiring!

  • @I_Follow_Jesus
    @I_Follow_Jesus 2 роки тому +1

    I started as a Business Analyst last year. Currently, I'm cranking out self-service analytics in Tableau. I'm about to start the SQL specialization from the University of Michigan on Coursera. I've taken a lot of Python training, but, haven't used it professionally yet. Wish I would have started with SQL before Python.

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      I did a similar thing to you in learning Python before SQL. It's not that big of a deal in my opinion and I think you will still be fine. Good luck with the studies the PostgreSQL for EVerybody is a great course!

  • @ruwindarowel8200
    @ruwindarowel8200 2 роки тому

    I just started getting into the learning curve of becoming a data analyst and your videos have been super helpful❤❤❤❤❤❤❤❤

  • @tinovimbachitate8992
    @tinovimbachitate8992 2 роки тому

    Solid overview of SQL👌
    Saw myself subscribing before the video even ended.
    Great content...

  • @alexweaver3929
    @alexweaver3929 2 роки тому

    Only 1/3 of the way through and I have already learned so much. Thank you.

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Heck yeah! So glad you're getting value out of this one!

  • @DaBaSoftware
    @DaBaSoftware 2 роки тому

    Thanks for the overviews, loved that suprise ending!

  • @djender
    @djender 2 роки тому

    Dude, your video was spot on! Best video I've seen for data analyst beginers. Helped me a lot. Very clear and simple explanation. Subscribing!!

  • @paradise2324
    @paradise2324 2 роки тому

    This is the best explanation that I've come across.

  • @arcadevampire
    @arcadevampire 2 роки тому +4

    Excellent video! Very comprehensive, and so much more than just about sql. Everyone getting into analytics should watch this first as a primer, to get a holistic view of the analytic process. I especially liked the boss section with different types of queries. When online learning you don't get a sense of the type requests in a real world business context. A bloke in a suit to kick you up the backside always works lol!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +2

      🤣😂 My boss is always on my back about the data they want. 😂
      Also I didn't actually think anyone would care to hear about me and my boss's interaction so this is interesting to hear!

  • @BananaChan1010
    @BananaChan1010 Рік тому +2

    Thank you, this was so helpful for beginners like me. I learned so much! Great engaging editing as well, I cant wait to check out the rest of your videos as well

  • @shikharsaxena8984
    @shikharsaxena8984 2 роки тому +2

    Very useful video Luke, thank you for making video on SQL 👏👏🙌😊

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Heck yeah! Glad you found it useful, Shikhar!!

  • @damariusmcnair8906
    @damariusmcnair8906 Рік тому

    best explanation of the use of SQL. You rock brother!

  • @balazsgrunsperger2459
    @balazsgrunsperger2459 2 роки тому +1

    Great Video, very informative... however that painting / poster at the end is just so epic! Looks great !

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      I was a little worried about sharing this at the end, but glad you liked it, my friends did a great job with it! 🤣

  • @alecestrada5799
    @alecestrada5799 2 роки тому

    Awesome explanation of RL use for SQL.

  • @RJM95
    @RJM95 Рік тому

    Thanks for this video-it is very helpful for a basic understanding of SQL. I currently work as a budget analyst and frequently use MS Excel. I’m interested in learning SQL to further develop my skills in data analysis. 🤘

  • @RafaelGrigorian
    @RafaelGrigorian 2 роки тому +1

    This video was so on time! Just started learning more about SQL going through the Google Data Analytics course. Great content as always Luke!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Heck yeah, glad to supplement your Google Data Analytics learnings! Keep up the studies.

  • @mohammedlamine8545
    @mohammedlamine8545 2 роки тому +2

    Thanks luke,
    Can you make a Full Project video ,not necessary a big one but a simple project that cover the most important steps in a typical data analysis project.

    • @LukeBarousse
      @LukeBarousse  2 роки тому +3

      Yeah let me see what I can do on this, I think this would be super beneficial for the community!

  • @ranrosenhaus8414
    @ranrosenhaus8414 Рік тому

    GREAT STUFF, LUKE YOU ARE A TRUE PROFESSIONAL

  • @608er
    @608er 2 роки тому +2

    Luke, your videos are outstanding. They’re incredibly clear and still entertaining. Thank you for taking time to do these.

  • @sunnygawande5283
    @sunnygawande5283 2 роки тому +1

    I requested for this and you delivered 🤩

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Yeah you did! Thanks for the request, Sunny. I'm thinking about doing more videos like this on other tools.

  • @candycandy4357
    @candycandy4357 Рік тому

    Hi Luke, first time notice your channel. Thx for your sharing. How nice if I could download your knowledge instantly...
    Pls share more so that we can continue to learned from you...
    🙏

  • @duythanhish
    @duythanhish 2 роки тому

    A very comprehensive introduction to data analysis. Thank you, Luke!

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Heck yeah, thanks for this! 🙌🏼

  • @rickdoesai4084
    @rickdoesai4084 2 роки тому +4

    Wasn't expecting this much information, this is really thorough Luke!:)
    I have a love hate relationship with SQL but you managed to make me watch the whole thing 😅

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Ha! Thanks Rick. I also have a very mutual feeling for SQL 🤣

  • @pedroelton7040
    @pedroelton7040 Рік тому +1

    2:49, S-Q-L is the right way, come on! hahaha Great Video Luke!

  • @hitheresa
    @hitheresa 2 роки тому +3

    Hi Luke, thank you for such a wonderfully informative channel on data analytics.
    I'm looking to transition from nursing to data analytics, and I'm finding it to be very resourceful on what steps I need to take going forward!

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Aw you got this Theresa, keep up the hard work!

  • @arjunrajeshirke9933
    @arjunrajeshirke9933 2 роки тому

    Luke can you please make a video on which one is most popular and in demand in terms of usage, functionality and market capitalisation today ?
    1. Database or snowflake data warehouse ??
    2. Python or R?
    3. Tableau or Power BI?

  • @ttovar17
    @ttovar17 2 роки тому

    What a great poster. Super cool! Love the ending. Ha. Thanks for the entertaining us along with providing useful info.

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Ha, I love this poster! Thanks Tami!

  • @eddiemeddie2018
    @eddiemeddie2018 9 місяців тому

    Love the video man! I have to agree with the Access part. I’m currently learning access from school and I kind feel like it’s rather pointless to learn at this point .

  • @rishabhsahu6102
    @rishabhsahu6102 6 днів тому

    love this video I'm early in my data career and was wondering what are the practical use of sql, python and excel in the real world

  • @HTWW
    @HTWW Рік тому

    I just got SQL explained to me by a serious version of AwakenWithJP and I have mixed feelings about it.
    You rock!

  • @rodrocdl
    @rodrocdl 2 роки тому

    Very interesting Luke! It was really puzzling for me how SQL works and how relevant it was to my job.

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      I was just as confused when I started in data analytics, so you are not alone! Glad this was helpful!

  • @neztorsmiths6328
    @neztorsmiths6328 2 роки тому

    As usual, clearing out my doubts. Thanks!

  • @seanmcgrady8688
    @seanmcgrady8688 2 роки тому +1

    SQL is quite easy for the most part in terms of its syntax. I think its real challenge is thinking ahead with sub-queries. With Python, I find I can progressively generate code to solve an issue. For SQL, that kind of happens, but then I'll need to think an extra step ahead with a sub-query to properly target data, or organize it.

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Yes! Very much can relate to these differences between Python and SQL... probably part of the reason why I favor python 🤣

    • @henrywhittaker8736
      @henrywhittaker8736 2 роки тому

      CTEs are your friend

  • @sumitapathak2900
    @sumitapathak2900 2 роки тому

    Now this is my favourite data science channel

  • @iamkv
    @iamkv 2 роки тому

    The kind of video I was looking for! Thank you Luke!

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Thank you, hope it helped ya out!

  • @rem9486
    @rem9486 2 роки тому +17

    Awesome as expected Luke! Got me inspired to learn SQL this weekend!
    Would it be possible to get a PowerBI tutorial from you as well Luke? 😁

    • @LukeBarousse
      @LukeBarousse  2 роки тому +11

      Thanks, Rem!! And you may have read my mind about the Power BI 🤫

  • @netol02
    @netol02 2 роки тому

    Great content and informative video. Liked the idea of vinculating the leg work done in sql and using Power BI to present the data.

  • @ashleywitherspoon5487
    @ashleywitherspoon5487 2 роки тому +2

    Thank you so much for this video! I always understand when you explain things. I hope you do a SQL course🙂

    • @LukeBarousse
      @LukeBarousse  2 роки тому +1

      Aw thanks for this! Let me see what I can do about a course for this!

  • @julianyepes5317
    @julianyepes5317 2 роки тому +3

    This is perfect for helping us know what sort of work to include in our portfolios. Thank you!

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Heck yeah! So glad this is helping with building up that experience in your portfolios!

  • @AlekseySergeychuk
    @AlekseySergeychuk 2 роки тому

    This is the best video about SeQuel, I've ever seen! Thank you Luke! With love from Russia)

    • @LukeBarousse
      @LukeBarousse  2 роки тому

      Heck yeah, glad it helped ya! Love from 🇺🇸! 🤙🏼

  • @lifeseasy3924
    @lifeseasy3924 Місяць тому

    Hey I have learnt so much from this video. Thanks a lot!

  • @youssefahmed6383
    @youssefahmed6383 2 роки тому +2

    On time video 👌
    Brilliant Luke ♥️