24SS-0164: Surgent's Excel: The Data Tools for Analysis -- Power Query and Power Pivot (Self-Study)
Valid for one year from purchase date
Self-study - On-Demand
1 CPE (1 technical)
If the organization paying
for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.
Add to cart
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.
Major subjects
-
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
Learning objective(s)
-
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
Who should take this program?
Anyone who wants to understand how you can begin your data analytics journey with the data tools available in Excel
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$59.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
|
Standard Member Fee |
$59.00
|
 Standard Nonmember Fee |
$59.00
|
Area
of study
Information technology
Field(s)
of study
Information Technology - Technical (1.0)
Level
Overview
Format
Self-study - On-Demand
Sponsor
NASBA ID#: 103212
Prerequisites
Prereq.
None
Advance
prep
None
If the organization paying
for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.
Add to cart
Not a member? Join the MNCPA
to start saving on CPE and accessing members-only benefits.
Search CPE catalog
