• +91 7021789240
  • info@techlearniversity.com
  • 170 1/1, Vijay Nagar, Mumbai, India
Logo

Business Intelligence Developer Professional Certification Program

Program Name - Business Intelligence Developer Professional Certification Program

The only professional certification program you need to become Business Intelligence Developer.

Rs. 51,313/- Only

Course Overview

This comprehensive course covers Tableau and Power BI, providing a deep dive into data visualization, preparation, and business intelligence. Starting with Tableau Prep and Desktop, you’ll learn to connect datasets, create visualizations, and build interactive dashboards. Advanced topics include DAX functions in Power BI, SQL queries, and data warehousing concepts. You’ll master filters, groups, sets, and parameters, along with advanced charting and formatting techniques. The course also includes performance monitoring, data modeling, and security implementation. Real-time projects and a professional internship program offer hands-on experience, preparing you for job interviews, freelancing opportunities, and career advancement in the data analytics field.

What You'll Learn?

In this course, you’ll master data visualization with Tableau and Power BI, learn advanced DAX functions, SQL queries, data modeling, and warehousing. You’ll also gain hands-on experience through real-time projects and professional internships, preparing you for career advancement.

Internship Program:

In addition to the course, you will participate in a 6-month internship involving 12 live projects. Upon successful completion, you will receive an Internship Certificate.

Letter of Recommendation:

Upon successfully completing the program and internship, you will also receive a Letter of Recommendation (LOR).

Duration:

90 Hours (15 Weeks) + 6 Months (Internship Program)

Requirements:

Microsoft Power BI, Tableau Desktop, Tableau Prep, Tableau Online, Microsoft SQL Management Studio

Pre-requisite:

Basic Excel Knowledge

Batch Details

Batch Start Date

Batch Timing

Batch End Date

Batch Days

Enroll Now

Curriculum

1. What is Tableau?
2. Why Tableau?
3. Tableau Products
4. Data Visualization
5. Business Intelligence tools
6. Tableau Architecture
7. Tableau Server Architecture
8. VizQL
9. Introduction to Tableau Prep
10. Tableau Prep Builder User Interface
11. Data Preparation techniques using Tableau Prep Builder tool

1. Introduction to Tableau Desktop
2. Start Page
3. Connections and Sheets

1. Connect to an Excel Data set
2. Preliminary data checks
3. Manage Data Properties
4. Rename a data field
5. Assign an alias to a data value
6. Assign a geographic role to a data field
7. Change data type for a data field (number, date, string, Boolean, etc.)
8. Change default properties for a data field (number format, aggregation, Color, date format,
etc.)
9. Explain difference between Live vs Extract
10. Tableau File types

1. Explain role of Worksheet, Dashboard, Story
2. Dimension and Measures Pane
3. Column and Row Shelves
4. Auto Generated Fields in Tableau
5. Discrete vs Continuous Fields
6. Show Me Feature

1. Text Table
2. Highlighter Table
3. Bar chart
4. Line chart
5. Bubble Chart
6. Stacked Chart
7. Side by Side Chart
8. Filled Maps
9. Symbol Maps
10. Bullet chart
11. Tree Map
12. Heat Map
13. Mark Cards
14. Histogram
15. Butterfly Chart
16. Waterfall Chart
17. 10 Advanced Charts

1. Data source Filters
2. Extract Filters
3. Dimension Filters
4. Measure Filters
5. Context Filters
6. Order of operations
7. Add Date filter to view
8. Customizing Show filters

1. Groups
2. Sets
3. Combined Sets
4. Parameters

1. Sorting
2. Headers
3. Palettes
4. Font and Alignment
5. Marks cards
6. Add Totals, Sub Totals and Grand Totals to Report

1. Reference line
2. Reference Band
3. Reference Distribution
4. Trend Line
5. Forecasting
6. Table Calculations

1. Date Expressions
2. String Expressions
3. Numeric Expressions
4. Logical Expressions

1. FIXED
2. EXCLUDE
3. INCLUDE

1. Joining multiple tables
2. Union Data
3. Blend
4. Relationship

1. Understanding Dashboard Layout
2. Blank Container
3. Add Headers and Borders
4. Horizontal and Vertical Containers
5. Text
6. Image
7. Web Page
8. Navigation
9. Download

1. Dashboards for Phone, Tablet
2. Dashboard Actions
3. Filters
4. Story

