From Excel to Power BI
- Offered byCoursera
From Excel to Power BI at Coursera Overview
Duration | 3 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
From Excel to Power BI at Coursera Highlights
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Beginner Level At least basic understanding of data analysis in Excel
- Approx. 3 hours to complete
- English Subtitles: English
From Excel to Power BI at Coursera Course details
- Are you using Excel to manage, analyze, and visualize your data? Would you like to do more? Perhaps you've considered Power BI as an alternative, but have been intimidated by the idea of working in an advanced environment. The fact is, many of the same tools and mechanisms exist across both these Microsoft products. This means Excel users are actually uniquely positioned to transition to data modeling and visualization in Power BI! Using methods that will feel familiar, you can learn to use Power BI to make data-driven business decisions using large volumes of data.
- We will help you to build fundamental Power BI knowledge and skills, including:
- Importing data from Excel and other locations into Power BI.
- Understanding the Power BI environment and its three Views.
- Building beginner-to-moderate level skills for navigating the Power BI product.
- Exploring influential relationships within datasets.
- Designing Power BI visuals and reports.
- Building effective dashboards for sharing, presenting, and collaborating with peers in Power BI Service.
- For this course you will need:
- A basic understanding of data analysis processes in Excel.
- At least a free Power BI licensed account, including:
- The Power BI desktop application.
- Power BI Online in Microsoft 365.
- Course duration is approximately three hours. Learning is divided into five modules, the fifth being a cumulative assessment. The curriculum design includes video lessons, interactive learning using short, how-to video tutorials, and practice opportunities using COMPLIMENTARY DATASETS. Intended audiences include business students, small business owners, administrative assistants, accountants, retail managers, estimators, project managers, business analysts, and anyone who is inclined to make data-driven business decisions. Join us for the journey!
From Excel to Power BI at Coursera Curriculum
From Excel to Power BI
Course Introduction and Objectives
Overview of Power BI
Lesson: Understand Power BI Licenses
Lesson: Understand Data Importation and the Data View
Overview of the Data View in Power BI
Import a File from Excel
Use Get Data to Connect to Data Sources
Try a Sample Dataset from Power BI Desktop
Lesson: Clean and Transform Data
Access the Power Query Editor
Overview of the Applied Steps List in Power Query Editor
Execute Basic Math Operations to a Column
Replace Errors in a Column
Lesson: Introduction to Data Modeling, Report View, and Visualizations
View Relationships in the Model View
Edit or Remove Relationships
Add a New Relationship Between Tables and Columns
Lesson: Understand the Report View
Overview of the Report View in Power BI
Add a Visualization
Overview of Format Features for Visualizations
Change the Visualization Type
Lesson: Understand Text Visualization Types
Create a Visualization Card
Create a Table Visualization
Create a KPI Chart
Create a Key Influencers Chart
Lesson: Intro to Chart Visualizations
Create a Scatter Chart
Create a Waterfall Chart
Create a Funnel Chart
Create a Ribbon Chart
Lesson: Filters, Slicers, and Data Drilling
Create a Slicer
Analyze Your Visualization
Drill Down and Drill Up in a Visualization
Lesson: Introduction to Power BI Service
Publish a Dataset or Report
View My Workspace in the Power BI Service
View Workspaces in the Power BI Service
Overview of Dashboards
Create a New Dashboard
Add a Tile to a Dashboard
Pin a Tile from a Report
Subscribe to a Power BI Dashboard
Share a Report Via Email
Share a Report To a Teams Channel
Export a Report to PowerPoint
STOP: Retrieve a Course Sample Dataset
Congratulations!
Quiz: Understand Power BI
Quiz: Lesson 1 Review
Quiz: Lesson 2 Review
Quiz: Lesson 3 Review
Quiz: Lesson 4 Review
Final Test
From Excel to Power BI at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?