Data Analytics

laxmiarte's profile thumbnail
Hi Leila,I do a lot of analytics and data visualization work. I'd say my day is split pretty evenly between data ETL work (basically getting the data ready for analysis by pulling, loading, and cleaning it) and data visualization work (i.e.: designing dashboards to present the data for decision making).I spent many years at Verizon, where I did a lot of large scale data architecture and implementation work. Think designing a database that would scale to many millions of users. Along the way I also started working on analyzing the large quantities of data being collected using SQL, Python and SSRS. Over the last 4-5 years, I created my own business where I do this exact sort of work, but at my own company Data Clartiti. I hope this helps..
virgofromearth's profile thumbnail
Hi Laxmi, Thank you so much for your response this is very helpful! What specific software do you tend to use on a daily basis like (SQL software, BI tool) and how did you enter into data analysis? Did you learn through school or was it more self taught?
laxmiarte's profile thumbnail
Happy to help..I use the following tools most often:- SQL - BI tools: PowerBI, Tableau, Google Data Studio- Azure Data FactoryData analysis and databases was something I learned in grad school. The BI tools were self taught. I'd say having an understanding of how databases work both logically and physically has served me well. BI tools these days are quite simple to pick up. I have a video on my Youtube channel called How to build a PowerBI report in 5 mins. Link : https://www.youtube.com/watch?v=vxwcvfDQcywcheers!
virgofromearth's profile thumbnail
Awesome! Thank you so much, I’ll check out your video. Also, do you have a Linkedin I can connect with you on?
allisontn's profile thumbnail
I’ve also been looking into roles in Data Analytics and just started the Google Data Analytics Professional Certificate: https://www.coursera.org/professional-certificates/google-data-analyticsIt’s designed to prepare you for an entry-level Data Analyst role, gets into SQL and R, and partners with several tech companies to recognize the cert. The reviews I’ve read on it says it more basic/foundational, but I figured everyone has to start somewhere :)
virgofromearth's profile thumbnail
Hey Allison!I also started the Google Data Analytics Certificate. I did some research on whether or not it was completely worth it but so far it’s been pretty helpful. I had some knowledge of SQL and Excel but I think knowing the basics/foundations is still useful as I haven’t been learning about data analysis for that long. How are you enjoying the course so far and when do you think you’ll complete it?
allisontn's profile thumbnail
That's awesome! Yeah, I'm still working through Course 1 but liking it a lot so far. I need structure to learn, so I appreciate how well laid out the curriculum is and that they walk you through it from the beginning. I've taken R courses before in my grad program, but felt like I was just thrown into the code without explaining the what/why of the analysis. Hoping to finish the cert by December, but also been doing DataCamp on the side for extra SQL practice. Would love to hear how it's going for you and your data analytics journey too!
virgofromearth's profile thumbnail
I’m also on course 1! and I’m the same way when it comes to learning I prefer a lot of structures and the videos help a lot since I’m not too keen on just learning by reading. And oh no that sounds rough I can understand how that was probably confusing hopefully the structure in this course will help you understand R a bit better! I’m kind of eh about them using R because I feel like most data analysts use Python but the more languages you know the better lol. And ah I didn’t know they had Datacamps! How is that going for you? I started learning about data analysis back in July and learned SQL and kind of got a better understanding of Excel through self teaching. It wasn’t that hard to learn again, not a lot of structure so I kind of struggled but doing guided projects/independent projects definitely helps a lot.
allisontn's profile thumbnail
That’s so great! Yeah I definitely recommend DataCamp then - it’s similar to Codeacademy but their courses are geared for Data Science and include more practical applications that I personally wanted (e.g. Marketing Analytics, Python for Finance). I think they have a whole Excel course too! Best of luck with your data journey! 😊
virgofromearth's profile thumbnail
Thank you so much!!! Same for you I hope everything goes well in your data journey ❤️