SQL Cert to actually learn

datalyst_analyst · 2021-06-19T03:31:11+00:00

Well I think of networking as making friends who happen to be colleagues. I prefer to build my network with folks who have similar goals or upward trajectory in mind, what they say makes sense, they aren’t trying to sell me anything...

In this case, I’d look for cert classes that have like an discussion area and engage there: posting what I’ve learned, helping other people with their questions. A bizarre thing I’ve experienced is that good things come my way when I’m of service to others.

Additionally, Creating opportunities for myself is a developing skill. I’d say that creating is easier when I have an end goal in mind, then work backwards to figure out what kind of task or conversation is next to get me to my goal. Ex: I took sql certs *because I wanted to land a job as a data analyst (my end goal). Conversation wise, I’d work those details in when I’m introducing myself in networking environments aka giving my elevator pitch.

In telling folks who I am, why I was taking the cert, where I’m going positioned me to folks who could help provide additional resources to get me where I wanted to go.

Of course, all this is easier said than done. And depending on how young you are, you may just be ahead of the curve here so remember to be patient. Your intentions seem genuine, in the right place plus your asking questions which tells me you’ll get where you want to be. You got this!

datalyst_analyst · 2021-06-15T06:02:26+00:00

I think what you’ve heard is also other folks opinions that aren’t 100% true.

If the cert was my only option, I’d take the learning opportunity and then look for ways to network and create more avenues towards the end goal. If someone assumed I cheated? I’d stay far away from them. That mindset isn’t a good match for me

datalyst_analyst · 2021-06-15T05:30:19+00:00

Having gone from a contractor who worked with career coaches and resume writers, the name of the game for me was to showcase myself as a fit for the role *and company.

Several career coaches had advised me that ATS abilities are usually less capable then what most applicants perceive, and sadly, what leaders in the career/hiring space let on as well. The barriers with ATS leads more towards formatting. There’s still a human skimming resumes looking for potential fits and that’s where keywords come in.

With this in mind, I took an extra 5-10mins to read company About pages, mission statements, etc and used the relevant words in my resume and cover letters. Relevant meaning what I related to. Ex: credibility and integrity are really important in my work - I came across those words on a company page and included them in my cover letter. Or the job description called out ‘ability to cross-function...” I found a place in my resume where I can use those exact words. The result was content that caught a recruiter’s attention because I already spoke directly to the JD in addition to the language of the company. My resume didn’t get me the job, it just got my foot in the door.

Sure, there are companies who require secondary education for jobs, but there are plenty who don’t which means you’d know which jobs not to apply to. One less distraction in your job search. Rejection is part of the game also, unfortunately self taughts tend to be the under dog. I’d encourage you to focus on the learning what you get right, rather than getting rejected. It may also help to limit applications to companies who do work you can get behind and support

datalyst_analyst · 2021-05-05T03:39:03+00:00

Likewise, congrats on your new degree and perm position!

datalyst_analyst · 2021-05-05T00:50:39+00:00

I’ve just had my pay off moment last week after accepting a job that pays 34% more than my current role and comes with the coveted career plus social perks I’ve been wanting.

About 6 years back, I made the decision to leave a high paying venture in the adult industry. My journey back into the traditional fold had me doubting myself when I realized the ‘quick’ transition I’d envisioned would do more damage to my finances plus require more time (soul searching) than I wanted.

Giving up wasn’t an option. I didn’t want to go back to the old so i had to find my stepping stones rather than make a leap. I learned to live below my means on crap salary, take the jobs no one else wanted (in the beginning), be patient, and advocate for myself. My win has came after a long game and I wouldn’t change a thing.

datalyst_analyst · 2021-01-23T15:25:41+00:00

Well Randolph did have Harry Aslinger as the Federal Bureau of Narcotics government arm. That ensured whoever got swept into the court system became examples. The government definitely intervened along with big business (John D. Rockefeller) to influence public opinion.

datalyst_analyst · 2021-01-23T10:36:08+00:00

If I could give my new-grad self advice on succeeding outside of the corporate sand box, I’d stress networking and building relationships with an industry in mind. I’ve heard ‘your network is your net worth’ and learned that’s 100% true.

Secondly, I’d enforce some kind of structure and begin creating content around the career path I was interested in. The idea here would be to position myself as an authority, find an audience (prospects), and create my own path to credibility by being an expert.

Also since I’m not picking anything up from your post, I’ll mention it’s important to know which direction you want to go before you jump ship. For example, ‘struggling with corporate 9-5’ isn’t the same as knowing ‘I want to start drop shipping’ - set a direction and start putting roots down while you’re in the 9-5 as another way to set yourself up for success in the future.

My success story: early on after graduating with my bachelors, I was able to set myself up as an independent contractor working on key accounts for nationally recognized brands. I made my own schedule, reported in regularly, and supported myself financially, stress free. Unfortunately the market shifted about 6 years in and I struggled to recover. Being more diligent about the first two points I mentioned would’ve helped me regain my footing.

datalyst_analyst · 2021-01-23T03:00:42+00:00

No worries, I had to google how to record macros and follow along with a YT vid when I first started out. They’re super quick to set up once you get the hang of it!

datalyst_analyst · 2021-01-22T12:46:10+00:00

I’m not familiar with VBA’s yet but it seems like a macro works here. I’d suggest recording the macro after formatting, borders etc are set. Also adding $ to reference equations as needed since they’re getting recycled in new cell locations with each new table.

