[et_\u200bpb_\u200bsection fb_built=\u201c1\u201d _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d da_disable_devices=\u201coff|off|off\u201d global_\u200bcolors_\u200binfo=\u201d{}\u201d da_is_popup=\u201coff\u201d da_exit_intent=\u201coff\u201d da_has_close=\u201con\u201d da_alt_close=\u201coff\u201d da_dark_close=\u201coff\u201d da_not_modal=\u201con\u201d da_is_singular=\u201coff\u201d da_with_loader=\u201coff\u201d da_has_shadow=\u201con\u201d][et_pb_row _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201c4_4\u201d _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d hover_enabled=\u201c0\u201d global_\u200bcolors_\u200binfo=\u201d{}\u201d sticky_enabled=\u201c0\u201d]<\/p>\n
In a pre\u00advi\u00adous blog we dis\u00adcussed how to move an exist\u00ading data ware\u00adhouse envi\u00adron\u00adment to the cloud and start new devel\u00adop\u00adment next to it.<\/p>\n
At Islet, the focus is pri\u00admar\u00adi\u00adly on devel\u00adop\u00ading a new data and ana\u00adlyt\u00adics envi\u00adron\u00adment direct\u00adly in the cloud using cloud-native tools.<\/p>\n
How\u00adev\u00ader, there are a large num\u00adber of On-Premis\u00ades envi\u00adron\u00adments where the obsta\u00adcle to cloud adop\u00adtion is too sig\u00adnif\u00adi\u00adcant an invest\u00adment in the cur\u00adrent envi\u00adron\u00adment. In this case, it\u2019s a big advan\u00adtage if part of the old solu\u00adtion can be par\u00adtial\u00adly moved to work in the new cloud envi\u00adron\u00adment. Nor\u00admal dai\u00adly oper\u00ada\u00adtions can con\u00adtin\u00adue unin\u00adter\u00adrupt\u00aded, and after that, new devel\u00adop\u00adment can be tar\u00adget\u00aded at cloud-native technologies.<\/p>\n
In addi\u00adtion to data ware\u00adhous\u00ading and data inte\u00adgra\u00adtions, the over\u00adall solu\u00adtion also includes data mod\u00adel for report\u00ading and the actu\u00adal reports. Now we will go through new fea\u00adtures that also enable cen\u00adtral\u00adized inte\u00adgra\u00adtion of these into Microsoft\u00ad\u2019s Pow\u00ader BI service.<\/p>\n
New migra\u00adtion oppor\u00adtu\u00adni\u00adties have been intro\u00adduced into Microsoft\u00ad\u2019s Pow\u00ader BI ser\u00advice, allow\u00ading migra\u00adtion of data mod\u00adels (AAS) and reports (SSRS). Addi\u00adtion\u00adal\u00adly, Microsoft\u00ad\u2019s Pow\u00ader Plat\u00adform offers alter\u00adna\u00adtives to tra\u00addi\u00adtion\u00adal meth\u00adods, sim\u00adpli\u00adfy\u00ading the devel\u00adop\u00adment and man\u00adage\u00adment of the data and ana\u00adlyt\u00adics environment.<\/p>\n
<\/p>\n
Microsoft is clear\u00adly com\u00admit\u00adted to help\u00ading their cus\u00adtomers trans\u00adfer to cloud envi\u00adron\u00adments and is strong\u00adly sup\u00adport\u00ading the cen\u00adtral\u00adiza\u00adtion of data stor\u00adage under one ser\u00advice (Fab\u00adric \/ Pow\u00ader BI).<\/p>\n
In addi\u00adtion to these, data col\u00adlec\u00adtion forms and pro\u00adgrams oper\u00adat\u00ading on-premis\u00ades envi\u00adron\u00adments can be replaced with Pow\u00ader Plat\u00adfor\u00adm\u2019s Pow\u00ader Apps products.<\/p>\n
<\/p>\n
SQL Serv\u00ader Analy\u00adsis Ser\u00advices mod\u00adels have long served as the pri\u00adma\u00adry sources for report\u00ading in Microsoft\u00ad\u2019s data and ana\u00adlyt\u00adics (data ware\u00adhouse) envi\u00adron\u00adment. Cloud adop\u00adtion of these mod\u00adels to Azure Analy\u00adsis Ser\u00advices has been pos\u00adsi\u00adble for some time, but now cen\u00adtral\u00adiz\u00ading these mod\u00adels into the Pow\u00ader BI ser\u00advice is possible.<\/p>\n
Sev\u00ader\u00adal steps are required for suc\u00adcess\u00adful migration:<\/p>\n
Migra\u00adtion is done in a straight\u00adfor\u00adward man\u00adner, and the nec\u00ades\u00adsary actions are guided:<\/p>\n
With each migra\u00adtion, the mod\u00adel itself is over\u00adwrit\u00adten with the cur\u00adrent migrat\u00ading ver\u00adsion, so care should be tak\u00aden not to over\u00adwrite any\u00adthing that should not be over\u00adwrit\u00adten. The migra\u00adtion will indi\u00adcate if there are any fea\u00adtures in the mod\u00adel that the Pow\u00ader BI ser\u00advice\u2019s Analy\u00adsis Ser\u00advices mod\u00adel does not yet support.<\/p>\n
Once the mod\u00adel migra\u00adtion is suc\u00adcess\u00adful, the mod\u00adel can be used from the ser\u00advice. One note to add is that even if usage is already trans\u00adferred to the Pow\u00ader BI ser\u00advice, it\u2019s not advis\u00adable to delete the migrat\u00ading mod\u00adels. Instead, it\u2019s bet\u00adter to pause them \u2013 for at least the test\u00ading period.<\/p>\n
After\u00adward, you\u2019ll still need to switch the data sources to the new migrat\u00aded mod\u00adels and test the reports\u2019 functionality.<\/p>\n
<\/p>\n
Pre\u00advi\u00adous\u00adly devel\u00adoped reports may con\u00adtain tens or even hun\u00addreds of hours of work, mak\u00ading it sen\u00adsi\u00adble and pos\u00adsi\u00adble to uti\u00adlize these reports even when moved to the cloud, pro\u00advid\u00aded that the source is trans\u00adferred for report accessibility.<\/p>\n
A big deal is that, going for\u00adward, the migra\u00adtion and usage of pag\u00adi\u00adnat\u00aded reports (SSRS) no longer require a Pow\u00ader BI Pre\u00admi\u00adum work\u00adspace, so with\u00adout Pre\u00admi\u00adum capac\u00adi\u00adty or larg\u00ader licens\u00ades, these can be moved to the Pow\u00ader BI service.<\/p>\n
Before migra\u00adtion, it\u2019s advis\u00adable to read about the restric\u00adtions relat\u00aded to migrat\u00ading pag\u00adi\u00adnat\u00aded reports. The migra\u00adtion tool will noti\u00adfy you if there are prob\u00adlems dur\u00ading the migra\u00adtion, and these usu\u00adal\u00adly relate on some lev\u00adel to com\u00adpat\u00adi\u00adbil\u00adi\u00adty issues, mean\u00ading that the Pow\u00ader BI por\u00adtal may not sup\u00adport all features.<\/p>\n
Oth\u00ader\u00adwise, the migra\u00adtion process is quite sim\u00adple: Start\u00ading from SQL Serv\u00ader Report\u00ading Ser\u00advice 2017, an option has been added to the migra\u00adtion tool that allows reports to be pub\u00adlished direct\u00adly to the Pow\u00ader BI ser\u00advice. Using this option, reports can be pub\u00adlished to your own work\u00adspace in the Pow\u00ader BI service.<\/p>\n
<\/p>\n
At Islet, we aim to enhance our clients\u2019 use of data and ana\u00adlyt\u00adics envi\u00adron\u00adments through Microsoft\u00ad\u2019s Pow\u00ader Plat\u00adform. Pow\u00ader Plat\u00adform tools offer a lot of pos\u00adsi\u00adbil\u00adi\u00adties\u2009\u2014\u2009the biggest part being the wide\u00adly known Pow\u00ader BI with its exten\u00adsive and well-known mod\u00adel\u00adling and report\u00ading capa\u00adbil\u00adi\u00adties. In addi\u00adtion to this, Microsoft\u00ad\u2019s Pow\u00ader Plat\u00adform has proven itself as an effec\u00adtive pack\u00adage, enabling the devel\u00adop\u00adment of small to large appli\u00adca\u00adtions as well as the cre\u00adation of integrations.<\/p>\n
Per\u00adson\u00adal\u00adly, the most exit\u00ading use case has been enabling data input and man\u00adage\u00adment for end-users with\u00adin data and ana\u00adlyt\u00adics envi\u00adron\u00adments. Pow\u00ader Apps offers exten\u00adsive inte\u00adgra\u00adtion pos\u00adsi\u00adbil\u00adi\u00adties and can be con\u00adnect\u00aded to mul\u00adti\u00adple dif\u00adfer\u00adent sources as the base for the appli\u00adca\u00adtion. This makes it even more appeal\u00ading for this pur\u00adpose because it allows users to see infor\u00adma\u00adtion from a data ware\u00adhouse, based on which they can save entries to anoth\u00ader data source.<\/p>\n
Pre\u00advi\u00adous\u00adly, Excels have served as the spear\u00adhead for this kind of data man\u00adage\u00adment. How\u00adev\u00ader, gen\u00ader\u00adal\u00adly speak\u00ading, Excels are prone to break down if made avail\u00adable to a large user base\u2009\u2014\u2009not to men\u00adtion issues relat\u00aded to val\u00adi\u00adda\u00adtions, data refresh\u00ading with\u00adin the Excel, and using Excels as a data source. Regard\u00adless of the use case among those pre\u00advi\u00adous\u00adly men\u00adtioned, a cat\u00ada\u00adstroph\u00adic fail\u00adure is inevitable at some point, requir\u00ading sev\u00ader\u00adal hours or days to resolve.<\/p>\n
<\/p>\n
We hope this blog series on the pos\u00adsi\u00adbil\u00adi\u00adties of mov\u00ading to the cloud has sparked some thoughts. If you\u2019ve ever con\u00adsid\u00adered migrat\u00ading your data and ana\u00adlyt\u00adics envi\u00adron\u00adment to the cloud or devel\u00adop\u00ading a new data and ana\u00adlyt\u00adics envi\u00adron\u00adment, please feel free to con\u00adtact us!<\/p>\n
Up next, we will be dis\u00adcussing things relat\u00aded to Fab\u00adric, Pow\u00ader BI, and Pow\u00ader Apps\u2009\u2014 so stay tuned!<\/p>\n
<\/p>\n
Best regards,<\/p>\n
Mikko and Ilkka<\/p>\n
<\/p>\n