Technical skills

Technologies: Other

Key facts

Depending on the product, a Business Analyst might need to deliver a variety of technical outputs related to data, integration, modeling etc.

Description

Some very basic programming skills and a technical background will be helpful, because a Business Analyst spends a lot of time communicating with technical people . Very often, a Business Analyst has to extract, process and analyze data. However, sometimes the only way to access data is to address the database directly via SQL. So, a BA should have a basic understanding of relational databases, as well as be able to write basic CRUD queries. Spreadsheet (e.g. excel) is the most common way of processing and analyzing data. There are different levels of excel users: formulas, functions, native data analytic tools (advanced filtering, pivot tables / charts, goalseeker etc.), recorded macros and eventually – the custom macros written in VBA. Being able to read, understand and prepare respective documentation is often done by a BA.

Resources

Title	Study Item Level	Description
Joey Blue: Learn SQL in 1 Hour - SQL Basics for Beginners	Qualified	A crash course in SQL. How to write SQL from scratch in 1 hour. In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL.
Technology for Teachers and Students: The Beginner's Guide to Excel - Excel Basics Tutorial	Qualified	Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.
Learnit Training: Excel VBA Beginner Tutorial	Qualified	Excel VBA Beginner Tutorial, where you will learn how to: use relative references, recording simple macros, sort and filter macro recording and much more useful things.
Le Wagon: API for beginners	Qualified	Have you ever wondered how Facebook is able to automatically display your Instagram photos? How about how Evernote syncs notes between your computer and smartphone? If so, then it’s time to get excited! During this 2 hour workshop, we'll walk you through what it takes to link different IT systems together thanks to this common tool called an Application Programming Interface (API). We will start off easy, explaining the basics of (web) APIs: what they are, how they work, and why they matter.
MuleSoft Videos: What is an API	Qualified	What exactly is an API? Finally learn for yourself in this helpful video from MuleSoft, the API experts.
Technology for Teachers and Students: Intermediate Excel Skills, Tips, and Tricks Tutorial	Competent	Learn many of the intermediate skills, tips, and tricks that you'll need in order to be able to use Excel effectively. This is the second of several video tutorials on Excel. Please consider watching my other video: The Beginner's Guide to Excel. In this intermediate video you'll learn some advanced formatting tools such as conditional formatting, how to save time by using the Autofill Handle, the basics of formulas and functions, sorting and filtering, and a few random useful tips such as Freeze Panes.
Learnit Training: Excel 2016 Advanced	Expert	Pass Excel 2016 Advanced Tutorial, during which you will learn how to create named ranges from selection, discover IF Functions, explore Formula Auditing Tools and much more else.

Curriculums

Title	Description
Business Analyst	A Business Analyst at an IT project ensures that the problem and solution are clear to the Team who implements and tests the product.

Views: 1309