´╗┐

MDX with Microsoft Analysis Services: How to ask questions and get accurate answers from your Data


Introduction

This instructor led course is designed to take a person from the very beginning of MDX queries to journeyman. The first chapters (1-4) get you well-grounded then from there we expand out. You won’t know how to do every MDX query. You won’t look at every function. But you will understand the patterns and from them you can examine examples and build on them to code your own sophisticated queries.
Queries such as:
  • What are the top 5 customers by country over the last 8 quarters?
  • What is our reorder point based on inventory levels?
  • What are our best customers in terms of volume and gross profit?
  • What effect does shipping cost have on profitability on a geographical distribution?
  • How do we calculate the Year to Date value?
  • How do we do Year-over-Year growth?
  • When looking at manufacturing how do we account only for workdays?

Outcomes

You will be at a mid-level of competence in MDX. You should be able, with practice, to get to expert on your own with experience. 

On-site training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.




User Reviews

Good Stuff (Rating based on 1 reviews)

100%
of respondents recommend this course to a friend.


Click here to Read Reviews

Course Info


Next Step

Enquire Now
Tell a Friend
Email Course Outline