KEMBAR78
PowerBi & SQLModule - 26 - 11 - 22 | PDF | Sql | Relational Database
Scribd
Upload
20 views6 pages

PowerBi & SQLModule - 26 - 11 - 22

The document outlines a comprehensive training module on Power BI and SQL, covering topics such as database fundamentals, SQL theory, and various SQL commands including select, insert, update, and delete statements. It also includes advanced SQL topics, data visualization techniques in Power BI, and data management with Power Query and DAX. Additionally, it features sections on creating executive dashboards and visualization tricks, along with resources like quizzes and a glossary.

Uploaded by

rushikesh goud
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
20 views6 pages

PowerBi & SQLModule - 26 - 11 - 22

The document outlines a comprehensive training module on Power BI and SQL, covering topics such as database fundamentals, SQL theory, and various SQL commands including select, insert, update, and delete statements. It also includes advanced SQL topics, data visualization techniques in Power BI, and data management with Power Query and DAX. Additionally, it features sections on creating executive dashboards and visualization tricks, along with resources like quizzes and a glossary.

Uploaded by

rushikesh goud
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

POWER BI & SQL MODULE

Demo

 About Power BI & different Product types


 SQL Demo

Introduction to databases SQL and MySQL

 Why SQL?
 Why MySQL?
 Introduction to databases

SQL Theory

 SQL as a declarative language


 Data definition language (DDL)
 SQL keywords
 Data manipulation language (DML)
 Data control language (DCL)
 Transaction control language (TCL)

Basic database terminology

 Relational database essentials


 Databases vs spreadsheets
 Database terminology
 Relational schemas - Primary key
 Relational schemas - Foreign key
 Relational schemas - Unique key and null
 Relationships

First steps in SQL

 Creating a Database - Part I


 SQL files
 Introduction to data types
 String data types
 Integers
 Fixed and floating-point data types
 Other useful data types
 Creating a table
 Using databases and tables

MySQL constraints

 Primary Key Constraint


 Foreign Key Constraint
 Unique Constraint
 Default Constraint
 Not Null Constraint

SQL Select Statement

 Select From
 Where
 And
 Or
 Operator Precedence
 In – Not in
 Like – Not Like
 Wildcard Characters
 Between – And
 Is Not Null – Is Null
 Other Comparison Operators
 Select Distinct
 Introduction to Aggregate Functions
 Order By
 Group By
 Using Aliases
 Having
 Where Vs Having
 Limit

SQL Insert Statement

 The Insert Statement


 Inserting data into a new Table
SQL Update Statement

 TCL’s Commit and Rollback


 The Update Statement
 Rollback

SQL Delete Statement

 Delete Statement
 Drop
 Truncate
 Drop vs Truncate

Aggregate Functions

 Count()
 Sum()
 Min() & Max()
 Avg()
 Round()
 Coalesce()
 Isnull() & Coalesce()

SQL Joins

 Introduction to Joins
 Inner Join
 Duplicate Records
 Left Join
 Right Join
 Join & Where Used together
 Cross Join
 Aggregate Functions with Join
 Join more than 2 tables
 Union vs Union All
 Self Join

SQL Subqueries

 SQL subqueries with in nested inside where


 SQL subqueries nested in select & from

Advanced SQL Topics:


 Views
 MySQL Indexes
 The Case Statement
 MYSQL Triggers
 Row_Num()
 Rank()

CONNECTING SQL & POWERBI

Chart Types, Creating and Formatting Visualizations in Power BI

1. Dashboard vs Reports
2. Dashboard Design
3. Bar Chart
4. Line Chart
5. Stacked Bar Chart
6. Histogram
7. Heat maps
8. Tree Maps
9. Bullet Graph
10. Combo Charts (Single Axes and Double Axes)
11. Scatter plot
12. Cross- Tab
13. Overlapping Bar Chart
14. Box plots
15. Using Bookmarks Labels and Annotations, Adding Titles, Captions
and Tooltips report pages
16. Editing Axes
17. Single-value visuals
18. Map visuals
19. Waterfall chart, Column chart, line chart
20. Power Platform visuals
21. Live Report pages, mobile optimized dashbaords
22. Formatting visualization
23. Table and matrix visuals

Data management with Power Query

1. Planning PowerBI Project


2. Power Query -combining, cleaning and transforming data
3. Automating queries with parameters & functions

Data Analysis with DAX & Power Pivot

1. DAX Deep dive


2. Power Pivot
3. Calculation groups, dimension metrics, dynamic ranking measures,
dynamic row-level security
4. Time intelligence patterns in Power BI
5. Performance testing

Story telling with Power BI

1. Report Tooltips
2. Conditional formats
3. Text commentary with DAX
4. Play Axis for scatter charts, Pulse chart
5. Analytics Pane
6. Quick Insights
7. Dimensional modeling with Power Query
8. Reference vs. Duplicate queries
9. Generating calendar tables
10. Data modeling with multiple fact tables
11. Measure development
12. Dashboard design and implementation

Executive Dashboard-I

Part 1 – Report goals and design


Part 2 – Data Modeling and Measures
Part 3 – Business View with KPIs & forecast
Part 4 – Business View contd
Part 5 – Finance Department View with What-if analysis

Executive Dashboard-II

Part 1 – Creating a timeline of funded amounts


Part 2 – Creating a Bar chart for sector
Part 3 – Creating a pie chart of split by Gender
Part 4 – Action: Filter, Highlight

BONUS: Visualization Tricks and Inspiration


 Report pages & Drill through
 Bookmarks & interactive reporting
 Labeling last point with measures
 Dynamic titles with conditional formatting
 Variance Charts in Power BI
 Power BI and Excel, R and Python Visuals
 Publishing & Sharing Options
 Quizzes and Challenges
 Cheat sheet
 Glossary
 FAQs

You might also like