BI Architects Make Better Decision Makers

Design and Build Systems to Answer Questions

Design systems to store, load and report against data throughout the company.

determine data warehouse

Design and build systems to gather data from throughout the company and standardize the data.

READY TO BECOME
A BI ARCHITECT?
WE HAVE YOU COVERED.

Pragmatic Works’ On-Demand Learning is set up with your success in mind. We have made thousands of people and teams like yourself reach their highest potential and salary. Our author and MVP team is passionate about guiding you and your team to a new skill.

The average BI Architect salary is $112,000.

Source: PayScale/ZipRecruiter Surveys

BI Architect U.S. Average Salary

STEP-BY-STEP PLAN FOR BUSINESS INTELLIGENCE MASTERY

The Learning Path includes classes offered as part of your On-Demand Learning package.  More classes are being added each quarter and old ones are constantly being updated because of the amount of change in business intelligence each month.

Start With The Free Community Plan​

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses.

Set Your
Learning Path

Set your Learning Path in the learning management system that guides you to accomplish your goals.

Achieve
Certifications

Prove you have the knowledge and the know-how with Microsoft certifications.

BI Architect Plan

Pragmatic Works’ On-Demand Learning classes are constantly being updated and re-recorded to make sure you have the latest info about business intelligence. Here’s a list of classes we recommend taking in the proper order:

Class
Class

Introduction to T-SQL

  • Understand the structure of a SQL Server database
  • Query tables and sort and filter the results
  • Write queries that involve multiple tables and summary queries
  • Learn to modify data and about the logical programming aspects of T-SQL

 

Class Info
Class
Class

Advanced T-SQL

  • This course has been designed using examples from real world scenarios
  • In many cases, the course demonstrates the different methods to solve a particular scenario and then explains why one may be better than another due to performance reasons
  • The course has a heavy emphasis on writing optimal queries

 

Class Info
Certification Exam
Certification Exam

Exam 70-761: Querying Data with Transact-SQL

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

 

Exam Info
Class
Class

Introduction to Power BI

  • Build your own dashboards
  • Understand the Power BI ecosystem
  • Extract and model data

 

Class Info
Class
Class

Advanced Power BI

  • Learn how the languages of R and M can be used to extend standard data extraction and transformation capabilities of Power BI
  • Understand complex data modeling scenarios and how Power BI can overcome them
  • Advanced data visualization techniques that can take your reports and dashboards beyond the basics

 

Class Info
Class
Class

Power BI Service Administration

  • Integrate Power BI into your corporate environment
  • In this course we cover various topics such as deployment, data refresh, security, collaboration, data governance, auditing and more.

 

Class Info
Exam
Exam

Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Candidates for this exam should have a good understanding of how to use Power BI to perform data analysis. Candidates should be proficient in connecting to data sources and performing data transformations, modeling and visualizing data by using Microsoft Power BI Desktop, and configuring dashboards by using the Power BI service. Candidates should also be proficient in implementing direct connectivity to Microsoft SQL Azure and SQL Server Analysis Services (SSAS), and implementing data analysis in Microsoft Excel. Candidates may include BI professionals, data analysts, and other roles responsible for creating reports by using Power BI.

 

Exam Info
Class
Class

Building BI with Pivot Tables

  • Build reports and quickly summarize 10s to 1,000s of rows of data quickly
  • The best ways to source and clean up source data for reporting
  • Present the data in a way that is easy to use for analysis by presenting data in both tabular and visually
  • Explore the best ways to analyze the data and drill in and out of data
  • Sourcing data, cleansing it, and analyzing it through pivot tables and dashboards

 

Class Info
Class
Class

Interactive Dashboards with Excel

  • Save time in Excel
  • Understand design patterns and strategies for building dashboards in Excel
  • Use the Formulas and Functions for the purpose of designing dashboards

 

Class Info
Exam
Exam

Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel

Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. Candidates may include BI professionals, data analysts, and other roles responsible for analyzing data with Excel.

 

Exam Info
Class
Class

Data Modeling

  • Modeling methodologies and advanced data modeling techniques
  • Transactional and dimensional model design
  • How to define the business process

 

Class Info
Class
Class

Introduction to SSIS

  • Create an SSIS package to load to a database
  • Make dynamic packages that work and self-heal in the event of a failure
  • Use SSIS in your environment

 

