Category: News
Spatial Workflows in Azure Database for PostgreSQL – Flexible Server
How do you benefit from spatial data?
Spatial data is an important component to any data-driven decision. It not only shows the location of a real-world asset, but it also helps to paint the picture of how that asset is impacted by its surroundings. Many everyday questions are answered by analyzing data based on location and proximity to other locations.
Enterprises that own and manage land may want to not only store the correct outline of a property as a polygon but also manage revenue or make risk-based decisions given the location of the property.
A transportation company will want to know the progress of its truck fleet at any given time. Estimating the time of delivery and solving for last mile logistics.
A telecommunications company may want to assess the impact of weathering on its equipment, or the estimated customer reach given the topology of the land on which the tower is located.
Or a tourist visiting a large city may want to choose the location of their lodgings based on proximity to landmarks and transportation.
Analysis involving spatial data impacts any enterprise or organization that owns, maintains, or manages physical assets.
However, working with spatial data can have its challenges. From different types of spatial representations to spatial reference considerations to availability of analytical functionality. Many solutions make it possible to work with spatial data, but they often focus on one aspect, or one set of workflows and it can be daunting to pick the right solution for your workflow.
How do you use PostGIS to work with spatial data?
Over the years, PostgreSQL has been a crucial part of many spatial workflows, primarily because of the extensive set of spatial capabilities available through the PostGIS extension. Created over 20 years ago, the extension kept growing in capabilities as the needs of the spatial market evolved. It allows for representation of data as points, lines and polygons, in two spatial data types.
Beginning with the st_geometry spatial type, which allows for persistence of points, lines and polygons projected to a flat surface such as a map or a monitor screen. It includes the standard set of spatial references and the ability to reproject between them, along with spatial indexes and extensive range of analytical functions.
As spatial workflows encompassed more global data, the st_geography spatial type was introduced, which represents data as points, arcs and polygons referenced to a spheroid.
This data is stored as latitude and longitude, using the WGS 84 datum, to approximate the shape of the globe. It is always persisted with spatial reference (SRID) of 4326. The type comes with its own set of analytical functions.
The PostGIS extension has the distinction of supporting both spatial types, the ability to perform analysis and maintain precision and accuracy of data in each type as well as the ability to cast data from one type to another. So, it can be used to maintain the correctness of projected data such a land parcel, or a road in st_geometry, and it can be used to represent data on a global scale such as ride sharing apps or airplane routes in st_geography.
In time, several other PostGIS extensions were created, each to work with different spatial representations, such as raster, point clouds and 3D data and perform operations such as geocoding or topology modeling.
How do you enable Azure Database for PostgreSQL – Flexible Server to work with spatial data?
Azure Database for PostgreSQL – Flexible Server is a fully managed database-as-a-service based on the community version of PostgreSQL which provides the ability to extend the functionality of the instance using extensions, which once loaded, will function like built-in features.
The following spatial extensions can be installed:
PostGIS – primary spatial extension for PostgreSQL.
PostGIS _Topology – model connectivity between features, such as road networks or land parcels
PostGIS_Raster – store and analyze bands of raster data, from imagery to land use or soil types
PostGIS_Tiger_Geocoder – use spatial data collected as part of the Census Bureau’s census, to create address points.
PostGIS_sfcgal – work with 3D data, such as building heights or surface dimensionality.
You can learn more about Azure Database for PostgreSQL – Flexible Server here.
Try it yourself!
In this example you are going to look for Airbnb rentals in New York City, within walking distance of a subway station. This workflow relies on the PostGIS extension, data publicly available from Airbnb and a backup from Introduction to PostGIS, available under the Creative Commons Attribution-Share-Alike 3.0 license, currently maintained by Paul Ramsey.
For an upcoming trip to New York City, you are looking for a rental within walking distance of many attractions and in close proximity to a subway station. The Broad Street subway station is in the heart of the financial district of Manhattan, and a short distance from the World Trade Center memorial. So, let’s look for rental properties within different distances of this station.
First, let’s prepare the environment!
Create an instance of PostgreSQL – Flexible Server using Portal
Deploy an instance of PostgreSQL – Flexible Server
Quickstart: Create with Azure portal – Azure Database for PostgreSQL – Flexible Server
Enable extensions on the newly created Flex Server
Extension – Azure Database for PostgreSQL – Flexible Server
Create a Blob Storage Account and load the Airbnb data
Quickstart: Upload, download, and list blobs – Azure portal
Create a Blob Container Introduction to Blob Storage – Azure Storage
Load Listings for New York City from Airbnb
Connect to your server using pgAdmin4
Create a database: nyc
create database nyc;
Enable Extensions in the nyc database
create extension azure_storage;
create extension postgis;
SELECT azure_storage.account_add(‘name_of_storage_account’, ‘secret_access_key’);
Restore the backup from the Introduction to PostGIS workshop, which includes a PostgreSQL backup of spatial data layers, gathered as part of the public census by the U.S. Census Bureau.
Backup and restore – Azure Database for PostgreSQL – Flexible Server
Create the table to store nyc_listings_bnb
CREATE TABLE IF NOT EXISTS public.nyc_listings_bnb
(
id bigint,
name character varying(50),
host_id integer,
host_name character varying(50),
neighbourhood_group character varying(50),
neighbourhood character varying(50),
latitude numeric(10,5),
longitude numeric(10,5),
room_type character varying(50),
price money
);
Load the Airbnb listings data from blob storage
INSERT INTO nyc_listings_bnb
SELECT id,name,host_id,host_name,neighbourhood_group,neighbourhood, latitude, longitude, room_type, price
FROM azure_storage.blob_get(‘name_of_storage_account’,’name_of_container’,’name_of_csv.csv’
,options:= azure_storage.options_csv_get(header=>true)) AS res (
id bigint,
name character varying(50),
host_id integer,
host_name character varying(50),
neighbourhood_group character varying(50),
neighbourhood character varying(50),
latitude numeric(10,5),
longitude numeric(10,5),
room_type character varying(50),
price money
);
Construct a PostGIS spatial column for the Airbnb listings table
Alter table nyc_listings_bnb ADD COLUMN listing_geom geometry(point, 4326);
UPDATE nyc_listings_bnb SET listing_geom =ST_SetSRID(ST_Point(longitude, latitude), 4326);
Explore the data
You now have at least 7 layers of spatially enabled data available for exploration and analysis. Let’s take a look at the Broad Street station.
select st_transform(geom, 4326)
from nyc_subway_stations
where name = ‘Broad St’;
PGAdmin4 includes an open-source viewer, Leaflet which will let you visualize a single spatial data layer, using OSM basemaps. The data to be visualized needs to be referenced to SRID 4326 to display against the basemap.
Perform Analysis
You can use the NYC Subway Stations layer to create different geofences around the Broad Street subway station. Using the ST_Buffer function you can create a polygon within a distance of a subway station, each of those polygons will be saved in a table. The distance will need to be given in the units of the data. In this case the data is in SRID 26918, which stores data in meters.
You can use the geofence layers to find available listings from the Airbnb listings data that lie within each polygon.
What if you were looking for an Airbnb listing that was within a hundred feet of a subway station, how many Airbnb listings would I be able to choose from?
create table nyc_geofence_100_Broad as
select st_transform(st_buffer(geom, 100), 4326) as geo_fence
from nyc_subway_stations
where name= ‘Broad St’;
select geo_fence from nyc_geofence_100_broad;
select host_id, host_name, l.listing_geom
from nyc_listings_bnb as l
join nyc_geofence_100_broad as g
on st_contains (g.geo_fence,l.listing_geom)
The analysis found that 13 Airbnb properties are available within 100 meters or 382 feet from the Broad St. subway station.
But what if you were willing to walk a third of a mile to a subway station, how many Airbnb listings would I be able to choose from?
create table nyc_geofence_500_Broad as
select st_transform(st_buffer(geom, 500), 4326) as geo_fence
from nyc_subway_stations
where name= ‘Broad St’;
select geo_fence from nyc_geofence_500_broad;
select host_id, host_name, l.listing_geom
from nyc_listings_bnb as l
join nyc_geofence_500_broad as g
on st_contains (g.geo_fence,l.listing_geom)
The analysis found that 514 Airbnb properties are available within 500 meters or .3 miles from the Broad St. subway station.
Extensibility of Azure Database for PostgreSQL – Flexible Server
Congratulations!
You just learned how to enhance your applications with spatial data by leveraging PostGIS with Azure Database for PostgreSQL – Flexible Server.
Microsoft Tech Community – Latest Blogs –Read More
Skilling snack: Advanced network security
Ready for another dive into network security? By now, you should already be familiar with the basics, courtesy of our previous skilling snack, Network security basics for endpoints. Network security is too broad and important of a topic to cover in a single snack, and it’s always improving! So, we’ve compiled a second serving of more advanced network security skilling to help you give your organization the worry-free environment it deserves.
Time to learn: 106 minutes
READ
Firewall & network protection in Windows Security
Introduce yourself to the Microsoft Defender Firewall, and how it benefits your network security.
(3 mins)
Defender + Firewall
READ
Tutorial: Deploy Always On VPN – Set up infrastructure for Always On VPN
Learn how to set up an Always On VPN connection for remote domain-joined Windows client computers. Then create a sample infrastructure.
(11 mins)
Always On + VPN + Active Directory + NPS
WATCH
Hear all about the guiding principles of Zero Trust, and how it can help secure all of your identities, devices, data, and networks.
(2 mins)
Zero Trust + Networking + IAM + Remote Workforce
WATCH
Detecting and Responding to Threats using Azure Network Security tools and Azure Sentinel
Learn how to effectively use the data collected from Microsoft Entra ID cloud-native security services and further refine your security strategy.
(24 mins)
Azure + Ignite + Log Analytics + Network Watcher + Entra ID
LEARN
Take an eight-unit course to learn the ins and outs of Microsoft Defender.
(22 mins)
Defender + Antivirus + Firewall + Malware
WATCH
Network protection in Microsoft Defender for Endpoint
Discover how to reduce the attack surface of your devices with the help of Microsoft Defender.
(5 mins)
Endpoint Security + Phishing + Malware
WATCH
Microsoft Entra Private Access protections for on-premises & private cloud network resources
Get started with enabling secure access to private on-premises and cloud resources with the help of Microsoft Entra.
(10 mins)
Entra + Security Service Edge + Zero Trust + Global Secure Access
New capabilities to protect on-premises resources with MFA via Microsoft Entra Private Access
Jump into a deep discussion of the many security benefits of Microsoft Entra Private Access, including multifactor identification, single sign-on, SSH support, remote access, and more.
(23 mins)
Entra + Zero Trust + SSO + SSH + Multifactor Identification
READ
5 ways to secure identity and access for 2024
Learn how security is evolving in 2024. Arm yourself with the best practices that you need to secure your network from modern, AI-powered cyberattacks.
(9 mins)
Entra + Microsoft Copilot for Security + AI + ML + MFA
READ
Security above all else—expanding Microsoft’s Secure Future Initiative
Get informed on how Microsoft is making security a priority with the Secure Future Initiative.
(7 mins)
SFI + Threat detection + Cloud security
When you’re ready to delve even deeper into your network security, consider some of our longer videos and learning courses:
Implementing network security in Azure (4 hours, 36 minutes): This four-module course will show you how to configure, protect, and isolate a network in Azure.
Deep Dive on Microsoft Entra Private Access (1 hour, 1 minute): This video will give you a thorough look at the Microsoft Entra private access Zero Trust network.
When it comes to your network, there’s no such thing as being too secure. If you’d like to hear more about network security, leave a comment below with your ideas, and come back later for more biweekly skilling snacks.
Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X/Twitter. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
Grow with Copilot for Microsoft 365 – May 2024
Welcome to Grow with Copilot, a new series where we curate relevant news, insights, and resources to help small and medium organizations harness the power of Copilot. In this edition, we take a look at the round up of recent product enhancements shared during today’s quarterly Microsoft 365 Product Connect for CSPs (on-demand available on May 22), Small and Medium Business (SMB) customer spotlight on Morula Health, SMB insights from the latest Work Trend Index, and resources to help organizations of every size get more out of Copilot.
ICYMI: Spring 2024 round up of product enhancements
Microsoft continues to invest in expanding Copilot for Microsoft 365 availability to more audiences, adding and refining Copilot experiences and how the product leverages data.
Reaching more customers
Expanded language support: we added Tier 2 languages including Arabic, Chinese Traditional, Czech, Danish, Dutch, Finnish, Hebrew, Hungarian, Korean, Norwegian, Polish, Portuguese, Russian, Swedish, Thai, Turkish, Ukrainian, to Copilot bringing the current total to 27 that you can find here.
Expanded SKU eligibility: we added Business Basic as a pre-requisite in April. That means whether you use Business Basic, Standard, or Premium, you can purchase Copilot for Microsoft 365 without a minimum seat requirement.
Increasing your digital efficiency
Copilot in Forms: Simplify creating surveys, polls, and forms with Copilot for Microsoft 365. Copilot will provide relevant questions and suggestions, and then you can refine the draft by adding extra details, editing text, or removing content. Learn more here.
Copilot in Stream: Get information quickly about your video content through Copilot in Stream, and catch up on the latest Teams meeting recordings, town halls, product demos, how-tos, or onsite videos. Learn more here.
Help Me Create: Let Copilot suggest the best format to bring your content to life, whether it’s a white paper, presentation, list, or quiz, and more. Learn more here.
Copilot in OneDrive (web): Get information about files in OneDrive without opening them, Copilot will provide you with smart and intuitive ways to interact with your documents, presentations, spreadsheets, and files. Learn more here.
Improving reasoning over data
Graph-grounding for Copilot in Word, Excel, PowerPoint, and Outlook: Copilot can now ground prompts in Graph content from within Word, Excel, PowerPoint, and Outlook, expanding context for responses and creating a more cohesive experience. Learn more here.
Improved usage reports: The Usage reports in the Microsoft 365 admin center now include usage metrics for Microsoft Copilot with Graph-grounded chat. This allows you to see how Chat usage compares with Copilot usage in other apps like Teams, Outlook, Word, PowerPoint, Excel, OneNote and Loop. Learn more here.
Adv. Data Residency + Multi-Geo: New commitments covering stored content of interactions with Copilot for Microsoft 365 have been added to existing data residency commitments for Microsoft 365, including the Advanced Data Residency and Multi-Geo Capabilities add-ons. Learn more here.
Restricted SharePoint Search: Interim measures to secure your data as you roll out Copilot for Microsoft 365. Admins can protect their most critical data without having to slow down user enablement while getting their tenant ready for Copilot. Learn more here.
Product enhancements are covered in our monthly What’s New in Copilot monthly blog, and you can always refer to the Microsoft roadmap to see what’s coming next.
SMB Customer spotlight: Morula Health
Morula Health, a UK health provider of under 50 employees, provides regulatory and clinical medical writing solutions to global clients in the healthcare sector. We recently sat down with Philip Burridge, Operations & Strategy, and Jayshwini Sanghani, Marketing, about their experience with Copilot.
Why was Copilot the right solution for your company and how does Morula Health use Copilot for Microsoft 365 today?
Jayshwini: Copilot is in the tools like Word, PowerPoint, Outlook that we were already using. So, the fact that Copilot can integrate so well with those kind of platforms, it made it so much easier. I didn’t then have to take all of that content across to a different platform. It was all available there.
Philip: We would in no way ever go near any of these early AI tools that were being released if we weren’t 100% confident that our data and the data that we are using from our customers is kept 100% secure. With Copilot, we know that none of this data is going back to the language models, nor is any of our data even going to leave our environment. We know that when we sign CDAs and NDAs with our clients, that they can be 100% confident that we are adhering to those and that they can trust us with their information.
What are some ways Copilot for Microsoft 365 is helping you be more effective?
Jayshwini: Copilot gives me new fresh ideas that I can then go and work off instead of just, you know, starting at a blank screen. Prior to Copilot, a blog draft would normally take about 3 weeks to write up, to finalize, and then to post. Whereas now with Copilot, I feel like it’s really possible for me to get two blog drafts out in a week.
Philip: I can be completely engaged on calls and focus on how to steer this call in the right direction to get the best out of everyone on that call. I make a few notes on my notepad of the specific topics that were discussed and ask Copilot to recap after. Not only does Copilot transcribe everything perfectly from our calls, but it’s able to pick up highly specific terminology relevant to our particular industry.
How has this ultimately changed the way people work?
Philip: We’ve started actually recognizing what prompts work near enough every time for each different section of a report that we need to write, so we’re building them into our template so our medical writers know immediately here’s a particular prompt that will help you to get started on this particular section. And what that actually does is it frees up our medical writers from the repetitive tasks, so they can focus on understanding what their data is trying to say and enhancing the quality and the strategy of what we’re trying to achieve with that document for our clients.
Check out the full customer story and other customer stories here.
2024 Work Trend Index Survey: Insights from SMBs
In the dynamic landscape of small and medium businesses, the integration of AI is not just an option—it’s a strategic necessity. The 2024 Work Trend Index Survey show that 78% of SMB workers across the world are already employing AI tools. With 71% of SMBs finding daily tasks energetically taxing and 67% finding innovation and strategic thinking burdensome, the pressing need for AI solutions is evident. A substantial number, over 50%, feel overwhelmed by data retrieval tasks and endure a lack of dedicated focus time.
The productivity benefit is huge. Small business productivity is only half that of large companies, raising it to top-quartile levels relative to large companies is equivalent to 5 percent of GDP in advanced economies and 10 percent in emerging economies, according to this month’s McKinsey Global Institute report.
Download the Work Trend Index – SMB executive summary. See how the data compares for small and medium-sized businesses and in US metropolitan areas. Read the full report on WorkLab.
AI for every business
While leveraging AI offers SMBs an advantageous edge, a conspicuous training deficit exists – only one third of SMB AI users have received training. To bridge the training deficit, we continue to publish resources to help every role, in every business, get more out of copilot wherever you are in your journey. Check out these recently published resources:
The Right Way to AI: What we’re learning about successful AI adoption from companies getting it right. A checklist you can follow with your AI rollout. Read more here
Training for every role: We host webinars for Executives, Sales, Marketing, IT Professionals, HR and more. Register for one (or more!) here.
“Prompt Like a Pro”: a new monthly blog series from the Microsoft Teams Tech Community that will teach you how prompts can help you can transform the way you work with AI by taking advantage of Copilot in Microsoft Teams
Copilot Skilling content: Copilot Academy offers self-paced training from familiarizing yourself with Copilot capabilities to learning how to prompt. We recently published the new 4000 series of courses that cover topics across end users, admins, and trainers. Check out MS-4004/5/6/7 courses on AI Learning Hub
Thank you for reading. Let us know in the comments how you use Copilot for Microsoft 365!
Footnotes
1 Copilot for Microsoft 365 may not be available for all markets and languages. Review current eligibility here.
2 We surveyed 31,000 people across 31 countries, identified labor and hiring trends from LinkedIn, analyzed trillions of Microsoft 365 productivity signals and conducted research with Fortune 500 customers. These insights are detailed in the (2024) Work Trend Index.
3McKinsey report (May 2, 2024): McKinsey Global Institute report.
Microsoft Tech Community – Latest Blogs –Read More
Dividing values in two datasets
Hello,
In short, I am trying to divide two values, one in DatasetC and one in DatasetA. I have tried to use Lookup to do it, but to no avail.
I am recreating a report and plugging it into SSRS. I have rewritten the report in SQL and it contains 6 parts, A, B, C, D, E, F and G. I am needing to divide DatasetC by DatasetA in order to get a percentage. I have looked into this and all I can find is to use Lookup, but when I do is produces an error. Below is the formula I am using. They all connect to the same datasource. Any advice would be appreciated.
=Lookup
(
Fields!Outstanding.Value,
Fields!Outstanding.Value,
Fields!Balance.Value,
“PartD”
)
/
Lookup
(
Fields!Outstanding.Value,
Fields!Outstanding.Value,
Fields!Balance.Value,
“PartA”
)
Thank you
Hello, In short, I am trying to divide two values, one in DatasetC and one in DatasetA. I have tried to use Lookup to do it, but to no avail. I am recreating a report and plugging it into SSRS. I have rewritten the report in SQL and it contains 6 parts, A, B, C, D, E, F and G. I am needing to divide DatasetC by DatasetA in order to get a percentage. I have looked into this and all I can find is to use Lookup, but when I do is produces an error. Below is the formula I am using. They all connect to the same datasource. Any advice would be appreciated. =Lookup(Fields!Outstanding.Value,Fields!Outstanding.Value,Fields!Balance.Value,”PartD”)/Lookup(Fields!Outstanding.Value,Fields!Outstanding.Value,Fields!Balance.Value,”PartA”) Thank you Read More
Unrecognized function or variable ” ” , when I use my function
Hi,
I write some function that will make a fit for my data. this is my function:
function Xmax = fit_function(x,y)
X1 = x(x>0.5 & x<2);
Y1 = y(x>0.5 & x<2);
% ymax calculated analytically with Wolfram Mathematica
ymax = @(b) (2-b(2)/b(1))*(2*b(1)/b(2)-1)^(-b(2)/2/b(1));
modelfun = @(b,x) b(3)/ymax(b)*exp((x-b(4))*(b(1)-b(2))).*sech(b(1)*(x-b(4)));
bguess=[78, 10, peaks(1),x(t_peaks(1))];
% [alpha, beta, amplitude, x offset]
% 78 and 10 were calculated by cftool (after given there a guess of 80,20)
beta = nlinfit(X1, Y1, modelfun, bguess);
fittedCurve = modelfun(beta, X1);
Xmax=log(-1+(2*beta(1)/beta(2)));
when I apply this function on some data, I have a problem in the line of bguess.
The function is able to read the "peaks(1)" variable, but not the t_peaks(1) variable. both of them save in the workspace, and slao both of them is double file.
as I say in the summary, the error is:
>> Xmax=fit_function(x,y);
Unrecognized function or variable ‘t_peaks’.
Error in fit_function (line 12)
bguess=[78, 10, peaks(1), x(t_peaks(1))];
why is append?
It’s strange that it can read one of the variables and not the other..
Thanks!(:Hi,
I write some function that will make a fit for my data. this is my function:
function Xmax = fit_function(x,y)
X1 = x(x>0.5 & x<2);
Y1 = y(x>0.5 & x<2);
% ymax calculated analytically with Wolfram Mathematica
ymax = @(b) (2-b(2)/b(1))*(2*b(1)/b(2)-1)^(-b(2)/2/b(1));
modelfun = @(b,x) b(3)/ymax(b)*exp((x-b(4))*(b(1)-b(2))).*sech(b(1)*(x-b(4)));
bguess=[78, 10, peaks(1),x(t_peaks(1))];
% [alpha, beta, amplitude, x offset]
% 78 and 10 were calculated by cftool (after given there a guess of 80,20)
beta = nlinfit(X1, Y1, modelfun, bguess);
fittedCurve = modelfun(beta, X1);
Xmax=log(-1+(2*beta(1)/beta(2)));
when I apply this function on some data, I have a problem in the line of bguess.
The function is able to read the "peaks(1)" variable, but not the t_peaks(1) variable. both of them save in the workspace, and slao both of them is double file.
as I say in the summary, the error is:
>> Xmax=fit_function(x,y);
Unrecognized function or variable ‘t_peaks’.
Error in fit_function (line 12)
bguess=[78, 10, peaks(1), x(t_peaks(1))];
why is append?
It’s strange that it can read one of the variables and not the other..
Thanks!(: Hi,
I write some function that will make a fit for my data. this is my function:
function Xmax = fit_function(x,y)
X1 = x(x>0.5 & x<2);
Y1 = y(x>0.5 & x<2);
% ymax calculated analytically with Wolfram Mathematica
ymax = @(b) (2-b(2)/b(1))*(2*b(1)/b(2)-1)^(-b(2)/2/b(1));
modelfun = @(b,x) b(3)/ymax(b)*exp((x-b(4))*(b(1)-b(2))).*sech(b(1)*(x-b(4)));
bguess=[78, 10, peaks(1),x(t_peaks(1))];
% [alpha, beta, amplitude, x offset]
% 78 and 10 were calculated by cftool (after given there a guess of 80,20)
beta = nlinfit(X1, Y1, modelfun, bguess);
fittedCurve = modelfun(beta, X1);
Xmax=log(-1+(2*beta(1)/beta(2)));
when I apply this function on some data, I have a problem in the line of bguess.
The function is able to read the "peaks(1)" variable, but not the t_peaks(1) variable. both of them save in the workspace, and slao both of them is double file.
as I say in the summary, the error is:
>> Xmax=fit_function(x,y);
Unrecognized function or variable ‘t_peaks’.
Error in fit_function (line 12)
bguess=[78, 10, peaks(1), x(t_peaks(1))];
why is append?
It’s strange that it can read one of the variables and not the other..
Thanks!(: function, variable MATLAB Answers — New Questions
Outlook Deleting Junk Email Automatically
This has happened two times this morning. I had two emails come into my inbox. One of them I marked read and it disappeared. Then another one came in and while I was reading it, it disappeared. I searched through my email and I do not see it. I went to the online email webpage and it is missing from there.
Is Microsoft now deleting emails it thinks are junk/spam? That is not good.
This has happened two times this morning. I had two emails come into my inbox. One of them I marked read and it disappeared. Then another one came in and while I was reading it, it disappeared. I searched through my email and I do not see it. I went to the online email webpage and it is missing from there. Is Microsoft now deleting emails it thinks are junk/spam? That is not good. Read More
Non-linearity errors and zero-crossing errors while training a RL Agent
A few days ago I posted a question about the training of an agent applied to the control of a nonlinear model of a three-degree-of-freedom aircraft. During training, randomly, I get this warning
The output port signal type of ‘RL_Training_TECS_Model/Environment System/State Propagator/Forces, Moments, 3DoF/Aerodynamic Coefficients, 3DoF/Datcom Aerodynamic Model’ is real (non-complex), however, the evaluated output is complex. Consider setting the ‘OutputSignalType’ to complex
followed by this error
Error using rl.internal.train.OffPolicyTrainer/run_internal_/nestedRunEpisode (line 284)
An error occurred while running the simulation for model ‘RL_Training_TECS_Model’ with the following RL agent blocks:
RL_Training_TECS_Model/RL TECS Alt Hold
Error in rl.internal.train.OffPolicyTrainer/run_internal_ (line 351)
out = nestedRunEpisode(policy);
Error in rl.internal.train.OffPolicyTrainer/run_ (line 40)
result = run_internal_(this);
Error in rl.internal.train.Trainer/run (line 8)
result = run_(this);
Error in rl.internal.trainmgr.OnlineTrainingManager/run_ (line 112)
trainResult = run(trainer);
Error in rl.internal.trainmgr.TrainingManager/run (line 4)
result = run_(this);
Error in rl.agent.AbstractAgent/train (line 86)
trainingResult = run(tm);
Caused by:
Error using rl.env.internal.reportSimulinkSimError (line 29)
Simulink will stop the simulation of model ‘RL_Training_TECS_Model’ because the 1 zero crossing signal(s) identified below caused 1000 consecutive zero crossing events in time interval between 7.6446467665241798e-11 and 7.6446467670045701e-11.
————————————————– ——————————
Number of consecutive zero-crossings: 1000
Zero-crossing signal name : SwitchCond
Block type: Switch
Block path : ‘RL_Training_TECS_Model/Environment System/State Propagator/Forces, Moments, 3DoF/Aerodynamic Coefficients, 3DoF/Switch’
————————————————– ——————————
or this one
Error using rl.internal.train.OffPolicyTrainer/run_internal_/nestedRunEpisode (line 284)
An error occurred while running the simulation for model ‘RL_Training_TECS_Model’ with the following RL agent blocks:
RL_Training_TECS_Model/RL TECS Alt Hold
Error in rl.internal.train.OffPolicyTrainer/run_internal_ (line 351)
out = nestedRunEpisode(policy);
Error in rl.internal.train.OffPolicyTrainer/run_ (line 40)
result = run_internal_(this);
Error in rl.internal.train.Trainer/run (line 8)
result = run_(this);
Error in rl.internal.trainmgr.OnlineTrainingManager/run_ (line 112)
trainResult = run(trainer);
Error in rl.internal.trainmgr.TrainingManager/run (line 4)
result = run_(this);
Error in rl.agent.AbstractAgent/train (line 86)
trainingResult = run(tm);
Caused by:
Error using rl.env.internal.reportSimulinkSimError (line 29)
Solver encountered an error while simulating model ‘RL_Training_TECS_Model’ at time 1.140683144978552e-08 and cannot continue. Please check the model for errors.
Error using rl.env.internal.reportSimulinkSimError (line 29)
Nonlinear iteration is not converging with step size reduced to hmin (4.05252E-23) at time 1.14068E-08. Try reducing the minimum step size and/or relax the relative error tolerance.
At the start of each episode, the reset function trims the aircraft to a safe area I specify and then linearizes. What could these errors be due to?A few days ago I posted a question about the training of an agent applied to the control of a nonlinear model of a three-degree-of-freedom aircraft. During training, randomly, I get this warning
The output port signal type of ‘RL_Training_TECS_Model/Environment System/State Propagator/Forces, Moments, 3DoF/Aerodynamic Coefficients, 3DoF/Datcom Aerodynamic Model’ is real (non-complex), however, the evaluated output is complex. Consider setting the ‘OutputSignalType’ to complex
followed by this error
Error using rl.internal.train.OffPolicyTrainer/run_internal_/nestedRunEpisode (line 284)
An error occurred while running the simulation for model ‘RL_Training_TECS_Model’ with the following RL agent blocks:
RL_Training_TECS_Model/RL TECS Alt Hold
Error in rl.internal.train.OffPolicyTrainer/run_internal_ (line 351)
out = nestedRunEpisode(policy);
Error in rl.internal.train.OffPolicyTrainer/run_ (line 40)
result = run_internal_(this);
Error in rl.internal.train.Trainer/run (line 8)
result = run_(this);
Error in rl.internal.trainmgr.OnlineTrainingManager/run_ (line 112)
trainResult = run(trainer);
Error in rl.internal.trainmgr.TrainingManager/run (line 4)
result = run_(this);
Error in rl.agent.AbstractAgent/train (line 86)
trainingResult = run(tm);
Caused by:
Error using rl.env.internal.reportSimulinkSimError (line 29)
Simulink will stop the simulation of model ‘RL_Training_TECS_Model’ because the 1 zero crossing signal(s) identified below caused 1000 consecutive zero crossing events in time interval between 7.6446467665241798e-11 and 7.6446467670045701e-11.
————————————————– ——————————
Number of consecutive zero-crossings: 1000
Zero-crossing signal name : SwitchCond
Block type: Switch
Block path : ‘RL_Training_TECS_Model/Environment System/State Propagator/Forces, Moments, 3DoF/Aerodynamic Coefficients, 3DoF/Switch’
————————————————– ——————————
or this one
Error using rl.internal.train.OffPolicyTrainer/run_internal_/nestedRunEpisode (line 284)
An error occurred while running the simulation for model ‘RL_Training_TECS_Model’ with the following RL agent blocks:
RL_Training_TECS_Model/RL TECS Alt Hold
Error in rl.internal.train.OffPolicyTrainer/run_internal_ (line 351)
out = nestedRunEpisode(policy);
Error in rl.internal.train.OffPolicyTrainer/run_ (line 40)
result = run_internal_(this);
Error in rl.internal.train.Trainer/run (line 8)
result = run_(this);
Error in rl.internal.trainmgr.OnlineTrainingManager/run_ (line 112)
trainResult = run(trainer);
Error in rl.internal.trainmgr.TrainingManager/run (line 4)
result = run_(this);
Error in rl.agent.AbstractAgent/train (line 86)
trainingResult = run(tm);
Caused by:
Error using rl.env.internal.reportSimulinkSimError (line 29)
Solver encountered an error while simulating model ‘RL_Training_TECS_Model’ at time 1.140683144978552e-08 and cannot continue. Please check the model for errors.
Error using rl.env.internal.reportSimulinkSimError (line 29)
Nonlinear iteration is not converging with step size reduced to hmin (4.05252E-23) at time 1.14068E-08. Try reducing the minimum step size and/or relax the relative error tolerance.
At the start of each episode, the reset function trims the aircraft to a safe area I specify and then linearizes. What could these errors be due to? A few days ago I posted a question about the training of an agent applied to the control of a nonlinear model of a three-degree-of-freedom aircraft. During training, randomly, I get this warning
The output port signal type of ‘RL_Training_TECS_Model/Environment System/State Propagator/Forces, Moments, 3DoF/Aerodynamic Coefficients, 3DoF/Datcom Aerodynamic Model’ is real (non-complex), however, the evaluated output is complex. Consider setting the ‘OutputSignalType’ to complex
followed by this error
Error using rl.internal.train.OffPolicyTrainer/run_internal_/nestedRunEpisode (line 284)
An error occurred while running the simulation for model ‘RL_Training_TECS_Model’ with the following RL agent blocks:
RL_Training_TECS_Model/RL TECS Alt Hold
Error in rl.internal.train.OffPolicyTrainer/run_internal_ (line 351)
out = nestedRunEpisode(policy);
Error in rl.internal.train.OffPolicyTrainer/run_ (line 40)
result = run_internal_(this);
Error in rl.internal.train.Trainer/run (line 8)
result = run_(this);
Error in rl.internal.trainmgr.OnlineTrainingManager/run_ (line 112)
trainResult = run(trainer);
Error in rl.internal.trainmgr.TrainingManager/run (line 4)
result = run_(this);
Error in rl.agent.AbstractAgent/train (line 86)
trainingResult = run(tm);
Caused by:
Error using rl.env.internal.reportSimulinkSimError (line 29)
Simulink will stop the simulation of model ‘RL_Training_TECS_Model’ because the 1 zero crossing signal(s) identified below caused 1000 consecutive zero crossing events in time interval between 7.6446467665241798e-11 and 7.6446467670045701e-11.
————————————————– ——————————
Number of consecutive zero-crossings: 1000
Zero-crossing signal name : SwitchCond
Block type: Switch
Block path : ‘RL_Training_TECS_Model/Environment System/State Propagator/Forces, Moments, 3DoF/Aerodynamic Coefficients, 3DoF/Switch’
————————————————– ——————————
or this one
Error using rl.internal.train.OffPolicyTrainer/run_internal_/nestedRunEpisode (line 284)
An error occurred while running the simulation for model ‘RL_Training_TECS_Model’ with the following RL agent blocks:
RL_Training_TECS_Model/RL TECS Alt Hold
Error in rl.internal.train.OffPolicyTrainer/run_internal_ (line 351)
out = nestedRunEpisode(policy);
Error in rl.internal.train.OffPolicyTrainer/run_ (line 40)
result = run_internal_(this);
Error in rl.internal.train.Trainer/run (line 8)
result = run_(this);
Error in rl.internal.trainmgr.OnlineTrainingManager/run_ (line 112)
trainResult = run(trainer);
Error in rl.internal.trainmgr.TrainingManager/run (line 4)
result = run_(this);
Error in rl.agent.AbstractAgent/train (line 86)
trainingResult = run(tm);
Caused by:
Error using rl.env.internal.reportSimulinkSimError (line 29)
Solver encountered an error while simulating model ‘RL_Training_TECS_Model’ at time 1.140683144978552e-08 and cannot continue. Please check the model for errors.
Error using rl.env.internal.reportSimulinkSimError (line 29)
Nonlinear iteration is not converging with step size reduced to hmin (4.05252E-23) at time 1.14068E-08. Try reducing the minimum step size and/or relax the relative error tolerance.
At the start of each episode, the reset function trims the aircraft to a safe area I specify and then linearizes. What could these errors be due to? matlab, simulink, error, reinforcement_learning, nonlinear, zero-crossing MATLAB Answers — New Questions
Analyse Data button not visible in MS365 Excel
The AI-powered feature Analyse Data button is not visible in the Excel app. I have a yearly subscription. In Powerpoint I can see the AI-powered feature Designer. I can see a new feature Data From Picture in Excel, so why can’t I see the Analyse Data button > Home? pls help.
The AI-powered feature Analyse Data button is not visible in the Excel app. I have a yearly subscription. In Powerpoint I can see the AI-powered feature Designer. I can see a new feature Data From Picture in Excel, so why can’t I see the Analyse Data button > Home? pls help. Read More
Best way to organize categorical data for plotting
I have wind speed data that I want to split and plot in several different ways. For instance, I may want to plot a 3d bar plot with different combinations of wind speed, month, frequency count, altitude. Or a subsection of the data as stacked bar plot or area plot. I’ve been looking at different ways of organizing the data to make plotting different variables and subsections easy, but I’m not used to working with categorical data in matlab, and I keep running into limitations with table/timetable. I’m coming from Python (and older versions of Matlab) and I find Matlab 2019 to be close enough to be just a bit frustrating.
I’m looking for advice on what might be the best way to organize data like this to make plotting quick and flexible. Clearly there’s some logic to this aspect of Matlab that I’ve missed. I’ve previously simply split the data into various matrices and manipulated them for plotting, which is plain and simple, but I’m sure there are better and more advanced ways to do this if one knows how.
I’ve attached the file GC.mat where the data is organized by month, wind speed (5 m/s bins), altitude (2 km bins) and count. I’ve also added part of the original timetable w_tt.csv with 2 s wind speed data (the original data covers 6 years).
I can provide examples of my plotting attempts and try to figure out why it’s not working, but I have a feeling the main problem is that I’ve just not understood the best way to organize the data, so I’m starting with an attempt to learn why this is/isn’t a good approach.
Example table:
166×6 table
monthname_Time disc_Altitude disc_Windspeed GroupCount norm perc
______________ _____________ ______________ __________ __________ __________
January [20000, Inf] [0, 2) 503 4.3455e-05 0.0043455
January [20000, Inf] [2, 4) 1355 0.00011706 0.011706
January [20000, Inf] [4, 6) 2452 0.00021183 0.021183
January [20000, Inf] [6, 8) 2931 0.00025321 0.025321
January [20000, Inf] [8, 10) 3516 0.00030375 0.030375
January [20000, Inf] [10, 12) 3640 0.00031447 0.031447
January [20000, Inf] [12, 14) 3392 0.00029304 0.029304
January [20000, Inf] [14, 16) 2398 0.00020717 0.020717
January [20000, Inf] [16, 18) 2134 0.00018436 0.018436
January [20000, Inf] [18, 20) 2815 0.00024319 0.024319
January [20000, Inf] [20, 22) 3811 0.00032924 0.032924
January [20000, Inf] [22, 24) 4504 0.00038911 0.038911
Example timetable data:
Time Windspeed Altitude
___________________ _________ ________
01/01/2015 00:17:01 27.3 18317
01/01/2015 00:17:03 27.3 18325
01/01/2015 00:17:05 27.2 18334
01/01/2015 00:17:07 27.1 18343
01/01/2015 00:17:09 27 18352
01/01/2015 00:17:11 26.9 18361I have wind speed data that I want to split and plot in several different ways. For instance, I may want to plot a 3d bar plot with different combinations of wind speed, month, frequency count, altitude. Or a subsection of the data as stacked bar plot or area plot. I’ve been looking at different ways of organizing the data to make plotting different variables and subsections easy, but I’m not used to working with categorical data in matlab, and I keep running into limitations with table/timetable. I’m coming from Python (and older versions of Matlab) and I find Matlab 2019 to be close enough to be just a bit frustrating.
I’m looking for advice on what might be the best way to organize data like this to make plotting quick and flexible. Clearly there’s some logic to this aspect of Matlab that I’ve missed. I’ve previously simply split the data into various matrices and manipulated them for plotting, which is plain and simple, but I’m sure there are better and more advanced ways to do this if one knows how.
I’ve attached the file GC.mat where the data is organized by month, wind speed (5 m/s bins), altitude (2 km bins) and count. I’ve also added part of the original timetable w_tt.csv with 2 s wind speed data (the original data covers 6 years).
I can provide examples of my plotting attempts and try to figure out why it’s not working, but I have a feeling the main problem is that I’ve just not understood the best way to organize the data, so I’m starting with an attempt to learn why this is/isn’t a good approach.
Example table:
166×6 table
monthname_Time disc_Altitude disc_Windspeed GroupCount norm perc
______________ _____________ ______________ __________ __________ __________
January [20000, Inf] [0, 2) 503 4.3455e-05 0.0043455
January [20000, Inf] [2, 4) 1355 0.00011706 0.011706
January [20000, Inf] [4, 6) 2452 0.00021183 0.021183
January [20000, Inf] [6, 8) 2931 0.00025321 0.025321
January [20000, Inf] [8, 10) 3516 0.00030375 0.030375
January [20000, Inf] [10, 12) 3640 0.00031447 0.031447
January [20000, Inf] [12, 14) 3392 0.00029304 0.029304
January [20000, Inf] [14, 16) 2398 0.00020717 0.020717
January [20000, Inf] [16, 18) 2134 0.00018436 0.018436
January [20000, Inf] [18, 20) 2815 0.00024319 0.024319
January [20000, Inf] [20, 22) 3811 0.00032924 0.032924
January [20000, Inf] [22, 24) 4504 0.00038911 0.038911
Example timetable data:
Time Windspeed Altitude
___________________ _________ ________
01/01/2015 00:17:01 27.3 18317
01/01/2015 00:17:03 27.3 18325
01/01/2015 00:17:05 27.2 18334
01/01/2015 00:17:07 27.1 18343
01/01/2015 00:17:09 27 18352
01/01/2015 00:17:11 26.9 18361 I have wind speed data that I want to split and plot in several different ways. For instance, I may want to plot a 3d bar plot with different combinations of wind speed, month, frequency count, altitude. Or a subsection of the data as stacked bar plot or area plot. I’ve been looking at different ways of organizing the data to make plotting different variables and subsections easy, but I’m not used to working with categorical data in matlab, and I keep running into limitations with table/timetable. I’m coming from Python (and older versions of Matlab) and I find Matlab 2019 to be close enough to be just a bit frustrating.
I’m looking for advice on what might be the best way to organize data like this to make plotting quick and flexible. Clearly there’s some logic to this aspect of Matlab that I’ve missed. I’ve previously simply split the data into various matrices and manipulated them for plotting, which is plain and simple, but I’m sure there are better and more advanced ways to do this if one knows how.
I’ve attached the file GC.mat where the data is organized by month, wind speed (5 m/s bins), altitude (2 km bins) and count. I’ve also added part of the original timetable w_tt.csv with 2 s wind speed data (the original data covers 6 years).
I can provide examples of my plotting attempts and try to figure out why it’s not working, but I have a feeling the main problem is that I’ve just not understood the best way to organize the data, so I’m starting with an attempt to learn why this is/isn’t a good approach.
Example table:
166×6 table
monthname_Time disc_Altitude disc_Windspeed GroupCount norm perc
______________ _____________ ______________ __________ __________ __________
January [20000, Inf] [0, 2) 503 4.3455e-05 0.0043455
January [20000, Inf] [2, 4) 1355 0.00011706 0.011706
January [20000, Inf] [4, 6) 2452 0.00021183 0.021183
January [20000, Inf] [6, 8) 2931 0.00025321 0.025321
January [20000, Inf] [8, 10) 3516 0.00030375 0.030375
January [20000, Inf] [10, 12) 3640 0.00031447 0.031447
January [20000, Inf] [12, 14) 3392 0.00029304 0.029304
January [20000, Inf] [14, 16) 2398 0.00020717 0.020717
January [20000, Inf] [16, 18) 2134 0.00018436 0.018436
January [20000, Inf] [18, 20) 2815 0.00024319 0.024319
January [20000, Inf] [20, 22) 3811 0.00032924 0.032924
January [20000, Inf] [22, 24) 4504 0.00038911 0.038911
Example timetable data:
Time Windspeed Altitude
___________________ _________ ________
01/01/2015 00:17:01 27.3 18317
01/01/2015 00:17:03 27.3 18325
01/01/2015 00:17:05 27.2 18334
01/01/2015 00:17:07 27.1 18343
01/01/2015 00:17:09 27 18352
01/01/2015 00:17:11 26.9 18361 categorical data, timetable, plot, histogram, bar plot MATLAB Answers — New Questions
A step by step / checklist for all settings / plugins etc. needed to make LDAP functional in hybrid
I would like a checklist for all settings / plugins etc. needed to make LDAP fully functional in an Azure Hybrid environment.
I would like a checklist for all settings / plugins etc. needed to make LDAP fully functional in an Azure Hybrid environment. Read More
How to troubleshoot the issue :”slot mate is not supported,” and the constraint has been exported as an ”unknown constraint” ?
I have imported an assembly from solidworks into sim mechanics so I can create a controller for the assembly. The problem is simulink doesn’t seem to recognize the "Slot Mate" from Solidworks.I have imported an assembly from solidworks into sim mechanics so I can create a controller for the assembly. The problem is simulink doesn’t seem to recognize the "Slot Mate" from Solidworks. I have imported an assembly from solidworks into sim mechanics so I can create a controller for the assembly. The problem is simulink doesn’t seem to recognize the "Slot Mate" from Solidworks. simulink, simscape, solidworks, mate, slot mate, export, advanced mating in solidworks, simscape multibodylink MATLAB Answers — New Questions
Bookings emails not stored in Sent folder
I’ve just recently created my Bookings page at work. When I send a private invitation via email from the Bookings page, the email shows in an Exchange trace, but it doesn’t show up in my Sent folder in Outlook. I need that to happen, because I need to document that the email was sent, and would rather not have to run an Exchange trace each time I use the feature. Is there a setting that can be enabled?
I’ve just recently created my Bookings page at work. When I send a private invitation via email from the Bookings page, the email shows in an Exchange trace, but it doesn’t show up in my Sent folder in Outlook. I need that to happen, because I need to document that the email was sent, and would rather not have to run an Exchange trace each time I use the feature. Is there a setting that can be enabled? Read More
Checking file access permissions on SharePoint Document Library using Power Automate
I looking for a way to check specific group file permissions on a SharePoint document library. The request needs to go through SharePoint HTTP connector in Power Automate.
I have found this page in SharePoint settings which is exactly what I need. But I am struggling to find a proper HTTP request to get this data in Power Automate.
Desired data:
I have tried using the following requests:
_api/web/RoleAssignments/GetByPrincipalId(14)/RoleDefinitionBindings
I looking for a way to check specific group file permissions on a SharePoint document library. The request needs to go through SharePoint HTTP connector in Power Automate. I have found this page in SharePoint settings which is exactly what I need. But I am struggling to find a proper HTTP request to get this data in Power Automate. Desired data:View in SharePoint I have tried using the following requests: _api/web/RoleAssignments/GetByPrincipalId(14)/RoleDefinitionBindings Read More
would like to reset value to 0
Hi,
I have a Powerapps form and one of the columns is where user enters a count of an item
That count should be reset to 0 when the editform is used if a choice column value is selected, otherwise leave the entered value as is.
I am trying to use this formula in the RESET property of the Count column:
Hi,I have a Powerapps form and one of the columns is where user enters a count of an itemThat count should be reset to 0 when the editform is used if a choice column value is selected, otherwise leave the entered value as is. I am trying to use this formula in the RESET property of the Count column: If(FlightInfo.Mode=FormMode.Edit, (DataCardValue4.Selected.Value = “Non-actionable”),ThisItem.’Guest Count’)it is probably not the correct formula or maybe the correct location to reset the value to 0 but powerapps is not returning an error but the formula does not act as expected. Any help is appreciated. Ren Read More
Azure Communication Services at Microsoft Build 2024
Join us in-person in Seattle or virtually for Microsoft Build 2024 from May 21 to 24. We’re excited to share the latest updates from Azure Communication Services with the developer community. Microsoft Build is your opportunity to connect with developers around the world and learn new skills in topics like copilots, generative AI, application security, cloud platforms, low-code, and more.
Don’t miss the chance to register for Microsoft Build 2024.
Below is the lineup of sessions that will showcase the upcoming releases from Azure Communication Services, along with samples, demos, and how-to manuals for building effective and efficient communication experiences. If you are a developer in the communication space, make sure to add these to your Build backpack.
Demo: In-person
Build Generative AI voice bots with line of business data
May 21 11:45 AM – 12:00 PM PST | Shawn Henry
Personalize customer interactions with voice bots that can have natural, real-time conversations. Join us in a step-by-step journey to construct a voice bot for your business that not only talks but draws from your company’s knowledge base. Additionally, learn how to use Azure Communication Services APIs to add advanced customizations including integration with voice, video, chat, SMS, WhatsApp and telephony capabilities into your apps with just a few lines of code.
Breakout: In-person & Virtual
Multimodal, and Multiagent innovation with Azure AI
May 21, 2:15 – 3:00 PM PST | Marco Casalaina and Mark Schoennagel
Join us at Microsoft Build for a showcase on Azure OpenAI Service’s breakthroughs and evolution of Azure AI. Explore GPT-4, multi-modality, and demos integrating sight and language with Dall-E and Whisper. Learn about developer tools, AI assistants, scalable applications, and customization. Focus on responsible AI, data privacy, and security with Azure. Featuring interactive demos and stories from companies like Unity Technologies, this session is perfect for developers and innovators.
Live Talk Show (Interstitial): In-person
Build AI-powered apps on the platform that runs Microsoft Teams and tour the mechanics of Azure Communication Services
May 23, 12:45 – 1:15 PM PST | Jeremy Chapman and Milan Kaur
Milan Kaur, who is an expert on Azure Communication Services, will talk to Microsoft Mechanics’ host Jeremy Chapman about the recent developments in how Teams and Azure Communications can interoperate to create compelling customer service solutions. The Interstitials are not part of the session catalogue on the Build app/website and will take place live in the expert meet up area.
Demo: In-person
Extend Copilot for Microsoft 365 with Azure Communication Services
May 23, 4:15 – 4:30 PM PST | Milan Kaur
Extend Copilot for Microsoft 365 to communicate with external audiences through channels such as email, SMS, and WhatsApp. You can use your line of business data to quickly craft personalized messages from the Copilot interface.
We hope you join us for Microsoft’s flagship developer event next week. Let’s build the future together!
Microsoft Tech Community – Latest Blogs –Read More
Evolving Microsoft Credentials for Dynamics 365
Microsoft Dynamics 365 empowers customers everywhere to drive process efficiency and deliver business success. With the introduction of AI and Microsoft Copilot, career growth opportunities are even greater for professionals with technical skills in Microsoft business applications.
We’re pleased to announce that we’re evolving Microsoft Credentials for Dynamics 365. The changes help ensure that skills related to Microsoft’s AI apps and services, the cloud, and other emerging technologies are validated, helping you build the skills you need to be successful in these job roles. We’re also streamlining the certification journey so that you have a more straightforward path to prove those skills.
Currently, the Dynamics 365 learning journey for customer experience professionals involves earning three role-based certifications—Dynamics 365 Sales Functional Consultant Associate certification, Dynamics 365 Customer Insights (Journeys) Functional Consultant Associate, and Dynamics 365 Customer Insights (Data) Specialty. Our goal is to simplify the path and improve the skills-validation experience with a single role-based Microsoft Certification, combined with multiple scenario-based Microsoft Applied Skills, providing the opportunity for professionals to showcase the depth of their knowledge for the role and for specific, real-world projects.
Coming soon: New Microsoft Credentials for Dynamics 365
The new Microsoft Certified: Dynamics 365 Customer Experience Analyst Associate certification will be released in late September 2024. It can help you prove that you have the skills to elevate the customer experience, strengthen customer relationships, and earn customer loyalty by using Dynamics 365 Sales, Dynamics 365 Customer Insights – Journeys, and Dynamics 365 Customer Insights – Data.
Coming soon, to complement the skills validated by the upcoming certification, we’ll release several Applied Skills scenarios related to Dynamics 365 Customer Insights, like creating and managing journeys with Dynamics 365 and creating and managing segments. Stay tuned for more news.
Some Dynamics 365 Certifications to be retired
The new Certification and Applied Skills will allow you to prove skills that are currently measured by the following certifications. These certifications, their exams, and the related renewal assessments will all be retired on November 30, 2024:
Dynamics 365 Sales Functional Consultant Associate and Exam MB‑210: Microsoft Dynamics 365 Sales Functional Consultant
Dynamics 365 Customer Insights (Journeys) Functional Consultant Associate and Exam MB-220: Microsoft Dynamics 365 Customer Insights (Journeys) Functional Consultant
Dynamics 365 Customer Insights (Data) Specialty and Exam MB-260: Dynamics 365 Customer Insights (Data) Specialty
How might these updates impact you?
The following questions and answers can help you determine how this news could impact your learning journey:
Q. What if I’m studying for Exam MB-210, Exam MB-220, or Exam MB-260?
A. If you’re currently preparing for Exam MB-210, Exam MB-220, or Exam MB-260, we strongly recommend that you take the exam before November 30, 2024. You won’t be able to take these exams or earn the associated certification after that date.
Q. I’ve already earned one of these certifications. What happens now?
A. If you’ve already earned the Microsoft Certified: Dynamics 365 Sales Functional Consultant Associate, Microsoft Certified: Dynamics 365 Customer Insights (Journeys) Functional Consultant Associate, or Microsoft Certified: Dynamics 365 Customer Insights (Data) Specialty certification, it will stay on the transcript in your profile on Microsoft Learn. If you’re eligible to renew your certification before November 30, 2024, we recommend that you consider doing so.
Q. Will this change impact Microsoft Partners?
A. For Microsoft Partners, those who have earned any of the eligible certifications before they retire will continue to earn points or credit toward offering requirements as long as those certifications remain on their transcript, until a year after the certifications are retired. New credentials may be eligible for inclusion in the Microsoft AI Cloud Partner Program (Partner Program) requirements. These changes will be shared with partners when additional details are available.
Partner skill-building for Customer Insights will continue as part of the initiatives from the Partner Program
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Entra Private Access for on-prem users
The emergence of cloud technology and the hybrid work model, along with the rapidly increasing intensity and sophistication of cyber threats, are significantly reshaping the work landscape. As organizational boundaries become increasingly blurred, private applications and resources that were once secure for authenticated users are now vulnerable to intrusion from compromised systems and users. When users connect to a corporate network through a traditional virtual private network (VPN), they’re granted extensive access to the entire network, which potentially poses significant security risks. These challenges have introduced new demands that traditional network security approaches struggle to meet. Even Gartner predicts that by 2025, at least 70% of new remote access deployments will be served predominantly by ZTNA as opposed to VPN services, up from less than 10% at the end of 2021.
Microsoft Entra Private Access, part of Microsoft’s Security Service Edge (SSE) solution, securely connects users to any private resource and application, reducing the operational complexity and risk of legacy VPNs. It enhances the security posture of your organization by eliminating excessive access and preventing lateral movement. As traditional VPN enterprise protections continue to wane, Private Access improves a user’s ability to connect securely to private applications easily from any device and any network—whether they are working at home, remotely, or in their corporate office.
Enable secure access to private apps that use Domain Controller for authentication
With Private Access (Preview), you can now implement granular app segmentation and enforce multifactor authentication (MFA) on any on-premises resource authenticating to domain controller (DC) for on-premises users, across all devices and protocols without granting full network access. You can also protect your DCs from identity threats and prevent unauthorized access by simply enabling privileged access to the DCs by enforcing MFA and Privileged Identity Management (PIM).
To enhance your security posture and minimize the attack surface, it’s crucial to implement robust Conditional Access controls, such as MFA, across all private resources and applications including legacy or proprietary applications that may not support modern auth. By doing so, you can safeguard your DCs—the heart of your network infrastructure.
A closer look at the mechanics of Private Access for on-prem user scenario
Here’s how Private Access helps secure access to on-prem resources and applications and provides a seamless way for employees to access the on-premises resources when they’re locally accessing these resources, while ensuring the security of the company’s critical services. Imagine a scenario where an employee is working on-premises at their company’s headquarters. They need to access the company’s DCs to retrieve some important information for their project or make some changes. However, when they try to access the DC directly, they find that access is blocked. This is because the company has enabled privileged access, which restricts direct access to the DC for security reasons.
Instead of accessing the DC directly, the employee’s traffic is intercepted by the Global Secure Access Client and routed to the Microsoft Entra ID and Private Access Cloud for authentication. This ensures that only authorized users can access the DC and its resources.
When the employee attempts to access the private resources they need, they’re prompted to authenticate using MFA. This additional layer of security ensures that only legitimate users can gain entry to the DC. Private Access also extends MFA to all on-premises resources, even those that lack built-in MFA support. This means that even legacy applications can benefit from the added security of MFA. With Private Access, the company has also enabled granular app segmentation, which allows them to segment access to specific applications or resources within their on-premises environment. This means that the employee can only interact with the services they’re authorized to access, ensuring the security of critical services.
Despite these added security measures, the employee’s user experience remains seamless. Only authentication traffic leaves the corporate network, while application traffic remains local within the corporate network. This minimizes latency and ensures that the employee can access the information they need quickly and efficiently.
Key benefits: Elevate network access security to on-premises resources with Private Access
Organizations seeking to enhance the security of their on-premises resources and protect their critical assets, including DCs, against identity threats can benefit from the key capabilities provided by Private Access—in preview. With Private Access, organizations can enable granular segmented access and extend Conditional Access controls to all their private applications.
Private Access allows for the implementation of MFA for private apps that use DC for authentication, adding an extra layer of security to prevent unauthorized access and reduce identity-related risks. By enabling granular segmented access policies for individual applications or groups, organizations can ensure that only authorized users interact with critical resources and services. Additionally, Private Access extends Conditional Access controls to all private resources, even those relying on legacy protocols, allowing organizations to consider factors such as application sensitivity, user risk, and network compliance when enforcing modern authentication methods across their entire environment.
Conclusion
Private Access provides granular access controls on all private applications for any user- on-premises or remote while bridging the gap between legacy applications and modern security practices. The capabilities of Private Access provide new tools to confidently enable secure access to private apps that use DC for authentication and navigate the complex landscape of modern authentication and access controls.
Explore the future of secure access today by joining Microsoft Entra Private Access in preview and stay ahead of evolving security challenges.
To learn more, watch “Announcing new capabilities to protect on-premises resources with MFA via Microsoft Entra Private Access” for a closer look into how these new capabilities work.
Read more on this topic
Microsoft Entra Private Access: An Identity-Centric Zero Trust Network Access Solution
Learn more about Microsoft Entra
Prevent identity attacks, ensure least privilege access, unify access controls, and improve the experience for users with comprehensive identity and network access solutions across on-premises and clouds.
Microsoft Entra News and Insights | Microsoft Security Blog
Microsoft Entra blog | Tech Community
Microsoft Entra documentation | Microsoft Learn
Microsoft Entra discussions | Microsoft Community
Microsoft Tech Community – Latest Blogs –Read More
Prompt Like a Pro with Microsoft Copilot in Teams
If you are looking for a smarter way to work with Microsoft Copilot in Teams, then look no further! “Prompt Like a Pro” is a monthly blog series from the Microsoft Teams Tech Community that will teach you how you can transform the way you work with AI. This post highlights the prompts* that have been featured to date so you can learn how to take advantage of Copilot in Microsoft Teams. From staying on top of your chats, to preparing for your week, to getting to decisions faster in meetings, Copilot in Teams has got you covered. So why wait? Explore the power of Copilot in Teams and start prompting like a pro today!
Stay on top of your chats with Copilot in Teams
It can be challenging to keep track of what is happening in your Teams conversations. Staying on top of everything is even harder when you have been traveling for work, are in training for a week, or work with people in different time zones. How do you ensure that you haven’t missed any important action items, decisions made, topics discussed, or anything else that might be relevant to your work?
Copilot in Teams chat can help you stay up to speed on all your conversations. With Copilot for Microsoft 365, you can leverage Copilot to answer questions, provide insights, and suggest actions based on your chat messages right in Teams. And one of the most useful prompts to use with Copilot in Teams is generating chat highlights. To learn more about this prompt, read the blog: Prompt Like a Pro: Stay on top of your chats with Copilot in Teams – Microsoft Community Hub
Prepare for your week with Microsoft Copilot in Teams
Do the number of meetings and tasks you juggle every week feel overwhelming? When your week ahead is full of meetings, emails to respond to, and content to review, it can be hard to know the best place to focus first and how to schedule your time.
Copilot in Teams gives you a quick and easy way to understand and prioritize how you spend your time before your week starts. Open Copilot from your Teams chat pane and use the prompt: “What do I have coming up this week?” to get started. To learn more, read the blog here: Prompt Like a Pro: Prepare for your week with Microsoft Copilot in Teams – Microsoft Community Hub
Get to decisions faster in Teams meetings with Microsoft Copilot
Copilot in Teams can help you get to decisions quicker during and after your meetings, no matter where everyone is connecting from. Use Copilot prompts to help your team visualize and evaluate ideas and make decisions based on them. As a result, you can avoid inefficient meetings by unlocking faster and more inclusive decision-making with the power of Copilot in Teams.
Copilot can also amplify your team’s brilliance, streamline decision-making, and transform meetings into efficient, productive, and action-oriented conversations. To learn how to get to decisions faster in your Teams meetings, read the blog here: Prompt Like a Pro: Get to decisions faster in Teams meetings with Microsoft Copilot – Microsoft Community Hub
Effectively summarize your channel conversations with Microsoft Copilot in Teams
Microsoft Teams channels help you have all your information related to a certain topic in one place. Yet with important documents being shared, ongoing conversations, and comments being added to threads, it can sometimes feel overwhelming! However, with a few simple tips and tricks, you can stay on top of your channels and avoid missing important updates.
To stay in the know across all your different channels – and the teams associated with those channels – look no further than Microsoft Copilot in Teams! With Copilot in Teams, you can go beyond just re-organizing your channels or setting up notifications and unlock richer insights and uncover your channel conversations with the power of AI. To learn more about what prompts to use to master engaging with your channel content in Teams, read the blog here: Prompt Like a Pro: Effectively summarize your channel conversations with Microsoft Copilot in Teams – Microsoft Community Hub
Additional resources
For more examples of prompts that Copilot can help you with, check out Copilot Lab. Filter by a specific M365 app to learn what prompts to use for meetings, in emails, and get tips for better optimized prompts across your favorite Microsoft 365 apps!
What’s coming next
Try out the featured Copilot prompts in Teams today and share the prompts you love for a chance to be featured on an upcoming blog post. Be sure to follow the Teams MTC site so you don’t miss the next prompt of the month and other Teams blogs, and before you know it you will be prompting like a pro as well!
*Copilot is constantly evolving and improving thanks to your input and feedback. If a Copilot prompt does not work the way you expect it to, let us know how by using the thumbs-down button that appears after a response.
About the Author
Luca Valadares is the AI Compete and Positioning Lead for Microsoft Teams, with a focus on creating more awareness for and usage of the AI available in Microsoft Teams. He has a strong background in marketing and business, and has amassed significant AI experience proficiency over the course of his time at Microsoft.
Microsoft Tech Community – Latest Blogs –Read More
Data API builder is now Generally Available | Data Exposed
Data API builder (DAB) is Microsoft’s open-source engine designed to expose Azure databases to client applications and customers through secure, feature-rich REST and GraphQL endpoints. It’s cross-platform, language-independent, and runs in a Docker-friendly container in any cloud and even on-premises. DAB is three years in the making, with thousands of engineering hours invested and stuffed with best practices. Best of all, it’s free & as of this week, generally available. Learn more in this episode of Data Exposed.
Resources:
Github: https://aka.ms/dab
View/share our latest episodes on Microsoft Learn and YouTube!
Microsoft Tech Community – Latest Blogs –Read More
Get Certified with GitHub
GitHub and Microsoft are helping you to boost your tech career with the Get Certified with GitHub livestream series! Starts from June 5th until June 26th. These sessions are designed to help you get certified on the GitHub Foundation Certification and to help you explore essential tools like GitHub Copilot and GitHub Codespaces. Plus, you’ll have the chance to earn a free certification voucher for the GitHub Foundation Certification*
REGISTER HERE: aka.ms/GetCertifiedwithGitHub
* At the end of the session, you may even receive a free GitHub certification voucher, on a first-come, first-served basis.
Offer good only while supplies last. Limit one GitHub voucher per person. This offer is non-transferable and cannot be combined with any other offer. This offer ends on June 27, 2024 or while supplies last, and is not redeemable for cash. Taxes, if any, are the sole responsibility of the recipient. Microsoft reserves the right to cancel, change, or suspend this offer at any time without notice.
Earning certification from GitHub is an excellent way to showcase your abilities, reputation, trust, and understanding of the tools and technologies used by over 100 million developers worldwide.
You’ll be interacting with Microsoft and GitHub Experts that will guide you during all these sessions about different topics related to the GitHub Foundation certification.
Also, by registering and attending the live sessions you may be able to receive a free certification voucher on a first-come, first-served basis
Earning a GitHub Certification gives you a competitive edge in the job market by allowing you to promote your skills in a specific GitHub domain.
These sessions will be full of tips, tricks, and practical exercises to help you build a great foundation for this certification. Whether you’re just starting out or looking to improve your skills, this is a must-see event for anyone interested in growing their career in tech.
All our sessions will take place in Pacific Time.
Session
Description
Building Automation with GitHub
June 5th – 11 am Pacific Time
Find out how you can create powerful automation on any software project using GitHub’s platform. This session will cover GitHub Actions, GitHub Copilot, and GitHub Codespaces
Securing projects on GitHub
June 12th – 11 am Pacific Time
Discover how to apply security features from GitHub Advanced Security to your own projects and protect it from security threats and vulnerabilities.
Faster development with GitHub Copilot
June 19th – 11 am Pacific Time
Learn how to leverage GitHub Copilot for automating repetitive tasks and increasing your development cycles. We’ll go through basic usage as well as newer features like interactive prompts and inline suggestions
Manage your project with the GitHub Platform
June 26th – 11 am Pacific Time
Use GitHub’s powerful project features to manage your software development process. We’ll cover project management with issues, pull requests, and tracking changes.
With the GitHub Foundations certificate, you can highlight your understanding of the foundational topics and concepts of collaborating, contributing, and working on GitHub. This exam covers:
Collaboration
GitHub products
Git basics
Working within GitHub repositories
We are super excited to announce the GitHub Challenge as part of the Microsoft Learn Challenge | Build Edition! This is part of Microsoft Build 2024, our largest developer event of the year. Registrations to the challenge are open – register NOW! (aka.ms/GitHubChallengeBuild)
The GitHub Challenge is a 30-day learning adventure on Microsoft Learn! It’s completely free, super fun, with dynamic exercises. Dive in to master GitHub Copilot! Plus, you’ll create interesting adventures with Python and JavaScript while using GitHub Codespaces and create real-world projects with GitHub Copilot —just in time for Microsoft Build! This challenge starts on May 21st and ends on June 21st 2024.
We want to support you in developing and upgrading your abilities! Prepare to take on this exciting challenge and level up. This learning journey has been designed to increase your understanding of AI and make you a GitHub Copilot expert! This challenge will help you prepare for the GitHub Foundations certification exam by covering a few topics that may appear on the test.
The GitHub Challenge is available every day at any time on Microsoft Learn. You can learn whenever it’s convenient for you and at your own speed.
By completing this challenge before June 21st 2024, you will receive a special and distinctive digital badge on your Microsoft Learn profile for finishing this learning experience. You can share your badge on your LinkedIn!
This badge is only available during Microsoft Build, our largest developer event of the year.
Take this amazing and unique opportunity to keep learning and growing your career in tech! Registrations to the challenge HERE!
We have a comprehensive, free, dynamic exercise guide to help you prepare for this certification. You can read all the information you need, here: aka.ms/InfoGuideGitHub
The voucher code will be entered manually during the checkout process. Below are the registration and scheduling steps:
Log into the exam registration site and choose the desired certification. This will redirect you to the registration page.
Click on “Schedule/take exam” to proceed.
Complete the registration form and select “Schedule exam” at the bottom.
This action will transmit your eligibility details to our testing vendor, PSI.
Upon submitting the registration form, you’ll be directed to the PSI testing site to finalize the scheduling of your exam.
During the checkout process on the PSI testing site, you’ll encounter a designated field where you can enter the voucher code to zero the balance.
Microsoft Tech Community – Latest Blogs –Read More