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 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