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

Description

*** This course includes LIFETIME access, More content is being developed,quality of lectures are a 100% satisfaction guarantee ***

Reviews from some of our students
"
I had little knowledge about Business Intelligence. But after attending this course and practising the examples. I can now do BI solutions on my own.
"
-Edwin Molapo
"Great course. I am in College currently getting my BA in Data Analytics and this course has help solidify my learning and also helped me with projects we had in our classes. I would highly recommend for and Business Intelligence seekers "
-Jared Rentz
"
Easy to follow and very understandable
"
-Dilli Sharma
As data volumes are exploding, more data has been created in the past two years than in the entire previous history of the human race. With an estimate of 4.1 zettabyets of data available today, the numbers  just keeps increasing every second. Organizations today estimate that only a fraction of recorded data can be analyzed, and IT professionals who can work with data by Data Integration, Data Analyzation, Data Visualization etc. in short a 'Data Geek' are becoming increasingly popular.
In Simpler terms, there is enormous amount of data and not enough professionals to manage it.This course aims to close that gap with SQL Server Management Studio and SQL Server Data Tools for Business Intelligence (BI).
We will Learn from the basics of creating a Microsoft Business Intelligence (MS BI)ecosystem, Sql server Integrating services(SSIS), Sql Server Analysis Services (SSAS), Sql Server Reporting Services (SSRS) and putting all of them together to learn the Complete Microsoft Business Intelligence (MS BI)
Learn and Master Microsoft Business Intelligence(MS BI) in this Comprehensive course.
SSIS(Sql Server Integrating Services)
Extracting Data from Source.
Transforming the Data in a staging area
Loading the data onto a destination
Managing different types of sources and destinations
Implementing aggregates and transformations 
Managing data flow and control flow tasks
SSAS(Sql Server Analysis Services)
Configuring analysis services
Creating a cube
Managing data in the data source view
Designing and deploying Cube dimensions and meassures
SSRS(Sql Server Reporting Services)
Creating reports and visualizations 
With 6 years of experience in the BI, Data analytics and Big Data, be sure to get rich content to help you succeed. Although it is still in the beginning phase but more in depth and quality lectures are being added regularly.
Who this course is for:
Fresh graduates looking for a job as a BI developer
Any working individual willing to switch career path to BI and looking for that breakthrough
BI developers who are willing to learn a new tool

What you'll learn

Perform file system tasks

Perform FTP tasks

Create dynamic properties with variables

Perform ETL jobs (Extraction, Transformation and Loading)

Perform Aggregates, Sorting and Conditional Splitting of data

Create analytic cube in SSAS

Design the Cube Dimensions and Measures

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-Setting up your Microsoft BI environment
6
1.1-Downloading the right file for installation
1.2-Installation guide for SQL Server Management Studio 2014
1.3-Installing Visual Studio SSDT-BI
1.4-Setup Adventure Works DW 2012 for Analytic Services Practice
1.5-Create a new database and a new table in ssms
1.6-How to Insert, truncate and drop a table?
2-SSIS Control Flow Tasks
10
2.1-FTP Server File download using SSIS
2.2-Creating new package and a look around the interface
2.3-Move files using a File System Task
2.4-Creating a table in SSMS using a Execute SQL Task
2.5-Inserting into the new table and truncate the old table using Execute SQL Task
2.6-Take Backup of Database using the Backup Database Task
2.7-Variables: Create a new user defined variable
2.8-Variables: Create a new file system task
2.9-Variables: Establishing a logical connection between Variables and File Sys Task
2.10-Copy 'n' number of files using the Foreach Loop container
3-SSIS Data Flow Tasks
8
3.1-Introduction to Data Flow Tasks and its components
3.2-Transfer Data from a Flat File Source to an OLE-DB Destination
3.3-Performing Aggregates.
3.4-Storing aggregated data in a table using OLEDB Destination
3.5-Performing a Conditional Split
3.6-Sorting data in ascending or descending order
3.7-Creating a Derived column
3.8-Performing data merge with two ways to sort the data
4-SSAS : Designing Cubes for Analysis
10
4.1-Creating a new project and configuring a Data source for SSAS Cube
4.2-Creating and Understanding the Data Source View
4.3-Creating a Cube by assigning Dimensions, Measures and changing column names
4.4-Deploying and viewing the cube
4.5-Browse the cube before Deployment
4.6-Dimension Designing 1: Gathering required columns and renaming them
4.7-Dimension Designing 2: Creating Named calculated columns
4.8-Dimension Designing 3: Named Column-Getting underlyinng data of a key
4.9-Dimension Desingning 4: Grouping dimensions into logical categories
4.10-Creating a Hierarchy
5-SSRS: Understanding report creation, management and deployment
4
5.1-What is SSRS?
5.2-Life Cycle of a Report
5.3-Getting started and looking at the Reporting Services interface
5.4-Connecting to a Data Source using Embedded Connection