Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Microsoft Business Intelligence

Complete Business Intelligence with SSIS, SSAS and SSRS

Master Microsoft BI by solving Real-Life Problems. Learn ETL, Integration, Analytics, Reporting and Visualization!
Rating: 4.2 out of 54.2 (334 ratings)
2,120 students
Created by Ikram Haq
Last updated 11/2017
English
30-Day Money-Back Guarantee

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

  • Basic SQL and Data warehousing concepts

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

Course content

5 sections • 38 lectures • 2h 52m total length

  • Preview02:34
  • Preview04:01
  • Preview02:29
  • Preview02:17
  • Preview03:10
  • How to Insert, truncate and drop a table?
    04:41

  • FTP Server File download using SSIS
    05:55
  • Creating new package and a look around the interface
    02:48
  • Move files using a File System Task
    06:31
  • Creating a table in SSMS using a Execute SQL Task
    04:40
  • Inserting into the new table and truncate the old table using Execute SQL Task
    06:32
  • Take Backup of Database using the Backup Database Task
    03:51
  • Variables: Create a new user defined variable
    03:58
  • Variables: Create a new file system task
    02:45
  • Variables: Establishing a logical connection between Variables and File Sys Task
    03:35
  • Copy 'n' number of files using the Foreach Loop container
    04:04

  • Introduction to Data Flow Tasks and its components
    03:13
  • Transfer Data from a Flat File Source to an OLE-DB Destination
    07:54
  • Performing Aggregates.
    04:03
  • Storing aggregated data in a table using OLEDB Destination
    03:06
  • Performing a Conditional Split
    06:42
  • Sorting data in ascending or descending order
    03:10
  • Creating a Derived column
    06:15
  • Performing data merge with two ways to sort the data
    07:17

  • Creating a new project and configuring a Data source for SSAS Cube
    05:06
  • Creating and Understanding the Data Source View
    07:51
  • Creating a Cube by assigning Dimensions, Measures and changing column names
    08:08
  • Deploying and viewing the cube
    05:30
  • Browse the cube before Deployment
    02:18
  • Dimension Designing 1: Gathering required columns and renaming them
    07:16
  • Dimension Designing 2: Creating Named calculated columns
    04:05
  • Dimension Designing 3: Named Column-Getting underlyinng data of a key
    04:34
  • Dimension Desingning 4: Grouping dimensions into logical categories
    06:14
  • Creating a Hierarchy
    02:24

  • What is SSRS?
    02:33
  • Life Cycle of a Report
    02:24
  • Getting started and looking at the Reporting Services interface
    03:47
  • Connecting to a Data Source using Embedded Connection
    05:06

Instructor

Ikram Haq
Data analyst and BI Consultant
Ikram Haq
  • 4.2 Instructor Rating
  • 334 Reviews
  • 4,044 Students
  • 3 Courses

I am a Business and Data analyst  and a Business Intelligence consultant with over five years of experience in telecom, customs,finance, retail, transport and other industries. I was trained by the best analytics mentors at at top Multi national Companies, today I leverage Big Data to drive business strategy, revamp customer experience and revolutionize existing operational processes.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.