Data Preparation and Processing: Loading & Transforming Data in Power BI

Microsoft Power BI 2.96    |    Beginner
  • 10 Videos | 1h 20m 1s
  • Includes Assessment
  • Earns a Badge
Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data. Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information. Upon completion, you'll be able to load data into Power BI and transform it for analysis.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    download and install Power BI desktop
    connect to and import data from an Excel file into Power BI
    import data from CSV and XML files into Power BI and recall the role of Power Query in transforming the data
    load data from a JSON file into Power BI
  • import data from a relational database and load it into Power BI
    remove unnecessary columns and rows from a data source using Power Query
    modify the types of columns in a table using Power Query
    merge the contents of two related columns in Power Query
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 57s
    UP NEXT
  • Playable
    2. 
    Downloading and Installing Power BI Desktop
    7m 33s
  • Locked
    3. 
    Loading Data from an Excel File into Power BI
    12m 38s
  • Locked
    4. 
    Loading Data from CSV and XML Files into Power BI
    11m 51s
  • Locked
    5. 
    Connecting Power BI to a JSON Data Source
    10m 20s
  • Locked
    6. 
    Connecting Power BI to a SQL Server Instance
    7m 49s
  • Locked
    7. 
    Trimming Data from a Data Source Using Power Query
    7m 56s
  • Locked
    8. 
    Transforming Data Types Using Power Query
    12m 15s
  • Locked
    9. 
    Merging Columns in Power Query
    4m 38s
  • Locked
    10. 
    Course Summary
    2m 3s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE