A bit of a background I have a bachelors of science in stats/psychology. Although I got it around the end of 2022 and had to go back to my parents country due to an emergency to look after. Im currently back and ready to job search. Few questions I'm wondering is if having my degree a while ago will hurt me. How much will I be tested on my stats knowledge.

Secondly, how should I go about learning and getting a job? I'd assume SQL, Excel and Power Bi. I'm told creating a personal project is important. Are there any resources on learning about the role itself and databases or will I be taught these things on the job? Any guidance on how I can be knowledgeable and best set myself up when getting a job will be helpful.

Basically the title is the question. I want to learn all 3 tools and I hope having these skills is enough to spart a career, but I want to really learn everything deeply, and a bit worrying to learn everything but so so. Probably I should everyday learn different things or even every week?

Hi guys! I just have started to learn Analytics and want to build really strong career. I’m thinking between Marketing and business analytics, or probably even intelligence, but definitely want to move in that direction.

I have strong inner motivation, mathematical skills, right mindset and bought a laptop, but I think it’s gonna be much more effective when I have a mentor as a person who knows much more that me and can bring value into my experience.

If we talking about free mentorship, then I would try my best to bring value to the mentor as well. Probably you create a courses or want to become professional mentor, in that case I, based on my experience as a math tutor and course maker, would give you my opinion and suggestions

Feel free to dm me and have a nice day

I have an Excel test coming up for a Pricing Analyst role i''m interviewing for. Just wanted to ask, is there any type of questions i should be prepared for and what can be expected ? Additionally, if any one is aware of the format that these type of test usually come in, specifically for Pricing Analyst or any role that relates to it that help me prepare for the test.

The pricing analyst role is in the express logistics industry.

Thank you in advance !

I have done my B.Sc. in maths and then MBA (not a top tier college) and have been working as a senior analyst at a reputed company, having work ex of 6 years. I never wanted to go to very technical skills like python, AL/ML as I am not an engineer and coding is not my passion. Currently working on tools like data visualisation and some etl (alteryx, basic sql). I would like to be in a management position because I feel that I am good at guiding people and stakeholder management. Shall I do some job granted course on UpGrad on product management, or learn the hard coding part to reach up the ladder? Any help is appreciated!

Hi guys,

I'm in the process of building out a data journalism project (non-profit; sharing insights into the sustainable finance sector from a carefully curated group of datasets). On the backend, I'm using self-hosted Metabase (which I really like). On the frontend, there's a blog.

I set up a PostgreSQL database because it's what Metabase preferes, but have been tempted to provision something more primed for data analytics and which could easily scale if the project does.

The downside I'm trying to hedge against is usability. With PostgreSQL there are a bunch of database GUIs that I can both use myself and offer to collaborators as a friendlier place to work with data (thinking about tools like PopSQL, for example).

Some names that have come up include Clickhouse and Snowflake. I'm willing to use just about anything but would prefer something that has a strong focus on usability and collaboration - as those are the features that would probably make the biggest difference.

If you can recommend a specific DBMS, please let me know!

Background. I have 2 yoe in SQL and excel. My company is paying for these certifications such as or Google DA course , Data Warehousing for Business Intelligence, IBM AI Engineering Professional Certificate

Does anyone have any experience with this cert/ certs in general?

I don't expect it to land me a job, but if it catches the HR's eye and lands me a phone interview, then that would probably be enough to justify its worth.

Any advice for someone who makes PowerBI reports and they just look.. ugly aesthetically? I find myself overcrowding pages and it just doesn't look seamless.

I'm not concerned with the content of the graphs, visuals, etc. but I just don't have a good eye for design and what looks good. I think my reports just look clunky!! Any advice? YouTube videos to watch?

So I've been trying to secure a job since graduating college last year and nothing has come through. I essentially support myself and my funds are almost out even after selling a lot of what I have. Looking to get into freelancing as I sorta saw I could earn something through it. I applied to few freelance roles but they either seemed like scams or they were primarily for software engineering, something I barely have any skill in. Really need the opportunity to make whatever small money that I can ASAP so I can continue to support the necessary needs until an actual job comes in. My skill set is listed below and I have projects for reference. Most of my experience lies with Python and SQL.

• Applications: Amazon Web Services(AWS), Outlook, Excel, Visio, Access, Tableau, Jupyter Notebook, SAP ERP, Colab
• SQL: Queries, Database Design, Triggers, Stored Procedures, Transactions, Locks, Indexes, Window Functions, CTE
• Python: Rest APIs, Testing, Machine Learning, Object Oriented Programming, Visualization, Statistics, Analytics, ETL
• Java: Object Oriented Programming, Graphical User Interface creation & design w/ JavaFX, File IO

I see quite a few posts about people thinking if switching careers to analytics. For those of you who have taken the leap, do you feel it was the right decision? Why or why not?

Virtually every DA job I’ve been applying to has more MS applicants than BS. Is this the new norm?

