Course Description

Business intelligence (BI) is a branch of data analytics that supports the process of converting raw data into actionable business and operational insight for improved decision-making and enhanced organizational efficiencies. The field encompasses techniques such as query generation, data mining, data modeling and analysis, creation of dashboards and visualization charts, and production of analytics reports.

This course introduces participants to the field of Business Intelligence (BI), with emphasis on descriptive analytics. It employs applied training techniques with participants forming data analytics teams to solve business problems and identify solutions, practically applying learned concepts to real-world cases.

Key areas of BI covered include; data collection, data preprocessing, data storage, data queries, basic data mining, descriptive data analytics, data visualization, and results presentation. Program participants will also receive training in the use of products such as Excel, SQL, Microsoft Power BI, and Tableau to collect, extract, mine, analyze, visualize and present business data.
 

Learner Outcomes

Upon successful completion of the program, participants will be able to:

• Demonstrate an understanding of the fundamentals of BI, potential applications of BI and its role in the field of data analytics
• Practice data collection, data mining and data loading by using applicable advanced features of Excel
• Apply the basics of SQL, its applicable data commands, basics of database queries, data aggregation, sorting, grouping, and summarization
• Apply the fundamentals of data mining, applicable techniques, functionalities, algorithms, and major challenges in the practice of data mining and descriptive data analytics
• Practice presentation and visualization techniques and storytelling using Tableau
• Define data relevancy, pattern recognition, trend analysis and relationships among data elements and clusters
• Apply learning to real-world business projects
• Employ data analytics to gain insight about business operations, solve problems and create solutions for corporate and organizational issues
• Produce evidence-based, tactical and strategic decisions toward organizational viability and competitiveness