Excelgoodies logo +91 9176633248
For IT & BI Professionals.

Data Engineering &
Full Stack Business Intelligence (On-Prem)

ETL with SSIS | SSAS

  • Both Online & Classroom | 1.2 Years (84 Sessions, 2 hrs each)
  • 50+ Projects & 14-Certificates

(1.5K+ Professionals enrolled)

Prove you're human: Type the code shown.

=
Excelgoodies

Program Overview

Training Schedule

Tuesday, 11 Apr

View Schedule

1.2 Years | 180 Hours

84 Sessions, 2 Hrs Each

Online & Classroom, Instructor-Led

Certificates

14 Specialist Certificates

View Certificate Details

Course Fee

₹10,000

Check what’s included?

Data Engineering & BI (On-Prem)

floating_menu floating_menu floating_menu

Batch starts on

th

Master On-Prem Tools

Data Engineering + Power BI + SQL + Automation

A Gateway for IT Professionals to Become BI & Reporting Experts

IT roles are evolving—BI and automation are now essential skills. This course helps IT professionals transition into BI reporting & automation while enabling BI professionals to expand into data engineering & IT infrastructure. Learn to build SQL-driven data pipelines, optimize BI systems, and automate reporting with SSIS, Power BI, and VBA—delivering real-time, enterprise-ready insights.

Tools You'll Learn

Data Analysis Tool

Microsoft Excel

Visualization Tool

Power BI

Data Modeling Tools

Power Pivot, DAX

Data Transformation Tools

Power Query 

Data Warehousing & Querying

MS-SQL

Automation & Scripting Tools

VBA

Scripting Language

Python

Data Engineering Tools

SSIS, SSAS

Application Development Tools

Power Apps

Automation Tool

Power Automate

Portal & Web Tools

Power Pages

Data Platform

Microsoft Dataverse

AI for Power BI

Copilot + Claude AI

In just 1.2 Years, you'll be able to:

Build Scalable Data Pipelines to automate and streamline data flows.

Optimize BI Infrastructure and ensure seamless integration of data systems.

Automate End-to-End Reporting Workflows to save time and improve data efficiency.

Integrate, Transform, and Visualize Data for actionable business insights.

Create Self-Sustaining BI Systems that automate reporting and support decision-making.

Master SQL, SSIS, and Power BI for dynamic data analysis and reporting.

In just 1.2 Years, you'll be able to:

Build Scalable Data Pipelines to automate and streamline data flows.

Optimize BI Infrastructure and ensure seamless integration of data systems.

Automate End-to-End Reporting Workflows to save time and improve data efficiency.

Integrate, Transform, and Visualize Data for actionable business insights.

Create Self-Sustaining BI Systems that automate reporting and support decision-making.

Master SQL, SSIS, and Power BI for dynamic data analysis and reporting.

A snapshot of what you'll be learning in 8-weeks.

Course Syllabus Overview

Quick Excel brush-up

Objective: To prepare a quick POC with small data and get the concurrence on the output before investing time on huge datasets.

Overview

  • Core Fundamentals Of Spreadsheets
  • How System Interprets Your Data
  • Crucial Formatting Concepts
  • Understanding Core Formula Fundamentals & Advanced Referencing Concepts
  • 60+ Advanced Excel Functions
  • Cleansing & Transforming Data
  • Data Summarization
  • Conditional Summarization
  • Working With Multiple Datasets
  • Working With Pivot Tables Including Advanced Pivot Tables Options
  • 15+ Charts - When To Use What Chart?
  • Develop Data Models to Simulate Complex Business Scenarios for What IF Analysis

Modeling with Power Pivot

Objective: To do faster queries, simpler DAX code and enjoy easier maintenance.

Introduction To PowerPivot

  • Limitation Of Excel Functions
  • Limitation Of Excel Pivot table
  • Why Powerpivot?
  • Powerpivot Features – Overview

Powerpivot Environment

  • Opening Powerpivot Environment
  • Understanding External Data Section
  • Understanding Formatting
  • Powerpivot Views
  • Understanding Measures

Loading Data Into PowerPivot

Calculated Columns

  • Calculated Columns
  • Entering Formulas
  • Using Autocomplete Feature
  • Renaming Columns
  • Understanding Tables

