PL-300: Loading & Transforming Data in Power BI

Microsoft Power BI    |    Beginner
  • 10 videos | 1h 20m 1s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 830 users Rating 4.7 of 830 users (830)
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

  • 2m 57s
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course PL-300: Power BI for Data Analysis
Rating 4.5 of 1379 users Rating 4.5 of 1379 users (1379)
Course PL-300: An Overview of Data Modeling in Power BI
Rating 4.6 of 227 users Rating 4.6 of 227 users (227)
Course PL-300: Applying the DAX Formula Language in Power BI
Rating 4.6 of 154 users Rating 4.6 of 154 users (154)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Business Reporting: Leveraging Treemaps, Matrices, & Slicers in Power BI
Rating 4.6 of 269 users Rating 4.6 of 269 users (269)
Course PL-300: Using the Power BI Service
Rating 4.4 of 449 users Rating 4.4 of 449 users (449)
Course Getting started in Excel 365
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)