Wise Owl courses

...This Excel Business Modelling course is aimed primarily at businesses and public sector organisations Building models What makes a good formula Separating... Learn about: Conditional formulae, Formatting numbers and dates, Data validation...

...from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies... Learn about: More exotic joins, Setting criteria using WHERE, Outputting to Excel...

...Using object variables Looping over collections Links to other applications Referencing other applications Instantiating objects Writing inter-application... Learn about: Class modules, Passing arguments, Working with text files...

...Not only our best-selling course, but also one of our favourites. This two-day course takes you through , all the way from recording Excel VBA macros through... Learn about: Loops & conditions, Referencing other applications, Automating Excel...

...SQL Server Reporting Services 2008 R2 is THE way to publish reports to your corporate intranet. Not only can you include tables of data, matrices... Learn about: Reporting Services, Data sets, Simple Reports...

...in business and public sector organisations Stored procedures Creating stored procedures Executing stored procedures System stored procedures Variables... Learn about: Parameters and return variables, Stored procedures, Temporary tables and table variables...

...Calendars Creating in Excel or SQL Linking to calendars Sorting months Multiple date tables Date functions Period to date Fiscal year calculations Parallel... Learn about: Power BI Desktop overview, Transforming data (Power Query), The CALCULATE function...

...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: Basic reports, Page setup, The SSRS web portal...

...SQL Server Analysis Services now comes in two varieties: multidimensional or tabular models. This course covers the former (creating multidimensional models... Learn about: Hierarchies and Relationships, Data Source Views, Cube actions...

...Using comparison operators Syntax for multiple conditions Lookup transforms Redirecting unmatched rows Choosing a cache mode Setting unmatched rows... Learn about: Derived column transforms, Data flow tasks, Importing multiple files...

...models by combining tables from SQL Server, Access, Excel and other data sources, and how to extract data from these models using Excel pivot tables... Learn about: Other data sources, Calculated columns, Visual Studio basics...

...There are three parts to creating a Power BI report, all of which are covered by this two-day course. Firstly, you'll learn how to get data from all manner of different sources... Learn about: Filtering Data, Publishing reports, Query editor...

...including ways to model multiple calendars, parent-child hierarchies and dynamic security. The course uses Power BI Desktop for editing measures... Learn about: Dynamic measures, Calendars and dates, Calculated columns...

...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...

...reports Power BI accounts Power BI files (PBIX) Power BI Service Overview Differences from PBI Desktop Workspaces Favorites Using Power BI Service Reports... Learn about: Creating databases - overview, Power BI Service Overview, Working with tables...

...On this course you'll learn how to write Python programs in the (free) Visual Studio Code environment to read in files and crunch data, among other things... Learn about: Error Handling, Visual Studio basics, Debugging and error handling...

...Advanced lookup functions Using = MATCH to find values Combining =INDEX and =MATCH The OFFSET function The INDIRECT function Text functions Basic... Learn about: Advanced tables, Lookup functions, Advanced pivot tables...

...Trapping for errors Case studies Navigation buttons Creating a simple menu Validating forms Criteria forms If time Linking to Excel and Word Referencing... Learn about: Attaching code to forms, Linking to Excel & Word, Messages & variables...

...Visual C# (also known as Visual C Sharp) as its programming language. Suitable for: This Advanced ASP.NET C# course is aimed primarily at businesses...

...and link to a SQL Server database WPF basics Using Visual Studio WPF and WinForms compared Basic windows Understanding XAML Basic WPF controls Changing... Learn about: Data sources...