BI Developer : Learn ( Power BI |SSIS |SSRS |SSAS|DW|T-SQL )

Gain Business Intelligence from Transforming Data

3.30 (436 reviews)
Udemy
platform
English
language
Other
category
BI Developer : Learn ( Power BI |SSIS |SSRS |SSAS|DW|T-SQL )
4,558
students
18 hours
content
Apr 2023
last update
$69.99
regular price

What you will learn

How to connect to multiple data sources with Power BI

How to transform connected data

How to create visualizations from data model

How to model data

How to establish relationships with connected data sources

How to Publish Reports to Power BI Service

How to create ETL Process with SSIS

How to implement Data warehouse

How to enforce data quality

How to cleanse data

How to consume data in data warehouse

How to perfume business intelligence on data models

How to use SSRS to create reports

How to use SSAS for data analysis

Why take this course?

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.

Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization.

In this beginners course you will learn how to  get started with this powerful toolset.  We will  cover topics like  connecting to and transforming web based data sources.  You will learn how to publish and share your reports and visuals on the Power BI service.

You will learn  how to import data, create visualizations, and arrange those visualizations into reports. You will learn how to how to pin visualizations to dashboards for sharing. You  will also learn how to use  DAX  language( Data Analysis Expressions) to perform calculations on data models.


Topics include:

  • Connecting to SQL Server and PostgreSQL Databases

  • Connecting to Microsoft Access Database File

  • Creating reports with data visualizations

  • Modifying existing reports

  • Creating and managing data dashboards

  • Creating Power BI datasets, dashboards, reports, and workbooks

  • Connecting to web based data source

  • Connecting to Excel dataset

  • Using Query Editor

  • Joining tables and creating tables

  • Formulating via DAX logic

  • Using quick measures and dynamic measures

  • Using conditional statements

  • Performing various transformation on connected dataset

  • How to implement a data warehouse solution

  • Debug and Troubleshoot SSIS packages.

  • Cleansing data by using Data Quality Services.

  • Extend SSIS with custom scripts and components.

  • How to create ETL (Extract,Transform, Load) process

  • How to deploy SSIS Package

  • How to create SSIS package using SQL Server Integration Services

  • How to download and install SQL Server Data Tools

  • How to perform data analysis with SQL Server Analysis Server - SSAS

  • How to create reports using SQL Server Reporting Services

  • How to download and install SQL Server

  • Learning some key operations using T-SQL


BI developers are expected to have a variety of skills that will enable them perform tasks such as: design, implementation and maintenance of structured query language (SQL) databases. They may work as database or web developers, depending on the specific position. SQL developers often spend many work hours seated in front of computers.

As a BI developer, you should have strong analytical, communication, and problem-solving skills. A knowledge of SQL servers, SQL Server Analysis Services -SSAS, SQL Server integration services (SSIS) and server reporting services (SSRS) is also important.







Our review

📍 **Course Overview:** The global course rating stands at 3.30, with recent reviews painting a mixed picture of the learning experience. The course is generally appreciated for its foundational content and usefulness for beginners aspiring to become BI developers. However, several reviewers have highlighted issues with outdated content, repetitive videos, and the absence of essential resources for practical application. **Pros:** - **Beginner-Friendly:** Many learners find the course well-suited for those new to the field of Business Intelligence (BI), especially Power BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and Data Warehousing (DW). - **Comprehensive Overview:** The course offers a broad overview of various topics within the MS BI Universe, which can be beneficial for learners who want to get a sense of the entire ecosystem. - **Educational Value:** Some users report that the content, when updated and accurate, is valuable and helps in learning and revising knowledge on these subjects. - **Easy to Understand:** The course is praised for its ability to explain complex topics in simple English, making it easier for novices to grasp the concepts. **Cons:** - **Outdated Content:** A significant concern raised by several users is the outdated nature of some content, particularly with respect to versions of Visual Studio, SQL Server Data Tools (SSDT), SSIS, SSRS, and SSAS. This can lead to confusion and frustration as learners attempt to apply outdated practices in current environments. - **Resource Availability:** There are complaints about the availability and accuracy of lab materials, with some users unable to complete practical exercises due to incorrect or missing resources. - **Inadequate Support:** The absence of timely support for learner queries is a recurring issue, with no responses provided even after multiple posts. - **Poor Organization:** Some learners find the course materials organized poorly, with unnecessary slow-pacing and repetition that can be both time-wasting and misleading about the actual duration of the content. - **Lack of Depth:** Certain topics, such as T-SQL, are criticized for a lack of depth, with some learners feeling that more detailed explanations and examples would have been beneficial. - **Misrepresentation of Course Duration:** There are allegations that the course duration is misrepresented, with some videos containing extended black screens or repeating content to artificially inflate the running time. **Recommendation for Improvement:** To enhance the value and effectiveness of this course, the following recommendations should be considered: - **Update Content Regularly:** Ensure that all materials are up-to-date with the latest versions and practices within the BI domain. - **Provide Accurate Resources:** Make sure that all necessary lab materials are accurate and accessible for learners to follow along effectively. - **Respond to Learner Queries:** Offer prompt and helpful support to address any questions or issues that arise during the learning process. - **Optimize Video Content:** Review the pacing and structure of the videos to remove unnecessary repetition, black screens, and intros/outros that do not contribute to the educational content. - **Increase Depth in Key Areas:** Expand on critical topics such as T-SQL to provide a more comprehensive understanding for learners. By addressing these concerns, the course can significantly improve its overall quality and become a more valuable resource for those looking to develop skills in the realm of Business Intelligence.

Charts

Price

BI Developer : Learn ( Power BI |SSIS |SSRS |SSAS|DW|T-SQL ) - Price chart

Rating

BI Developer : Learn ( Power BI |SSIS |SSRS |SSAS|DW|T-SQL ) - Ratings chart

Enrollment distribution

BI Developer : Learn ( Power BI |SSIS |SSRS |SSAS|DW|T-SQL ) - Distribution chart
2508692
udemy ID
8/14/2019
course created date
11/20/2019
course indexed date
Bot
course submited by