-
All
-
Online
-
Filters
Wise Owl courses
- Course
- Londonandanother venue.
- Manchester
- Beginner
- Different dates available
- 2 Days
...use SQL Server 2008 if you prefer; the differences are small). Suitable for: This Writing SQL course is aimed primarily at businesses and public sector organisations... Learn about: Outputting to Excel, Simple Queries, Using SQL Server...
- Course
- Londonandanother venue.
- Manchester
- Advanced
- Different dates available
- 2 Days
...Declaring variables SET versus SELECT Tricks with variables So-called global variables Parameters and return values Passing parameters Default values... Learn about: Inserting Data, Derived tables and CTEs, Stored procedures...
- Course
- Londonandanother venue.
- Manchester
- Intermediate
- Different dates available
- 2 Days
...Dimension usage Multiple measure groups Calculations Creating calculations Formatting calculations Basic MDX expressions MDX Expressions Year-to-date Ratios... Learn about: MDX Expressions, Basic Cubes, Cube actions...
- Training
- Londonandanother venue.
- Manchester
- Beginner
- Different dates available
- 2 Days
...using Query Editor to manipulate the results; secondly, you'll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more)... Learn about: Overview of maps, Multiple tables, Data sources...
- Training
- Londonandanother venue.
- Manchester
- Intermediate
- Different dates available
- 2 Days
...with blanks Basic measures Creating measures Understanding filter context Using a measures table AggregateX functions The CALCULATE function Filter context... Learn about: Basic measures, Ways to edit DAX, Advanced date functions...
Similar training and in other locations
- Course
- Online
- Advanced
- Different dates available
- 12h - 2 Days
...on for a worksheet Protecting the whole workbook Grouping/outlining Creating and removing groups Expanding and collapsing Multiple worksheets Group editing... Learn about: Investment Appraisal, Conditional Formatting, Cashflow calculations...
- Course
- Online
- Advanced
- Different dates available
- 12h - 2 Days
...Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean! Suitable for: This Advanced... Learn about: Revision of VBA, Passing arguments, Linking to data...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...Three main types of loop Looping over collections Object variables Looping over collections Event handling Assigning macros to events Cancelling events... Learn about: Event Handling, Referencing other applications, Looping over collections...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...subreports Drill-through reports Parent and child reports Creating actions Passing values to a child report If time Maps ESRI shapefiles / SQL spatial... Learn about: Reporting Services, Data sets, Simple Reports...
- Course
- Online
- Beginner
- Different dates available
- 2 Days
...start to use the DAX language for more in-depth analysis of data; analyse time series data ("compare this month's sales with the same period in the previous quarter")... Learn about: Power BI Desktop overview, Date Functions, Using other data sources...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...(this course teaches either - or both). Data sources and datasets Data sources Datasets Using query designer Tables Creating tables Interactive sorting... Learn about: Page setup, The SSRS web portal, Data sources and datasets...
- Training
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...Using comparison operators Syntax for multiple conditions Lookup transforms Redirecting unmatched rows Choosing a cache mode Setting unmatched rows... Learn about: Looping over files, Using different data connections, Data viewers...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...Linking tables using RELATED Measures Creating measures SUMX, AVERAGEX, etc. Changing query context The CALCULATE function Using FILTER Prototyping using... Learn about: Accessing DAX queries, Calculated columns, Creating a data model...
- Short course
- Online
- Beginner
- 12h - 2 Days
...ANY and IN Using EXISTS Correlated subqueries If time Derived tables and CTEs Using derived tables Common Table Expressions (CTEs) Multiple CTEs in a single query... Learn about: Database training, SQL Database...
- Short course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...feature Drill-through filtering Adding drillthrough filters Back buttons Action buttons Assigning actions to shapes Inserting buttons Hover and select... Learn about: Creating databases - overview, Power BI Desktop overview, Working with tables...
- Short course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...Sequences • Tuples versus lists • Iterating over sequences • Slicing sequences • Joining and splitting Manipulating lists • Adding/removing items • Sorting... Learn about: Debugging and error handling, Error Handling, Data sources...