Introduction
Enhance your data analysis skills with Microsoft Office Self Service Business Intelligence Tools. Advantages for :- Analyzing data from Point of Sale and Enterprise Resource Planning systems; text and CSV files; Blending data across multiple tables and sources for loading, structuring, and relating data logically to other data in preparation for analysis; Microsoft Business Intelligence tools integrate the key functions of SQL database management, Visual basic coding, and MS Excel formulas & functions into one robust Self-Service Business Intelligence tool;
Objectives
- Microsoft Excel (Introduction to spreadsheets,
- Functions and Formulas,
- Charts and graphics, Reports).
- ETL (Extract Transform Load) & Data Modelling (The Business Intelligence Landscape, Power Query, Data Modelling
- Data Analysis (Power Pivot & DAX, Common DAX Functions)
Requirements
Open
Duration
At least 9 days
Mode of Study
Face-to-face or virtual
