Community developer events

Business Intelligence Evening with Mitchell and Webb

Date
Thu, 15 Jan 2009, 17:30 - 21:00 (Add to calendar) GMT
Venue
Microsoft Ltd , Reading, GB
Cost
Free

Join us for another UK SQL Server User Group meeting.

5.30pm – 6:00 Registration and networking + Tea/Coffee with biscuits.

Meet and greet.

6:00pm – 6:30pm Round Table discussion and Nuggets - ALL

Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.

It's also a great opportunity to share your knowledge and gain exposure in the industry by giving a short 1 - 6 minute "nugget" demo/tip.

6.30pm – 7:30 Allan Mitchell, SQL Server MVP;Konesans*

Time Gentlemen Please.

Making predictions over time is a very common use of Data Mining. Whether you want to know what the FX rate of EUR to GBP will look like over the next 3 months or you want to know what skills to train the service desk personnel in based on current support call trends, time series data mining is going to help you a lot.

In this presentation I want to look at what MS is offering in SQL Server 2008 for Time Series Analysis. We will look at the different algorithms available, when to use them and how. We will also have a look at the effects of changing some of the parameters in the Mining model like AUTODETECTPERIODICITY and MISSINGVALUESUBSTITUTION. We will also spend a small amount of time querying the Time series model to get a handle on the possibilities outside of BIDs.

Data Mining is often seen as super complex and off-putting but I am going to try and change that view and make this session fun.

7:30pm – 7:50 BREAK: Light refreshments

More time to network and ask questions...

7:50pm – 9.00pm Chris Webb, SQL Server MVP; Cross Join Consulting

Creating an SSIS, SSAS and SSRS monitoring solution with SSIS, SSAS and SSRS

The Microsoft BI stack is now mainstream, and mission-critical implementations can be found in the largest businesses worldwide. However, the kind of monitoring tools that we take for granted with the relational engine simply don't exist yet for Integration Services, Analysis Services and Reporting Services. How do we know if our Integration Services packages are taking longer and longer to run every day, who's running that big query that's slowing Analysis Services down, or if the boss ever looks at that Reporting Services report you took three weeks to create for him? Luckily the solution is close at hand: we can use SSIS, SSAS and SSRS to build an application for monitoring SSIS, SSAS and SSRS. This session will describe how you can do this.

Comments

Leave a comment

Sign in or Join us (it's free).

AddThis

Map

Other nearby events

  • Nov 26

    VBUG Annual Conference 2009

    0km away in Reading

    This years VBUG Annual Conference will be held in Building 3 of Microsoft, Reading.Topics to be covered will include:Concurrency Using Functio

  • Nov 26

    Windows Mobile Workshop 2009

    0km away in Reading

    Are you thinking of developing for Windows Mobile? Do you want to know how to create Windows Mobile applications that are more that skin deep? Running

  • Dec 8

    VBUG Bracknell: ASP.Net MVC 2.0

    7km away in Bracknell

    Our VBUG Bracknell meeting in December will feature Gavin Osborn from 'The Edge' usergroup.Gavin will be talking about MVC 2.0 and with luck, prev

  • Dec 3

    DevEvening: Christmas CodeFest

    18km away in Woking

    This time we're trying something different:We all learn in different ways. While it can be good to learn by hearing people present and demonstrate new techniques, it can also be good to learn by seeing how different people solve the same problem.  That's what we hope to do at the CodeFest.The plan is for everyone to write automated players for a simple game.  Don't worry if this sounds complicated, it will only involve implementing an interface containing 4 methods.

  • Nov 25

    Oxford Geek Night #15

    29km away in Oxford

    The geek nights are a way for local web developers, designers, programmers, neophiles or geeks of any other stripe to get together, chat, drink and listen to talks on new technologies and innovations.

Related podcasts

Want to stay in touch with what's going on? Follow us on twitter!