Seattle, United States

Data Analytics and BI

Microsoft Business Intelligence (BI) Training Programin Seattle

Develop business intelligence expertise with Microsoft BI Training in Seattle, United States . Learn data integration, SQL fundamentals, Power BI, data modelling, reporting, and dashboard development. Explore analytical workflows, business…

30–40 Hours/4-5 daysLive virtual trainingFoundation

Training is delivered live online for learners in Seattle, United States. Corporate programs are available for teams; request a quotation to confirm the schedule.

Plan your attendance

Training information for Seattle

Selected country and city time: America/Los_Angeles. Times follow the selected country and city. Choose another time zone below if needed.

Training information for Seattle
DeliveryLive online · Classroom when confirmed
Price$799 USD

Bookings and payments are in USD only.

ScheduleCourse-page batches starting in the next 7 days; subject to availability
Exam voucherCheck with StepMerit
Classroom venueClient premises or a StepMerit-arranged conference hall in Seattle, subject to venue and batch confirmation.
Weekend · 4 training days

Starts Nov 21, 2026, 9:00 AM

First session ends Nov 21, 2026, 3:00 PM

America/Los_Angeles · Weekend hours are flexible. Schedule and delivery subject to confirmation.

Enquire about this batch
Weekday · 4 training days

Starts Nov 23, 2026, 9:00 AM

First session ends Nov 23, 2026, 5:00 PM

America/Los_Angeles · Schedule and delivery subject to confirmation.

Enquire about this batch
Corporate batches

Chat with us on WhatsApp to arrange training for your team.

What you will learnExpand syllabus +

Module 1: Introduction to Microsoft Business Intelligence

  • Overview of Business Intelligence (BI) concepts and architecture
  • Role of Microsoft BI tools in business analytics and reporting
  • Understanding data sources, datasets, and business information
  • Introduction to Microsoft SQL Server and Power BI
  • Business intelligence workflows and enterprise reporting requirements

Module 2: Database Fundamentals and SQL

  • Introduction to relational database management systems
  • Understanding tables, records, fields, and relationships
  • SQL commands for data retrieval and manipulation
  • Using SELECT, WHERE, ORDER BY, and GROUP BY statements
  • Working with joins, subqueries, and aggregate functions
  • Querying business datasets for analytical reporting

Module 3: Data Connectivity and Integration

  • Connecting Microsoft BI tools to different data sources
  • Importing data from Excel, SQL Server, and other databases
  • Understanding data connectivity and storage modes
  • Working with structured and semi-structured datasets
  • Managing data refresh and source configurations
  • Applying data integration techniques for reporting solutions

Module 4: Data Preparation and Transformation

  • Introduction to data cleaning and preparation techniques
  • Using Power Query for data transformation
  • Removing duplicates and handling missing values
  • Filtering, sorting, merging, and appending datasets
  • Creating calculated columns and custom transformations
  • Preparing reliable datasets for business analysis

Module 5: Data Modelling and Relationships

  • Understanding data modelling concepts and methodologies
  • Creating relationships between multiple data tables
  • Working with primary keys and foreign keys
  • Understanding star schema and snowflake schema
  • Building logical data models for business reporting
  • Optimising data models for analytical performance

Module 6: Power BI Fundamentals

  • Introduction to Power BI Desktop, Service, and Mobile
  • Understanding the Power BI development environment
  • Importing and connecting datasets in Power BI
  • Creating tables, charts, and basic visualisations
  • Designing interactive reports and dashboards
  • Publishing and sharing Power BI reports

Module 7: DAX and Advanced Calculations

  • Introduction to Data Analysis Expressions (DAX)
  • Creating calculated columns and measures
  • Using SUM, AVERAGE, COUNT, and related functions
  • Applying CALCULATE and FILTER functions
  • Working with time intelligence calculations
  • Developing business metrics and KPI calculations

