Wise courses

...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...

...the lecturer will develop an understanding of how to use the statistics, analytic and OLAP features in a BI environment. The main features of this presentation are examples...

...How to plan and implement a data warehouse with high availability, simplified manageability and optimal performance What are common statistics...

...This SQL Server 2008 New DW/BI Features presentation covers the technical and non-technical details as these relate to: Data warehousing...

...As about 80% of this presentation is ETL based, upon its completion, the delegate should be able to think clearly with regards the available SSIS options...

...ETL solutions. Suitable for: SQL Server 2005/2008 developers in particular and DBAs in general. SQL Server 2005/2008 developers in particular and DBAs in general...

...Runtime engine Data Flow engine Execution trees Parallelism Source and destination adapters Advanced transformations (synchronous vs. asynchronous)...

...intelligence and data warehousing architects.Prerequisites:Completion of our courseSummary:This presentation uses business cases to illustrate how to design...

...DBAs and SQL Server 2005 administrators. Level: Executive Audience: Data architects, business intelligence/data warehouse specialists, DBAs and SQL Server 2005 administrators...

...performance techniques Etc. Suitable for: Data architects, business intelligence/data warehouse specialists, DBAs and SQL Server administrators. Data architects...

...Report Designer and Report Builder Create different types of reports, such as tables, matrices and charts Add expressions to reports Add parameters...

...Data mart design and load Business Intelligence Development Studio (BIDS) SQL Server Management Studio Building dimension tables Building fact tables Developing...

...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...

...Upon completion of this course, the participant should understand Oracle DB and application tuning options and how they may be used to optimise data warehousing performance...

...Database administrators and system administrators. Database administrators and system administrators. After discussing the components of the data warehouse and data warehousing...

...DW administrators, DBAs, data architects, DW PL/SQL developers. Prerequisites: Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge...

...the participant should be able to design a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes...

...how to optimise data warehouse design in both non-partitioned and partitioned environments. Topics central to this presentation include:...

...databases in general. Additionally, the course participant should be qualified to select and tune queries to exploit the MDC and MQT implementations. Audience...

...Suitable for: Developers and DBAs. Developers and DBAs. Audience: Developers and DBAs. Prerequisites: At least six (6) months SQL Server application developer experience...