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 continuation of your BIID learning journey to master the skills needed to become an efficient Business Analyst and Information Designer. This is an advance level course and it builds upon your knowledge that you gained in part 2 : Business Intelligence and Information Design : Intermediate : BIID201.

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.

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
• Business Intelligence and Information Design : Intermediate : BIID201

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

Advanced KNIME

• Database Operations
• Web Functionality
• Date And Time
• Flow Variables
• Loops
• Switches
• Advanced Reporting

Advanced Tableau

• Sets and Groups
• Table Calculations
• Timeseries Blending
• Animations
• Level of Detail

Advanced SQL

• Case statement

Subqueries

• Subqueries With In Embedded Inside Where
• Subqueries With Exists-Not Exists Embedded Inside Where
• Subqueries Nested In Select And From

Stored Routines

• Introduction to Stored Routines
• Creating Stored Routines
• Input, Output
• Variables
• User Defined Functions

SQL And Tableau Problems

Learning Outcome

• Perform database operations in KNIME
• Fetch data from web
• Manipulate and work with Data and Time
• Perform visual programming in KNIME
• Perform advance reporting functions
• Blend multiple time-series
• Create animated visualizations in Tableau

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.
• † 18% Indian taxes extra.