Module 8: Data Visualisation and Dashboard Development

  • Selecting appropriate charts and visualisation techniques
  • Designing interactive business intelligence dashboards
  • Working with slicers, filters, and drill-through features
  • Creating KPI cards, charts, and performance indicators
  • Applying visual storytelling and dashboard design principles
  • Building management reports for business decision-making

Module 9: Report Publishing, Security, and Performance

  • Publishing reports to Power BI Service
  • Configuring workspaces, apps, and report access
  • Understanding row-level security (RLS)
  • Managing scheduled data refresh
  • Applying report optimisation and performance improvement techniques
  • Sharing business insights across organisational teams

Module 10: Practical Business Intelligence Project

  • Identifying business reporting requirements and analytical objectives
  • Connecting and integrating sample business datasets
  • Cleaning, transforming, and modelling data
  • Developing SQL queries and analytical calculations
  • Creating interactive Power BI dashboards and reports
  • Presenting business insights through a practical BI project

Exam details

  • Assessment Type: Online or classroom-based assessment.
  • Exam Level: Beginner to Advanced.
  • Question Format: Multiple-choice, scenario-based, and practical questions.
  • Total Questions: Approximately 40 questions.
  • Exam Duration: 90 minutes.
  • Proposed Passing Score: 70% (28 out of 40 questions).
  • Practical Assessment: Data preparation, SQL querying, data modelling, and Power BI dashboard creation.
  • Project Evaluation: Development of a business intelligence report using sample datasets.
  • Key Topics: Microsoft BI concepts, SQL, Power Query, data transformation, data modelling, DAX, Power BI visualisation, reporting, and dashboard development.
  • Certification: Eligible learners may receive a StepMerit Learning Certificate of Course Completion, subject to programme requirements.

Plan your learning

Who this course is for

- Aspiring Business Intelligence Analysts: Individuals seeking to build a career in business intelligence through SQL querying, data modelling, analytical reporting, and Microsoft Power BI dashboard development. - Power BI Developers and Reporting Specialists: Professionals looking to strengthen their expertise in interactive dashboards, DAX calculations, data transformation, report publishing, and business performance visualisation. - Data Analysts and Business Analysts: Learners who want to convert raw business datasets into meaningful insights using Microsoft BI tools, analytical techniques, and KPI-driven reporting. - SQL Developers and Database Professionals: IT professionals interested…

Before you begin

Basic Computer Literacy: Familiarity with operating systems, file management, and productivity applications is recommended for learners starting Microsoft BI Training in Seattle, United States . Microsoft Excel Fundamentals: Basic knowledge of worksheets, formulas, tables, sorting, filtering, and spreadsheet reporting helps learners understand business data preparation. Data Analysis Fundamentals: An introductory understanding of datasets, data types, business metrics, and analytical concepts is useful for developing business intelligence reports. Database Knowledge: Familiarity with relational databases, tables, rows, columns, and basic SQL concepts can support data connectivity and…

Learning outcomes

Problem Statement – A telecommunications company faces challenges with fragmented customer data, disconnected operational databases, delayed reporting, limited visibility into network performance, and inefficient business decision-making. These issues affect customer service, billing operations, network management, sales performance, and service delivery. The goal is to improve data accessibility, reporting accuracy, and business intelligence using Microsoft BI technologies. How We Overcame the Problem – Learners applied Microsoft BI concepts, SQL querying, data integration, Power Query, data modelling, DAX calculations, and Power BI visualisation to consolidate business information…

Related reading

Course blogs for learners in Seattle

Explore this course locally

Know the location

Local information: Seattle

Seattle, United States. View city location ↗

City overview

Seattle, United States.

Geography & administration

Time zone: America/Los_Angeles.

Education & learning

Course learning optionsExplore Microsoft Business Intelligence (BI) Training Program through live online instructor-led training. Seattle learners can request a corporate program for their teams. Course duration: 30–40 Hours/4-5 days. Check the upcoming online batches and contact StepMerit to confirm the schedule and exam arrangements.

Explore related courses and cities

Find related training in Seattle or explore this course in another city.

View more (3)