Booking Information
Once you have booked your course, you will receive a
confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland
Portal within the Kubicle site
About this course
Databases
are a common feature of data analysis projects, however, working with such large
datasets need not be limited to database administrators. In this course you’ll
learn the basic tools for connecting databases to your workspace in Power
BI.
You’ll step through the process of connecting an online database to Power BI
Desktop. Similarly, you’ll learn how to connect an Excel sheet to the Power BI
online service. As you progress, you’ll develop an appreciation of the
differences between the online and desktop versions of Power BI.
By the end of this course, you’ll be ready to connect your workspaces to
external data sources, significantly boosting he size and scale of your data
analysis projects.
Learning Outcomes
- Connect
to a database in Power BI Desktop
- Import
Excel data to the online service
- Use
the Analyze in Excel feature
- Analyze
the performance of your reports
- Install
a data gateway
- Set
up scheduled data refreshes
Lessons
- Connecting to a Database
- Selecting Relevant Data
- Working with Database Data
- Creating the Visualization
- Connecting to the Dataverse
- Importing Excel Data
- Using Analyze in Excel
- Creating a PivotTable
- Using the Performance Analyzer
- Installing a Data Gateway
- Scheduling Data Refreshes
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
LOADING...