Prepare and format data

• Understand and use styles to format efficiently.
• Structure your table into a database.

Clean and transform data

• Connect to a variety of data sources: CSV, Excel, PDF, Web, SQL, SharePoint, etc.
• Control the data quality and data type.
• Rearrange data and transformation steps.
• Produce a calculated column.
• Create query references and duplicates.
• Merge columns.
• Create indices.
• Add conditional results.
• Create a column based on a transformation algorithm.
• Use parameters and functions.
• Document the steps and structure the queries.

Create a Star Model

• Normalize queries.
• Merge queries.
• Create and set up relationships between tables.
• Manage a hierarchy.
• Add a simple measure.

Synthesize data with a Pivot Table

• Create and transform a Pivot Table.
• Set up a Pivot Table and configure its display.
• Calculate aggregate values.
• Sort, filter, and apply conditional formatting in a Pivot Table.

Visualize data with a chart

• Create and set up a chart.
• Change the appearance of a chart.
• Adapt source data.
• Use chart templates.
• Create a pivot chart.

Design a dashboard

• Embed sparkline graphs.
• Apply filters with segments and timelines.
• Combine visuals (pivot tables, charts, and filters) into an analytical dashboard.

Intermediate – 2 Days

990€ face-to-face

890€ remotely

Prices are without Tax.

Get in touch with us to schedule this Power Query and Power Pivot course or for a quote if you are interested in organizing this training within your company.