Introduction to clustering models by using R and Tidymodels – part 4 of 4

Introduction to clustering models by using R and Tidymodels – part 4 of 4

This article is contributed. See the original author and article here.

bethanyjep_0-1656920903082.png


In the previous episodes, we have journeyed through airports, real estate, and wine industry, gaining insight on the different industries, and utilizing the data in decision making. Alas, now we are in the final episode of a Four-part series – An introduction to R and Machine learning. Join us for the session at Introduction to clustering models by using R and Tidymodels – part 4 of 4, Tue, Jul 12, 2022, 4:00 PM | Meetup. If you missed previous episodes, watch them on demand below: 



 


Introduction to clustering models by using R and Tidymodels – part 4 of 4


In this session, you will train a clustering model. Clustering is the process of grouping objects with similar objects. This kind of machine learning is considered unsupervised because it doesn’t make use of previously known values to train a model. 


Who is it aimed at? 
This session is aimed at anyone who would like to get started with data science in R 


Why should you attend? 
Get an introduction to clustering models and learn how to train a clustering model in R 


Any pre-requisites? 
Knowledge of basic mathematics 
Some experience programming in R 


 


Speaker Bio’s 
Carlotta Castellucio – Cloud Advocate, Microsoft 
Carlotta Castelluccio is a Cloud Advocate at Microsoft, focused on Data Analytics and Data Science. As a member of the Developer Relationships Academic team, she works on skilling and engaging educational communities to create and grow with Azure Cloud, by contributing to technical learning content and supporting students and educators in their learning journey with Microsoft technologies. Before joining the Cloud Advocacy team, she worked as an Azure and AI (ARTIFICIAL INTELLIGENCE) consultant in Microsoft Industry Solutions team, involved in customer-face engagements focused on Conversational AI solutions. Carlotta earned her master’s degree in Computer Engineering from Politecnico di Torino and her Diplôme d’ingénieur from Télécom ParisTech, by completing an E+/EU Double Degree Program. 


 


Eric Wanjau – Data Scientist/Researcher at the Leeds Institute for Data Analytics (LIDA) 


Eric is an Early Career Researcher who continually seeks to tackle real-world challenges using applied research, data analytics and machine learning; all wrapped in unbridled empathy and enthusiasm. He is currently a Data Scientist/Researcher at the Leeds Institute for Data Analytics (LIDA) in the University of Leeds, working on the British Academy project undertaking urban transport modelling in Hanoi. He has also done research in robotics, computer vision and speech processing in Japan and Kenya, aimed at creating safe working environments and exploring human-robot interaction in board games. Eric holds a BSc. in Electrical and Electronic Engineering (2021) from Dedan Kimathi University of Technology Kenya. He plays the guitar (terribly but passionately). 


Join us for the session. 

#JulyOT 2022 -31 days of IoT content for everyone starting 1st July

#JulyOT 2022 -31 days of IoT content for everyone starting 1st July

This article is contributed. See the original author and article here.

Animated July O T logoAnimated July O T logo


 


#JulyOT is back for 2022! Throughout the month of July, the IoT teams at Microsoft will be sharing content and events put together by IoT enthusiasts from around the world.  This includes content from community members, Microsoft employees, and could even involve you!   For every working day in July, we’ll focus on one or more featured content pieces from our curated collection at the new home of #JulyOT – JulyOT.dev!.  The idea is to inspire those curious about IoT to pursue their own personal projects within the realm of Internet of Things, and then share them on social media with the hashtag #JulyOT.


 


We’ll be updating JulyOT.dev with new content every working day in July, so check back there often, or subscribe to the RSS feed. We’ll also be updating this post at the end of each week with a round up of what we covered in that week.


 


IoT live streams


 


IoT for Beginners Reactor stream logoIoT for Beginners Reactor stream logo


 JulyOT kicks off with live streams from the Microsoft Reactor. Check out our events page to learn more and register. These include the first 4 lessons of IoT for Beginners, our free, open source IoT curriculum, as well as live streams in English and Spanish.


 


