Course Content
Getting Started with PowerBI Getting Started with PowerBI by navigating through the PowerBI environment
Draft Lesson
00:00
Importing Data from excel This lesson we will learn how to import data from excel to PowerBi
Importing Data From Excel
00:001.3 IMPORTING CSV_ TEXT DATA
00:00GETTING DATA FROM A WEB PAGE
00:001.5 IMPORTING DATA FROM DATABASE
00:00Introduction to PowerBI
Data Transformation Data transformation is a critical step in the data preparation process when working with Power BI, a powerful business intelligence tool developed by Microsoft. 1. Power Query Editor: Power Query Editor is the data transformation tool within Power BI.
It provides a user-friendly, graphical interface for shaping, cleaning, and enhancing your data before analysis.
2. Data Transformation Steps: Filtering: Remove unwanted rows or columns from your dataset based on specific criteria.
Sorting: Arrange data in ascending or descending order.
Merging: Combine data from multiple tables or sources using various join operations.
Grouping: Aggregate data by categories or attributes.
Pivoting/Unpivoting: Reshape data from wide to tall format or vice versa.
Data Type Conversion: Change data types (e.g., text to numbers).
Renaming: Rename columns for clarity.
Adding Custom Columns: Create calculated columns using Power Query's M formula language.
2.0 POWER QUERY EDITOR
00:002.1 BASIC DATA TRANSFORMATIONS
00:002.2 USE FIRST ROW AS HEADERS
00:002.3 REMOVE COLUMNS
00:002.4 CHANGE COLUMN DATA TYPE
00:002.5 ADD COLUMN FROM EXAMPLES
00:00
Student Ratings & Reviews
No Review Yet