Who are you?
I am currently an Independent Consultant, and I specialize in Data Warehousing, Dimensional Modeling, SQL Server Integration Services (SSIS), Business Intelligence Markup Language (Biml), and technical training. I’ve been working with SQL Server for well over 10 years gaining a mastery of the full Microsoft Business Intelligence Stack. This, bolstered by my teaching experience and Bachelors Degree in Education, is why I enjoy sharing my passion for Data Warehousing so much.
I’m highly active in the PASS Community on all levels as I frequently present at SQL Saturdays and SQL Server User Group Meetings. I’m very active as a PASS volunteer as well.
I’m also considered one of the foremost experts in the Made2Manage ERP System. I’m particularly skilled in customizing M2M functionality with Visual Basic, FastForms, and other methods; as well as integrating it with other computer systems, and providing expert level reports in a variety of mediums. I also provide technical support to several M2M companies on an as-needed basis.
Why do you blog?
As I mentioned earlier, I have a passion for Data Warehousing and Analytics. However, I enjoy connecting with people even moreso. I’d like to invite you to read my posts, watch my videos, and learn with me. Note that I said “With” because I love learning and I probably learn more from the blogging process than my readers.
I also use this blog to document the process of my work. I find that if I don’t write notes about what I’m doing, then I have to re-invent the wheel every time a similar challenge presents itself in the future.
What can I do for you?
I solve problems. If you have some, I offer a wide array consulting services with an emphasis in the following:
- Data Warehouse Design/Dimensional Modeling
- SQL Server Integration Services
- Biml Scripting
- SQL Server Reporting Services
- SQL Server Analysis Services
- Qlikview Data Analytics and Dashboarding
- SQL Server Development
- SQL Server Administration and Disaster Recovery
- Customization, Business Intelligence, and Troubleshooting Services for users of the Made2Manage ERP System.
If you need someone with experience to help you learn any of the above skills, I’d be glad to help. I also have an extensive professional network which includes the very best practitioners in every field of data science, so I can always find the help you need.
I also enjoy connecting with people and introducing them to the PASS Community.
How can I contact you?
Feel free to contact me through any one of the following:
- Email: David@Made2Mentor.com
- Twitter: @Made2Mentor
- LinkedIn: LinkedIn Profile
Finally got a chance to check out your blog and I’ve got to say I’m impressed. You’ve obvoiusly put some time into it and it looks like it’s beginning to generate the kind of dialouge you’re looking for. I really like the avatar. It made me laugh a little, how appropriate! Where did you find it?
Thanks for the compliments. I used the South Park Studios Character Generator.
Give it a try here: http://www.sp-studio.de/
I substituted it as I need to get some decent pictures taken, maybe at the Vegas User Conference.
Collecting and playing video games, eh?
And which games (or types of games) might the most frequently played be?
David, what a great site. It really looks good, and it provides a lot of useful information.
David, you’ve got a great site going here. Any chance you’re attending PASS in Seattle?
I would love to, but I am simply too busy at work to get away for a few days before the end of the year. Maybe next year.
[…] I mentioned in my first post I’ve been working as a Made2Manage Administrator for more than 10 years. However, even if […]
I was looking for something on Consona Bulletin Board and found a link to your site. I’m very impressed, and thaking you for taking the time and creating all thiose blogs that I’m going to read.
Thank you,
Avi
Your blog is so great. I am from Mexico and your blog will give me a lot of help.
congrats!
Thank you so much sir, it’s a great help for the M2M users like us.
[…] Stein […]
I just read your blog for the first time and would like to thank you for taking time out to share your knowledge with us. I’ve been interested and fascinated by data warehousing and business intelligence, have spent a lot of money on trainings, but more often than not you don’t learn much to get you started at these trainings. I’ll be referring to posts a lot in the near future to get me grounded in this field. Thanks once again.
*** I’ll be referring to your posts a lot in the near future to get me grounded in this field. *** (correction).
Hi there,
We are considering to merge two company databases. One is our main database with 10 yrs of info, and the other is much, much, smaller. Cust master 85, INV 385, etc.
We would be okay with just bringing over current and static information at this time. Are you aware of any resources / contacts that may be instrumental in assisting us in this task?
http://www.made2mentor.com/2011/04/using-a-date-table-to-track-custom-fiscal-yearsperiods/
Hi
I am looking for the actual script for all of this article.
Please and thank you
Tania