4-course program: $3,600
The SQL Business Intelligence certificate program includes coverage of RDB fundamentals, SQL programming, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), and Power BI. It includes comprehensive coverage of SQL syntax including complex queries, as well as creating and using stored procedures, functions, views and triggers. You will learn how to deploy and manage SSRS, create and customize reports including Table, Matrix, Parameterized and Linked reports. You’ll be introduced to the design and use of data warehouses and the use of SSIS to import/export data. A thorough introduction to SSAS includes creation of data cubes to support business analytics, and syntax for extracting information including the use of MDX to develop Multidimensional models. Students will also learn to use Microsoft's Power BI suite of products to import, analyze, and visualize business data, and to share business intelligence.
Upon completion of the program, students will have developed an appropriate knowledge base for a variety of positions related to database programming, data reporting, and data analysis. Students will have gained an appropriate skillset to pursue an entry level database reporting or business intelligence position at companies which use Microsoft SQL Server.
On-Demand learning gives you the flexibility to plan study time around the rest of your day. Our programs combine video, hands-on lab exercises and one-on-one facilitation to enable you to learn as your schedule allows. Labs are performed via remote access to a dedicated lab machine (unless a student requests to utilize their own equipment). Our unique commitment to student success includes a personal instructor to assure that your courses are completed on time and with full understanding of both the lecture content and the lab exercises. For a short video with more information about our on-demand training, please click here.
At Bright Star, we are happy to find out your personal career goals, and to discuss your personal situation to determine which IT and programming certificate programs are a good fit for you. Course Advisors are available at 978.256.9077 to answer any questions you may have, or you may request information here.
|Microsoft Transact-SQL Programming||35 hours|
|SQL Server 2017 Reporting Services||21 hours|
|SQL Server 2017 Business Intelligence: Integration Services and Analysis Services||35 hours|
|Analyzing and Presenting Data with Power BI||21 hours|
The Power BI course has an optional extension that is available at no extra cost.
|Optional Extension of Required Course||Duration|
|Analyzing Data Using DAX and M Power Query||14 hours|
Feel free to call us to discuss your desired curriculum – one of our advisors will be happy to discuss your training objectives and confirm that your goals and selected courses align. Your advisor will assist you in customizing the appropriate track to your personal situation.
After enrollment and speaking to your advisor, payment can be made anytime prior to your chosen start date for your first course. For multi-course certificate programs, you may pay for each course as you start it (pay as you go). Financing is also available.