Udemy - Tabular Editor 3 for Power BI and SQL Server Analysis Services
Tabular Editor 3 for Power BI & SQL Server Analysis Services
Description
In this course you will learn how to use the best external tool for Power BI, SQL Server Analysis Services.
Learning TE3 is an important skill as it allows you to develop models efficiently, make changes to a live database without the PBIX or Visual Studio project
You can write DAX Queries to investigate data, you can create objects such as Measure, Columns, and Tables with a single commit, without waiting for Power BI Desktop to update and process the changes one by one which in turn reduces the development time.
You can automate the processes by writing C# Scripts that allow you to iterate the objects in Tabular Object Model and perform certain actions.
You can use TE3 to create Calculation Groups which reduces the number of measures or variations of measure(s) that you have to create and provide a seamless experience, using TE3 you can script all the Calculation Groups and use that script to deploy Calculation Groups to a completely different data model.
TE3 allows you to write your own Best Practices using LINQ so that you can evaluate the models in your organization against those best practices and identify the objects that break the rules
You can execute process commands on Tabular objects such as Tables & Partitions on individual basis, you can modify Incremental Refresh Policies in Power BI Service and then process partitions there.
This just the tip of the iceberg and there is a lot more that you can do with TE3 it is an absolute beast in terms of saving development efforts!
Chapter_1-Introduction/1. Course Introduction.mp4 13.25 MiB Chapter_2-Configuring_Working_Environment/11. Connecting TE to different Tabular Models.mp4 55.67 MiB Chapter_2-Configuring_Working_Environment/3. Tabular Editor 3.mp4 11.50 MiB Chapter_2-Configuring_Working_Environment/5. Power BI Service Developer Account.mp4 24.59 MiB Chapter_2-Configuring_Working_Environment/6. SQL Server & Analysis Services.mp4 50.85 MiB Chapter_2-Configuring_Working_Environment/7. Visual Studio, C# and SSAS Extension.mp4 58.50 MiB Chapter_2-Configuring_Working_Environment/8. Creating our First Power BI & SSAS Model.mp4 140.87 MiB Chapter_2-Configuring_Working_Environment/Extra_Files/Contoso+5M.zip 294.31 MiB Chapter_2-Configuring_Working_Environment/Extra_Files/Contoso+TE3+Demo.zip 144.97 MiB Chapter_3-Tabular_Editor_Introduction/12. TE 3 UI Intro & Setup.mp4 179.10 MiB Chapter_3-Tabular_Editor_Introduction/13. Understaing TOM - Tabular Object Model.mp4 160.85 MiB Chapter_3-Tabular_Editor_Introduction/14. Understanding TE vs Non TE approach.mp4 125.09 MiB Chapter_3-Tabular_Editor_Introduction/15. Serializing Model for CICD and DevOps.mp4 193.98 MiB Chapter_4-Developing_Data_Model/17. Sneak Peak of the underlying data.mp4 140.54 MiB Chapter_4-Developing_Data_Model/18. Relationships.mp4 126.08 MiB Chapter_4-Developing_Data_Model/19. Diagrams.mp4 64.47 MiB Chapter_4-Developing_Data_Model/20. Measures.mp4 302.14 MiB Chapter_4-Developing_Data_Model/21. Detail Rows Expression.mp4 195.85 MiB Chapter_4-Developing_Data_Model/22. Unsupported Modeling Features.mp4 101.41 MiB Chapter_4-Developing_Data_Model/23. Refresh Tables.mp4 168.15 MiB Chapter_4-Developing_Data_Model/24. Import Tables.mp4 262.45 MiB Chapter_4-Developing_Data_Model/25. Using Tabular Model Scripting Language.mp4 193.49 MiB Chapter_4-Developing_Data_Model/26. Write vs Read mode.mp4 38.58 MiB Chapter_4-Developing_Data_Model/27. Calculated Columns.mp4 349.24 MiB Chapter_4-Developing_Data_Model/28. Calculated Tables.mp4 155.94 MiB Chapter_4-Developing_Data_Model/30. Object Dependencies, Mark as Date, and Update Table Schema.mp4 183.35 MiB Chapter_4-Developing_Data_Model/31. User Hierarchies.mp4 71.43 MiB Chapter_4-Developing_Data_Model/32. Modify PBI Service Connection String & Parameters.mp4 80.47 MiB Chapter_4-Developing_Data_Model/33. Perspectives.mp4 130.29 MiB Chapter_4-Developing_Data_Model/34. Keep Unique Rows, Key, Group By Properties.mp4 133.16 MiB Chapter_4-Developing_Data_Model/35. Key Performance Indicators aka KPI.mp4 127.80 MiB Chapter_5-Querying_Visualizing_and_Debugging/36. EVALUATE, DEFINE & MEASURE.mp4 139.83 MiB Chapter_5-Querying_Visualizing_and_Debugging/37. COLUMN & TABLE.mp4 117.91 MiB Chapter_5-Querying_Visualizing_and_Debugging/38. Import Tables w DAX Queries.mp4 37.80 MiB Chapter_6-Securing_Data_Model_with_Roles/39. Model Access & Security - SSAS.mp4 162.02 MiB Chapter_6-Securing_Data_Model_with_Roles/41. Model Access & Security - Power BI Service.mp4 88.99 MiB Chapter_6-Securing_Data_Model_with_Roles/42. Object Level Security.mp4 251.30 MiB Chapter_6-Securing_Data_Model_with_Roles/43. Static Row Level Security.mp4 243.17 MiB Chapter_6-Securing_Data_Model_with_Roles/44. Dynamic Row Level Security.mp4 235.69 MiB Chapter_7-Calculation_Groups/45. Measure Selector.mp4 135.27 MiB Chapter_7-Calculation_Groups/46. Time Intelligence Variations.mp4 150.26 MiB Chapter_7-Calculation_Groups/47. Categorize Fields & Trendy vs Others.mp4 77.55 MiB Chapter_7-Calculation_Groups/48. Switch Relationships.mp4 77.75 MiB Chapter_8-C#_Scripts/49. Output, Selected, Select, and Recording Macros.mp4 168.56 MiB Chapter_8-C#_Scripts/50. Data Types & Variables & a small application.mp4 102.71 MiB Chapter_8-C#_Scripts/51. Importing Libraries and using InputBox and MessageBox.mp4 164.18 MiB Chapter_8-C#_Scripts/52. Referencing objects.mp4 45.35 MiB Chapter_8-C#_Scripts/53. LINQ.mp4 291.62 MiB Chapter_8-C#_Scripts/54. Accessing Data Model with Visual Studio.mp4 137.58 MiB Chapter_8-C#_Scripts/55. Create Methods that Print Tables, Columns, and Measures.mp4 90.79 MiB Chapter_8-C#_Scripts/56. Create Functions that returns different objects.mp4 89.43 MiB Chapter_8-C#_Scripts/57. Add New Measures & Calculated Columns.mp4 92.93 MiB Chapter_8-C#_Scripts/58. Refresh Model Objects.mp4 44.96 MiB Chapter_8-C#_Scripts/59. EvaluateDax & Export to CSV.mp4 82.70 MiB Chapter_8-C#_Scripts/60. Hide Columns used in Relationships.mp4 28.42 MiB Chapter_8-C#_Scripts/61. Create Variations of Selected Measures.mp4 61.18 MiB Chapter_8-C#_Scripts/62. Create Measures from Selected Columns & based on Data Types.mp4 73.18 MiB Chapter_8-C#_Scripts/63. Format DAX & Disable default summarization.mp4 76.19 MiB Chapter_9-Vertipaq_Analyzer/64. Summary.mp4 53.68 MiB Chapter_9-Vertipaq_Analyzer/65. Tables.mp4 215.98 MiB Chapter_9-Vertipaq_Analyzer/66. Attribute Hierarchy - IsAvailableInMDX.mp4 101.95 MiB Chapter_9-Vertipaq_Analyzer/67. Calculated Columns vs MSQL Columns.mp4 98.90 MiB Chapter_9-Vertipaq_Analyzer/68. Relationships Pane.mp4 41.12 MiB Chapter_9-Vertipaq_Analyzer/69. Incremental Refresh Partitions.mp4 164.28 MiB Chapter_9-Vertipaq_Analyzer/70. SSAS Tabular Partitions.mp4 150.34 MiB Chapter_9-Vertipaq_Analyzer/71. Optimizing Data Model.mp4 142.22 MiB Chapter_9-Vertipaq_Analyzer/Extra_Files/SQL+Scripts.zip 1.68 KiB Chapter_9-Vertipaq_Analyzer/Extra_Files/Vertipaq+Analyzer+-+SQL+Columns.txt 2.53 KiB