OLTP database, trying to ease the reporting difficulties

the two servers involved are sql 2014 and sql 2016
Our billing system is an OLTP database and it is very hard to report off of.   I have been reading on OLAP and ssas.  Is there a good manual or starting place for a rookie to try to overcome the reporting issues.
any ideas on should i start with trying to use ssas or creating an olap database from the online transactional database.
jamesmetcalf74Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pushpakumara MahagamageVPCommented:
Creating a Data cube and grant access to finance people would be the best option. becouse they are excel experts and they can view data as they wish from data cube.
Read following article and create SSAS Data cude.

https://www.mssqltips.com/sqlservertutorial/4203/sql-server-analysis-services-installation/

https://www.youtube.com/watch?v=ct_hn_e_59k  (I didn't watch entire video)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm not sure if you really want to go for SSAS for this.
Being hard to report from your OLTP database, it might means that perhaps isn't well designed instead of "not work for an OLTP db".
If you can be more specific with the kind of report are you trying to obtain, it may help us to advice you better.
0
jamesmetcalf74Author Commented:
Thanks Guys
0
Pushpakumara MahagamageVPCommented:
You are welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSAS

From novice to tech pro — start learning today.