Data Analysis using Excel Level 1: Report Builders

This Data Analysis Using Excel course lays the foundation for all Power BI for Excel Designers. It is the first of several courses an Advanced Power BI Designer would require. Power BI Report Writers will learn everything they need to create highly effective PivotTable and PivotChart reports using data models created by more advanced Power BI Designers. Topics covered include an overview of the PowerPivot add-in, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, and creating simple custom data calculations.

• Excel levels 1 & 2, including PivotTable & Pivot Chart skills
• A basic understanding of database concepts

Data Analysis using Excel Level 1: Report Builders Delivery Methods

• Microsoft Official Course content
• Eligible for SATV redemption

Data Analysis using Excel Level 1: Report Builders Course Benefits

• Introducing PowerPivot
• Defining a Report
• Understanding PowerPivot Data
• Create Reports using PowerPivot Data
• Creating PowerPivot Functions

Data Analysis Using Excel Course Outline