Tuesday, May 13, 2014

Data Analyst Skills Set

1.  SQL, Database
Oracle PL/SQL Development Experience with Strong ETL experience.
Good understanding of Relational Database concepts.
Experienced with writing stored procedures, functions and triggers.
Experience working with TOAD/SQL Developer.

2. Excel, VBA
Exceptionally strong Excel skills (Microsoft certified preferred)
Able to decipher, interpret, troubleshoot, and edit complex Excel formulas including (but certainly not limited to):
VLOOKUPs
OFFSET references
Nested IF Statements

Advanced Excel macro development including:
Writing VBA code specifically for Excel and the functions associated with the program
Troubleshooting and resolving bugs in existing VBA code
Experience with editing MS Office Ribbons using XML

No comments:

Post a Comment