Implementing Microsoft Business Intelligence and Analytics Solutions
Business Analytics helps analyze data across different domains in an organization providing helpful business insights to measure current business performance and take important business decisions to improve business performance. In this 40-hour course you’ll build and deploy data warehouse solution for an imaginary company to help them analyze business performance and take future business decisions. The course has advanced coverage of SQL Server Multi-Dimensional model, Tabular Model, Power BI, SQL Server Integration Services and SQL Server Reporting Services. The course also covers Azure Machine Learning, HDInsight, Azure Data Factory, Azure Stream Analytics and Cortana Analytics suit for analyzing Bigdata. Overall, this is the most detailed, advanced & comprehensive training on SQL Server Business Intelligence and Analytics.
This Master Class will be delivered by Amit Bansal, Microsoft Certified Master of SQL Server & 11 times Microsoft’s Most Valuable Professional awardee.
All Master Class participants will get a 1-month FREE subscription to SQLMaestros Hands-on-Labs. Apart from practicing course specific labs, participant’s will have access to the entire library during this period.
|Course Title||Implementing Microsoft Business Intelligence and Analytics Solutions|
|Delivery Format||In-Person (Classroom-based). Learn more about our In-Person Delivery Model|
|Date, Time & Duration||December 14 to December 16, 2017, 40 hours Master Class comprising of:
During the 3 days of classroom training, class timings will be from 9 am to 6 pm with one-hour of lunch break
*Prices are subject to change without prior notice
|Level||300-400 (Advanced to Expert)|
|Target Audience||This course is intended for data developers, data management professional, data scientists who design business analytics solution with Microsoft Data Platform.|
|Prerequisites||You need to have at least 1 to 2 years of genuine working experience with SQL Server BI and Analytics. This course is not for freshers|
|Trainer/Instructor||Amit R S Bansal (SQL MCM,SQL MVP)|
- The most advanced SQL Server Performance Tuning Workshop in India
- 40 hours of deep-dive learning
- Exclusive, level 300/400 content
- Packed with real-world scenarios and examples
- Get your own copy of SQLMaestros course material developed by Amit Bansal
- Learn from the Masters: Amit R S Bansal (SQL MCM,SQL MVP)
Module 1: Introduction
The Microsoft BI Ecosystem, Data Warehousing Concepts, Analysis Services Architecture: One Product Two Models, Choosing the Right Model for Your Project and more!
Module 2: Multidimensional Model
Dimensions, Cubes, Calculations, Currency Conversions, Common Calculations, Regular and Dynamic Name Sets, Measures and Measure Groups, Semi Additive and Non-Additive Measures, Creating Measure Group from Dimension Tables, Perspectives, KPIs, Actions and more!
Aggregations, Interpreting, Building and Monitoring Aggregation Usage, Partitions Strategy, Partitions Slicing and Sizing, Hierarchies, Parent Child Hierarchies, Natural and Ragged Hierarchies, Unary Operators, Default Members, Custom Rollups, Referenced Relationships, Many-to-Many Relationships, Dimensions and Cell Writeback and more!
Deploying and Securing Multidimensional Model
Deployment Process, Storage Modes, Deployment Considerations, Attach and Detach Analysis Services Databases, Backup and Restore Analysis Services Databases, Move, Rename Analysis Services Databases, User Security, Roles and Permissions, Dimension Security, Cell Security, Administrator Security, Advanced Security, Dynamic Security, Parent Child Hierarchy Security, Writeback Security and more!
Accessing Data With MDX
MDX Key Concepts, MDX Fundamentals, MDX Scripting Fundamentals and more!
Performance Tuning and Optimization
Optimizing MDX, Enhancing Partition Processing Performance, Enhancing Dimension Processing Performance, Tuning Server Resources, Effective Cube Usage and Performance Monitoring and more!
Module 3: Tabular Model& Power Pivot
Getting Started with The Tabular Model
Working with SQL Server Data Tools, Building A Simple Tabular Model, Querying A Tabular Model in Excel, Querying A Tabular Model in Power View and more!
Loading Data Inside Tabular
Understanding Data Sources, loading from SQL Server, Loading from Analysis Services, Loading from A Reporting Services Report, Loading from The Windows Azure Data Market, Loading from Web, Loading from CSV, Text, XML, Json and more!
Data Modelling in Tabular
Understanding Different Data Modelling Techniques, Working with Dimensional Models, Measures and Calculated Columns, Modelling with Direct Query Enabled, Using Views to Decouple from The Database, Basic Hierarchies, Parent and Child Hierarchies and more!
Using Advanced Tabular Relationships
Using Multicolumn Relationships, Using Many-to-Many Relationships, Implementing Basket Analysis, Querying Data Models with Advanced Relationships and more!
Querying Tabular Model – DAX
Defining Measures Inside Query, Parameters in DAX Query, Querying by Using MDX and more!
Filter context, Row context, Calculate and more!
Understanding xVelocity And DirectQuery
Tabular Model Architecture in Analysis Services, Query Execution in In-Memory Mode, Using DirectQuery and Hybrid Modes and more!
The Tabular Presentation Layer
Naming, Sorting, and Formatting, Perspectives, Power View–Related Properties, Drill-through, KPIs and more!
Deploying a Tabular Model
Sizing the Server Correctly, Automating Deployment to A Production Server, Table Partitioning, Processing Options, Processing Automation, DirectQuery Deployments and more!
Securing a Tabular Model
Roles, Administrative Security, Data Security, Dynamic Security, Advanced Authentication Scenarios, Monitoring Security and more!
Module 4: SQL Server Integration Services
Packages, Control Flow, Data Flow, Variables and Parameters, Error handling, Logging, Connections Managers, Event handlers, Package Mode v/s Project Mode and more!!!
Using Variables, Using Parameters, Using Expressions, Data Types and Casting and more!!!
Precedence Constraints, Looping and Sequence tasks, Scripting Task, Data Preparation Tasks, RDBMS, tasks, Server Administration Tasks and more!!!
Data Paths, Data Viewers, Sources and Destinations, Blocking and non-blocking transformations, performing lookups, Using Caching functionalities, Common transformations, Script Transform and more!!!
Optimizing Data Flow
Optimizing Data Extraction, Using SET based logic, Using CDC / Change Tracking, Optimizing data loading, Using RAW files, Memory Buffer architecture, Execution trees, Database snapshots, Using MERGE operator and more!!!
Reliability and Scalability
Checkpoints, Transactions, Multi package transactions, Error outputs, Scaling out options and more!!!
Using the SSIS catalog, Executing packages using command line utilities, Using Environments, Using Data Taps, Securing the SSIS catalog,Scheduling packages, Proxy accounts, Monitoring package executions, Custom reporting and more!!!
Module 5: SQL Server Reporting Services
Introduction to SSRS
Architecture, Basic report components, Data sources, Datasets,Shared data sources and datasets
Basic Report Development
Report Items, Data Regions, Tables, Matrix, Lists, Tablix, Working with Row and column groups, Static columns and rows, Adjacent and child groups, Parameterizing reports, Cascading parameters and Drill down and drill-through
Introduction to Expression syntax, Placeholders, Global collections, Fields and Datasets collection, Expression usage, Conditional formatting, Aggregate functions, Report variables and more!!!
Working with multiple reports
Drill through reports, Linking reports, Sub Reports and more!!!
Chart types, Chart data pane and elements, Data bars, Sparklines, Gauges, Indicators, Maps and spatial data types, Map layers, Map elements and viewport properties, Scale breaks, Empty points, Calculated series, Secondary axis, Multiple chart types and areas and more!!!
Controlling Page Layout
Controlling page rendering, Render Formats, Pagination and Page breaks, Page Headers and footers, Interactive sorting, Fixed headers, Tooltips, Document maps, Bookmarks and more!!!
Deploying reports, RS Utility and Report Parts
Data source configuration, Report Execution using URL Access, Caching, Scheduling reports, Snapshots, Subscriptions, Securing reports and more!!!
Module 6: Power BI
Introduction to Power BI
Power BI – The Self-Service BI, Power BI Service, Power BI Desktop, Power BI Mobile Apps, Power BI Developer, Datasets, Reports, Dashboard and more!
Power BI Desktop
Introduction, Data Sources, ETL in Power BI Desktop, Transform Data with Queries, Data Modelling in Power BI Desktop, Relationships, Calculated Columns and Calculated Tables, Measures, DAX in Power BI Desktop, Data Categorization, Visualizations and Reporting, Power BI Online and more!
Power BI Service
Connect to Available Content Packs/Services, All About Power BI Dashboards, Question Your Data, Sharing Dashboards, Queries and Reports, Data Refresh, Create and publish your/Organization Content Packs, Connect to Available Content Packs/Services, All About Power BI Dashboards, Question Your Data, Sharing Dashboards, Queries and Reports, Data Refresh, Create and publish your/Organization Content Packs and more!
Managing Power BI
Coverage Includes: Power BI Administration, Gateways and more!
Power BI Developer
Introduction, Power BI Rest API, Integrate Tile into an Application, Custom Visuals and more!
Power BI Mobile Apps
Coverage Includes: Introduction, iPad App, iPhone App, Android App, Windows App and more!
Module 7: Azure Intelligence + Analytics
Introduction, blob, queue, table and file storage, working with blob storage, transfer, manage and secure Azure Storage, monitor and troubleshoot Azure Storage and more!!!
Azure Data Lake Store
Overview, ingesting, processing, visualizing and downloading data from the Azure Data Lake store, copy data, integrating data lake store with azure services, building applications with Azure data lake and more!!!
Azure SQL Data Warehouse
Overview, creating and managing Azure SQL DW, Integration with Azure ecosystem, loading, migration, performance and more!!!
Cortana Intelligence Suite
Overview, dataflow and architecture, Azure Event Hub, Azure Stream Analytics, Azure Data Factory, Azure Machine Learning, Azure Data Catalog, Reporting, Excel, Power BI, Azure Data lake store, Azure SQL data warehouse service, preconfigured solutions, customer implementations and more!!!
Azure HDInsight Overview
BigData Overview, Hadoop Overview, HDInsight components, Hive, Pig, Apache Storm, Apache Spark, kafka preview, Hadoop sandbox and more!!!
Azure HDInsight Applications
Real time analytics with HDInsight Apache Storm and Power BI, Predictive analytics with R on Spark on HDInsight and more!!!
Azure Machine Learning
Machine Learning overview, Azure ML studio, creating a predictive solution with Azure ML, tools and utilities and more!!!
Overview, getting started with Azure search, create service, create index, add data, plan and design, manage and more!!!
Azure Stream Analytics
Overview, real time fraud detection with Azure Stream Analytics and more!!!
Azure Data Factory
Introduction, datasets, pipelines, activities, scheduling, creating pipeline to transform data and more!!!
In the words of Amit Bansal
“Hi, my name is Amit Bansal and I am the instructor of this course. Business Analytics is an essential component of successful modern businesses. Analysing data across different domains in an organization provides with helpful insights to measure current business performance and plan to improve future performance. Microsoft SQL Server is a top notch offering when it comes to business analytics and is a leader in Gartner Magic Quadrant for BI and Analytics. This 40-hour course teaches you to build a data warehouse from scratch for SQLMaestros. You’ll gather requirements, design data warehouse schema in Microsoft SQL Server, write ETL to load data into the data warehouse using SQL Server Integration Services. You’ll then design dimensions, measure, cubes to help SQLMaestros management analyse their business using SQL Server Analysis Services – multidimensional and tabular model. You’ll also prepare a reporting solution with SQL Server Reporting Services and Power BI. You’ll make use Azure HDInsight, Machine learning, R Services, Azure data factory, Azure Data Warehouse, Azure Analysis Services and Azure Stream Analytics to analyse bigdata and design real time reporting solutions. Note that this 40-hour class is rigorous and deep-dive!The course is packed with Hands-On-Labs powered by SQLMaestros.com.
Please feel free to contact us if you need any further information
Email : email@example.com
Skype : firstname.lastname@example.org
Contact: +91-7829999046 / +91-9503124667