Agile BI is pleased to offer this world class training course (SSAS Tabular PowerPivot Training Sydney) for developers from industry experts Pragmatic Works. If you want to get started with PowerPivot, SSAS Tabular and DAX this is the course for you – teaching you how to model you data, enrich it and serve it up to your users like a professional.

We don’t just deliver from a script – our trainers are consultants who deliver results for our clients in the field every day. They can bring, real proven expertise to the material and deal with your questions and real life challenges based on what they do for our clients.

SSAS Tabular PowerPivot Training Sydney Course goal:

By the end of this course, you’ll feel confident using this powerful toolset to analyze and gain insight from your business data. It includes plenty of hands on labs designed to give you practical experience using Power Pivot and creating tabular data models.

For details of upcoming courses and to book, visit the Pragmatic Works pages – please note all prices are in US Dollars:

Course content:

Tabular and Power Pivot for Developers is an intensive course that is designed to get you up to speed using Power Pivot quickly and productively. You will start from basic concepts and move to complex data models and DAX formulas. The full outline is below:

  • Introduction to Power Pivot
  • Importing Data into Power Pivot
  • Creating the Data Model
  • Creating Calculations with DAX
  • Creating Calculated Measures with DAX
  • Incorporating Time Intelligence
  • Building Power Pivot Reports
  • Introduction to the Tabular Model
  • Managing Tabular Data Models
  • Securing Tabular Data Models
  • Advanced Data Analysis
  • Performance Tuning
  • Planning and Implementing a Solution

If you want to know more about SSAS Tabular PowerPivot Training Sydney, use the contact form below to get in touch, or book now one of your preferred session – please note all prices are in US Dollars:

 

Email us today about SSAS Tabular PowerPivot Training Sydney


What our attendees have said about this course:

BI Developer, NSW Government

Did you have any concerns before attending this training?

Only that it may fall into the standard vanilla instructor reading off notes at the front of the room for two days.

What did you find as a result of attending?

It was not the above. Informative, engaging, relevant.

What specific aspect of the training did you like most?

I found the references to the real world examples and insider insight to be valuable.

What would be three other benefits you found from attending?

Validation of our ideas, common pitfalls, benefit of real world experience.

Would you recommend this course to another person? If so, why?

Yes if they were in the BI space or heading into it. The course materials offered both entry level and more advanced concepts, without being overwhelming.

Is there anything you’d like to add?

I enjoyed the fact that James was approaching it from a hands on perspective, how would I solve this problem(?), rather than as just a trainer.


BI Manager, NSW Government

Did you have any concerns before attending this training?

Primary concern was that the trainer would just be reciting/presenting a straight textbook training course with no real knowledge of the material. You definitely proved to have practical and proven expertise in this space though.

What did you find as a result of attending?

For us it confirmed we are heading down the correct path and got some good theory behind how some of the technical stuff works as well as some tips and tricks.

What specific aspect of the training did you like most?

Being able to ask you some quite technical questions and have you immediately understand what we were asking and provide relevant answers.

Would you recommend this course to another person? If so, why?

Yes, especially to those that have a technical background.


Business Analyst, Government

Did you have any concerns before attending this training?

Yes, I did not have knowledge on server development and wanted to understand it. In regards to PowerPivot, I was stuck on particular “below the line” dax formulas.

What did you find as a result of attending?

I got my previous dax query solved. I already had knowledge on building PowerPivot models but it I gained knowledge on the background of how it works structurally, how to make models more efficient and new dax functions that I did not know about previously. I got a good overview on server development and server data management tools.

What specific aspect of the training did you like most?

I liked how James explained things especially using the whiteboard. He uses visual maps to explain things which is really useful for me to understand easily.

What would be three other benefits you found from attending?

I now know about hierarchy modelling in PowerPivot, I learned some new things in PowerPivot such as how to manage many to many relationships and James advised us on useful websites and reading material to help us.

Would you recommend this course to another person? If so, why?

Yes, it gives you a stronger foundation on PowerPivot development and even if you are not a server administrator, it is good to understand how it works to have a big picture view.

Is there anything you’d like to add?

Thanks for the training!


Business Analyst, Government

Did you have any concerns before attending this training?

Mainly, that the schedule (esp. Day 2) included a lot of terms (such as “tabular model”) that were completely meaningless to me, so I was a bit nervous about how much assumed knowledge there would be

What did you find as a result of attending?

Generally, the explanation of and connection between the familiar and unfamiliar components was well handled (ie my concerns were mainly unfounded)

What specific aspect of the training did you like most?

It was good that there were lab exercises so that we could actually do some of the steps that you had shown us on the big screen – its very valuable (in the learning / remembering process) to actually **do** something

What would be three other benefits you found from attending?

(1) The hints/tips for improving usability of Powerpivots (eg giving sensible English names to columns with spaces etc), (2) usage of Calculated Measures (I had never used them before) (3) learn the difference between Power Pivot / Tabular Model and Analysis Services OLAP

Would you recommend this course to another person? If so, why?

Yes, mainly because of James’ considerable ‘real world’ experience in using these products (esp. Power Pivots and Tabular Model) for the management of data and creating reports; his ability to be pragmatic in designing reports in usable ways rather than chasing “computational efficiency” but ending up with an unusable mess!