Course Code: ssaspowbi
Duration: 35 hours
Prerequisites:

Audience

  • Data mining professionals, MDX developers, or individuals planning to take the 700-768 Microsoft certificate examination can take up the course.
  • Anyone interested in the role of BI Architect, SSAS Architect/Administrator/Developer or Performance Engineering Specialists, Data Modelers is also eligible to sign up for the affordable training carried out by industry experts.
Overview:

Microsoft SSAS is an online-based data analytical tool used to generate business intelligence data for business reports which help businesses grow through better decisions.

What are the course objectives?

This Microsoft SSAS online training program is aimed at educating participants about the latest trends in Microsoft SSAS. It begins with lessons on how to support Business Intelligence solutions using Microsoft’s SSAS services to design and implement multidimensional OLAP cubes.

The three query languages used for analytics; MDX, DAX, and DMX are all taught alongside lessons. The courses teach how to develop data mining models using algorithms like Decision Trees, Naïve Bayes, Neural Network, Clustering, Time Series, Linear Regression and Sequence Clustering. It is followed by other lessons on how to design, model and build SSAS databases and deploy SSAS solutions in combination with SSAS administration tasks like backup and restore, processing dimensions and measures, etc.

At the end of the training, participants would be so well versed with Microsoft SSAS that they would be able to develop MDX and DAX codes with confidence in understanding how SSAS fits with other tools like SSIS, SSMS, SSDT, and SSRS. More so, they’ll also learn how to create OLAP cubes and automate maintenance with XMLA scripts so that they can leverage on SSAS to produce Business Intelligence solutions that would be instrumental to making smarter business decisions.

Course Outline:

A. SQL SERVER ANALYSIS SERVICES (SSAS)19

  • Introduction to SSAS course
  • What to expect from this SSAS course
  • Tier 1 SSAS Solutions
  • SSAS Data Mining with Excel
  • SSAS Caching and Cache Warming in Analysis Services
  • SSIS & SSAS BI Platform Performance Tuning
  • SSAS and SSIS BI
  • SSAS – Introduction to Data Mining
  • SSAS – Creating a new project
  • SSAS – Creating a new project
  • SSAS – Dimension Model
  • SSAS – Data Mining Basics
  • Administering SSAS
  • Building reports with Project
  • Expert to Expert SSAS
  • Performance tuning
  • How to implement security with SSAS
  • Implementing SSAS Security
  • SSAS Tabular vs MOLAP
  • Types Of Relationships inside CUBE
  • Hierarchies
  • Aggregations
  • MDX in Report

2. Power BI

  • Introduction to Power BI
    • What is Power BI and Why Power BI
    • Installing Power BI Desktop
    • Exploring the Power BI Workflow
    • Adjusting the settings of the Power BI Desktop
    • Comparison of Power BI vs Other Reporting Tools
  • Getting and Transforming Data with Power BI Desktop
    • Connecting to different sources
    • Different connecting Options(DirectQuery vs Import Data Vs Live Connection)
    • Shaping and transforming data with Power Query
    • Editing,Merging,Appending queries etc
  • Modeling with Power BI
    • Introduction to Modeling
    • Building Relational Models(Setup and Manage Relationships)
    • Creating table relationships
    • Understanding the filter flow
    • Cardinality and Cross filtering
  • Introduction to DAX
    • Understanding Dax Syntax
    • Calculated Columns vs Measures
    • Common Dax functions and formulae
    • Understanding the evaluation context in DAX
  • Visualising Data with Reports
    • Creating Visualisations
    • Color & Conditional Formatting
    • Setting Sort Order
    • Scatter & Bubble Charts & Play Axis
    • Tooltips
    • Slicers, Timeline Slicers & Sync Slicers
    • Cross Filtering and Highlighting
    • Visual, Page and Report Level Filters
    • Drill Down/Up
    • Hierarchies
    • Constant Lines
    • Tables, Matrices & Table Conditional Formatting
    • KPI's, Cards & Gauges
    • Map Visualisations
    • Custom Visuals
    • Managing and Arranging
    • Drillthrough
    • Custom Report Themes
    • Grouping and Binning
    • Bookmarks & Buttons
  • Introduction to Power BI Service
    • Introduction to the Power BI Service
    • Quick Tour of Power BI Service
    • Connecting to Data from Power BI service
    • Building Blocks of Power BI Service
  • Sharing and Collaboration Tools in Power BI Service
    • Sharing and Collaboration Options Overview
    • Publish from Power BI Desktop
    • Publish Reports to Web
    • Printing and Exporting from Power BI Service
    • Sharing Reports & Dashboards
    • Workspaces (My Workspace vs App Workspace)
    • Publishing Apps in Power BI Service
    • Row Level Security in Power BI Desktop and Service
  • Power BI Gateway and Refreshing Datasets
    • Understanding Gateways in Power BI
    • Difference between Personal and On-Premise Gateway
    • Installation of Personal Gateway
    • Installation of On Premise Enterprise Gateway
    • Setting Up a Gateway in Power BI Service
    • Understanding Data Refresh(Manual vs Scheduled Refresh)
    • Troubleshooting Refreshing scenarios
  • Case Study