ACAD
Institute of Engineering & Science
IPSACADEMY
edge.
EXpeRIMENT No. L
laBttall Power BI /Tobleau. and explare the interface
INTROOUCTLON
Power B is o freely ouailable tool from
MiorosoPt tor eusiness Araalytics. It helos yau via ualize data
Qnd senmlessly share the insiohts from t wth stakebalclere
Nhether oue a dato seientist on analyst oro buciness.
Ser Power e is Q muet knau too) that con maake uoua
work
lot ensier lt alouss umu o conoet to NOous data
SOurces tronstorm data ooin nsiohts and ore otte morssive
reparts ond ttte eHS
DoWNLOAD PoweR BI DesKTOP
LA. Direct Doontoac rom Microasottis wehsite
O visit the Power eL Desktop courlaad pa0e.
O Select tepaLInload Eree? and chogse mour prefered
Language
o Download #the onprapiote version for our sustem
arohitecture (XRG Or xG4)
2 DonLAad vio B_Sevioe
Pou)er
o Loo in to the Power eL Serviee
O ciok the dounlOad ieon at tine ton rioht and select Doe)er
R Deskton" from the drondoun memu
Galaxy F15 5G
Institute of Engineering & Science
oe, Skil
IPSACADEMY
INSTALL PoweR BI DeskOP A
Re
Reun the. nstaller
Once he dauonlaad is camplete locate the instaler
le (usuay in Qur douonloads fololer) ond dowhle -aiok it
tOUn
2. Accept the License AQreement -
Read through and accept the microcoft SoftuoQre Lcen
Se Térms
y checking the bax Qnd clicking-
eNext"
3 Choose the lmstoll ation Locattion
Select the destination folder tor the installation The
defoult lbcalion is usualy tine but ou can change it it
4. Comolete the [Link]
eick (nstoa? to
begin the processThs may take a tevo
ainues, Once done eliek Finish
PoweR BI INTEREACe
Exolore Sample Data , Poeer Bl desktoo comes with samole
dota that yo Can use to ora ctice on and get tamiliar
with the intertoce and featuree
o Connect to YQur Data
usin0 the Get Dato" butto
Home toh 0u nthe
can connecb to uour
Excel
Qun data SOurceS hke
files SOL dotabQses or clouc services
Galaxy F15 5G
Institute of Engineering & Science
IPS ACADEMY
edge. SRiN,S
o Creaing Reports ; Use the CReport
cm
vieu"to Create
and crop ields
visualizahons and reports You drag
Arom the eepield nne to ereate diterent tpes o
charte Qndtoble
o Custbmeze Reports Customize uaucvisualizaaons using
the ngtiona avotlable in tne ee visuatzatons" pane
O Puhlchino Reports After ereabng uur reportsou con
Save them as opbix Ales To share. ur reporS puich
them to the Power e Service bu Clicking the ee pusish"
buton in the Home, tab. Then tollou Hhe prompts to ag in
and selet a orkspace
Galaxy F15 5G
ACAD Institute of Engineering & Science
IPSACADEMY
Skil
lodge
EXpeRIMeNT No, 2
sources and import doto into PoWer eI/
Connect to ditterent dato
Tobleou.
go
uou instoll Pouoer BLBesktoo lun ch the. appcatiorn
s
Once
nresented witho Pou)er
runnin an aur local comnputer You'ce
allowthe tutodoLtoct th o blonk convaC The
B) tutAriaL
reporte fOm JOur dato
AcCess the Get Doto" Funtion
the Get
Open youc power Bi/Tobleou appicotion and locate
Dota" ooon in the nbbon or navigarian panel
D Select dOto SOUrce
avoiloble doto sourees chonse the tupe, of dota
Fram the ist o
connect to EXCel fle SQL Server dotooasee
uOu w Ont to eo.
Cus ile.
Google Analytics
Provde coronection detoils -
on the data SOuroe uoumioht need to entera
|Depending
in fornnotton uke server addree dtabse nme USename
oaSsMOroor Ale Dath
Connet and Previeo dota -
click connect to et estobtisb the connection annceview
the avoulable cata tablea anc oolumng
GalaxyF5-56
GADS Institute of Engineering & Science
IPSACADEMY
Medge. Skil
LOad data
Power BIproject
Selest Load" to inaport the dota into tyaur
creating vioualizotiane
yastart
Examples of data Sources can Conneot to PoAer R and
Tabloau
> Ale- Bosed -Excel CSv Text Fles poE
> Relotianol Datahases - SQL Seuer My SQl Oracle,[Link]
Clud Serviceg - Salesforee Gaggle Analutia Azure SQL
DotabAse
> APlS - Web APls ResTAPls
> Social Meda - Toitter Facebook an
nstogram.
Galaxy F15 5G
CADE
Institute of Engineering & Science
age. s
IPSACADEMY
ExpeRIMeNT No 3
Pectorm data cleaning and trangtomoton S0male dataet..
To petom data cleonino and trans tomatiaY on Q sample
dotaset in
Power BI uou con wse the Pouer (Quer, editor to
denti ond oddresa issuses ike miesino values incorret
olata tpes duplioates inconeistent tnrmotting and owera
then eshape the cdota s needed by com bining splthng
adding new calumna hased on existiag data taithio the dataset
o Access Pouwer Quer, Eitor
Once uour dota is loaced cick ceTcanstorm Dota" in the ome
mbbon to open the Poer Qe ry Editor
o tHandle Mising Values
>\den ty columns wito onaicsin o volue by Iaoking tor blonk
Cells.
>use the e Rerlce Values" otion to ether Allio
missing value
wnt a specic volue arcemoNecogOI miesno Nolue
• Check Datn Tpes
>chek each co)umn has the conret
f
data tine (Hext number
doto ete)
Change dota types using theData Type" dnpdoon menu it
meeded,
Remove Dupcotes
Go to the "Home" tab and olhok Remave oLim
Dunlioates to
Galaxy F15 5G
ACAD
Institute of Engineering & Science
IPS ACADEMY
nce Wedge, Sil,
inote cuaicote rou0g
Split Columns
ect RQ single column cantaina mnulhple values sepaoied by Q
delimiter use the "Split column hu Delimiter" aption to create
meo colunn S.
• Combine Columns
Use the Meroe Column Option to combine doto from mutinle
colums ioto a
cingle
Creatte Coleuloted Colunns
>Ad ne columhs oth caleuloted Uoues ASing tormulas based
ing
Cn exstino cdoa
> example caculate TOtal eales" by multiping auanti'" with
• Sort Dota
Sort data by a speciho column o arronge cous io aseen
descending Qrder
aing- or
cilter ota
Appy
Altere to select speciie subseta ndata baaed on
certain criterio
Galaxy F15-56