The Azure Analysis Services online course is a short-term programme offered by IIT Kanpur. The course allows learners to understand the cloud's services and management techniques in the contemporary industry. With a skill-oriented approach, the training allows candidates to upskill.
The Azure Analysis Services training is completely online, and lets the candidate access and learn the course from any part of the world. The course is spread over six-weeks with a comprehensive curriculum covering every aspect of Azure services. The course extends multiple questions to the candidates for a sense of familiarity and hands-on practice of the subject.
IIT Kanpur's Azure Analysis Services online course takes the learners through various components of how the interaction takes place along with key terminology used in Azure services. The students get to work on an industry-based project that allows them to put their knowledge to practical use under the course. The students are rewarded with a certificate upon the successful completion of the course and passing the final exam.
The Azure Analysis Services by E&ICT Academy, IIT Kanpur is for students, teachers, and professionals from a technical background who are interested in the Azure data platform.
Admission Details
Step 1: To gain admission into the Azure Analysis Services certification course, the candidate must create a registration profile on the E&ICT Academy, IIT Kanpur website, or log in with their credentials.
Step 2: Visit the website https://ict.iitk.ac.in/product/azure-analysis-services/ and select ‘Enroll & Pay’. In the redirected page, select ‘Proceed to Check out’.
Step 3: Pay the required fee. Candidates can join the course once the payment has been made.
Application Details
Candidates need not fill out a separate application form to enrol for Azure Analysis Services by E&ICT Academy, IIT Kanpur. They can log in to the website to proceed with the registration.
The Syllabus
Introduction to Azure Analysis Services
Prerequisites
Connect to VM
Create an Azure VM – 1
Create an Azure VM – 2
Setting up Analysis Services Tabular Instance
Installing Development Environment - SSDT – 1
Installing Development Environment - SSDT – 2
Setup VM
Restoring Adventure Works DW
Viewing SSDT
Why Azure Analysis Services
Installing PowerPivot
Import Data from Data Source
Create a Tabular Project
Familiarising yourself with the Environment
Filtering other columns
Renaming a Column
Filtering the columns
Calculated Column – part 1
Calculated Column – part 2
Viewing the Imported Data Model
Create Relationships
Introduction to Perspectives
Creating Perspectives
Creating Margin Column
Create a Measure – part 1
Create a Measure – part 2
Create a Measure – part 3
Create a Measure – part 4
Create a Measure – part 5
Introduction to Partitioning
Create Partition – part 1
Create Partition – part 2
Introduction to Hierarchy
Create Hierarchy
Introduction to KPI
Create a KPI
Renaming Measures
Introduction to Roles
Connect in Excel
Creating Roles
Exploring Web Designer - 1
Exploring Web Designer - 2
Deployment Methods
Analyse data in Excel
Deployment on Azure VM
Translations
Deployment - 1
Connect to the Deployed model from Power BI – 1
Connect to the deployed model from Power BI – 2
Connect to the Deployed model from Excel
Create Azure Analysis Services
Deploy to Azure Analysis Services
Conclusion
Evaluation process
Candidates are required to give a final MCQ exam and score 60% or above to pass. Certificates will only be provided to candidates who pass the exam.
IIT Kanpur Frequently Asked Questions (FAQ's)
1: What sort of exam will be there at the end of the course?
There will be a final MCQ exam at the end of the course.
2: Who is offering the course?
IIT Kanpur offers the Azure Analysis Services online course.
3: Is this an instructor-led course?
No, Azure Analysis Services training is a self-study course.
4: Do I get placement assistance upon the completion of the course?
There is no placement assistance after completing the Azure Analysis Services programme.