1. Publishing Workbooks to Tableau Online
2. Interacting with Content on Tableau Online
3. Data Management through Tableau Catalog
4. AI-Powered features in Tableau Online (Ask Data and Explain Data)
5. Understand Scheduling
6. Managing Permissions on Tableau Online
7. Data Security with Filters in Tableau Online

1. Real time Projects
2. How to analyze the data and get insight from it?
3. How to approach any business scenario/problem?
4. How to solve any business scenario/problem?
5. How to create a story on any business scenario/problem?

1. How to track performance of a dashboard?
2. How to understand the output of performance tracker?
3. Best practices to improve dashboard performance
4. Other tips related to performance monitoring and improvement

1. Introduction to Databases
2. Understanding SQL and Its Importance
3. Basic SQL Syntax
4. SELECT Statement: Retrieving Data
5. WHERE Clause: Filtering Data

1. Sorting Data: ORDER BY Clause
2. Filtering Data: WHERE Clause (continued)
3. Aggregating Data: GROUP BY Clause
4. Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN
5. Subqueries and Derived Tables

1. SQL Functions: COUNT, SUM, AVG, MAX, MIN
2. Modifying Data: INSERT, UPDATE, DELETE
3. Data Integrity: Constraints
4. Windows functions (rank, dense rank, etc.)

1. What is Data Warehousing?
2. Data Warehousing Architecture
3. Star Schema and Snowflake Schema
4. ETL (Extract, Transform, Load) Process
5. OLTP vs OLAP

1. Identifying Data Sources
2. Data Modeling: Fact Tables and Dimension Tables
3. Design Best Practices
4. Data Warehouse Tools and Platforms
5. Performance Tuning and Optimization
6. Reporting and Dashboards

1. Introduction to Business Intelligence
2. Self-Service Business Intelligence (SSBI)
3. Introduction to Power BI
4. The Flow of Work in Power BI
5. Basic Components of Power BI
6. Introduction to Building Blocks of Power BI
7. Data model and importance of Data Modelling

1. Power BI desktop overview
2. Data Sources in Power BI Desktop
3. Data connectivity modes
4. Power query editor overview
5. Data transformation in power query editor
6. Data types in Power BI
7. Model optimization in query editor

1. Overview of modelling and schemas
2. Star Schema, Snowflake Schemas
3. Data Cardinality (Relationships) types & Directions of Cardinality
4. Cross filtering and connection type (Active/Inactive)
5. Managing & Editing Data Relationships

1. Introduction to DAX
2. Data Types in DAX
3. Filter Context vs Row Context
4. Calculated columns, measures and quick measures
5. Aggregation, Date & Time, Filter, Logical and Information Functions
6. DAX Syntax, Functions & Operators

1. Introduction to Visuals in Power BI
2. Visualization Charts in Power BI
3. Visual formatting and analytical features
4. Grouping, selection pane, bookmarks, buttons
5. Tooltip, drill down and drill through functionality
6. Matrixes and Tables
7. Slicers and Map Visualizations
8. Gauges Chart, KPI and Single Number Cards
9. Shapes, Text Boxes, and Images
10. Usage of visuals in different Scenarios

1. Introduction to Dashboards
2. Dashboard vs Reports
3. Creating Dashboards
4. Parameters in Power BI
5. Row Level security (RLS) Implementation
6. Power BI Gateway Connection

1. Introduction to workspaces
2. Publishing datasets or reports in Power BI Service
3. Sharing workspace access with Users
4. Scheduling refresh of datasets
5. Exporting data from dashboards in PPT or PDF or Excel

1. Interview questions with PL-300 Questions
2. Interview tips
3. How to crack job interview
4. How to register for freelancing work
5. How to get freelance work

1. How to create Tableau Public profile and its importance?
2. Mock-up
3. Tips and tricks in Tableau
4. Interview questions
5. Mock interviews
6. Interview tips
7. How to crack job interview
8. How to register for freelancing work
9. How to get freelance work

6 Live Professional Projects

6 Live Professional Projects

Download Curriculum

FAQ

Since our inception in 2021, Tech Learniversity has been dedicated to mastering the art of online education. Our unwavering commitment to delivering quality education, exceptional services, and unparalleled customer support has fostered a loyal community that continues to grow. We relentlessly pursue improvement and expansion to serve learners worldwide. Our graduates, now employed by multinational corporations, stand testament to the transformative impact of our training programs.

