BI Fundamentals
Training level | BI Course |
Duration | 4 days / 32 Hours |
Delivery method | In Class |
Level | 300 |
Language | Bulgarian/English |
List price | 1050 Euro VAT Excl. |
Course Summary
Training level | BI Course |
Duration | 4 days / 32 Hours |
Delivery method | In Class |
Level | 200 |
Language | Bulgarian/English |
List price | 1050 Euro VAT Excl. |
Click Tabs for Detailed info
SQL Master Academy works in close partnership with SolidQ in the field of Business Intelligence trainings, due to which fact we also have in our portfolio a unique programme of professional trainings in the field of Data Quality, Multidimensional Design, SSAS, ETL and SSIS. The courses train BI developers and designers of BI solutions, including back end EIM, as well as front end and reporting.
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
- 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
Module 1. Introduction to BI
Module 2. Dimensional data warehouse (DW) modeling
Module 3. SQL Server data warehousing
Module 4. Extract-transform-load (ETL) with SQL Server Integration Services (SSIS)
Module 5. Enhancing data quality with Data Quality Services (DQS)
Module 6. Managing master data with Master Data Services (MDS)
Module 7. Reporting with SQL Server Reporting Services (SSRS)
Module 8. On-line analytical processing (OLAP) with SQL Server Analysis Services (SSAS) Multidimensional
Module 9. Personal OLAP with Power Pivot
Module 10. Small and medium business (SMB) OLAP and SSAS Tabular
Module 11. Using Power Query to enhance the Power Pivot data model
Module 12. Ad-hoc reporting with Power View and Power Map
Module 13. Power BI new experience with Power BI Desktop and Power BI Services
Module 14. Data mining with SSAS Multidimensional and Azure ML
Module 15. Introduction to R
Module 16. Machine learning with Python
Upcoming Training
Trainer: Dejan Sarka

Reserve your seat
Reserving a seat does not imply any obligations for payment