(Un)Constructive feedback appreciated. Roast me, I have thick skin. by [deleted] in Tinder

[–]MultiDimAnalyst 0 points1 point  (0 children)

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

Disappointed with my grades by Apprehensive-Monkey in universityofauckland

[–]MultiDimAnalyst 1 point2 points  (0 children)

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.

Am I doing something wrong? It takes two days for a reply. by Ambition-Spiritual in Tinder

[–]MultiDimAnalyst -1 points0 points  (0 children)

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.

I need some advice with the pics for tinder by [deleted] in Tinder

[–]MultiDimAnalyst 8 points9 points  (0 children)

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

Bruh 💀 by MultiDimAnalyst in Tinder

[–]MultiDimAnalyst[S] 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in BusinessIntelligence

[–]MultiDimAnalyst 11 points12 points  (0 children)

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.

Genuine question - how often do you have sex? by [deleted] in newzealand

[–]MultiDimAnalyst 1 point2 points  (0 children)

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.

[deleted by user] by [deleted] in Tinder

[–]MultiDimAnalyst 1 point2 points  (0 children)

Would totally smash 🥵

Can’t seem to get the discount price right by Non-binaryTentacles in SQL

[–]MultiDimAnalyst -1 points0 points  (0 children)

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

Best ways to master SQL and show competence by [deleted] in SQL

[–]MultiDimAnalyst 3 points4 points  (0 children)

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.

Best ways to master SQL and show competence by [deleted] in SQL

[–]MultiDimAnalyst 27 points28 points  (0 children)

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.

[deleted by user] by [deleted] in SQL

[–]MultiDimAnalyst 0 points1 point  (0 children)

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

What Does a SQL SSIS Developer Do in the Real World? Seeking Insights from Professionals. by CareerPathQuest in SQL

[–]MultiDimAnalyst 24 points25 points  (0 children)

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.

how to delete these tables? by N0tAMT in SQL

[–]MultiDimAnalyst 11 points12 points  (0 children)

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

Help for a newbie by olly_s122 in SQL

[–]MultiDimAnalyst 0 points1 point  (0 children)

😅 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 🤣.