Creating Measures

  • Creating Simple DAX Measures
  • Explicit Measure Vs Implicit Measure
  • Referencing Measures In Other Measures
  • Formatting Measures
  • Manage Data Relationships
  • Working With Multiple Tables
  • Disconnected Tables
  • Creating Custom Calendars
  • Using Advanced Filter()
  • Advanced Calculated Columns
  • Understanding Relationship Concept
  • Join Tables
  • Left Join Tables
  • Right Join Tables

Data Visualization Using

  • Charts, Score Cards And Dashboards
  • Slicers
  • Map Visualizations
  • Data Binding And Formatting

Creating Advanced Dashboards With PowerPivot

Creating Free Form Reports With PowerPivot & Excel

Develop Simple Models And Forecast Data Using PowerPivot & Excel

Modern Functions (New)

Duration – 2 Hours

Dynamic Array Functions

  • FILTER
  • SORT
  • SORTBY
  • UNIQUE
  • SEQUENCE
  • RANDARRAY

Lookup & Reference Functions

  • XLOOKUP
  • XMATCH

Text Functions

  • TEXTSPLIT
  • TEXTJOIN
  • TEXTBEFORE
  • TEXTAFTER
  • CONCAT

Logical Functions

  • IFS
  • SWITCH
  • LET
  • LAMBDA

Math & Trigonometry Functions

  • MAP
  • REDUCE
  • SCAN

Array Manipulation Functions

  • VSTACK
  • HSTACK
  • CHOOSECOLS
  • CHOSEROWS
  • WRAPROWS / WRAPCOLS

Power BI

Objective: Getting started with Power BI and leverage it’s full potential to develop compelling visualizations.

Building Blocks of Power BI

  • Visualizations
  • Datasets
  • Reports
  • Dashboards
  • Tiles

Building Your First Power BI Report

  • Connect to Data Sources in Power BI Desktop
  • Clean and Transform Your Data With the Query Editor
  • Create a report in Power BI Desktop
  • Publish the report in the Power BI service

Data Modeling with Power BI

  • Fundamentals of Modeling
  • How to Manage Your Data Relationships
  • Create Calculated Columns
  • Optimizing Data Models for Better Visuals
  • Create measures and work with time-based functions
  • Create Calculated Tables
  • Explore Time-Based Data

Visualizations

  • Create and Customize Simple Visualizations

Building compelling data visualizations

  • Identify metrics and pair them with appropriate data visuals
  • Using slicers
  • Creating Map Visualizations
  • Creating Tables and Matrixes
  • Creating Scatter Charts
  • Creating Waterfall and Funnel Charts
  • Using Gauges and Single Number Cards
  • Charting Options including Formatting with Colors, Shapes, Text Boxes, Images, etc.

Designing User-friendly reports

  • Customize themes
  • Create versatile layouts for your reports
  • Design principles to reduce noise and highlight data stories

Creating interactive reports for data exploration

  • Filtering & drilling for insights
  • Difference between filters & slicers
  • Filter pane for reporting needs

Exploring Data

  • Use Quick Insights in the Power BI service
  • Create and Configure A Dashboard
  • Share Dashboards with your organization
  • Display Visuals and Tiles Full-Screen 

Power Query

Objective: To learn different methods to Transform Data before uploading it to the SQL Database.

Overview

  • Introduction
  • Loading & Refresh
  • Combine data from multiple data sources

Data Transformation

  • Editing Queries Created with Power Query
  • Editing Column Headers in Power Query
  • Splitting Column Data with Power Query
  • Sorting Data
  • Multi-Level Sorting
  • Filtering Data
  • Aggregate data from a column
  • Insert a custom column into a table
  • Merge columns
  • Remove columns
  • Remove rows with errors
  • Promote a row to column headers
  • Transforming Text Values
  • Replacing Data
  • Using the Fill command
  • Pivot and Unpivot Column
  • Transpose Query Data
  • Pivot Column Command in Action
  • Unpivot Columns Command
  • Grouping Data
  • Create a Duplicate Query
  • Group and Summarize Data
  • Advanced Data Grouping
  • Working with multiple sources in Power Query
  • Multiple Excel Tables
  • Expand a column containing an associated table
  • Understanding Table Relationships
  • Merging Queries

Loading Power Query Data to Destinations

  • Familiarity with the Load & Refresh Settings
  • Loading it to Workbook
  • Loading it to Data Model

DAX Functions

Objective: To add analytical power to your Power BI model that is not available in the data as-is, using DAX.

