Microsoft BI - Excel Tools for Data Analysis
Reference : EX-BI-10
Price : Contact us
Level & Prerequisites :
Duration : 1 day
Basic Excel knowledge
Description
This course provides an overview of Excel’s Business Intelligence features, enabling participants to analyze data efficiently and create insightful reports. It focuses on PivotTables, Power Query, Power Pivot, and data visualization techniques.
Public
Who Should Attend:
Excel users
Business analysts
Reporting professionals
Course objective
Use Excel as a BI tool
Create PivotTables and PivotCharts
Import and transform data with Power Query
Build simple data models with Power Pivot
Apply basic DAX formulas
Design clear and impactful dashboards
Content
Excel BI overview
PivotTables and advanced features
Power Query fundamentals
Power Pivot introduction
Basic DAX
Data visualization best practices