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:
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.
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
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.
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.
-|- 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.
-|- 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.
-|- 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
Master of Science with major in Computer Applications and Information Technology