Skip to main content

#Fabric Data Analyst

Fabric Data Analyst is a promising job role that deals with Data, Analysis, Derived Information and drive to Infographics of enterprise content. This role also involves Data collection, data processing, and data analysis to identify trends, patterns, and relationships that can be used to solve problems and make informed decisions with ease!

✅ Power BI with Fabric
✅ Fabric DWH with Power BI
✅ Fabric Lakehouse with Power BI
✅ Fabric Stream House & Power BI
✅ Dynamic Row-Level Security
✅ Data Activator, Alerts
✅ Big Data Analytics
✅ DP 600 Exam Guidance
✅ Real Time Project
✅ 1:1 Mentorship, Resume

Fabric Data Analyst Today

Fabric Data Analyst
Training Course Contents:

Module 1 : Microsoft SQL (TSQL)

Ch 1: SQL SERVER INTRODUCTION

  • Database Introduction
  •  Types of Databases
  •  Need for & ETL, DWH
  •  BI Implementations
  •  SQL Server Advantages
  •  Version, Editions of MSSQL
  •  Data Analyst Job Roles

Ch 2: SQL SERVER INSTALLATIONS

  • SQL Server 2019, 2017
  • SSMS Tools Installation
  • Database Engine (OLTP)
  • SCM, Configuration Tools
  • Instance Types, Uses
  • Authentication Modes
  • Collation, File Stream

Ch 3: SQL BASICS – 1

  • Need for Databases, Tables
  • Need for SQL Commands
  • DDL, DML & DQL Statements
  • Database Creation @ GUI
  • Data Operations @ GUI
  • Session ID, SQL Context
  • DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

  • DDL Variants in MSSQL
  • DML Variants in MSSQL
  • INSERT & INSERT INTO
  • SELECT & SELECT INTO
  • Basic Operators in SQL
  • Special Operators in MSSQL
  • ALTER, ADD, TRUNCATE, DROP

Ch 5: Data Imports, Schemas

  • Data Imports with Excel
  •  ORDER BY & UNION
  • UNION ALL For Sorting Data
  •  Creating, Using Schemas
  •  Real-world Banking Database
  •  Table Migrations @ Schemas
  •  2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

  • Need for Constraints, Keys
  •  NULL, NOT NULL, UNIQUE
  •  Primary Key & Foreign Key
  •  RDBMS and ER Models
  •  Identity Property, Default
  •  Clustered Index, Primary Key
  •  Non Clustered Index, Unique

Ch 7: Joins & Views Basics

  • JOINS: Purpose. Inner Joins
  • Left / Right / Full Outer Joins
  • Cross Joins, Query Tuning
  • Creating & Using Views
  • DML, SELECT with Views
  • RLS : WITH CHECK OPTION
  • System Views & Metadata

Ch 8: Functions(UDF), Data Types

  • Using Functions in MSSQL
  •  Scalar Value Functions
  • Inline & Multiline Functions
  • Date & Time Functions
  • String, Aggregate Functions
  • Data Types : Integer, Char, Bit
  • SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

  • Stored Procedures & Usage
  • Creating, Testing Procedures
  • Encryption, Deferred Names
  • SPs for Validations, Analysis
  • System SPs, Recompilation
  • Normal Forms & Types
  • Data Models, Self-References

Ch 10: Triggers, Temp Tables

  • Need for Triggers
  • DDL & DML Triggers
  • Using Memory Tables
  • Data Replication, Automation
  • Local & Global Temp Tables
  • Testing & Using Temp Tables
  • SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

  • Planning VLDBs : Files, Sizing
  • Filegroups, Extents & Types
  • Log Files : VLF, Mini LSN
  •  Table Location, Performance
  • Schemas, Transfer, Synonyms
  • Transactions Types, Lock Hint
  •  Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

  • Cursors : Realtime Use
  • Fetch & Access Cursor Rows
  • CTEs for SELECT, DML
  • CTEs: Scenarios & Tuning
  • Linked Servers, Remote Joins
  • Linked Servers: MSDTC, RPC
  • Tuning Remote Queries

Ch 13: Merge, Upsert & Rank

  • Need for Merge in ETL
  • Incremental Loads with SQL
  • MERGE and RANK Functions
  • Window Functions, Partition
  • Identify, Remove Duplicates

Ch 14: Grouping & Cube

  • Group By & HAVING
  • Cube, Rollup & Grouping
  • Joins with Group By
  • 3 Table, 4 Table Joins
  • Query Execution Order

Ch 15: Self Joins, Excel Analysis

  • Self Joins & Self References
  •  UNION, UNION ALL
  •  Sub Queries with Joins
  •  IIF, CASE, EXISTS Statements
  •  Excel Analytics, Pivot Reports

Module 2: Microsoft Fabric Data Analytics

Ch 1 : Power BI Introduction

  • Reporting Basics & Types
  • Interactive,Analytical Reports
  • Paginated Reports (RDL)
  • Power BI Eco System
  • Power BI Tools,Service,Server
  • Need for Power Query (M)
  • Need for DAX & Cloud

Ch 2: Power BI Basic Reports

  • Power BI Desktop Installation
  • Basic Report Design (PBIX)
  • Data View, Data Models
  • Data Points, Aggregations
  • Focus Mode, Spotlight, Exports
  • ToolTip, PBIX and PBIT
  • Visual Interactions & Edits

Ch 3 : Grouping, Hierarchies

  • Creating Groups in Power BI
  • Groups : Creation & Usage
  • Group Edits Options
  • Bins & Bin Size, Bin Count
  • Hierarchies: Creation, Use
  • Drill Down, Drill Up
  • Conditional Drill Down

