SSAS Azure, Tabular SSAS, Data Migration, and Administration
3.8 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
80 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SSAS Azure, Tabular SSAS, Data Migration, and Administration to your Wishlist.

Add to Wishlist

SSAS Azure, Tabular SSAS, Data Migration, and Administration

SQL Server Analysis Services, SSAS, Azure, SQL Azure, Tabular SSAS, Data Analysis, Business Intelligence, Data Migration
3.8 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
80 students enrolled
Created by Siddharth Mehta
Last updated 5/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 2 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to build a new SQL Azure Server, SQL Azure Database and SSAS Azure Server
  • Learn how to populate data in SQL Azure database
  • Learn how to source data from SQL Azure to develop SSAS Azure Tabular data model
  • Learn how to host SSAS Tabular model on SSAS Azure server
View Curriculum
Requirements
  • Install SQL Server 2016 Database Engine (Trial or higher version)
  • Install SQL Server 2016 Analysis Services – Tabular Server Mode (Trial or higher version)
  • Install SQL Server Management Studio and SQL Server Data Tools on Visual Studio 2015 or higher
Description

Top 2 Reasons to take this course

1) You can learn developing tabular data models on SSAS Azure from scratch as well as ask questions directly to a Published Author, Microsoft MVP, and a Senior Technology Architect with more than 14 years of experience who actively practices Business Intelligence, Data Mining and Analytics in real-world client projects internationally.

2) Learn to work with SQL Azure as well as SSAS Azure from scratch using a free Microsoft Azure subscription for a month. Understand and practice SSAS Tabular data model development as well as deployment approach in less than 2 hours. The course also provides key resources like links to development tools and sample data warehouse.

Course Description

This is an introductory fast-track course for SSAS professionals / beginners who want to spend an hour or two and learn the process of developing tabular SSAS solutions on Azure cloud. This course is about how a SQL Azure and SSAS Azure can be used to host a brand new SSAS Tabular solution in less than 2-3 hours. The course is explained using a FREE Trial Subscription of Microsoft Azure available to any first time Azure user.

This course is not meant to be an exhaustive reference of SSAS Tabular / Azure & SQL Azure Data Modeling or Development. This is a 100% practical course with hands-on practical examples of the approach for developing SSAS Tabular data model on Azure cloud.

Who is the target audience?
  • Professionals who are willing to host SSAS Tabular instances on Azure cloud using SSAS Azure
  • Students who already have some basic idea of SSAS Tabular and wants to apply this knowledge on cloud platform
  • Analytics and data modeling professionals who intend to learn SSAS cloud development without any administrative efforts
Students Who Viewed This Course Also Viewed
Curriculum For This Course
15 Lectures
01:10:10
+
Introduction
2 Lectures 05:36

Instructor Introduction

Preview 01:05

Course objectives and what you will need to start practicing the exercises in the course

Preview 04:31
+
Overview
4 Lectures 21:31

High level overview of Microsoft Azure in context of SQL Azure and SSAS Azure

Preview 05:02

Database offerings in Microsoft Azure

Database offerings in Microsoft Azure
05:03

Analytics offerings in Microsoft Azure

Analytics offerings in Microsoft Azure
04:07

Estimate cost of using SQL Azure and SSAS Azure services in Microsoft Azure

Pricing Calculator
07:19
+
Installation and Configuration
3 Lectures 23:26

Build and configure SQL Azure server and database

SQL Azure Server and Database - Build and Configure
09:49

Load a data warehouse data from local instance on SQL Server to SQL Azure

SQL Azure Database - Sample Data
07:23

Build and configure SSAS Azure Server

SSAS Azure Database Server - Build and Configure
06:14
+
Data Model development and deployment
3 Lectures 15:59

Load a dimension and a fact table from SQL Azure in your SSAS Tabular data model

SSAS Azure - Data Model Development
07:51

Deploy SSAS Tabular data model on SSAS Azure

SSAS Azure - Data Model Deployment
03:08

Query a SSAS Azure hosted tabular data model using SSMS and DAX Query

Querying data from SSAS Azure to build reports
05:00
+
Summary
3 Lectures 03:54

Course Summary

Summary
02:42

Links to key resources

Resources
00:12

Bonus Lecture - Discount coupons of my other courses

Bonus Lecture - Discount Coupons of my other courses
01:00
About the Instructor
Siddharth Mehta
4.1 Average rating
453 Reviews
5,248 Students
7 Courses
Published Author, Microsoft MVP Alumni, Sr. Tech Arch

My name is Siddharth Mehta. I work in the role of a Senior Technology Architect with a multinational IT firm. I have career experience of more than 14 years in the IT industry working with multinational IT companies and Fortune 500 clients. 

Industry Experience

-|- International experience of working across geographies (US, UK, Singapore) for multi-national clients in Banking, Logistics, Government, Media Entertainment, Products, Life Sciences and other domains

-|- I usually work as a lead architect for a portfolio of applications in web, mobile, BI, Analytics, Data warehousing, Reporting, Collaboration, CMS, NoSQL and other categories.

-|- In my present role, I remain responsible for Arch Design, Tech Stack selection, Infra design, 3rd party products evaluation and procurement, and Performance engineering. My primary specialty is Microsoft SQL Server and Microsoft Business Intelligence. I usually work with MS BI integration with cross technologies like Elasticsearch / Lucene, MongoDB, Sharepoint 2013 and 2010, jQuery based framework like Highcharts and GoJS, jQueryMobile, Bootstrap, iOS xCode framework, and many others.

Authoring Achievements

-|- I have authored more than 200 articles and tutorials collectively for online publications like mssqltips, sqlserverperformance, sqlservercental, techrepublic and others.

-|- I have authored / co-authored as well as reviewed books for print-media publication houses like Manning publication, Packt publication.

-|- I have also authored a whitepaper for MSDN Library titled: Bulk report generation using SSIS and SSRS 2008 R2.

Certifications

-|- TOGAF 9 Part I & II certified architect
-|- CITA-F certified architect
-|- HCAHD (Hortonworks Hadoop certified)
-|- MCSD.Net, and MCTS in SQL Server maintenance as well as Developing BI apps using SQL Server
-|- Certified Sr. Technology Architect as well as Digital Architect

Academics

Master of Science with major in Computer Applications and Information Technology