Hello TM1 experts,
We are a group of two students Mastering in IT and have scored excellent results in Data Warehousing, Mining. We are towards our final year and have to do a Project to finish off just before graduation. We want to do a project in Warehousing and on the way learn this intelligent tool TM1.
We are not sure what a concrete project topic would be and want your help in providing us with some projects? which can also help two students learn this tool and get towards our Masters degree.
Thank you very much. Eagerly waiting for a reply.
Project Ideas
-
- Posts: 1
- Joined: Fri Feb 08, 2013 7:19 am
- OLAP Product: SQL
- Version: 10.1
- Excel Version: 2012
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Project Ideas
Unfortunately your question is a "how long is a piece of string" one.Dataware1234 wrote:Hello TM1 experts,
We are a group of two students Mastering in IT and have scored excellent results in Data Warehousing, Mining. We are towards our final year and have to do a Project to finish off just before graduation. We want to do a project in Warehousing and on the way learn this intelligent tool TM1.
We are not sure what a concrete project topic would be and want your help in providing us with some projects? which can also help two students learn this tool and get towards our Masters degree.
Thank you very much. Eagerly waiting for a reply.
TM1 is essentially a rules-based, calculation engine which lives on a server, and which offers a range of front end clients. Some clients perform administrative tasks, some data input and output.
Concrete projects? The scope is limited by your imagination and ability to represent your data as numeric values.
Build a bottom up budgeting system? Yes, it can.
Build a top down budgeting system? Sure.
Serve as a data warehouse? Easy, as long as you have the necessary skills.
Power a management information dashboard? No problem.
Rolling forecasts? Production costing and planning? Certainly. Just as with (say) SQL Server (or any other RDBMS) or even a tool like Excel, say, you're presented with specific built-in functionality and it's up to you to determine what projects you want to do with it. There's no limited list of potential projects, there's not even a typical list of potential projects. Budgeting or GL reporting are not uncommon, certainly, but the way that they're implemented can be radically different from one organisation to another.
However you face a more fundamental problem. TM1 is not a tool that you can learn in theory. You can never really understand TM1 unless you "do" TM1. And unlike some other products there is no "Express" or "Community" edition, nor is there a reasonably priced personal edition of it. If you want it you have to pay money. Big money. Personally I think that this is a bad policy on IBM's part just as I thought it was a bad policy on Applix's part before them since it limits the growth in the number of users who are familiar with TM1. It therefore limits the tool's growth. However that's a different conversation.
Unless you have some way of getting your hands on a copy of it (perhaps through an internship at an IBM partner, say), I think you'll have a hard time using TM1 as the basis of your masters degree.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Project Ideas
If you qualify for the IBM Academic Initiative you should be able to get free access to the software to use in your studies.
If you cannot get membership yourselves then it may be that your faculty staff can join and get the software for you to use.
If you cannot get membership yourselves then it may be that your faculty staff can join and get the software for you to use.
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Project Ideas
Nice one; I was unaware of that program. I'll have to take a look and see if I can find a home for that in the FAQ since I know that we do get periodic requests from those seeking to study the software.Duncan P wrote:If you qualify for the IBM Academic Initiative you should be able to get free access to the software to use in your studies.
If you cannot get membership yourselves then it may be that your faculty staff can join and get the software for you to use.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Project Ideas
Indeed. For motivated students and faculty staff, it might be interesting to set up a financial model in TM1 for the faculty. Budgeting is an important topic at universities.Duncan P wrote:If you cannot get membership yourselves then it may be that your faculty staff can join and get the software for you to use.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- mattgoff
- MVP
- Posts: 516
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Project Ideas
I'm skeptical that any implementation project would be sufficient for a Masters program. I'm not sure what an "IT" Masters degree even is, but I presume that you would need to do something novel, likely involving the API.
Matt
Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Project Ideas
Writing a functional editor for TI and a decent Rules editor should be worth a PhD at least...mattgoff wrote:I'm skeptical that any implementation project would be sufficient for a Masters program. I'm not sure what an "IT" Masters degree even is, but I presume that you would need to do something novel, likely involving the API.
![Twisted Evil :twisted:](./images/smilies/icon_twisted.gif)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- mattgoff
- MVP
- Posts: 516
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Project Ideas
For anyone else looking for projects, here's my comprehensive list:Alan Kirk wrote:Writing a functional editor for TI and a decent Rules editor should be worth a PhD at least...mattgoff wrote:I'm skeptical that any implementation project would be sufficient for a Masters program. I'm not sure what an "IT" Masters degree even is, but I presume that you would need to do something novel, likely involving the API.
- CS -> create a way to use Perl (or C# or really anything, I'll learn it as long as it's modern) to replace TI, maybe via the API
- CS -> create a way to perform efficient and reliable replications outside TM1, maybe also via the API
- UX -> redesign the terrible interface (especially iconography) and beg IBM to use it
- MSIS -> fix the documentation and post publicly under a CC license
- MSIS -> repackage 10.x into individual installer components so I don't have to deploy 2GB installers to my users
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
- Steve Rowe
- Site Admin
- Posts: 2424
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Project Ideas
Assuming you have access to the software, you can think further out of the box than a pure finance app, it is easy to lose sight of the fact that with TM1 you can build many kind of models.
In a past life I've built a revenue model for a training company which modelled the flow of pupuls through various stages of their training courses. More complex than it sounded with revenue being generated in the middle and at the end of each module and so x% of people quitting or moving on to the next stage of the model. I should think there were obvious parallels with the above and a University.
You could also try networking with your colleagues on other courses and see if they have problems they are trying to solve. I do think that TM1 could be used in a variety of pure academic research areas other than the rather dull lets add the accounts up that TM1 is marketed for these days.
Will be interesting to see how you get on!
Cheers
In a past life I've built a revenue model for a training company which modelled the flow of pupuls through various stages of their training courses. More complex than it sounded with revenue being generated in the middle and at the end of each module and so x% of people quitting or moving on to the next stage of the model. I should think there were obvious parallels with the above and a University.
You could also try networking with your colleagues on other courses and see if they have problems they are trying to solve. I do think that TM1 could be used in a variety of pure academic research areas other than the rather dull lets add the accounts up that TM1 is marketed for these days.
Will be interesting to see how you get on!
Cheers
Technical Director
www.infocat.co.uk
www.infocat.co.uk