Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Upload your resume securely at https://www.dwsimpson.com
to be contacted when our jobs meet your skills and objectives.


Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2017, 03:42 PM
Idiot's Avatar
Idiot Idiot is offline
Member
CAS
 
Join Date: Jun 2012
College: ITT Tech
Posts: 215
Default Has anyone done a migration to Office 365?

For security reasons, our company is planning to move ALL our network files to the online Sharepoint site. We are currently using a shared network drive.

So far the process has been poorly explained. But apparently we can use our local Excel programs to access the online files. How will this affect any links to other spreadsheets and our macros that open other files? There isn't any apparent functionality like Google Drive or Dropbox where the local files are synced online. It's all stored online only. And when accessing SQL servers, you need a local DSN file right? So many things that can go wrong

Has anyone else gone through this? What other things would concern you? I feel like this has potential to totally ruin our workflow.
__________________
exam 666
Reply With Quote
  #2  
Old 11-11-2017, 10:45 AM
clarinetist clarinetist is offline
Member
Non-Actuary
 
Join Date: Aug 2011
Studying for Rcpp, Git
Posts: 6,747
Default

Ask for OneDrive.

It drives me nuts how much people love SharePoint.
__________________
If you want to add me on LinkedIn, PM me.

Why I hate Microsoft Access.

Studying/Reading: Statistical Inference, Bayesian Data Analysis
Reply With Quote
  #3  
Old 11-11-2017, 11:38 AM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is offline
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 44,987
Default

Quote:
Originally Posted by Idiot View Post
And when accessing SQL servers, you need a local DSN file right? So many things that can go wrong
Depends on what you're trying to access it. If you're using SSMS you can just connect directly by using your credentials. with a programming language, you'll need the appropriate connection string.
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
Reply With Quote
  #4  
Old 11-11-2017, 11:44 AM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is offline
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 44,987
Default

Quote:
Originally Posted by Idiot View Post
For security reasons, our company is planning to move ALL our network files to the online Sharepoint site. We are currently using a shared network drive.

So far the process has been poorly explained. But apparently we can use our local Excel programs to access the online files. How will this affect any links to other spreadsheets and our macros that open other files? There isn't any apparent functionality like Google Drive or Dropbox where the local files are synced online. It's all stored online only. And when accessing SQL servers, you need a local DSN file right? So many things that can go wrong

Has anyone else gone through this? What other things would concern you? I feel like this has potential to totally ruin our workflow.
The problem can be solved by just getting rid of spreadhseets. I don't use Excel for any serious work, except for keeping track of my calorie intake. I use MS Azure as my centralized data store.

Most analytical work is done via scripting with web technology (Javascript/CSS/HTML) as a reporting layer for dashboards and presentations.

If you want to keep it limited to MS, you can do something like:

(Data stored in Azure) -> (Analytics with Spark, Microsoft R HDI) -> (Presentations with power BI)
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
Reply With Quote
  #5  
Old 11-11-2017, 12:09 PM
jas66Kent's Avatar
jas66Kent jas66Kent is offline
Member
SOA
 
Join Date: May 2012
Location: London
Favorite beer: Corona :)
Posts: 21,211
Default

I have to use sharepoint and it is annoying as f*ck.
__________________
Quote:
“Stupidity is a more dangerous enemy of the good than malice. Against stupidity we are defenseless. Neither protests nor the use of force accomplish anything here; reasons fall on deaf ears; facts that contradict one’s prejudgment simply need not be believed – in such moments the stupid person even becomes critical – and when facts are irrefutable they are just pushed aside as inconsequential, as incidental. For that reason, greater caution is called for when dealing with a stupid person than with a malicious one".
Reply With Quote
  #6  
Old 11-11-2017, 01:19 PM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is offline
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 44,987
Default

So does everyone agree that OP should go back to management and say, "don't do it, some guys from the AO tried it before and said it was a bad idea." ?
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
Reply With Quote
  #7  
Old 11-11-2017, 04:02 PM
nonlnear nonlnear is offline
Member
Non-Actuary
 
Join Date: May 2010
Favorite beer: Civil Society Fresh IPA
Posts: 27,620
Default

Quote:
Originally Posted by jas66Kent View Post
I have to use sharepoint and it is annoying as f*ck.
This.

SharePoint has got to be one of the worst products ever produced.
Reply With Quote
  #8  
Old 11-11-2017, 04:15 PM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS AAA
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 2,044
Default

Quote:
Originally Posted by jas66Kent View Post
I have to use sharepoint and it is annoying as f*ck.
Which version of SharePoint?

The older versions of SharePoint are annoying as f*ck.

I've only casually played with the current version of SharePoint (friends at Microsoft = free Office365 subscription), but it seems much better behaved as regards Office applications, approaching the level of being almost indistinguishable from networked drives at first glance.

I'd be interested in hearing if my impression is incorrect.
Reply With Quote
  #9  
Old 11-11-2017, 04:19 PM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS AAA
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 2,044
Default

Quote:
Originally Posted by Colonel Smoothie View Post
The problem can be solved by just getting rid of spreadhseets.
Unfortunately, some of us have to work with non-actuaries whom we're lucky to get to basic level of Excel proficiency.
Reply With Quote
  #10  
Old 11-15-2017, 01:31 AM
Idiot's Avatar
Idiot Idiot is offline
Member
CAS
 
Join Date: Jun 2012
College: ITT Tech
Posts: 215
Default

Quote:
Originally Posted by Maphisto's Sidekick View Post
Unfortunately, some of us have to work with non-actuaries whom we're lucky to get to basic level of Excel proficiency.
this, our teammates would rather quit than replace Excel for their work. i confirmed that we can open the cloud files with local Excel to edit, but i don't know how the linking/calling between files would work.
__________________
exam 666
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 08:17 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.20464 seconds with 11 queries