Overview

  • What is DAX?
  • Data Types
  • Table-Valued Functions
  • Building a Calendar Table
  • Date and Time Functions
  • Filter Functions
  • Information Functions
  • Logical Functions
  • Mathematical and Trigonometric Functions
  • Statistical Functions
  • Text Functions
  • Time Intelligence Functions

Creating Advanced Dax Measures With Advanced Dax Functions

  • Calculate()
  • All()
  • Filter()
  • IF()
  • Switch()
  • SumX()

Evaluation Context

  • Filter Context
  • Row Context
  • Using RELATED in a Row Context
  • Filters and Relationships
  • USERELATIONSHIP

Hierarchies in DAX

Querying with DAX

Relationships

  • One-to-Many Relationships
  • Many-to-Many Relationships

T-SQL

Objective: To query MS-SQL Database (es) by writing accurate, effective, and robust T-SQL code - the right way.

Introduction to MS-SQL

  • Creating a Database
  • Understanding Tables and Creating Tables
  • Inserting, Updating and Deleting Data
  • Querying Data
  • Filtering Data
  • Grouping Data
  • Ordering Data
  • Column Aliases
  • Table Aliases

DDL INSIGHTS

  • CREATE TABLE
  • Dropping Objects
  • CREATE INDEX
  • TEMPORARY OBJECTS
  • Object Naming and Dependencies

SELECT STATEMENTS

  • Simple SELECTs
  • Calculated and Derived Fields
  • SELECT TOP / BOTTOM Records
  • Derived Tables
  • Joins
  • Predicates
  • Subqueries
  • Aggregate Functions
  • GROUP BY and HAVING
  • UNION
  • ORDER BY

Advanced DAX Expressions

Objective: Leverage DAX potential to perform advanced data analytics

Advanced Table Manipulation Functions

  • ADDCOLUMNS
  • CROSSJOIN
  • DATATABLE
  • DISTINCT column
  • EXCEPT
  • FILTERS
  • GENERATESERIES
  • INTERSECT
  • NATURALINNERJOIN
  • NATURALLEFTOUTERJOIN
  • ROW
  • SELECTCOLUMNS
  • SUMMARIZE
  • SUMMARIZECOLUMNS
  • Constructor
  • TOPN
  • UNION
  • VALUES

Advanced Filter Functions

  • ADDMISSINGITEMS
  • ALL
  • ALLCROSSFILTERED
  • ALLEXCEPT
  • ALLSELECTED
  • CALCULATE
  • DISTINCT
  • FILTER
  • FILTERS
  • RELATED
  • REMOVEFILTERS
  • SELECTEDVALUE
  • USERELATIONSHIP
  • VALUES

ADVANCED USAGE OF

  • CALCULATE
  • SUMX
  • COUNTX
  • AVERAGEX
  • MAXX
  • MINXX
  • DATATABLE

Power BI Administration

Objective: Get hands-on experience with advanced administration settings, permissions, Data refresh times etc.

Overview

  • Publishing Power BI Reports
  • Creating & Managing Workspaces and Its Access
  • Creating & Managing Dashboard and Its Access
  • Installing & Configuring Data gateway
  • Scheduling and configuring data refresh
  • Managing & Reusing Datasets
  • Scheduling Report Alerts
  • Setting up Row Level Permissions
  • Managing Users & Audit Log
  • Custom Branding Power BI For your Organization
  • Adding Custom Visuals for your Organization

Architect Power BI Solution

Objective: To put our entire learning to use and arrive at the best possible BI solution -using the right combination of available technologies.

Overview

  • Case Study 1
  • Case Study 2
  • Case Study 3

AI-Powered BI with Microsoft Copilot

AI-Powered BI with Microsoft Copilot
  • Introduction to Copilot in Power BI
  • Generating DAX measures using natural language prompts
  • Building report pages with Copilot (conversational report creation)
  • AI-generated narrative summaries for dashboards
  • Preparing your semantic model for Copilot (data prep for AI)
  • Smart Narratives and Q&A visuals
  • Copilot licensing and organizational requirements

Supercharging BI with Claude AI

Supercharging BI with Claude AI
  • Claude for data analysis: uploading, cleaning, and exploring datasets
  • Writing and debugging DAX with Claude
  • Generating SQL queries from natural language using Claude
  • Interpreting analytical results and statistical outputs with Claude
  • Creating executive-ready data narratives and summaries
  • Claude vs. Copilot: when to use which tool
  • Building an AI-augmented BI workflow (bringing it all together)

