Community developer events
Business Intelligence with SQL Server 2005
- Date
- 12-16 Nov 2007 (Add to calendar) GMT
- Venue
- JB International , London, GB
- Cost
- £1995+vat
Introduction - SSAS
Database Design
Review of third normal form and traditional OLTP databases
Introduction to designing OLAP star and snowflake schemas
Introduction to designing cubes
Analysis Services (using Business Intelligence Development Studio - BIDS)
Building fact tables
Building dimensions
Building cubes
Pivot Tables and Matrices
Browsing cubes in BIDS and Management Studio (SSMS)
Browsing cubes in Excel
Browsing cubes in Web Pages
Cubes in Reporting Services (SSRS)
Maintaining data warehouses
Backup and restoring star schemas
Backup and restoring of cubes
Cube security
Updating cubes
SQL Server Integration Services (SSIS)
Using SSIS Wizards
Using SSIS Designer
Using SSIS to normalise data
Using SSIS to denormalise data
Using SSIS to process cubes
Analysis Services programming
MDX queries and expressions
DMX data mining queries
ASSL and XMLA and AMO
SSIS Programming
SSIS and TSQL (Transact SQL)
SSAS and VB.NET & C#
SSIS and VB.NET
Running and saving SSIS
Scheduling SSIS packages
Running from stored procedures
Saving to SQL Server
Saving to file
Advanced Analysis Services
Data mining
Deployment
Perspectives
Actions
Write-back
Introduction to SQL Server 2005 Reporting Services
Architecture
Reporting Services
Report Server
Report Server databases
Report Designer
Report Manager
Report Models
Report Builder
Designing a simple report
Report wizards
Report Designer
Basic formatting
Using templates
Previewing
Deploying
Working with data
SQL queries
Query Builder
MDX queries
DSV (data source views)
Grouping
Advanced reports
Formatting
Using expressions
Page breaks
Matrices
Headers
Graphics
Interactive reports
Parameters
Drill through
Report Builder
Tables and matrices
Adding clickthrough
Sorting and filtering
Administration
Report Manager
Configuration Manager
Management areas
Managing Report Server
Managing security
Managing subscriptions
Managing Report Models
Managing deployment
Managing access
Map
Other nearby events
-
Feb
26
PHP UK Conference 2010
7km away in London
PHP UK Conference 2010 is PHP London's fifth annual conference.
-
Feb
17
Talk on Flex integration with Spring using BlazeDS at the Adobe RIA meetup on Feb 17th
8km away in London
The talk is on Flex & Spring integration with Spring BlazeDS In this free tech talk at the Adobe RIA user group, Rick Evans will introduce Spring BlazeDS Integration. Spring BlazeDS Integration is a Spring Portfolio project that makes it easier to build Rich Internet Applications for the enterprise using Flex and Spring.
-
Mar
13
Pub Standards 100
8km away in London
Celebrate the 100th Pub Standards!Special Event!Bring your mother!Take a day off work!Put the date in your Filofax NOW!
-
Feb
11
London Geek Nights: Hydras and Hypermedia
8km away in London, United Kingdom
Let Ian Robinson, REST Guru, be your dungeon master! Do you know what your enterprise apps get up to in their time off? Fighting fantasy, pick-your-path, hypermedia-driven, RESTful Web application adventures--of course.
-
Mar
2
London Geek Nights: Agile System Adminstration
8km away in London, United Kingdom
This is part of the Agile Sysadmin events. Agenda TBC but likely to be focussing on how admins should be part of the development team.
Related discussion
-
High-Performance .NET Application Development & Architecture
by Manjot Bawa (0 replies)
-
Update Sql Two Tables, Page Rank Update List
by StevenJ (0 replies)
-
Update Sql Multiple Tables, Windows Update Blank Page Windows Xp
by StevenJ (0 replies)
-
Update Sql Statement. Unable To Update Public Freebusy Data Outlook 2002
by StevenJ (0 replies)
-
Replicate Sql Express - Heuer Replica Tag Watch Womens
by JamesO (0 replies)
Related articles
Related podcasts
-
Stack Overflow: Podcast #28
This is the twenty-eighth episode of the StackOverflow podcast, where Joel and Jeff discuss Windows Azure, SQL Server 2008 full text search, Bayesian filtering, porn detection, and project management — among other things. Jeff met the inestimable Joey DeVilla aka Accordion Guy...
This thread is for discussions of Business Intelligence with SQL Server 2005.