About the Course

There are four functional roles in Data Science, namely, Business Analyst, Data Analyst, Machine Learning Engineer and Data Engineer. The BIID track targets the Business Analyst role. This course is the start of your learning journey to master the skills needed to become an efficient Business Analyst and Information Designer.

The role of a Business Analyst is to process and analyze business data and present it using concise and effective data visualizations to decision-makers so they can make meaningful business decisions.

Arguably, the most famous example of an effective data visualization that moved the management into action comes from Florence Nightingale in 1858.

Designing effective data visualizations is an art form. They can capture the viewer’s emotions and attention and direct them to hidden patterns which are difficult or impossible to visualize just by looking at raw data. You don’t need to be an artist to create these amazing Data Visualizations. All you need is some creativity and skill imparted by this course!

Prerequisites

• Curiosity
• Basic arithmetic skills - Brackets, division, multiplication, addition, subtraction
• Ability to operate a computer, keyboard and mouse
• Ability to use a web browser to access and use the internet
• Ability to install software on your computer

Hardware and Software Requirements

• Windows 10 or greater, MacOS 10 or greater, Or Linux host with Windows inside virtualization, operational computer
• 16 GB RAM
• Broadband internet connection > 5 MBPS
• 100 GB free hard disk space. SSD Drive Recommended

Learning Objective

• Introduction To BIID

Knime Analytics

• Introduction To Knime Analytics Platform
• Data Blending
• Data Manipulation And Aggregation
• Data Mining

Tableau

• Data Analysis Fundamentals
• Data Processing
• Data Visualization
• Business Intelligence
• Dashbording
• Sharing Your Work

SQL (MySQL)

• Why SQL and MySQL
• What Is A Relational Database
• Relational Database Fundamentals
• Database Vs Spreadsheets
• Important Database Terminologies
• The Concept Of Relational Schemas: Primary Key, Foreign Key, Unique Key And Null Values, Relationships Between Tables
• MySQL Workbench Interface
• Loading The Data
• Select From, Where, And, Or
• Order Precedence
• In, Like
• Between And
• Is Not Null Is Null
• Comparison Operators
• Select Distinct
• Aggregate Functions
• Order By
• Group By
• Aliases
• Having
• Limit
• Sum
• Max Min
• Average
• Round

Learning Outcome

• Ascertain which type of visualization will be best for a given dataset
• Use visual analytics tools to create statistical and machine learning models to explain the data
• Generate captivating Data Visualizations (DataViz) to communicate a story
• Learn the fundamentals of SQL Language to retrieve data from transactional databases or Data Warehouse in a form that you need to create your visualization

Fineprint

• The topics presented are tentative and we reserve the right to add or remove a topic to update or improve the bootcamp, or for a technical or time reasons.
• † taxes extra.