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.

Apply now for early bird offer >> /2kjvWmq

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 10% discount. See details below:

Week 1 (Nov 4th) - 10k
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 (Nov 11th) - 10k
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 (Nov 18th) - 15k
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 (Nov 25th) - 15k
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

Apply for early bird offer >>http://theleadspace.co/index.php/services/training/