SSAS Training Videos with Online Lab

On demand Training Videos accessible at your comfortable timings and conveninent environment. Our SSAS Video Training Service (Course Code: VC05) offers complete realtime practical knowledge transfer services for aspiring SQL BI / Cube Developers. Study and Practice Material with Realtime Case Study, Free LIVE Server Access for online Lab are included in this course. Register for SSAS & MDX Video Training

Plans for SSAS Video Training

  PLAN A PLAN B
Description SSAS SSAS + Power BI
No.of Videos 12 30
Completely Real-time Check-Symbol-for-Yes Check-Symbol-for-Yes
Resume, Job Support Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-time Project (ERP) Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Desktop Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Service Croos-symbol-for-No Check-Symbol-for-Yes
Power BI Report Server Croos-symbol-for-No Croos-symbol-for-No
Complete MSBI : IS, AS, RS Croos-symbol-for-No Croos-symbol-for-No
Microsoft BI Certification Croos-symbol-for-No Croos-symbol-for-No
Total Course Fee INR 7000/-
USD 100
INR 15000/-
USD 250

SSAS (MDX & DAX) Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance.

SSAS Training Highlights

  • Completely Real-time and Practical
  • Video wise Lab Work, Tasks, Solutions
  • One Real-time Project + Ticketting Tools
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support

If above schedule does not work for you, Register for SSAS Video Training

For Weekend / FastTrack Trainings Click Here

Trainer : Mr. Sai Phanindra T (12+ Yrs EXP) Profile

 

SSAS Video Training Course Contents:

 

Basic SSAS Development & Cube Design

Advanced SSAS Development & Deployment

VIDEO 1: INTRODUCTION TO SSAS & CONFIGURATION

  • Installation and Configuration: SSAS 2014 and SSAS 2016
  • Need for SSAS Component & Tools - Operation Modes
  • Multidimensional Mode : Purpose, Properties & Usage
  • Tabular Mode : Purpose, Properties and Usage (ROLAP)
  • PowerPivot Mode : Purpose, Properties and Usage (Overview)
  • Configuring Multidimensional Mode Instances, Verification
  • Configuring Tabular Modes Instances Purpose and Tests
  • Understanding Multidimensional Databases (OLAP Databases)
  • SSAS Service Accounts & Usage. SQL Browser Service
  • SSDT Tool: SQL Server Data Tools - SSDT / Visual Studio Shell
  • SSDT 2015 Installation and Verification of SSAS Templates
  • SSDT 2013 Installation and Verification of SSAS Templates
  • Understanding SSAS Developer Environment (SSDT) Interface
  • SSAS Online Training - Lab Plan, Resources & Databases
  • Introduction to OLAP Database: Measure Groups, Measures
  • Attributes, Hierarchy Levels and Members. Cube, OLAP DB
  • Need for MDX : Multidimensional Expression Language
  • SSAS Workflow in Real-world. Sources to SSAS to Reports
  • Data Source Configurations & DB Installations for Lab

VIDEO 7: KEY PERFORMANCE INDICATORS & MDX

  • Key Performance Indicators (KPI) - Purpose, Design Options
  • GOAL, VALUE, STATUS, TREND and WEIGHT
  • Data Driven Goals - Identification and MDX Expressions
  • Variance and Value Computations. Format Options, Scope
  • KPI Organizer, Calculations. MDX Expressions, Time Analysis
  • Parent - Child KPIs : Purpose and Design Options. Weights
  • Cube Design Options with KPI Calculations and Functions
  • FORMAT_STRING, MDX Expressions and Member Operators
  • KPI Goal and Status @ PARALLELPERIOD, CLOSINGPERIOD
  • MDX Expressions for additional Cube Design, SESSIONSCOPE
  • MEMBER Names and SOLVE_ORDER Expressions in MDX
  • Parent KPIs with Member Hierarchies, KPI Browser Options
  • KPIs for Drill-Up, Drill-Down in MS Excel. Pivot Tables
  • Variance Factors and Calculations with MDX Expressions
  • Retrieving & Displaying KPIs. Client Apps @ Multi-Level Access
  • Perspectives and Translations with KPIs,Usage Options
  • Role Playing Dimensions, Fact and Factless Dimensions
  • Referenced Dimensions and Conformed Dimensions - Usage
  • Degenerate, Junk and Hierarchical Dimensions - Usage

