Intertech
Intertech Logo

Power BI for Excel 2016 -Level 1 -Report Builders 

  • Offered byIntertech

Power BI for Excel 2016 -Level 1 -Report Builders
 at 
Intertech 
Overview

Take the first of several courses an Advanced Power BI Designer would require

Duration

1 day

Start from

12th Dec'30

Mode of learning

Online

Schedule type

Self paced

Credential

Certificate

Power BI for Excel 2016 -Level 1 -Report Builders
 at 
Intertech 
Highlights

  • This course lays the foundation for all Power BI for Excel Designers
Details Icon

Power BI for Excel 2016 -Level 1 -Report Builders
 at 
Intertech 
Course details

Skills you will learn
What are the course deliverables?
  • PowerPivot Key Features
  • The Self-Service BI Model
  • Defining a Report
  • Data-Driven Storytelling
  • Creating PowerPivot PivotTables
  • Creating PowerPivot PivotCharts
More about this course
  • This is the first course in the Power BI for Excel 2016 training series
  • 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

Power BI for Excel 2016 -Level 1 -Report Builders
 at 
Intertech 
Curriculum

Introducing PowerPivot

What Is PowerPivot?

PowerPivot Key Features

The Self-Service BI Model

PowerPivot Components

Defining a Report

What is a PowerPivot Report?

Defining a Report

Data-Driven Storytelling

Understanding PowerPivot Data

Data Terminology

Understanding Tables

Understanding Relationships

Diagnosing Data Models

Data Model Schemas

Create Reports using PowerPivot Data

Making Changes to PowerPivot Data

Creating PowerPivot PivotTables

Creating PowerPivot PivotCharts

Creating Slicers

Graphing Data

Understanding PowerPivot Functions

Calculated Columns

What is DAX?

Understanding DAX Functions

Common DAX Functions

Dates and Date Functions

Power BI for Excel 2016 -Level 1 -Report Builders
 at 
Intertech 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Power BI for Excel 2016 -Level 1 -Report Builders
 at 
Intertech 
Admission Process

    Important Dates

    Dec 12, 2030
    Course Commencement Date

    Other courses offered by Intertech

    1.35 L
    3 days
    – / –
    2.08 L
    3 days
    Intermediate
    View Other 1 CoursesRight Arrow Icon
    qna

    Power BI for Excel 2016 -Level 1 -Report Builders
     at 
    Intertech 

    Student Forum

    chatAnything you would want to ask experts?
    Write here...