Advanced data connections

Summary

In this course, you’ll learn how to work with the sort of complicated data sources that you’ll encounter in the real world, such as databases. You’ll also learn how to keep the data in Power BI up to date, so that your reports update automatically when the data changes. You’ll apply key concepts through case-study style learning, with concise lessons & applied assessments.   Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suited to intermediate level learners with an understanding of how to connect simple data sources to Power BI. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to expand their knowledge of connecting data sources to Power BI.

Course Overview

This Kubicle course contains 9 lessons, 2 exercises and 1 Exam. It covers the following topics:

  • Connecting to a Database
  • Selecting Data from a Database
  • Creating a Visualization from Database Data
  • Importing data from Excel to the Power BI service
  • Using Analyze in Excel
  • Creating a PivotTable using Analyze in Excel
  • Installing a Data Gateway
  • Scheduling Data Refreshes

Key Outcomes

Once you’ve completed this course, you’ll have a better understanding of how more advanced data sources can be connected to Power BI. In particular, you’ll be able to work with databases, and keep your data up to date. The skills you’ll learn in this course will help you work more effectively when you want to analyze data that comes from a more complicated source than a simple Excel file.