O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Getting Started with Microsoft Power BI

Video Description

Power BI is a new software product from Microsoft that helps you find meaning in your data. It's used to take in, transform, analyze, and visualize data in new and exciting ways.

Microsoft Power BI produces actionable business intelligence in the form of reports, visualizations, and dashboards that can be shared with your colleagues anywhere in the world. Understanding Power BI is fast becoming a job skill that is just as important as knowing Word and Excel: This course shows you the way.

  • Gain valuable experience using Microsoft Power BI Desktop
  • Learn how to create data derived visualizations, reports, and dashboards
  • Discover how to install the software, import data, and create meaningful visualizations
  • Learn to load any type of data and combine with data from other sources
  • Explore data modeling and the need for consistent relationships among data sources
  • Understand how to visualize and report your data in multiple ways
  • Learn how to upload your reports to the cloud and share them with anyone, anywhere
Allen G. Taylor is a writer, educator, and data engineer who has worked in the database field for more than 20 years. Formerly with the Electrical and Computer Engineering Department at Portland State University in Portland, Oregon, Allen has authored over 40 technology books, including the best sellers "SQL for Dummies" and "Database Development for Dummies".

Table of Contents

  1. Introduction
    1. Welcome To The Course 00:01:59
    2. About The Author 00:01:12
    3. How To Access Your Working Files 00:01:15
  2. Getting Started
    1. Data, Data, Everywhere 00:02:05
    2. A Picture Is Worth Much More Than A Thousand Words 00:01:56
    3. Turning Raw Data Into Actionable Intelligence 00:01:26
    4. Power To The People (DIY BI) 00:02:03
    5. Power BI Desktop And Power BI In The Cloud 00:03:54
  3. Getting Data
    1. Installing Power BI Desktop 00:02:52
    2. Importing Data 00:03:35
    3. Creating a Simple Visualization 00:05:06
  4. Transforming Data
    1. Transforming Data From A Single Source 00:06:13
    2. Combining Data From Different Sources 00:06:09
    3. More Transformations 00:06:30
  5. Building Models
    1. Creating A Model Of Your Data 00:04:43
    2. Creating Relationships Manually 00:03:50
    3. Creating Calculated Columns 00:05:12
    4. Using Measures 00:04:16
    5. Dealing With Dates And Times 00:07:09
  6. Visualizations
    1. Text-Based Visualizations 00:05:47
    2. Stacked Bar Chart 00:06:19
    3. Clustered Bar And Column Charts 00:02:14
    4. Line Chart And Stacked Column Chart, Line Chart And Clustered Column Chart 00:04:20
    5. Area Charts 00:03:41
    6. Waterfall Chart And Scatter Chart 00:02:37
    7. Pie Chart, Donut Chart, Treemap, And Funnel Chart 00:02:41
    8. Map And Fill Map Charts 00:01:51
    9. Gauge Chart And KPI 00:04:25
    10. Filtering Data With The Filters Pane 00:03:45
    11. Slice And Dice A Visualization 00:02:46
    12. Interacting Visualizations 00:02:39
    13. Dashboards 00:02:02
  7. Publishing And Sharing
    1. Publishing Reports 00:02:07
    2. Sharing Dashboards 00:03:49
    3. Power BI Mobile 00:00:53
  8. Wrap Up And Thank You
    1. Wrap Up And Thank You 00:01:07