Overview

This online course training will teach you how to use Power Apps visualizations, which allow your Business Analysis users to get Business Analytics and take actions from their Power BI reports in real-time. Moreover, we’ll look into the ways that Power BI and SQL Server Analysis Services can be integrated for enterprise-level data models and analysis for business decisions.  This online course training will teach you how to use Power Apps visualizations, which allow your Business Analysis users to get Business Analytics and take actions from their Power BI reports in real-time. Moreover, we’ll look into the ways that Power BI and SQL Server Analysis Services can be integrated for enterprise-level data models and analysis for business decisions.  In this course you will learn logical table design, indexing and query plans. This course focuses on the creation of database objects including views, stored procedures, parameters and functions. Common aspects of procedure coding such as indexes, concurrency, error handling, and triggers are also covered in this course. This course will also teach you how to optimize indexes, ensure data integrity, implement views, stored procedures and functions as well as manage transactions and locks. In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. In this Microsoft ASP .NET MVC online training course you will learn a powerful, patterns-based way to build dynamic websites that gives you full control over markup for enjoyable, agile development. You will learn ASP.NET MVC and its many features that enable fast, TDD-friendly development for creating sophisticated applications that use the latest web standards. Elevate your web development programming skills in this HTML5 and CSS3 training course. HTML5 and CSS3 are key web technologies that allow you to build up content for the internet. This training program showcases how to use innovative HTML5 multimedia features such as video, audio, and animation. With this course, you can unlock more creative possibilities with your digital media!

Your Training Instructor

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.

  • 10 Traning Hours
  • 65 Videos
  • 11 Topics
  • 75 Practice Questions

What is Power BI?

Power BI is a member of the Power Platform. Power BI is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your Power BI Dashboard Business users to derive business insights and take actions from right within their Power BI reports and dashboards, essentially your business intelligence platform. Finally, this Introduction to Microsoft Power BI course will explore the intersections between Power BI and Microsoft’s enterprise-level data modeling and analysis platform, SQL Server Analysis Services.

About this video course

Through this course you will have access to hours of video content and will learn the varied techniques and best practices that adhere to business intelligence skills and technical requirements for utilizing Power BI and develop interactive visualizations. In addition, as a Business analysts you’ll be given a comprehensive overview of how to access data from various sources–both relational or non-relational. Finally, students we’ll learn key concepts to explore ways on how to manage and deploy reports as well as dashboards in order to share your insights with others effectively.

Power BI Course Topics Objectives

  • Make the most of Power BI’s data by ingesting, streamlining, and transforming it
  • Leverage Advanced Power of model data to optimize your performance and scalability
  • Develop and generate reports for data examination, allowing you to make well-informed decisions
  • Leverage advanced report analytics to make sound decisions
  • Improve business processes and easily distribute and collaborate on reports with colleagues
  • Unleash the power of Power BI to produce stunning paginated reports!

Frequently Asked Questions About Introduction to Microsoft Power BI

What exactly will I learn in this course?

You’ll learn how to use Power BI’s data by ingesting, streamlining, and transforming it. You’ll develop and generate reports for data examination, learn to make well-informed decisions, and improve business processes. The course also includes creating Power App visuals, managing and deploying reports, and integrating Power BI and SQL Server Analysis Services​.

I’m a beginner. Is this course suitable for me?

Yes! This course is designed to introduce you to Microsoft Power BI. It covers a wide range of topics, from the basics of data preparation and loading, to creating reports and dashboards, and even advanced analytics. So, whether you’re a beginner or someone looking to expand their knowledge of Power BI, this course has something for you.

Who’s going to be teaching me?

The course is taught by James Ring-Howell, a full-stack developer with over 40 years of experience. James has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. He has also been teaching technology courses for over 20 years.

How is the course structured?

The course is divided into 11 modules, each focusing on a specific topic. Modules cover everything from preparing and loading data, designing a data model, creating model calculations using DAX, creating reports and dashboards, creating paginated reports, performing advanced analytics, creating and managing workspaces, creating Power App visuals, and integrating Power BI with Analysis Services.

Introduction to Microsoft Power BI Course Outline

Module 1 – Prepare Data

  •    1.1 Course Introduction

  •    1.2 Module 1 Introduction

  •    1.3 Introduction to Power BI

  •    1.4 Get data from various data sources

  •    1.5 Preview source data
Module 2 – Clean, Transform, and Load Data

  •    2.1 Module 2 Introduction

  •    2.2 DimEmployee Example

  •    2.3 DimEmployeeSalesTerritory Example

  •    2.4 DimReseller Example

  •    2.5 FactResellersSales Example

  •    2.6 ResellerSalesTargets Example

  •    2.7 Color Formats Example
Module 3 – Design a Data Model

  •    3.1 Module 3 Introduction

  •    3.2 Introduction to Data Modeling

  •    3.3 Model Relationships

  •    3.4 Table Configuration

  •    3.5 Model interface

  •    3.6 Quick Measures

  •    3.7 Many-to-many relationships

  •    3.8 Row-level security
Module 4 – Create Model Calculations using DAX

  •    4.1 Module 4 Introduction

  •    4.2 DAX context

  •    4.3 Calculated Tables

  •    4.4 Calculated Columns

  •    4.5 Managing Date Tables

  •    4.6 Measures

  •    4.7 Filter Manipulation

  •    4.8 Time Intelligence
Module 5 – Create Reports

  •    5.1 Module 5 Introduction

  •    5.2 Basic Report Creation

  •    5.3 Example Page 1

  •    5.4 Example Page 2

  •    5.5 Example Page 3

  •    5.6 Report Publishing

  •    5.7 Enhancing Reports

  •    5.8 Drill-Through Pages

  •    5.9 Conditional Formatting

  •    5.10 Buttons and Bookmarks
Module 6 – Create Dashboards

  •    6.1 Module 6 Introduction

  •    6.2 Dashboard Basics

  •    6.3 Real Time Dashboards

  •    6.4 Enhanced Dashboards
Module 7 – Create Paginated Reports

  •    7.1 Module 7 Introduction

  •    7.2 Introduction to Power BI Report Builder

  •    7.3 Report Layouts

  •    7.4 Report Data

  •    7.5 Report Tables
Module 8 – Perform Advanced Analytics

  •    8.1 Module 8 Introduction

  •    8.2 Introduction to Advanced Analytics

  •    8.3 Scatter Chart

  •    8.4 Forecast

  •    8.5 Decomposition Tree

  •    8.6 Key Influencers
Module 9 – Create and Manage Workspaces

  •    9.1 Introduction to Workspaces

  •    9.2 Working with Workspaces and the Portal
Module 10 – Create Power App Visuals

  •    10.1 Module 10 Introduction

  •    10.2 Introduction to Power Apps Visual

  •    10.3 Creating the App

  •    10.4 Basic Power Apps Concepts

  •    10.5 Refreshing the Report
Module 11 – Analysis Services and Power BI

  •    11.1 Module 11 Introduction

  •    11.2 Introduction to Analysis Services

  •    11.3 Connecting with Multidimensional Models

  •    11.4 Premium Workspaces and Analysis Services

  •    11.5 Course Wrap Up