Recent Group Posts

RSS Feed

Group Admins

  • Profile picture of Data Analyst Training

Career Coaching

Public Group active 1 month, 2 weeks ago ago

Career Coaching on How To Become A Business Analyst and How To Learn Business Analysis

Data Analyst Career Path for Data Entry, Management Queries, Reporting in Non Profit Sector (2 posts)

← Group Forum   Group Forum Directory
  • Profile picture of daniellepekalski daniellepekalski said 8 months, 2 weeks ago ago:

    I’ve been working with the donor database The Raiser’s Edge for the past four years.

    I do data entry, management, queries, some exports and reports.

    I’m pretty tech savvy, I find myself being the accidental techie in several of my endeavors, so I wonder if this is a possible career path.

    I’m apprehensive though because while I know that there are similar positions in the for-profit sector, I don’t know how to make the jump.

    I’d appreciate any tips you may have.

  • Profile picture of Data Analyst Training Data Analyst Training said 8 months, 2 weeks ago ago:

    #1: there are definitely similar jobs in the for-profit sector where you get to do data entry, work with management reports, write queries or export data / reports.

    #2: Before you work on the transition to a for-profit data analyst job, improve your skills until it becomes like that of a highly skilled / expert data analyst professional.

    Reporting Skills
    Take one or two reporting tools that are widely used in the for-profit sector and learn everything about the tool(s) until you will consider yourself an expert.

    Focus on one of these reporting tools (Crystal Reports, Microsoft Sql Server Reporting Services or Microsoft Access Reporting)

    SQL Queries:
    Become highly skilled or expert at writing complex SQL statements.

    Learn the ins and outs of writing inner joins, outer joins, subqueries, stored procedures, etc.

    Learn how to write highly optimized sql queries that take advantage of primary keys and indices.

    Learn how to spot data inconsistencies and data redundancies and then normalize the data in your tables to third (3rd.) normal form.

    Learn how to add foreign keys to tables and create one to one, one to many and many to many relationships.

    Make it your one and only job to become the most competent data analyst you can be … if you do that, you will be qualified and ready to make the transition from a non-profit to a for-profit data analyst job …