4-course program: $4,500
The Data Analyst / SQL Server Business Intelligence Certificate Program includes coverage of relational database fundamentals, SQL programming, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), and Power BI.
Our programs focus on student success with personal facilitation and comprehensive hands-on exercises to ensure successful training and subsequent competence in the IT workplace. Our support staff provides personal setup assistance, guidance and lab equipment setup for each student. An instructor is assigned to each student to assist in completing lab exercises and to help with any questions about the course content. Lab exercises are performed via direct high-speed access to a dedicated lab machine, providing responsive interaction and anywhere/anytime accessibility by the lab facilitator as well as the student.
The Data Analyst / SQL Server Business Intelligence Certificate Program provides a solid understanding of relational database design concepts, coding and utilizing SQL queries and database management tools. It includes comprehensive coverage of SQL syntax including complex queries, as well as creating and using stored procedures, functions, views and triggers. In the SQL Business Intelligence courses, you will learn how to deploy and manage Reporting Services, 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. The 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 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 SQL Business Intelligence 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 gain a robust skillset to pursue a career in data reporting, data analytics, and business intelligence as well as enhanced career opportunities as a data architect and business intelligence developer.
Our personally facilitated on-demand learning environment gives students the ability to work within their schedule and learn at their own pace to ensure a thorough understanding of database design, data presentation, and data analytics. The program includes streaming lectures, extensive hands-on lab exercises and one-on-one facilitation to assure successful completion. Bright Star's unique approach to student success includes a personal instructor to assure that courses are completed on time and with a solid understanding of the content. Each student has a dedicated workstation loaded with the software required for exercises. We do not use simulation software or “canned” labs. Learn more about our on-demand training here.
Take advantage of quality program content and personal service to assure your success. Our unique approach to teaching valuable I.T. skills cannot be compared to anything else in the market. Learn more by speaking with a curriculum advisor at 302.335.8868, or you may request information here.
There are a wide variety of career opportunities in the field of data analytics. Data analysts can be involved with data integration and curation, data storage and retrieval, business intelligence, operations analysis, data presentation, machine learning – almost anything to do with the large amounts of data involved in today’s business operations.
At Bright Star we are happy to help assess your personal career goals related to Data Analytics or any of our other certificate programs. Reach out to get in touch with a Course Advisor at 302.335.8868, or you may request information here.
Bright Star's Data Analyst / SQL Server Business Intelligence program includes optional advanced training for interested students at no additional charge. After completing the core curriculum students may elect to learn advanced data manipulation techniques using DAX and M Power Query.
Note: Students are required to have a personal interview (inperson, phone, or videoconference) with an admissions representative, before they start their first course.
| Required Courses | Duration | |
|---|---|---|
| Microsoft Transact-SQL Programming | 90 hours | |
| SQL Server 2019 Reporting Services | 60 hours | |
| SQL Server 2019 Business Intelligence: Integration Services and Analysis Services | 90 hours | |
| Analyzing and Presenting Data with Power BI | 90 hours | |
| Total Program Hours | 330 hours |
| Optional Course (No additional charge) | Duration | |
|---|---|---|
| Analyzing Data Using DAX and M Power Query | 40 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.