Microsoft Excel ndiye chida choyambirira cha ma code otsika, koma deta ndi malingaliro abizinesi mu Excel spreadsheet sizimayendetsedwa ndipo sizimagawidwa ndi ogwiritsa ntchito mabizinesi ena, kotero sizinthu zomwe zitha kugwiritsidwanso ntchito mosavuta kunja kwa spreadsheet. Deta mu nsanja ya data yogwiritsidwa ntchito ndi Power Platform ya Microsoft, Dataverse, ndiyolemera: Pali metadata yomwe imayika zinthu zamabizinesi monga ma adilesi a imelo, ma invoice ndi manambala oyitanitsa ndi tsatanetsatane wa zomwe ziyenera kukhala momwemo ndi zomwe bizinesi imachita nazo, kuphatikiza kuthandizira malingaliro abizinesi. , chilolezo, nzeru ndi analytics.
Pitani ku:
Makina opanga AI Power Apps Copilot atha kugwiritsidwa ntchito kale kupanga mapulogalamu mu Microsoft Dataverse pofotokoza m’chilankhulo chachilengedwe zomwe wogwiritsa ntchito akufuna kuti pulogalamuyo ichite. Mwachitsanzo, atha kufunsa Copilot kuti awonjezere zowonera, zowongolera ndi mawonekedwe pomwe akupeza malingaliro ambiri.
Excel to App ndi chida chatsopano chowoneratu chothandizira ogwiritsa ntchito kubweretsa zomwe ali nazo kale mumaspredishiti. Imachita ndendende zomwe dzinalo likunena: Ogwiritsa ntchito amatha kukoka ndikugwetsa zomwe sizinapangidwe kuchokera ku Excel – kapena kupatsa Copilot ulalo ku fayilo – ndipo Power Platform idzausanthula, kukulitsa ndi zina zowonjezera zomwe Dataverse ikufunikira, ndikuisintha kukhala pulogalamu. , Nirav Shah, wachiwiri kwa Purezidenti wa Dataverse ku Microsoft adafotokozera TechRepublic.
“Chifukwa ndi Power Apps Copilot-yothandizidwa, ikuwonetsa momwe tebulo liyenera kukhalira, liyenera kulitcha bwanji, mafotokozedwe otani, ndi mizati yotani yomwe ikuyenera kukhalapo komanso mitundu ya data yazazanjazi,” adatero Shah. “Powerengera (omwe ndi mndandanda wazinthu zomwe zingatheke), zimangopanga zokhazo zomwe zasankhidwa mu Dataverse schema yanu.”
Kupatsa deta yonse ya Excel nyumba yatsopano ku Dataverse ndikwabwino pakuwongolera deta.
“Kutenga zidziwitso zosayendetsedwa komanso nzika kunja uko zomwe sizikuyendetsedwa ndi bizinesi yonse ndikuzisintha kukhala mtambo woyendetsedwa bwino, wokonzedwa bwino ndi mfundo zovomerezeka, utsogoleri ndi chitetezo chomwe chingathe kukula momwe bizinesi ikufunikira ingathandize kuchepetsa mthunzi wa IT womwe umapezeka ponseponse. bizinesi, “adatero Shah.
Matebulo atsopano otanuka mu Dataverse amatha kunyamula ma data ambiri osalumikizana, mpaka kumeza mizere mamiliyoni ambiri pa ola limodzi.
Mabizinesi amagwiritsa ntchito kale zida kuti apeze “zonyamula” Excel spreadsheets zomwe ogwiritsa ntchito amadalira. Tsopano akhoza kuwalimbikitsa kuti abweretse deta yovutayi ku Dataverse komwe gulu la IT lingathe kubwezeretsa, kumasulira ndi kuyang’anira, ndipo ogwiritsa ntchito ena amalonda angagwiritse ntchito mwayi. Koma, Shah adanenanso kuti ogwiritsa ntchito payekha adzafunanso kubweretsa deta yawo ya Excel mu Power Platform kuti athe kugwiritsa ntchito zida kumeneko – monga chilankhulo chachilengedwe popanga mawonekedwe a pulogalamu yawo.
“Tikuganiza kuti izi zichotsa mikangano yambiri,” adatero Shah. “Zimapatsa anthu omwe akupanga zopanga zawo (ntchito mu Excel) ndi njira yopita patsogolo kuti awone luso lotheka ndi kulemera komwe Dataverse mu Power Platform ingawapatse.
“Dataverse ndiye kumbuyo komweko komwe kumalumikizana ndi Power Platform yonse ndikupanga kusintha kuchokera ku Excel, kulemera ndi kuthekera komwe tili nako kudutsa Power Platform yonse. Mfundo yoti mutha kuchita izi mkati mwa mphindi imodzi imachotsa zolepheretsa kuti opanga ayambe kugwiritsa ntchito zambiri zomwe zili mkati mwa Dataverse pamwamba pa datayo. ”
Zida zatsopano zoyendetsedwa ndi AI mu Dataverse
Deta mu Excel itha kukhala yosavuta kwa ogwiritsa ntchito payekhapayekha, koma kuibweretsa ku Dataverse kumalumikiza ndi zida zatsopano za AI.
Power Virtual Agent chatbots
Zomwe zili mu Dataverse, zimapezeka kuti ma chatbots a Power Virtual Agents agwiritse ntchito, kuphatikiza ogwiritsa ntchito a Teams bots tsopano atha kupanga. Ngati wogwiritsa ntchito asunga mndandanda wazinthu zamakampani monga ma projekiti ku Excel ndikubweretsa izo ku Dataverse m’malo mwake, zitha kukhala gawo la ma chatbot omwe amathandiza antchito atsopano kudziwa momwe angachitire zinthu, pamodzi ndi zida zovomerezeka za kampani ya HR.
Mabotolowa amatha kugwiritsa ntchito Azure Open AI Service kuti ayambe kuyankha mafunso omwe adayambitsa bot sanawapange kuti agwire. Mwachitsanzo, ngati wina awonjezera mahedifoni a VR ndi HoloLens pamndandanda wazinthu, amatha kuuza Copilot kuti awaphatikize mu pulogalamuyi, ndipo bot ikhoza kuyankha mafunso okhudza iwo popanda wolemba bot kuwonjezera izi pamanja.
Zida Zamagulu za Visual Studio ndi Visual Studio Code
Teams Toolkit ya Visual Studio ndi Visual Studio Code imathandizira kupanga mapulogalamu a Matimu omwe amagwiritsa ntchito Adaptive Cards ngati mawonekedwe mkati mwa Matimu. Pamodzi ndi mapulagini a ChatGPT omwe Bing akuyimira pa macheza ake a AI ndi zolumikizira za Power Platform, mauthenga owonjezera a Teams omwe atha kupangidwa ndi Teams Toolkit azigwira ntchito ngati mapulagini a Microsoft 365 Copilot – zida za AI zomwe zikubwera kuofesi ndi ntchito za Office, yomwe idzakhala ndi mwayi wopeza deta kuchokera ku Dynamics 365 ndi Power Platform yosungidwa mu Dataverse.
Ngati mukufuna kuchita zinazake nthawi zokwanira, zingakhale zomveka kupanga pulogalamu mu Power Apps kuti muchite. Kapena data ikangopezeka mu Dataverse, zitha kukhala zosavuta kungofunsa Copilot kuti apereke zosintha pamipata yabwino kwambiri yogulitsira kapena mndandanda wamakasitomala omwe akutsogola kwambiri sabata yatha. Koma ogwiritsa ntchito sayenera kusankha monga mapulogalamu opangidwa pogwiritsa ntchito Power Apps Copilot ali ndi Copilot mkati mwake, kotero amatha kufunsa Wothandizira kuti achite zinthu mkati mwa pulogalamuyi.
Zida zaukhondo wa data
Tsopano popeza ndikosavuta kugwiritsa ntchito zomwe zili mu Dataverse ya AI zomwe Shah amachitcha “mapulogalamu oyendetsedwa ndi data,” ndikofunikira kuti ikhale yoyera, yokwanira komanso yolondola. Izi zikutanthauza kuti iyenera kukhala ndi zambiri zamakasitomala popanda mizere yosowa mu ma adilesi ndi zonse zolondola pa invoice. Zida zatsopano zaukhondo za AI zoyendetsedwa ndi data mu Dataverse zimachepetsa ndikutsimikizira deta mwanzeru pazinthu monga ma adilesi a imelo ndi ma URL, komanso ma adilesi enieni.
“Dataverse ili ndi mtundu wa data wa semantic wokhala ndi chidziwitso chozama cha zomwe mtengo wake umakhala wa maimelo ndi ma adilesi chifukwa awa ndi mitundu ya data yokhazikika, kotero imatha kupereka zochulukirapo potengera kutsimikizika kwa data,” adatero Shah.
Kuyeretsa ndikusintha deta ndichinthu chomwe ogwiritsa ntchito amabizinesi sangaganize kuchita, chifukwa chake kukhala ndi nsanja kumawathandiza kupeza zotsatira zabwino.
“Tikufuna kufewetsa ndikupangitsa kuti opanga azitha kupeza zambiri zamakina apamwamba kwambiri mudongosolo kuti zidziwitso, kugwiritsa ntchito, njira zamabizinesi zikupereka phindu lochulukirapo kwa ogwiritsa ntchito omwe akugwiritsa ntchito ndi njira zomwe opanga akumanga. pamwamba pa dongosolo,” adatero Shah.
ONANI: Tsamba lachinyengo la TechRepublic la kuyeretsa deta
Momwe opanga ma code otsika angagwiritsire ntchito Power Fx ndi Dataverse
Opanga ma code otsika amathanso kugwiritsa ntchito chilankhulo cha Power Fx, chomwe chidzadziwika kwa aliyense amene adapanga ntchito za Excel, kuti alembe zovomerezeka zawo pazochita zilizonse nthawi yomweyo kapena zomwe akufuna – kapena kupanga mapulagini ena ogwiritsidwanso ntchito pamalingaliro abizinesi ndi Dataverse. malamulo okhala ndi zoyambitsa ndi zochita zomwe zimagwira ntchito ndi zolumikizira za Power Platform ndi ma API a pa intaneti.
“Izi ndi njira zochepa zopangira malingaliro abizinesi ndikuphatikiza izi mu dongosolo popanda kupita ku chitukuko chokwanira cha .NET,” adatero Shah. “Mutha kuyambitsa zolemba zina zomwe zidapangidwa kapena kusinthidwa mkati mwadongosolo ndikuwongolera zomwe mukufuna kuti zichitike pogwiritsa ntchito Power Fx kuyimbira ma API ena mkati mwa Dataverse kuti mulumikizane ndi zina zomwe zili mudongosolo kapena kuyitanitsa zolumikizira zathu za Power Platform. (ku magwero ena a deta) kukonza malingaliro amenewo kapena kupanga ma API atsopano pogwiritsa ntchito Power FX ndikuwulula zomwe zingagwiritsidwe ntchito pa chilichonse chomangidwa pamwamba pa Dataverse.”
Izi zitha kutumiza imelo kwa makasitomala omwe amawathokoza chifukwa cha madongosolo awo kapena kubwereza chilichonse chomwe ogwiritsa ntchito angachite ndi njira yosungidwa ya SQL, koma azichita mwachindunji kuchokera ku Dataverse, m’malo mongofuna kudziwa momwe angapangire database ya SQL.
Ogwiritsa ntchito amatha kupanga kale malingaliro olemera abizinesi pazochitika ndi zochita mu Dataverse, koma izi zimathandizira kumanga popanda kuchita ntchito zambiri zachitukuko.
“Tachotsa zopinga zambiri zolowera ndikupangitsa kuti zikhale zosavuta komanso zosavuta kugwiritsa ntchito zomangira zomwe zilipo kale m’dongosolo,” Shah adapitilizabe. “Ikutengera momwe zinthu zilili m’malo omwe tili nawo komanso ma data kuti zikhale zosavuta komanso zachangu kuti opanga awonjezere malingaliro abizinesi mudongosolo.”
Kugwiritsa ntchito SQL ndi Dataverse
Dataverse ndi yochulukirapo kuposa nkhokwe ya SQL, koma opanga omwe amadziwa kale kugwiritsa ntchito SQL kulemba mafunso kuti afufuze, kusefa, kuphatikiza, kupanga, kujowina ndi gulu lamagulu atha kugwiritsa ntchito mkonzi watsopano wa SQL mu Power Apps Studio kuti agwiritse ntchito. Mafunso a SQL motsutsana ndi matebulo a Dataverse.
Izi ndizothandiza chifukwa zikutanthauza omwe akupanga database omwe alipo sayenera kuphunzira njira yatsopano yofunsira deta, koma ukadaulo womwewo ndi momwe Microsoft Copilots yosiyana ingagwirire ntchito ndi dataverse.
“Kuseri kwa zochitikazo, zomwe tikuchita ndikusintha funsolo kuchokera ku chithunzi chomveka chomwe chimawonetsedwa kudzera mu metadata mu Dataverse kupita ku malo osungira omwe tili nawo mu Dataverse,” adatero Shah. “Ilinso gawo lofunikira pa momwe timathandizira zochitika zambiri za Copilot zomwe zimamangidwa pamwamba pa Dataverse.
“Kutha kwa ife kutenga chilankhulo chachilengedwe ndikumasulira kuti mufunso lokhazikika lomwe lingayende molingana ndi wogwiritsa ntchito, ndi chitetezo chawo komanso malamulo ovomerezeka akugwira ntchito kwa iwo, kuti athe kuyankha mafunso achilankhulo chachilengedwe a Power App. Copilot, ndi Ma Copilots ena kudutsa Microsoft ecosystem alidi, pachimake, mothandizidwa ndi thandizo lathu pafunso la SQL pamwamba pa Dataverse. ”
Apanso, izi zimathandiza opanga odziwa ntchito kuti azigwira ntchito mwachangu, Shah adanenanso.
“Opanga akatswiri sayenera kumanga ndikuyika zidutswa zonse pamodzi,” adatero Shah. “Chifukwa tili ndi chidziwitso chimenecho, chifukwa tili ndi kulumikizana komweko ku Power Platform ecosystem, timatha kulumikiza madontho okha, kuti athe kupanga zokumana nazo za Copilot za pulogalamuyo m’njira yosinthira ndikutulutsa phindu. kwa ogwiritsa ntchito awo mwachangu, mosavuta, kusiyana ndi kuwononga nthawi kuti adzipangire okha chikwatu chimenecho. ”
ONANI: Momwe mungafunse matebulo angapo mu SQL mu phunziro ili la TechRepublic
Kuteteza deta kudzera pa Microsoft Dataverse
Ndi deta yofunika kwambiri mu Dataverse, mabungwe angakhale akufunafuna njira zowonjezera chitetezo. Ngati wogwiritsa ntchito amayang’anira makiyi awo obisala mu Azure Key Vault, atha kugwiritsa ntchito njira iyi ya Bweretsani Own Key ndi Dataverse. Athanso kuchepetsa mwayi wofikira kutengera adilesi ya IP pafupifupi munthawi yeniyeni ndi chowotcha moto chatsopano cha IP chomwe chimalola gulu lachitetezo kusankha ma IP omwe ogwiritsa ntchito angalumikizane nawo.
Ngati wina ayesa kuchitapo kanthu movutikira monga kufufuta akaunti yake – yomwe ingakhale yovomerezeka koma anganenenso kuti akaunti yawo yalandidwa ndi wowukira – Azure Active Directory kuunikira kopitilira muyeso kumayang’ana momwe akauntiyo imatsimikizidwira komanso komwe ikulumikizidwa. . Ngati wogwiritsa ntchito asamukira ku adilesi ina ya IP popita kunyumba kapena makina awo akuwoneka ngati akulumikizana kuchokera kumalo osadziwika, ndipo sali pamtundu wa IP wololedwa, pempho lawo lidzaletsedwa, ngakhale anali atalowa kale ndipo nthawi zambiri amakhala amaloledwa kuchita.
“Ogwira ntchito ali kutali kwambiri komanso osakanizidwa ndipo akuyenda padziko lonse lapansi m’njira zomwe sizinachitikepo kale,” adatero Shah. “Ngati simukufuna kuti ogwiritsa ntchito alowe nawo malo ogulitsira khofi mumsewu, kapena mukufuna kuwasunga pamanetiweki, IP firewall imapereka njira, chitetezo china chakuzama kwa anthu kuti ateteze zida zawo ndikuteteza chitetezo chawo. chuma chamtengo wapatali, chomwe ndi data yawo. ”
Ndondomeko ya zomwe ogwiritsa ntchito amaloledwa kuchita ndi datayo ikhoza kukhala yosiyana kutengera dipatimenti yomwe amagwirira ntchito, ndipo tsopano ikhoza kusintha ndi malo omwe akugwira ntchito.