Online Service and Data Connections
Advanced Data Connections
Explore some of Power BI’s more advanced connectivity features. In this course you’ll learn how to connect to external sources, whether that’s connecting to a database in Power BI Desktop or importing Excel files for analysis in the Power BI online service. Please note that some of the content covered in this course requires a Power BI Pro license.
Advanced    11 Lessons    120 Minutes    CPD Credits
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
4. Creating the Visualization
5. Connecting to the Dataverse
6. Importing Excel Data
Read More
7. Using Analyze in Excel
8. Creating a PivotTable
9. Using the Performance Analyzer
10. Installing a Data Gateway
11. Scheduling Data Refreshes
Learning Certificates
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.
