Home Courses Offered JOB ORIENTED PROGRAMS Course Details
 

DATA ANALYST-POWER BI DEVELOPER

Pre-requisite: IT Professionals with SQL/Database Experience and Good Communication Skills

 

Job Prospects:  DATA ANALYST / BI ANALYST / POWER BI DEVELOPER 

 

COURSE-1: Data-Centric Roles and IT Projects Overview (1 Session)

 

MODULE-1: COURSE INTRODUCTION 

  • Business Metrics Overview (Revenue, Profitability, and Risk)
  • Data-Centric Job Roles and Required Skills
  • Distinguish Business Analyst / Business Data Analyst / Data Scientist Titles
  • Quiz

 

MODULE-2: IT PROJECTS AND SUPPORT LIFECYCLES OVERVIEW

  • IT and Business Projects
  • IT Applications Maintenance / Operations Support
  • Project Management Processes
  • Software Development Life Cycle (SDLC) 
  • Waterfall / Agile / Hybrid Methodologies
  • ITIL Service Lifecycle
  • Quiz

 

COURSE-2: Data Analytics Essentials (2 Sessions)

 

MODULE-1: TRANSACTIONAL AND ANALYTICAL SYSTEMS 

  • Transactional Systems Functions (Business Operations)
  • Analytical Systems Functions (Business Intelligence)
  • Analytical Systems: Data Warehouse, Data Mart, Data Lake, Big Data, etc.
  • Data Flow from Transactional Systems to Analytical Systems
  • Various Components Comparison
  • Quiz

 

MODULE-2: DATA KEY TERMINOLOGY 

  • Data Normalization vs De-Normalization
  • Primary and Foreign Key (Natural vs Surrogate Keys)
  • Data vs Meta Data
  • Data Modelling Concepts and Design Steps
  • Entity Relationship vs Dimensional Modeling
  • Quiz

 

MODULE-3: DATABASE MANAGEMENT SYSTEMS 

  • Relational Databases
  • Multi-Dimensional Databases
  • OLAP Cube Basics
  • Quiz

 

COURSE-3: Microsoft PowerBI - Data Analysis and Visualization  (10-12 Sessions)

 

MODULE-1: COURSE INTRODUCTION

  • What is Business Intelligence?
  • What is Microsoft Power BI?
  • Purpose of Training 
  • What to Expect?
  • Required Resources
  • Structure of Training
  • Introduction to Training Project
 
MODULE-2: INTRODUCING THE POWER BI TOOL
  • Meeting the Power BI tool: Desktop & Service
  • How and where to Download Power BI Desktop
  • Necessary Settings
  • Familiarizing with Power BI
  • Data Analysis Expressions (DAX)
  • Quick Quiz Time
  • Questionaire 
 
MODULE-3: POWER QUERY - CONNECTING TO DATA SOURCES
  • Different Types of Connections
  • Advantages / Disadvantages of each connection type
  • Frequently used data sources
 
MODULE-4: POWER QUERY - SHAPING DATA
  • Power Query Editor
  • Basic Transformations
  • Using Multiple tools available on Power Query
  • Quick introduction to Advanced Editor
  • Discussing Best Practices
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-5: POWER BI DESKTOP - MODELING DATA 
  • Introduction to Data Model
  • Describing Modeling Tab
  • Creating Model
  • Best Practices
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-6: POWER BI DESKTOP - DAX
  • What are Measures?
  • What are Calculated Columns?
  • Measure vs Calculated Columns
  • Working session Using DAX
  • Best Practices
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-7: POWER BI DESKTOP - CREATING VISUALIZATION
  • Introduction
  • Working session with Visuals
  • Using Filters Pane
  • Using Slicer
  • Interacting with Visuals
  • Using Drill through & Drill Down
  • Editing Interactions
  • Using "What-if" Parameters
  • Managing Roles in Power BI
  • Publishing Report to Power BI Service
  • Best Practices
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-8: INTRODUCING POWER BI SERVICE
  • BI as a Service
  • Setting Expectations
  • What is Power BI Service?
  • How Power BI Service look like
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-9: POWER BI SERVICE - DATA CONNECTION FROM SERVICE
  • Options for Data Connection
  • Loading Flat files to Power BI Service
  • Components of Power BI Service
  • Creating App Workspace 
  • Loading Power BI File to Service
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-10: POWER BI SERVICE - GATEWAYS & REFRESH IN SERVICE
  • What is a Data Gateway?
  • Different types of Gateways
  • Setting up Personal Gateway
  • Enabling Scheduled Refresh
  • What are Dataflows?
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-11: POWER BI SERVICE - REPORTS & DASHBOARDS
  • What are Reports & Dashboards
  • Pinning Report Visuals to Dashboard
  • Adding Slicers Visuals
  • Pinning Live Pages to Dashboards
  • Setting up alerts
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-12: POWER BI  SERVICE - SHARING ON SERVICE
  • Sharing on Power BI Service
  • Publishing the Report on the Web
  • User Roles & Permissions
  • Publishing Apps and using it
  • Quick Quiz Time
  • Questionaire 
  • Exercise
 