Hey everyone check out our weekly SQL question. Give it a try!

Uber, is conducting an analysis of its driver performance across various cities.

Your task is to develop a SQL query to identify the top-performing drivers based on their average rating.

Only drivers who have completed at least 5 trips should be considered for this analysis. .

The query should provide the driver's name, city, and their average rating, sorted in descending order of average rating

Note: Round the average rating to 2 decimal points.

Drivers:

Trips:

You can try solving it for free (Link in comments :) )

Hey everyone!
I'm making this post because I'm finding it really challenging to find some direction into the analytics, so I was hoping someone could help me out!
I'm an Undergrad student who's 1 year into their program, and I recently learnt the basics of Power Bi. Since I loved working on the program, I'd like to delve further into the field.
Although since I'm super inclined towards getting a specialization degree after my undergrad program ends (since my ug has only plans to provide basic knowledge about a variety of topics) I sorta had the realization I have 0 experience and my resume is basically empty.
I'm really curious on what sort of internships I should look for, or what additional courses I should look for to up my skills to get an internship in the first place in order to get into specialization programs?

I have 10 different workbooks. Esch containing anywhere from 5-15 columns.

Names of these columns differ, but many of them are used for the same purpose (for example, email address from one workbook is the equivalent of customer contact in another).

Since there isn’t a lot of data, I could manually compare each field and try to figure out what equals what.

But what if the data was humongous? What tool(s) would be best for this?

Hi there! I have been looking for jobs since last few months and was lucky enough to get to the panel rounds with 3 different companies and after going through tech and behavioral rounds. I failed all three! I was in shock! I asked the recruiter if they had any feedback and it seemed like my answers lacked structure. Can someone tell me what is the structure they are looking for?! I know about using the STAR method and have used it but it’s something I am really lacking! What do you suggest on explaining my work experience or relevant stories if they ask Tell me a time when..kinda questions? Sometimes they had gone really deep into it and I think I might have digressed a little being nervous :( Have you all practiced with people before the interviews? Any feedback would be appreciated!

Hi, I was wondering if anyone could help me with a problem that I have, I've been stuck on this issue for too long and can't work it out!

I need to show the calculation of the revenue impact of increasing the repeat rate by 1ppt (the revenue has three main sources). I was trying to do a "what if" in excel, however I can't figure out how to connect the variables! Any help on this would be greatly Appreciated!

FYI this is for a meta company

Just curious which data visualization tool is more frequently used. I would have assumed it was Tableau a few years ago but seems like Power BI is getting more popular.

Also the potential of companies being in bed with Microsoft subscriptions, so being in the Azure & Microsoft Office ecosystem.

I'm defining analytics as a centralized team that creates reporting, analytics, and Data Viz (ie Power BI etc) and data architects/engineers. Realizing that some groups have their own analysts-not counting those unless the org is totally decentralized.

For example my team is 20 employees, the total org is 4000, so 0.5%.

Lots of variables and intangibles here I know. Just trying to get a relative sense, thanks!

Just started reading the Art of Statistics and it reminded me of the days when I'd read a lot of books on general forensic analysis. Just wondering if there's any particular books that have stuck with anyone bridging the gap of big data and forensic analysis in solving crimes.

It doesn't have to be very technical, mostly looking for a good read of in-depth situations of using data to solve crimes. Anyone have anything to scratch that itch?

Thanks!

Can anyone share the structure of how the data team fits into your organization whether they allow self service or take full ownership of reports and dashboards.

For example I believe all request and data that shareholders might see should come through the data team.

We use Power Bi but now have some people who want to play around with the data. I don't mind people looking to build visuals for themselves but do take issue when they share measures/columns they built themselves without the data team knowing.

What do other organizations do with people who want to find insights themselves. Is there another tool where the data team might have full control over it?

A few years ago myself and a friend built a 'Wordle assist' website. (Yes, a way to 'cheat' at Wordle, but it was more of a compsci + data structures recreational exercise for me and my friend.)

We basically deployed and forgot about the site, but it averages 350+ users per month, and i've logged all the inputs. Would anyone want to do analytics on this?

Some clarifications:

• For any 'assist', my page doesn't know the actual answer, it returns the remaining valid words based on the inputs (previous gueses, correct letters, letters but wrong place)
• The format below:
  • 1r, " the letter 'r' was incorrectly guessed at index 1, but the letter belongs at a different index"
  • "-er-y", the placement of correct letters e r and y, with two letters still unknown
  • "d,b,u", a list of letters guessed but not in the wordle
• Below is some example output, these are four consecutive 'assists', clearly the same user (that would have to be part of the analytics I think, "clumping" the user 'sessions')

2024-05-09T09:47:18.176-04:00

1r,2e,3r,3e,4r,4e

-er-y

d,b,u,q,m,i,t,s,l,w,o,h,n,a,c

2024-05-09T09:47:05.597-04:00

1r,2e,3r,3e,4r,4e

----y

u,q,m,i,t,s,l,w,o,h,n,a,c

2024-05-09T09:46:57.918-04:00

1r,2e,3r,3e,4r,4e

----y

m,i,t,s,l,w,o,h,n,a,c

2024-05-09T09:46:41.624-04:00

1r,3e,4r,4e

-----

m,i,t,s,l,w,o,h,n,a,c

I received a data analyst/BI analyst offer from 1 company and another still waiting for decision after final interview. For context I'm a data analyst with almost 4 years of experience. I don't know what's best for me because both has pros and cons. Both have similar pay, value work life balance. and are hybrid.

• Company 1 (sent offer): building a new analytics team, no one else with data engineer/analytics background present in the company. And executives and company as a whole seems pretty unknowledgeable of good data practices and tech. I'm worried that the workload is all on me and won't have another analyst to make decisions with/have a mentor. That's just how my current job is and I was looking forward to change. Pros: great benefits, shorter commute.
• Company 2 (waiting final decision): executives of this company are very knowledgeable of analytics and how valuable it is. I'll have a manager that's been working there for a long time, cleaning and maintaining the data so it's not as messy. The data is more interesting which I'd enjoy and I'll have a mentor. Cons: further commute, benefits just OK.

If anyone with more experience have any advice for me it'd be appreciated.

Do you know of any apps that can track your exercise, which also allows you to download your data and analyse it?

Hello guys and girls :)

