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.