- Introduction
-
Welcome
-
Prerequisites
-
User story
- Getting the data
-
Connecting to CDF
-
Using the Power Query Editor
-
Steps for using the Power Query Editor
-
Check your knowledge
- Visualizing the data
-
Exploring the data
-
Steps for exploring the data
-
Measures and columns
-
Adding the gas to energy ratio
-
Steps for adding the gas to energy ratio
-
Check your knowledge
- Summary
-
Key takeaways
-
Reflections
-
Share your feedback
CDF & Power BI: Solving a Use Case
Solve a simple use case with the Cognite Power BI Connector.
Welcome to CDF & Power BI: Solving a Use Case!
This course walks you through solving a simple use case in Power BI with data from CDF. You will connect Power BI to CDF, use the Power Query Editor, and work with relationships between tables, and visualize the data.
The course requires hands-on work in Power BI so make sure to consult the prerequisites before you start.
After completing this course, you will be able to:
- Use the Power query editor to retrieve data.
- Work with data and relationships between time series and data points.
- And finally, visualize data and create a report by using Data Analysis Expressions (DAX).
Who should take this course?
Power BI users who want to be guided to gain hands-on experience with working with CDF.
Instructor
Cognite Academy has developed this course.
Scott Melhop
Senior Analytics Architect
Knowledge prerequisites
We recommend this course for intermediate Power BI. Before starting this course, please make sure to complete Introduction to CDF & Power BI course.
Technical prerequisites
You will need the Power BI application to follow along with the course. You can download it here. Note that you need the November 2021 version (or later) of Power BI Desktop. To automatically stay updated with the latest version, download Power BI Desktop from the Microsoft Store. Power BI is currently only supported for Windows.
If you use a Mac, you will need to run Windows on your computer with the help of a virtual machine or parallel like Boot Camp.
In this course, you will be alternating between two windows: this e-learning course and Power BI. Therefore we suggest using two screens if possible to make switching windows easier.