# Business Intelligence Course

> Are you interested to learn business intelligence? We at next g classes offers this course in both online and offline mode.

- Institute: Next-G Classes, Plot No 4, Kh. No. 59/13, First Floor, Pal Colony, Rithala, Near Rithala Metro Station, Delhi - 110085
- Web page: https://nextgclasses.com/business-intelligence-course
- Duration: Regular 9 Months · Fastrack 6 Months · Crash 4 Months
- Mode: Classroom and Live Online · Certificate · Live projects · Placement assistance
- Enquire: +91-7503301775 · nextgclasses@gmail.com

The Business Intelligence (BI) Course at Next G Classes is a comprehensive 9-month program designed to provide students with the necessary skills and knowledge to analyze data and generate actionable business insights. The course is divided into several modules, each focusing on critical aspects of business intelligence, from data management to visualization and reporting.

## Syllabus

**MIS**

- Module-1: Basic Concepts of Information System

- Module-2: Types of IS

- Module-3: Architecture & Design of IS

- Module-4: Decision Making Process

- Module-5: Introduction to Enterprise Management Technologies

- Module-6: Introduction to SAD

**Microsoft ExcelManage Workbook Options and Settings**

- Create Worksheets and Workbooks

- Navigate in Worksheets and Workbooks

- Format Worksheets and Workbooks

- Customize Options and Views for Worksheets and Workbooks

- Configure Worksheets and Workbooks for Distribution

**Apply Custom Data Formats and Layouts**

- Apply Custom Data Formats and Validation

- Apply Advanced Conditional Formatting and Filtering

- Create and Modify Custom Workbook Elements

**Create Tables**

- Create and Manage Tables

- Manage Table Styles and Options

- Filter and Sort a Table

**Perform Operations with Formulas and Functions**

- Summarize Data by using Functions

- Perform Conditional Operations by using Functions

- Format and Modify Text by using Functions

**Create Charts and Objects**

- Create Charts

- Format Charts

- Insert and Format Objects

**Manage Workbook Options and Settings**

- Manage Workbooks

- Manage Workbook Review Restrict editing

**Apply Custom Data Formats and Layouts**

- Apply Custom Data Formats and Validation

- Apply Advanced Conditional Formatting and Filtering

- Create and Modify Custom Workbook Elements

- Prepare a Workbook for Internationalization

**Create Advanced Formulas**

- Apply Functions in Formulas

- Look up data by using Functions

- Apply Advanced Date and Time Functions

- Perform Data Analysis and Business Intelligence

- Troubleshoot Formulas

- Define Named Ranges and Objects

**Create Advanced Charts and Tables**

- Create and Manage Pivot Tables

- Create and Manage Pivot Charts

**MY SQL
**

- OVERVIEW OF MySQL

- User Management

- Databases

- Table & Views

- MySQL Queries

- MySQL Indexes

- MySQL Clauses

- MySQL Flow Function

- MySQL Joins

- MySQL Keys

- Aggregate Function

- MySQL Mics

**POWER BI**

- Module 1: SQL SERVER INTRODUCTION

- Module 2: Introduction to Power BI

- Module 3: Basic Report Design

- Module 4: Visual Sync, Grouping

- Module 5: Hierarchies, Filters

- Module 6: Bookmarks, Azure, Modeling

- Module 7: Visualization Properties

- Module 8: Power Query Level 1

- Module 9: Power Query Level 2

- Module 10: Power Query Level 3

- Module 11: DAX Functions - Level 1

- Module 12: DAX Functions - Level 2

- Module 13: DAX Functions Level 3

- Module 14: Power BI Cloud - 1

- Module 15: Power BI Cloud - 2

- Module 16: Excel & RLS

- Module 17: Report Server, RDL

- Module 18: PowerApp

- Module 19: Power BI Service & Power BI Mobile

- Module 20: Power BI and Excel Together