ABOUT THIS COURSE
This training gives an Introduction to ETL and SSIS. You learn using MDX and Calculations and Object synchronization / Object Filters
The IFS EOI Consultants who is a mid to senior level and responsible for mapping and translating the business needs into EOI data requirements. This IFS EOI BI Modeler is designing Business cubes and assures the periodic update of data in the business cubes (setting up the data engine in congruence with the model engine and its connections to the source systems).
Together with the appropriate customer/end-user, the IFS EOI BI Modeler will analyze available data in source systems and evaluate the most efficient upload procedures. To be more specific, with help of MS SQL Integration Services and MS SQL Analysis Services, an automated, semi-automated or manual upload procedures based on ETL (Extraction, Transform and Load) procedures will be developed and maintained by the IFS EOI BI Modeler.
Also advanced reports based on the Business Model content or based on data from underlying sources can be created. Finally, the BI Modeler is able to create query reports, SSAS Excel reports and reports created by the MS-SQL Reporting Services functionality.
- Data Integration 1
- Data Integration 2
- Data Integration 3 & Reporting
At the end of this course, the participants are able to:
- Create the Performance Framework Architecture
- To model the EOI Data warehouse
- To understand ETL and SSIS
- To connect Data to the IFS EOI platform
- To create query reports, SSAS Excel reports and reports created by the MS-SQL Reporting Services functionality
Knowledge: Basic knowledge of the EOI platform and EOI engines. Basic knowledge in Microsoft SQL Server Analytic Services (MS SSAS) and Microsoft SQL Server Reporting Services (MS SSRS)
Courses: Business Modelling 1
Exams: Associate level IFS EOI Fundamentals.
IFS Academy Inquiry Text
- IFS Enterprise Operational Intelligence