MS-50578 MDX with Microsoft Analysis Services - ENU
How to Ask Questions and Get Accurate Answers From
Besoin d’adapter cette formation à vos besoins ?
N’hésitez pas à nous contacter afin d’obtenir un devis sur mesure !
Formation créée le 09/01/2023. Dernière mise à jour le 23/09/2024.
Version du programme : 2
Programme de la formation
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?
Objectifs de la formation
- Explore the flow of data in the Microsoft Business Intelligence Stack. Know the toolsets available
- Explore MDX syntax and review some key terms in MultiDimensional space
- Take a detailed look at dimensions and know how to use them with MDX
- Explain the use of navigational functions, to use those functions to locate a member within a hierarchy and evaluate the member’s position
- Create new measures and perform calculations on them with or without the existing measures
- Perform time based analysis by using MDX functions
- Use MDX in SQL Server Report Services
Profil des bénéficiaires
- If the past is any indicator of the future then this course will be attended mainly by SQL Professionals, Microsoft Analysis Service cube and report developers and Business Intelligence Professionals coming from competing platforms.
- But you do not need those skills. The course was not written assuming those skills.
- Why this course may be for you: - Your company is moving or implementing Microsoft SQL Server Analysis ServicesYour organization is implementing Department Business Intelligence with a Data Mart. - You want to develop a skillset in high demand. - The current reports from the cubes do not provide the answers. - Your organization wants you to get grounding in MDX so you can build out advanced analytics.
- Before attending this course, students should have: A good idea of what direction their organization wants to go with Business Intelligence Basic Microsoft interface skills such as working with Excel, Power BI.
Contenu de la formation
-
Module 1 : Microsoft Business Intelligence Stack - Jour 1
- Data flow in the stack
- SQL Server BI Platform
- The Tool Sets : Developer Tools, Power User Tools, Information Worker Tools
-
Module 2 : Getting Started with MDX. We walk then run. Learn this and you won't trip. - Jour 1
- Who use MDX?
- MDX Statements
- Basic MDX
- Aliasing through With Clause
-
Module 3 : The all-important Dimensions. The bearers of truth. - Jour 1 & 2
- MDX Functions
- Key Concepts of Dimensions
- MDX Hierarchies
- .members Function
- Tuples
- Cells
- Sets
-
Module 4 : Navigation and the secrets of relatives! - Jour 2
- Navigating Hierarchies
- Immediate Relatives
- Function Syntax
- .members Function
- Descendants, Ancestor, Ascendants, Siblings, Cousin Functions
- Lastchild and Firstchild Functions
- Lead, Lag, Head and Tail Functions
- Prevmember, Nextmember, CurrentMember Functions
- Hierarchize and Drill down & up Functions
- Order, Rank Functions
- Range Operator
- TopCount, BottomCount Function
- Filter Function
- NonEmpty Function
- Combining Sets : Union, Intersection, Exception
-
Module 5 : MDX Calculations - Jour 2 & 3
- Named Calculation
- Named Set
- Scoped Assignments
- Expressions
- Solve Order
- Calculated Members (WITH Member)
- AllMembers Function
- Dynamic Expressions
- Using Sets In Expressions
- Existing keyword
- IIF Functions
- IsEmpty, CurrentMember
- Level and Ordinal Functions
- Statistical Functions
- Count, TopCount Functions
- Generate Function
-
Module 6 : Working with Time. Multiple calendars, divergent horizons - Jour 3
- The Time Dimension
- Current Value
- Navigating Time
- Historical Values
- ParrallelPeriod
- OpeningPeriod/ClosingPeriod
- PeriodsToDate
- (x)TD Functions
- LastPeriods
- Combining Functions
-
Module 7 : Business Insights. Now let's put it to work and get some situational answers - Jour 3
- Ranking Comparisons
- Peer Ranking
- Percent of Level or Group
- Percentage of Parent
-
Module 8 : Where else will MDX work? SQL Reports - Jour 3
- MDX in SSRS
- Reports in BIDS (SSDT)
- Data Sources
- Datasets
Activ-IT Formation est un organisme de formation spécialisé dans les formations en informatique et bureautique. Activ-IT Formation est principalement installée à Montpellier et dispose de toutes les facilités sur des sites proposés par ses partenaires. Des salles de formation équipées de matériel informatique de dernière génération, espace de convivialité, parking gratuit et surveillé et restauration sur place dans des centres de nos partenaires. Des salles de formation digitales équipées de matériel informatique de dernière génération. Forte d'un réseau de formateurs experts, la promesse de Activ-IT Formation est de savoir répondre aux demandes, que ce soit pour des formations « standard » ou spécifique ». Activ-IT est à l'écoute des personnes en situation de Handicap. Informez-nous si vous avez besoin d'aide. Nos formateurs/Intervenants sont certifiés sur les sujets enseignés et/ou ont une expérience terrain d'expertise en entreprise.
- Feuilles de présence
- Questions orales ou écrites (QCM)
- Mises en situation
- Formulaires d'évaluation de la formation
- Certificat de réalisation de l’action de formation
- Accueil des apprenants dans une salle dédiée à la formation
- Documents supports de formation projetés
- Exposés théoriques
- Etude de cas concrets
- Quiz en salle
- Mise à disposition en ligne de documents supports à la suite de la formation