Introduction to Data Analytics and Microsoft PowerBI Tools

Speaker: Bryan Smith, CPA, CITP, CISA

Format

Video

Level

Basic

Duration

In this webcast, we will provide an overview of the exciting PowerBI tools and discuss Microsoft's PowerBI strategy. We will begin by explaining the challenges many accountants face when analysing data in Excel. You will learn how each PowerBI tool reduces data challenges and improves your analytic skills. Through detailed examples, you will gain a comprehensive understanding of when and why to use each tool.

Learning outcomes

Understand how the PowerBI tools can help with your data analysis needs.
Identify when and why to use each PowerBI tool.
Understand how each PowerBI tool will meet your organization's strategy.

£139.00 (CIMA members only)

£179.00

VAT calculated on checkout

Product information

Overview

##This video is the first part of the Microsoft PowerBI series.

Excel is the #1 data analysis tool for accountants, yet most accountants don’t even know the basics of Excel data analysis functions and tools. Many may have learned to analyse data using PivotTables but quickly realised that there are many weaknesses with PivotTables, leading to complex calculations for simple tasks. After much needed development, Microsoft released Power Pivot in 2010. It is a new data analytics tool that removed PivotTables. This single product took Excel from a low-end data analytic tool to one of the most sophisticated and comprehensive tools on the market. Introducing PowerBI.

In this episode we will provide an overview of the exciting PowerBI tools and discuss Microsoft's PowerBI strategy. We will begin by explaining the challenges many accountants face when analysing data in Excel. You will learn how each PowerBI tool reduces data challenges and improves your analytic skills. Through detailed examples, you will gain a comprehensive understanding of when and why to use each tool.

Explore the other webcasts in the Microsoft PowerBI Series:

Introduction to Data Analytics and Microsoft PowerBI Tools
Microsoft PowerBI – Get Started with the Right Data
Microsoft PowerBI – Introduction to Data Analysis in Excel
Microsoft PowerBI – Improve Data Analysis with DAX Measures
Microsoft PowerBI – Power Pivot for Advanced Data Analysis
Microsoft PowerBI – Fundamentals of Power Query
Microsoft PowerBI – Fundamentals of the PowerBI Desktop App
Microsoft PowerBI – Fundamentals of the PowerBI Dashboards

Professional development

All learning resources available in the CGMA Store qualify for CPD for CIMA members.

Prerequisites:	None
Programme level:	Basic
Duration:	2h
Format:	Video
Access:	This is a digital product. You will have access to the content for a year after purchase date.

Return and refund policy

£139.00 (CIMA members only)

£179.00

VAT calculated on checkout

Speaker

Bryan Smith, CPA, CITP, CISA
Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.

Qualifications and Experience:

• Leadership role in IT consulting services for a top 10 and two top 100 firms over the past 25 years.
• Nationally recognized speaker on technology issues impacting the CPA profession, with an emphasis on internal controls, disaster recovery planning and information security.
• Specialized knowledge in project management systems
• Charter member of the Masters of Science in Information Assurance (MISA), Walsh College, Troy, Michigan
• Treasurer of the Microsoft Project Users Group - Michigan
• Member of the AICPA CITP (Certified Information technology Professional) Credential Committee
• Past Chair of the Michigan Association of CPAs Information
• Technology Committee and Leadership Committee