tutorial_ facebook analytics using power bi desktop – microsoft power bi

11/4/2015 Tutorial:FacebookanalyticsusingPowerBIDesktopMicrosoftPowerBI

https://support.powerbi.com/knowledgebase/articles/461312tutorialfacebookanalyticsusingpowerbideskto 1/22

Tutorial: Facebook analytics using PowerBI DesktopPowerBIDesktop(/knowledgebase/topics/68530powerbidesktop)

InthistutorialyoulearnhowtoimportandvisualizedatafromFacebook.Duringthetutorialyou'lllearnhowtoconnecttoaspecificFacebookpage(thePowerBIpage),applydatatransformationsteps,andcreatesomevisualizations.

Herearethestepsyou'lltake:

Task1:ConnecttoaFacebookPage

Task2:CreatevisualizationsusingtheReportview

Step1:CreateaTreemapvisualization

Task3:ShapedataintheQueryview

Step1:Splitthedatetimecolumnintotwo

Step2:Addanaggregatevaluefromarelatedtable

Task4:CreateadditionalvisualizationsusingtheReportview

Step1:Loadthequerytoyourreport

Step2:CreateaLinechartandaBarchart

Task 1: Connect to a Facebook pageInthistaskyouimportdatafromtheMicrosoftPowerBIFacebook(https://www.facebook.com/microsoftbi)site(here'stheURL:https://www.facebook.com/microsoftbi).

Anyonecanconnecttothatpage,andfollowthesestepsnospecialcredentials(otherthanyourownFacebookaccount,whichyouuseinthisstep)arerequired.

Microsoft Power BI SupportGethelpandsupportforPowerBI

PowerBIDesktop(/knowledgebase/topics/68530powerbidesktop)PowerBIDesktopHelp(/knowledgebase/articles/567183powerbidesktophelp)

What'snewinthelatestPowerBIDesktopupdate?(/knowledgebase/articles/489224whatsnewinthelatestpowerbidesktopupdate)

GetPowerBIDesktop(/knowledgebase/articles/464158getpowerbidesktop)

GettingstartedwithPowerBIDesktop(/knowledgebase/articles/471664gettingstartedwithpowerbidesktop)

PowerBIDesktopvideos(/knowledgebase/articles/461292powerbidesktopvideos)

ImportExcelworkbooksintoPowerBIDesktop(/knowledgebase/articles/703422importexcelworkbooksintopowerbidesktop)

Newandreturningusersmaysignin(/signin)

Sign up forPower BIGet started usingPower BI todayand begin creatinginsightful,interactivedashboards withinminutes.

Sign up



1. IntheGettingStarteddialogorintheHomeribbontab,selectGetData.

2. TheGetDatadialogappears,lettingyouselectfromallsortsofdatasources.SelectFacebookfromtheOthergroup.

ConnecttodatainPowerBIDesktop(/knowledgebase/articles/471635connecttodatainpowerbidesktop)

DatasourcesinPowerBIDesktop(/knowledgebase/articles/471643datasourcesinpowerbidesktop)

UseDirectQueryinPowerBIDesktop(PreviewFeature)(/knowledgebase/articles/755139usedirectqueryinpowerbidesktoppreviewfeatu)

AnalysisServicesTabulardatainPowerBIDesktop(/knowledgebase/articles/665278analysisservicestabulardatainpowerbidesktop)

ReportViewinPowerBIDesktop(/knowledgebase/articles/461283reportviewinpowerbidesktop)

TipsandtricksforcreatingreportsinPowerBIDesktop(/knowledgebase/articles/464157tipsandtricksforcreatingreportsinpowerbid)

PublishfromPowerBIDesktop(/knowledgebase/articles/461278publishfrompowerbidesktop)

QueryoverviewinPowerBIDesktop(/knowledgebase/articles/471646queryoverviewinpowerbidesktop)

ShapeandcombinedatainPowerBIDesktop(/knowledgebase/articles/471644shapeandcombinedatainpowerbidesktop)

CommonquerytasksinPowerBIDesktop(/knowledgebase/articles/471648commonquerytasksinpowerbidesktop)

Tutorial:AnalyzingsalesdatafromExcelandanODatafeed(/knowledgebase/articles/471597tutorialanalyzingsalesdatafromexcelandano)

DataViewinPowerBIDesktop(/knowledgebase/articles/663202dataviewinpowerbidesktop)

RelationshipViewinPowerBIDesktop(/knowledgebase/articles/663229relationshipviewinpowerbidesktop)

CreateandmanagerelationshipsinPowerBIDesktop(/knowledgebase/articles/464155createandmanagerelationshipsinpowerbideskto)



WhenyouselectConnect,adialogappearstoalertyoutotherisksofusingathirdpartyservice.

3. WhenyouselectContinue,theFacebookdialogboxappearswhereyoucanpastethepagename(microsoftbi)intotheUsernametextbox.SelectPostsfromtheConnectiondropdown.

4. ClickOK.5. Whenpromptedforcredentials,signinusingyourFacebookaccount

andallowPowerBIaccessthroughyouraccount.

Afterestablishingaconnectiontothepage,youwillseethedatabeingloadedinthemodel.

CalculatedcolumnsinPowerBIDesktop(/knowledgebase/articles/590598calculatedcolumnsinpowerbidesktop)

MeasuresinPowerBIDesktop(/knowledgebase/articles/554577measuresinpowerbidesktop)

DatatypesinPowerBIDesktop(/knowledgebase/articles/558030datatypesinpowerbidesktop)

DatacategorizationinPowerBIDesktop(/knowledgebase/articles/594282datacategorizationinpowerbidesktop)

SortbycolumninPowerBIDesktop(/knowledgebase/articles/592116sortbycolumninpowerbidesktop)

CalculatedtablesinPowerBIDesktop(/knowledgebase/articles/741510calculatedtablesinpowerbidesktop)

Tutorial:ImportingandanalyzingdatafromaWebPageusingPowerBIDesktop(/knowledgebase/articles/461315tutorialimportingandanalyzingdatafromaweb)

DAXbasicsinPowerBIDesktop(/knowledgebase/articles/554619daxbasicsinpowerbidesktop)

Tutorial:FacebookanalyticsusingPowerBIDesktop(/knowledgebase/articles/461312tutorialfacebookanalyticsusingpowerbideskto)

Tutorial:CreateyourownmeasuresinPowerBIDesktop(/knowledgebase/articles/556656tutorialcreateyourownmeasuresinpowerbides)

Tutorial:CreatecalculatedcolumnsinPowerBIDesktop(/knowledgebase/articles/590610tutorialcreatecalculatedcolumnsinpowerbide)

Thirdpartyservice:GoogleAnalyticsconnectorforPowerBIDesktop(/knowledgebase/articles/591699thirdpartyservicegoogleanalyticsconnectorfo)

Thirdpartyservice:FacebookconnectorforPowerBIDesktop(/knowledgebase/articles/571845thirdpartyservicefacebookconnectorforpower)

ProjectOnline:connecttodatathroughPowerBIDesktop



Fromthere,QueryEditordisplaysthedata.QueryEditorispartofPowerBIDesktop,butloadsinaseparatewindow,andiswhereyouperformallyourtransformationsonyourdataconnections.

Whenyourdataishowyouwantit,youcanloaditintoPowerBIDesktop.SelectLoad&ClosefromtheHomeribbon.

(/knowledgebase/articles/495096projectonlineconnecttodatathroughpowerbid)

ImportanddisplayKPIs(Preview)(/knowledgebase/articles/751896importanddisplaykpispreview)

PyramidAnalytics(/knowledgebase/articles/729417pyramidanalytics)

Contactsupport(https://support.powerbi.com/knowledgebase/articles/436810)

Givefeedback(/forums/265200powerbi)

BIinSQLvNext(/forums/282523biinsqlvnext) 178

DeveloperAPIs(/forums/268152developerapis) 45

PowerBI(/forums/265200powerbi) 1,824

KnowledgeBase(/knowledgebase)Gettingstarted(/knowledgebase/topics/63037gettingstarted) 17

Getdata(/knowledgebase/topics/63369getdata) 11

FilesinPowerBI(/knowledgebase/topics/88767filesinpowerbi) 7

ServicesinPowerBI(/knowledgebase/topics/88770servicesinpowerbi) 31

Databasesandmore(/knowledgebase/topics/88773databasesandmore) 6

Datarefresh(/knowledgebase/topics/107925datarefresh) 9

Allaboutdashboards(/knowledgebase/topics/65158allaboutdashboards) 14

Allaboutreports(/knowledgebase/topics/65157allaboutreports) 19

Search



You'llseeadialogthatdisplaystheprogressofloadingthedataintothePowerBIDesktopdatamodel.

Onceloaded,youllbetakentotheReportviewwherethecolumnsfromthetablearelistedintheFieldlistontheright.

Visualizationsinreports(/knowledgebase/topics/65160visualizationsinreports) 29

Q&AinPowerBI(/knowledgebase/topics/70394qainpowerbi) 6

GroupsinPowerBI(/knowledgebase/topics/101158groupsinpowerbi) 5

PowerBIDesktop(/knowledgebase/topics/68530powerbidesktop) 36

MobileappsforPowerBI(/knowledgebase/topics/72969mobileappsforpowerbi) 1

iPadapp(PowerBIforiOS)(/knowledgebase/topics/77999ipadapppowerbiforios) 10

iPhoneapp(PowerBIforiOS)(/knowledgebase/topics/78002iphoneapppowerbiforios) 9

PowerBIappforWindows(/knowledgebase/topics/75729powerbiappforwindows) 9

PowerBIappforAndroidphones(/knowledgebase/topics/85887powerbiappforandroidphones) 8

Administrative(/knowledgebase/topics/63248administrative) 9

Troubleshooting(/knowledgebase/topics/65779troubleshooting) 11

Samples(/knowledgebase/topics/75672samples) 11

Topissuesandquestions(/knowledgebase/topics/106950topissuesandquestions) 4

Allarticles(/knowledgebase/articles/all)

(http://aka.ms/gettingstartedpowerbi)



Task 2: CreatevisualizationsusingtheReportviewNowthatyouhavelandedthedatafromthepage,youcanquicklyandeasilygaininsightsaboutyourdata,usingvisualizations.

Step1:CreateaTreemapvisualization

Creatingavisualizationiseasy,wejustdragafieldfromtheFieldlistanddropitontheReportcanvas.

DragthetypefieldontotheReportcanvas.PowerBIDesktopcreatesanewvisualizationintheReportcanvas.Next,dragtypefromFields(thesamefieldyoujustdraggedontotheReportcanvas)ontotheValueareatocreateaBarvisualization.



WecaneasilychangethetypeofvisualizationbyselectingadifferenticonfromtheVisualizationpane.Let'schangethetypetoaTreemapbyselectingitsiconfromVisualizations,asshowninthefollowingimage.

Next,let'saddalegend,thenchangethecolorofadatapoint.SelecttheFormaticonintheVisualizationspanetheFormaticonlookslikeapaintbrush.



WhenyouselectthedownarrownexttoLegend,thesectionexpandstoshowhowtocustomizethelegendfortheselectedvisualization.Inthiscase,wemadethefollowingselections:

movedtheLegendslidertoOnsoalegendwouldappearselectedRightfromtheLegendPositiondropdownmovedtheTitleslidertoOnaswell,soatitleforthelegendwillappeartypedintypeforthetitleofthelegend

Inthefollowingimage,thosesettingsarealreadymadeandreflectedinthevisualization.

Next,let'schangethecolorofoneofthedatapoints.Thelinkdatapointshouldbeblue,soit'sclosertothecommoncolorforhyperlinks.

SelectthearrownexttoDataColorstoexpandthatsection.Thedatapointsareshown,withselectionarrowsbesideeachcolorthatallowsustoselectadifferentcolorforeachdatapoint.



Whenyouclickonthecolorboxdownarrowbesideanydatapoint,acolorselectiondialogappears,lettingyouchooseyourcolor.Inthiscase,we'llchooselightblue.

That'sbetter.Inthefollowingimage,youcanseehowthecolorisappliedtothedatapointinthevisualization,andthatthelegendisalsoautomaticallyupdated,asisitscolorintheDataColorssection.



Task 3: Shape data in the tableNowthatyouhaveimportedthetableselectedandyoustarttovisualizeit,youmaynoticeyouneedtoperformvariousdatashapingandcleansingstepsinordertogetthemostoutofyourdata.

Step1:Splitthedatetimecolumnintotwo

Inthisstep,youwillsplitthecreated_timecolumntogetboththedateandtimevalues.Wheneveryou'reinPowerBIDesktopandyouwanttomodifyanexistingquery,youneedtolaunchQueryEditor.Todothat,selectEditQueriesfromtheHometab.



1. IntheQueryEditorgrid,scrolltotherightuntilyoufindthecreated_timecolumn

2. RightclickacolumnheaderintheQueryPreviewgrid,andclickSplitColumn>ByDelimitertosplitthecolumns.ChoseCustominthedelimiterdropdownandenterTNotethatthisoperationisalsoavailableintheHomeribbontab,intheManageColumnsgroup.



3. Renamethecreatedcolumnstocreated_dateandcreated_timerespectively.

4. Selectthenewcolumn,created_time,andintheQueryviewribbon,navigatetotheAddColumntabandselectTime>HourundertheFromDate&Timegroup.Thiswilladdanewcolumnthatisonlythehourcomponentofthetime.

5. ChangethetypeofthenewHourcolumntoWholeNumber,bynavigatingtotheHometabandselectingtheDataTypedropdownorbyrightclickingthecolumnandselectingTransform>WholeNumber.



Step2:Addanaggregatevaluefromarelatedtable

Inthisstep,youaddthecountofsharesfromthenestedvaluesothatyoucanuseitinthevisualizations.

1. Continuescrollingtotherightuntilyouseethesharescolumn.Thenestedvalueindicatesthatweneedtodoanothertransforminordertogettheactualvalues.

2. Inthetoprightofthecolumnheader,selectthe icontoopentheExpand/Aggregatebuilder.SelectcountandhitOK.Thiswilladdthecountofthesharesforeachrowinourtable.



Afterthedataloads,renamethecolumntosharesbydoubleclickingonthecolumnname,rightclickingthecolumnorintheQueryviewribbon,selectRenameundertheTransformtabandAnyColumngroup.

4. Finally,changethetypeofthenewsharescolumntoWholeNumber.Withthecolumnselected,thetypecanbechangedbyrightclickingthecolumnandselectingTransform>WholeNumberorbynavigatingtotheHometabandselectingtheDataTypedropdownor.

Querystepscreated

AsyouperformtransformationsintheQueryview,querystepsarecreatedandlistedintheQuerySettingspane,intheAPPLIEDSTEPSlist.EachquerystephasacorrespondingQueryformula,alsoknownasthe"M"language.



Task Querystep

Formula

ConnecttoaFacebooksource

Source Facebook.Graph

("https://graph.facebook.com/microsoftbi/posts")

SplitColumnstogetthevaluesyouneed

SplitColumnbyDelimiter

Table.SplitColumn

(Source,"created_time",Splitter.SplitTextByDelimiter("T"),{"created_time.1","created_time.2"})



ChangeTypeofthenewcolumns(automaticstep)

ChangedType

Table.TransformColumnTypes

(#"SplitColumnbyDelimiter",{{"created_time.1",typedate},{"created_time.2",typetime}})

Renameacolumn

RenamedColumns

Table.RenameColumns

(#"ChangedType",{{"created_time.1","created_date"},{"created_time.2","created_time"}})

Insertacolumn

InsertedHour

Table.AddColumn

(#"RenamedColumns","Hour",eachTime.Hour([created_time]),typenumber)

ChangeType

ChangedType1


(#"InsertedHour",{{"Hour",typetext}})

Expandvaluesinanestedtable

Expandshares

Table.ExpandRecordColumn

(#"ChangedType1","shares",{"count"},{"shares.count"})

Renamethecolumn

RenamedColumns1

Table.RenameColumns

(#"Expandshares",{{"shares.count","shares"}})

ChangeType

ChangedType2


(#"RenamedColumns1",{{"shares",Int64.Type}})

Task 4: Create additionalvisualizations using the Report viewNowthatwehaveconvertedthedataintotheshapethatweneedfortherestofouranalysis,wecanloadtheresultingtableintoourReportandcreateadditionalvisualizations.

Step1:Loadthequerytoyourreport



Inordertoloadthequeryresultstothereport,weneedtoselectLoad&ClosefromQueryEditor.ThiswillloadourchangesintoPowerBIDesktop,andcloseQueryEditor.

InPowerBIDesktop,weneedtomakesurewe'reinReportview.SelectthetopiconfromtheleftbarinPowerBIDesktop.

Step2:CreateaLinechartandaBarchart

Inordertocreateavisualization,wecandragfieldsfromtheFieldlistanddropthemintheReportcanvas.

1. DragthesharesfieldontotheReportcanvas,whichcreatesabarchart.Thendragcreated_dateontothechart,andPowerBIDesktopchangesthevisualizationtoaLineChart.



2. Next,dragthesharesfieldanddropitintheReportcanvas.NowdragtheHourfieldintotheAxissectionundertheFieldList.

3. WecaneasilychangethetypeofvisualizationbyclickingonadifferenticonintheVisualizationpane.ThearrowintheimagebelowpointstotheBarCharticon.



4. ChangethevisualizationtypetoBarChart.5. TheBarChartiscreated,buttheaxisisn'twhatwewantwewantit

sortedintheotherdirection(fromhightolow).SelectthedownarrownexttoYAxistoexpandthatsection.WeneedtochangethetypeofaxisfromContinuoustoCategorical,soit'llsorthowwewantit(theimagebelowshowstheaxisbeforewemaketheselectioncheckoutthesubsequentimageforhowwewantittolook).

That'sbetter.Andnowwehavethreevisualizationsonthispage,whichwecansizeaswewanttofillupthereportpage.



Asyoucansee,it'seasytocustomizevisualizationsinyourreport,soyoucanpresentthedatainthewaythatyouwant.PowerBIDesktopprovidesaseamlessendtoendexperiencefromgettingdatafromawiderangeofdatasourcesandshapingittomeetyouranalysisneedstovisualizingthisdatainrichandinteractiveways.Onceyourreportisready,youcanuploadittoPowerBI(http://support.powerbi.com/knowledgebase/articles/461278uploadpowerbidesignerfiles)andcreatedashboardsbasedonit,whichyoucansharewithotherPowerBIusers.

Youcandownloadtheendresultofthistutorialhere(http://download.microsoft.com/download/1/4/E/14EDED286C584055A65C23B4DA81C4DE/FacebookAnalytics.pbix)

WhereelsecanIgetmoreinformation?

ReadotherPowerBIDesktoptutorials(http://go.microsoft.com/fwlink/?LinkID=521937).

WatchPowerBIDesktopvideos.(http://go.microsoft.com/fwlink/?LinkID=519322)

VisitthePowerBIForum.(http://go.microsoft.com/fwlink/?LinkID=519326)

ReadthePowerBIBlog.(http://go.microsoft.com/fwlink/?LinkID=519327)



Wasthisinformationhelpful? Yes No

Sign up for Power BISign up for free or become a Pro User for even more storage and features.

Enter your work email address Use it free

By clicking Use it free, you agree to the Power BI Preview Terms of Service /termsofservice

Sign up

Insights are hiding in your company's data see the impact of bringing them into focus with Power BI.

Enter your work email address Use it free

By clicking Use it free, you agree to the Power BI Terms of Service /termsofservice

Downloads

Whether you are on the go or need to create rich,interactive reports, Power BI offers you the tools youneed.

POWER BI DESKTOP(HTTPS://POWERBI.MICROSOFT.COM/DESKTOP)



MOBILE(HTTPS://POWERBI.MICROSOFT.COM/MOBILE)

SEE ALL DOWNLOADS(HTTPS://POWERBI.MICROSOFT.COM/DOWNLOADS)

Legal

PRIVACY & COOKIES(HTTP://GO.MICROSOFT.COM/FWLINK/?LINKID=248681)

TERMS OF USE (HTTPS://WWW.MICROSOFT.COM/EN-US/LEGAL/INTELLECTUALPROPERTY/COPYRIGHT/DEFAULT.ASPX)

TRADEMARKS (HTTP://GO.MICROSOFT.COM/?LINKID=9851308)

Information

SUPPORT (HTTPS://SUPPORT.POWERBI.COM/)

DEVELOPERS(HTTPS://POWERBI.MICROSOFT.COM/DEVELOPERS)

BLOG (HTTP://WWW.MICROSOFT.COM/EN-US/POWERBI/BI-BLOG.ASPX)

NEWSLETTER(HTTPS://POWERBI.MICROSOFT.COM/NEWSLETTER)

DesignedandbuiltbythePowerBIDesignStudio(https://powerbi.microsoft.com/studio)

(https://twitter.com/MSPowerBI)(https://www.facebook.com/microsoftbi?fref=ts)(https://www.youtube.com/c/mspowerbi)

tutorial_ facebook analytics using power bi desktop – microsoft power bi

Documents