Leao2005

All Star
Supporter
Joined
Dec 14, 2019
Messages
2,654
Reputation
140
Daps
7,171
I've been causally do this when I have some free time. It's decent "intro" but it's weak.
With that said, when you join any job they'll typically train about how they run shyt.
So I dont think this "cert" is useless.
I almost finish with the case study. Already have my code up on GitHub. Finishing my tableau graphs

would link on here but this isnt good website to link my real name/career
 

Secure Da Bag

Veteran
Joined
Dec 20, 2017
Messages
41,326
Reputation
21,368
Daps
129,532
Does anyone know of a good Power Query book that Power BI centric? Most of the books I've come across have been Excel centric.
 

Macallik86

Superstar
Supporter
Joined
Dec 4, 2016
Messages
6,674
Reputation
1,503
Daps
21,870
Just thought of a lil interview cheat code for brehs already skilled in Power BI :lupe:
Now that most reviews are remote and screensharing is the norm, you can show your handiwork more easily:
  1. Subscriber to PhantomBuster 14 day trial
  2. Watch the quick tutorial video to avoid tripping websites looking for bot activity
  3. Go to your prospective company's FB Reviews page
  4. Scrape the data into CSV
  5. ETL into Power BI
  6. Analyze their data and create a dashboard around it
  7. Share the dashboard in the interview
Make light work of their work before they give you work to make sure they know you put in work brehs :youngsabo:

Also, once you set up the report for one prospective employer, the only alterations you make moving forward to your code is changing the FB Reviews URL. :blessed:Minimum effort w/ future employers still being pleasantly surprised at your initiative

After the trial, PhantomBuster costs $60/mo fyi. It's a worthwhile interview prep investment that I'd only do leading up to a big interview, but long-term it's probably better just to learn Python and scrape manually.
 
Last edited:

greenvale

Superstar
Supporter
Joined
Aug 1, 2017
Messages
6,353
Reputation
1,960
Daps
24,777
Reppin
Delaware
Does anybody in here do ETL work. I just got a job as an etl developer in SSIS. Wanted to see how realistic would it be to make $100,000 after working this position for a year.
Yep I work in analytics and I do my own ETL for all our analyses. I've used a variety of tools but use SSIS on the daily. I have 5 yoe and making >100k not including bonus + rsus.

Located in Philly so it's not like my COL is super high either. Data engineering is THE career right now imo.
 
Joined
Mar 11, 2022
Messages
536
Reputation
166
Daps
2,400
Been doing analytics and eventually data engineering for the last decade and been making >100k for the last 8

Analytics is one of the few areas where if you can teach yourself the requisite skills then you can become attractive in the market. Software engineering not so much since the market is saturated with CompSci and Eng degrees. The challenge is getting exposure and then experience with analytic tools like SSIS to teach yourself which is typically easier at larger companies. Smaller companies don't usually have the budget to invest heavily into analytics upfront (unless they're smart). The flip side is smaller companies can also be good place to experience building things from the ground up so it's really all in what you make it when an opportunity presents itself
 

Macallik86

Superstar
Supporter
Joined
Dec 4, 2016
Messages
6,674
Reputation
1,503
Daps
21,870
If brehs want me to do a review on the google analytics cert I can do it in here or a solo thread
Do it here. I just enrolled myself in case I get a lot of free time soon:jbhmm:

On a related note, do yall know any resources to show proof of skills to prospective employers? Right now the only thing that comes to mind is going hamburger on the AdventureWorks dataset... Build some reports and answer some data questions and then buy the premium version of Software that allows for shareable links and throw it on a website. I really don't want to deal with all the website bullshyt tbh so let me know if I'm overlooking anything.
 

Leao2005

All Star
Supporter
Joined
Dec 14, 2019
Messages
2,654
Reputation
140
Daps
7,171
Do it here. I just enrolled myself in case I get a lot of free time soon:jbhmm:

On a related note, do yall know any resources to show proof of skills to prospective employers? Right now the only thing that comes to mind is going hamburger on the AdventureWorks dataset... Build some reports and answer some data questions and then buy the premium version of Software that allows for shareable links and throw it on a website. I really don't want to deal with all the website bullshyt tbh so let me know if I'm overlooking anything.

