• Importing SQL Server tables
• Filtering rows & also columns
• Data and also diagram view
• Hiding from client view
• Relationships

• Drill-down vs Quick Explore
• Slicers and also timelines
• Controlling what you see

• Creating and also naming tables
• Adding to data models

• Importing Access and also Excel
• Importing cubes
• Pasting from the clipboard

• Querying databases
• Web pages and also XML files

• Splitting columns
• Merging and also inserting columns
• Other transforms

• Creating calculated columns
• Using the RELATED function
• BLANK and also SWITCH

• The all-important query context
• Implicit calculated fields
• AutoSum fields
• Creating in Excel and also PowerPivo

• The DAX Studio add-in
• Calculating ratios
• Aggregate X functions

• Replacing filters
• Using ALL
• Using VALUES to edit filters

• Using FILTER to filter tables
• Ranking
• The EARLIER function

• Creating in Excel or SQL
• Linking to calendars
• Sorting months & also weeks

Multiple date tables

• Period to date
• Fiscal year calculations
• Parallel periods
• Semi-additive measures

• Creating hierarchies
• Pros and also cons

• Relative KPIs
• Absolute KPIs

• The data model again
• Creating visualisations

• Slicers
• Using tiles
• Filtering data

• Creating matrices and cards
• Chart multiples
• Chart drill-down
• Scatter and also bubble charts

• Assembling your data
• Creating maps
• Drill-down in maps

• Creating maps
• Scenes, tours and also layers
• Creating videos
• Reasons not to use