IoT Cloud Skills Challenge


A cartoon raccoon holding medalsA cartoon raccoon holding medals


We’ll also challenge y’all to grow your IoT skills with a cloud skills challenge! More details coming on the 1st July.


 


Digital swag


What better way to celebrate #JulyOT than with digital swag! Set your desktop or video chat background, and get cool visuals to share on social on our digital swag page.


 


Enjoy the celebration of #JulyOT


See you all at JulyOT.dev as we celebrate #JulyOT.


 


 

Recommendations for Oracle 19c Patches in Azure

Recommendations for Oracle 19c Patches in Azure

This article is contributed. See the original author and article here.

Oracle 19c is the terminal release for Oracle 12c.  If you aren’t familiar with that term, a terminal release is the last point release of the product.  There were terminal releases for previous Oracle versions (10.2.0.4, 11.2.0.7.0) and after 19c, the next terminal release will be 23c.  Therefore, you don’t see many 18c, 20c or 21c databases.  We’ve gone to yearly release numbers, but the fact remains that 19c is going to receive all major updates and continue to be supported unlike the non-terminal releases.


 


Oracle will tell you for support, you should be upgrading to 19c.  Premier Oracle Support ended for December 1st, 2020 and as we discussed, not many are going to choose or stay on non-terminal releases, so 19c is it.


 


upgrade.gif


With that said, we must offer guidance on recommended practices for Oracle versioning and patching in Azure.  Although I will list any bugs and document IDs that back up the recommendations I’m making, be aware that many of these will be behind Oracle Support’s paywall, so you’ll only be able to access them with an Oracle Support CSI.  Let’s talk about the things not to do first-


Don’t Upgrade DURING Your Migration


I know it sounds like an awesome idea to upgrade to the latest database version while you are migrating to the cloud, but please, don’t do these two things- migrating to the cloud and upgrading the database/app at the same time.  It’s a common scenario that I’m brought in after the Azure specialists are left scratching their head or scrambling to explain what has changed and then I come in to tell them to stand down because it’s the DATABASE THAT’S CHANGED. 


 


Do Patch to the LATEST Patchset for Oracle


I am part of the crowd that often did the latest patchset -1 approach.  We would always be one patchset behind and let others figure out how many bugs might be introduced by the patch that had sneaked through testing. 


 


Not anymore… I have a few customers on 19.14, which should be safe, considering the previous practice I mentioned, but the sheer number of bugs and serious bugs that were experienced has changed my thinking to recommend going to the latest patchset.


 


I think it’s easy to think, “Oh, it’s just a small bug” but I’m in agreement with you, if it’s a small impact and it has an easy work around, that’s one thing, but these bugs I’m referring to are quite impactful and here’s how:


High CPU Usage



  • 19.14 release, there were 11 bugs that caused high CPU usage for Oracle.

  • High CPU usage to the point of doubling the core count for the VM the database ran on in Azure.

  • Doubling the need for Oracle licenses for the database, even though it was a bug that was causing all the additional CPU usage.

  • At $47500 list price per processor license, this isn’t something I’d recommend letting go on.


For one customer that I was deeply involved in, the VM sizing required 20 vCPU to run the workload.  I sized up to 32 vCPU for peak workloads and yet they were at 97.6% CPU busy with a 64-core machine.  The workload hadn’t changed, and the CPU usage traced was out of control!


I would start here: After Upgrade to 19c, One or More of the Following Issues Occur on Non-Linux Platforms: High Paging/Swapping, High CPU, Poor Performance, ORA-27nnn Errors, ORA-00379 Errors, ORA-04036 Errors (Doc ID 2762216.1)


 


Bug examples for high CPU usage in 19.14:


























































































NB



Prob



Bug



Fixed



Description


 

II



31050103



19.15, 23.1.0.0.0



