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
4
Securing Web Applications Training Course
6km away in London
The Securing Web Applications training course is a one day hands on event targeted at web developers. The courses is delivered by Sec-1 whos main activity is the assessment of web applications for corporate and government clients.
-
Dec
12
Ruby Manor 2 : Manor Harder
8km away in London
Ruby Manor 2 : Manor Harder The Guvner is opening the doors to The Manor once again, and just like last time it’s up to you to fill my echoing halls with the sound of Ruby. It'll be the same process as last year, so you can just read last year’s announcement again () and skip straight to making a topic suggestion (something you’d like to listen to) or talk proposal (something you’d like to speak about) in a new thread on the mailing list
-
Nov
27
Agile Specifications, Bdd And Testing Exchange
8km away in London
Following the excellent response to our Agile Testing and BDD community events and courses during the last 10 months, Skills Matter is proud to organise the first, annual Agile Specification, BDD and Testing eXchange - an intensive and intimate event aimed at bringing together leading thinkers and passionate community members. The aim of this eXchange is to promote awareness and adoption of modern Agile Testing techniques and ideas.
-
Dec
2
David Laribee's Towards a New Architect workshop
8km away in London
Calling all technical leads, senior developers, coaches & architects: you can nto afford to miss David Laribee's David Laribee's Towards a New Architect 2-day workshop. David's highly-anticipated workshop is a must for anyone wanting to learn actionable techniques and tools for leading your team toward greater throughput and technical excellence.
-
Dec
4
HTML 5 Communication: Using Web Sockets, Server-Sent Events, and more to build real-time Web applications
8km away in London
he HTML 5 Communication Workshop is a highly practical, one-day workshop about HTML 5 Communication for Real-time Web applications, using Web Sockets, Server-Sent Events (SSE), PostMessage, Cross-Document Messaging, and more. Presented by Kaazing consultants, this workshop will teach you how to create next generation real-time Web 2.0 solutions, using HTML 5 Communication, which will work in today's browsers. The afternoon session is hands-on, so bring your laptop!
Related discussion
-
High-Performance .NET Application Development & Architecture
by Manjot Bawa (0 replies)
-
VS.NET/sql server installation problem
by daspeac (4 replies)
-
Research topic in software
by reachsangeethamathew (0 replies)
-
Error Msg Description ?
by morizan (0 replies)
-
How to Change Default exe Icon in C#.net Windows Application
by sonali.terse (2 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.