Skip to main content
2 answers
2
Updated 121 views Translate

What is the day to day like?

Hello I am studying to be a business intelligence analysis.

+25 Karma if successful
From: You
To: Friend
Subject: Career question for you

2

2 answers


5
Updated Translate

Eldon’s Answer

You'll likely have a few meetings to either discuss requirements for new work that you'll be doing or get feedback on work you've recently completed. The rest of your day will likely be spent actually doing the work, manipulating and analyzing data.

Depending on your role, your work will require you to learn about new datasets, understand how data relates to the business, and communicate insights through reports, dashboards, and analysis. The tools you'll likely use are SQL, a Business Intelligence (BI) tool (e.g. Power BI, Tableau), and perhaps a scripting language like R or Python for more advanced analytics.

The most successful BI analysts have a good command of the technical tools required to manipulate, analyze, and present data as well as a curiosity about the business. You should view yourself as a partner with your business counterparts, not just someone who receives tickets to build reports or dashboards.
5
0
Updated Translate

Pamela’s Answer

Hi there, your goal would be to provide insights to your company based upon analyzing vast amounts of data.

Your typical day might start out by reading your emails and reading your company Slack posts or messenger posts. You will likely get small requests for analytics help this way. Your manager will likely assign projects for you to work on and provide you with other contacts that will support you. So you might have a meeting or two (in-person or virtual) to get acquainted and better understand the goals of your projects.

From there, you may do some work to get access to large data sets, getting them exported into a spreadsheet for analysis using pivot tables and charts within Excel or Google Sheets spreadsheet applications. Or you may get trained on how to use Google Analytics, or my personal favorite, Tableau analytics. Tableau is owned by Salesforce and I believe it to be the best analytical tool to help you visualize trends in your data and better determine hypotheses or key insights about your company to share and educate others.

You will likely spend a great deal of your time studying data, identifying outliers, creating charts from the data, checking things for accuracy, and then exploring trends in the data set. You might also see anomalies in your data (ie a big spike during one month) and then schedule some calls to ask various experts what might have happened during that time. Much of this work will culminate in you sharing your insights and learnings with your manager and/or key decision makers that will make use of the data. They may ask you to dive deeper into the data or add additional data perspectives to learn more.

Good luck!
Pam
0