Foresight BI

Download all data files

9. What you must know about Append Queries

10. Understanding Merge Queries

11. Using Multiple Columns as Keys for Merging Queries

12. Understanding Join Kinds

13. Using the different Join Kinds in Power Query

14. What you must know about Merge Queries

15. Introduction to Transposing Data

16. Transposing Data when there is Header Row

17. Understanding Unpivot Columns

18. Unpivoting Columns when there are null values

19. Unpivoting Columns without Header Rows

20. Understanding Pivot Columns

21. Understanding Group By

22. Adding Duplicate and Index Columns

23. Adding new Columns from a Text Column

24. Adding new Columns from Numbers and Date Columns

25. Adding Conditional Columns (1)

26. Adding Conditional Columns (2)

27. Adding Custom Columns (1)

28. Adding Custom Columns (2)

29. Adding Columns From Examples

Transformation Assignment

30. Other common Column Transformations

31. Removing Duplicate Records

32. Dealing with Cell Errors in Power Query

33. Checking for Cell Errors reasons in Power Query

34. Introduction to Data Cleaning

35. Data Cleaning Example 1

36. Data Cleaning Example 2

37. Data Cleaning Example 3

38. Data Cleaning Example 4

39. Data Cleaning Example 5

40. Data Cleaning Example 6

Cleaning Dirty Data Assignment

Introduction to connecting to Data Sources

Connecting to Folders (1)

Connecting to Folders (2)

Connecting to Excel and combining multiple Worksheets

Create a Microsoft 365 Developer Account

Intro to SharePoint Data Source

Connecting to Excel File on SharePoint or OneDrive for Business

Connecting to a Folder on SharePoint

Connecting to OData Feeds

Install Microsoft SQL Server and host a Database

Importing Data from Microsoft SQL Server

Using Embedded Queries to get data from SQL Server

Introduction to Query Folding

Introduction to Direct Query Connection

Wrap up