Tech Learniversity stands as a premier e-learning platform, offering live, interactive online training across a wide range of subjects, including Data Science, Cybersecurity, Business Intelligence, and more. Our affordable and accessible learning solutions serve a global audience, creating a vast community of learners from the US, India, the UK, Canada, and beyond.

Below are the services offered by Tech Learniversity.

1. Online Training Courses
2. Corporate Training
3. Online Institute Training
4. Online College Training
5. Online School Training
6. Online Customized 1 to 1 Training Courses
7. Online Customized Group Training Courses
8. Online Professional Internship Program
9. Online Interview Preparation Training
10.Online Customized Project Preparation
Below are benefits to be considered before choosing us ahead of others.

Why Choose Us

  1. Live Instructor Led Training
    2.
Class will be live Instructor led training and the trainers are experienced software working professionals in MNC’s. They face challenges every day at work and they know how to tackle them which they will teach it to the students. Trainers will teach them theory, concepts along with giving them basic to advanced level examples which will be useful for the students when they attend any interview or while working in any company.

  1. In-depth Industry Ready Training
    2.
Our trainers are experienced software working professionals in MNC’s so the training will be in-depth which will make the students Industry ready and the students can work independently when they join any company.

  1. Live Projects
 Students will be provided 3 to 8 live projects in a particular course so that they get enough practice during and after completion of the course. This will give them confidence to work with any company as the level of work in any company will be complex.

  1. Watch recorded Video for Online and Offline Viewing
 Students will be able to view the recorded class video on Tech Learniversity app online and offline by downloading the video in mobile. They can also watch the video in desktop and laptop by using our web version.

  1. Internship Program
 Students will be getting Internship Certificate after completion of Internship Program which is of 3 months. We provide Internship program in almost each course so that they will find it easy to join and work with any company after completion of Internship Program. If any student has already done any course from others but only want to do Internship Program from us, they can also join our Internship Program of 3 months.

  1. Letter of Recommendation (LOR)
 After successful completion of the Course and Internship Program they will get Letter of Recommendation (LOR) if they perform well as per instructions provided to them by the respective trainers.

  1. Real time working experience
 We have designed all our courses and Internship Program in such a way that the students get real time working experience. This will benefit students to work independently when they join any company.

  1. Job Interview Preparation
 There will be a separate session for Job Interview preparation where our trainers will guide the students about how to crack any interview, help in resume preparation and also provide tips and tricks for interview. We will also provide resources which will help in preparation of the Interview.

  1. Customized 1 to 1 Training
 We also provide customize training based on the student requirements. We conduct free demo to student so that student get a chance to interact with trainer before they take the 1 to 1 class.

  1. Customized Group Training
 We also provide customize training to small groups based on student’s requirements. We conduct free demo to students so that students get a chance to interact with trainer before they take the small group class.

  1. Referral Bonus
 Students are also eligible for referral bonus once they purchase a course from us.

  1. Freelance Work
 We will also provide tips on how to register for freelance work so that they can work as a full-time freelancer or part time freelancer to earn extra income during their free time.

  1. Community for Discussion
 We will have experts and students who can discuss their queries, doubts and also can share their thoughts, solutions with each other.

  1. Superfast Support
 We will provide superfast support to any queries or concern so that our students are satisfied with our services.

All the Tech Learniversity course available on our website are live Instructor led training.

Yes, we do have app available on Play Store & App Store.

Play Store: Tech Learniversity link: https://play.google.com/store/apps/details?id=co.lily.zustc
IOS Store: My Institute link: https://apps.apple.com/in/app/my-institute/id1472483563

How to Login to IOS App (My Institute)

  1. Download the My Institute app
  2. Enter the Org code: ZUSTC

We do not provide EMI facility but you can convert through Credit Card or any other method as per availability.

We will provide placement assistance after the completion of the course in coming months.

Classes will be conducted on Zoom app and link will be shared via e-mail. We will be sending you the instructions on how to attend the live class in your mobile, laptop or desktop once you enroll in any of our courses.

Yes, you can watch recordings in the mobile app or by visiting our web version with your login credentials. You will find the recording in your purchased course section after you login.  We will be sending you the instructions on how to view the recorded live class in your mobile, tablet, laptop or desktop.

Yes, you will get Completion Certification after completion of the course.

Tech Learniversity is ISO Certified (ISO 9001:2015) firm which has good value in corporate world. Certificate Number is 305022111717Q.

CONTACT US

Scroll to Top