VBA Macro Automation

Objective: To collect data from multiple ad-hoc sources and prepare it for loading it to SQL Database for BI Reporting purpose.

Overview

  • Core Fundamentals of VBA
  • Understanding VBA Environment
  • Writing simple VBA Codes
  • Concept of Variables & Data Types
  • Testing & Debugging Code
  • Understanding Fundamental Coding Blocks
  • IF Block
  • Select Case
  • And / Or Conditions
  • Understanding Fundamentals of Looping
  • For Loop
  • Do While
  • Understanding Object Based Programming
  • Advanced Excel Automations
  • Word Automation
  • Outlook Automation
  • Working with Database
  • Working with Web Browsers - Web Scrapping
  • Creating User Interfaces with VB Forms
  • Handling Run Time Errors & Securing Code

VBA Automation using Excel

VBA Programming Fundamentals

  • Understanding Object Based Programming
  • Understanding Objects
  • Working with Collection Objects
  • Working with Methods
  • Read & Write Properties

Programming & Automating with Excel Objects

  • Excel Object
  • Workbook Object
  • Worksheet Object
  • Cell Objects
  • WorksheetFunction Object
  • PivotTables Object
  • Chart Objects
  • Other Misc Objects

Code Automation Concepts via Excel Automation

  • Calling Methods
  • Passing Arguments while calling procedures
  • Passing Arguments while calling functions
  • Creating & Strategizing re-usable code modules

Analyzing Data With Python

Objective: To collect data from multiple ad-hoc sources and prepare it for loading it to SQL Database for BI Reporting purpose.

Overview

  • Core Fundamentals of Python
  • Understanding Python Development Environment
  • Understanding Data Types
  • Concept of Variables & Operators
  • Functions including String, Math, Date, Time, etc
  • Files and Modules in Python
  • Understanding Fundamental Coding Blocks
  • IF Block
  • Select Case
  • And / Or Conditions
  • Understanding Fundamentals of Looping
  • For Loop
  • Do While
  • Understanding Object Oriented Programming in Python
  • Data Analysis Process
  • Python Nympy - Shape, Size, Arrays, Agregation, Comparisons, Transposing, etc
  • Reporting & Data Analysis with Power BI ,Python & SQL
  • Web Scrapping with Python

Power Apps

Power Apps Training Course for Working Professionals

INTRODUCTION TO POWER APPS

Overview of Power Apps

  • What is Power Apps?
  • Benefits and use cases
  • Types of Power Apps: Canvas, Model-Driven, and Portal Apps

Getting Started

  • Setting up your Power Apps environment
  • Navigating the Power Apps interface

DATA INTEGRATION AND MANAGEMENT

Connecting to Data Sources

  • Introduction to connectors
  • Connecting to common data sources (SharePoint, Excel, SQL Server, etc.)

Managing Data

  • Understanding data tables and collections

BUILDING YOUR FIRST CANVAS APP

Basics of Canvas Apps

  • Understanding Canvas Apps
  • Creating a simple Canvas App
  • Adding screens and navigation
  • Creating simple app to view details from data source.
  • Using simple forms to display and edit data

ADVANCED CANVAS APP FEATURES

User Experience Design

  • Designing responsive layouts
  • Using themes and templates
  • Best practices for user interface design

Working with Controls

Using different types of controls like

  • Button
  • Text input
  • Drop down
  • Combo Box
  • Date picker
  • List box
  • Radio
  • Text label
  • Vertical gallery
  • Horizontal gallery
  • Flexible height gallery
  • Blank Vertical gallery
  • Blank Horizontal gallery
  • Blank Flexible height gallery
  • Data table
  • Horizontal container
  • Vertical container
  • Container
  • Image
  • Icons
  • Shapes
  • Working with control properties

Working with Variables

  • Global variables
  • Context variable
  • Collections

Using formulas for dynamic form management

Functions to be used in forms

  • SubmitForm
  • EditForm
  • Clear
  • ClearCollect
  • Collect
  • Filter
  • If
  • Navigate
  • NewForm
  • Notify
  • Patch
  • Refresh
  • Search
  • Set
  • Text
  • ThisItem
  • Value

Advanced Controls and Features

  • Working with media (images, videos)
  • Implementing charts and graphs
  • Using Power Automate for workflows

INTRODUCTION TO MODEL-DRIVEN APPS

