ETL and Data Modeling using Power BI, SSIS, Azure Data Factory
Your Instructor
Yoseph A. Kassaye has been programming for around 15 years and teaching for almost 5 years. He is equiped with two masters degree, microsoft Certified professional, scrum master . He is the owner of YaYoBE which is a successful web development and Software Development company and specializes in everything from HTML5 to front end frameworks like Angular as well as server side technologies like Node.js, C#, Asp.NET, MVC, Mobile development (both Swift and Android). Yoseph has mastered explaining very complex topics in a simple manner that is very understandable. Invest in your knowledge by watching Yoseph's courses.
This course is prepared for those who would like to lean Technology in Amharic.
Course Curriculum
-
StartPart 1- Power BI -Overview (9:16)
-
StartPart 2- ETL (17:11)
-
StartPart 3- Overview of Power BI Desktop (16:27)
-
StartPart 4- First Project (19:52)
-
StartPart 5- Setting up the project and load the files (20:15)
-
StartPart 6- Data Transformation-Detail (24:11)
-
StartPart 7- Data Transformation-Detail (17:35)
-
StartPart 8- Data Transformation-More (15:47)
-
StartPart 9- Creating Data Model (17:29)
-
StartPart 10 Importing Data 1 (19:55)
-
StartPart 11 Data Import and Transformation (4:23)
-
StartPart 12 Data Import and Transformation 2 (8:59)
-
StartPart 12 Translating Values (13:37)
-
StartPart 13 Adding Computer Columns (16:12)
-
StartPart 14 Date Function (4:14)
-
StartPart 15 Data Visualization (16:45)
-
StartPart 16 Data Visualization- Part 2 (7:01)
-
StartPart 15 Data Visualization (16:45)
-
StartPart 17 Data Visualization-Formatting (9:38)
-
StartPart 18 R-Script Introduction (8:43)
-
StartPart 19 R-Script Introduction-Part 2 (12:42)
-
StartPart 20 R-Script Introduction-Part 3 (13:55)
-
StartPart 21 R-Script Introduction-Part 4 (10:48)
-
StartPart 22- Import csv data using Python (16:23)
-
StartPart 23- Python-for Visualization (21:24)
-
StartPart 24- Row level Security Part 1 (8:05)
-
StartPart 25- Row level Security Part 2 (11:06)
-
StartPart 26- Power BI- API Part 1 (14:12)
-
StartPart 27- Power BI- API Part 2 (14:10)
-
StartPart 28- Power BI- API Part 3 (17:31)
-
StartPart 29- Power BI- API - How API Works Part 4 (7:49)
-
StartPart 1- SQL Server Integration Service- SSIS-How to setup (14:59)
-
StartPart 2- SSIS-Basic (12:54)
-
StartPart 3- SSIS- First Project (31:14)
-
StartPart 4 SSIS-Data Transformation from SQL (11:51)
-
StartPart 5 SSIS-Data Transformation from SQL2 (30:41)
-
StartPart 6 SSIS-Data Transformation from SQL3 (7:56)
-
StartPart 7 SSIS-Data Transformation from SQL4 (14:53)
-
StartStudent Management Database Script
-
StartPart 10 SSIS-For Each Loop Part 2 (8:00)
-
StartPart 8 SSIS-Loop-For Loop (24:31)
-
StartPart 9 SSIS-For Each Loop (7:28)
-
StartPart 11- SSIS- Grade Calculation Example (20:59)
-
StartPart 12 - SSIS Sampling (7:35)
-
StartPart 13 - SSIS Percentage Sampling (2:52)