Power BI - Prepare Your Data Efficiently for Excel Analysis WEBCAST
Overview
Before you can analyze data, you first must get the data. This webcast focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform). After this webcast you will finally be able to get the data you need to perform data analysis.
Highlights
Getting data into the correct structure. Data sources that you can access. Working with multiple tables and data sources. Steps to import data for analysis. Introduction to Power Query and Get and Transform.
Prerequisites
Working knowledge of Excel features and functions.
Designed For
Anyone who uses Excel to analyze data.
Objectives
Differentiate between improper and proper data structure. Select the best way to import data into Excel. Identify ways to use Power Query to clean your data.
Preparation
None.
Notice
None.
Leader(s):
Leader Bios
Bryan Smith, CPA Crossings LLC
Bryan L. Smith, CPA, CITP, CISA is the co-founder of CPA Crossings in Rochester, MI. He is a CPA with a strong background in information technology and serves as a virtual CIO to CPA firms and professional organizations. He specializes in the planning and deployment of effective technology solutions. Bryan and John Higgins recently authored Ten Steps to a Digital Practice in the Cloud, which has been published by the AICPA. Bryan helps firm leaders understand the opportunities associated with deploying information technology to improve productivity, enhance client services, and increase profitability. He uses his extensive knowledge and experience to help CPAs bridge the gap between business and technology. He is a past chair of the Michigan Association of CPAs Information Technology Committee and the Leadership Committee.
Non-Member Price $142.00
Member Price $118.00