Class Info
Class
Class

Advanced SSIS

  • Use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges
  • Implementing common real-world SSIS patterns taught from the experts of SSIS
  • In-depth SSIS training with advanced discussion in many areas

 

Class Info
Exam
Exam

Exam 70-767: Implementing a Data Warehouse using SQL

This exam is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.

 

Exam Info
Class
Class

Introduction to SSAS 2012/2014/2016

  • Develop a data warehouse for your company and a repeatable methodology for a successful SSAS project
  • Create and configure a cube and dimensions
  • Write MDX (the querying language for cubes)
  • Define calculations, Key Performance Indicators (KPIs) and perspectives, and implementing dynamic security
  • Administer and deploy SSAS, defining actions, implementing data mining
  • Build office-based BI applications and dashboards, and administering SSAS

 

Class Info
Class
Class

Introduction To MDX

  • How to write MDX queries to retrieve data from an Analysis Services cube
  • Common functions for creating sets and performing set-based operations
  • MDX and Cube security
  • Optimization techniques for queries

 

Class Info
Class
Class

Advanced SSAS

  • Create complex reports that use Analysis Services as a data source and custom code assemblies
  • Master advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage

 

Class Info
Exam
Exam

Exam 70-768: Developing SQL Data Models

This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

 

Exam Info
Class
Class

Introduction to SSAS Tabular

  • Use Power Pivot and create Tabular data models
  • Create calculated columns and calculated measures with DAX
  • Managing and securing Tabular models
  • Advanced data analysis to gain insight from your business data

 

Class Info
Class
Class

Introduction to DAX

  • Add analytical value to data models by creating calculated columns and measures
  • Develop a strong understanding of how to work with time intelligence functions in DAX
  • Build the foundations necessary for authoring more complex DAX calculation

 

Class Info
Class
Class

Advanced DAX

  • Siggnificantly enhance the analytical value of data models with DAX calculations
  • Develop a strong understanding of advanced DAX concepts and learn to think like DAX
  • Understand when and how to use the more advanced DAX functions

 

Class Info
Class
Class

Introduction to SSRS

  • Create complex reports
  • Key concepts of Reporting Services from basic reporting, parameters, deploying and scheduling

 

Class Info
Class
Class

Mobile Reports and Dashboards with SSRS

  • Use the Mobile Report Publisher for designing Dashboards viewable on your desktop, tablet and phone
  • Design KPIs in the Web Portal
  • Administer and manage security on your Mobile Reports

 

Class Info
Exam
Exam

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server

This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

 

Exam Info
Class
Class

Advanced SSRS

  • Create complex reports that use Analysis Services as a data source and custom code assemblies
  • Master advanced topics of reporting services like scaled-out deployment, .Net integration and monitoring reporting services usage

 

Class Info
Class
Class

Introduction to Azure SQL Database

  • Configure and manage databases in the Microsoft Cloud
  • Perform common task for implementing security and making the solution highly-available

 

Class Info
Class
Class

SQL Server Hardware and Software Configuration

  • Learn how hardware and software operate together so you can better understand what your systems can actually achieve
  • Configure hardware and software properly for SQL Server

 

Class Info
Class
Class

Introduction to PowerShell

  • Understand what PowerShell is and how it can be used
  • Understand and work with cmdlets
  • Navigate the PSProvider and work with the pipeline
  • Write your own scripts for managing SQL Server

 

Class Info
Class
Class

SQL Server Performance Tuning

  • SQL Server Index Tuning and Query Tuning best practices
  • Use tools such as Profiler, Extended Events and SQLIO
  • Create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns

 

Class Info
Class
Class

Administering Business Intelligence

  • Write queries that involve multiple tables and summary queries
  • Modify data and understand the logical programming aspects of T-SQL

 

Class Info
Exam
Exam

Exam 70-764: Administering a SQL Database Infrastructure

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

 

Exam Info
Certification Complete!
Certification Complete!

Mission Accomplished!

It was a challenging journey, but you have arrived and are certified.

Business Intelligence (BI) architects are in charge of analyzing and implementing business intelligence for their organization. They are responsible for determining platforms and correct functioning for the central data warehouse.

Begin Your Journey to Become a BI Architect

Get Our Special Offers Directly to Your Email