Power BI - Create Compelling Interactive Reports

1. Introduction 00:0
2. Excel File - Sales Data 00:06:57
3. Starting Power BI Desktop 00:08:36
4. Get Data 00:11:18
5. Sales Report File 00:13:45
6. Report Example 00:15:14
7. Building Visuals 00:17:49
8. Creating A Simple Report 00:20:56
9. Creating A Pie Chart 00:22:03
10. Adding A Column Chart 00:26:27
11. Sharing The File 00:35:00
12. Power BI Desktop 00:37:17
13. Opening A .PBIX File 00:39:31
14. Table View 00:40:26
15. Power BI Website - Publishing & Sharing The Report 00:41:34
16. Power BI Website - Creating A Workspace 00:43:15
17. Power BI Website - Sharing The Report 00:46:08
18. Power BI’s and ERP’s 00:52:13
19. Creating Addtional Columns 00:54:41
20. Republishing 01:01:25
21. Excel vs. Power BI 01:02:00
22. Power BI Dashboard Card 01:05:34
23. Interactive Visuals 01:12:42
24. Power BI Measures 01:15:08
25. Linking Data In The Model View 01:17:35
26. Power BI Desktop - Creating Data Sets and Connections 01:20:10
27. Power Query Editor 01:23:51
28. Creating A Connection Between Tables 01:27:01
29. Using The Connection Between Tables 01:31:51
30. Formatting 01:34:19
31. Speaker Contact Details And Closing 01:38:08
32. Presentation Closing 01:38:36

• 

  Mike Thomas

  Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support t [...]

  View Full Profile

• .CSV 00:08:14, 01:18:33
• .PBIX 00:09:59, 00:35:39, 00:39:34, 00:42:31, 00:47:48
• Bar Chart 00:15:28, 01:02:17
• Column 00:14:27, 00:18:09, 01:05:40, 01:10:41, 01:21:58, 01:36:05
• Column Chart 00:26:44, 00:55:00, 00:59:08, 01:09:29, 01:32:02
• Column Headings 00:58:31
• Filter 0:52:11, 01:13:07
• Formula 00:58:48
• PDF 00:06:52, 00:28:04, 01:18:31
• Pie Chart 00:15:29, 00:22:05, 01:02:18, 01:14:03
• Power BI 00:00:07, 00:04:34, 00:08:21, 00:15:05, 00:20:32, 00:34:26, 00:43:30, 01:02:01, 01:06:06, 01:18:11
• Power BI Dashboard Card 01:05:34
• Power BI Desktop 00:02:59, 00:08:37, 00:24:50, 00:37:07, 00:48:04
• Power BI Measure 01:15:09
• Power BI Workspace 00:43:29
• Power Query Editor 01:23:52
• Refresh 01:10:31
• Row 00:07:05, 00:13:20,  01:24:49
• Slicer 00:59:51
• Table 01:29:07, 01:31:50
• Text Files 00:08:14
• Workbook 00:11:14

.CSV: Comma-Separated Value files are text files where each field of data is separated by a comma. This is an effective means to export data from QuickBooks that you, in turn, wish to analyze in Excel.

.PBIX: The file extension for Power BI files is “.pbix”. The .pbix files are highly compressed file types that contain all the graphics along with the actual data.

Bar Chart: A bar chart (also called a bar graph) is a great way to visually display certain types of information, such as changes over time or differences in size, volume, or amount. Bar charts can be horizontal or vertical; in Excel, the vertical version is referred to as a column chart.

Column: A column is a vertical series of cells in a chart, table, or spreadsheet in Excel.

Column Chart: A column chart is a graphic representation of data. Column charts display vertical bars going across the chart horizontally, with the values axis being displayed on the left side of the chart.

Column Headings : The column heading or column header is the gray-colored row containing the letters (A, B, C, etc.) used to identify each column in the worksheet. The column header is located above row 1 in the worksheet.

Combo Chart: A combo chart in Excel is a chart that displays multiple sets of data in different ways on the same chart. For example, you may want to combine a bar graph with a line graph in the same chart.

Filter: The Filter feature in Excel allows you to show or hide rows within a list of data by making selections from drop-down lists. The Filter feature is available on the Data tab of all versions of Excel as well under the Sort & Filter command on the Home menu.

Formula: A formula is an expression which calculates the value of a cell.

PDF: Portable Document Format, a universal document format created by Adobe that allows cross-platform compatibility of documents.

Pie Chart: A pie chart is a circular representation that reflects the numbers of a single row or single column of Excel. The individual numbers are called data points (or categories) and a list (row or column) of numbers is called a data series.

Power BI: Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform

Power BI Dashboard Card: The Power BI Dashboard card allows organizations to display dashboards from the Microsoft Power BI visualization tool, which includes various custom data visualization charts.

Power BI Desktop: Power BI Desktop is a free application you install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model.

Power BI Measures: Power BI measures are the way of defining calculations in a DAX model, which helps us to calculate values based on each row. But rather, it gives us aggregate values from multiple rows from a table.

Power BI Workspace: Workspaces are created on capacities. Essentially, they are containers for dashboards, reports, workbooks, datasets, and dataflows in Power BI. There are two types of workspaces: My workspace and workspaces. My workspace is the personal workspace for any Power BI customer to work with your own content.

Power Query Editor: Power BI Desktop also comes with Power Query Editor. Use Power Query Editor to connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.

Query: A database query extracts data from a database and formats it in a readable form. A query must be written in the language the database requires; usually, that language is Structured Query Language (SQL). For example, when you want data from a database, you use a query to request that specific information.

Refresh: The Refresh command appears on the Options tab of Excel 2007 and 2010 as well as the Analyze tab of Excel 2013. Pivot tables store a snapshot of the underlying source data, so they don’t immediately reflect changes to said data. You must periodically refresh any pivot table to ensure it reflects any changes to the source data.

Row: A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. Rows are identified by numbers e.g. row 1, row 5. Examples of use. A row might contain the headings of a table e.g. product ID, product name, price, number sold.

Slicer: You can insert slicers in Excel to quickly and easily filter pivot tables. Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click

Table: A table is an arrangement of data in rows and columns, or possibly in a more complex structure. Tables are widely used in communication, research, and data analysis. Tables appear in print media, handwritten notes, computer software, architectural ornamentation, traffic signs, and many other places.

Text Files : Raw data files that often have file extensions such as .TXT or .CSV. TXT files are sometimes tab-delimited (meaning each field is separated by a tab character) while CSV files are comma-delimited.

Workbook: In Microsoft Excel a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.