| 1. Introduction to SSRS.html | 1.8 KB | ||
| 1. Introduction.mp4 | 1.5 MB | ||
| 1. Overview of Microsoft SQL (T-SQL).html | 2.3 KB | ||
| 1. What is SSAS.html | 1.3 KB | ||
| 1. What is SSIS.html | 2.2 KB | ||
| 1. What is Visual Studio.mp4 | 23.9 MB | ||
| 10. Add and configure the flat file source.mp4 | 28.1 MB | ||
| 10. Create calculated columns Part 1.mp4 | 64.7 MB | ||
| 10. Install adventureworksDatabase.mp4 | 32.6 MB | ||
| 10. Previewing the report.mp4 | 6.7 MB | ||
| 10.1 DAX+Formulas.txt | 1.1 KB | ||
| 11. Add and configure the lookup transformations.mp4 | 75.3 MB | ||
| 11. Create calculated columns Part 2.mp4 | 31.3 MB | ||
| 11. Exporting the report.mp4 | 5.2 MB | ||
| 11. Install adventureworksDWDatabase.mp4 | 28.9 MB | ||
| 11.1 lookupsqlquery.txt | 819.2 B | ||
| 12. Add and configure Lookup for datekey transformations.mp4 | 68.1 MB | ||
| 12. Creating measures Part 1.mp4 | 51.9 MB | ||
| 12.1 Creating+measures++Part+1.txt | 512 B | ||
| 13. Add and configure the OLE DB destination.mp4 | 53.9 MB | ||
| 13. Creating measures Part 2.mp4 | 30.4 MB | ||
| 13.1 create+additional+measures+in+the+FactInternetSales+table.xlsx | 10.1 KB | ||
| 14. Creating measures Part 3.mp4 | 27.5 MB | ||
| 14. Test SSIS Package.mp4 | 12.1 MB | ||
| 14.1 CUSTOM+MEASURES.xlsx | 9.9 KB | ||
| 15. Create key performance indicators.mp4 | 38.9 MB | ||
| 15.1 Create+Key+Performance+Indicators.txt | 819.2 B | ||
| 16. Creating perspectives.mp4 | 13.5 MB | ||
| 17. Creating Hierarchies Part 1.mp4 | 25.5 MB | ||
| 18. Creating Hierarchies Part 2.mp4 | 41.3 MB | ||
| 19. What are partitions.mp4 | 9.2 MB | ||
| 2. Create a report server project.mp4 | 7.9 MB | ||
| 2. Install SSAS.mp4 | 44.7 MB | ||
| 2. Introduction to stored procedures.mp4 | 24.5 MB | ||
| 2. Visual Studio installation requirements.mp4 | 37.4 MB | ||
| 2. What is ETL.mp4 | 19 MB | ||
| 2. What is SQL Server.mp4 | 11.1 MB | ||
| 20. Creating partitions.mp4 | 83 MB | ||
| 21. Creating Roles.mp4 | 48.2 MB | ||
| 22. Analyze in Excel.mp4 | 30.5 MB | ||
| 23. Deploying your model.mp4 | 22.3 MB | ||
| 24. Analyzing Model.mp4 | 34.8 MB | ||
| 3. Connect to SSAS.mp4 | 4.8 MB | ||
| 3. Create a report definition file.mp4 | 10.5 MB | ||
| 3. Creating stored procedures.mp4 | 52.5 MB | ||
| 3. ETLSSIS Overview.html | 2.6 KB | ||
| 3. Install Visual Studio.mp4 | 33.4 MB | ||
| 3. SQL Server Edition.mp4 | 28.3 MB | ||
| 4. Configure a data source for the report.mp4 | 15.2 MB | ||
| 4. Create SSIS Package.mp4 | 11.5 MB | ||
| 4. Creating a Tabular model project.mp4 | 10.3 MB | ||
| 4. Modifying stored procedures.mp4 | 18.9 MB | ||
| 4. SQL Server Installation Requirements.mp4 | 21.2 MB | ||
| 4. Visual studio workloads.mp4 | 17.9 MB | ||
| 5. Define a dataset for the report.mp4 | 30.5 MB | ||
| 5. Explore tabular model authoring.mp4 | 21.8 MB | ||
| 5. Install SQL Server Data Tools.mp4 | 22 MB | ||
| 5. Note.html | 102.4 B | ||
| 5. Properties page of a stored procedure.mp4 | 20.9 MB | ||
| 5. SSIS Designer.mp4 | 14.6 MB | ||
| 5.1 SQL+Script.txt | 819.2 B | ||
| 6. Add a table to the report.mp4 | 32.5 MB | ||
| 6. Add and configure a flat file connection manager.mp4 | 38.8 MB | ||
| 6. Create a connection to data source.mp4 | 14.9 MB | ||
| 6. Download SQL Server.mp4 | 23.2 MB | ||
| 6. Install SSDT Designer Templates.mp4 | 38.1 MB | ||
| 6. Viewing dependencies of a stored procedure.mp4 | 11.5 MB | ||
| 6.1 SampleCurrencyData.txt | 43.2 KB | ||
| 7. Deleting a stored procedure.mp4 | 8.1 MB | ||
| 7. Format the report.mp4 | 36.7 MB | ||
| 7. Install SQL Server.mp4 | 62.1 MB | ||
| 7. Remapping Column Data Types.mp4 | 104.1 MB | ||
| 7. Transform and import data.mp4 | 67 MB | ||
| 8. Add and configure an OLE DB Connection manager.mp4 | 26 MB | ||
| 8. Group data in report.mp4 | 24.8 MB | ||
| 8. Install SSMS.mp4 | 36.6 MB | ||
| 8. Mark as data table.mp4 | 13.2 MB | ||
| 8. Viewing the definition of a stored procedure.mp4 | 19.6 MB | ||
| 9. Add a data flow task to package.mp4 | 26.1 MB | ||
| 9. Adding totals to the report.mp4 | 28.7 MB | ||
| 9. Connect SSMS to SQL Server.mp4 | 12.5 MB | ||
| 9. Create table relationships.mp4 | 53.9 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 84 total files | |||
ETL/SQL Developer Toolkit :MS SQL Server ,SSIS,ETL,SSRS,SSAS
https://FreeCourseWeb.com
Published 5/2023
Created by Digital Learning Academy
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 74 Lectures ( 5h 20m ) | Size: 2 GB
Master ETL/SQL Developer Skills: Microsoft SQL Server /SSIS /ETL/SSRS/SSAS/T-SQL
What you'll learn
The basics of ETL (extract, transform, load) concepts and data integration
Creating stored procedures using T-SQL
Using SQL Server Integration Services (SSIS) for ETL
Creating SSIS packages for data extraction, transformation, and loading
SQL Server Reporting Services (SSRS) for creating reports
Designing and building reports using SSRS
Designing efficient ETL pipelines
Data transformations, including data cleaning and data mapping
Create Tabular Data model with SSAS
Create and execute SSIS Package
Deploy SSAS Model
Requirements
Students should have a basic understanding of database concepts and SQL (Structured Query Language).
Students should have access to a computer running MS SQL Server and the SQL Server Management Studio (SSMS) software.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Build AI-Driven Data Warehouses - ChatGPT ETL, and Python BI Posted by
freecoursewb in Other
|
1.7 GB | freecoursewb | 5 months | 4 | 0 |
| 493.1 MB | freecoursewb | 1 year | 0 | 7 | |
| 259.2 MB | freecoursewb | 1 year | 0 | 0 | |
|
Udemy - SQL - ETL Developer - T-SQL - Stored Procedures - ETL - SSIS Posted by
freecoursewb in Other
|
2.4 GB | freecoursewb | 2 years | 0 | 0 |
| 461.3 MB | freecoursewb | 3 years | 0 | 0 |
All Comments