Data analytics (8)

Mastering Data Preparation and Analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 13 November, 2019 | 9:00 am - 11:00 am UTC

This webcast is a must for any accounting or finance professional. Excel is almost as important as your technical training – so why aren’t you using it to save time or analyse data properly? This might be the best two hours of learning in your career so far.

Microsoft PowerBI – Fundamentals of Power Query

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 11 November, 2019 | 3:00 pm - 5:00 pm UTC

This webcast focuses on using Power Query, as well as 'Get' and 'Transform' in Excel 2016, to clean, shape, and transform your messy data while still allowing you the one-click refresh.

Microsoft PowerBI – Fundamentals of the PowerBI Dashboards

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 13 November, 2019 | 3:00 pm - 7:00 pm UTC

This webcast introduces you to Microsoft PowerBI Dashboards and its differences from PowerBI Desktop. You will learn how you can share data from Power Pivot or PowerBI Desktop to PowerBI.com.

Microsoft PowerBI – Fundamentals of the PowerBI Desktop app

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 12 November, 2019 | 3:00 pm - 7:00 pm UTC

This webcast focuses on learning the PowerBI Desktop interface, connecting to data sources and creating visualisations. We tour the PowerBi Desktop interface and create each of the various visualisations.

Microsoft PowerBI – Improve data analysis with DAX Measures

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 17 October, 2019 | 2:00 pm - 4:00 pm UTC

This webcast focuses you to the relevant Excel data analysis tools and what you can do with your data once it is in Excel. Learn how to use various techniques to cleanse your data by removing errors, validating and standardising data.

Microsoft PowerBI – Power Pivot for advanced data analysis

Speaker: Bryan Smith, CPA, CITP, CISA

Webcast: 18 October, 2019 | 2:00 pm - 4:00 pm UTC

This webcast focuses on using the Power Pivot features to enhance your data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will use the power of DAX to create meaningful calculations that add new dimensions to your data.

Microsoft PowerBI – Introduction to data analysis in Excel

Speaker: Bryan Smith, CPA, CITP, CISA

This webcast introduces you to the relevant Excel data analysis tools and focuses on what you can do with your data once it is in Microsoft Excel. You will learn how to use Power BI various techniques to cleanse your data by removing errors, validating and standardsing data.

Data Analytics for Finance Managers (Two-Day Webcast)

Speakers: AlignAlytics; Roland Mosimann, President, AlignAlytics, Wayne, PA; Chris Coigne

Webcast: 06 November, 2019 | 9:00 am - 9:00 pm UTC

Drawing from the best practices of effective data-driven organisations, this course will help finance leaders develop thoughtful analytics to deliver data-driven insights and drive organisational growth.