- Mcse business intelligence training kit for free#
- Mcse business intelligence training kit professional#
I studied up on the stuff that I had never seen or worked with before. In addition to MVA, I also used PluralSight and various other books. I also found the video for Tabular Model training. I went out to Microsoft Virtual Academy (MVA) and found the training video for 70-466. But I did much better than I thought I would, so I knew there was hope of earning my MCSE. I failed exam 70-466 the first time I took it, as I expected I would. At worst, I’ll fail the exam, but will gain valuable experience in how the exam is structured, what it covers and learn where I need to focus my studies. I figured, what do I have to lose? At best I’ll pass first time around.
Mcse business intelligence training kit for free#
For a limited time, it allowed a person a second chance to take a qualifying exam for free if you fail it the first time. Since there are no Training Kits for the last two exams, I decided to take Microsoft up on its Second Shot offer. There are two exams needed to earn your MCSE: Business Intelligence after your MCSA, they are 70-466 and 70-467. I’ve only been using Analysis Services on a regular basis for about 2 1/2 years now, so I am certainly no expert, so definitely needed some work there as well. I don’t use Reporting Services in SharePoint integrated mode nor do I do any work with the Tabular model for Analysis Services. I looked at the topics that were covered in the exams and realized there were going to be some huge gaps.
Mcse business intelligence training kit professional#
The question came down to MCSE: Database Professional or MSCE: Business Intelligence, since most of the work that I do now is BI related, I decided on the later. I was going to stop at the MCSA, but after I completed that with relative ease, I decided I needed a bit more of a challenge. That approach paid off and on February 20, 2015, I passed the exam and earned my MCSA for SQL Server 2012. I followed the same approach for 70-463 as I did for exam 70-462. On January 30, 2015, I passed exam 70-462.Įxam 70-463 is about implementing a data warehouse. I failed that first practice exam, but it provided me with a road map of what I actually needed to focus on. I had never used Always On and it has been years since I worked with replication so I figured the best place to start was by taking a practice exam to see where I needed to focus.
It is focused on Administering SQL Server. I passed exam 70-461 on December 24, 2014.Įxam 70-462 was a bit more involved for me. For the questions I got wrong, I went back and read the lesson, re-answered the questions correctly and that’s it. I read through the questions at the end of every lesson in each chapter and the case studies.
I’ve been querying SQL Server for almost 20 years, so it didn’t take much effort for me to pass this exam. The first exam, 70-461, is all about querying SQL Server. The MCSA certification consists of three exams, 40-461, 70-462 & 40-463. It seemed like the best candidate so I ordered it from Amazon and had it delivered in two short days (Thank you Amazon Prime!). It consists of three books, each dedicated to an exam and each book has its own practice exams. I did a little bit more research on the exams and what study guides were available and discovered the Microsoft Training Kit. I decided I needed to get my SQL learnin’ on.
There were so many pieces of the technology that I had never used or hadn’t used in years. I looked through the topics that the three exams covered and got really excited. I looked at the MCSA certification path again. I started doing some research on the question and decided, if I am going to do this research, why not get something other than just an answer, there had to be other things that I didn’t know. That got me thinking, if I don’t know the answer to that, what else don’t I know? I was asked a question that seemed simple, but I didn’t know the answer. I did a very introductory class on Integration Services. Last summer I was invited to speak for the Triad SQL BI User Group in Winston-Salem. What made me change my mind you ask? The short answer is, being a speaker.
Back in May of 2013, I wrote about being Certifiable and wasn’t really interested in pursuing any certifications. I earned my MCSE: Business Intelligence Certification on May 27, 2015.
0 kommentar(er)
