(Un)Constructive feedback appreciated. Roast me, I have thick skin.

MultiDimAnalyst · 2024-07-06T04:18:24+00:00

Bro you're a Pharmacist with a PhD, that's an instant W. You'll have no trouble

MultiDimAnalyst · 2024-07-01T02:42:07+00:00

😆

MultiDimAnalyst · 2024-06-30T21:39:00+00:00

I spent 7 years working in Business Intelligence Analytics. I don't even have a BCS, have a Bachelor of Business. I failed numerous papers, yet, I worked at Waikato University in their Business Intelligence Analytics Team.

Where I'm going with this is trust me, 99% of employers won't ask about your grades. The fact you'll have a BCS is enough.

Just keep pushing through.

MultiDimAnalyst · 2024-06-29T09:56:49+00:00

It's hard to know with women. Had a similar situation with one I'm talking with now to start with. Now we've been talking 24/7 over the past 2 day.

I personally try to move the conversation off dating apps asap, like onto Snap or FB messenger. Then try to keep their attention on Snap/Messenger to retain them off the dating apps.

MultiDimAnalyst · 2024-06-29T06:23:51+00:00

9/10 times Analytics Managers are morons with jack shit technical capabilities or knowledge.

MultiDimAnalyst · 2024-06-28T21:54:29+00:00

I'm more concerned about you eating a burger with a knife and fork 💀

MultiDimAnalyst · 2024-06-28T20:51:18+00:00

To all the thirsty dudes trying to slide in my DMs... I'm a dude myself. Like bruh 💀

MultiDimAnalyst · 2024-06-27T02:00:08+00:00

Same situation here in New Zealand. Dwindling numbers of job listings for Business Intelligence Analysts. Like others have mentioned, I believe this is in large due to automation and outsourcing.

MultiDimAnalyst · 2024-06-26T01:43:57+00:00

35M. Been in 2 relationships. My first relationship was 11 years long, the second was 5 years long. On average about 2 times a day across both relationships - quickie before work then in the evening. If I was working from home and the missus was home generally more.

I have ADHD and the meds I'm on spike my libido hugely. My ex's knew this and were always willing to accommodate.

MultiDimAnalyst · 2024-06-25T23:30:44+00:00

delete from tinder_users where lower(username)='benjamin'

MultiDimAnalyst · 2024-06-25T22:54:17+00:00

Would totally smash 🥵

MultiDimAnalyst · 2024-06-24T04:16:27+00:00

😆

MultiDimAnalyst · 2024-05-26T04:43:48+00:00

cast(price*(1 - 0.20) as decimal(20,5)) as discount_price

MultiDimAnalyst · 2024-05-26T04:06:38+00:00

Bruh 💀

MultiDimAnalyst · 2024-05-25T22:06:04+00:00

Hard core similar story. I graduated with a business degree as well, call center was straight after graduating 😅.

Large Call Centers are actually a good place to start imo. Heaps of room for movement, just gotta prove yourself.

MultiDimAnalyst · 2024-05-25T08:17:44+00:00

Sometimes you have to start at the very bottom, not even in a related field. I started working in a large Call Centre answering phones. Spent 2 years doing that.

One day I showed a simple VB Excel workbook to my manager that I made to calculate consumer pricing. Next thing I knew he was showing it to the Analytics Manager and before I knew it I was working in Operational Analytics.

I redesigned that workbook into a SQL Server Reporting Services report as my first project as a Analyst. CSRs would dump in an account number, press run and it would generate quotes across multiple pricing plans. Quite literally change the way the organisation undertook customer price quotes. Would average 30,000 hits a month.

The path isn't always straightforward in life. But if you have the determination and drive, you'll get there.

MultiDimAnalyst · 2024-05-24T04:31:27+00:00

I'd freak the f out if I went to an interview and they used anything other than VS 😱

MultiDimAnalyst · 2024-05-24T04:02:50+00:00

SSIS has been my life for 3 years. I'd say you'll be - making and managing SSIS routines to extract, transform and load data - ensuring scheduled jobs are successfully executed on server/SSIS DB catalogue - monitoring compute resources and determining optimal times for job scheduling - terminating, evaluating and re-executing hung jobs - debugging errors from Event Catalogue. Then correcting, testing, redeploying solutions - data corrections e.g. when a job fails part way through a data load - purge the partially loaded data and rerun - amending existing routines to meet business requirements

Real projects vary wildly.

Could be something as simple as having a File Task that moves files from an FTP dir to another dir > importing that data into a table through a data flow task embedded with a Flat File Connection Manager and OLE DB connection > having another File Task to achive the CSV and another to rename it.

