Excel Training – Review the way you Analyze Data with Power Query and Power Pivot
This Power Query and Power Pivot training module can be organized in Luxembourg, Brussels, Paris or anywhere within your offices. It is intended for participants who wish to use the data transformations and modelling features of Excel to build analytical dashboards with automatic updates while relying less on calculated columns. Try it, it is actually not that hard.
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
890€ face-to-face
790€ remotely
Prices are without Tax and per person within a group including different companies.
Get in touch with us to schedule this course focusing on Excel Power Query transformations and Power Pivot modelling or to get a quote for custom content.