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

You will learn about 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 This course is ideal for individuals who are Beginner Data Analyst or Beginner Business Analyst or Beginner BI Developer or Beginner Data Scientist It is particularly useful for Beginner Data Analyst or Beginner Business Analyst or Beginner BI Developer or Beginner Data Scientist.

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

Summary

Price: $69.99

Average Rating: 3.4

Number of Lectures: 177

Number of Published Lectures: 163

Number of Curriculum Items: 177

Number of Published Curriculum Objects: 163

Original Price: $124.99

Quality Status: approved

Status: Live

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

Who Should Attend

Beginner Data Analyst
Beginner Business Analyst
Beginner BI Developer
Beginner Data Scientist

Target Audiences

Beginner Data Analyst
Beginner Business Analyst
Beginner BI Developer
Beginner Data Scientist

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.

Course Curriculum

Chapter 1: Getting Started with Power BI

Lecture 1: Introduction

Lecture 2: What is Power BI

Lecture 3: Signing Up to Office 365

Lecture 4: What is Power BI Desktop

Lecture 5: Installing Power BI Desktop

Lecture 6: Exploring Power BI Desktop

Lecture 7: Exploring Power BI Service

Lecture 8: Overview of Power BI – Part 1

Lecture 9: Overview of Power BI – Part 2

Lecture 10: Overview of Power BI – Part 3

Lecture 11: Building Blocks of Power BI

Lecture 12: What are Power BI Apps

Lecture 13: Connecting to web based data source

Lecture 14: Cleaning and transforming data – Part 1

Lecture 15: Cleaning and transforming data – Part 2

Lecture 16: Combining Data Sources

Lecture 17: Creating Data Visualization with Power BI – Part 1

Lecture 18: Creating Data Visualization with Power BI – Part 2

Lecture 19: Publishing Report to Power BI Service

Lecture 20: Importing and transforming data from access database

Lecture 21: Changing Locale Settings

Lecture 22: Transforming Less Structured Data

Lecture 23: Query Parameters

Chapter 2: Transforming and Modelling Data with Power BI

Lecture 1: What is Data Modelling

Lecture 2: Connecting to a Data Source

Lecture 3: Power Query Editor and Queries

Lecture 4: Creating and managing Query Groups

Lecture 5: Renaming Queries

Lecture 6: Splitting Columns

Lecture 7: Changing Data Types

Lecture 8: Removing and Reordering Columns

Lecture 9: Duplicating and adding columns

Lecture 10: Creating conditional columns

Lecture 11: Connecting to Files in a Folder

Lecture 12: Appending Queries

Lecture 13: Merging Queries

Lecture 14: Creating and Managing Data Relationship

Lecture 15: Creating calculated columns

Lecture 16: Optimizing Models for Reporting

Lecture 17: Performing Time intelligence on data model

Chapter 3: Microsoft SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server 2019 Hardware | Software Installation Requirements

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server 2019 Developer Edition

Lecture 5: SQL Server 2019 Developer Edition Installation

Lecture 6: Installing SQL Server Management Studio

Lecture 7: Connecting to SQL Server with SSMS

Lecture 8: SQL Server Configuration Manager

Lecture 9: Install adventureworks 2016 database

Lecture 10: Install adventureworksdDW 2016 database

Chapter 4: SQL Server Reporting Services Setup

Lecture 1: Installing Reporting Services

Lecture 2: Configure Report Server

Lecture 3: Accessing Report Server Web Portal Locally

Lecture 4: Accessing Report Server Web Portal Remotely

Lecture 5: Configure SSMS for local SSRS administration

Lecture 6: Adding users and groups to SSRS

Lecture 7: Installing Report Builder

Chapter 5: Setup for Visual Studio 2019 ,SSIS.SSRS.SSAS,BI Designer Templates

Lecture 1: What is Visual Studio

Lecture 2: Minimum Installation Requirements for Visual Studio 2019

Lecture 3: Installing Visual Studio

Lecture 4: Installing SQL Server Data Tools (SSDT)

Lecture 5: Installing Designers for SSIS,SSAS,SSRS

Chapter 6: Getting started with T-SQL

Lecture 1: What is T-SQL

Lecture 2: Querying Data using SELECT Statement

Lecture 3: Creating Views

Lecture 4: Using Comments

Lecture 5: Using Stored Procedures

Lecture 6: Removing duplicates

Lecture 7: Filtering records with equality filters

Lecture 8: Filtering records with comparison filters

Lecture 9: Filtering records with logical filters

Lecture 10: Filtering records with NULL values

Lecture 11: Using ORDER BY clause

Lecture 12: Sorting by ascending order

Lecture 13: Sorting by descending

Lecture 14: Adding new records to database

Lecture 15: Updating Records

Lecture 16: Deleting Records

Lecture 17: Using CASE expression

Lecture 18: Introduction to Table Joins

Lecture 19: INNER Join

Lecture 20: LEFT OUTER Join

Lecture 21: RIGHT OUTER Join

Chapter 7: Microsoft SQL Server Integration Services – SSIS

Lecture 1: What is SSIS

Lecture 2: What is Visual Studio

Lecture 3: Minimum Requirements to Install Visual Studio

Lecture 4: Visual Studio WorkLoads

Lecture 5: Installing Visual Studio

Lecture 6: Introduction to SSIS

Lecture 7: How to create a new SSIS Project with Visual studio

Lecture 8: Download and install SQL Server Data Tools- SSDT

Lecture 9: Create a new SSIS Project

Lecture 10: Add a Flat File Connection Manager

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 25 votes
2 stars: 10 votes
3 stars: 82 votes
4 stars: 153 votes
5 stars: 169 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu