Wise Owl courses

...validation rules Input and error messages Highlighting validated cells Circling invalid data Protection How protection works Unlocking cells Turning protection... Learn about: Building models, Lookup functions, Data tables...

...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 diagrams, Using SQL Server, Simple Queries...

...and FileSystemObjects Avoiding using INPUT/OUTPUT Creating and opening Arrays Creating and populating arrays Dynamic arrays The PRESERVE keyword Distributing... Learn about: Working with text files, Revision of VBA, Links to other applications...

...Messages and variables Input boxes and message boxes Declaring variables Option Explicit Scope of variables Constants Visual Basic explained The Excel... Learn about: Messages & variables, Visual Basic, Debugging and error handling...

...formatting lists Grouping using lists Using rectangles in lists If time Subreports Creating a child report Creating the main report Creating and formatting... Learn about: Reporting Services, Simple Reports, Data sets...

...dynamic SQL Executing dynamic SQL Disadvantages of dynamic SQL If time Pivots Assembling data for pivoting Using PIVOT Dynamic column headers If time Triggers Insert... Learn about: Inserting Data, Parameters and return variables, Creating Tables...

...Calculated columns Creating calculated columns Using the RELATED function BLANK and SWITCH Measures The all-important query context Implicit calculated... Learn about: Power View, DAX basics, Calculated columns...

...Matrices Row and column groups Sorting and filtering matrices Creating subtotals Charts Creating charts The parts of a chart Formatting charts Basic reports... Learn about: Page setup, Data sources and datasets, Basic reports...

...hierarchies Unnatural hierarchies Attribute relationships Suppressing hierarchies Parent-child Hierarchies The self-join needed Tidying up the dimensions... Learn about: Multi-dimensional models, Data Source Views, Time dimensions...

...this course is for you! Refreshingly, the course doesn't use any large, impenetrable Microsoft database, but instead uses a simple Wise Owl... Learn about: Derived column transforms, Lookup transforms, Data flow tasks...

...Studio basics Visual Studio windows Setting startup options Creating a project Connecting to SQL Server Creating and using connections Filtering rows... Learn about: Connecting to SQL Server, Changing query context, Other data sources...

...to ArcGIS Calculated columns Adding columns IF and SWITCH The RELATED function Calendars Creating calendars Using multiple calendars Working days Publishing... Learn about: Using Power BI Service, Other types of visualisation, Publishing reports...

...but is just as useful if you're using PowerPivot or SQL Server Analysis Services (tabular model). Ways to edit DAX Power BI PowerPivot SSAS Tabular... Learn about: Calendars and dates, Basic measures, Understanding EARLIER...

...Using SQL Server Using Object Explorer Hiding system objects Creating databases - overview Designing databases Primary keys Indexing fields Working... Learn about: SQL Database, Database training...

...Excel / text files Websites and web serivces Formatting visualisations The formatting panes Conditional formatting Charts Working with charts Specific... Learn about: Working with tables, Power BI Desktop overview, Power BI Service Overview...

...(if time) • The try clause • Handling exceptions Working with data types (if time) • Manipulating strings • Numbers and Booleans • The DATETIME module... Learn about: Debugging and error handling, Visual Studio basics, Error Handling...

...tables Removing duplicates Advanced filters (multiple criteria) Adding and removing subtotals Grouping/outlining controls Pivot tables Creating pivot tables... Learn about: Advanced tables, Advanced Lookup Functions, Advanced pivot tables...

...other applications Manipulating Excel from Access If time Modifying queries Basic SQL statements Amending queries'... Learn about: Messages & variables, Attaching code to forms, Visual Basic explained...

...Instantiation Private and public properties Inheritance Using classes Classes to create records Classes to return records Creating your own business objects...

...styling of controls and a more web-like development environment. This course aims to teach you the basics of WPF: laying out forms, binding to data using... Learn about: Data sources...