Lynda - Power BI Data Methods

1. 01 - Introduction/01 - The Power BI ecosystem.mp43.54MB
2. 01 - Introduction/02 - What is Power BI.mp43.01MB
3. 01 - Introduction/03 - Understanding ETL (extract, transform, and load).mp42.72MB
4. 01 - Introduction/04 - Focus on Power Query.mp43.59MB
5. 01 - Introduction/05 - Course considerations.mp42.78MB
6. 02 - Extracting Data Files/01 - Connecting to CSV or text files.mp45.93MB
7. 02 - Extracting Data Files/02 - Manually entering data.mp43.6MB
8. 02 - Extracting Data Files/03 - Connecting to an Excel file.mp46.47MB
9. 02 - Extracting Data Files/04 - Connecting to a PDF file.mp47.99MB
10. 02 - Extracting Data Files/05 - Connecting to folders.mp413.37MB
11. 03 - Extracting Data Databases/01 - Connecting to databases.mp410.19MB
12. 03 - Extracting Data Databases/02 - Comparing data connection modes.mp43.95MB
13. 03 - Extracting Data Databases/03 - Query folding and native queries.mp46.39MB
14. 04 - Extracting Data Web and Other Options/01 - Connecting to web tables.mp416MB
15. 04 - Extracting Data Web and Other Options/02 - Querying API data.mp44.82MB
16. 04 - Extracting Data Web and Other Options/03 - Querying REST API connections.mp414.71MB
17. 04 - Extracting Data Web and Other Options/04 - Configuring OData feeds.mp44.98MB
18. 04 - Extracting Data Web and Other Options/05 - Installing Python.mp45.53MB
19. 04 - Extracting Data Web and Other Options/06 - Running Python scripts.mp45.01MB
20. 05 - Transforming Data Cleaning/01 - Leveraging metadata.mp42.49MB
21. 05 - Transforming Data Cleaning/02 - Leveraging data types.mp45.4MB
22. 05 - Transforming Data Cleaning/03 - Making initial field transformations.mp410.27MB
23. 05 - Transforming Data Cleaning/04 - Splitting fields.mp46.81MB
24. 05 - Transforming Data Cleaning/05 - Merging fields.mp43.88MB
25. 05 - Transforming Data Cleaning/06 - Cleaning text fields.mp45MB
26. 05 - Transforming Data Cleaning/07 - Transforming numerical fields.mp45.94MB
27. 05 - Transforming Data Cleaning/08 - Removing or replacing values.mp46.29MB
28. 05 - Transforming Data Cleaning/09 - Filtering and removing duplicates.mp47.39MB
29. 05 - Transforming Data Cleaning/10 - Accessing native query in cleaning.mp412.9MB
30. 06 - Transforming Data Integration/01 - Introducing table objects.mp48.8MB
31. 06 - Transforming Data Integration/02 - Introducing list and record objects.mp412.95MB
32. 06 - Transforming Data Integration/03 - Working with binary objects.mp48.28MB
33. 06 - Transforming Data Integration/04 - Grouping data.mp43.86MB
34. 06 - Transforming Data Integration/05 - Pivoting data.mp415.51MB
35. 06 - Transforming Data Integration/06 - Transposing data.mp44.45MB
36. 06 - Transforming Data Integration/07 - Unpivoting data.mp44.2MB
37. 06 - Transforming Data Integration/08 - Accessing native query in integration.mp411.38MB
38. 07 - Transforming Data Enrichment/01 - Leveraging text formulas.mp418.06MB
39. 07 - Transforming Data Enrichment/02 - Conditional formulas.mp45.78MB
40. 07 - Transforming Data Enrichment/03 - Filling up or down columns.mp44.93MB
41. 07 - Transforming Data Enrichment/04 - Leveraging date formulas.mp415.52MB
42. 07 - Transforming Data Enrichment/05 - Combining binary files with formulas.mp416.13MB
43. 07 - Transforming Data Enrichment/06 - Accessing native query in enrichment.mp49.22MB
44. 08 - Leveraging M Language Logic and Syntax/01 - Working with Query Editor steps.mp47.7MB
45. 08 - Leveraging M Language Logic and Syntax/02 - Breaking down syntax.mp42.76MB
46. 08 - Leveraging M Language Logic and Syntax/03 - Renaming steps in M.mp410.95MB
47. 08 - Leveraging M Language Logic and Syntax/04 - Consolidating M steps.mp45.41MB
48. 08 - Leveraging M Language Logic and Syntax/05 - Adding data types as custom M code.mp46.43MB
49. 08 - Leveraging M Language Logic and Syntax/06 - Connecting to zipped binary data.mp46.76MB
50. 09 - Leveraging M Language Objects/01 - Utilizing parameters.mp45.53MB
51. 09 - Leveraging M Language Objects/02 - Creating list objects.mp47.28MB
52. 09 - Leveraging M Language Objects/03 - Referencing a list as a column in a table.mp46.42MB
53. 09 - Leveraging M Language Objects/04 - Leveraging record objects.mp44.4MB
54. 09 - Leveraging M Language Objects/05 - Leveraging list functions.mp44.75MB
55. 09 - Leveraging M Language Objects/06 - Creating date tables.mp47.18MB
56. 09 - Leveraging M Language Objects/07 - Looping with lists.mp412.64MB
57. 09 - Leveraging M Language Objects/08 - Combining list objects.mp416.45MB
58. 10 - Leveraging M language Custom Functions/01 - Setting up custom functions.mp415.56MB
59. 10 - Leveraging M language Custom Functions/02 - Converting queries into functions.mp424.37MB
60. 10 - Leveraging M language Custom Functions/03 - Configuring custom filtering.mp414.59MB
61. 11 - Loading Data/01 - Configuring loading options.mp45.95MB
62. 11 - Loading Data/02 - Fixing errors.mp48.55MB
63. 11 - Loading Data/03 - Refreshing data.mp413.44MB
64. 11 - Loading Data/04 - Joining sets of data.mp414.76MB
65. 11 - Loading Data/05 - Composite models.mp44.54MB
66. 12 - Conclusion/01 - Next steps.mp41.24MB