fbda: slow sql performance when running in pluggable database


 



32869560



19.15, 21.6



HIGH CPU ON KXSGETRUNTIMELOCK AND SSKGSLCAS


 

I



29446010



20.1



Query Using LIKE Predicate Spins Using NLS_SORT=’japanese_m’ NLS_COMP=’linguistic’


 



32431067



23.1.0.0.0



Data Pump Export is Slow When Exporting Scheduler Jobs Due to Query Against SYS.KU$_PROCOBJ_VIEW


 



33380871



19.15, 21.6



High CPU on KSLWT_UPDATE_STATS_ELEM


 



33921441



19.15



Slow performance in AQ dequeue processing



*



II



32075777


 

Performance degradation by Wnnn processes after applying july 2020 DBRU


 

III



32164034


 

Database Hang Updating USER$ When LSLT (LAST SUCCESSFUL LOGIN TIME) Is Enabled


 

III



30664385


 

High count of repetitive executions for sql_id 35c8afbgfm40c during incremental statistics gathering


 

II



29559415


 

DMLs on FDA enabled tables are slow, or potential deadlocks on recursive DML on SYS_FBA_* tables


 

II



29448426



20.1



Killing Sessions in PDB Eventually Results in Poor Buffer Cache Performance Due To Miscalculating Free Buffer Count



 


Time Slip


This issue will often display an ORA-00800 error and you will need to check the extended trace file for details.  It will include the VKTM in the error arguments.


 


…/trace/xxxxx_vktm_xxxx.trc


ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes]

The trace file will include additional information about the error, including:


Kstmmainvktm: failed in setting elevated priority

Verify: SETUID is set on ORADISM and restart the instance highres_enabled

 


This refers to a bug and has two documents around time drift and how to address it-


ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM] (Doc ID 2718971.1)


I’d also refer to this doc, even though you aren’t running AIX:


Bug 28831618 : FAILED TO ELEVATE VKTM’S PRIORITY IN AIX WITH EVENT 10795 SET


 


Network Connection Timeouts


Incident alerting will occur in the alert log, and it will require viewing the corresponding trace file for the incident.


 


ORA-03137: malformed TTC packet from client rejected.

ORA-03137: Malformed TTC Packet From Client Rejected: [12569] (Doc ID 2498924.1)


Potential Tracing to gather more data:


Getting ORA-12569: TNS:Packet Checksum Failure While Trying To Connect Through Client (Doc ID 257793.1)


 


Block Corruption


Thanks to Jeff Steiner from the NetApp team who advised on this one.


Bug 32931941 – Fractured block Corruption Found while Using DirectNFS (Doc ID 32931941.8)



  • This can result in 100’s to 1000’s of corrupted blocks in an Oracle database.

  • All customers using dNFS with 19c should run 19.14 or higher to avoid being vulnerable to this bug.


Also follow the Recommended Patches for Direct NFS Client (Doc ID 1495104.1)


Summary


If you’re considering an upgrade to Oracle 19c, please review the following Oracle Doc:


Things to Consider to Avoid Database Performance Problems on 19c (Doc ID 2773012.1)


It really is worth your time and can save you a lot of time and headache.


 

Row Level Security in Power BI Desktop

Row Level Security in Power BI Desktop

This article is contributed. See the original author and article here.

Picture1.png


 


 


The Same KPIs, Different Department


 


Scenario: You have different managers requesting to see the same KPIs (Customer Count, Revenue Generated, Products Performance, etc) for their different region. Data privacy requires that the various managers only see reports for their regions. A simple way to think about this is by creating different reports for the managers making a total of 3 Reports. 


 


I am sure you will agree with me that this isn’t effective. more efforts and it is not scalable. what if it is a large multinational – country manager, regional manager, group manager, unit head, team leads all across the world? will you also build different reports for over 500 people? With Row Level Security, you can easily address this challenge by building a single Reports and set roles and rules to filter what everyone can see.


 


 


