Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
With an All-Access Pass, you get access to every current and future ITU course. Access over 2,500 hours of on-demand IT Training 24/7. With over 13,000 on-demand training videos and 19,000+ practice questions, you'll have the tools to excel in the critical IT skills needed to elevate your IT Career. Our All-Access pass is available in three affordable plans.
Paris is the capital of France.
Tokyo is the capital of Japan.
Most Popular
Categories
With an All-Access Pass, you get access to every current and future ITU course. Access over 2,500 hours of on-demand IT Training 24/7. With over 13,000 on-demand training videos and 19,000+ practice questions, you'll have the tools to excel in the critical IT skills needed to elevate your IT Career. Our All-Access pass is available in three affordable plans.
ITU provides a vast array of IT-focused on-demand training designed to help you excel in both entry-level and advanced IT skills. Browse our most popular training or take a deper dive into our robust catalog of training categories.
Popular Courses All CategoriesCompTIA Train for a globally recognized IT certification with our comprehensive CompTIA courses. A+ | Network+ | Security+ Cybersecurity Master the art of combating cybersecurity threats and become a cyber hero. Ethical Hacking (CEH) | CISSP | CISM Cloud Computing An essential skill set in today's IT environments. Learn cloud computing platforms Azure Administrator | Google Cloud | AWS Practitioner Project Management Key to successful projects, learn the skills and methodolgy behind project management. PMP | Risk Mgmt | Agile PM Adobe Business & Management Cisco Cloud Computing CompTIA Computer Support Cybersecurity Data Administration Data Analysis Development & Programming Marketing & Social Media Medical Coding & Billing Microsoft Microsoft Office Network Administration Networking & Software Project Management Web Development
In this online training course you will learn how to plan and design a business intelligence (BI) infrastructure by designing a reporting solution, designing BI data models and designing an ETL solution. This course will teach business intelligence (BI) architects the overall design of a BI infrastructure and how it relates to other data systems in use.
Included In This Course
Closed Captions
Certificate of Completion
Course Description
Note: Although the associated examination for this course has been retired, it is a good resource for training.
The Microsoft 70-467 course, focusing on Designing Business Intelligence Solutions with SQL Server 2012, offers a comprehensive learning experience for BI architects and aspiring professionals. This course meticulously covers the essentials of BI infrastructure planning, reporting solution design, and the development of BI data models. You’ll gain hands-on expertise in leveraging SQL Server 2012 BI tools, ensuring you are well-equipped to create robust BI solutions.
By enrolling in this course, students will understand the intricate processes of ETL solution design and business intelligence data model creation using Microsoft SQL Server 2012. The curriculum is designed to enhance your skills in BI infrastructure and reporting, making you a valuable asset in the field of business intelligence. The course’s practical approach ensures that you gain real-world skills, applicable in various business contexts.
Our Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server is one of the many SQL courses available at ITU Online. This 70-761 Introduction SQL course prepares students to use the Microsoft SQL Server BI tools and is focused on the Microsoft 70-467 exam.
Students taking this online course will learn Microsoft SQL Server can be used to build robust business intelligence solutions using the tools already available in Microsoft SQL Server 2012. Topics like Introduction to Business Intelligence, Power Pivot, Extract, Load and Transform (ETL) methods, Microsoft SSIS, creating drill-down reports, building business intelligence fact tables and more are included.
The exam covers the following key focused areas.
This course is ideal for professionals aiming to deepen their expertise in Microsoft SQL Server BI tools, particularly those in roles such as BI architects, data analysts, and IT professionals involved in business intelligence projects. Whether you’re looking to advance in your career or acquire new skills in the BI domain, this course offers the knowledge and practical experience needed to succeed.
For the most recent information regarding this exam, we encourage you to visit the Microsoft website.
To see more Microsoft related training, Visit the Microsoft Website.
So, this course is all about helping you understand how to plan and design a business intelligence (BI) infrastructure using Microsoft SQL Server 2012. It’s going to cover a lot of ground – things like designing a reporting solution, creating BI data models, and designing an ETL solution. Just remember, even though the exam associated with this course has been retired, it’s still a really solid resource for training.
The course packs a punch in 19 training hours. It’s made up of 47 videos covering 8 different topics. Plus, you get to test your knowledge with 43 practice questions.
Absolutely! With the All Access Monthly Subscription, you can dive into this course and over 2,500 hours of on-demand content whenever you like. You also get a 7-day free trial to see if it suits you. And don’t worry, there’s no obligation – you can cancel anytime.
This course is part of a bigger library that includes training for different levels and fields, like CompTIA, Cybersecurity, Project Management, Cisco, Microsoft, Adobe, Microsoft SQL, Azure, Amazon Web Services, and Cloud Services. So, whether you’re starting out or looking to deepen your knowledge, there’s a range of courses to choose from.
You bet! All instructors have a minimum of 10 years of experience in their respective fields and are recognized as experts. So you’ll be learning from the best in the biz.
Absolutely! The platform is designed to offer flexible learning options. You can learn anywhere at any time on your desktop, tablet, or mobile. All you need is an internet connection and you’re good to go.
Course Outline
Rafiq has extensive experience including more than 20 years in IT as a Systems Architect, Software Engineer, DBA, and Project Manager. He has instructed in a variety of technical areas and has designed and implemented network and information systems. Bringing nearly 30 years of advanced IT experience to each course and adding his unique perspective and “real world” tips, Rafiq has a knack for making complex topics easy to understand.
$49.00
Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.
Monthly All-Access Subscription
7 Days Free - $39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription
$229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library
$379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
$49.00
This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server database. It is specifically tailored towards individuals who want to gain knowledge features in numerous versions of SQL server as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases!
$49.00
In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.
$49.00
In this course you will learn logical table design, indexing and query plans. This course focuses on the creation of database objects including views, stored procedures, parameters and functions. Common aspects of procedure coding such as indexes, concurrency, error handling, and triggers are also covered in this course. This course will also teach you how to optimize indexes, ensure data integrity, implement views, stored procedures and functions as well as manage transactions and locks.
Unlock endless learning opportunities with over 2,500 hours of IT training at our lowest price ever. Plus, get all new and updated online courses for free while your subscription remains active.
Cancel at your convenience. This exceptional deal on IT training provides you access to high-quality IT education at the lowest monthly subscription rate in the market. Boost your IT skills and join our journey towards a smarter tomorrow.
Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.