Posted on 2020-10-30, by 0nelovee.
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 77 lectures (5h 2m) | Size: 2.26 GB
Learn how extract, clean and load data in a database using Microsoft Excel and Business Intelligence tools
What you'll learn:
Understand Data Warehousing Terminology
Understand the difference between OLTP and OLAP
Install and use MS SQL Server and SQL Server Management Studio
Install and use Business Intelligence tools (SSIS and SSRS)
Understand and use ETL via SSIS
Introduced to different Flat files
Clean CSV files using Microsoft Excel
Use simple and efficient ETL that avoid many of expecting errors
USE SSRS to create different types of business reports
Practice data analysis while creating SSRS reports
Basic knowledge of SQL
Learning how to extract, clean and load data into a SQL database warehouse are highly required skills for data analysis field. You will learn in this course how to use Microsoft Excel to clean your data before loading them into a Microsoft SQL Server database. You will learn how to use SQL Server Integration Services (SSIS) which is one of Microsoft Business Intelligence tools to perform ETL process. You will learn a simple technique that save you a lot of time and help to avoid many possible errors during the ETL process. You will learn also how to use SQL Server Reporting Services (SSRS) to create business reports and data analysis with SQL queries. This course is designed to be more practical by putting your hands on real projects with diverse business scenarios to learn by practice. Learning via practice is the best way to get knowledge stuck in your mind because it is similar to acquire experience through work.
Who this course is for
Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI
- Ebooks list page : 45086
- 2021-01-20Python For Data Analysis The Ultimate and Definitive Manual to Learn Data Science and Coding With P...
- 2021-01-02Data Management and Analysis with Advance Excel
- 2020-12-30Udemy - Data Management and Analysis with Advance Excel
- 2020-10-22Learn Data Analytics and Visualization with Tableau from A-Z
- 2020-10-17Learn Data Analytics and Visualization with Tableau from A-Z
- 2020-01-02Data Visualization And Analysis With R
- 2019-10-25Data Visualization and Analysis with R
- 2019-10-19Data Visualization and Analysis with R
- 2019-05-16Data Wrangling and Analysis with Python
- 2019-05-06Data Wrangling and Analysis with Python
- 2019-04-08Stone River Elearning Data Modelling And Analysis With Excel Power Pivot
- 2019-04-08Infinite Skills Data Wrangling And Analysis With Python
- 2019-04-08Stone River Elearning Data Modelling And Analysis With Excel Power Pivot Illiterate
- 2019-01-31Stone River eLearning - Data Modelling and Analysis with Excel Power Pivot
- 2019-01-09Infinite Skills Data Wrangling And Analysis With Python
- 2019-01-02Infinite Skills Data Wrangling And Analysis With Python-Illiterate
- 2018-12-31Stone River Elearning Data Modelling And Analysis With Excel Power Pivot-Illiterate
- 2018-11-14Data Modelling and Analysis with Excel Power Pivot
- 2018-05-04Data Modelling and Analysis with Excel Power Pivot
- Download links and password may be in the description section, read description carefully!
- Do a search to find mirrors if no download links or dead links.