VIDEO 2: BASIC CUBE DESIGN WITH SSAS, EXCEL PIVOT

  • Identifying Analysis Entities in OLAP Database, Design Plan
  • Need for OLAP Databases and Cubes For Analysis - OLAP
  • Implementing Kimball & Inmon Methods Of BI - SSAS Design
  • A Realworld Example - Sales Scenario for SSAS. Cube Design
  • Sample Analysis Requirements and Entities - Measure Groups
  • Basic SSAS Database Entities & Usage. Sources, Destinations
  • Working with SQL Server Data Tools (SSDT). SSAS Templates
  • Data Source, Data Source View and Cube Designer Wizard
  • Dimension Wizard and Attributes. BUILD, DEPLOYMENT
  • PROCESS of OLAP Cube. Options and Online Deployment
  • Cube Browsing (Basic Level) using SSMS & ADOMD Client
  • Excel Connections for SSAS Databases and OLAP Cube Access
  • Excel PIVOT Tables and Basic Chart Report Design with SSAS
  • Piechart Reports and Attribute Filters. Usage Statistics
  • Using Microsoft Excel for OLAP Cube Access and Filters
  • Common Deployment Errors : Logon Failures @ OLAP Server
  • OLAP Server Impersonation Account - NT ATHORITY Account
  • OLAP Deployment Warnings and Solutions. Precautions
  • Data Source to SSDT : Issues, Solutions and Data Flow
  • Data Source to OLAP Server : Issues, Solutions and Data Flow
  • OLAP Cube Design and Working : Advantages. Access Methods
  • End to End Implementation of SSAS - Basic Level Example

VIDEO 8: SSAS PROJECT DEPLOYMENT & TOOLS

  • SSAS Deployment Procedures and Tools. BUILD Options
  • Deployment Configuration Files - Usage. Contents, Targets
  • Deployment Options, Settings, Targets: Transaction Settings
  • SSAS Deployment Wizard Usage: Impersonation Settings
  • SSAS Deployment Accounts and Passwords. Security Inherit
  • OLAP Cube Security Roles and Partition Settings (MOLAP)
  • Defining Key Error Logs for OLAP Databases and Cubes
  • Custom Storage and Error Locations for Databases, Cubes
  • Scripting Deployment Procedure. Executing of XMLA Scripts
  • OLAP Database Processing Options - Full, Default, None
  • Cube Processing Options: Full, Default, Data, Index, Clear
  • Scripting OLAP Databases and Cube, Dimensions. Purpose
  • Cloning Options with XMLA. OLAP DB Testing & Executions
  • Partitions Management - SPLIT and MERGE. Aggregations
  • Lazy Aggregations and Purpose. Process Scripts with XMLA
  • Force Commits and Cube Slice. SSAS Server Level Audits
  • OLAP Server Security, Database Level, Cell Level Security
  • Managing Security with MDX Expressions (Dynamic Security)
  • Attribute and Cell Visibility. Read Contingent Permissions
  • Processing Options: Sequential, Parallel and Thread Priority
  • DB and Cube Processing Jobs: Scripting @ XMLA Commands
  • SQL Agent Jobs and Analysis Services Commands for XMLA

VIDEO 3: CUBE DESIGN WITH ATTRIBUTES, HIERARCHIES

  • Cube Design with Attributes, Keys and Relations. Members
  • Data Source View : Entities, Related Objects, Filters
  • Database Dimensions : Identification and Purpose / Usage
  • Cube Dimensions: Identification and Purpose / Usage
  • Connection Strings for SQL Server Data Sources. Options
  • Named Queries and Calculations in Data Source View (DSV)
  • DSV Entities : Data Explore Options. Data Verifications
  • Expressions in DSV Entities. Named Calculations & Reports
  • Cube as a Subject Oriented OLAP Database Object. Browse
  • Cube Access Methods : Cube Browsers - SSMS and SSDT
  • Cube Access Methods: Excel, SSRS, Power BI, Tableau, etc.
  • MDX Filters (Browser Based). Pivot Reports @ MS Excel
  • Conditional Formats, Table Formatting Styles @ MS Excel
  • Cell Styles and Monetary Formatting Options. ODC Connections
  • Enabling Caching. Reusing ODC Connections. Filter Expressions
  • Backend Access to Business Data. Frontend Access to Reports
  • Cube Browser - Differences between SSDT & SSMS Drilldowns
  • Hierarchies : Attribute Levels and Purpose. Easy Access
  • Defining Hierarchies for Easy Access. Drill-down Reports
  • Performance Warnings and Missing Attribute Relations and Keys
  • Composite Attribute Keys, Member Name Columns, Hierarchies
  • Deployment Errors - Duplicate Attribute Keys: Solutions

