$678

Excel - Power Tools (1 day)

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

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

Bring Your Own Device

Each participant must bring his/her laptop with Excel installed. Participant must enable Excel add-ins for Power Query and Power Pivot.

Laptop Rental Available.

Quality Service

This EXCEL training session is limited to 6 attendees to address each participants questions and requests.

The course is delivered at the Ottawa Impact Hub in a comfortable, bright and modern environment. COVID-19 restrictions applied to ensure social distancing.

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

Can I rent a laptop ?

Yes. Email request at julie.foucault@daxel.ca or book online.

Are snacks provided ?

Yes. Tea, coffee and snacks are provided by the organizer.

What's the refund policy?

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

Do I have to bring my printed ticket to the event?

No. Simply bring positive attitude!

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.

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.

Save This Event

Event Saved