Basics of Model-Driven Apps

  • Understanding the Common Data Service (Dataverse)
  • Creating entities and relationships
  • Building a simple Model-Driven App

SECURITY AND ADMINISTRATION

Security in Power Apps

  • Understanding security roles and permissions
  • Implementing data security

App Management

  • Managing app versions
  • Publishing and sharing apps

BEST PRACTICES AND ADVANCED TOPICS

Performance Optimization

  • Tips for improving app performance
  • Debugging and troubleshooting techniques

Real-World Use Cases

  • Case studies and examples
  • Industry-specific applications

REALTIME PROJECTS

  • Project 1: Employee Leave Request App

  • Project 2: Inventory Management App

  • Project 3: Customer Feedback App

  • Project 4: Project Management Dashboard

  • Project 5: Sales Order Processing App

Power Automate

Power Automate Training Course for Working Professionals

INTRODUCTION TO POWER AUTOMATE

Overview of Power Automate

  • What is Power Automate?
  • Benefits and use cases
  • Types of flows: Cloud Flows, Desktop Flows, and Business Process Flows

Getting Started

  • Setting up your Power Automate environment
  • Navigating the Power Automate interface

CREATING YOUR FIRST FLOW

Basics of Flow Creation

  • Understanding triggers and actions
  • Creating a simple flow
  • Running and testing flows

Flow Templates

  • Using predefined templates
  • Customizing template flows
  • Best practices for using templates

WORKING WITH CONNECTORS

Introduction to Connectors

  • Understanding connectors and their roles
  • Connecting to common data sources (SharePoint, OneDrive, Outlook, etc.)

Advanced Data Integration

  • Using premium connectors
  • Connecting to SQL Server, Azure, and other advanced data sources

ADVANCED FLOW FEATURES

Conditions and Loops

  • Implementing conditional logic
  • Using loops for repetitive tasks

Approvals and Notifications

  • Creating approval workflows
  • Sending email and mobile notifications

Error Handling and Troubleshooting

  • Managing errors in flows
  • Debugging and troubleshooting techniques

DESKTOP FLOWS (RPA)

Introduction to Desktop Flows

  • Understanding Robotic Process Automation (RPA)
  • Setting up Power Automate Desktop

Building Desktop Flows

  • Recording desktop actions
  • Automating desktop applications

Advanced Desktop Flow Features

  • Using conditions and loops in desktop flows
  • Integrating with cloud flows

BUSINESS PROCESS FLOWS

Introduction to Business Process Flows

  • Understanding business process automation
  • Creating a simple business process flow

Customizing Business Process Flows

  • Defining stages and steps
  • Implementing business rules and logic

Advanced Business Process Flow Features

  • Using custom entities and fields
  • Integrating with power apps

PROJECTS

Power Automate Projects

  • Project 1: Automated Invoice Approval Workflow

  • Project 2 : Employee Onboarding Automation

  • Project 3: Social Media Post Scheduler

  • Project 4: Customer Support Ticketing System

  • Project 5: Monthly Sales Report Automation