VIDEO 9: TABULAR MODE - CUBE DESIGN, MDX QUERIES

  • Tabular Mode - Importance, Advantages and SSDT Templates
  • Workspace Server Architecture, Configuration Settings
  • Entity Identification Procedures and Design Constraints
  • Data Import Wizard and SQL / ODBC Connection Settings
  • Named Query Options with Tabular Design, Entity Relations
  • Dimension Identification: Hierarchies, Attributes, Members
  • Time & Non-Time Hierarchies with Tabular Mode. Keys
  • Aggregated Measures and Measure Groups. KPI Generation
  • KPIs with Static and Dynamic Goals. Status, Trend Factors
  • Partitions - Entity Level Partitions, SQL Scripts, Process
  • Partition Reuse. Perspectives in Tabular Mode - Cube Browser
  • Time Based Hierarchies and Keys in Tabular Mode - Usage
  • Tabular Database Processing: InMemory, Direct Query Modes
  • In-Memory with Direct Query, Direct Query with In-Memory
  • Performance Advantages of Tabular Mode, In-Memory Queries
  • Virtual Cube Access, Browsing Options. MDX in Tabular Mode
  • MDX Filters - Vertical, Horizontal Access Attributes. MEMBERS
  • Connection Edits and SMDL (Semantic Definition Language)
  • Advanced Cube Design and STAR / SNOWLFLAKE Schemas
  • MDX Predicates and FILTER() Expressions, Nested Queries
  • Querying Tabular Cubes @ MDX Joins, SCOPE, TOPPERCENT
  • xVelocity and Direct Query with MDX / DAX. Tuning Options

VIDEO 4: MDX QUERIES & EXPRESSIONS

  • MDX: Multidimensional Expression Language. Syntax Rules
  • MDX Syntax and Axis Models. Cube Data into ROWS, COLUMNS
  • Practical Advantages of MDX: Reports, Cube Writebacks
  • Additional MDX Usage for Cube Design, KPIs, Actions, Security
  • MDX Queries with Dimension Attributes, Members. Axis Levels
  • MDX Queries on Hierarchies, Levels and Attribute Keys
  • MEMBERS, CHILDREN, ALL MEMBERS: Comparison, Aggregates
  • MDX Joins using * and CROSSJOIN. Precautionary Measures
  • MDX ORDER, TOPCOUNT / HEAD, BOTTOMCOUNT/ TAIL
  • MDX Queries with WHERE, EXCEPT, RANGE, Operators
  • NONEMPTY, Multiple Member Values. Limitations with WHERE
  • PARENT and CHILDREN with MDX Hierarchies. Tuple Inverse
  • FILTERS in MDX - CURRENT MEMBER, EMPTY MEMBER
  • FILTER Expressions with AND / OR and LEFT / RIGHT Range
  • LEFT/RIGHT and Pattern Matching with MDX. Empty Axis
  • Exact and Closest Match Search Patterns, Operators in MDX
  • Working with NULL Values, Cascades and Cell Details in MDX
  • MDX Query Batches - GO. ADOMD Client: MDX Query Processing
  • Differences between Cube Browser & MDX Expressions
  • MDX Queries for Formatting Options. Member Name Binding
  • Attribute Keys for Member Value Access. Advantages, Usage
  • MDX in SSMS Vs Cube Browser @ SSMS/SSDT. Null, Empty Axis

VIDEO 10: TABULAR MODE: DAX, OLAP CUBES

  • DAX: Query Syntax and Data Types. Comparision with Excel
  • Defining Measures inside DAX Query. ROLAP Cube Access
  • Using DAX Local Measures in MDX Queries, Drillthrough
  • Adding New Columns, DAX Comparisions and Calcualtions
  • DAX Operators, Freezing Columns, Concatenation Options
  • IF and Member Expressions. Hiding / Changing Columns
  • Vertipaq Storage - Advantages and OLAP Backend Options
  • Optimizing Performance: In Memory Query Processing
  • Direct Query & In Memory with Direct Query Processing
  • Tabular Mode Cube Design: Manual/Automated Calculations
  • Security Management with DAX. OLAP Database Roles
  • DAX Filters for Security. Dynamic Security Scenarios - DAX
  • Tabular Mode Cube Design with ODC Sources - PowerPivot
  • Cude Design with PowerPivot Mode using SSDT & Workspace
  • Advantages and Limitations of Tabular Mode Cubes. Usage
  • Importing Tabular Mode Solutions and Workspace Databases
  • Entity Level Partitions Versus Measure Group Partitions
  • Scripting Options with Tabular Mode. Cloning & Processing
  • OLAP Backups and Restores. Detach - Attach Process
  • Data Process & Read Access Security Tests with Excel
  • OLAP Database Upgrades. Process Recalculation, Clear
  • DAX Filters & Security Roles. XMLA Scripts. Cube Imports

