We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!

Training courses coming up!

Here are the courses on which we still have places in the next 4 weeks or so:

Dates Venue Course Summary Book
14‑15 Apr Manchester Advanced Power BI

If you've mastered the basics of creating Power BI reports, you may like to find out what else it can do - but you should only consider attending this course if you use Power BI regularly.  Learn how to create report themes and templates, find out how to use quick measures and bookmarks, delve further into Query Editor and maps, and much more!

Book places
16‑17 Apr London Introduction to SSIS

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams! 

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

Book places
21‑22 Apr London DAX

This course will teach you how to create calculated columns and measures using DAX, including how to understand complicated DAX functions like CALCULATE, VALUES and EARLIER.  The course also covers writing DAX queries to interrogate databases.  During the course you'll pick up lots of clever techniques for building data models, including ways to model multiple calendars, parent-child hierarchies and dynamic security.  The training uses Power BI Desktop for editing measures, but is just as useful if you're using PowerPivot or SQL Server Analysis Services (tabular model).  This course is definitely more difficult than our two-day Introduction to Power BI course, and is complementary to our two-day Advanced Power BI course (there is virtually no overlap between the two).

Book places
23‑24 Apr Manchester Excel Advanced

Excel can do so much more than simple formulae!  This two-day advanced course will show you how to use VLOOKUP and MATCH/INDEX functions, create pivot tables and much, much more.  The idea is that by the time you finish the course you will have seen virtually everything that Excel can offer(apart from VBA, the subject of a separate two-day Excel VBA course).

Book places
27‑28 Apr Manchester Excel VBA macros

Tired of repeating tasks in Excel? Perhaps it's time to automate your work, by learning how to write macros using the built-in VBA programming language (VBA stands for Visual Basic for Applications, and is the language also used by Access, Word, Outlook and PowerPoint).

Book places
27‑28 Apr Manchester Introduction to SSIS

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams! 

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

Book places
27‑28 Apr Manchester Advanced VBA

If you already know how to create subroutines in VBA, are happy declaring variables and can write loops and conditions without a qualm, this is the course for you! Assuming a good working knowledge of Visual Basic for Applications, the advanced course shows you how to loop over collections, reference other applications, work with files in all of their manifestations, create your own classes (!) and much more.  The course uses examples drawn from Excel, Access, Word and Outlook.

Book places
29‑30 Apr Manchester Introduction to Power BI

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, how to use Query Editor to manipulate the results and how to build a data model; secondly, you'll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you'll learn how to create calculated columns  using basic DAX language.  You'll also learn how to publish reports to Power BI Service.  If you're not sure whether you want to book on this course or on our two-day Excel Power BI tools course, have a look here.

Book places

You can download our full course schedule here.

This page has 0 threads Add post