AZURE SQL in Hyderabad, India

Description

• Microsoft BI SSAS Course is designed to provide insights on tool in Microsoft BI Suite (SQL Server Analysis Services). Companies are looking for expertise in SSAS & DAX concepts. This course will give you the practical knowledge of Data Warehouse concepts and how this tool help in developing a robust end-to-end BI solution using the Microsoft BI Suite.
• SSAS training is designed to make you a certified Business Intelligence Analyst by providing you rich hands-on training Microsoft’s business intelligence tool. This course is stepping stone to your Analyst journey and you will get the opportunity to work on various industrial projects.

What will you learn from our Workshop: 

• Choosing the right model architecture
• Importing data to create tables and defining relationships
• Enhancing model designs with usability features
• Enhancing model designs with business logic
• Managing tabular databases
• Designing for DirectQuery mode
• Deploying to Azure Analysis Services
• Comparing tabular and multidimensional models
• Expertise in DAX functions

Is this course right for you?

• You can learn SSAS,DAX and Data Warehousing Concepts from scratch
• In a single course, without any prior query development experience – You can learn query languages –   T-SQL,DAX  in such detail that you can apply for a job of SQL Developer / SSAS Developer / Data Mining Developer.
• Also you get to compare the querying techniques in different query languages side by side using examples from a single course, taught by a single instructor on the same sample data.

 Prerequisites:

• No prior working knowledge of SQL Server, SSAS, Data Mining, T-SQL, MDX, DAX or DMX is required.

Course Content :

Getting started

• Multidimensional Vs Tabular
• Separate Named Instances

Visual Studio basics

• Visual Studio windows
• Setting startup options
• Creating a project

Connecting to SQL Server

• Creating and using connections
• Filtering rows and column

Creating a data model

• Hiding from client tools
• Renaming tables/columns
• How column storage works
• How processing works

Relationships

• Diagram view
• Creating relationships

Measures

• Creating measures
• SUMX, AVERAGEX, etc.

Hierarchies

• Creating a hierarchy
• Viewing hierarchies

KPIs

• The parts of a KPI
• Absolute and relative measures
• Creating and viewing KPIs

Perspectives

• Creating perspectives
• Using in Excel

Security

• How security works
• Creating roles
• Filtering rows by role

Calculated columns

• Using IF and SWITCH
• BLANK arithmetic
• Linking tables using RELATED

DAX (Data Analysis Expressions)

• Purpose of Data Analysis Expressions (DAX)
• Scope of Usage with DAX. Usability Options
• DAX Context : Row Context and Filter Context
• DAX Entities : Calculated Columns and Measures
• DAX Data Types : Numeric, Boolean, Variant, Currency
• DAX Operators & Symbols. Usage. Operator Priority
• Parenthesis, Comparison, Arithmetic, Text, Logic
• DAX Functions and Types: Table Valued Functions
• Filter, Aggregation and Time Intelligence Functions
• Information Functions, Logical, Parent-Child Functions
• Statistical and Text Functions. Formulas and Queries
• Syntax Requirements with DAX.
• Naming Conventions and DAX Format Representation
• Working with Special Characters in Table Names
• Attribute / Column Scope with DAX – Examples
• Measure / Column Scope with DAX – Examples
• YTD, QTD, MTD Calculations with DAX
• Time Intelligence Functions with DAX
• DATESYTD, DATESQTD, DATESMTD
• ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
• FIRSTDATE, LASTDATE, DATESBETWEEN
• CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
• SAMEPERIOD and PREVIOUSMONTH,QUARTER