POWER BI CERTIFICATION TRAINING

Posted on by admin
0

COURSE : POWER BI | ONLINE TRAINING | DURATION : 45 HOURS (30 Days)

Course Syllabus

Introduction

  • What is Business Intelligence(BI)
  • Introduction to Power Bi Desktop and Power BI service
  • Building Blocks of Power BI Desktop
  • Connect Data Sources and Transformations
  • Connect to Data Sources in Power BI
  • Clean and Transformation the data using Power query
  • Append, Merge, Pivot,UnPivot,grouping
  • Advanced Data Sources and Transformations

Modelling

  • How to manage data and Relationship
  • Create Calculate columns
  • Create measure and Create tables
  • Create measures and work with time-banded functions
  • Explore Time-Based data functions

Visualizations

  • Create and Customize Simple Visualizations
  • How to use combination charts
  • Create and format slicers and Filters
  • Table and Matrix
  • Map Visualization
  • Waterfall and Funnel chart
  • KPIs, Gauges ,Single and Multi Number cards
  • How to modify colors in charts and visuals
  • Styling reports with shapes, text boxes and images
  • Page Layout and formatting
  • Drill throw
  • Drill Down
  • Book Mark

Power BI Service

  • Exploring data
  • Create and Configure a Dashboards and Reports
  • Tiles
  • Introduction to Q&A Suggestions
  • Manual Refresh and refresh data
  • Install and Configure a Personal gateway
  • Publish and sharing the reports
  • Create groups
  • Create ,edit content packs
  • Share Dashboards, Report

DAX (Data Analysis eXpression language)

  • Introduction to DAX
  • Using DAX to create new models from existing data
  • DAX Calculated Columns and Measures, Relationships and Hierarchies
  • DAX Variable: Using variables in text, calculated columns, Measures and Calculated Tables
  • DAX Context: Implicit and Explicit Filters, Row Context and Context Transition
  • DAX Functions: Aggregation, Filter, Date and Time, Time Intelligence, Information, Counting, Logical, Mathematical, Statistical, Text Functions. Formulas
  • Queries in DAX
  • Table relationships
  • DAX Table valued Functions and Filters
  • More then 200 functions will covered

Create a SSAS Tabular Model Project using DAX

  • Import data from Source databases (Analysis Service or Power Pivot)
  • Create Relationship between the Tables (Modelling)
  • Create calculated Columns and Measures
  • KPIs
  • Hierarchies
  • Perspectives
  • Partitions
  • Translations
  • Roles
  • Create a SSAS Tabular model Project and Deployed into tabular Analysis
  • Pull the data from SSAS tabular to Power BI
  •  

Azure Analysis Service

  • Create a Tabular Model Project and Deployed the model into Azure environment
  • Extract data from Azure to Power BI

Interview Questions and Answers

Resume Preparation

project 1

Project 2

Register Now