MODULE-13: SUMMING UP
  • Best Sites for Reference
  • Best YouTube Channel for Reference
 
MODULE-14: ADVANCED TOPICS
  • Working with M Language
  • Advanced DAX Functions
  • Calculated Tables
  • Handling Many-to-Many Relationships
  • Best Practices in Power Query
 

COURSE-4: SQL Overview - Database Query (4 Sessions) OPTIONAL - NOT FOR ALL BATCHES

 

MODULE-1: COURSE INTRODUCTION

  • Introduction to Database
  • What is Relation Database (RDBMS)?
  • How is a Database different from Excel?
  • Popular Relational and New Emerging Databases
  • Working with User-Friendly Tools (TOAD / SQL Plus /DB Visualizer etc.)
  • Roles and Responsibilities (DBA, Developer, End User)
  • What is SQL?
  • Quiz

 

MODULE-2: SQL INTRODUCTION

  • What Are Database Objects (Tables, Views, etc..)?
  • DDL – Data Definition Language (Create/Alter/Drop/Rename)
  • DML – Data Manipulation Language (Insert/Update/Delete)
  • DQL– Data Query Language (Select)
  • Understanding SQL
  • Quiz
  • Exercise

 

MODULE-3: SQL DATATYPES AND OPERATORS

  • Data Types (Char and Varchar2, Numeric, Date, etc.)
  • Operators (AND, OR, IN, LIKE, ORDER BY, etc.)
  • SELECT Statements to Query Single Table
  • Quiz
  • Exercise

 

MODULE-4: SQL SELECT STATEMENTS

  • SELECT Statement to Query Multiple Tables
  • JOIN Statement
  • Quiz
  • Exercise

 

COURSE-5: Python Overview (4 Sessions) OPTIONAL - NOT FOR ALL BATCHES

 

MODULE-1: INTRODUCTION TO PROGRAMMING & DATA ANALYTICS

  • Introduction to Software Programming
    • Hardware vs Software
    • Computer Programming Languages– High and Low Level
    • Proprietary Software vs Open Source
    • Compiled vs Interpreted Languages
    • Which category does Python fall under?
  • Python Overview
    • Introduction and History of Python
    • Library & Different Python Libraries 
    • Various Python Distribution Vendors & Text Editors
    • Demo

 

MODULE-2: INSTALLATION AND GETTING STARTED

  • Setting up Programming Environment
    • Installing Python (Anaconda 3) for Windows and OS X (Mac) Operating Systems
    • Introduction to Python IDE - Jupyter Notebook
  • Running First Python Program
    • Syntax and Symantec Errors
    • Python File Extensions
    • Writing your first Python Program
    • Saving and Opening Programs
    • Running Python Program
    • Exercise

 

MODULE-3: MATH AND VARIABLES

  • Operators and Order of Operations
  • Introduction to Variables
  • Naming and Using Variables
  • Using Comments
  • Exercise

 

MODULE-4: DATA TYPES

  • Introduction to Data Types
  • Strings and Numbers
  • Expressions
  • Creating and Working with Strings
  • Concatenating Strings
  • Converting Strings to Numbers
  • Accepting Input from Users
  • Programming Best Practices
  • Exercise

 

MODULE-5: CONDITIONAL STATEMENTS

  • IF Statements
  • IF-ELSE Statements
  • IF and ELIF Statements
  • Multiple IF Conditions
  • CASE Statement
  • Exercise

 

SELF-STUDY

  • @BI_Courses YouTube Videos
  • Microsoft Office (Excel, Word, and PowerPoint)
  • Database and SQL Queries
  • PowerBI Practice
  • Python Coding Practice
  • Tableau BI Overview

 

  • Live Training with Demos
  • Practical Assignments & Assessments
  • Real-Time Scenarios
  • Communication Skills Guidance*
  • Effective Resume Building*
  • Interview Preparation / Mock Interview*
  • Placement Assistance*

 

Classes: ~25-30 Hours

Assignments: ~40 hours

Duration: ~8-9 Weeks 
 
Course Fee (Live Sessions): $500 (< $15/Hour)
 
 
 
**As per the tutor's discretion, some of the provided course content may be altered/omitted to suit the class needs**
 
**Products and Logos Mentioned are Trademarks of the Respective Companies**
 
**Provided Individual Course Fee is not applicable for Corporate Customers**
 
*Selected Individuals Only*
 
 






Please contact us for the course details including the currently offered courses, course content, price and the schedule.

Free Demo

If you are interested to upgrade your skill-set, please consider attending one of our Real Classes as a free demo to evaluate the class quality and then decide your course of action.