VIDEO 5: CALCULATIONS, TIME BASED ENHANCEMENTS

  • MDX Calculations - Need & Advantages. UI Options
  • Calculations with MDX Scripts. Syntax Verification
  • Calculations Usage and Folders - Cube Browser Usage
  • Relating and Reusing Calculations with MDX Expressions
  • Using Calculations in FILTERS and Search Pattern - MDX
  • Conditional Formats, Expressions. Verification @ MS Excel
  • TIME DIMENSIONS - Purpose and Advantages, Properties
  • Time Keys and Time Attributes - Calendar / Fiscal / ISO
  • Adding Hierarchies and Members to Time Dimensions. Usage
  • Dimension Enhancements - Purpose, Advantage, Usage Scope
  • Cube Enhancements - Purpose, Advantage and Usage Scope
  • Time Type Calculations with MDX Expressions, SCOPE, Formats
  • Identifying Attributes & Hierarchies For Time Enhancements
  • Time Calculations for Attributes & Hierarchies - Differences
  • MDX Scripting for Time Calculations. Verification Techniques
  • Attribute Calculation Sets and MDX Scripts. Grouping Options
  • Browsing Time Calculations in MDX Editor, Cube Browser
  • Time Calculations with User Defined Calculations - Options
  • Attribute Level Calculations and Members - Dimension Level
  • Measure Level Calculations and Granularity - Cube Level
  • Calculation Properties : Type, Scope, Format, Visibility
  • Associated Measure Groups & Parent Hierarchy, Non-empty
  • Pie-Charts & User Defined Measures For Time Calculations
  • Slow running Queries with MDX: Need for Tuning Cubes

VIDEO 11: CUBE MANAGEMENT, DATA MINING & TUNING

  • SSAS Database (MOLAP) and Cube Audits - MDX Query Logs
  • Security Audits and Need for Optimizations, DB Audits
  • Usage Based Optimization Options (MOLAP) and Filters
  • Flight Recorder Settings, SSAS Query Log Providers
  • Data Sampling Intervals and MDX Query Tuning Process
  • 100% Aggregations (FULL), CPU and Space Thresholds
  • Lazy Aggregations & UBO in MOLAP, Performance Settings
  • Writebacks - Purpose, Settings and Usage. Forecasts
  • Writeback Partitions - Cube & Dimension Level, UPDATES
  • Using MDX Expressions, Queries for Writeback. Advantages
  • Writeback. MDX Transactions - COMMIT, DESCANDANTSK
  • Subcube - Creation, Advantages Usage. MDX Query Plans
  • Data Mining - Purpose, Techniques and Forecast Operations
  • Mining Structures & Mining Models - Storage Architecture
  • CLUSTERING, DECISION TREES, NEURAL NETWORK Models
  • REGRESSION Techniques, Naive Bayes Mining Algorithms
  • Case Tables Identification and Nested Table For Relations
  • Attribute Data Types - DESCRETE & CONTINOUS. Drilldowns
  • Training Sets and Testing Sets for Data Mining Accuracy
  • Dependency Rules, Classification Charts and Lift Chart
  • Mining Algorithms - Score and Prediction Analysis Functions
  • DMX Queries - Forecasts, Prediction Functions, Expressions
  • Mining Model Comparison, DMX and Forecast Reports
  • Multidimensional Mode Versus Tabular Mode - Technical

VIDEO 6: PARTITIONS, AGGREGATIONS, STORAGE MODES

  • Partitions : Purpose and Architecture, Tuning Operations
  • Cube Partitions : Storage, Slice Options. Query Conditions
  • Query Binding and Table Binding Options in Partition Design
  • Redesign and Default Partitions. Location / Remote Storage
  • Role of Measure Group Partitions in Cubes - Advantages
  • Aggregations - Purpose and Usage. Predefined Calculations
  • Aggregation Types: Full, Default, None and Unrestricted
  • Measure Properties and Default Aggregation Types in OLAP
  • Linking Aggregations and Partitions. Cube Slicing Options
  • Aggregation Reusability Options - Multiple Partitions
  • Additive and Semi-Additive Measures - Aggregation Options
  • Minimize Impact of Aggregations on OLAP Cube Processing
  • Storage Modes : Multidimensional, Relational and Hybrid
  • Aggregation Storage & Measure Group Storage: MOLAP/ROLAP
  • MOLAP - Automatic Processing, Scheduled, Medium Latency
  • Low Latency Processing and Custom Scheduling Options
  • Proactive Caching Options and Silence / Override Interval
  • Cache Rebuild & Overwrite Options. Processing with Partitions
  • Perspectives - Purpose and Scenarios For Invalid Cube Access
  • Dimension Usage Tab for Dimension Relations. End User Access
  • Cube Deployments with Partitions, Aggregations

