Microsoft Power BI has been recognized as one of the leaders for Analytics and Business Intelligence Planform in the Gartner Magic Quadrant for many consecutive years. It lets you connect, transform, analyze, and visualize data very efficiently, which will enable any finance, accounting, tax professionals to perform more powerful data analytics in almost real time.
This is an intermediate level workshop designed specifically to allow you to develop advanced skills to collect data from various sources, transform data, and create measures using Microsoft Power BI and Microsoft Excel in more complex scenarios. After completing this hands-on and highly engaging workshop, you will be able to prepare data using advanced query editor, organize and create relationships between data sets, create measures using DAX, import data model from Excel, design, create, and share reports in Power BI.
Module 1: Connecting to other data sources
Module 2: Advanced data transformation techniques (M)
Module 3: Advanced measures (DAX)
Module 4: Publishing and sharing reports
This workshop qualifies for 7.0 CPE hours in Information Technology (Category 5).
You should ideally have:
Your laptop should be:
By the end of the workshop, you will :
Accounting Professionals and Business Managers with some baseline knowledge and fundamental skills in data analytics and would like to be able to perform complicated data transformation, calculation, and visualization in Microsoft Power BI and Excel.
John is a US Certified Public Accountant licensed in New York State, and currently leads a business intelligence service practice. He utilizes over fifteen years of combined experience in corporate financial reporting and analysis, corporate tax compliance and provision, executive financial dashboard management, technology and performance improvement, data modeling and warehousing, and ERP integration to assist corporate finance and tax functions with improving performance and managing business risk using business intelligence.
John was part of EY’s Tax Technology and Transformation group (formerly known as Tax Performance Advisory) in Washington, New York City and Singapore. Prior to joining EY, John was a financial analyst in charge of the development of Business Objects tools, data modeling and warehousing, and executive financial dashboard management for a global manufacturing company in the United States.