$632.39

Excel Power Tools - Virtual Training (1 day)

Actions and Detail Panel

$632.39

Event Information

Share this event

Date and time

Location

Location

Training Room

123 Slater Street

Ottawa, ON K1P 5G4

Canada

View Map

Refund policy

Refund policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Event description
Create data models and build interactive report with Power Pivot. Automate your report update process using the Power Query Editor.

About this event

Virtual Training - LIVE Instructor

Groups limited to 3 participants.

Interact with instructor using a webconferencing interface: share screen and mouse control to resolve issues.

INQUIRE FOR A CUSTOM SCHEDULE with julie.foucault@daxel.ca .

Microsoft Certified Professional

Our Ottawa-based instructor is certified by Microsoft, as a skilled professional in Business Intelligence Reporting. Read more.

Target Audience

Analysts, Accountants, Report Builders

Course Learning Outcomes

  • Transform data with Power Query Editor
  • Model Data in Power Pivot environment
  • Create Measures and Calculated Columns with DAX functions
  • Build interactive reports with charts, tables and slicers

Technical Requirements for EXCEL Online Course

Participant must have access to 2 screens: using a laptop and a monitor is adequate.

Participant must install free app, Zoom, on his/her computer and enable Excel add-ins for Power Query and Power Pivot.

Quality Service

During this virtual course on Power BI, the participant is guided through practical exercises. Participant's desktop can be shared with the instructor to resolve issues.

All dates are guaranteed to run. Session may be private!

Detailed Course Outline

1. Master the basic workflow

  • Import data from different sources
  • Transform data in Power Query
  • Load data to Data Model
  • Define data default format setting in Power Pivot environment
  • Create relationships between data tables in Power Pivot
  • Create a PivotTable
  • Create a PivotChart
  • Create a slicer

2. Review the report’s update process

  • Periodic Update process: click Refresh All
  • Cyclical Update process: edit Data Source Settings…

3. Add complexity to the basic workflow

  • View the impact of wrong relationships on a Pivot Table
  • Understand the concept of context in a Pivot Table or PivotChart
  • Create inactive relationships between data tables in Power Pivot
  • Create Measures
  • Use DAX functions : COUNT, SUM, DIVIDE AVERAGEX, CALCULATE and USERELATIONSHIP
  • Edit a Measure
  • Create a Pivot Table to visualize a measure
  • Create Calculated Columns in Power Pivot environment
  • Use a calculated column in a Pivot Table as a Row field
  • Format a report
  • Name charts and tables

Learn more about us, visit www.daxel.ca, Power BI Expert in Ottawa.

Browse other Power BI training offers by Daxel in Gatineau - Ottawa.

Daxel may also be contacted to schedule a private EXCEL or Power BI training for your organization in Gatineau - Ottawa, Toronto, Montreal and surroundings.

FAQs

How can I contact the organizer with any questions?

Email at julie.foucault@daxel.ca or text/call 819-635-6564

What's the refund policy?

Refunds up to 7 days before event, Eventbrite's fee is nonrefundable.

Can I update my registration information?

Email any changes at julie.foucault@daxel.ca

Is my ticket transferrable?

Yes. Email request at julie.foucault@daxel.ca

Is it ok if the name on my ticket or registration doesn't match the person who attends?

Yes.


		Excel Power Tools - Virtual Training (1 day) image
Share with friends

Date and time

Location

Training Room

123 Slater Street

Ottawa, ON K1P 5G4

Canada

View Map

Refund policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

{ _('Organizer Image')}

Organizer Daxel

Organizer of Excel Power Tools - Virtual Training (1 day)

Save This Event

Event Saved