{"@id":"https://credentialengineregistry.org/resources/ce-2f3dffaa-ab8c-42f7-83d0-23a127635090","@type":"ceterms:Certification","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-2f3dffaa-ab8c-42f7-83d0-23a127635090","ceterms:name":{"en-US":"SQL Server Business Intelligence Program"},"ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-49640492-9040-4478-a2c8-5c888f549fd5"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:description":{"en-US":"An 116week in-depth program designed to provide a comprehensive introduction to the Microsoft Business Intelligence platform using Microsoft SQL Server. The program focuses on teaching data professionals how to use SQL Server 2016 product features and tools to build business intelligence solutions. Topics covered in the program include SQL Server Data Tools (SSDT); SQL Server Management Studio (SSMS); SQL Server Integration Services (SSIS)-Data Extraction, Transformation and Loading (ETL); SQL Server Analysis Services (SSAS); Unified Dimensional Modeling-cube and dimensions development; Key Performance Indicators (KPI) and calculations; developing and utilizing different data mining algorithms; SQL Server Reporting Services (SSRS); report management; Power View and PowerPivot; Power BI; designing reports with the Report Builder tool; publishing and accessing reports with SSRS and Microsoft Office; new features of SQL Server 2016 for the business intelligence developer. Students will be provided with a copy of Microsoft SQL Server 2016 for installation on their personal computers. This computer must be running Windows 10 and the student should have administrator privileges."},"ceterms:targetLearningOpportunity":["https://credentialengineregistry.org/resources/ce-4dd52699-26c5-411f-9e34-c56752ae0173"]}],"ceterms:offeredBy":["https://credentialengineregistry.org/resources/ce-49640492-9040-4478-a2c8-5c888f549fd5"],"ceterms:inLanguage":["en-US"],"ceterms:description":{"en-US":"An 116week in-depth program designed to provide a comprehensive introduction to the Microsoft Business Intelligence platform using Microsoft SQL Server. The program focuses on teaching data professionals how to use SQL Server 2016 product features and tools to build business intelligence solutions. Topics covered in the program include SQL Server Data Tools (SSDT); SQL Server Management Studio (SSMS); SQL Server Integration Services (SSIS)-Data Extraction, Transformation and Loading (ETL); SQL Server Analysis Services (SSAS); Unified Dimensional Modeling-cube and dimensions development; Key Performance Indicators (KPI) and calculations; developing and utilizing different data mining algorithms; SQL Server Reporting Services (SSRS); report management; Power View and PowerPivot; Power BI; designing reports with the Report Builder tool; publishing and accessing reports with SSRS and Microsoft Office; new features of SQL Server 2016 for the business intelligence developer. Students will be provided with a copy of Microsoft SQL Server 2016 for installation on their personal computers. This computer must be running Windows 10 and the student should have administrator privileges."},"ceterms:subjectWebpage":"https://www.cdm.depaul.edu/ipd/Programs/Pages/SQLServerBusinessIntelligence-Details.aspx","ceterms:credentialStatusType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CredentialStatus","ceterms:targetNode":"credentialStat:Active","ceterms:frameworkName":{"en-US":"Credential Status"},"ceterms:targetNodeName":{"en-US":"Active"},"ceterms:targetNodeDescription":{"en-US":"Awards of the credential are ongoing."}},"ceterms:instructionalProgramType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://nces.ed.gov/ipeds/cipcode/Default.aspx?y=56","ceterms:targetNode":"https://nces.ed.gov/ipeds/cipcode/cipdetail.aspx?y=56\u0026cip=11.9999","ceterms:codedNotation":"11.9999","ceterms:frameworkName":{"en-US":"Classification of Instructional Programs"},"ceterms:targetNodeName":{"en-US":"Computer and Information Sciences and Support Services, Other."},"ceterms:targetNodeDescription":{"en-US":"Any instructional program in computer and information sciences and support services not listed above."}}]}