PL-300: Preparing Data for Visualizations in Power BI

Microsoft Power BI    |    Beginner
  • 12 videos | 1h 51m 18s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 459 users Rating 4.5 of 459 users (459)
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

  • 3m 19s
  • 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 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: Maps, Waterfall Charts, & Scatter Plots in Power BI
Rating 4.5 of 83 users Rating 4.5 of 83 users (83)
Course PL-300: Understanding Data Visualization
Rating 4.5 of 407 users Rating 4.5 of 407 users (407)
Course PL-300: Working with Filters in Power BI
Rating 4.4 of 115 users Rating 4.4 of 115 users (115)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Rating 4.6 of 1028 users Rating 4.6 of 1028 users (1028)
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: Matrix & Treemap Controls in Power BI
Rating 4.6 of 81 users Rating 4.6 of 81 users (81)