VIDEO 12: REAL-TIME PROJECT, SSAS MODE COMPARISIONS

  • Multidimensional OLAP DB Management: Backups, Restores
  • Multidimensional OLAP DB Management: Detach, Attach
  • Multidimensional OLAP DB Management: DB Synchronize
  • Tabular OLAP DB Management: Backups, Restores
  • Tabular OLAP DB Management: Detach, Attach
  • OLAP Database Scripting and Cloning Options. Jobs
  • Cube Processing Jobs and Schedules with SQL Server
  • Comparing SSAS 2012, SSAS 2014 and SSAS 2016
  • Comparing Multidimensional and Tabular Modes
  • XEvents support through SSMS (New in SSAS 2016)
  • DAX performance through Super DAX - DBCC Commands
  • DBCC Commands and MDX for SSAS - 2016

Real-time Project for SSAS

* Above curriculum applicable for registrations from October 26th, 2017.

Power BI Training Course Contents:

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modelling

Module III: Power BI Service (Cloud)

Video 1 : Introduction to Power BI

  • Need for Big Data and BI Technologies
  • Purpose of BI & Power BI Suite of Tools
  • Power BI as a Self-Service BI, Scope
  • Comparing Power BI with Microsoft MSBI
  • Comparing Power BI @ Tableu, QlickView
  • Power BI as an End-to-End BI Tool
  • Microsoft Data Platform Technologies
  • Colloboration, Visualization and IOT
  • Power BI with Reporting Services (SSRS)
  • Power BI For Data Scientists, AI Scope
  • Power BI For Business Analysts
  • Power BI Job Roles and Responsibilities
  • Power BI Component :Overview, Lab Plan
  • MCSA Examination for Power BI: 70-778

Video 7 : Power Query & M Language - 1

  • Power Query [M Language] - Purpose
  • Power Query Usage & Operation Types
  • Power Query Architecture and Usage
  • QUERY Concept, Properties, Validations
  • Power Query for Data Mashup Operations
  • Basic Data Types, Literals and Values
  • Expressions and Primitives in M Language
  • LIST : Syntax, Examples and Usage
  • RECORD : Syntax, Examples and Usage
  • TABLE : Syntax, Examples and Usage
  • Power Query Connection Formats, Settings
  • let, source & in statements in M Lang
  • Power BI Canvas: Edits, Applied Steps
  • Queries and Applied Steps, Edit Queries

Video 13 : Power BI Service (Cloud) - 1

  • Power BI Cloud & Power BI Workspace
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports and Datasets in Power BI Cloud
  • Pin Visuals and Pin LIVE Report Pages
  • Dashboard Creation and Tiles, Media
  • Images, Web Content, Videos, Q & A
  • Mobile View, Web View, QR Codes, Shares
  • Enabling Interactive Visuals. Embed Codes
  • Report Shares and Dashboard Shares
  • App Publish Options and App Updates
  • Power BI Report Edits in Cloud, Visuals
  • Download PBIX Reports from Cloud
  • Sharepoint Integration, PPTX and Excel

Video 2: Power BI Architecture

  • Power BI Architecture - in Detail, Tools
  • Power BI - Integrations in Real-time
  • Need for Power BI Service and Cloud
  • Need for Power BI Report Server, SSDT
  • Power BI Report Server & Report Builder
  • Power BI Mobile Report Publisher Tool
  • Types of Reports in Power BI - Interactive
  • Analytical, Paginated & Mobile Reports
  • Office Online Server & SharePoint Server
  • Content Packs, Cortana - Q&A Features
  • API Integration: LIVE Streaming DataSets
  • Configure Power BI Cloud, Basic Usage
  • Installing Power BI Desktop, Gateways
  • Installing Excel Publisher & Analyzer

