Microsoft Power BI Desktop and Microsoft Power Query

at Certstaffix Training - Largo

(114)
Course Details
Price:
$620 4 seats left
Start Date:

Thu, Oct 17, 10:00am - 5:00pm

Next start dates (2)

Location:
Largo
1300 Caraway Ct Ste 200
Btwn McCormick & Arena Drives
Largo, Maryland 20774
(Map)
Share:
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 3

What you'll learn in this data visualization training:

This course familiarizes the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. 

Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.

Students Will Learn:
  • Connecting to Databases
  • Grouping/Summarizing
  • Introduction to Power Query
  • Loading Your Data
  • Performing Merges
  • Power Query Language "M"
  • Working with CSV, Text and Excel
Course Objectives
  • Understand the revolutionary changes in Power Query and the ease it provides for Excel pros.
  • Successfully navigate the Power Query interface.
  • Understand and properly configure data types.
  • Understand and perform importing data.
  • Understand and perform transforming data.
  • Understand and perform loading data.
  • Understand and utilize ranges in Excel.
  • Understand and handle special situations.
  • Understand and perform appending operations.
  • Understand and utilize working with folders and files.
  • Understand and perform combining worksheets.
  • Understand and utilize PivotTables.
  • Understand working with relational data.
  • Understand and perform importing from SQL Server Analysis Services Multidimensional.
  • Understand and perform importing from SQL Server Analysis Services Tabular.
  • Understand the issues encountered when performing merges.
  • Understand and utilize merges.
  • Understand and utilize loading into Excel.
  • Understand and utilize loading into Power Pivot.
  • Understand and utilize loading to Power BI Desktop.
  • Understand and utilize the data sources available.
  • Understand and utilize grouping.
  • Understand and utilize summarizing.
  • Understand the M interface.
  • Understand Power Query formulas.
Prerequisite: The student should be familiar with Excel and the concepts of datasets and basic reporting, including the use of PivotTables.

Headsets for free, Guaranteed to Run, Re-Takes for free (Up to 6 months), Interactive Classroom environment.

Registration Note: We can only accept students into our classes whose tuition is being paid by an employer or sponsoring organization. Self-paying individuals cannot enroll.

School Notes:
Important:
Courseware (if a course has a Courseware) will be shipped to the address provided two weeks before the class starts. Make sure that the additional info field is properly and correctly filled out to avoid Courseware being lost in transit. Please also note that P.O. Box addresses are not allowed.


The classes are instructor-led live training you attend in a local classroom or from your home/office. Our instructors teach from a remote location while being able to interact with students as in a traditional classroom setting.

Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions.

Still have questions? Ask the community.

Refund Policy
You can cancel or reschedule your registration without penalty or charge provided you give notice of 10 business days (M-F) or more days before the start of my class.

If you request to cancel or reschedule your registration 10 Business Days (M-F) or less days before the class start you will be charged 100% the course fee and will not be entitled to a refund. You have one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

You cannot change your class location ten (10) Business days (M-F) or less before the class start because Certified Staffing Solutions has shipped training materials and provisioned resources. Location changes requested prior to that timeframe are subject to availability and may incur an additional charge.

Should Certified Staffing Solutions need to cancel your class due to insufficient enrollment, or postpone it due to events beyond their control, Certified Staffing Solutions will notify you as soon as possible. In such cases, you may reschedule to a future class date at no additional charge or receive a refund for any money on account relating to that registration.

Travel arrangements and costs are the sole responsibility of the student. Certified Staffing Solutions suggests obtaining refundable reservations. Certified Staffing Solutions classes are confirmed approximately 14 days before the start of the class. We cannot guarantee class commitments before that window of time. Certified Staffing Solutions will not be responsible for any cancellation costs incurred, including but not limited to, airline/mass transit tickets, hotel reservations and so on.

Map

Google Map

Certstaffix Training

All classes at this location

Start Dates (3)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm Remote Instructor 1 $620
10:00am - 5:00pm Remote Instructor 1 $620
10:00am - 5:00pm Remote Instructor 1 $620

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 6200 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Certstaffix Training (22)

Similar Classes

School: Certstaffix Training

Certstaffix Training

Certified Staffing Solutions specializes in providing computer training and instructors nationwide. Our instructors are professional trainers and utilize hands-on exercises to reinforce lecture. Each averages more than 5 years delivering classes to business professionals.

Our Advantages

  • Our Instructors:...

Read more about Certstaffix Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DC educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.