Google Data Analytic Certification Review

Overview: Good if you have no experience, not prior job knowledge. Not useful as an IT cert. Need further studying for a job

Price: is like 39$ a month.

Time line: I finished it in two weeks, but I didn't officially finished until 3 months due to procrastination on the capstone project.



Skills taught: Tableau, Google Spreadsheet(Excel), R, SQL
Also, job stuff, Data thinking


Overview:
The course outline is this:
1. Foundations: Data, Data, Everywhere:
2. Ask Questions to Make Data-Driven Decisions:
3. Prepare Data for Exploration:
4. Process Data from Dirty to Clean
:
5. Analyze Data to Answer Questions:
6. Share Data Through the Art of Visualization:
7. Data Analysis with R Programming:

8. Google Data Analytics Capstone: Complete a Case Study:

The course mainly goes over a selection of topics: Making yourself marketable in the job market, workplace etiquette in data, Thinking in a data analytical way, Spreadsheets, SQL, R, and Tableau (and storytelling). Google has a 6 step process for data that you can look up.

Briefing talking about my backgrounds: I have a economics background, and currently worked in the data field, but was not using programming language at work as a recently post Bach grad. Was/am currently doing my master while doing cert. I learned R through school, and excel proficiently through work. I learn SQL through data camp prior to doing this cert.

Thus, why my timeline was very short. However, if you take this like you would going to high school, you could finished this in the same rate.



I think that the topics cover were great to trash:
SQL: the basics of SQL was pretty good. This is good enough to get you started. ie SELECT FROM, INSERT, CREATE TABLE, WHERE, AVG, MIN, etc. very simple. The questions were not too hard tho
  • BIGQUERY is trash in terms of using, by they have good real world datasets
R: I am a R fanboy due to me using it in my economic backgrounds
  • Very short compared to how I actually use it
  • Many people were confused from it on how she presented it.
  • I didn't like the visualization part of it. I myself only use visualization in R to see visual what I need to code. A good non "R" looking visualization takes too much code.
  • Not really don't well from my opinion as well
Tableau: Used for visualizations
  • Not done well
  • In my experience the hardest to learn quickly.
  • SPREADSHEETS are the most important thing to learn, which I don't believed was covered.
  • Even other parts are not well done as well . Example: One of the case studies uses location data. This course does not really go in depth on map graph. So without outside searching, you will be stuck
  • Best to learn outside of course
Spreadsheet: Well done
  • A Data analyst who can't use excel is a joke
  • Give a good amount of knowledge in terms daily operation, formulas, and etc
  • This is the best of the course

They also cover some aspects, like thinking in a data way, thinking in a critical way, making sure you know how to act in a job (ie emails, dress, etc), job search and interview tips, career development tips, etc. Probably the most valuable from the cert. Its the biggest value over the similar IBM cert.


Job opportunities: Close to none. Google states companies are willing to hire post cert. This is a lie, even the Secret job board Google has is relatively poor. The job board does not have a lot of remote opps (I believe less than 20 off top). If you don't care moving, you could prob get a job, however, most opps are in High Living areas however.

Companies in general are not aware of this cert as well, and does not hold real cert weight compared to lets say C++ or COMPTIA++ or even a Tableau Cert
  • To this point, in the data field, projects>certs. And Experience>projects. Make sure do the capstone project and other projects very soon.
  • To the first point, get a Github, LinkedIn, and a portfolio website

Personally, post cert, I have went from a 15$ data job to just this month of May accepting a job just under 70k. The google cert DID NOT HELP DIRECTLY (you will see many people call it useless) however indirectly, it gave me a lot terminology that I could use on interviews. Please keep in mind when take the cert. And questions, ask me.
 

Macallik86

Superstar
Supporter
Joined
Dec 4, 2016
Messages
6,674
Reputation
1,503
Daps
21,870
The R & Tableau were the main areas of interest for me since I'm well-versed in the SQL/Spreadsheets so you definitely saved me going down a pointless path with your review. Repped and appreciate you for sharing @tunes757.

Congrats on the new gig!
 
Top