Business Data Analytics Practice
Business Data Analytics has become an area of great interest to organizations. It has been recognized as a means by which organizations can obtain valuable insights from data, supporting more informed business decision-making. As a result, more organizations are investing in business data analytics to deliver on their strategic imperatives, innovate, and obtain competitive advantages in the marketplace, hence the increasing demand. This course aims to prepare the student for the Practice of Business Data Analytics with a complementary Hands-on implementation of Business Intelligence and Data Analytics solution using Power BI.
Hands-on + CBDA Certification
Course Outlines
1. Identify Research Questions
The purpose of Identify Research Questions is to define business data analytics activities such as defining the business problem or opportunity, assessing the current state, defining the future state, and framing the research question that business data analytics will be leveraged to answer.
a. Identify and frame the business situation
b. Plan analytics approach
2. Source Data
The purpose of Source Data is to define what data is needed to answer the research question; identify data sources; determine how and when to collect the data; assess the data’s quality, and make changes to the data acquisition approach as needed.
a. Plan data sourcing activities
b. Identify data sources
c. Determine how and when to obtain data
d. Perform data setup and preparation
3. Analyze Data
The purpose of Analyze Data is to decide how data analysis will be performed, including which models and mathematical techniques will be used. It involves preparing the data for analysis; performing the data analysis; determining whether the analytical solution/results help answer the business question, and adjusting the approach when it does not.
4. Interpret and Report Results
The purpose of Interpret and Report Results is to define how to use the results obtained from data analysis, to gather insights from the data collected, and determine how best to communicate and report the outcome from business data analytics to interested stakeholders.
5. Use Results to Influence Business Decision Making
The purpose of Use Results to Influence Business Decision Making is to define using business data analytics to influence and create informed decision-making.
6. Guide Company-level Strategy for Business Analytics
The purpose of Guide Company-level Strategy for Business Analytics is to define business analysis concepts and activities from recommending action to evaluation, to data management and curation through to performance improvement.
a. Recommend Action
b. Evaluation
c. Master Data Management
d. Perform Data Curation
e. Metadata Management
f. Performance Improvement
7. Hands-On: Fundamentals of Power BI
The purpose of Hands-on in Business Intelligence tools with focus on Power BI is to give students practical experience
- Identify and connect to a data source
- Get data from a relational database, such as Microsoft SQL Server
- Get data from a file, such as Microsoft Excel
- Get data from applications
- Get data from Azure Analysis Services
- Select a storage mode
- Fix performance issues
- Resolve data import errors
