Power BI

1 Courses 2 Projects 15 Hours

Overview

This course will help the individual gain in-depth knowledge of all concepts of Power BI from basics to advanced level techniques. It is available in online mode for the best training at your own place. In this course, our industry expert trainers will help you gain expertise in the following concepts like Microsoft Power BI Desktop layouts, Power Query, Power BI Mobile, BI reports, Creating Dashboards, Power BI DAX commands, etc. Enrol now to know more about this course and get certified in it.

Course Fee

Can’t find a batch you were looking for?

Let us know

Key Features

  • Flexible Schedule
  • 24 x 7 Lifetime Support
  • Certification
  • Instructor Led Training

Curriculum

Download Curriculum

  • Getting Started
  • Class Introduction (BI Basics) 
  • Class Introduction (Power BI Desktop Overview) 
  • Data Discovery with Power BI Desktop
  • Transforming Data (Basic Transforms)  
  • Transforming Data (Add Column From Example)
  • Transforming Data (Appending Queries)
  • Transforming Data (Merging Queries)
  • Transforming Data (Combine Files)
  • Transforming Data (Parameters and Templates)
  • Transforming Data (Other Query Features)
  • Introduction to Modeling Data
  • Creating the Data Model (Modeling Basics)
  • Creating the Data Model (Model Enhancements)
  • Creating Calculated Columns and Tables (DAX Basics)
  • Creating Calculated Columns and Tables (Calculated Tables)
  • Creating Calculated Measures (Measure Basics)
  • Creating Calculated Measures (Time Intelligence Functions)
  • Introduction to Visualizing Data
  • Creating Basic Reports with the Power BI Desktop
  • Creating Interactive Reports (Adding Slicers for Filters)
  • Creating Interactive Reports (Visualizing Tabular Data)
  • Creating Interactive Reports (Visualizing Categorical Data)
  • Creating Interactive Reports (Visualizing Data Trends)
  • Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
  • Creating Interactive Reports (Visualizing Geographical Data with Maps)
  • Creating Interactive Reports (Visualizing Goal Tracking)
  • Creating Interactive Reports (Using Custom Visuals)
  • Creating Interactive Reports (Other Features)
  • Using the Power BI Service (Deploying to the Power BI Service)
  • Using the Power BI Service (Creating and Sharing Dashboards)
  • Using the Power BI Service (Using Power BI Q&A)
  • Using the Power BI Service (Subscriptions and Alerts)
  • Using the Power BI Service (Excel Integration)
  • Refreshing the Data (Refreshing Data Overview)
  • Refreshing the Data (Installing the Data Gateway)
  • Refreshing the Data (Scheduling a Data Refresh)
  • Mobile BI (Power BI Mobile Overview)
  • Mobile BI (Designing Reports and Dashboards for Mobile)
  • Mobile BI (Interacting with the Power BI Mobile App)
  • Excel
  • CSV
  • Flat File
  • Sql Server
  • SSAS Multidimensional
  • SSAS Tabular
  • Getting Started
  • Data Modeling Basics (Overview)
  • Data Modeling Basics (Tabular)
  • What is DAX (Overview)
  • What is DAX (Tabular)
  • Creating Calculated Columns (Basics)
  • Creating Calculated Columns (Basics Continued)
  • Navigation Functions
  • Conditional and Logical Functions
  • Creating Calculated Measures
  • Time Intelligence (Overview)
  • Time Intelligence (Time Intelligence Functions)
  • Using X-Functions and A-Functions
  • Table Functions
  • DAX as a Query Language
  • Class Introduction (Class Files)
  • Class Introduction (Why Advanced DAX)
  • Working with Variables
  • Working with Filter Context (What is Filter Context?)
  • Working with Filter Context (CALCULATE)
  • Working with Filter Context (Overriding Filter Context)
  • Working with Filter Context (FILTER)
  • Working with Filter Context (FILTER and ALL)
  • Working with Filter Context (ALLEXCEPT)
  • Working with Filter Context (Totals)
  • CALCULATE and Time Intelligence (YTD and MTD)
  • CALCULATE and Time Intelligence (Rolling 12 Months Total)
  • CALCULATE and Time Intelligence (Rolling 3 Month Average Total)
  • Security (Implementing Basic Security)
  • Security (Dynamic Security)
  • Role Playing Dimensions (Multiple Table Import)
  • Role Playing Dimensions (USERELATIONSHIP)
  • Advanced DAX Function (CONTAINS)
  • Advanced DAX Function (FIND)
  • Advanced DAX Function (SEARCH and SUBSTITUTE)
  • Advanced DAX Function (ALLSELECTED)
  • Advanced DAX Function (RANKX)

Need customized curriculum?

Talk to Us

Certification

Power BI Certification

SLearn certification is awarded, after successful completion of the project work which shows that trainee have learned, achieved skills and experiences from the project. All the acknowledged trainees are therefore eligible for challenging projects and better job opportunities in MNC's like TCS, IBM, Cisco, Cognizant, Wipro, Dell etc.

Get Sample Certificate

Faq's

Free Career Counselling

We are happy to help you