May-2014 ~ Advanced Tabular Development ~ Christopher Schmidt

Posted by admin

cschmidt

Presenter: Christopher Schmidt
Topic: Advanced Tabular Development

In this session, we’ll cover some of the more advanced concepts in tabular databases. First we’ll take a look at things like partitions and perspectives, and how we can use them to assist in management and maintenance of an Analysis Services database. Then we’ll look at implementing dynamic security into our solution, and finally we’ll briefly explore the types of query modes available to tabular.When should In-Memory, DirectQuery, or one of the hybrids be used?

Biography:

Chris is a Senior Business Intelligence Consultant with Pragmatic Works and has more than 5 years experience in developing business intelligence solutions. He lives in Raleigh, NC and is an active member of the SQL community. Chris is extremely passionate about business intelligence, and helping companies achieve insight through data. An avid sci-fi fan, when he’s not watching his beloved Manchester United play, you’ll frequently see Game of Thrones, Doctor Who and BattleStar Galactica reruns on his television. Chris also blogs at http://intelligentsql.wordpress.com.

Sep-2009 ~ Creating reports using cubes ~ Sunil Kadimdiwan

Posted by admin

 

Presenter: Sunil Kadimdiwan
Topic: Creating Impressive Reports Using Smart Data Analysis Cubes

 

It is important for us Database Developers and Database Administrators to provide useful reports to our business users. These should be based on good analysis of your data. It is more beneficial if we can display charts, maps, summary reports with drilldown capabilities and combine relevant information into easy to view dashboards. This will allow business users to get to the right information quickly.

SQL Server Analysis Services (SSAS) 2008 allows us to build data analysis cubes and then SQL Server Reporting Services (SSRS) 2008 will allow us to develop compelling reports & dashboards. In this presentation I will show you how to get started on these 2 products and very quickly get useful results.

Biography:

Sunil Kadimdiwan is a Data Architect with an extensive record of successfully designing and implementing mission critical Database & Reporting solutions.

He has deep knowledge of Microsoft BI technology platform. He is well versed in Insurance, High Tech, Capital Market, Publishing, and Non-Profit industries. He is a frequent speaker at code camps, user groups in the New England region.