Blog Post

Educator Developer Blog
2 MIN READ

A Day in the Life of a Data Analyst - Interview with Industry Experts

theoyinbooke's avatar
theoyinbooke
Icon for Microsoft rankMicrosoft
Jun 17, 2022

 

Questions on Your Mind

Your Curiosity led you here and that is a good sign that you have the spirit of the data benders and ninjas. Lol

 

Life as a Data Analyst is not always full of writing codes and building dashboards and reports. in this session, our guests itemized the following as additional skill you need to master

  • Stakeholders Management: How to do engage with immediate team members to get support or resources needed to get your work done? How best should you make request from managers on your project? How do I set the right expectations for the stakeholders and how to manage such expectation? etc.  
  • Communication and Presentation Skill: Dashboards and Reports are not useful on their own, how do you get to communicate your findings and recommendation to the stakeholders? Having a good communication and presentation skill is of great advantage to Data Analyst
  • Curiosity: Curiosity for a Data Analyst can't kill you, it will make you better. If you are not curious, you can't get the best from any data project and you will fail to meet the expectations of the stakeholders with many questions left unanswered.
  • Ownership Mindset: Most of the time, a data analyst is an experienced Individual Contributor. In Many firms in Africa, you are responsible for sourcing and cleaning data, analyzing data, reporting, implementing and monitoring the recommendation.  You will need to have ownership mentality to take up a task and do all you have to do ethically to get the work done.
  • Domain Knowledge: Having an industry knowledge is yet another advantage for every data analyst. what if you are still a student or without work experience? the best approach to this is to research on the KPIs and metrics common to the industry of your interest, learn more about them and that will help you get familiar with how they perceive and measure value. This actually differ from one industry to the other.
  • Business Value: Data Analysis is not about the tool, it is about Business value. always bear this in mind as you apply both your soft and technical skills on projects. Ask yourself questions like - What value is in this project? Is it the same thing the stakeholders are expecting from it? Don't work on a beautiful nonsense projects. Beautiful because it looks so good, Nonsense because it didn't end up meeting the business needs
  • and many more.

 

Watch the Session

 

 

 

Assignment

  1. Complete your COVID19 Dashboard Using Excel here: https://aka.ms/30DLDATDay3 
  2. Share your portfolio online using hashtag #30DaysOfLearning

 

Additional Resources

 

 

Updated Jun 26, 2022
Version 2.0
  • Alaribe_Daniel's avatar
    Alaribe_Daniel
    Copper Contributor

    Hi, am grateful for the teaches am receiving is so amazing thank you. I have a little challenge though. When I signed up for office 365 I notice that in the excel app, I didn't see the get and transform data option in the ribbon tab. Can anyone help me out. Thanks

  • Shunlexxi's avatar
    Shunlexxi
    Brass Contributor

    Alaribe_Daniel 

    I ran into this problem also; couldn't find "import from web" on Excel (web).

    First, Microsoft 365 (which include Office 365 Apps; Word, Excel, Powerpoint...) can be categorized into;

    Microsoft/Office Desktop (the one you install on your PC)
    Microsoft/Office Web App/Services (when you use it via your browser)

    Is the above clear? as it will help you continue.

    There are some features that aren't available yet on the web version (Microsoft/Office services/Web App), meaning you can only access them when you download and install Microsoft packages (say Excel) on your PC, unfortunately, the "import from web" is one of them.

    [if you noticed @theoyinbooke used Excel Desktop to scrape the COVID 19 data in the walkthrough, though he didn't explicitly mention it (you may go back to the video to be sure]. Also, let me mention that you need to be connected to the internet (Just in case)

    You may checkout Microsoft documentation to figure out the differences between the WEB (version) of EXCEL and the DESKTOP (version) here;

    https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-i...

    https://support.microsoft.com/en-us/office/data-import-and-analysis-options-3ea52160-08bc-45ac-acd9-...

    Also, checkout my blog! I hope this helps!

  • Shunlexxi's avatar
    Shunlexxi
    Brass Contributor

    theoyinbooke, Good Afternoon, Sir

    I'm done with my COVID 19 REPORT but when trying to document and upload it on GitHub, it was rejected as the file was complained to be too large (40MB)

     

    I'm planning to upload it on the cloud and add a link to it in the documentation. 

     

    Is that okay? Or any better walk-around?