SQL Server Reporting Services on iOS, Android and Windows 10
4.5 (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.
127 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Reporting Services on iOS, Android and Windows 10 to your Wishlist.

Add to Wishlist

SQL Server Reporting Services on iOS, Android and Windows 10

SQL Server, SSRS Reporting, SSAS, Mobile Reports, Data Analysis, Dashboards, KPI, Business Intelligence
4.5 (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.
127 students enrolled
Created by Siddharth Mehta
Last updated 5/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 2 Articles
  • 62 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Downloadable course content - 10 fully-functional real-life complex dashboards, 55 custom designed shapes and maps, 1 Sample Multidimensional OLAP Database containing fully functional cube with sample data, curated reference material links, and all the examples developed in the course.
  • By end of this course, you should be able to work with actual clients, technology architects, or team leads on a large scale Reporting and Analytics project
  • Design and develop mobile dashboards specially designed and optimized for analytics and accessed from mobile, tablets and similar devices
  • Develop a basic understanding of SQL Server Analysis Services and a detail understanding of SQL Server Reporting Services
  • Learn development of SSRS reports for desktops and well as mobile devices
  • Learn about Microsoft Business Intelligence Architecture, and understand how SSAS and SSRS fits in this architecture.
View Curriculum
Requirements
  • No prior working knowledge of SSAS, SSRS, or Mobile Reporting is required.
  • Basic working knowledge of SQL Server and at least a trial version installable setup of SQL Server is required.
  • Installation and Configuration will be covered in the course
Description

Top 4 Reasons to take this course:

1) You can learn Mobile Reporting and Visual Analytics that can be accessed on Mobile Platforms like iOS, Android and Windows 10 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, Mobile Analytics, Data Visualizations, Data Mining and Data Analytics in real-world client projects internationally.

2) In a single course, without any prior SSAS experience - You can learn installation of SQL Server, SSAS and SSRS. Post installation you will learn how to consume data from SSAS multi-dimensional cube (which is composed of billions of rows typically) using MDX Query Designer into mobile dashboards for visual analytics by CxOs of an organization.

3) You get to train yourself on a number of analytical charts, graphs and gauges and understand the applicability of the same for different types of data and scenarios.

4) Downloadable Course Content:

  • 10 Fully functional dashboards with desktops, tablet and mobiles layouts targeted for iOS, Android and Windows 10
  • 1 Sample Multidimensional OLAP SSAS Database with sample data
  • 50+ Custom geographical maps ( which are not available out-of-box )
  • All examples developed in the course
  • Short guides on using Charts and Graphs
  • Links to key resources

Course Description

Visual Analytics with SSAS and SSRS on iOS Android and Windows 10 is a  course in which a student having no experience in analytics, reporting and visualizations would be trained step by step from basics. The intention of this course is to empower students with the knowledge of developing mobile dashboards for senior leadership of an organization like CEO, COO etc. 

These skills can potentially yield salaries of $85 - $150k based only on your experience of data visualizations and mobile reporting techniques using Microsoft BI Tools using the latest version of SQL Server Analysis Services and SQL Server Reporting Services 2016.

Course includes practical hands-on exercises as well as theoretical coverage of key concepts. Anyone pursuing this course would be able to clearly understand about Microsoft Business Intelligence Architecture, Microsoft Mobile Reporting Architecture and understand how SSAS fits in this architecture along with other tools like Power BI.

This course does not cover any native mobile programming, and SSAS as well as MDX Query Techniques is covered limited to the scope of using it as a data source.


Who is the target audience?
  • Open minded professionals seeking to give a competitive edge to their carrer in the field of data and analytics should definitely consider in enrolling for this course.
  • This course is for those who want to start a career in the mobile platform space by learning a niche mobile reporting skill
  • If you are planning to appear for a Reporting and Analytics job interview, this course is for you
  • This course is specially designed for those working or who want to work in the role of Reporting Architect / Reporting SME.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
61 Lectures
05:59:56
+
Introduction
2 Lectures 08:54

Instructor Introduction and Hardware / Software Requirements

Preview 03:14

Course objectives and curriculum walk-through

Preview 05:40
+
Visual Analytics Theory
6 Lectures 49:08

Importance of Visual Analytics for Mobile Reporting

Importance of Visual Analytics for Mobile Reporting
08:06

Examples and explanation on visualizing patterns

Visualizing Patterns
06:54

Examples and explanation on visualizing proportions

Visualizing Proportions
12:13

Examples and explanation on visualizing relationships

Visualizing Relationships
09:15

Examples and explanation on visualizing similarities and differences

Visualizing Differences
06:12

Examples and explanation on visualizing geospatial data

Visualizing Geospatial
06:28
+
Fundamentals of Analytics and Reporting Architecture and Tools
7 Lectures 39:07

Detailed explanation of Business Intelligence& Analytics Architecture

Preview 08:25

SSRS Mobile Reporting Architecture and Tools Overview