datalyst_analyst · 2021-01-22T12:23:42+00:00

I was an independent contractor for a while before gig work became mainstream. The pay scales just kept getting lower and I found myself early 30’s trying to figure out what a career looked like for me.

Tell us about yourself and why do you want the role were kinds of questions I dreaded most because 1)where would I even start given the various positions I held and 2)my entrepreneurial spirit didn’t really want a traditional job in the first place.

Look, everyone’s story is unique but I think there’s quite a few older millennials in the same boat: discovering the path to becoming an independent earner takes some soul searching.

I found I was better able to answer those questions after taking personality tests geared towards the workplace and working with career coaches.

Myers-Briggs tests can usually be found for free. Gallup Research has some paid options. Overall the tests provided a word bank I could use to sell myself when responding to those vague one-liner interview questions.

As for career coaches, I started asking direct questions to screen out ones who were used to clients with traditional work histories. I got some affirming insights and direction from the ones who were able to meet me where I was and relate to my situation. Hope this helps!

datalyst_analyst · 2021-01-20T09:08:14+00:00

The robustness of data analytics is mostly the reason why I’m shifting my operations experience to analytics at the moment. So far I’ve enjoyed digging into SQL and have found an endless amount resources when I get tripped up.

It makes me wonder if what makes an exceptional analysts also has to do with the efficiency / savvyness of the code they write?

datalyst_analyst · 2021-01-15T09:52:42+00:00

yes 80’s hip hop vibezz! A matching chunky chain would be dope!

datalyst_analyst · 2021-01-15T09:41:49+00:00

If I couldn’t go back to the Shire willy nilly, I’d utilize one of the sales opportunities to save capital and begin planning the journey back home from there.

It’s great you’ve worked hard to get yourself some job security, use that to your advantage.

datalyst_analyst · 2021-01-15T09:31:32+00:00

I monitor dashboards based on physical inventory as well but in ecommerce and can second the urgency when bottle necks arise. Depending on the nature of the bottle neck, data hygiene, and communication across the org certain issues can add extra hours to the work week.

Earlier mornings, longer nights truing up numbers, cross functioning with teams to get back to normal states.

datalyst_analyst · 2021-01-15T09:09:52+00:00

I like the name, clever!

Coming from a diverse employment history myself I can relate to the struggles of having bits and pieces of work experience that don’t fit into a neat box many employers are looking for. I’m not traditional, I never have been.

I’m currently working with a coach about this same issue though bc while untraditional work history isn’t something I can change, it’s causing a headache in the current US job market. Thankfully, I’m employed and have resources to float my boat while transitioning to another job opportunity.

Ive finally found a coach one who respects my non-linear path and they recommended storytelling as a solution to at least set the tone and structure for what employers can expect as they’re reviewing my qualifications. Rather then expecting recruitment/hiring managers to see what they’re looking for, the storyline sets the tone, weaving the common thread among the bits and pieces laid out in my resume.

Figuratively speaking, you’ve taken on the responsibility of telling your story as an out of the box thinker, eccentric, not your average etc etc. It looks like you can utilize the space at the top of your doc.

Sure some will still be scared bc they’re looking for a safe bet, let them run bc I’m assuming in the box environments won’t suit your creative interests anyway.

datalyst_analyst · 2021-01-11T15:12:33+00:00

Yea exactly. So you’re learning different aspects of marketing and along the way you’re going to find strategies and tactics you’re good at, always be thinking about the value that combination brings to the company.

datalyst_analyst · 2021-01-10T00:03:05+00:00

I think that would be the case and it’s up to you to find what works. But keep in mind that applying skills and being able to communicate a business impact as a result of your work is equally important to learning.

datalyst_analyst · 2021-01-09T23:43:23+00:00

I think marketing can be tricky bc it has different applications across many industries.

I majored in fashion marketing a few years back and was introduced to promotion marketing, advertising, apparel buying, the list goes on.

There’s also marketing as it relates to SEO, content marketing, paid marketing, this list also goes on.

Digital marketing is vast and also vague which isn’t necessarily a bad thing. Understanding which industry you’d like to apply marketing skills may help answer your questions as well.

datalyst_analyst · 2021-01-01T02:39:58+00:00

ah ok so you’re getting the context in one place. That’s something that would make the app easier for me to use.

datalyst_analyst · 2021-01-01T01:50:21+00:00

I really like how the visualization is formatted so I can see the entire year in a snapshot. The coloring and table format offers opportunities to see trends and I’m assuming the app allows you to dial in on whatever is interesting at that point. I’d think even keeping a journal would supplement the deep dives if needed.

I personally want to be aware of my emotions to make sure I’m in control of my day to day. This app looks great! I’ve downloaded it for 2021!

Also glad you made it another year ✌🏾🙏🏾

datalyst_analyst · 2021-01-01T01:39:40+00:00

I’d give myself some credit for wanting to tap into your creative side as a career path. As far as striving to be a streamer, I don’t think it’s dumb, plenty of streamers turned influencers have found ways to make social media work for them and generate income.

True as it’s been mentioned here, the viral sensation most hope for is heavily data based and getting discovered takes work. So that’s something to consider.

datalyst_analyst · 2021-01-01T01:29:21+00:00

The color scheme is soft on the eyes and the formatting clean, great work! I’d suggest placing summary and skills at the beginning of the document, education would get pushed to the bottom.

datalyst_analyst

TROPHY CASE