Power BI Program

(Batches Start from 3rd, 17th & 27th November 2023)

About The Program

With the belief to build a healthy ecosystem as per the Industry Standards REGex Software brings a Summer Training/Internship Program on “Power BI”. We organize Power BI Program for improving the knowledge and skills of the Students/Professionals, so that they can become specialized in the field of Power BI and get their Dream Job in Software Development Field in Big MNCs.

REGex Software Services’s “Power BI” program is a valuable resource for beginners and experts. This program will introduce you to SQL, Power BI etc. from Basics to Advance. If you want to become BI Analyst, REGex introduce this program for you.

Weekly Duration

20 Hours Per week

Location

Physical (Jaipur)
or 
Online (Google Meet)

Duration

75 or 90 Days

Participants

20 per Batch

Pause Your Program

You can pause your program if you have any Medical Emergency or if you have Exams and join again our new program within next 3 Months

What you will Learn

Python

Duration: 20 - 25 Hours

SQL

Duration: 10 - 15 Hours

Power BI

Duration: 30 - 35 Hours

Study Material

  • E-Notes
  • Assignments & Poll test
  • 70+ hours on demand Live Video Lectures
  • Access of Recordings & Study Material
  • Mentorship Support
  • Work on multiple data sets
  • Work on Live Projects

Output

  • Able to think out of the box
  • Become expert in multiple technology domains like: Python, SQL, MongoDB, Power BI etc.
  • Understand creating Data Insights by connecting data sets, transform & clean the data into data models and then create chars/graphs to provide visuals of the data
  • Build Charts/Graphs/Insights of data sets
  • Work on multiple data sets
  • Become Power BI Analyst / Power BI Developer after completion of this program

Why Choose Us

Live Sessions

Live Sessions by Expertise Trainers and Access of Recorded Session is also available.

Live Projects
Get a chance to work on Industry Oriented Projects to implement your learning.
24*7 Support
24*7 Mentorship Support available for all Students to clear all of your doubts.
Opportunities
REGex provides Internship / Job opportunities to the best Students in different Companies.

Placed Students//Partnership

What People Tell About Us

Placed Students

Course Content

  • Basics of Python 
  • OOPs Concepts
  • File & Exception Handling
  • Working with Pandas, Numpy & Matplotlib
    ■ Working with Missing Data
    ■ Data Grouping
    ■ Data Subsetting
    ■ Merging & Joining Data Frames
  • Importing Libraries & Datasets

Database

  • Functional Dependency
  • Closure of Attributes
  • Types of Keys: PrimaryKey CandidateKey & Super Key in DBMS
  • Normalization
  • Indexing
  • Transaction and Concurrency Control
  • Transaction in DBMS
  • ACID Propertise in DBMS
  • Joins in DBMS
  • Create & Alter Table
  • Constraints in SQL
  • Sql Queries & Sub Queries
  • SQL Stored Procedure
  • View, Cursor & Trigger in SQL
  • Common Table Expession
  • Replace Null and Coalesce Function
  • Running Total In SQL

