Migrate SQL Workloads to Azure
Course Facts
- 2 day course
- Our Trainers are Authorised Professionals
- Live Online or Classroom-based
- Certificate of completion
- Maximum class size of 6 for scheduled courses
- Unlimited support after your course
- Courses at all levels: Introduction, Intermediate, Advanced and Masterclasses
Course Outline
- Introduction to Business Intelligence
- Introduction to PowerPivot and Analysis Services Tabular Mode
- A First Look at Tabular BISM
- Enhancing Your Tabular BISM
- Introduction To DAX
Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Enquire NowTeam Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Enquire NowTeam Training and Bespoke Sessions
Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.
- Sessions can be run online or in person, on your site or at our London training centre.
- We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
- Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
- We offer a free consultation service to work out every detail of your course.
Prices for bespoke sessions with our expert trainers start at £525 + VAT.
Overview
Course Outline
Introduction to Business Intelligence
- OLTP databases
- OLAP databases
- Data Warehouses
- SSIS ETL, SSRS and SSAS
Introduction to PowerPivot and Analysis Services Tabular Mode
- What Is PowerPivot?
- PowerPivot Deployment Options
- Self-Service Business Intelligence (SSBI)
- Differences between SSAS Tabular Mode and Multidimensional
- Power Pivot Data Models
- Pivot Tables and Charts
A First Look at Tabular BISM
- Using Visual Studio and working with Projects
- The Tabular Designer
- Importing Data
- Relationships
- Calculations
- Browsing Models
- Modelling and Deploying
- Administering Tabular Models with SSMS
Enhancing Your Tabular BISM
- Refining the Tabular Model
- Hierarchies
- Measures
- KPIs
- Perspectives
- Partitions
- Processing a Tabular Database
- Creating and Applying Security Roles
Introduction To DAX
- DAX Fundamentals
- DAX Operators
- DAX Functions
- DAX as a Query Language
Advanced Topics in DAX
- Parent-Child Hierarchies
- Cross Filtering with Many-to-Many Relationships
- Multiple Relationships Between Tables
- Time Based Analysis
- Non-Aggregatable Columns
Analysing Tabular BISMS in Excel
- Pivot Tables
- Sheet Data Reports
- Pivot Charts
- Local Cubes
- Excel Services
Reporting on Tabular Models with SSRS
- PowerPivot
- PowerPivot Add-In for Excel
- PowerPivot data model
Our Clients
Why Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact specification.
Worldwide Creative Skills Training
Join our authorised training courses live online from anywhere in the world.
Authorised Training Professionals
Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.
Courses Live Online
Join our virtual classrooms to learn from the comfort of your own space in real time from our accredited training experts.
SEE COURSESClassroom Training
Join us at one of our Authorised Training Centres for a traditional classroom-based experience.
We have everything ready for you to have the best training experience.
SEE COURSESPrivate Courses
One-to-one tuition or a private group training with just you or your colleagues.
We can train you live online, at one of our centres or onsite, wherever you are located.
SEE COURSESUseful Links
- Wikipedia page for SQL Server – History and capabilities of SQL Server
- SQL Server internals and architecture guides – Discusses general concepts and apply to all versions of SQL Server, unless stated
- Tutorials from W3 Schools – SQL tutorials that will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres and other database systems
- SQL Server download page – Microsoft-authored tutorials to help you learn new technologies and features