Certificate in POWER BI


Certificate in POWER BI
@ AICT

Module 1: Introduction to Power BI

• Power BI Architecture

• Power BI introduction and overview

• Introduction Power BI Desktop and Power BI in Excel

• Connecting with Data

• Introduction to Power BI Components: Power Query, Power Pivot, Power View &Power Map

Module 2: Power Query for Data Transformation

• Installation, Requirements, and Configuration

• Different versions of Power Query

• Power Query Introduction

• Query Editor

• Transformation GUI

• Row Transformations

• Column Transformations

• Data Type

• Adding Column

• Text Transformations

• Number Column Calculations

• Date and Time Calculations

• Data types, Lists, Records, and tables in M

• M built-in functions

Module 3: Power Pivot and Data Sources

• Using SQL Server data.

• Loading data from cubes.

• Load data from text files.

• Using data from Excel sheets. • Loading data via data feeds.

Module 4: Building PivotTables on Power Pivot

• Building pivot tables on top of Power Pivot.

• Using Pivot Charts.

• Working with Slicers.

• Building custom sets.

• Combine Power Pivot data with Sparklines. • Deploying PivotTables to Excel Services.

Module 5: Introduction Power View

• From personal BI to corporate BI.

• Power View reports in Excel and SharePoint.

Module 6: Authoring Power View reports

• Create tables and Matrices.

• From table to chart.

• Interactive sorting, filtering and highlighting.

• Working with bubble charts. • Slicers, cards and multiples.

• Adding maps to Power View.

• Working with multi-view reports.

• Improving Power Pivot models for Power View reporting.

Module 7: Deploying Power View reports

• Saving Power View reports in document libraries.

• Power Pivot Gallery functionality.

• Printing the report.

• Export to PowerPoint functionality.

 

Module 8: Power Map

• Mapping geographical data.

• Exploring visualization options. • Working with multiple scenes.

 

Individual Classes. Arrange your convenient time. Professional Training, Course Conducted by Qualified Lecture.

Duration

40 Hours

Course Fee

24500

Course Level

Certificate

Location

Colombo

Category

Information Systems , Information Science

Contact Details

+94 11 2 363632 +94777996242

http://www.aictstudy.com

03, 1/1 , Fernando Road , Colombo 06

Send Inquiry

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scholarship Alerts

Type "REG coursenet" and SEND to 77000

Get latest scholarships, offers & academic event alerts to your phone via SMS.

Service is available for Dialog, Mobitel, Hutch & Airtel users. Monthly (Rs. 30 + tax).

Related Courses

Institute Courses

Loading...