SSRS Mobile Reporting Architecture and Tools Overview
08:57

SQL Server, SSAS and SSRS Installation Guide

Preview 05:33

SSAS and SSRS Configuration Settings

SSAS and SSRS Configuration
05:52

Download and configure SSAS Multi-dimensional Database on SSAS Instance

Downloading and Configuring Sample Data
02:44

Create a quick small report project with a wizard using SSAS as a data source and SSRS for reporting.

Hello World with SSAS and SSRS
05:25

Deploy SSRS Report on SSRS Web Portal

Reports Deployment
02:11
+
Exploring & Profiling Analytical Data in SSAS
4 Lectures 36:46

Open SSAS Database in SQL Server Data Tools and understand important components of SSAS.

Introduction to SSAS - Fundamentals, Internals and Concepts
08:07

Understand Dimensional Model of a SSAS Cube and how it can be useful for reporting

Dimensional Modeling of SSAS Cube
08:52

Learn how to browse, explore and profile data in dimensions and measures

MDX Query - Cube, Dimensions & Measures
12:33

Learn how to explore and profile KPIs, and create analytical reports in excel using KPIs.

MDX Query - Key Performance Indicators
07:14
+
Analytical and Paginated Reporting for Desktops
7 Lectures 01:09:20

Learn how to use List, Tables, and Matrices to represent analytical data from SSAS Cubes on SSRS Reports for Desktop Reporting.

Tables, Matrices and List
17:04

Learn how to add parameters to a SSRS Analytical Report

Parameters
11:42

Learn about SSRS Charts and how to use the same in Analytical SSRS Reports using SSAS as the data source.

Charts
08:31

Learn about Gauges and how to use the same in Analytical SSRS Reports using SSAS as the data source.

Gauge
08:41

Learn about Sparklines and Databars and how to use the same in Analytical SSRS Reports using SSAS as the data source.

Sparkline and DataBars
08:43

Learn about State Indicators and how to use the same in Analytical SSRS Reports using SSAS as the data source.

State Indicator
03:37

Learn about Maps and how to use the same in Analytical SSRS Reports using SSAS as the data source.

Maps
11:02
+
Mobile Reporting Tools - Installation and Software Setup
5 Lectures 27:07

Architecture and Design Considerations for using SSRS and Mobile Report Publisher for Mobile Reporting

Design and Architecture Considerations
13:16

Introduction to SQL Server Mobile Report Publisher

Introducing - Mobile Report Publisher
04:42

Learn how to install Power BI Mobile App and integrate the same with SQL Server Reporting Services

Install and Integrate Power BI Mobile App with SSRS
04:49

Learn how to create shared datasets using SSAS as the data source, and use these data sets in mobile reports

Developing Shared Datasets for Mobile Reports using Report Builder
04:15

Download links of Report Builder and Mobile Report Publisher

Resources
00:05
+
Mobile Data Grids
3 Lectures 27:45

Learn how to use Simple Data Grid for mobile reporting and visual analytics

Simple data grid
14:07

Learn how to use Indicator Data Grid for mobile reporting and visual analytics

Indicator data grid
09:12

Learn how to use Chart Data Grid for mobile reporting and visual analytics

Chart data grid
04:26
+
Mobile Charts
6 Lectures 34:05

Learn how to use Pie chart and Funnel chart for mobile reporting and visual analytics

Pie chart and Funnel chart
05:45

Learn how to use Totals chart and Comparison totals chart for mobile reporting and visual analytics

Totals chart and Comparison totals chart
05:44

Learn how to use Category chart and Comparison category chart for mobile reporting and visual analytics

Category chart and Comparison category chart
05:52

Learn how to use Time chart and Comparison time chart for mobile reporting and visual analytics

Time chart and Comparison time chart
06:30

Learn how to use Waterfall Chart for mobile reporting and visual analytics

Waterfall chart
05:32

Learn how to use Treemap chart for mobile reporting and visual analytics

Treemap chart
04:42
+
Mobile Maps
2 Lectures 06:27

Learn how to use different types of maps like Gradient Map, Range stop heat map ap, and Bubble Map for mobile reporting and visual analytics

Gradient Map - Range stop heat Map - Bubble Map
04:49

Learn how to add custom maps in Mobile Reports Publisher for reporting data on custom shapes

Adding Custom Maps
01:38
+
Mobile Gauges
3 Lectures 13:43

Learn how to use gauges like Number, Delta, Numbers and Delta, and Delta Indicator for mobile reporting and visual analytics

Numbers and Delta
05:09

Learn how to use gauges like donut gauge, speedometer gauge, cylinder gauge and thermometer gauge for mobile reporting and visual analytics.

Radial and Linear Gauges
03:58

Learn how to use progress bar gauge, linear gauge and bullet graph gauge for mobile reporting and visual analytics.

Progress bars and graphs
04:36
3 More Sections
About the Instructor
Siddharth Mehta
4.1 Average rating
454 Reviews
5,260 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