From the course: Using Power BI with Excel
Join today to access over 24,700 courses taught by industry experts.
Excel business intelligence add-ons - Power BI Tutorial
From the course: Using Power BI with Excel
Excel business intelligence add-ons
- [Instructor] There are two features that are positioned between Excel and Power BI and really highlight the two main differences between these tools. These two features are built into Power BI but can be added to Excel as add-ons. The first tool is called Power Query and it focuses on discovering, combining and refining data across a wide variety of data sources. The term query means to retrieve data from a database. This tool accomplishes the task of ETL or extract transform and load, which is a critical step in business intelligence. Essentially, this tool can pull data from various data sources then format it so you're ready to conduct your analysis. ETL is a very manual process in Excel, if you don't have this add-on. Next, you have Power Pivot. Power Pivot enables you to create a data model which is a set of connected data sources. You first need to find a common field in your different data sources, then use…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
