
Instructor Introduction and Hardware / Software Requirements
Course objectives and curriculum walk-through
Importance of Visual Analytics for Mobile Reporting
Examples and explanation on visualizing patterns
Examples and explanation on visualizing proportions
Examples and explanation on visualizing relationships
Examples and explanation on visualizing similarities and differences
Examples and explanation on visualizing geospatial data
Detailed explanation of Business Intelligence& Analytics Architecture
SSRS Mobile Reporting Architecture and Tools Overview
SQL Server, SSAS and SSRS Installation Guide
SSAS and SSRS Configuration Settings
Download and configure SSAS Multi-dimensional Database on SSAS Instance
Create a quick small report project with a wizard using SSAS as a data source and SSRS for reporting.
Deploy SSRS Report on SSRS Web Portal
Open SSAS Database in SQL Server Data Tools and understand important components of SSAS.
Understand Dimensional Model of a SSAS Cube and how it can be useful for reporting
Learn how to browse, explore and profile data in dimensions and measures
Learn how to explore and profile KPIs, and create analytical reports in excel using KPIs.
Learn how to use List, Tables, and Matrices to represent analytical data from SSAS Cubes on SSRS Reports for Desktop Reporting.
Learn how to add parameters to a SSRS Analytical Report
Learn about SSRS Charts and how to use the same in Analytical SSRS Reports using SSAS as the data source.
Learn about Gauges and how to use the same in Analytical SSRS Reports using SSAS as the data source.
Learn about Sparklines and Databars and how to use the same in Analytical SSRS Reports using SSAS as the data source.
Learn about State Indicators and how to use the same in Analytical SSRS Reports using SSAS as the data source.
Learn about Maps and how to use the same in Analytical SSRS Reports using SSAS as the data source.
Architecture and Design Considerations for using SSRS and Mobile Report Publisher for Mobile Reporting
Introduction to SQL Server Mobile Report Publisher
Learn how to install Power BI Mobile App and integrate the same with SQL Server Reporting Services
Learn how to create shared datasets using SSAS as the data source, and use these data sets in mobile reports
Download links of Report Builder and Mobile Report Publisher
Learn how to use Simple Data Grid for mobile reporting and visual analytics
Learn how to use Indicator Data Grid for mobile reporting and visual analytics
Learn how to use Chart Data Grid for mobile reporting and visual analytics
Learn how to use Pie chart and Funnel chart for mobile reporting and visual analytics
Learn how to use Totals chart and Comparison totals chart for mobile reporting and visual analytics
Learn how to use Category chart and Comparison category chart for mobile reporting and visual analytics
Learn how to use Time chart and Comparison time chart for mobile reporting and visual analytics
Learn how to use Waterfall Chart for mobile reporting and visual analytics
Learn how to use Treemap chart for mobile reporting and visual analytics
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
Learn how to add custom maps in Mobile Reports Publisher for reporting data on custom shapes
Learn how to use gauges like Number, Delta, Numbers and Delta, and Delta Indicator for mobile reporting and visual analytics
Learn how to use gauges like donut gauge, speedometer gauge, cylinder gauge and thermometer gauge for mobile reporting and visual analytics.
Learn how to use progress bar gauge, linear gauge and bullet graph gauge for mobile reporting and visual analytics.
PS: This course was originally titled Visual Analytics with SSAS and SSRS on iOS, Android and Windows 10. It has been re-branded as Mastering SSRS Reports Development for Mobile Devices
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.