IT, ICT and Computing courses

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 courses

DIGITAL SOUNDS COURSE (12-18 years) Want to make music on your computer? These weekly sessions will equip you with the skills and the know-how for you to create and produce your own pieces of music. We will cover recording, sequencing, sampling and...it, ict and computing courses

Improve your music creation, mixing and production skills. Create and produce our own piece of music and gain an insight in mixing techniques in a recording studio environment using Logic Pro and Garageband and Reason. This course will equip you with...it, ict and computing courses

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 courses

The successful delivery of a data warehouse or business intelligence project requires a combination of strong project management skills and a good understanding of the unique challenges of data warehouse projects. This course is designed to equip delegates with the necessary...it, ict and computing courses

The data warehouse continues to be one of the most organisationally complex and technically interesting projects in Information Technology. We believe the market today requires professionals to be multi talented and strategically positioned for the growth in data warehousing and dimensional...it, ict and computing courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses

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 courses