Ch 4 : Visual Sync, Filters

  • Slicer & Single Select
  • Multi Select Options
  • Integer, Character Slicers
  • Visual Sync with Slicers
  • Filters: Visual, Page, Report
  • Drill Thru Filters & Usage
  • Basic, Top & Advanced
  • Clear Filter Options, Resets

Ch 5 : Bookmarks, Big Data

  • Bookmarks Creation & Usage
  • Visual Interactions, Bookmarks
  • Images : Actions, Bookmarks
  • Big Data Access with Power BI
  • Storage Modes: Direct Query
  • Import & Performance Impact
  • Formatting & Data Refresh
  • Summary, Date Time Formats

Ch 6 : Power BI Visualizations

  • Chart and Bar Visuals
  • Line and Area Charts
  • Maps, TreeMaps, HeatMaps
  • Funnel, Card, Multrow Card
  • PieCharts & Settings
  • Waterfall, Sentiment Colors
  • Scatter Chart, Play Axis
  • Infographics, Classifications

Ch 7 : Power Query Level 1

  • Power Query (Mashup)
  • ETL Transformations in PBI
  • Power Query Expressions
  • Table Combine Options
  • Merge, Union All Options
  • Table Transformations

Ch 8 : POWER QUERY LEVEL 2

  • Any Column Transformations
  • String / Text Transformations
  • Numeric Analytics & Mashup
  • Date Time Transformations
  • Add Column Transformations
  • Expressions and New Columns

Ch 9 : POWER QUERY LEVEL 3

  • Parameters in Power Query
  • Static Parameters, Defaults
  • Dynamic Dropdowns, Lists
  • Linking with Table Queries
  • Column From Examples
  • Step Edits, Type Conversions

Ch 10 : Power BI Cloud – 1

  • Power BI Cloud Concepts
  • Workspace Creation, Usag
  • Report Publish & Edits
  • Semantic Models in Realtime
  • Dashboard Creation, Usage
  • Clone, Share, Subscribe
  • Q&A, Lineage, Settings

Ch 11 : Power BI Cloud – 2

  • Data Gateways, Data Refresh
  • Data Source Configurations
  • Data Refresh & Scheduling
  • Gateway Optimizations
  • Semantic Model Optimizations
  • Report Optimizations
  • Dashboard Optimizations

Ch 12 : Power BI Cloud – 3

  • Power BI Apps, Shares
  • App Sections & Options
  • App Updates, Security
  • Excel Analytics
  • Data Explorer Option
  • Sharing, Subscriptions
  • Alerts, Metrics, Insights

Ch 13 : Report Server & DAX

  • Power BI Report Server
  • Report Database, TempDB
  • Web Service & Server URL
  • Paginated Reports (RDL)
  • Report Builder Tool Usage
  • DAX : Purpose, Realtime Use

Ch 14: DAX Level 2

  • DAX Measures Creation, Use
  • DAX Functions: IIF, ISBLANK
  • SUM, CALCULATE Functions
  • DAX Cheat Sheet : Examples
  • Quick Measures in Power BI
  • Running Totals, Filters

Ch 15 : DAX Level 3

  • Star Rating Calculations
  • Data Models & DAX
  • Star & Snowflake Schemas
  • Dimensions, Fact Tables
  • DAX Expressions & Joins
  • DAX Variables, Usage

Ch 16 : DAX Level 4

  • Dynamic Report with DAX
  • SELECTED MEMEBER
  • Time Intelligence with DAX
  • PARALLELPERIOD, DATE
  • DAX with Big Data
  • Big Data Analytics

Ch 17 : Realtime Project Phase 1

  • Project Requirement Spec
  • Understanding Data, Formats
  • Report Pattern Design
  • Report Design & Modelling
  • Power Query, DAX, Insights
  • Analytical Reports in Cloud

Ch 18 : Realtime Project Phase 2

  • Complete Project Solution
  • Project FAQs, Key Roles
  • Real-world Considerations
  • Power BI Admin Concepts
  • Resume Points, FAQs
  • PL 300 Exam Guidance

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Fabric Data Analyst Training FAQ's

What is Fabric Data Analyst Job Role?

A Fabric Data Analyst is responsible for designing, building, and delivering data analytics solutions using Microsoft Fabric. The role involves working with lakehouses, warehouses, dataflows, pipelines, and Power BI to ingest, model, and visualize data. Fabric Data Analysts turn raw enterprise data into actionable business insights through modern analytics solutions that are secure, scalable, and governed.

What are the Job Roles of a Fabric Data Analyst?

💼 Top Job Roles:

1️⃣ Ingest and transform data using Fabric Data Pipelines and Dataflows
2️⃣ Build Lakehouse and Warehouse data models for analytics
3️⃣ Develop semantic models for enterprise reporting
4️⃣ Design and publish interactive dashboards using Power BI
5️⃣ Apply data security, governance, and compliance in analytics solutions
6️⃣ Collaborate with engineers, architects, and business users and more..!

What does our Fabric Data Analyst Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: Microsoft SQL (TSQL)
👉🏻Module 2: Power BI

Who can join this course?

  •  Freshers starting a career in modern data analytics
  • Power BI professionals expanding into Fabric analytics
  • ETL/SQL developers moving to Fabric-based analytics solutions
  • Data analysts wanting Fabric enterprise skills
  • Anyone passionate about building cloud-first analytics solutions

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1:        LIVE Online Training  (100% Interactive, step by step, assignments)

Option 2:        Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for Fabric Data Analyst training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice.  Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

Why Choose SQL School

  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance