ICT 707 - Data Analysis and Presentation
Course Description
In this course, students will learn to create useful analysis for the business within a functional reporting framework. Also, students will learn to gather the right requirements and ask the right business questions to create dashboards and reports for presenting the results of business analysis using the MAD framework.
Course Details
Business Intelligence is often misunderstood because it resides in-between the business and the technology departments of an organization. Both its challenges and its potential are borne from the dependence on collaboration to achieve the desired outcome. However, this collaboration requires that both groups understand the needs and capabilities that Business Intelligence solutions can provide.
The concepts in this course will be taught through a class-long mini-project where you will engage in the hands-on development of dashboards, scorecards and reports primarily using tools from the Microsoft suite.
Course Level Learning Outcomes
By completion of this course, successful students will be able to:
- Model a MAD framework presentation
- Use industry best practices to develop visual dashboard layouts
- Develop monitor level dashboards and detail level reporting
- Develop analysis level dashboards using Power BI Desktop
Topics of Instruction
- Identify business problems to solve through reporting and analysis
- Translate requirements into information presentation designs
- Develop a MAD framework for the information delivery solution
- Use semantic layers to drive report development
- Develop interactive operational reports
- Enable drill, slice and filter capabilities within the reporting solution
- Design user experiences that enable effective information consumption
- Develop executive dashboards and scorecards
- Explore advanced data visualization tools and techniques
Notes
For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...
Applies Towards the Following Program(s)
- Certificate in Business Intelligence and Analytics : Core Courses
Noha Salem BS is a career-long practitioner of business intelligence, reporting, and analytics. She worked with a variety of industries healthcare, energy, telecommunications, pharmaceuticals, automotive and retail. She has worked in various analytical projects for different clients within Calgary, such as Enbridge, CNRL, SMS Equipment, Blackline safety, and Shaw. Her specialty is the ability to understand the business, gather requirements, engage stakeholders, data preparation, modelling, evaluation, and provides insights that help in better decision making. Noha worked previously as BI consultant for Groundswell. Where she worked in different roles as Release manager, BI analyst, BI developer, Data warehousing developer. Currently working as an Analyst for Field Logistics at Suncor. Her expertise includes Power BI, Tableau, Qlik Sense, SAP Business Objects, SAP Lumira, SSRS, SSMS, SSIS, ADF, Statistica, and Knime. Noha has a Certificate in Business Intelligence from SAIT and a Certificate in Predictive Analytics from the University of California Irvine. Her current interests are in Data science and Machine learning. She is part of leadership and support of the Calgary Business Intelligence user group – LET IT BI.