Data Loading & Visualization in Power BI: Loading Data from Databases

Power BI 2.12    |    Beginner
  • 11 videos | 1h 12m 33s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Power BI offers a seamless and efficient way to connect and retrieve data from databases. It supports a wide range of database systems including, but not limited to, SQL Server, Oracle, MySQL, and PostgreSQL. Users can establish connections to these databases by providing connection details such as server addresses, authentication credentials, and database names. You will start this course by loading files stored in SharePoint into Power BI. You will authenticate yourself to SharePoint from Power BI to access, process, and load data. Then, you'll visualize the data with pie and donut charts. Next, you'll load data from SQL Server into Power BI. You'll discover the difference between the Import mode and the DirectQuery mode. Lastly, you'll import data from a MySQL database, connect to MySQL using root credentials and user credentials, and learn to reset credentials and configure new ones.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Load data into power bi from sharepoint
    Visualize data using pie and donut charts
    Load data from sql server into power bi
    Visualize hierarchical data using treemaps
    Store data using the import mode
  • Store data using the directquery mode
    Connect to mysql from power bi
    Reset cached mysql credentials from power bi
    Create and view an area chart
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 56s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 9m 31s
    Learn how to load data into Power BI from SharePoint. FREE ACCESS
  • Locked
    3.  Visualizing Data Using Pie and Donut Charts
    5m 20s
    Find out how to visualize data using pie and donut charts. FREE ACCESS
  • Locked
    4.  Loading Data from SQL Server
    10m 17s
    Discover how to load data from SQL Server into Power BI. FREE ACCESS
  • Locked
    5.  Visualizing Hierarchy and Proportions Using a Treemap
    8m 8s
    In this video, you will learn how to visualize hierarchical data using treemaps. FREE ACCESS
  • Locked
    6.  Using the Import Mode for Data Storage
    7m 37s
    In this video, discover how to store data using the import mode. FREE ACCESS
  • Locked
    7.  Using the DirectQuery Mode for Data Storage
    7m 59s
    In this video, find out how to store data using the DirectQuery mode. FREE ACCESS
  • Locked
    8.  Connecting to a MySQL Server
    9m 47s
    Learn how to connect to MySQL from Power BI. FREE ACCESS
  • Locked
    9.  Clearing Cached Credentials and Reconnecting with New Credentials
    5m 18s
    Find out how to reset cached MySQL credentials from Power BI. FREE ACCESS
  • Locked
    10.  Visualizing Data Using Area Charts
    3m 51s
    Discover how to create and view an area chart. FREE ACCESS
  • Locked
    11.  Course Summary
    2m 51s
    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 Data Loading & Visualization in Power BI: Loading Data from Cloud Storage
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Book Beginning Power BI for Business Users: Learning to Turn Data into Insights
Course Getting Started with Power Query in Power BI
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting Started with the Power BI Service
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course Data Loading & Visualization in Power BI: Data Modeling
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course PL-300: Understanding Data Visualization
Rating 4.5 of 407 users Rating 4.5 of 407 users (407)