Power BI - Advanced Data Connections

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

1. Connecting to a Database
2. Selecting Relevant Data
3. Working with Database Data
4. Creating the Visualization
5. Connecting to the Dataverse
6. Importing Excel Data
7. Using Analyze in Excel
8. Creating a PivotTable
9. Using the Performance Analyzer
10. Installing a Data Gateway
11. 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.

Contact us

If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930

Note for Legacy CPA Members

Members who joined Chartered Accountants Ireland following1 September 2024, please continue to book on the CPA Portal here to ensure you receive your member discount.