Learn Data Warehousing and Analysis with Microsoft BI Tools
- 4.3
-
![]()
![]()
![]()
![]()
Brief Introduction
Learn how extract, clean and load data in a database using Microsoft Excel and Business Intelligence toolsDescription
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.
Requirements
- Requirements
- Basic knowledge of SQL
Data Science Guide
4.3 Raiting
Mastering Data Analysis in Excel
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Unlock the power of Excel to utilize its analytical tools from Vlookup to Pivot Table - no matter your experience level...
LEARNING PATH: Microsoft Power BI Made Easy
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Change your data into actionable business insights The highlights of this Learning Path are: Get to discover and share new insights from your published reports and dashboards...
Excel Interactive Dashboards and Data Analysis
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn to create POWERFUL, INTERACTIVE dashboards in Excel in minutes with no coding We've focused on providing you with the fundamentals you need to work with Excel effectively! ...
Microsoft Power BI Certification: DA-100 Exam Prep
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Complete, hands-on guide to passing the DA-100 Power BI Exam and becoming a Microsoft Certified Data Analyst Associate See why Maven Analytics courses are among the TOP-RATED and BEST-SELLING courses on Udemy:...
