Business Intelligence with Excel

BI - Using collective intelligence with Excel

• Presentation of the individual BI components.
• The pivot table, the ETL tool Power Query and the data model in Power Pivot.
• Get to know and understand the added value of the power tools in Excel.
• Format data as a table and evaluate with pivot table incl. data slices.
• BI terms such as dimensions, facts, measures, etc. explained in an understandable way.
• Outlook on Power BI.

Power Query - Retrieve and transform data

• Importing data - the query editor.
• Create and reuse queries for modeling data once.
• The most important transformation steps: Delete rows, split columns, filter rows, ...
• Merge data from multiple files and multiple file types.
• Unpivot data.

Power Pivot - fast and advanced data analysis and visualization

• Create table relationships.
• Compress data. 
• Data analysis with interactive dashboards.
• Practical example: target/actual comparison.

Practical application

• Create data models.
• Create reports and dashboards.
• Data analysis and visualization.

Please bring your own laptop to the training . You can find more detailed installation instructions under Methods.