Power BI Summer Internship/Training Program

August 2022

(Batches Start from 18th August 2022)

About The Program:

With the belief to build a healthy ecosystem as per the Industry Standards REGex Software brings an Industrial 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.

Timing

09:00 PM – 11:00 PM (IST)

Platform

Google Meet

Duration

4 – 6 Weeks

Participants

50 per Batch

What People Tell About Us

What you will Learn

SQL

Duration: 10 - 15 Hours

Power BI

Duration: 30 - 35 Hours

Study Material

  • E-Notes
  • Assignments & Poll test
  • 45+ 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: 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 In

Previous
Next

Course Content

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
    • 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 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

Extra Sessions

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

Fee Structure

Indian Fee

Price: ₹17999/- (Flat 75% off) => ₹4499/- 

International Fee

Price: $600 (Flat 75% off) => $150 

Cashback Policy

  • You will get your Unique Referral Code after successful paid registration.
  • You will get ₹450 Cashback directly in your account for each paid registration from your Unique Referral Code on 30th August, 2022(After Closing Registrations of this program) .
  • For Example:- If we received 10 paid registration from your Unique Referral Code then you will receive ₹450*10 = ₹4500 on 30th August, 2022.
For Frequent Course Updates and Information, Join our Telegram Group
For Webinar Videos and Demo Session, Join our Youtube Channel
Other Summer Internship/Training Program – August 2022

Enroll Now

(Batches Start from 18th August 2022)

*It will help us to reach more
*Seats can be filled or Price can be increased at any time. Refund policy is not available*