Power BI & SQL

SQL for Business Power BI for

Analysts Business Analysts
I. Introduction to I. Introduction to Power BI
Databases and SQL 1. Understanding Business
1. Understanding Databases Intelligence (BI) and its importance

Overview of what a database is Overview of BI and its

and its importance in storing, significance in data-driven
retrieving, and managing decision-making.
[Link] of databases: Role of Power BI in
Relational (e.g., SQL Server, transforming raw data into
MySQL) and NoSQL. meaningful insights.
Types of databases (Relational, 2. Overview of Power BI and its
NoSQL, etc.) components
2. Introduction to SQL Introduction to Power BI
SQL as the standard language Desktop, Power BI Service, and
for managing and manipulating Power BI [Link] BI
relational [Link] uses architecture and how it fits into
of SQL in data querying and an organization's BI strategy.
analysis.

3. MySQL Installation and Setup

II. Data Sources and
Connections
Installing MySQL server and
client 1. Setting up Power BI Desktop and
licensing
Configuring MySQL server
2. Importing data from various
MySQL command-line client
sources
and GUI tools

Power BI & SQL 1

 II. SQL Basics Connecting to various data
sources such as Excel,
1. SQL Syntax and Structure
databases, and web services.
Overview of SQL statements
3. Data Types and Data
(e.g., SELECT, INSERT,
Transformation
UPDATE, DELETE) and clauses
(e.g., WHERE, ORDER Overview of data types in
BY).Writing basic SQL queries Power BI and their
to extract specific data from [Link] data
databases. using Power Query Editor,
including removing duplicates,
2. Creating and Managing Databases
changing data types, and
How to create, modify, and creating calculated columns.
delete databases.

3. Data Types III. Data Modeling in

Common data types in SQL
Power BI
(e.g., INT, VARCHAR, DATE) 1. Understanding Data Models
and their applications in
Basics of data modeling,
business data.
including the star schema and
dimensional modeling.
III. Creating and
Creating relationships between
Manipulating Tables tables to enable effective data
1. Creating Tables analysis.

How to define tables, including 2. Calculated Columns and Measures

setting up columns, data types,
Introduction to DAX (Data
and constraints (e.g., primary
Analysis Expressions) for
keys).
creating calculated columns
2. Modifying Tables and measures.

Altering existing tables to add, Implementing basic DAX

modify, or delete columns. functions (e.g., SUM, COUNT)
and understanding their role in
3. Inserting, Updating, and Deleting
reporting.
Data

Power BI & SQL 2

 How to insert, update, and
delete records in a database
table. IV. Data Visualization and
Use of the INSERT INTO, Reporting
UPDATE, and DELETE
1. Creating Visualizations
statements.
Understanding various chart
types (bar, line, pie, etc.) and
IV. Querying Data
when to use them.
1. Selecting Data
Customizing visualizations with
Retrieving specific data using formatting options, conditional
the SELECT [Link] formatting, and interaction
results using the WHERE features.
clause.
2. Building Reports:
2. Sorting and Limiting Results
Designing and laying out
Sorting data with the ORDER reports, adding filters, and
BY clause. customizing themes.
Limiting the number of records Incorporating bookmarks and
retrieved with LIMIT and navigation to create interactive
OFFSET. reports.
3. Joining Tables 3. Creating Dashboards
Combining data from multiple Pinning visuals to dashboards,
tables using JOIN operations designing dashboard layouts,
(INNER JOIN, LEFT JOIN, and adding interactive
etc.).Importance of joins in elements like slicers.
creating comprehensive
4. Creating dashboards
reports and insights.
Pinning visualizations and tiles
V. Advanced SQL for Data Configuring dashboard layout
Analysts and design

1. Subqueries and Derived Tables: Adding interactive elements

(slicers, filters, etc.)

Power BI & SQL 3

 Writing complex queries with
subqueries for advanced data
retrieval.

2. Aggregating Data:

Using GROUP BY to aggregate

data and HAVING to filter
groups.

Common aggregate functions

like COUNT, SUM, AVG, MIN,
and MAX.

3. Views

Creating and managing SQL

views to simplify complex
queries.

4. Stored Procedures and Functions

Using stored procedures and

user-defined functions for
reusable query logic.

Power BI & SQL 4