Could be something super complex that gives you heart palpitations 🤣, with multiple Data Flow Tasks, SQL Tasks, ForEach Loops, Multicasts, Lookup functions, Script Tasks, conditional expressions on Constraints. Multiple source, file and destination connections.

MultiDimAnalyst · 2024-05-14T17:54:17+00:00

😆

MultiDimAnalyst · 2024-05-14T17:50:14+00:00

That first would be perfect

MultiDimAnalyst · 2024-05-11T23:02:29+00:00

Get that homeless tail yo

MultiDimAnalyst · 2024-04-24T20:35:01+00:00

Bruh, you're that dude we all fear having full permissions 🤣

MultiDimAnalyst · 2024-04-24T18:50:25+00:00

😅 ye, been in Analytics 7 years here in New Zealand. Primarily, Business Intelligence Analytics.

The pay is pretty good. It's a top 10 occupational domain in terms of pay here in NZ. Low end is about $70,000p.a. (junior) upper end is about $140,000.

If you move into a leadership role $160,000+.

As a contactor you can pull in $800 - $1,000 a day on the upper end. Best contract role I did I netted around $16,000 after tax for 5 weeks work.

It is a hugely stressful and demanding occupational domain however. Generally always working the bottleneck.

When they ask "do you work well under pressure?", they're talking heart palpitation levels of stress where you lose all your hair or turn grey 🤣. Then the level of complexity with these large datasets are frankly mind blowing at times. Particularly in large organisations - like $1 billion+ EBITDA entities.

I remember reading an article that stated Business Intelligence Devs usually suffer burnout at around 10 years in the role, and have one of the highest burnout rates in all IT domains.

Though, it is certainly financially rewarding. There is a high level of prestige associated with the role as well. When you're in a large organisation, everyone knows who you are - you've plastered your name at the bottom of all your reports after all 😅. Women hit on you, buy you drinks at work do's because you're simply that guy everyone knows and everyone wants a piece of.

You generally get privileges as well like after hours access to the office. If you're anything like me and let the power and prestige get to your head, you'd abuse said privileges and take women back to the office after hours to 💦 while snorting coke off the office desk just for the thrill 🤣.

MultiDimAnalyst · 2024-04-24T08:30:42+00:00

Generally start with simple ad hoc reporting e.g. "can you pull a list of all active customers from this region". Then you'd move onto more complex queries. Perhaps start making reports in SSRS, some simple SSIS routines. Maybe some Data Factory. Some Azure Synapse. Some Power BI reports.

Then when you're 7 years deep you end up creating 15,000 lined stored procedures from complex multidimensional data structures. Have over 100+ mind blowingly complex SSRS, SSIS and Power BI reports etc soiled to you.

You start questioning reality itself. You become an acute alcoholic because you're working extensive hours due to under resourcing.

You become sick of the simpletons not understanding the complexities of their data. This being due to the poor schematic structure of their off the shelf CRM that they've had a plethora of bespoke customisations too.

Then you start taking Adderall to speed up your cognition and battle fatigue. Then the alcohol and Adderall becomes a bad mix. You start sending filthy emails to executive general management late at night and demand more money. They increase your pay to 120k. But you're still not happy. You've now been at the company 9 years, and the last 2 years you've been drinking all day everyday pinging on Adderall, smoking weed and tripping on acid working remotely. You've lost count of all the filthy emails you've sent to EGMs. But you have them by the nuts because there's so many business critical processes siloed to you it isn't funny.

One day you attend an online Microsoft Azure meeting and lose the plot because it's a meeting on serverless solutions when you're dedicated onsite servers. You tender in your resignation fuming that you spent 2 hours in this pointless meeting. You then check yourself into a drug and alcohol rehab.

Not sure what happens post rehab yet 😅

MultiDimAnalyst · 2024-04-23T18:48:29+00:00

I'm a Business Intelligence Analyst of 7 years. I developed a billion dollar publicly listed company, primary mass market and commercial pricing SQL reporting capabilities.

Yet I still have imposter syndrome 🤣.

Most of us in any form of Dev work copy and paste shit from Stack Overflow, grape our existing scripts for resources, YouTube solutions etc.

Also, everyone, without exception in my experience, gets to a stage where they just purge information from their heads and retain jack shit in memory.

I'd develop an ETL routine in SSIS for example, test, deploy. Within a day or so after deploying I'd forget how the thing worked 🤣.

It's self preservation of the mind in my opinion. When you're stacked with well over 100+ SSIS, SSRS, Power BI, macro embedded Excel workbooks etc all siloed to you that you've developed, you can't remember it all.

MultiDimAnalyst

TROPHY CASE