Using Power BI with Excel
- Offered byLinkedin Learning
Using Power BI with Excel at Linkedin Learning Overview
Duration | 1 hour |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Using Power BI with Excel at Linkedin Learning Highlights
- Earn a sharable certificate
- 1 exercise file to practice
- 5 quizzes to test knowledge
- Access on tablet and phone
Using Power BI with Excel at Linkedin Learning Course details
- In this course, instructor John David Ariansen shows learners how to combine the power of a familiar tool, Excel, with all the potential of Power BI
- Learners will be able to discover how to conduct power pivots, import data, clean and shape data, and model data to present to stakeholders
- Learners will learn about performing calculations with Data Analysis Expressions (DAX) and visualizing data with the various built-in charts and graphs in Power BI
- By the end of this course, learner will be equipped with new skills to take data analysis to the next level
Using Power BI with Excel at Linkedin Learning Curriculum
Introduction
Transforming and refining your data
Excel vs. Power BI
Power BI desktop vs. Excel
Business intelligence (BI) with Excel
Excel business intelligence add-ons
Business Intelligence with Excel
Pros and cons of Excel
Cleaning data in Excel
Combining data in Excel
Creating calculations in Excel
Visualizing trends in Excel
Power BI Overview
What is Power BI?
Connecting to multiple data sources
Data modeling
Introduction to DAX
Visualizing data
Business Intelligence with Power BI
Connecting to and cleaning data
Creating calculated columns in Power BI
Implicit vs. explicit measures
Building a data model
Data tables vs. lookup tables
Building line graphs
Building bar charts
Building geomaps
Creating a slicer
Creating a dashboard
Conclusion
Next steps
Using Power BI with Excel at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?