SQL & Power BI培训

Duration of training:

2 days for a total of 12 hours (Split into 3 sessions of 4 hours each)

Training content:

SQL

SQL Introduction

DDL

◦ SELECT

◦ INSERT

◦ UPDATE

◦ DELETE

DML

◦ CREATE

◦ ALTER

◦ DROP

Others

◦ JOIN

◦ GROUP BY

◦ ORDER BY

◦ WHERE

◦ BETWEEN AND

◦ INT IN

◦ LIKE

Function

◦ String function

◦ Date Function

◦ Math Function

◦ Blank Function

◦ Conditional function

◦ Aggregation Function

Power BI

Power BI Introduction

• Power BI Desktop Introduction

• Connect to data

• Loading data into Power BI

Data Modeling

Chart

• Create Chart

• Moblie Version Creation

• Security Setting

Publish & Share

• Power BI Service Introduction

• Publish & Share

DAX Basic