Microsoft Power Business Intelligence Training

BY
Careerera

Mode

Online

Duration

24 Hours

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based

Course and certificate fees

certificate availability

Yes

certificate providing authority

Careerera

The syllabus

Chapter - 1: Power BI –A Complete Package Introduction

Chapter - 1.1: Introduction to Power BI

Chapter - 1.2: Components of Power BI

Chapter - 1.3: Installing Power BI Desktop

Chapter - 1.4: Various Options in Power BI Desktop

Chapter - 2: Working with Different Sources (Excel, SQL Server, OData Feed etc.)

Chapter - 2.1: Import

Chapter - 2.2: Direct Query

Chapter - 2.3: Import vs Direct Query

Chapter - 2.4: Limitations of Direct Query

Chapter - 2.5: Query Editor

Chapter - 2.6: Working with Power Query Editor

Chapter - 2.7: Relationships (1:1, 1: Many, Many:1)

Chapter - 2.8: Basics of M Language

Chapter - 3: Reports Development

Chapter - 3.1: Reports Development in Power BI

Chapter - 3.2: Working with Different Visuals

Chapter - 3.3: Formatting Options in Reports

Chapter - 3.4: Working with Filters

Chapter - 3.5: Custom Visuals

Chapter - 4: Power BI Service (Power BI service domain account will be provided to hands on Service)

Chapter - 4.1: Overview of Power BI Service

Chapter - 4.2: Publishing the Reports

Chapter - 4.3: Dashboards

Chapter - 4.4: Gateways

Chapter - 4.5: Enterprise vs Personal Gateway

Chapter - 4.6: Work Spaces

Chapter - 4.7: Content Packs/ Apps

Chapter - 4.8: Security

Chapter - 4.9: Schedule Data Refresh

Chapter - 4.10: Power BI Premium

Chapter - 5: SSAS Tabular

Chapter - 5.1: SSAS Tabular Overview

Chapter - 5.2: Install and Configure SSAS Tabular

Chapter - 5.3: Building a Tabular Model

Chapter - 5.4: SSAS Tabular as Source

Chapter - 5.5: Live Connections

Chapter - 5.6: Deploy & Processing in Tabular

Chapter - 5.7: SQL Server Agent

Chapter - 5.9: Schedule Processing of Model

Chapter - 6: Data Analysis Expressions (DAX)

Chapter - 6.1: Introduction to DAX

Chapter - 6.2: Calculated Columns

Chapter - 6.3: Measures

Chapter - 6.4: Calculated Columns vs Measures

Chapter - 6.5: Variables

Chapter - 6.6: Table Functions

Chapter - 6.7: Evaluation Contexts

Chapter - 6.8: Calculate

Chapter - 6.9: Time Intelligence in DAX

Chapter - 6.10: Frequently Used DAX functions in Real time

Chapter - 6.11: Calendar Functions

Chapter - 7: Advanced/ Other Power BI Concepts

Chapter - 7.1: Parameters

Chapter - 7.2: Drill Through

Chapter - 7.3: Bookmarks

Chapter - 7.4: Row level Security

Chapter - 7.5: Dynamic Measures

Chapter - 7.6: Dynamic Axis in Charts

Chapter - 7.7: Dynamic Filters

Chapter - 7.8: Power BI Template file

Chapter - 7.9: Wallpapers

Chapter - 7.10: Themes

Chapter - 7.11: Q&A

Chapter - 7.12: Editing the Themes

Chapter - 7.13: Power BI Updates

Chapter - 8: Live Project

Chapter - 8.1: Course Prerequisites

Chapter - 8.2: Before attending Analyzing Data with Power BI course, students must have:

Chapter - 8.3: Good understanding of relational databases and reporting.

Chapter - 8.4: Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).

Chapter - 8.5: Fundamental understanding of basic programming constructs (such as looping and branching).

Chapter - 8.6: Basic knowledge of key business priorities such as revenue, profitability, and financial accounting

Chapter - 8.7: Familiarity with Microsoft Office applications particularly Excel.

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books