| 1. Connect to data source.mp4 | 26.7 MB | ||
| 1. Connect to data source.srt | 5.2 KB | ||
| 1. Introduction.mp4 | 1.5 MB | ||
| 1. Introduction.srt | 614.4 B | ||
| 1. Power BI Overview Part 1.mp4 | 23.1 MB | ||
| 1. Power BI Overview Part 1.srt | 5.3 KB | ||
| 1. What is Alteryx.mp4 | 14.3 MB | ||
| 1. What is Alteryx.srt | 3.5 KB | ||
| 1. What is Power BI.mp4 | 35.3 MB | ||
| 1. What is Power BI.srt | 5.3 KB | ||
| 1. What is SSAS.html | 409.6 B | ||
| 1. What is SSIS.mp4 | 18.2 MB | ||
| 1. What is SSIS.srt | 3 KB | ||
| 1. What is Visual Studio.mp4 | 24.3 MB | ||
| 1. What is Visual Studio.srt | 4.6 KB | ||
| 1.1 Financial+Sample.xlsx | 81.5 KB | ||
| 10. Add and configure the lookup transformations.mp4 | 75.7 MB | ||
| 10. Add and configure the lookup transformations.srt | 12.5 KB | ||
| 10. Create calculated columns Part 1.mp4 | 65.3 MB | ||
| 10. Create calculated columns Part 1.srt | 7.8 KB | ||
| 10. Install adventureworksDatabase.mp4 | 32.6 MB | ||
| 10. Install adventureworksDatabase.srt | 7 KB | ||
| 10. Splitting Columns.mp4 | 23.6 MB | ||
| 10. Splitting Columns.srt | 3 KB | ||
| 10.1 DAX+Formulas.txt | 1.1 KB | ||
| 10.1 lookupsqlquery.txt | 819.2 B | ||
| 11. Add and configure Lookup for datekey transformations.mp4 | 63.1 MB | ||
| 11. Add and configure Lookup for datekey transformations.srt | 10 KB | ||
| 11. Analyze Data based on a column.mp4 | 20.8 MB | ||
| 11. Analyze Data based on a column.srt | 3.1 KB | ||
| 11. Create calculated columns Part 2.mp4 | 31.6 MB | ||
| 11. Create calculated columns Part 2.srt | 3.8 KB | ||
| 11. Install adventureworksDW Database.mp4 | 29.2 MB | ||
| 11. Install adventureworksDW Database.srt | 6.1 KB | ||
| 12. Add and configure the OLE DB destination.mp4 | 50 MB | ||
| 12. Add and configure the OLE DB destination.srt | 7.4 KB | ||
| 12. Creating measures Part 1.mp4 | 52.6 MB | ||
| 12. Creating measures Part 1.srt | 5.8 KB | ||
| 12.1 Creating+measures++Part+1.txt | 512 B | ||
| 13. Creating measures Part 2.mp4 | 30.3 MB | ||
| 13. Creating measures Part 2.srt | 4.5 KB | ||
| 13. Test SSIS Package.mp4 | 11.1 MB | ||
| 13. Test SSIS Package.srt | 1.8 KB | ||
| 13.1 create+additional+measures+in+the+FactInternetSales+table.xlsx | 10.1 KB | ||
| 14. Creating measures Part 3.mp4 | 27.5 MB | ||
| 14. Creating measures Part 3.srt | 3.6 KB | ||
| 14.1 CUSTOM+MEASURES.xlsx | 9.9 KB | ||
| 15. Create key performance indicators.mp4 | 39.6 MB | ||
| 15. Create key performance indicators.srt | 5.8 KB | ||
| 16. Creating perspectives.mp4 | 13.8 MB | ||
| 16. Creating perspectives.srt | 2.5 KB | ||
| 17. Creating Hierarchies Part 1.mp4 | 25.7 MB | ||
| 17. Creating Hierarchies Part 1.srt | 4 KB | ||
| 18. Creating Hierarchies Part 2.mp4 | 41.6 MB | ||
| 18. Creating Hierarchies Part 2.srt | 5.9 KB | ||
| 19. What are partitions.mp4 | 9.3 MB | ||
| 19. What are partitions.srt | 1.6 KB | ||
| 2. Clean and transform data Part 1.mp4 | 37.8 MB | ||
| 2. Clean and transform data Part 1.srt | 6.7 KB | ||
| 2. Creating a basic workflow.mp4 | 62.7 MB | ||
| 2. Creating a basic workflow.srt | 9.9 KB | ||
| 2. Install SSAS.mp4 | 44.9 MB | ||
| 2. Install SSAS.srt | 8.3 KB | ||
| 2. Power BI Overview Part 2.mp4 | 25.9 MB | ||
| 2. Power BI Overview Part 2.srt | 4.8 KB | ||
| 2. Visual Studio installation requirements.mp4 | 37.6 MB | ||
| 2. Visual Studio installation requirements.srt | 4.9 KB | ||
| 2. What is ETL.mp4 | 19.5 MB | ||
| 2. What is ETL.srt | 5.6 KB | ||
| 2. What is Power BI Desktop.mp4 | 11.7 MB | ||
| 2. What is Power BI Desktop.srt | 3.3 KB | ||
| 2. What is SQL Server.mp4 | 11.2 MB | ||
| 2. What is SQL Server.srt | 2.6 KB | ||
| 20. Creating partitions.mp4 | 83.2 MB | ||
| 20. Creating partitions.srt | 9.4 KB | ||
| 21. Creating Roles.mp4 | 48.8 MB | ||
| 21. Creating Roles.srt | 7.7 KB | ||
| 22. Analyze in Excel.mp4 | 30.3 MB | ||
| 22. Analyze in Excel.srt | 3.6 KB | ||
| 23. Deploying your model.mp4 | 22.2 MB | ||
| 23. Deploying your model.srt | 3.6 KB | ||
| 24. Analyzing Model.mp4 | 35 MB | ||
| 24. Analyzing Model.srt | 7 KB | ||
| 3. Clean and transform data Part 2.mp4 | 78.1 MB | ||
| 3. Clean and transform data Part 2.srt | 11.1 KB | ||
| 3. Connect to SSAS.mp4 | 4.9 MB | ||
| 3. Connect to SSAS.srt | 1.8 KB | ||
| 3. Connecting to data.mp4 | 8.3 MB | ||
| 3. Connecting to data.srt | 1.4 KB | ||
| 3. Create SSIS Package.mp4 | 11.3 MB | ||
| 3. Create SSIS Package.srt | 2.6 KB | ||
| 3. Install Visual Studio.mp4 | 33.4 MB | ||
| 3. Install Visual Studio.srt | 7.8 KB | ||
| 3. Office 365 Setup.mp4 | 38.1 MB | ||
| 3. Office 365 Setup.srt | 8.4 KB | ||
| 3. Power BI Overview Part 3.mp4 | 41.1 MB | ||
| 3. Power BI Overview Part 3.srt | 5.7 KB | ||
| 3. SQL Server Edition.mp4 | 28.6 MB | ||
| 3. SQL Server Edition.srt | 4.7 KB | ||
| 4. Combine Data Sources.mp4 | 44.2 MB | ||
| 4. Combine Data Sources.srt | 8 KB | ||
| 4. Components of Power BI.mp4 | 8.6 MB | ||
| 4. Components of Power BI.srt | 2.4 KB | ||
| 4. Creating a Tabular model project.mp4 | 10.6 MB | ||
| 4. Creating a Tabular model project.srt | 3.2 KB | ||
| 4. Install Power BI.mp4 | 37.4 MB | ||
| 4. Install Power BI.srt | 8.2 KB | ||
| 4. SQL Server Installation Requirements.mp4 | 21.5 MB | ||
| 4. SQL Server Installation Requirements.srt | 4.2 KB | ||
| 4. SSIS Designer.mp4 | 13.9 MB | ||
| 4. SSIS Designer.srt | 2 KB | ||
| 4. Viewing Data.mp4 | 8.6 MB | ||
| 4. Viewing Data.srt | 1.3 KB | ||
| 4. Visual studio workloads.mp4 | 18.1 MB | ||
| 4. Visual studio workloads.srt | 4.7 KB | ||
| 5. Add and configure a flat file connection manager.mp4 | 36.3 MB | ||
| 5. Add and configure a flat file connection manager.srt | 5.9 KB | ||
| 5. Building blocks of Power BI.mp4 | 42.4 MB | ||
| 5. Building blocks of Power BI.srt | 6 KB | ||
| 5. Create Visualization Part 1.mp4 | 29.9 MB | ||
| 5. Create Visualization Part 1.srt | 6.2 KB | ||
| 5. Download SQL Server.mp4 | 23.2 MB | ||
| 5. Download SQL Server.srt | 5.3 KB | ||
| 5. Explore tabular model authoring.mp4 | 22.5 MB | ||
| 5. Explore tabular model authoring.srt | 4.2 KB | ||
| 5. Install SQL Server Data Tools.mp4 | 22.2 MB | ||
| 5. Install SQL Server Data Tools.srt | 4.2 KB | ||
| 5. Power BI Desktop Tour.mp4 | 37.4 MB | ||
| 5. Power BI Desktop Tour.srt | 7.2 KB | ||
| 5. Transforming Data.mp4 | 32.3 MB | ||
| 5. Transforming Data.srt | 4.5 KB | ||
| 6. Cleansing Data.mp4 | 18.3 MB | ||
| 6. Cleansing Data.srt | 2.4 KB | ||
| 6. Create Visualization Part 2.mp4 | 35.3 MB | ||
| 6. Create Visualization Part 2.srt | 6.1 KB | ||
| 6. Create a connection to data source.mp4 | 15.1 MB | ||
| 6. Create a connection to data source.srt | 2.9 KB | ||
| 6. Exploring Power BI Desktop Interface.mp4 | 30.6 MB | ||
| 6. Exploring Power BI Desktop Interface.srt | 7.1 KB | ||
| 6. Install SQL Server.mp4 | 62.5 MB | ||
| 6. Install SQL Server.srt | 11.8 KB | ||
| 6. Install SSDT Designer Templates.mp4 | 38.7 MB | ||
| 6. Install SSDT Designer Templates.srt | 7.5 KB | ||
| 6. Remapping Column Data Types.mp4 | 93 MB | ||
| 6. Remapping Column Data Types.srt | 12 KB | ||
| 7. Add and configure an OLE DB Connection manager.mp4 | 24.5 MB | ||
| 7. Add and configure an OLE DB Connection manager.srt | 3.4 KB | ||
| 7. Adding a new column.mp4 | 20.1 MB | ||
| 7. Adding a new column.srt | 3.1 KB | ||
| 7. Exploring Power BI Service.mp4 | 22.2 MB | ||
| 7. Exploring Power BI Service.srt | 5.1 KB | ||
| 7. Install SSMS.mp4 | 36.8 MB | ||
| 7. Install SSMS.srt | 5.8 KB | ||
| 7. Transform and import data.mp4 | 67 MB | ||
| 7. Transform and import data.srt | 9.3 KB | ||
| 8. Add a data flow task to package.mp4 | 24.5 MB | ||
| 8. Add a data flow task to package.srt | 4.6 KB | ||
| 8. Connect SSMS to SQL Server.mp4 | 32.4 MB | ||
| 8. Connect SSMS to SQL Server.srt | 9 KB | ||
| 8. Filtering Data.mp4 | 16.2 MB | ||
| 8. Filtering Data.srt | 2.2 KB | ||
| 8. Mark as data table.mp4 | 13.2 MB | ||
| 8. Mark as data table.srt | 1.8 KB | ||
| 8. Power BI Apps.mp4 | 22.5 MB | ||
| 8. Power BI Apps.srt | 4 KB | ||
| 9. Add and configure the flat file source.mp4 | 26.5 MB | ||
| 9. Add and configure the flat file source.srt | 4 KB | ||
| 9. Blend and Analyze Data.mp4 | 35.6 MB | ||
| 9. Blend and Analyze Data.srt | 4 KB | ||
| 9. Create table relationships.mp4 | 54.4 MB | ||
| 9. Create table relationships.srt | 7.4 KB | ||
| 9. Please Read.html | 102.4 B | ||
| 9.1 SampleCurrencyData.txt | 43.2 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 175 total files | |||
Data Analyst | ETL : SQL Server,SSIS,SSAS,PowerBI, Alteryx
https://CoursePig.com
Last Update: 11/2021
Duration: 6h 55m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 2.53 GB
Genre: eLearning | Language: English
Extract, Transform,Load and Analyze Data
What you'll learn:
Connect to data multiple data sources
Extract Data
Clean and Transform data
Load cleaned and transformed data
Create and execute SSIS Package
Create Tabular Data model with SSAS
Deploy SSAS Model
Analyse Data
Create Data Visualizations
Publish Reports to Power BI Service
Description:
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.
Power BI consists of several elements that all work together, starting with these three basics:
A Windows desktop application called Power BI Desktop.
An online SaaS (Software as a Service) service called the Power BI service.
Power BI mobile apps for Windows, iOS, and Android devices.
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.
Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.
Integration Services includes a rich set of built-in tasks and transformations, graphical tools for building packages, and the Integration Services Catalog database, where you store, run, and manage packages.
You can use the graphical Integration Services tools to create solutions without writing a single line of code. You can also program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.
SQL Server Analysis services (SSAS) is a multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data. It is part of Microsoft SQL Server and helps perform analysis using various dimensions. It has 2 variants Multidimensional and Tabular. The SSAS full form is SQL Server Analysis Services.
Analysis Services is an analytical data engine (VertiPaq) used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. Analysis Services is available in different platforms.
SQL Server is a software application designed to manage databases, it stores and retrieves data as requested by other applications. When software developers are writing new business applications that store information in a database they will very often use SQL Server’s functionality to look after the databases rather than reinventing the wheel writing their own code to do the same thing. This makes writing database applications easier and quicker (and therefore cheaper) as well as making them more reliable, scalable and secure.
SQL Server is known as a “Relational Database” Management System. Data is stored in tables in a similar way to rows and columns in a spreadsheet. If you imagine a database containing accounting information you may have a table for each invoice with values, VAT, Totals, invoice number etc. Each invoice relates to a customer but instead of recording the customer’s details (name, address, discounts etc.) with each invoice you just record it once in a separate table called Customers. The Customers table and Invoices table are linked or “related”.
The “Management System” part of SQL Server makes sure the databases are stored efficiently and the data can be searched or retrieved as quickly as possible. It also makes sure multiple people connecting to the same data are managed properly so you don’t get problems if two people change the same information at the same time.
Alteryx is a software solution that allows users to quickly access, manipulate, analyze, and output data. This can be done in a one-off manner or, more commonly, the process (called a “workflow”) is something people use on a recurring (daily, weekly, monthly) basis. The way Alteryx builds workflows becomes a form of process documentation allowing users to see, collaborate on, support, and enhance the process. Data can be read and written to files, databases, and APIs. Alteryx is used for access, manipulation, analysis, and output of data. The platform is very robust and can be used in virtually any industry or functional area.
Who this course is for:
Beginner Data Analyst
Beginner Data Scientist
Beginner Data Engineer
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
| 1.1 GB | freecoursewb | 1 week | 5 | 7 | |
| 2.9 GB | freecoursewb | 1 week | 2 | 19 | |
|
Udemy - Revit Ideate - BIM Automation, Data Management and Documents Posted by
freecoursewb in Other
|
2.4 GB | freecoursewb | 1 week | 11 | 10 |
| 952.8 MB | freecoursewb | 2 weeks | 45 | 16 |
All Comments