Training courses coming up!

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

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them. You'll learn about the WHERE clause (for setting criteria); the ORDER BY clause; how to aggregate data using GROUP BY; and how to create inner, outer and full joins!

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

Excel can do so much more than simple pivot tables!  This two-day course will show you how to:

• create simple, elegant data models in PowerPivot;
• use these data models to create pivot tables based on multiple tables;
• use queries to build queries to extract, transform and load data (this used to be called Power Query, but is now integrated in Excel);
• 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");
• create hierarchies, and display them in pivot tables;
• create and display KPIs in Excel;
• understand what Power BI Desktop is, and how it is the same in many ways as PowerPivot / Power Query;
• create visualisations in Power BI Desktop (tables, charts and matrices);
• understand how to publish Power BI Desktop reports to the cloud, and pin tiles to dashboards.

Note that you'll need to be using Excel 2016 (or 2013) Professional Plus or Office 365 ProPlus to be able to use the Power BI (Power Business Intelligence) features within Excel.

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.

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them. You'll learn about the WHERE clause (for setting criteria); the ORDER BY clause; how to aggregate data using GROUP BY; and how to create inner, outer and full joins!

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

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!

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

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.