Course description
Designing Self-Service Business Intelligence and Big Data Solutions (MS-20467)
About this course:
Providing Big Data analytics services to organizations is one of the leading roles that engineers can opt for. Our Data Science Training program is a complete package that not only helps individuals learn tricks to offer efficient Big Data analysis but also asses self-service Business Intelligence in a better way. You will learn efficient ways to utilize Windows Azure HD Insight which is an additional skill to help you attract business owners. This course is all about making the most of the various Microsoft programs including MS Office 365 Power BI, MS Excel, MS SQL Server, and much more. Deigning a self-service BI model will become easy with the help of this course.
This e-learning program is ideal for individuals who are eager to understand and implement MS SQL Server 2012 and SQL Server 2014. You will learn all about the various features of these servers and become capable of implementing it on your own.
After having this course in your resume, you will be able to earn up to $89,000 annually as a BI expert.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Who should attend?
Audience:
This course is intended for:
Business Intelligence and Database engineers who already have sufficient knowledge of SQL Server based enterprise Business Intelligence and data warehouses. Skilled Big Data analysts who are eager to understand Microsoft products and data solutions.
Prerequisites:
- Knowledge of data warehousing and data modeling principles.
- Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.
Suggested prerequisites courses:
- Microsoft SharePoint Server 2013 for the Site Owner/Power User (MS-55035)
- Microsoft Excel 2013 Introduction Level 1 (MS-Excel13-1)
Training content
Course Objective:
After completing this course, students will be able to:
- Describe key features and benefits of self-service BI.
- Use SQL Server Reporting Services to implement a self-service reporting solution.
- Use PowerPivot in Microsoft Excel to create analytical data models.
- Use Power Query in Microsoft Excel to import data into a data model.
- Use Power View in Microsoft Excel to create interactive data visualizations.
- Use Power Map in Microsoft Excel to create geographic data visualizations.
- Use Microsoft SharePoint Server to implement collaborative self-service BI solutions.
- Find and use public data in the Windows Azure Marketplace.
- Use Microsoft Office 365 Power BI to implement cloud-based self-service BI solutions.
- Provision and use a Windows Azure HDInsight cluster for Big Data analysis.
- Use Pig and Hive to analyze big data in Windows Azure HDInsight.
- Design and implement Big Data processes to support self-service BI.
Why choose QuickStart?
98% increased workplace productivity
94% instructor and course effectiveness
Partnered with vendors including Microsoft, Cisco, and Citrix
Contact this provider
Meet your career goals with QuickStart!
QuickStart exists to create world-class technologists by personalizing and individualizing training to address the massive skills gap in the IT industry. Through 20 years of research and data analysis, we’ve learned that a modern learner prefers to learn through multiple...