Video 8 : Power Query & M Language - 2

  • Data Sources with Excel, File Formats
  • Data Sources with Database Connections
  • BLANK Data Sources Creation & Scope
  • Creating LIST, RECORD, TABLE Queries
  • Functions in Power Query and Usage
  • Defining Functions and Invoke Options
  • Mashup Operations in Power Query Editor
  • Row Filters, Column Filters, Renames
  • Promoting Headers and Query Settings
  • MERGE Queries For Combining Queries
  • Inner Join and Left/Right Outer Joins
  • Left Anti Join, Right Anti Join, Full Join
  • UNION All, Group By and Aggregations
  • Close and Apply Options. Data Imports

Video 14 : Power BI Service (Cloud) - 2

  • Dashboard Properties and Security
  • Report properties and Security
  • Dataset properties and Security
  • Report Insights, Related Items & Metrics
  • Quick Insights. Publishing App Workspace
  • Power BI LIVE Report Edits, Downloads
  • Content Packs : Creation and Use
  • Organizational and Service Level
  • Content Packs from Azure MarketPlace
  • Gateway Clusters - Installation
  • Personal and Enterprise Gateways
  • NT SERVICE\PBIEgwSERVICE Account
  • Dataset Refresh Options and Schedules
  • Azure Databus Integration, ODG Logs

Video 3 : Using Power BI Desktop

  • Install and Configure Power BI Desktop
  • Understanding Power BI Desktop Tool
  • In-Memory, SMDL and Vertipaq Options
  • Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Concept & Use of PBIX and PBIT Files
  • Designing Simple / Basics Reports in PBI
  • Get Data from DAT Files, Basic Reports
  • Enter Data from Excel Files, Basic Reports
  • Creating PBIX Files and Re-Use
  • Creating PBIT Files & Data Import Options
  • Database Connections with Power BI
  • Import and DirectQuery - Data Loads
  • Table Reports, Matrix and Chart Reports
  • Interactive Visuals and Focus Mode

Video 9 : Power Query & M Language - 3

  • Data Modeling Options with Power Query
  • Modeling Operations - Custom Columns
  • Query Transforms, Sort Direction, Statistics
  • Enabling / Disabling Loads. ToList Options
  • Creating Parameters & Variables. Functions
  • Date and Time Columns. String Functions
  • Advanced Edit Options, Custom Queries
  • Custom Functions in Power Query M Lang
  • Grouping and Sub Groups with Queries
  • Binning with Groups and Query Formats
  • SubString Functions, Splits (Row, Column)
  • Parsing XML and JSON Files. Formatting
  • Removing Duplicate Rows and Columns
  • Column Delimters and Field Formatting
  • Group By Aggregations, Fill, Reverse Rows
  • Format Options in M Language. Bookmarks
  • Pivot and Unpivot Options in Power Query
  • Data Type Conversions & Format Options

Video 15 : Excel with Power BI

  • Using Excel with Power BI Reports
  • Using Excel Analyser in Power BI
  • Using Excel Publisher in Cloud
  • Creating Datasets with Excel, Office 365
  • Excel Uploads & Cloud Imports, Office 365
  • Cell Selection and PINS in Power BI
  • Excel Online Service - Edits and Pins
  • Excel ODC Connections and Real-time Use
  • Excel Power Pivot and Power BI Cloud
  • Excel Drilldowns and Drillthru Reports
  • Create Key Performance : KPI Reports
  • Excel for Big Data Analysis, Reporting
  • Worksheets and Dashboards with Excel
  • Power Pivot Reports in with Excel
  • Power View Report Options in Excel
  • Change Type and Transform Operations
  • Replace Values & Errors, Transpose

Video 4 : HIERARCHIES and FILTERS

  • Hierarchies - Creation, Purpose & Realtime Usage
  • Using Hierarchies in Power BI Visual Fields
  • Using Hierarchies for Visualization Data Drills
  • Drill-down Reporting Options in Power BI Visuals
  • Drill-thru Reporting Options in Power BI Visuals
  • Drill-down with Isolated and Dependant Options
  • Expand, Goto Next Level and Drill-up Options
  • Data Explore Options : Spotlight & Focus Options
  • See Data, Export Data, See Records in PBI Canvas
  • Include & Exclude Options. Multi-Field Values
  • Filters and Real-time Usage with Power BI Reports
  • Report Filters & Page Filters - Usage in Real-time
  • Visual Filters and Comparison with Slicer Values
  • Drill-down Filters - their visibility in Drilldowns
  • Filter Options: Basic, Advanced and Top N Values
  • Big Data Access with Power BI - Filters Usage

