Welcome to TED Learning!

  • 12-07, Binjai 8 Premium SOHO, No. 2 Lorong Binjai, 50450 Kuala Lumpur
  • Phone: +603-2742 1828
  • training@ted.com.my

Power BI Desktop (Level II)

By tedadmin | January 31, 2019
Awesome Image

Awesome Image

This is a follow up course after Fundamentals to Power BI Desktop.

This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power BI. The course covers the core elements needed to get an understanding of what Power BI  can do. You will use more advance Power Query techniques to extract and shape data and then load and build a complex Power Pivot Model, and write more complex DAX formulas and set up interactive reports or Dashboards.

What Will I Learn From This Course?

Transformation

Import, shape, and transform data for business intelligence (BI).

Sophisticated Operations

Create data models & perform more advance calculations with DAXS.

Time

Create and visualize data over a period of time with time intelligence functions.

Dashboard

Create awesome dashboards based on reports in Power BI desktop.

Target Audience

Excel Power Users, data analysts, business analysts, managers, MIS professionals and Business Intelligence Consultants / BI Developers.

 

Pre-requisites

Participants must have some basic knowledge in Power BI desktop, basic working knowledge in Excel Power Query & Power Pivot. Advance Excel users with good knowledge of functions & formulas and Pivot tables may also attend.   

Course Outline

Module 1: Creating Awesome Dashboards

  • Synchronize data across pages.
  • Drilling down to a more focus report.
  • Enhancing visuals with more contextual information.
  • Enhancing reports with conditional formatting

Module 2: Segmenting Data in Reports & Defining Parameters

  • Customised categorising of data.
  • Aggregating data based on values found in the underlying data.
  • Define parameters for flexibility in data loading.
  • Creating report templates.

Module 3: Date Dimension in Power BI

  • Pros & Cons using built using built in date tables.
  • Creating custom date tables with Power Query.
  • Creating custom date tables with DAXS.
  • Shaping Data in Power Query

Module 4: Data Analysis Expressions (DAXS) Language

  • Performing calculations with Columns & Measures.
  • RELATED, DIVIDED, DISTINCTCOUNT functions.
  • Understanding Row Context and Filter Context
  • SUMX, CALCULATE, FILTER, ALL functions.
  • Grouping data with DAXS.
  • Making DAXS more readable.

Module 5: Time Intelligence Functions

  • Functions that return a single date.
  • Functions that return a table of dates.
  • Functions that evaluate expressions over a time period.

Module 6: Relationships in Power BI

  • How relationships works.
  • Both-Directional Relationship in Power BI.
  • Using DAXS to simulate the Both-Directional Relationship.

Module 7: Power BI Tricks – Automated Reports

  • Building A Dynamic Date Table.
  • Filtering Pages Dynamically.
  • Filtering Visuals Dynamically.
  • Dynamic Titles.

Feel Free To Inquire About our Range of Training Course

Previous client that we have conducted training with

The Coffee Bean & Tea Leaf Malaysia
Swis Resources Sdn Bhd
Cypark Resources Berhad