Learning Power BI Desktop

Learning Power BI Desktop
Learning Power BI Desktop
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 28m | 410 MB

Power BI Desktop—the powerful data analysis and visualization software from Microsoft—can help you get more insights from your data, whether that data is stored on your computer or in the cloud. In this course, discover how to leverage this easy-to-use tool to more efficiently model and visualize data. Learn how to connect various data sources, including Excel, databases, and web data sources like Wikipedia. Explore how to search and transform your data using the built-in Query Editor. Plus, instructor Gini von Courter shows how to build and arrange visualizations, create interactive reports, share your work, manage your published files in the Power BI service, and more.

Table of Contents

1 Model and visualize your data with Power BI Desktop
2 What you need for this course
3 Power BI Desktop and other Power BI tools
4 Install Power BI Desktop
5 Launch Power BI Desktop
6 Power BI data sources The basics
7 Connect to a file Excel
8 Connect to a file CSV
9 Connect to databases
10 Connect to a web data source
11 Connect to a SharePoint list
12 Advanced connection types DirectQuery and live connections
13 Open a PBIX file or Excel data model
14 Reduce data with the Query Editor
15 Transform data Filter, set data type, replace values
16 Transform data Unpivot, text and number columns
17 Insert a custom column
18 Append data to a query
19 Add an index column
20 Clean up data
21 Relate tables in your model
22 Merge data
23 Showing and hiding queries
24 Use lookup tables in a data set
25 Using the Power BI report view
26 Create and arrange visualizations
27 Format visualizations and apply themes
28 Create text visuals Cards, table, matrix
29 Create and format chart visuals
30 Use slicers to filter visuals
31 Use filters to filter reports and pages
32 Work with the new Filters pane
33 Add search capabilities with a QA visualization
34 Create a phone layout
35 Create map visualizations
36 Get and use a custom visualization
37 Sharing The basics
38 Upload a PBIX file to the Power BI service
39 Publish from Power BI Desktop
40 Republish a dataset to the Power BI service
41 Set Build permissions for a data set
42 Connect to a live connection
43 Manage published files
44 Next steps