SSAS Training Videos with Online Lab

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

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