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


Reply
 
Thread Tools Search this Thread 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: 219
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,872
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: GLMs, Bayesian Stats, Time Series
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: 48,121
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: 48,121
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 jas66Kent is offline
Member
SOA
 
Join Date: May 2012
Location: London
Favorite beer: Corona :)
Posts: 22,630
Default

I have to use sharepoint and it is annoying as f*ck.
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: 48,121
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: 30,074
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
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 2,752
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
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 2,752
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: 219
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 Search this Thread
Search this Thread:

Advanced Search
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 05:29 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, 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.27685 seconds with 11 queries