Business Intelligence

A look at Business Intelligence including some of the tools used in Data Analysis; such as Excel Power Tools and Power BI.

This is a long video so please step ahead to the sections that are relevant to you by using the content links below:

Introduction and Definitions of BI

5:53 BI Project steps & responsibilities

10:00 Required Data

11:05 What is a Data Model?

18:58 Common Tools

24:40 Power Query – Get data

34:10 Data Model Manager – Relationships

37:12 Power Pivot

38:05 Data Model Manager – Add Calculated Columns

41:00 Data Model Manager – More Calculated Columns

47:37 Power Pivot – Charts

48:40 Power Pivot – Using Date Fields

51:42 Data Model Manager – Add Measures

59:56 Data Model Manager – More Measures

1:02:45 Power Pivot – Adding Slicers to all Charts

1:09:20 Power Query – Merge Queries

1:14:10 Power View – Setting the Add-ins

1:16:53 Power View – Adding a View in Excel

1:18:04 Power View – Adding a Chart

1:19:03 Power View – Filters

1:21:08 Power View – Slicers

1:23:08 Power View – Maps

1:24:42 Power View – Sharing Reports

1:25:30 Power Maps

1:34:44 Power BI – Desktop

1:25:45 Power BI – Get Data from folder – .csv files only

1:41:27 Power BI – Get Data from Excel Tables

1:42:35 Power BI – Get Data from single text file

1:43:00 Power BI – Relationships

1:45:00 Power BI – Formatting Visualisations

1:46:30 Power BI – Calculated Columns using RELATED

1:48:56 Power BI – Measures

1:52:19 Power BI – Chart Visualisations

1:53:20 Power BI – Date Fields and Timeline Slicers

1:56:05 Power BI – Map Visualisations

1:58:19 Power BI – Slicers

2:02:40 Power BI – Sharing Reports

2:04:25 Power BI – Online

2:05:19 Power BI – Sharing

2:09:33 Power BI – QR code to view Reports