Contact Us
+1 647 862 8133
Request More Information
Business Intelligence Analysis
As data volumes are exploding, there is enormous amount of data and not enough professionals to manage it. More data has been created in the past two years than in the entire history of the human race. IT professionals who can work with data by Integration, Analysis and Visualization are high in demand.
This course aims to provide candidates with data analysis skills to support business goals. By the end of this course, students will be comfortable writing queries for perform business intelligence reporting, write requirements for decision support systems, as well as integration between operational systems and decision systems, as well as working with reporting tools.
What You Will Learn
This hands-on course teaches technical tools including:
- MS SQL Server 2016
- SSIS Integration tool
- SSAS Analysis tool
- SSRS Reporting tool
Upon completion of this course, you will learn to:
- Perform SQL queries that analysts implement in their day-to-day tasks
- Create databases and objects e.g. tables and views etc
- Sort and filter records
- Join database tables using Inner, Left, Right & Full Joins.
- Aggregate data by groups, and filter groups.
- Administer and back Databases
- Selectively delete data, tables or databases.
- Setup a framework to allow for pulling and reporting data in the required frequently (daily, weekly, monthly, quarterly, etc)
- Transform Data in a staging area
- Loading data onto a destination
- Create a cube
- Design and deploying Cube dimensions and measures
- Create reports and visualizations
Who is it for?
You are an ideal candidate for this course if you are
- A recent graduate looking for a job in data analytics
- Looking to switch career paths to Business Intelligence
- Have previously taken a Business Analysis course and are looking to gain more technical expertise.
- Passionate about organizing data sets to solve Business problems
- Technical, with some interest and / or exposure to programming
Schedule
The Business Intelligence Analysis course is 7 weeks long, Saturday 12PM to 5:PM
Next Class begins:On-Demand Access
Potential job opportunities after this Course
Data Analyst, Business Systems Analyst, Business Intelligence Consultant
Curriculum
Click here to Request Curriculum