Home
Course
Power BI with SQL

Power BI with SQL

~~$24~~ $20
Enroll Now Enroll Now

Power BI with SQL

In this course we are going to learn about Power BI ,SQL . This course is designed to get hands-on practical experiences.

Power BI and SQL Certification Preparation

Overview of Power BI and SQL Certification Tracks.
Exam Structure and Format.
Study Materials and Resources.
Practice Exams and Mock Tests.
Tips for Successful Exam Preparation.

Power BI Topics

Module 1

Introduction to Power BI

Introduction to Business Intelligence (BI)
Stages of business intelligence (BI)
Use cases of BI
Various BI tools
Overview of Data warehouse & concepts
Introduction to Power BI
Why Power BI
Power BI Components
Power BI pricing structure
Building blocks of Power BI
Architecture of Power BI
Power BI vs Tableau vs QlikView
Introduction of Power BI Desktop
Installation of Power BI Desktop
The key features of Power BI workflow
Process of creating reports in Power BI

Module 2

Data Extraction

Overview of Power BI desktop
Data sources in Power BI
Using files (excel, pdf, csv, etc.) as a data source
Using SaaS connectors
Extracting data from folders, and databases
Working with Azure SQL database and database sources
Connecting to Analysis Services
Other data sources (OData, web, SharePoint etc.)
Python & R script in Power BI
Introduction of power query editor
Advance editor
Query dependency editor
Data Transformation and Cleaning
Data Modeling in Power BI
Visualization in Power BI

Module 3

DATA TRANSFORMATION – SHAPING & COMBINING DATA

Shaping data using Power Query Editor
Formatting data
Transformation of data
Understanding of Data types
Data profiling for data quality check
Naming conventions & best practices to consider
Identify and create appropriate keys for joins
Working with Parameters
Merge Query
Append Query
Group by of data (aggregation of data)
Applied steps (query settings)
Duplicate & Reference tables
Transpose of data
Fill
Pivot & Un-pivot of data
Custom columns
Conditional columns
Replace data from the tables
Split columns values
Move columns & sorting of data
Detect data type, count rows & reverse rows
Promote rows as column headers
Hierarchies in Power BI
M query

Module 4

DATA MODELLING & DAX

Introduction of relationships
Creating relationships
Cardinality
Cross filter direction
Use of inactive relationships
Introduction of DAX
Why DAX is used
DAX syntax
DAX functions
Context in DAX
Calculated columns using DAX
Measures using DAX
Calculated tables using DAX
Learning about table, information, logical, text, iterator
Time intelligence functions (YTD, QTD, MTD)
Cumulative values, calculated tables, and ranking and rank over groups
Date and time functions
identify poorly performing measures, relationships, and visuals
DAX advanced features

Module 5

DATA VISUALIZATION WITH ANALYTICS

Deep dive into Power BI data visualization
Understanding Power View and Power Map
Data visualization techniques
Page layout & Formatting
Power BI Desktop visualization
Formatting and customizing visuals
Visualization interaction
Custom visualization in Power BI
Top-down and bottom-up analytics
Drill down
Drill through
Page navigations
Bookmarks
Selection pane to show/hide visuals
Comparing volume and value-based analytics
Combinations charts (dual axis charts)
Filter pane
Slicers
Use of Hierarchies in drill down analysis
Theme for corporate standards
Power BI template for design reusability
Mastering the best practices
Performance analyzer in Power BI for
monitoring performance of report
Power BI Q&A (Natural Language Query visual)
Sync slicers
Tooltips & custom tooltips
Tables & matrix
Conditional formatting on visuals
Waterfall chart, KPI, Donut chart, Scatter chart
Geographical data visualization using Maps

Module 6

POWER BI SERVICE (Cloud), Q & A AND DATA INSIGHTS

Introduction to Power BI Service
Introduction of workspaces
Dashboard
Creating & Configuring Dashboards
Dashboard theme
Reports vs Dashboards
Building workspace Apps
Sharing reports & dashboards
configure subscriptions and data alerts
Paginated report and Introduction to Power Q & A

Module 7

POWER BI SETTINGS, ADMINISTRATION & DIRECT CONNECTIVITY

Getting to understand Power BI Desktop settings
Aggregating data from multiple data sources
Power BI Service settings
Power BI Admin Portal
Administration activities
Power BI usage analysis
Introduction of Office 365 admin activities
Introduction of Data Gateway
Installation & Configuration of data gateways
Scheduling auto data refresh
Managing groups, row-level security, datasets, reports, and dashboards
Real time data analysis using Direct Connectivity
Direct Query vs Import Mode

Module 8

EMBEDDED POWER BI WITH API & POWER BI MOBILE

Introduction to embedded Power BI
Create embedded code
Manage embedded code
Integration of Power BI in SharePoint
Introduction of Power BI API
Power BI Embedded playground
Introduction to Power BI Mobile
Creating mobile based reports & dashboards
Optimizing report for Power BI mobile app
Features of Power BI mobile app
Introduction of integrating Power BI & Excel
Power BI Analyze in Excel

Module 9

POWER BI ADVANCE & POWER BI PREMIUM

Introduction of Power BI Premium
Power BI Premium per user
Power BI Premium features
Introduction to Data Flow
Create Data Flow
Advantages of Data Flow
Create reports using Data Flow
Introduction to Power BI Deployment Pipelines
Create Deployment Pipelines
Benefits of Deployment Pipelines
Introduction of Sensitivity Labels
Introduction of Power BI Goals feature
Incremental data load in Power BI
use AI visuals
use the Forecast feature
Power BI best practice rules to improve performance
Advanced Data Modeling
Advanced DAX Techniques
Power BI and Azure Integration

SQL Topics

Module 1

Introduction to SQL

Various types of databases
Introduction to Structured Query Language
Distinction between client server and file server databases
Understanding SQL Server Management Studio
SQL Table basics
Data types and functions
Transaction-SQL
Authentication for Windows
Data control language
The identification of the keywords in T-SQL, such as Drop Table
Introduction to SQL Commands
Normalization in Databases
Stored Procedures and Triggers in T-SQL

Module 2

Database Normalization and Entity Relationship Model

Entity-Relationship Model
Entity and Entity Set
Attributes and types of Attributes
Entity Sets
Relationship Sets
Degree of Relationship
Mapping Cardinalities, One-to-One, One-to-Many, Many-toone, Many-to-many
Symbols used in E-R Notation
Foreign Key Constraints:
Primary Key Constraints
Stored Procedures
Normalization
Denormalization

Module 3

SQL Operators

Introduction to relational databases
Fundamental concepts of relational rows, tables, and columns
Several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys
Understanding group functions
The unique key
Data Integrity
Triggers in SQL
Database Design Principles

Module 4

Working with SQL: Join, Tables, and Variables

Advanced concepts of SQL tables
SQL functions
Operators & queries
Table creation
Data retrieval from tables
Combining rows from tables using inner, outer, cross, and self joins
Deploying operators such as intersect, except, union,
Temporary table creation
Set operator rules
Table variables

Module 5

Deep Dive into SQL Functions

Understanding SQL functions what do they do?
Scalar functions
Aggregate functions
Functions that can be used on different datasets, such as numbers, characters, strings, and dates
Inline SQL functions
General functions
Duplicate functions
Mathematical Functions
String Functions
Date and Time Functions

Module 6

Working with Subqueries

Understanding SQL subqueries, their rules
Statements and operators with which subqueries can be used
Using the set clause to modify subqueries
Understanding different types of subqueries, such as where, select, insert, update, delete, etc.
Methods to create and view subqueries
Common Table Expressions
Stored Procedures and Functions
Database Transactions