Business Intelligence: Data Analysis and Reporting Techniques
Length:
Type:
Available Dates
Course Details
- Introduction
- Objective
- Who should attend
This program will introduce Business Intelligence (BI), hands-on, to allow you to clean, normalize, and interpret large volumes of data. You will be able to establish historical relationships, analyse the current situation and predict future strategies.
The application of BI is borderless, covering operational, tactical, and strategic business decisions. It spans all departments and cascades down to all users who perform data cleansing, reporting, analysis, modelling, integration, and automation.
In this course we use MS Excel exclusively as an ultimate and readily available BI tool allowing you to develop an exclusive level of expertise and add immediate value to your job and company.
Course Outline
Data analysis tools and techniques
- Consolidating data from separate files and sheets
- Advanced data validation using lists, dates and custom validation
- Powerful array functions
- Cell management tools: left, right, mid, concatenate, value
- Naming, editing, and managing cells and ranges
- Subtotal, sumif, sumifs, sumproduct, count, countif, countifs
- Looking-up data, texts, and values using vlookup
- The incredible table-tools technique
- Slicing dates into day names, weeks, week numbers, month names, years and quarters
- Text-to-columns and dynamic trimming using trim and len
- Managing texts and numbers using replace, find, and substitute
- Text change functions
Course Video
