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
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 56sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
9m 31sLearn how to load data into Power BI from SharePoint. FREE ACCESS
-
3. Visualizing Data Using Pie and Donut Charts5m 20sFind out how to visualize data using pie and donut charts. FREE ACCESS
-
4. Loading Data from SQL Server10m 17sDiscover how to load data from SQL Server into Power BI. FREE ACCESS
-
5. Visualizing Hierarchy and Proportions Using a Treemap8m 8sIn this video, you will learn how to visualize hierarchical data using treemaps. FREE ACCESS
-
6. Using the Import Mode for Data Storage7m 37sIn this video, discover how to store data using the import mode. FREE ACCESS
-
7. Using the DirectQuery Mode for Data Storage7m 59sIn this video, find out how to store data using the DirectQuery mode. FREE ACCESS
-
8. Connecting to a MySQL Server9m 47sLearn how to connect to MySQL from Power BI. FREE ACCESS
-
9. Clearing Cached Credentials and Reconnecting with New Credentials5m 18sFind out how to reset cached MySQL credentials from Power BI. FREE ACCESS
-
10. Visualizing Data Using Area Charts3m 51sDiscover how to create and view an area chart. FREE ACCESS
-
11. Course Summary2m 51sIn 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.
