Microsoft Business Intelligence Tools: SSIS,SSRS,SSAS,BI

Microsoft Business Intelligence Tools: SSIS,SSRS,SSAS,BI, available at $64.99, has an average rating of 4, with 93 lectures, based on 38 reviews, and has 2144 subscribers.

You will learn about Connect to multiple data sources Clean, Transform and import data Create data relationships Implementing ETL with SSIS Create and execute SSIS Package Configure SSRS Report Server Create and publish reports with SSRS Create tabular model with SSAS Create key performance indicators -KPI's Create Perspectives Create hierarchies Analyze in Excel Deploy and Analyze Model Create data visualizations and dashboards Publish reports to the Power BI Service This course is ideal for individuals who are Beginner Data Analyst or Beginner Data Scientist or Beginner Business Intelligence Analyst or Beginners to Power BI It is particularly useful for Beginner Data Analyst or Beginner Data Scientist or Beginner Business Intelligence Analyst or Beginners to Power BI.

Enroll now: Microsoft Business Intelligence Tools: SSIS,SSRS,SSAS,BI

Summary

Title: Microsoft Business Intelligence Tools: SSIS,SSRS,SSAS,BI

Price: $64.99

Average Rating: 4

Number of Lectures: 93

Number of Published Lectures: 93

Number of Curriculum Items: 93

Number of Published Curriculum Objects: 93

Original Price: $124.99

Quality Status: approved

Status: Live

What You Will Learn

Connect to multiple data sources
Clean, Transform and import data
Create data relationships
Implementing ETL with SSIS
Create and execute SSIS Package
Configure SSRS Report Server
Create and publish reports with SSRS
Create tabular model with SSAS
Create key performance indicators -KPI's
Create Perspectives
Create hierarchies
Analyze in Excel
Deploy and Analyze Model
Create data visualizations and dashboards
Publish reports to the Power BI Service

Who Should Attend

Beginner Data Analyst
Beginner Data Scientist
Beginner Business Intelligence Analyst
Beginners to Power BI

Target Audiences

Beginner Data Analyst
Beginner Data Scientist
Beginner Business Intelligence Analyst
Beginners to Power BI

Business intelligence (BI) combines business analytics, data mining, data visualisation, data tools and infrastructure, and best practices to help organisations to make more data-driven decisions. In practice, you know you’ve got modern business intelligence when you have a comprehensive view of your organisation’s data and use that data to drive change, eliminate inefficiencies and quickly adapt to market or supply changes. Business intelligence comprises the strategies and technologies used by enterprises for the data analysis and management of business information.

Microsoft BI tools provide a solution for handling the volume of important business intelligence information continuously generated by modern companies. With the right tools, you can process huge amounts of data in mere seconds, and it is this part of the process that counts. Any business can collect information, but it takes skill and careful management using business intelligence tools to make it valuable. This is the essence of “business intelligence”: the ability to take vast quantities of market data and extract trends and patterns.

The Microsoft BI Suite is the software giant’s suite of tools designed for easy data processing. That’s putting it a bit simply, but these programs do have a simple objective. The system aims to help businesses turn all of that messy, complex information into extractable insights. It is one of the most popular BI solutions on the market right now.

The full range of tools enables businesses to direct data through IT systems, identify and isolate data, and create expansive reports on the current status of different departments. They include (SQL Server Integration Services), SSAS (SQL Server Analytical Services) and SSRS (SQL Server Reporting Services) and Power BI

With these tools, any mass of data can be turned into a digestible report, dashboard, graph, spreadsheet or another format. You just need to input your parameters and let the system know what you need. The Microsoft business intelligence platform works by moving data from multifarious, unmanageable sources to a centralized architecture where it can be reconfigured.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: SQL Server Editions

Lecture 4: SQL Server Installation Requirements

Lecture 5: Download SQL Server

Lecture 6: Install SQL Server

Lecture 7: Install SSMS

Lecture 8: Connect SSMS to SQL Server

Lecture 9: Please Read

Lecture 10: Install adventureworks Database