Video 10 : POWER QUERY - PARAMETERS

  • Need for Parameters and Conditions in Power BI
  • Creating Parameters using Power Query (M Lang)
  • Intrinsic Parameters and User Query Parameters
  • Parameter Data Types, Default Value Lists
  • Linking Parameters with Query Results (Tables)
  • Static List Parameters and Invoke Options
  • Defining Dynamic Lists For Parameters, ToTable()
  • Parameters with Table.SelectRows() Functions
  • Testing Parameters with PBIT and PBIX Files
  • Using Parameters in PBIX Edit Query Screens
  • Defining Parameters using Advanced Query Option
  • Parameter Control and Edit and Run Time, Get Data
  • Static Web Page Data Source, Parameterization
  • Defining Value List for Parameters in Power Query
  • Implementing Table Parameters in Power Query
  • Structured Lists, Dynamic Parameter Connections

Video 16: POWER BI REPORT SERVER

  • Need for Power BI Report Server in Intranet
  • Security Advantages with Report Server Database
  • Report Server Settings & Power BI Admin Console
  • Install and Configure Power BI Report Server
  • Report Server Database & ReportTemp Database
  • Webservice URL and Webportal URL - Usage
  • Report Builder Tool - Installation and Usage
  • Creating Report Data Source and Report Dataset
  • Designing Paginated Reports (RDL) and Testing
  • Deploy to Power BI Report Server - Settings
  • Data Source Connections, Report Server Options
  • Register Power BI Report Server to Cloud
  • Tenant IDs Generation and Real-time Usage
  • Publish RDL Reports to Power BI Cloud via URL
  • Pinning Paginated Reports Convert to Intractive
  • Paginated Reports Versus Interactive Reports

Video 5 : Power BI Visual Properties - 1

  • Fields, Formats and Analytics Options
  • Table Visuals & Properties, Filters
  • Data Bar and Data Scaling Options
  • Divergent Property, Data Labels
  • Matrix : Sub Totals, Grand Totals
  • Drilldown Options : Row and Column
  • Stacked Bar Chart, Clustered Colum Chart
  • Stacked and Clustered Colum Chart
  • 100% Stacked Bar and Column Charts
  • Area & Stacked Area Chart. Ribbon Chart
  • Waterfall Chart, Scatter Chart, Pie Chart
  • Line, Doughnut TreeMap, Funnel, Gauge
  • DETAILED Properties of Every Visual
  • General, Labels, Values, Legend Options
  • Axis, Title, Markers, Filter Options
  • Adding Text Box, Images, Buttons Shapes

Video 11 : DAX Functions & Usage - 1

  • DAX : Importance and Real-time Usage
  • DAX Data Types and DAX Calculations
  • Syntax, Functions, Context Options
  • ROW Context and Filter Context in DAX
  • DAX Functions. Aggregates and Usage
  • Creating and Using Measures with DAX
  • Creating and Using Columns with DAX
  • Vertipaq Engine & Special Characters
  • Operators in DAX - Real-time Usage
  • Quick Measures in DAX - Auto validations
  • PowerPivot xVelocity & Vertipaq Store
  • In-Memory Processing : DAX Performance
  • Date and Time & Text Functions
  • Time Intelligence Functions in DAX
  • Logical & Mathematical Functions

Video 17 : REST APIs & Power BI Admin

  • REST APIs with Power BI Cloud Service
  • Streaming Datasets Creation in Power BI
  • API : Usage. SubKeys and Channels
  • Push and Pubnub Datasets in Power BI
  • Azure Stream for Real-time Data Reports
  • Real-time Data Tracking Visuals (Interactive)
  • Power BI Mobile Publisher and Mobile Reports
  • Power BI Vs Tableau, SSRS, Sharepoint
  • Licensing & Pricing Plans in Power BI
  • MSBI SSAS and SSRS with Power BI
  • Custom Visuals in Power BI
  • Configuring Alerts in Power BI
  • Managing and Receiving Alerts
  • Power BI with OneDrive, Google Analytics
  • SaaS Components, OneDrive with PowerBI

