Linkedin Instagram Telegram Facebook

Power BI Program

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

45 or 75 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 People Tell About Us

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

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.

Our Students Placed // Partnership

Previous
Next

Placed Students

Gunjan Saini National Instruments
Gunjan Saini
National Instruments
Prem Wipro & IBM
Prem
Wipro & IBM
Purnima ponrajkumar Indium software
Purnima ponrajkumar
Indium software
sonal Wipro
sonal
Wipro
Mohammad Atash Shaikh Wipro
Mohammad Atash Shaikh
Wipro
Ayush Kumar srivastava Sopra
Ayush Kumar srivastava
Sopra
Sourav Dash Tek System
Sourav Dash
Tek System
Simran Khatri Techmatrix jaipur
Simran Khatri
Techmatrix jaipur
Madhav Sharma Cognizant
Madhav Sharma
Cognizant
Rajkishor. P. Game Redington India Ltd
Rajkishor. P. Game
Redington India Ltd
Bhuvan Nucleus software
Bhuvan
Nucleus software
Akshay Kachave Talent Sikha
Akshay Kachave
Talent Sikha
Vasavi Uppala NCR coperation
Vasavi Uppala
NCR coperation
Ashish Chauhan wipro
Ashish Chauhan
wipro
Pratik Choubey TCS
Pratik Choubey
TCS
Debarya Pal Accenture
Debarya Pal
Accenture
Vritika Vijay Kamra Larsen and toubro infotech
Vritika Vijay Kamra
Larsen and toubro infotech
Mihir Vatsa Infosys
Mihir Vatsa
Infosys
Divyansh Singh Sengar Infosys
Divyansh Singh Sengar
Infosys
Harsha Kumari Bank Of America
Harsha Kumari
Bank Of America
Vatan Gupta Accenture
Vatan Gupta
Accenture
Fardeen Khan Deloitte us
Fardeen Khan
Deloitte us
Divyanshi jain Deloitte
Divyanshi jain
Deloitte
Hritick goyal Ranjio
Hritick goyal
Ranjio
Sumodh c Sabu TCS
Sumodh c Sabu
TCS
Swati Accenture
Swati
Accenture
Nishant Kumar cognizant
Nishant Kumar
cognizant
Saquib Mansuri Circulants
Saquib Mansuri
Circulants
Dhanisha sharma TCS
Dhanisha sharma
TCS
Aditya Prasad Capgemini
Aditya Prasad
Capgemini
Sathvika Chekuri Barclays
Sathvika Chekuri
Barclays
Priyanshu Lasod Barclays Arcgate
Priyanshu Lasod
Barclays Arcgate
Jaya Mendhe Accenture
Jaya Mendhe
Accenture
Dipali Jp Morgan Chase & Co.
Dipali
Jp Morgan Chase & Co.
Meenal Hewlett-Packard
Meenal
Hewlett-Packard
Riya Khanna HSBC
Riya Khanna
HSBC
Muskan Hewlett-Packard
Muskan
Hewlett-Packard
Praveen Jangid Celebal Tech
Praveen Jangid
Celebal Tech
Previous
Next

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

Projects you will work on

Live Client Projects With Development Team Under The Guidance Of Mentor
Project Use Cases

Extra Sessions

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

Fee Structure

Indian Fee (Physical)

Price: ₹59,999/- (Flat 75% off) => ₹14,999/-  
₹9,999/- 
(Limited Period Summer Special Offer)

Indian Fee (Online)

Price: ₹59,999/- (Flat 75% off) => ₹14,999/-  
₹9,999/- => ₹6,000/- 
(Limited Period Summer Special Offer)

International Fee

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

Fee can be paid in 2 Installments of 6k & 5k for Physical Students.

Cashback Policy

  • You will get your Unique Referral Code after successful paid registration.
  • You will get ₹250 Cashback directly in your account for each paid registration from your Unique Referral Code on 30th April, 2022(After Closing Registrations of this program) .
  • For Example:- If we received 10 paid registration from your Unique Referral Code then you will receive ₹250*10 = ₹2500 on 30th April, 2022.

Get In Touch With Us

If you’re interested in our Training Services, please contact us today to schedule a consultation.
Contact US