[go: up one dir, main page]
Scribd
Upload
32 views3 pages

PowerBI Notes

Uploaded by

no one
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
32 views3 pages

PowerBI Notes

Uploaded by

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

Day1 (21-08-24)

PowerBI
Business Intelligence Tool

PowerBI Download Link


https://powerbi.microsoft.com/en-us/desktop/
Microsoft Play Store -PowerBI Desktop App -Get

PowerBI Version
1 PowerBI Desktop(Free)

2 PowerBI Pro ( 1GB $9.9 Per Month)

3 PowerBI Premium(10GB $4995 Per Month)

PowerBI Platform
1 PowerBI Desktop ( Only in Desktop/Laptop)
2 PowerBI Services( SAS Platform online Platform)
3 PowerBI Gateways( One Premisses to other premisses)
4 PowerBI Mobile (Read only Files)

Path
Data-Rows Column- Table - Databases -Schema
Power Query Editor-Data Cleaning
Power Pivot -Data Modelling

Data Analyst
Collect Data-Data Understanding-Data Cleaning-Data Modelling (More than 2 Table)-
Visualization-Dashboard Layout-Dashboard (Data ,Chart ,Slicer,
Filter ,Navigation ,KPI Card,Link)

Extensions
.pbix - Packaged Workbook
.pbit- Templet /Without Data

Data Connectivity Mode


1 Import
2 Direct Query
3 Live Connection

Data Types
1 Text -No Symbol
2 Numeric -Summation Symbol
3 Date -Calendar Symbol
#23-08-24(Day2)
Desktop Visualization
Less Distribution Data
1 Bar Chart X Axis-1 Numerical Data Y Axis -1 Text Data
2 Column Chart Y Axis-1 Numerical Data X Axis -1 Text Data
3 Stacked Bar Chart X Axis-1 Numerical Data Y Axis -1 Text Data
Legends-1 Text Data
4 Stacked Column Chart Y Axis-1 Numerical Data X Axis -1 Text Data
Legends-1 Text Data
5 Cluster Bar Chart X Axis-1 Numerical Data Y Axis -1 Text Data
Legends-1 Text Data
Chart type Cluster Bar Chart-Less Values clearly Visible
6 Cluster Column Chart Y Axis-1 Numerical Data X Axis -1 Text Data
Legends-1 Text Data
Chart Type Cluster Column Chart-Less Values clearly Visible
7 100% Stacked Bar Chart X Axis-1 Numerical Data Y Axis -1 Text Data
Legends-1 Text Data
Distribution in percentage
8 100% Stacked Column Chart Y Axis-1 Numerical Data X Axis -1 Text Data
Legends-1 Text Data
Distribution in percentage
#26-08-24(Day3)

Date -Drill Up Drill Down -Hierchey in Date Column

9 Line Chart X Axis -Date(Y/Q/M/D) Y Axis -1 Numerical


Data
Trend, Average, Min, Max, X axis Constant ,Y axis constant ,Forecasting, Error,
Percentile Line
10 Area Chart (Overlapping) X Axis -Date(Y/Q/M/D) Y Axis -1 Numerical
Data Legends -text Data
11 Stacked Area Chart (No Overlapping) X Axis -Date(Y/Q/M/D) Y Axis -1 Numerical
Data Legends -text Data
Small Values not Visible in Chart
12 100% Stacked Area Chart (100% Distribution) X Axis -Date(Y/Q/M/D) Y Axis -1
Numerical Data Legends -text Data
13 line & Stacked Column Chart (Dual Axis)X Axis -1 Date(Y/Q/M/D)/1 Text Y Axis
-1 Numerical Data Line Y axis -1 Numerical Data Legends -text Data (Small Values
not Visible in Chart)
14 line & Cluster Column Chart X Axis -1 Date(Y/Q/M/D)/1 Text Y Axis -1
Numerical Data Line Y axis -1 Numerical Data Legends -text Data (Cluster of Values)

#27-08-24(Day4)
15 Ribbon Chart Legends 1 -text(less Dist) Y Axis 1 numerical X Axis -
Date/Text
16 Water Fall Chart X Axis 1 Text(less Dist) Y Axis 1 Numerical Breakdown-
Date
17 Funnel Chart Category 1 Text(Max till 20) Values 1 Numerical
18 Scatter Chart X Axis 1 Numerical Y Axis 1 Numerical Values -text Data Max
Distribution Play Axis -Y/Q/M

#28-08-24(Day5)
19 Table 1 Text Data 2/more Numerical Data(Column Wise
Info)
20 Multiple Row Card 1 Text Data 2/more Numerical Data(Column Wise
Row Wise Total Not Available)
Use as Single card to Show all Single card in one
21 Matrix 1more Text in Rows 1 Date(Hierchey) Column 1
Numerical -Values
(Row Wise and Column Wise Total available)
Table Multirow Card Matrix
1Data Column Row Row &
Column
2 Total Column Total Card Total
Row,Column,Grand Total
3 Hierchey/Drill up Down No No Yes(Row &
Column)
4 Single Card Yes Yes No
Slicer

You might also like