Video 6 : Power BI Visual Properties - 2

  • Map Reports and Filled Map Reports
  • ArcGIS Maps and Real-time Usage. Options
  • Longitudes and Latitudes. Bing Maps
  • Color Analytical Maps, Styles, Options
  • KPI Reports - Target, Value and Trend
  • Plot Area & Responsiveness Properties
  • Sentiment Colors, Color Saturations
  • Breakdowns, Title, Axis Properties
  • Category & Data Lables, Constant Lines
  • Working with SLICER Visual : Value Filters
  • Horizontal and Vertical Slicer Filters
  • Single Select and MultiSelect Options
  • Frown (Errors), Details. Lock Aspects
  • Custom Visuals & PBIVIZ Files. Visual Sync
  • PBI : Options and Settings, VM Settings

Video 12 : DAX Functions & Usage - 2

  • Data Modeling with DAX. Creating Roles
  • Currency Conversions, Field Formatting
  • SUM and SUMX Functions: Differences
  • CALCULATE(), CALCULATEX() Functions
  • CALCULATETABLE Functions. VAR, VARP
  • DATESMTD, DATESQTD, DATESYTD
  • ENDOF(), FirstDay(), LastDay()
  • SAMEPERIODLASTYEAR, STARTOF()
  • Other DAX Functions and Examples
  • DAX Expressions with Quick Measure
  • DAX Usage for Row Level Security
  • Creating Roles with Power BI Desktop
  • DAX Filters and Multi Value Conditions
  • Manage Roles and Membership Options
  • VIEW AS ROLE. Information Functions

Video 18 : POWER BI with R LANGUAGE

  • Introduction to R and Microsoft R Open (MRO)
  • MKL (Math Kernel Library) Libraries, R Engine
  • R Script and R Visual Usage in Power BI Tools
  • Using R as General Public License Version (GPL)
  • R Language compiler and mran [R revolution Org]
  • Installing Microsoft R Open in Windows OS
  • Installing RStudio Tool & R Packages Activation
  • Configuring R for Predictive Analysis, Reports
  • Configuring Power BI Desktop for R Script
  • Enabling R Scripts. Executions in Power BI
  • Get Source Data (Dynamic) using R Scripts
  • Using R Visual in Power BI Desktop Tool
  • Using Power BI Canvas for Forecast Analysis
  • Power BI Limitations with R in Real-time
  • New Features from Latest Releases of Power BI

Real-time Project 1 :

For Power BI Registrations: Real-time Project Implementation @ Climate Control Datasets and REST API

Real-time Project 2 :

For Power BI with SQL Server T-SQL Registrations: Real-time Project Implementation @ ERP Database

New Features from Latest Releases of Power BI

Note : Above course curriculum applicable for registrations from July 9th, 2018.

One Real-time Project with 24x7 LIVE Server & Video wise Lab and Documentation for each video.

Why choose SQL School™ Training Institute:

  • Completely Practical and Realtime
  • Video Wise Tasks and Assignments
  • Labwork and Material for each video
  • On Job Support even after the course
  • 24x7 Server LIVE Online Lab
  • Mock Interviews and Certification Guidance
  • Microsoft Learning Partner Verify Link
  • ISO Certified Training Instittue

After the SSAS Video Training course participants should be able to:

  • Multidimensional OLAP Server Configuration, Tools
  • Tabular OLAP Server Configuration, Workspace
  • Partition Cubes, UBO, Lazy Aggregations, MDX Filters
  • MDX Security, Actions, DAX and Tabular Expressions
  • Cube Reports with MDX, Nested Sub Cubes, KPIs
  • Data Mining with DMX, Forecasts, Pivot Reports
  • OLAP DB Synchronizations and Tuning Approaches
  • OLAP MDX Calcualtions, Time Based Members
  • MDX Routines, SCOPE, THIS, PARRELLPERIOD
  • MDX and DAX Expressions, Rpeorting

Please find the Guidelines for Video Based Training (VBT) - Online

1. How does Video Training Works

> Videos are accessible 24x7. You can opt to access any number of videos each day or same video for multiple days.

> Video Course to be completed within 3 months from the date of registration.

> To ensure secured delivery of our services the participant shall connect to our video cloud in a secured environment.

2. Access the videos

> Each video is for duration of 80 - 90 minutes, can be paused/replayed for writing running notes and understanding.

> Each video can be accessible any number of times.

> A Technical Test / Mock Interview is conducted and a Course completion certificate to be issued upon completion of the course.

3. Study Material, Practice and Doubts/clarifications

> Study Material and Practice examples used in every video to be provided on email.

> Software Installation Assistance and access to our 24x7 LIVE Server to be provided for duration of the course.

> Trainers are available for doubts clarifications. On Skype, Email as well as on Call.

Register today for SSAS Video Training
 

SQL Server, SQL DBA, MSBI Trainings :