IT, ICT and Computing In a classroom

Microsoft Excel is a very comprehensive spreadsheet software package that can be used to maintain business accounts, contact databases and many other features. Training starts at basic data input, data formatting and simple maths, progressing to data analysis and manipulation. ...it, ict and computing training

What is Financial Modelling Basic Financial Statements Income Statement Balance Sheet Cash Flow Statement Compounding Capitalization Importing Data Converting Files from Other Applications Copying Data from another Application Importing Data from External Sources Using Microsoft Query Adding a Data Source Creating a Query Named Ranges Navigating Workbooks using cells or Range names Creating named Ranges based on Cell...it, ict and computing training

This DW terminologies and concepts course addresses the following topics: What is data warehousing? What is a data mart? What are the data modelling options? What are the terms and concepts specific to data warehousing and OLAP design? What are common statistics, analytic and OLAP SQL...it, ict and computing training

This dimensional modelling techniques course is designed to answer questions, such as the following: What is data warehousing? What is a data mart? What are the data modelling options? What is Extract, Transform and Load (ETL)? What are the terms and concepts specific to data warehousing...it, ict and computing training

After presenting entity relationship (ER) and dimensional modelling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very large data warehouse. Using real-world business scenarios, SALES, for example, the instructor will...it, ict and computing training

After reviewing Business Intelligence (BI) terms and concepts, including dimensional modelling, data warehousing (DW), data marts, OLTP vs. OLAP, this hands-on course focuses on the more useful and challenging features of SSIS as they relate to BI/DW solutions in general and...it, ict and computing training

As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and...it, ict and computing training

Designed mainly for SQL Server DBAs (and SSIS developers whose job description spans both SSIS developer and DBA tasks), this scenario-oriented presentation concentrates on the more esoteric features of SSIS: Deployment internals Runtime engine Data Flow engine Execution trees Parallelism Source and destination adapters Advanced transformations (synchronous vs....it, ict and computing training

This scenario-based presentation details how to use the Business Intelligence Development Studio (BIDS) to develop and deploy Analysis Services projects and to use the SQL Server Management Studio to manage the databases derived from these projects. it, ict and computing training

This course emphasises improving the quality of the end-user experience by equipping the technical support team (developers, DBAs, etc.) with the requisite SSAS skills to design, implement, monitor and tune: Dimension attributes Analysis Services query (MDX) performance Processing performance Aggregations performance Indexes Partitioning Etc. it, ict and computing training

This course is designed for OLAP (cube) developers and administrators and SQL Server Reporting Services (SSRS) developers. Emphasis is placed on using MDX queries and scripts to: Return data to client applications from OLAP cubes Format query results Perform cube design tasks, such as...it, ict and computing training

This presentation begins by introducing the tools, techniques and concepts required to exploit SQL Server’s data mining facilities. Then it progresses to include some of the more detailed topics, such as: Data mining projects Use of BIDS and SSMS in the project development...it, ict and computing training

This scenario-based presentation details how to use SQL Server 2008 Reporting Services (SSRS) to design a robust reporting solution to support a BI solution. it, ict and computing training

This scenario-based presentation details how to use SQL Server 2005 Reporting Services (SSRS) to design a robust reporting solution to support a BI solution. it, ict and computing training

Please note this is a 3.5 day course. Assuming a working knowledge of the above 'Prerequisites', the delegate should be prepared to delve into some of the more esoteric and advanced SSRS features to support a wide variety of reporting scenarios, including: Harnessing...it, ict and computing training

This hands-on course is aimed at business intelligence power users and end users who want to develop reports with report models built by administrators. The course details how to use SQL Server 2008 Reporting Services' Report Builder 1.0 and 2.0 tools...it, ict and computing training

This hands-on course is aimed at business intelligence power users and end users who want to develop reports with report models built by administrators. The course details how to use SQL Server 2005 Reporting Services' Report Builder tool to design and...it, ict and computing training

After reviewing Dimensional Modelling fundamentals, this course focuses on tuning the Oracle DB engine and DW application interfaces with especial emphasis on: Star schema design Indexes Materialized views Partitioning DB parameters it, ict and computing training

This course focuses on the extract, transform and load (ETL) phase of the data warehouse (DW) development life cycle. After discussing ETL as it relates to all DBMSs (DB2, MS SQL Server, Sybase, etc.) we elaborate on Oracle's ETL offering: Change Data...it, ict and computing training

This presentation and hands-on workshop emphasises how to optimise data warehouse design in both non-partitioned and partitioned environments. Topics central to this presentation include: Giga- and Tera-byte table considerations Partitioning and parallelism I/O design High performance DB/DBM configuration parameters How to exploit the DB2 optimizer Materialized Views/Materialized Query...it, ict and computing training