Koed

Key Features

Koed Brand to

back your credentials

The certificate given upon successful completion of the course will be endorsed by Koed which has industry & Govt. of india recognition.

Industry Experts as mentors

Koed is a well known brand having Industry expert trainers with decades of working and training experience distinguished status among the companies.

A 360 exclusive Support to

Our Placement Cell

Providing Job support, Interview preparation and Resume Analysis, Alumni portal access, E-learning, and lots more!

REQUEST DETAILLED SYLLABUS ENROLL NOW

Mentors From

About Business Intelligence Course

Duration/Mode: 24 Hours Live Online Training.
Trainer: Industry expert trainers with decades of working and training experience.
Live Projects: Experience Industry oriented Projects during the training.
Prime Membership: Get a 1-Year Prime Membership of Koed and avail the 360^o placement support.
Job Opportunities and Internship: Get access to job opportunities to top MNCs.
E-Learning Access: Includes Recorded Videos, Projects, and Case Studies resume & placement support Job Opportunities and Internship: Get access to job opportunities to top MNCs.

Benefits of Koed Business Intelligence Course

24-Hours Live Virtual Training.
1-Yr Prime Membership of Koed and avail the 360^o placement support.
Access to the Koed LMS.
Recorded Videos of the Session for recap.
Resume analysis and Interview Preparation.
100% Job Support exclusively entitled for BI Specialist Professionals.

Own a certificate in exchange for your merit and hard work, not just money.

Acquire
In your hand, will rest a Koed certificate once you test your knowledge in the exam and pass with flying colours. Once all modules of the course are done, our trainers will be greatly pleased to share your reward with you.
Think out of the box, go out of your comfort zone
Everybody has an option to do things the conventional way but only some have the courage to own up and do it in their own way. Once you complete all modules of the course, you will be instilled with all the required skills and knowledge to be able to carve your own way. You will see your productivity shoot up at work, during interviews and more.
Share and inspire others
No success story is a great story until it motivates other people to work harder. We would encourage you to highlight and show the world the reward you earned for your hardwork and consistency. Share the certificate on social media channels, alumni networking meetings and other platforms. Remember when it's your time to shine, shine brightly.

Power BI Course Curriculum

Module 1: Business Intelligence (BI) Concepts

In this module the candidate will learn about importance, Tools and Technologies in Business Intelligence and the relationship between Business Intelligence and Data Warehouse.

Introduction to Business Intelligence
The importance of Business Intelligence
The relation between Business Intelligence and Data Warehouse
Tools and Technologies in Business Intelligence area

Module 2: Microsoft Power BI (MSPBI) Introduction

In this module the candidate will learn about the overview of Architecture og Power BI, and introduction to Power BI desktop and Power BI in Excel Power BI Architecture Power BI introduction and overview Introduction Power BI desktop and Power BI in Excel

Module 3: Connecting Power BI with Different Data Sources

In this module the candidate will learn about how to connect to CSV, Excel , Text, SQL Server, Webpage, and Direct SQL Query in Power BI Desktop Connect to CSV files in Power BI Desktop Connect to Excel in Power BI Desktop Connect to text in Power BI Desktop Connect to SQL Server in Power BI Desktop Connect to a Web page from Power BI Desktop Connect to Direct SQL Query in Power BI Desktop

Module 4: Power Query for Data Transformation

In this module the candidate will learn about Power Query, Query Editor, Editor interface, Column Transformations, Data Type, Adding Columns, Number column and date and time Calculations, and Built-in functions

Power Query Introduction
Query Editor
Query Editor Interface
Column Transformations
Data Type
Adding Column
Text Transformations
Number Column Calculations
Date and Time Calculations
M built-in functions

Module 5: Data Modelling in Power BI

In this module the candidate will learn about DAX, calculated Columns and Tables, Row Context and Set Context, Advanced calculations using Calculate Functions and knowledge of Time Intelligence Functions.

Introduction to DAX
Calculated Columns
Measures
Calculated Tables
Row Context vs Set Context
Advanced calculations using Calculate functions
Time Intelligence Functions

Module 6: Reports in Power BI

In this module the candidate will learn about Reports in Power BI, how to create, use report editor, add page, add Filter, Save report, Bout filtered and Highlighting, analyze in Excel, open a Power BI in Report Reading View and change how visuals interact in a Report, interact in editing view, rename a report, duplicate and delete a page from Power BI Report.

Create a new Power BI report
The report editor in Power BI
Add a page to a Power BI report
Add a filter to a report in Power BI
Save a report in Power BI
About filters and highlighting in Power BI reports
How to use report filters
Analyze in Excel
Change how visuals interact in a report
Open a Power BI report in Reading View
Go from Reading View to Editing View in Power BI
Interact with a report in Editing View in Power BI
Aggregates (sum, average, maximum, etc.) in Power BI
Rename a report in Power BI
Page display settings in a Power BI report
Duplicate a report page in Power BI
Delete a page from a Power BI report
Rename a report page

Module 7: Reports & Visualization Types in Power BI

In this module the candidate will learn about Reports and Visualization in Power BI, which includes, types and custom visualization, Downloading a custom visual from gallery, color formatting, sorting chart in Power BI, Drill down in Visualization, Histogram, Basic Area chart, Combo Chart, Doughnut charts, Enhanced scatter charts, Etc.

Types of visualization in a Power BI report
Custom visualization to a Power BI report
Download a custom visual from the gallery
Getting started with color formatting and axis properties
Change how a chart is sorted in a Power BI report
Move, resize, and pop out a visualization in a Power BI report
Drill down in a visualization in Power BI
Histograms
Basic Area chart
Combo Chart in Power BI
Customize visualization title, background, and legend
Customize X-axis and Y-axis properties
Doughnut charts in Power BI
Enhanced Scatter charts in Power BI
Funnel charts in Power BI
KPI Visuals
Radial Gauge charts in Power BI
Scatter Charts in Power BI
Slicers in Power BI
Tree Maps in Power BI
Waterfall charts in Power BI

Module 8: Dashboards in Power BI

In this module the candidate will learn about Dashboards in Power BI, how to create Power BI dashboards, Pin a Tile, Power BI publisher for Excel, Data Alerts, Adding Images, video etc, Tips for designing a great Power Dashboard, Featured Dashboard and Adding an image to a Dashboard.

Create a Power BI dashboard
Dashboard tiles in Power BI
Pin a tile to a Power BI dashboard from a report
Power BI publisher for Excel
Pin an entire report page to a Power BI dashboard
Data alerts in Power BI service
Add an image, text box, video, or web code to your dashboard
Edit a tile — resize, move, rename, pin, delete, add hyperlink
Tips for designing a great Power BI dashboard
Print a dashboard, print a dashboard tile, print a report page
Display dashboards and reports in Full Screen mode (TV mode)
Display a dashboard tile in Focus mode
Featured dashboards in Power BI
Create a phone view of a dashboard
Add an image to a dashboard

Module 9: Data Refresh in Power BI

In this module the candidate will learn about Configure scheduled refresh, how to refresh a dataset created from a Power BI Desktop File - Local and Cloud and how to Refresh a dataset created from an Excel workbook - Local