Desktop Flows (RPA

  • Project 1: Automated Data Entry from Emails

  • Project 2: Invoice Processing and Archiving

  • Project 3: Automated Report Generation

  • Project 4: Customer Account Reconciliation

  • Project 5: Automated Data Migration

Microsoft Copilot Studio

INTRODUCTION TO COPILOT STUDIO

Overview of Copilot Studio

  • What is Microsoft Copilot Studio?
  • Benefits and use cases for business automation
  • Understanding Copilot Studio vs. traditional chatbot platforms
  • Licensing and environment setup

Getting Started

  • Setting up your Copilot Studio environment
  • Navigating the Copilot Studio interface
  • Understanding the bot creation workflow

BUILDING YOUR FIRST COPILOT

Basics of Bot Creation

  • Creating a new copilot from scratch
  • Using templates for quick deployment
  • Configuring bot identity, greeting, and fallback behavior

Topics and Trigger Phrases

  • Understanding Topics as conversation building blocks
  • Creating and managing trigger phrases
  • Designing conversation flows with the authoring canvas
  • Using message nodes, question nodes, and condition branches

ENTITIES, VARIABLES & SLOT FILLING

  • Pre-built entities (date, number, email, city, etc.)
  • Creating custom entities and closed-list entities
  • Using variables to store and pass user input
  • Global variables vs. topic-level variables
  • Slot filling for natural conversation handling

GENERATIVE AI & KNOWLEDGE SOURCES

  • Enabling Generative Answers (AI-powered responses)
  • Connecting knowledge sources: websites, SharePoint, uploaded documents, Dataverse
  • Configuring content moderation and response quality
  • Boosting topics with generative AI fallback
  • Understanding when to use authored topics vs. generative answers

INTEGRATION WITH POWER PLATFORM

Power Automate Integration

  • Calling Power Automate flows from Copilot Studio
  • Passing variables between bot and flow
  • Automating backend processes triggered by conversations

Power Apps Integration

  • Embedding Copilot Studio bots within Power Apps canvas apps
  • Using bots to enhance app user experience

Dataverse Integration

  • Reading and writing data to Dataverse from conversations
  • Building bots that query business data in real time

PUBLISHING & CHANNELS

  • Publishing your bot to Microsoft Teams
  • Deploying to websites (custom and SharePoint)

BEST PRACTICES & ADVANCED TOPICS

  • Designing conversational UX: tone, length, error handling
  • Multi-language bot configuration
  • Bot testing and debugging techniques
  • Performance optimization and response speed
  • Using Copilot Studio with Microsoft 365 Copilot ecosystem

REAL-TIME PROJECTS

  • Project 1: Customer FAQ & Support Bot
  • Project 2: Employee IT Helpdesk Bot
  • Project 3: Lead Qualification & Routing Bot
  • Project 4: HR Policy & Leave Inquiry Bot
  • Project 5: Appointment Booking & Scheduling Bot

Microsoft Power Pages

INTRODUCTION TO POWER PAGES

Overview of Power Pages

  • What is Microsoft Power Pages?
  • Benefits and use cases for external-facing portals
  • Power Pages vs. Power Apps portals (legacy)
  • Understanding the Power Pages architecture

Getting Started

  • Setting up your Power Pages environment
  • Navigating the Power Pages design studio
  • Understanding site templates and starter layouts

BUILDING YOUR FIRST PORTAL

Site Design & Pages

  • Creating and managing web pages
  • Using the drag-and-drop WYSIWYG editor
  • Working with sections, columns, and components
  • Adding text, images, buttons, and navigation menus
  • Responsive design and mobile-friendly layouts

Templates & Themes

  • Choosing and customizing site templates
  • Applying themes, colors, fonts, and branding
  • Using custom CSS for advanced styling

DATA INTEGRATION WITH DATAVERSE

Connecting to Dataverse

  • Connecting to Dataverse
  • Displaying Dataverse data on portal pages
  • Creating and configuring lists (entity lists)
  • Creating and configuring forms (basic forms and advanced forms)
  • Multi-step forms for complex data entry workflows

Data Management

  • CRUD operations from portal pages
  • Form validation and business rules
  • File upload and attachment handling

AUTHENTICATION & USER MANAGEMENT

  • Configuring authentication providers (Azure AD B2C, local, social logins)
  • User registration and login workflows
  • Managing web roles and permissions
  • Table permissions for data security
  • Page-level access control

REAL-TIME PROJECTS

  • Project 1: Customer Self-Service Portal
  • Project 2: Partner Onboarding Portal
  • Project 3: Event Registration & Management Portal
  • Project 4: Knowledge Base & Documentation Portal
  • Project 5: Vendor Management Portal

Microsoft Dataverse

INTRODUCTION TO MICROSOFT DATAVERSE

Overview of Dataverse

  • What is Microsoft Dataverse?
  • Dataverse vs. traditional databases (SQL Server, SharePoint lists)
  • Role of Dataverse in the Power Platform ecosystem
  • Key concepts: tables, columns, relationships, environments

Getting Started

  • Setting up a Dataverse environment
  • Navigating the Dataverse interface in Power Apps maker portal
  • Understanding standard vs. custom tables

TABLE DESIGN & DATA MODELING

Creating and Managing Tables

  • Creating custom tables
  • Understanding standard (system) tables
  • Column types: text, number, choice, lookup, date, currency, file, image
  • Calculated and rollup columns
  • Auto-numbering columns

Relationships

  • One-to-many relationships
  • Many-to-many relationships

Data Modeling Best Practices

  • Designing normalized data models
  • Choosing between lookup vs. choice columns
  • When to use standard tables vs. custom tables
  • Data model documentation and naming conventions

DATA MANAGEMENT

Importing and Exporting Data

  • Importing data from Excel and CSV
  • Bulk data operations
  • Data export and backup strategies
  • Using Dataflows for data transformation

Views and Charts

  • Creating personal and system views
  • Filtering, sorting, and column management

SECURITY MODEL

Role-Based Security

  • Understanding security roles and privileges
  • Creating custom security roles
  • Business units and teams
  • Row-level security (record ownership model)

INTEGRATION WITH POWER PLATFORM

  • Dataverse as the backbone for Power Apps (model-driven and canvas apps)
  • Dataverse triggers and actions in Power Automate
  • Dataverse as a data source for Power BI
  • Dataverse in Power Pages (forms, lists, and Web API)
  • Dataverse as a knowledge source for Copilot Studio

SOLUTIONS & APPLICATION LIFECYCLE MANAGEMENT (ALM)

  • Understanding solutions (managed vs. unmanaged)
  • Creating and packaging solutions
  • Exporting and importing solutions across environments
  • Environment strategy: Dev, Test, Production
  • Version control and solution layering

REAL-TIME PROJECTS

  • Project 1: Employee Directory & Organizational Data Model
  • Project 2: Product Catalog & Order Management System
  • Project 3: Case Management & Ticketing Data Model
  • Project 4: Project Tracking & Resource Allocation System
  • Project 5: Multi-Entity Business Process with Security Roles

SSIS

SSAS

System Requirements

System Requirements:

  1. Power BI Desktop

    Free & Downloadable from Microsoft Store App

    https://www.microsoft.com/store/productid/9NTXR16HNW1T?ocid=pdpshare

  2. Excel 2016 & above with PowerPivot

    Available with Office 365 subscriptions that include desktop versions of Excel for Windows.

  3. MS-SQL Server

    https://www.microsoft.com/en-in/sql-server/sql-server-downloads

    Kindly install Developer Edition as it is full-featured free edition, licensed for use as a development and test database in a non-production environment.

  4. SQL Server Management Studio (SSMS)

    Download and install SSMS from https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

  5. Power Automate & Power Apps

    Power Apps
    https://www.microsoft.com/en-us/power-platform/products/power-apps
    Sign-up for free developer plan

    Power Automate
    https://www.microsoft.com/en-us/power-platform/products/power-automate
    Sign-up for a free 30-day trial

  6. Secondary Monitor (optional, but recommended)

    Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.

fullstack courses

Taught by Microsoft Certified Trainers

All our classes are live,
hands-on and with
real-trainers.

fullstack courses

Training Schedule

This is an add-on module. The training schedule will be shared after completing the pre-requisite course.

Kindly note that the sessions will be conducted only on weekends (Saturday & Sunday).

Have Questions?

Tel:

+91 9176633248

Email:

support@excelgoodies.com

Projects & Assignments

What's included?

  • 180 hours of live instructor-led training
  • 8 Excel reports & models
  • 4 Power BI + DAX + Power Query dashboards
  • 6 Power Pivot models
  • 12 Power BI + DAX dashboards
  • 5 Power Apps projects
  • 5 Power Automate projects
  • 5 RPA workflow projects
  • 5 Copilot Studio projects
  • 5 Power Pages projects
  • 5 Dataverse projects
  • 6 Power Query projects
  • 3 Power BI + DAX + Power Query + SQL dashboards
  • 14 VBA automation scenarios
  • 5 MS-SQL projects
  • 9 master projects integrating Power BI, Power Apps, Power Automate, SQL, VBA
  • 14 specialized certificates

Upcoming Batch

Starts On

Time

Course Fee

₹10,000

Plus GST for Company-Sponsored.

FAQs

Yes! Many professionals use this course to:

  • Move from Excel reporting to Power BI & SQL-based BI roles.
  • Transition from IT support to Data Engineering.
  • Become BI consultants or SQL/ETL specialists.

If you want real-world, applied skills, this course will set you up for success.

Many IT professionals support databases and infrastructure but don’t get involved in reporting & BI workflows. This course helps you:

  • Understand how data is used for business reporting.
  • Automate data transfers using ETL tools (SSIS) & SQL.
  • Support Power BI users more effectively.
  • Bridge the gap between IT & business users.

If you’re tired of just maintaining databases and want to add BI expertise, this course is a game-changer.

This isn’t just a reporting course or a data engineering course—it bridges both!

  • BI professionals learn to build scalable data pipelines and automate workflows.
  • Data engineers gain insight into how their work powers BI reporting and dashboards.
  • Excel users transition to Power BI while solving performance bottlenecks.
  • IT professionals learn to integrate databases, ETL tools, and automation for seamless data workflows.

In the real world, BI and Data Engineering teams don’t work in silos—this course prepares you for that essential overlap.

We assume no prior coding knowledge and start from the basics.

  • SQL is taught from scratch—no prior experience needed.
  • VBA is covered with real-world automation examples (no deep coding required).
  • ETL & SSIS training is done in a step-by-step, UI-based approach.

Even if you’ve never written a single line of code, you’ll still be able to apply these concepts in your daily work.

Yes! We provide corporate invoices for employer-sponsored payments. You can either use a company card or request an invoice to forward to your finance team.

These options are available on the

Yes! We offer discounts for teams of 10 or more enrolling together. Customized corporate training is also available.

Contact us for group pricing.

We accept credit/debit cards, wire transfers, and corporate invoices for employer-sponsored payments.

Most Data Engineering courses focus heavily on big data, cloud tech, and programming (Spark, Hadoop, AWS, etc.). But in real-world companies, not all data pipelines are cloud-based.

This course is different because it focuses on:

  • On-prem SQL & ETL with SSIS—many companies still use SQL-based infrastructure.
  • Power BI integration—because data pipelines exist to serve reporting.
  • VBA—because automation still plays a major role in bridging gaps.

If you’re looking for a more practical, business-oriented approach to Data Engineering, this course makes more sense than a pure coding-heavy cloud-based course.

Many Power BI users rely on Power Query for transformations, but that doesn’t scale well with large datasets.

Learning SQL & ETL (SSIS) will help you:

  • Process large datasets efficiently before they enter Power BI.
  • Avoid slow dashboards by handling transformations at the database level.
  • Automate data extraction, cleaning & loading from multiple sources.

Many Power BI professionals hit a bottleneck because they don’t know how to optimize data pipelines—this course fixes that!

This is a live, instructor-led course with hands-on exercises, real-world case studies, and Q&A discussions to ensure a highly engaging learning experience.

No, this is a live interactive course with hands-on projects. However, you’ll receive detailed assignments, documentation, and automation templates to practice.

If you miss a session, we provide class notes and exercises to help you catch up. Additionally, you can attend the same session in a future batch (subject to availability).

Yes! You will receive a Specialist Certificate upon successfully completing the course and final assessment.

You can retake sessions from a future batch (subject to availability), but full course re-enrollment may require an additional fee.

Unlike pre-recorded courses, this is a live, interactive program where you work on real-world datasets and get direct access to expert instructors for personalized guidance.

More questions ?

Gain industry-recognized credentials.

14 Specialized Certificates

Shareable certificate

Add to your LinkedIn profile

Gain industry-recognized credentials.

14 Specialized Certificates

Build Real-World Solutions During the Course

Key Skills You'll Master

Cloud Data Integration & Management

Cloud Data Modeling

Real-Time Data Processing & Handling

Cloud-Based Data Transformation

Cloud Reporting & Dashboard Creation

Automated Cloud Reporting & Scheduling

Cloud Performance Optimization

Collaborative Cloud Analytics

Cloud Data Security & Governance

Cloud Automation Techniques

Cloud-Based Solution Design

Data Pipeline Management for Cloud

Cloud Performance Tuning

Classroom Gallery

About The Trainer

Mr. Sami

MCT, MCSA

15,000+

Students Trained

19+

Year of Experience

4.9

Reviews

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance, HR & Information Technology brings in 19 years of Industry experience. He has successfully trained 15,000+ professionals by now, and the counting is still on.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Google Reviews

Corporate Training

bi_report_automation_mob

Avail additional 10% Corporate Benefit on the total course fee for 5+participants.

Get you team BI ready, today.

Ms.Jayasree

Business Associate

Prove you're human: Type the code shown.

=
Excelgoodies

Esteemed Clientele

Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele

Thousands Trained. Here’s What They Say.

Total Reviews 2080
Average Rating
4.5
Excelgoodies Excelgoodies Excelgoodies Excelgoodies Excelgoodies
fullstack courses

Thousands Trained. Here’s What They Say.

APPLICATION DEADLINE

Registration Closes
on .

Prove you're human: Type the code shown.

=
Excelgoodies

Industry Insights

Industry Insights