My name is Augustin, and I'm currently studying and researching how data professionals, like you, can maximize the impact of data platforms.

I'm working on a concept which aims to create a data platform for marketing use, for an eSport team. The goal would be to provide a platform that simplifies complex data sets and transforms them into actionable insights.

I'd love to hear your thoughts on the following questions:

1. What are the biggest challenges you currently face with data platforms?

2. What features do you find most useful in existing platforms, and what do you wish they could improve?

3. How important are predictive analytics for your work, and what predictive features do you find valuable?

Your input will directly contribute to refining my research and I'd greatly appreciate your insights! If you have any questions about it, feel free to ask, I will gladly answer!

Thanks a lot for your time :)

Augustin

Hi there! I've launched my MVP, a mobile app. I'm having some issues, though, in properly and effectively tracking user data. I'm fairly new to this aspect, so forgive me if I ask basic questions. Still learning!

I have a clear picture in mind of the acquisition and conversion funnel; I've tried using GA4, MixPanel, Firebase, and of course Google Play Console and App Store Connect, but there's always something slipping through the cracks or some missing data.

In general, my data sources are:

• Social media (Meta+TikTok)
• Email marketing (MailChimp)
• Mobile app behavior (iOS+Android)
• Website

Any advice? Do you know any guide, course, or tutorial?
Thanks a lot!

Tips, tricks, tools, systems, curious to hear all of them!

Issues I’m currently dealing with below, feel free to ignore!

I’ve been in my first analyst job for about it 6 months now (brand new to the field, I was an arts major). At a recent review, I was told I was doing outstanding work and exceeding all expectations.

But the past few weeks have suddenly been hell! Data source issues, pie-in-the-sky stakeholder demands, and very short expected turn-around times. I am face-planting!

I’m just not very efficient at my job yet, even though I’ve been here for over 6 months. While I’m confident about using my tools in general, I take a little longer than I’d like for blockers, and when they pile up with tight deadlines, I’m nervous it seems like I need too much hand-holding.

So anyways, if you’ve found anything that has improved your efficiency since you first started, I’d love to hear it!

Anyone who has worked with/currently using contentsquare for analytics? Any tips? How good of a tool is it for the long run?

I have setup a new board for all analysts from India Feel free to join

https://www.reddit.com/r/analyticsindia/s/JBdOOaVbdf

I graduated last may with a degree in Financial Planning and a minor in Business. I have been working in a Financial Planning role for the past 7 months and have not really enjoyed it. The only parts I enjoyed were was when I was given numerical data to work with.

I have always been more of a numbers person than a people person, and have been thinking of going into a more analytical career. I have been applying for Financial Analyst and other analyst roles for the past 8-9 months or so with no luck. I was wondering if getting a masters in Data or Business Analytics would help me get more noticed. I enjoyed the statistic courses I had to take more my Major and even enjoyed Calculus 1 & 2 that I had to take for a previous major that I changed during university.

I am struggling to figure out if this is the right career choice to do or to stay in a field that I do not enjoy being in.

I have a mobile application for iPhone and Android.

The question is: why do I need Firebase and Google Analytics?
Why does everyone talk about them and install them for analytics?

• I view data for Android in Google Play Console.
• I view data for iOS in App Store Connect
• I track product metrics (events) in Amplitude
• I want to integrate Appsflyer to track advertising sources (attribution).

Isn't it enough that I'm already tracking these?