Learn and Practice Along here:


 


 


 


Additional Resources



 


 

Streamline sales actions with Dynamics 365 sales accelerator

Streamline sales actions with Dynamics 365 sales accelerator

This article is contributed. See the original author and article here.


The sales accelerator in Dynamics 365 provides a tailored experience for sellers by minimizing the time spent searching for the best next customer to reach out to. It’s a workspace optimized with AI and suggested activities that guide sellers through customer interactions. The sales accelerator enables your sales team to prioritize their pipeline, reach out to prospects most likely to buy, and respond to recommendations, speeding up the sales process.

Our teams are constantly reviewing customer feedback and optimizing the experience. We have two new updates you’ll see immediately in your environments:

  • Sales Hub users now get out-of-the-box access to the sales accelerator workspace. (If you use a custom app, additional steps might be required to surface the capabilities.)
  • Sales engagement managers can discover and configure the sales accelerator in a newly streamlined onboarding process.

Let’s take a deeper look at these improvements.

Out-of-the-box access to the sales accelerator workspace

Sales Hub users will now be able to instantly access the sales accelerator from the left pane on the site map menu. As they access the sales accelerator, sellers will immediately see any activities scheduled for them in the worklist. Without navigating away from the screen, they can see who to contact next, filter and sort the records to their chosen priority, and then take the best next action.

Sales Hub is a Microsoft app that’s designed around the sales processes that most organizations follow. If you’re new to Dynamics 365 Sales and wondering whether to use the Sales Hub app or create a custom app, this comparison will help you decide.

If you’re already using a custom app, you’ll need to add the sales accelerator to your site map to allow users to see and select it from the left pane.

Simple onboarding and setup

The following improvements help sales engagement managers and admins discover and engage with the right options to implement and deploy the sales accelerator more efficiently:

  • Independently configured sales accelerator workspace and optimized assignment rules
  • Context-specific settings
  • Setup recommendations

Independently configure access to the workspace and assignment rules

Assignment rules enable new leads and opportunities to be automatically assigned to sellers or sales teams. This helps reduce the time and effort required to manually assign records, prevent the loss of unassigned records, and balance assignments among sellers.

Assignment rules can now be independently used or aligned to the use of the sales accelerator. This allows you to select the right options for your sellers and ensure they receive the records to work on, regardless of workspace area. We’ve introduced the ability to set security roles to separately control access to the sales accelerator workspace and assignment rules.

A security role defines how users may access different types of records. You can modify existing security roles, create new security roles, or change which security roles are assigned to each user. Learn more about security roles.

To configure access to the sales accelerator workspace, choose security roles in the Manage access and record type section of the workspace settings page.

Screenshot of the Manage access and record type section of the sales accelerator workspace settings page, with security roles highlighted.

To configure access to assignment rules, choose security roles in the Team settings section of the assignment rules settings page.

Screenshot of the Team settings section of the assignment rules settings page, with security roles highlighted.

Context-specific settings

Advanced settings for sequences, assignment rules, and sales teams are now available in context, on the page, rather than requiring navigation to another settings area. This screenshot shows an example of the new in-context settings, using seller availability:

Screenshot of the new in-context seller availability settings.

Personalize your workspace

To improve sellers’ productivity, we help them focus on who to engage next. To that end, you can now customize the workspace filters. For example, sellers might want to filter work items based on the lead source, such as website inquiry. Add a filter based on Lead as the record type and Leadsource as the field.

We encourage you to try out different capabilities to get the most out of the sales accelerator. To help you discover its capabilities, we show recommended next steps in workspace settings. Recommendations are tailored to the sales process and based on where your organization is in the setup process, taking away the guesswork and guiding you on a recommended path for a successful implementation.

Stay tuned for more exciting improvements to come, such as customizable worklist cards, advanced sorting, and a new sequence designer experience!

Next steps

The post Streamline sales actions with Dynamics 365 sales accelerator appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.