Surgent's Excel: The Data Tools for Analysis - Power Query and Power Pivot
Available Anytime
Location:
Online
1Credits
Technical Business
Registration is Open
FICPA Members
Nonmembers
$74.00 Regular Price
Product Code: SU24-DT02-SSWC
Level: Overview
Vendor: Surgent
Field of Study: Information Technology
Overview:
With the Power BI ecosystem, a complete business intelligence solution, your company can begin the data analytics journey with Excel. Excel contains two data tools of the Power BI ecosystem to begin developing data skills: Power Query and Power Pivot. Beginning your data journey with an application your business users are already familiar with will increase your chances of success in your company's data goals. This course will demonstrate the capabilities of Power Query and Power Pivot in Excel.Objectives:
- Explain the data tools available in Excel
- Locate Power Query and Power Pivot in Excel
- Be well versed in the important points of Power Query and Power Pivot
- Understand why starting with Excel in implementing data analytics is a smart choice
Major Topics:
- Demonstration in Excel: where to locate the data tools of Power Query and Power Pivot
- Data skills demonstrated: data preparation and data modeling
- Demonstrations in Power Query – the Extract Transform and Load tool for data preparation of the Power BI ecosystem, including data sources Power Query can connect to; transformations; load options; operations; and sample of use cases
- Demonstrations in Power Pivot, the data modeling tool of the Power BI ecosystem, including query organization; custom columns; parameters; and database capabilities
Designed For:
Anyone who wants to understand how you can begin your data analytics journey with the data tools available in ExcelPrerequisite:
NoneAdditional Info:
You will receive an email from info@surgent.com with instructions on how to log onto your course shortly. If you do not receive the email within the hour, please check your spam filter.
For technical support, registration questions or other customer service-related inquiries, please call (800) 778-7436 or email info@surgent.com. Phones are staffed from 8:30 a.m. to 5:00 p.m. Eastern Time, Monday through Thursday, and 8:30 a.m. to 4:00 p.m. Eastern Time on Friday.