Lecture 11: Install adventureworksDW Database

Chapter 2: Visual Studio Setup

Lecture 1: What is Visual Studio

Lecture 2: Visual studio installation requirements

Lecture 3: Visual studio workloads

Lecture 4: Installing Visual studio

Lecture 5: Install SQL Server Data Tools

Lecture 6: Install SSDT BI Templates

Chapter 3: Implementing ETL with SSIS

Lecture 1: What is ETL

Lecture 2: ETL Process – Illustration

Lecture 3: What is SSIS

Lecture 4: Installing SQL Server Integration Service

Lecture 5: Connect to SSIS

Lecture 6: Create a a new SSIS Package

Lecture 7: SSIS designer

Lecture 8: Add and configure a flat file connection manager

Lecture 9: Remapping column data types

Lecture 10: Add and configure an OLE DB connection manager

Lecture 11: Add a data flow task to package

Lecture 12: Add and Configure flat file source

Lecture 13: Add and configure lookup transformations

Lecture 14: Add and configure lookup datekey transformations

Lecture 15: Add and configure OLE DB Destination

Lecture 16: Test and Run SSIS Package

Chapter 4: SQL Server Reporting Services – SSRS

Lecture 1: What is SSRS

Lecture 2: Installing SQL Server Reporting Services

Lecture 3: Report Server configuration requirements

Lecture 4: Configure Report Server

Lecture 5: Create a report server project

Lecture 6: Create a report definition file

Lecture 7: Configure a data source for the report

Lecture 8: Define a dataset

Lecture 9: Add table to report

Lecture 10: Format report

Lecture 11: Adding totals

Lecture 12: Previewing report

Lecture 13: Exporting report

Lecture 14: Grouping data in a report

Lecture 15: Publishing report

Chapter 5: SQL Server Analysis Services – SSAS

Lecture 1: What is SSAS

Lecture 2: Install SSAS

Lecture 3: Connecting to SSAS

Lecture 4: Creating a tabular model project

Lecture 5: Exploring tabular model and authoring

Lecture 6: Creating a connection to the data source

Lecture 7: Transform and import data

Lecture 8: Mark as data table

Lecture 9: Create table relationships

Lecture 10: Create calculated columns: Part 1

Lecture 11: Create calculated columns: Part 2

Lecture 12: Creating measures : Part 1

Lecture 13: Creating measures : Part 2

Lecture 14: Creating measures : Part 3

Lecture 15: Creating key performance indicators -KPI's

Lecture 16: Creating Perspectives

Lecture 17: Creating hierarchies : Part 1

Lecture 18: Creating hierarchies : Part 2

Lecture 19: What are partitions

Lecture 20: Creating partitions

Lecture 21: Creating roles

Lecture 22: Analyze in Excel

Lecture 23: Deploying Model

Lecture 24: Analysing Model

Chapter 6: Power BI Setup

Lecture 1: What is Power BI

Lecture 2: What is Power BI Desktop

Lecture 3: Microsoft 365 setup

Lecture 4: Exploring Microsoft 365

Lecture 5: Creating user accounts on Microsoft 365

Lecture 6: Exploring Power BI Interface

Chapter 7: Overview of Power BI

Lecture 1: Power BI Overview: Part 1

Lecture 2: Power BI Overview: Part 2

Lecture 3: Power BI Overview: Part 3

Lecture 4: Components of Power BI

Lecture 5: Building blocks of Power BI

Lecture 6: Power BI Service

Lecture 7: Power BI Apps

Chapter 8: Data Analysis & Visualization with Power BI

Lecture 1: Connecting to SQL Server Database

Lecture 2: Connecting to web data

Lecture 3: Clean and transform data : Part 1

Lecture 4: Clean and transform data : Part 2

Lecture 5: Combine data sources

Lecture 6: Creating Visualizations: Part 1

Lecture 7: Creating Visualizations: Part 2

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes
2 stars: 2 votes
3 stars: 8 votes
4 stars: 9 votes
5 stars: 16 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