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:
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
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
Introduction to Power BI
- Build your own dashboards
- Understand the Power BI ecosystem
- Extract and model data
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
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.
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.
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
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
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.
Data Modeling
- Modeling methodologies and advanced data modeling techniques
- Transactional and dimensional model design
- How to define the business process
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
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
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.
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
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
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
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.
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
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
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
Introduction to SSRS
- Create complex reports
- Key concepts of Reporting Services from basic reporting, parameters, deploying and scheduling
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
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.
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
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
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
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
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
Administering Business Intelligence
- Write queries that involve multiple tables and summary queries
- Modify data and understand the logical programming aspects of T-SQL
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.
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.