image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

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.
Who this course is for:
Beginner Data Analyst
Beginner Data Scientist
Beginner Business Intelligence Analyst
Beginners to Power BI

What you'll 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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-SQL Server Setup
11
1.1-Introduction
1.2-What is SQL Server
1.3-SQL Server Editions
1.4-SQL Server Installation Requirements
1.5-Download SQL Server
1.6-Install SQL Server
1.7-Install SSMS
1.8-Connect SSMS to SQL Server
1.9-Please Read
1.10-Install adventureworks Database
1.11-Install adventureworksDW Database
2-Visual Studio Setup
6
2.1-What is Visual Studio
2.2-Visual studio installation requirements
2.3-Visual studio workloads
2.4-Installing Visual studio
2.5-Install SQL Server Data Tools
2.6-Install SSDT BI Templates
3-Implementing ETL with SSIS
16
3.1-What is ETL
3.2-ETL Process - Illustration
3.3-What is SSIS
3.4-Installing SQL Server Integration Service
3.5-Connect to SSIS
3.6-Create a a new SSIS Package
3.7-SSIS designer
3.8-Add and configure a flat file connection manager
3.9-Remapping column data types
3.10-Add and configure an OLE DB connection manager
3.11-Add a data flow task to package
3.12-Add and Configure flat file source
3.13-Add and configure lookup transformations
3.14-Add and configure lookup datekey transformations
3.15-Add and configure OLE DB Destination
3.16-Test and Run SSIS Package
4-SQL Server Reporting Services - SSRS
15
4.1-What is SSRS
4.2-Installing SQL Server Reporting Services
4.3-Report Server configuration requirements
4.4-Configure Report Server
4.5-Create a report server project
4.6-Create a report definition file
4.7-Configure a data source for the report
4.8-Define a dataset
4.9-Add table to report
4.10-Format report
4.11-Adding totals
4.12-Previewing report
4.13-Exporting report
4.14-Grouping data in a report
4.15-Publishing report
5-SQL Server Analysis Services - SSAS
24
5.1-What is SSAS
5.2-Install SSAS
5.3-Connecting to SSAS
5.4-Creating a tabular model project
5.5-Exploring tabular model and authoring
5.6-Creating a connection to the data source
5.7-Transform and import data
5.8-Mark as data table
5.9-Create table relationships
5.10-Create calculated columns: Part 1
5.11-Create calculated columns: Part 2
5.12-Creating measures : Part 1
5.13-Creating measures : Part 2
5.14-Creating measures : Part 3
5.15-Creating key performance indicators -KPI's
5.16-Creating Perspectives
5.17-Creating hierarchies : Part 1
5.18-Creating hierarchies : Part 2
5.19-What are partitions
5.20-Creating partitions
5.21-Creating roles
5.22-Analyze in Excel
5.23-Deploying Model
5.24-Analysing Model
6-Power BI Setup
6
6.1-What is Power BI
6.2-What is Power BI Desktop
6.3-Microsoft 365 setup
6.4-Exploring Microsoft 365
6.5-Creating user accounts on Microsoft 365
6.6-Exploring Power BI Interface
7-Overview of Power BI
7
7.1-Power BI Overview: Part 1
7.2-Power BI Overview: Part 2
7.3-Power BI Overview: Part 3
7.4-Components of Power BI
7.5-Building blocks of Power BI
7.6-Power BI Service
7.7-Power BI Apps
8-Data Analysis & Visualization with Power BI
8
8.1-Connecting to SQL Server Database
8.2-Connecting to web data
8.3-Clean and transform data : Part 1
8.4-Clean and transform data : Part 2
8.5-Combine data sources
8.6-Creating Visualizations: Part 1
8.7-Creating Visualizations: Part 2
8.8-Publishing reports to Power BI Service