Power BI

  • Introduction
  • Meet Microsoft Power BI Desktop
  • Interface & Workflow
  • Helpful Power BI Resources
  • New Power BI Ribbon
    • Introduction
    • Types of Data Connectors in Power BI Desktop
    • The Power BI Query Editor
    • Demo: Basic Table Transformations in Power BI
    • Power BI Demo:

 

  • Working with Text Tools
  • Numerical Values
  • Date & Time Tools
  • Creating a Rolling Calendar
  • Grouping & Aggregating Records
  • Pivoting & Unpivoting Data

 

    •  
    • Merging Queries in Power BI Desktop
    • Appending Queries in Power BI Desktop
    • Configuring Power BI Data Source Settings
    • Configuring Power BI Query Refresh Settings
    • Additional Data Types & Categories in Power BI
    • Defining Hierarchies in Power BI Desktop

 

  • Importing Models from Excel to Power BI

 

 

    • Introduction
    • What is a “Data Model”?
    • Principles of Database Normalization
    • Understanding Data Tables vs. Lookup Tables
    • Understanding Table Relationships vs. Merged Tables
    • Creating Table Relationships in Power BI Desktop
  • Snowflake Schemas in Power BI
  • Managing & Editing Table Relationships in Power BI Desktop
  • Managing Active vs. Inactive Relationships
  • Understanding Relationship Cardinality
  • Connecting Multiple Data Tables in Power BI Desktop
  • Understanding Filter Flow
  • Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
  • Hiding Fields from the Power BI Report View
  • New Power BI Desktop “Model” View
  • Introduction
  • Meet Microsoft Power BI Desktop
  • Interface & Workflow
  • Helpful Power BI Resources
  • New Power BI Ribbon
    • Introduction
    • Types of Data Connectors in Power BI Desktop
    • The Power BI Query Editor
    • Demo: Basic Table Transformations in Power BI
    • Power BI Demo:

 

  • Working with Text Tools
  • Numerical Values
  • Date & Time Tools
  • Creating a Rolling Calendar
  • Grouping & Aggregating Records
  • Pivoting & Unpivoting Data

 

    •  
    • Merging Queries in Power BI Desktop
    • Appending Queries in Power BI Desktop
    • Configuring Power BI Data Source Settings
    • Configuring Power BI Query Refresh Settings
    • Additional Data Types & Categories in Power BI
    • Defining Hierarchies in Power BI Desktop

 

  • Importing Models from Excel to Power BI

 

 

  • Introduction
  • Meet Data Analysis Expressions (DAX)
  • Intro to DAX Calculated Columns
  • Intro to DAX Measures
  • Adding Columns & DAX Measures in Power BI Desktop
  • Implicit vs. Explicit DAX Measures
  • Filter Context Examples in Power BI
  • Understanding DAX Syntax & Operators
  • Common DAX Function Categories
  • DAX Demo: 
    • Basic Date & Time Functions
    • Conditional & Logical Functions (IF/AND/OR)
    • Common Text Functions
    • Joining Data with RELATED
    • Basic Math & Stats Functions
    • COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
    • CALCULATE
    • CALCULATE & ALL
    • CALCULATE & FILTER
    • Iterator Functions (SUMX, RANKX)
    • Time Intelligence Formulas
  • FILTER Function
  • LOGICAL Functions
  • MATHEMATICAL Functions
  • STATISTICAL Functions
  • TEXT Functions
  • TIME INTELLEGENT Functions
  • Other Functions
  • Power Query Editor
  • Power BI Aggregation & Template
    • Introduction
    • Exploring the “Report” View in Power BI Desktop
    • Adding Simple Objects to the Power BI Report Canvas
    • Inserting Basic Charts & Visuals in Power BI
    • Conditional Formatting
    • Power BI Report Formatting Options
    • Power BI Report Filtering Options
    • Power BI Demo:
      • Exploring Data with Matrix Visuals
      • Filtering with Date Slicers

 

  • Showing Key metrics with Cards & KPI Visuals

 

    • Inserting Text Cards
    • Visualizing Geospatial Data with Maps
    • Visualizing Data with Treemaps
    • Showing Trends with Line & Area Charts
    • Adding Trend Lines & Forecasts 
    • Goal pacing with Gauge Chart
    • Adding Drillthrough Filters
  • Editing Power BI Report Interactions
  • Managing & Viewing Roles in Power BI Desktop

 Note: Content may Subject to Change by REGex as per Requirement

Extra Sessions

Additinal Session on GIT, Linux, Docker, AWS Basics, Jenkins and many more for all students.

Projects you will work on

Live Client Projects With Development Team Under The Guidance Of Mentor

Fee Structure

Offline Fee

Price: ₹59,999/- (Flat 75% off) => ₹14,999/-
=> ₹11,999/-
(Upto 50% off – Special Diwali offer)

Online Fee

Price: ₹59,999/- (Flat 75% off) => ₹14,999/-
=> ₹7,500/-
(Upto 50% off – Special Diwali offer)

International Fee

Price: $1200 (Flat 75% off) => $300
(Limited Period Special Offer)

Fee Can be Paid as No Cost EMI @2500/Month.

Cashback Policy

  • You will get your Unique Referral Code after successful paid registration.
  • You will get Upto ₹1000 Cashback directly in your account for each paid registration from your Unique Referral Code (After Closing Registrations of this program) .
  • For Example:- If we received 10 paid registration from your Unique Referral Code then you will receive Upto ₹1000*10 = ₹10,000.
For Frequent Course Updates and Information, Join our Telegram Group

Industrial Internship/Training Program – November 2023

For Webinar Videos and Demo Session, Join our Youtube Channel

Enroll Now

(Batches Start from 3rd, 17th & 27th November 2023)

*It will help us to reach more
*Extra off is applicable on 1 time payment only. Seats can be filled or Price can be increased at any time. Refund policy is not available*