THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

PowerPivot Course European Roadshow – first stop London #ppws

After the successful first edition in Amsterdam of the PowerPivot Workshop in December, we are planning to repeat this 2-day intensive course on PowerPivot in several other European countries (we are also evaluating one or two possible dates in US – please write me in case you are interested either as an individual or as a training company: we are making agreements for local deliveries of the same content).

All the information are available on a fresh nice website www.powerpivotworkshop.com – and we will also use the #ppws twitter tag to give updated info about the workshop. We will start from London, on February 7-8, 2011 (and the early bird discount for London expires on January 17 – so hurry up!).

This is the list of the cities in our plan (I will update dates as soon as they are confirmed):

  • London, UK – February 7-8, 2011
  • Frankfurt, DE - February 21-22, 2011
  • Dublin, IE
  • Zurich, CH
  • Copenhagen, DK
  • Vienna, AT
  • Stockholm, SE
  • Paris, FR
  • Milan, IT (in Italian language)

The course has been designed to provide a full coverage of PowerPivot modeling options and a solid explanation of DAX concepts (syntax, aggregations, evaluation contexts, date intelligence, and much else). The content is based on our PowerPivot book and we use several practical examples and graphical diagrams to explain the concepts.

The targets of these training days are both Excel Power Users and BI Consultants / BI Developer. We had many BI consultants in our first workshop, in part because we reach a more technical audience, but also because PowerPivot is an excellent way to create proof of concepts and/or to face particular problems that don’t require (or don’t justify) the building of a “traditional” Corporate BI solution. If you are reading this blog regularly and you still don’t know PowerPivot, you should consider attending the workshop or at least read the book! The reason is simple: you cannot avoid learning DAX. The next version of Analysis Services will use DAX for the new BI Semantic Model. And, after more than one year of DAX usage, I have to say that it is really powerful, even if it require some changes in your mindset, especially if you are used to MDX. It is not that one is better than the other. They are different. Being able to use both on Analysis Services will be wonderful.

The course outline is the following:

  • Introduction to PowerPivot
  • Introduction to DAX
  • Data Modeling basics for building PowerPivot data models
  • Data loading techniques with different kind of sources: OLTP, DWH, Microsoft SQL Server, Microsoft Access and others
  • Mastering Pivot Tables
  • Full coverage of the DAX programming language, with several hands-on examples
    • Evaluation Contexts and CALCULATE
    • Calendar-based computations
    • DAX Patterns
  • Advanced data modeling techniques to solve some common scenarios
  • SharePoint integration

All the details and the registration form are available on www.powerpivotworkshop.com.

Published Wednesday, January 05, 2011 5:26 PM by Marco Russo (SQLBI)
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Alberto Ferrari said:

As you might have read in Marco’s post , the PowerPivot Workshop I and Marco Russo have prepared is now

January 7, 2011 5:00 AM
 

SQLBI - Marco Russo said:

One week ago I described the PowerPivot Workshop Roadshow that we are planning in several European countries.

January 13, 2011 10:19 AM

Leave a Comment

(required) 
(required) 
Submit

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement