Advanced Data Connections
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Connecting to a Database
Connecting to a Database
Databases are common in most businesses, but connecting to them can be more difficult than connecting to simple files. In this lesson, we'll learn how to connect to a PostGreSQL database hosted online.
Selecting Relevant Data
Selecting Relevant Data
Having connected to the database, in this lesson, we'll identify the tables that we want to add to the data model. We'll also discuss the benefits of a data dictionary in navigating a database like this.
Working with Database Data
Working with Database Data
Data from a database is often not as user-friendly as you would like. In this lesson, we'll see how we can use the Query Editor to clean the data and make it easier to understand and analyze.
Creating the Visualization
Creating the Visualization
With our dataset in a proper format, we can start creating visualizations in Power BI Desktop. In this lesson, we'll create a line chart that tracks sales for a particular category of pharmaceutical products over time.
Connecting to the Dataverse
Connecting to the Dataverse
The Dataverse is a cloud system developed by Microsoft for storing your company's data. In this lesson, you'll learn how to connect to this data and use it in your Power BI visualizations.
Importing Excel Data
Importing Excel Data
In this lesson, we'll learn how to connect an Excel sheet directly to the Power BI service. We'll see how to create a report in the service, instead of Power BI Desktop, and discuss the difference in features between the two.
Using Analyze in Excel
Using Analyze in Excel
Analyze in Excel lets you export data from the Power BI service into Excel, where you can analyze it using an Excel PivotTable. We'll see how to do this in this lesson.
Creating a PivotTable
Creating a PivotTable
Creating a PivotTable in Excel is slightly different when the data has come from Power BI. In this lesson, we'll see what you need to be aware of when using Analyze in Excel,
Using the Performance Analyzer
Using the Performance Analyzer
Very large Power BI models can occasionally develop speed and performance issues. You can understand the speed and performance of a data model using the Performance Analyzer tool, which is demonstrated in this lesson.
Installing a Data Gateway
Installing a Data Gateway
When the data source updates, it can be useful to have your reports and dashboards update automatically. You can do this in the Power BI service by installing a data gateway, which we'll do in this lesson.
Scheduling Data Refreshes
Scheduling Data Refreshes
With a data gateway installed, we can set up scheduled refreshes to update our data at an appropriate frequency. We'll see how to do this in this lesson.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
