Data Loading & Visualization in Power BI: Loading Data from Cloud Storage

Power BI 2.12    |    Beginner
  • 12 videos | 1h 28m 38s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Power BI offers robust capabilities to seamlessly retrieve data from various cloud storage services, facilitating efficient integration of cloud-based data into reports and visualizations. It supports connections to popular cloud platforms, including Microsoft Azure Blob Storage, Amazon S3, Google Cloud Storage. In this course, you will learn how to import data into Power BI from BigQuery on the Google Cloud Platform (GCP). You will create a service account with the permissions necessary to access and load data. Next, you will work with S3 buckets on Amazon Web Services (AWS) and create an Identify and Access Management (IAM) user with the credentials necessary to access and work with S3. You will write a Python script to connect to S3 and load and import data into Power BI. You will then access and retrieve data from Azure Blob Storage to load it into Power BI for analysis and use a connection string to authenticate and authorize Power BI to Azure storage. Finally, you will import data by making REST API calls and from embedded HTML in a web page using a Web connector and build visualizations such as pie charts, line charts, treemaps, and area charts in your Power BI report.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Upload data to bigquery
    Load data from bigquery
    Set up a matrix visualization
    Upload data to amazon s3
    Load data from s3 with a python script
  • Visualize data using line chart
    Load data from azure blob storage
    Visualize data using scatter plots
    Load data from an application programming interface (api) into power bi
    Load data from an html page into power bi
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 5s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 6m 41s
    In this video, you will learn how to upload data to BigQuery. FREE ACCESS
  • Locked
    3.  Loading Data from Google BigQuery
    9m 3s
    In this video, find out how to load data from BigQuery. FREE ACCESS
  • Locked
    4.  Visualizing Data Using a Matrix
    7m 5s
    Discover how to set up a matrix visualization. FREE ACCESS
  • Locked
    5.  Uploading Data to S3 and Creating a User with the Right Permissions
    8m 24s
    Find out how to upload data to Amazon S3. FREE ACCESS
  • Locked
    6.  Loading Data from S3 Using a Python Script
    8m 47s
    During this video, discover how to load data from S3 with a Python script. FREE ACCESS
  • Locked
    7.  Visualizing and Customizing a Line Chart
    11m 37s
    Learn how to visualize data using line chart. FREE ACCESS
  • Locked
    8.  Loading Data from Azure Blob Storage
    9m 45s
    Find out how to load data from Azure Blob Storage. FREE ACCESS
  • Locked
    9.  Visualizing Data and Using Drillthrough Filters on Scatter Plots
    6m 12s
    In this video, learn how to visualize data using scatter plots. FREE ACCESS
  • Locked
    10.  Loading Data from an Application Programming Interface (API) Response
    6m 58s
    Discover how to load data from an application programming interface (API) into Power BI. FREE ACCESS
  • Locked
    11.  Loading Data from a Website
    9m 20s
    Find out how to load data from an HTML page into Power BI. FREE ACCESS
  • Locked
    12.  Course Summary
    2m 41s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

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 Microsoft Azure Fundamentals: Managing Storage
Rating 4.6 of 423 users Rating 4.6 of 423 users (423)
Course Data Loading in Snowflake: Unloading Data
Rating 4.8 of 32 users Rating 4.8 of 32 users (32)
Book Azure SQL Hyperscale Revealed: High-performance Scalable Solutions for Critical Data Workloads

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Loading & Visualization in Power BI: Advanced Visualizations
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Working with Scorecards, Dashboards, & Paginated Reports in Power BI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Getting Started with Power Query in Power BI
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)