Data Preparation and Processing: Preparing Data for Visualizations in Power BI

Microsoft Power BI 2.96    |    Beginner
  • 12 Videos | 1h 51m 18s
  • Includes Assessment
  • Earns a Badge
A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations. Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows. Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals. Upon completion, you'll be able to prepare data for visualization using a variety of transformations.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    connect to data sources that are related but stored in separate files and load them into Power BI
    use Power BI's column profiling feature to recognize what information is stored in a dataset
    perform a join operation to merge two related tables into a single unit
    load data from multiple separate but related files located in a single directory
    perform aggregations on data in a table to summarize the contents of a dataset
  • apply the M formula language to perform data transformations in Power BI
    filter out unnecessary data by defining row-level filters
    create a basic column chart to visualize data in Power BI
    connect to a relational database in DirectQuery mode
    build a simple column chart from the contents of a Power BI table and distinguish between Import and DirectQuery storage modes in Power BI
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    3m 19s
    UP NEXT
  • Playable
    2. 
    Loading Related Data into Power BI
    9m 28s
  • Locked
    3. 
    Profiling Data in Power Query
    8m 46s
  • Locked
    4. 
    Merging Tables in Power BI
    11m 44s
  • Locked
    5. 
    Combining Data in a Folder Using Power BI
    11m 14s
  • Locked
    6. 
    Performing Aggregate Operations on Data
    11m 40s
  • Locked
    7. 
    Using the M Formula Language in Power BI
    11m 27s
  • Locked
    8. 
    Applying Row-level Filters in Power BI
    12m 21s
  • Locked
    9. 
    Building a Simple Visualization in Power BI
    12m 39s
  • Locked
    10. 
    Loading Data to Power BI with DirectQuery
    10m 15s
  • Locked
    11. 
    Building a Visual with DirectQuery in Power BI
    6m 8s
  • Locked
    12. 
    Course Summary
    2m 18s

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.