This is a 4-day end-to-end training on business analytics for all professionals, including those with no prior analytics experience. You’ll learn how data analysts describe, predict, and inform business decisions in the specific areas of marketing, human resources, finance, and operations, and you’ll develop day-to-day basic data literacy and an analytic mindset that will help you make strategic decisions with the use of robust data. At the end of the course, you will be provided with data which will need your hands-on application of the skills learned to interpret a real-world data set and make appropriate strategic business recommendations.

Register now - https://docs.google.com/forms/d/e/1FAIpQLSc58jhC67PwxKsZHJ3xXgWBbeJ4pDnOn6EcdQF2XZYQrdIA1A/viewform

At this workshop, it’s assumed that you have little or no understanding of the following:

SQL
Business Intelligence (BI)
Database and Data-Warehousing (DB and DW)
Business Analytics (Prescriptive, Descriptive and Predictive)
Big Data (Sentiment Analysis)

To practically and effectively learn in this class, we require that you come along with a working laptop with minimum specification of 4GB RAM, 500GB HDD.

This training has 4 modules, interested participants in 3 or more modules get 20% discount.

Week 1 (July 7th) – NGN10,000

Development Environment Set-up

Installation and configuration of all related technologies
Structured Programming and SQL Development I

Introduction to Database
Introduction to Data-warehouse
Introduction to SQL
Database Objects
RDBMS Concepts
SQL Operators, Data types, Expressions , Syntax , Queries (create, insert, update, delete, truncate, drop, and & or clauses, select etc.)
Week 2 (July 14th) – NGN10,000

Structured Programming and SQL Development II

Usage of database functions like SUM(), COUNT(), MERGE, AVG(), ANALYTIC FUNCTIONS etc.
Construction of Functions
Construction of Procedures
Construction of Packages
Usage of other related database objects
Advance SQL

SQL Joins (Inner, Left Outer, Right Outer, Full Outer)
SQL Sub-Queries
Usage of temporary tables
SQL Wildcards
SQL Constraints
SQL Cursor
SQL Loop
Week 3 (July 21st) – NGN15,000

Concept of Business Intelligence
• Description of Business Intelligence concept for Business use
• Simple architecture of an EDW
• Data mart and its attributes
• ERD
• Introduction to Data Modeling
• Introduction to Facts and Dimensions

Data Visualization

• Introduction to Tools and Terminology
• Dashboard in Minutes
• Excel vs Power BI
• Setup and manage relationships
• Creating calculated columns
• Creating measures
• Map Visualizations
• Custom visuals
• Drill Down/Up
• Hierarchies
• Publishing and sharing visualizations
• Exporting data from a visualization
• Custom Q&A questions
• Transform data into actionable insights

Week 4 (July 28th) – NGN15,000

Business Analytics concept

• Introduction to Descriptive Analytics
• Introduction to Prescriptive Analytics
• Introduction to Predictive Analytics
• Market basket analysis
• Classification
• Regression
• Segmentation

Big Data Concept
• Introduction to Big Data
• Big Data Technologies
• Sentiment analysis

What to Expect

Gain understanding of business analytics with the use of robust data and the ability to take into account the relationships between this discipline and other areas of business to make holistic judgments when analyzing business situations.Apply quantitative modeling and data analysis techniques to the solution of real world business problems, communicate findings, and effectively present results using data visualization techniques.

Learn how to suppress who are customers least likely to respond to direct marketing campaigns.

Apply ethical practices in everyday business activities and make well-reasoned ethical business and data management decisions.

Select, Prepare, Construct, Integrate, Structure, and Format data to be most effective to ensure the models meet the business goals.

Develop actionable plans from existing data and initiatives to increase sales, reduce marketing costs and improve customer retention.

Determine whether a piece of writing is positive, negative or neutral.

Demonstrate knowledge of statistical data analysis techniques utilized in business decision making.

Manage data efficiently and allow users to perform multiple tasks with ease.