Fundamentals of all parts of a business intelligence solution with Microsoft Tools
Author and Instructor: Dejan Sarka
Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database & business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of thirteen books about databases and SQL Server. Dejan Sarka also developed many courses and seminars for Microsoft, SolidQ and Pluralsight.
Learn in four intensive days how to get information and predictions from your data. Get understanding of the components of a business intelligence solution from an enterprise to a personal level, from simple to the most advanced types of analyses, and get familiar with the Microsoft tools.
The vast majority of contemporary companies have already pretty advanced transactional and other line of business systems. The amount of data they collect is constantly growing. Getting information from this data helps improving the business.
The amount of the tools Microsoft provides for business intelligence (BI) and enterprise information management (EIM) applications is really impressive. It is not simple even to enlist them all. SQL Server suite has tools for the enterprise and medium business level. Power BI brings the analytical capabilities down to the small business and personal level.
Attendees of this seminar get familiar with Bi concepts and tools. During labs, they build a simple, but complete BI solution. The solution is transferrable to their own systems.
The focus of the training is the explanation of the concepts of a BI solution and the introduction of Microsoft tools. The attendees should be able to select the appropriate tools for their needs and start their first real-life BI project after the course.
On completion of the seminar, attendees are able to:
- Understand the components of a BI solution
- Create a dimensional model for a data warehouse
- Use data warehousing components of the SQL Server Database Engine
- Develop an extract-transform-load procedure with SQL Server Integration Services
- Evaluate the data quality issues and define possible resolutions with Data Quality Services
- Keep the quality of their most important data with Master Data Services
- Author managed reports with SQL Server Reporting Services
- Use on-line analytical processing solutions with SQL Server Analysis Services Multidimensional
- Define simple cubes with SQL Server Analysis Services Tabular
- Use Power Pivot to develop personal analytical database
- Find and load external data with Power Query
- Create ad-hoc reports from a Power Pivot model with Power Query
- Develop geographic and temporal visualizations with Power Map
- Use SQL Server Analysis Services for on premise data mining
- Start programming in R for statistical analyses on premise and in cloud
- Find patterns and make predictions with Azure Machine Learning
Attendees should have basic understanding of data analysis and relational data models. They should have experience with at least some of the following tasks:
- Reporting from a line of business system
- On-line analytical processing
- Data warehousing
- Data quality
In order to focus on the content of the labs, they should have some experience with at least some of the following tools:
- SQL Server Management Studio
- SQL Server Data Tools or Business Intelligence Development Studio
- Microsoft Office Excel 2013 or later