Transforming and Modelling Data Using Power BI Desktop

Complementing Creating Reports Using Power BI Desktop, this course focuses on the preparation of data using the Data Query Editor and Power BI Desktop.  We will use real housing examples to show how to pull together a variety of data sources and prepare them for use in data analysis and report building. 

Two half-day sessions will cover:  

Power Query Editor: loading data, text, numerical and date tools, merging and appending, pivot and unpivot, refreshing data.

Calculated Fields Using DAX: calculated columns, measures, filter context, DAX functions and syntax. 

Data Modelling: star and snowflake schemas, primary and foreign keys, creating and managing relationships, filter flow. 

Who is this course for? The course is aimed at staff responsible for collating data ready for analysis. These may be database specialists within the IT team or advanced data analysts. 

Entry requirements: The course requires good all-round IT skills. Database experience is not essential, as the basics will be covered in the course, but SQL expertise would make it easier to grasp some of the concepts. A good understanding of housing measures, such as those in the Sector Scorecard would also be beneficial, but not essential.

2021 dates

MONDAY 22 AND TUESDAY 23 MARCH - BOOK YOUR PLACE SOLD OUT

MONDAY 24 AND TUESDAY 25 MAY - BOOK YOUR PLACE 

MONDAY 4 AND TUESDAY 5 OCTOBER - BOOK YOUR PLACE 

Price

 £375+VAT each (HouseMark members)

£450+VAT each (Non-members) 

Access the full 2021 Data Training prospectus here. 

Subscribe to our newsletters

Subscribe below to get regular updates from Housemark

Latest Tweets

Latest tweet

hasRole=False

leadValue=False

showPopup=False

totalGroups=0

loginStatusModel.IsLoggedIn=False

  1. id: 12586
  2. name: Transforming and Modelling Data Using Power BI Desktop
  3. item type: Content
  4. template alias: FullWidthSlim
  5. created data: 02/02/2021 15:15:19
  6. Document Type Alias: Page
  7. Path: -1,1101,1099,12586
  8. Last Render: 20/04/2021 13:27:46