COURSE
EMPLOYEE PRODUCTIVITY
INTERVIEW QUESTIONS
FINANCE USECASE
DEPARTMENTAL
OPTIONS TRADEING
MORTGAGE USECASE
COURSE
EMPLOYEE PRODUCTIVITY
INTERVIEW QUESTIONS
FINANCE USECASE
Finance Detailed Report
DEPARTMENTAL
OPTIONS TRADING
MORTGAGE USECASE
Business Analysis
Describes the step by step process followed when testing
Describes the Test Scenarios that will be used to do regression testing
Here we have test scripts that describes the step by step stress testing of the database
BA interview
Gives explanation for both Agile and Waterfall
advanced Python Training
This powerpoint explains the project description for DAF application system
This ppt will entail the following : a. Trainings b. Project Description(Use Cases and Stories) c. Team and Stakeholders d. Tools and Access.
Reporting Deployment
Deployment of the reports into the server
All functionalities should be tested and whenever new functionalities are added, Testers should retest all previous parameters that had been added in previous sprints. We will demonstrate this using our internal CODA Website
Describes the test scripts for regression testing
Here we are validating the regression test scenario by testing all the functionalities
We will use reports to demonstrate unit testing. Here we will be testing each unit/parameter on the dashboard(Tableau Report) to make sure it works as expected.
Describes the step by step validation of the requirements
Understanding the requirement and deriving/ coming up with different scenarios to be tested.
Stress testing is performance testing, Testing the speed of retrieval of information.Here we will use sql to test our tables/store procedures/views on how well/fast they are retrieving information from the database.
Here we have test cases that describes the stress testing of the database
Here we have test Validations that describes the step by step stress testing of the database
Wireframes
Image of the company Logo
Image of an Arrow for the landing page
Image of a clock for the landing page
Image for the landing page
Image for the landing page
Image for the landing page
Shows the landing page wireframe
Shows the mockup for overview report
Shows the rating mockup
We will now learn how to embed analytics in our project. To that end, our first release we will start by creating the landing page, a home which will serve to consolidate all the reports and direct the end user to report of choice. Executive overview report will will give the top management high level overview of performance of employees to make enhance business decisions and finally the rating report, This report shows the performance of employees during one-on-one sessions. Employees are rated based on communication, punctuality and understanding.
Here are supplementary links and materials for further exercises.
A home page that contains buttons to help us navigate to Executive Report,Meeting Report and Rating Report Given different data sources, are you able to come up with the landing page report?
Here we will visualize meetings, DAF points and message points as well as ranking top preforming employees in the company
Dataset in excel format
Use the ppt to go through what we are going to learn as far as reporting is concerned
There are many tools that can be used to perform ETL; Alteryx, SSIS and Data stage. For this project we use Alteryx to clean data. Below is what is required to come up with data cleaning workflows. Install alteryx and create a workflow to clean the following raw data. You can make use of the video and the PowerPoint for guidance.
A powerpoint showing step by step cleaning of data
There are many tools that can be used to preform ETL; Alteryx, SSIS and DataStage. For this project we use Alteryx to clean data. Below is what is required to come up with data cleaning workflows
Learning by examining what was done by past students to get access to their presentations
Alteryx Installation
Introduction to Tableau
DEVELOPMENT
introduction
General
Link for project description powerpoint
Involves development, testing and deployment of Update, Create & Delete Views
Explain web development in CODA
Involves development, testing and deployment of a model/table
Describes how to impliment Django Signals, tooltips and integrating with OpenAi
For this project we use SQL to create and manage a database by doing data normalization, developing a data dictionary and data models for optimal management of the database.
A video demonstrating how to retrieve data
A video demonstrating Normalization and creation of tables
A video demonstrating Creation, Insertion & Update of tables
Dataset in excel for meetings, WhatsApp and DAF
A slide PowerPoint that explains how the normalization, data dictionary, tables, store procedures and data retrieval are created in the database
A video demonstrating how to create store procedure
Introduction Overview
Schedule will continue to get updated in the course of the training.
Laptop Specifications
You can print this letter for the purposes of change of schedule request at your job.
Prerequisites and what is required to be successful. We focus on the summary of the course, how to organize your information and also the specifications of the laptop.
Organization is so crucially in IT industry, we will learn how to bookmark important links,organize emails and desktop.
This is a powerpoint for organizing gmails and bookmark
A video showing how organization of bookmark and gmail is done
An overview of tools that will be used to deliver the project.In this project we will use Tableau for reporting,Alteryx for ETL and SQL for database.
A ppt that shows step by step process of installing SQL
Describe step by step process of installing alteryx
A video demonstrating how to install SQL
List tools that are used for training purposes
Describes a step by step process of installing tableau
Project
Creating wireframes/mockups that mimics the final product. A guide in development stage.
Daily Achievement form
A video explaining the employee productivity project
Gather, define and document requirements through a real time project.
Define what the project is about and incorporate agile methodology in project delivery.
Show more information of project
Describes requirements using Planning polker
Discuss on the requirements
Employee productivity refined requirement
Link leading to planning poker Website
Video showing how PBR is performed
Discuss on the requirements
Crown Data Analysis and Consultancy LLC (CODA) was established to provide our customers with high quality services in project management. Consultancy and Software solutions. Our goal is to provide these services with efficiency and effectiveness at a fair price both locally & internationally