Learning Paths

---

 Pre-requisite: N/A (This path is suitable for beginners) | Time Required: 8 Weeks | 3 hours per week | 3 hours of Assignments

Video recordings of each class will be provided after each lesson

Begin your journey into Business Intelligence (BI) with this critical path developed for beginners, equipping you with the skills to analyze, visualize, and interpret business data. 

In two months, you'll dive into "Tableau" to harness the power of Tableau for dynamic data visualization, identifying key business trends and insights. You'll learn to import raw data, blend it, and create compelling visual narratives to influence decision-making.

Furthermore, "Data Visualization with Excel" will transform you into an Excel pro, enabling you to design insightful charts from bar to heat maps, essential for any data analyst.

Plus, "Power BI" will top off your practical knowledge, giving deep insights into data connection, analysis, and presentation with Power BI, ensuring you can deliver precise and actionable business insights. This path lays a strong foundation in BI, readying you to impact business strategies and operations with data-driven clarity.

1. TABLEAU : Hands on training 

 This course will allow you to use Tableau to identify trends in data such as sales trends, customer buying behavior and production bottlenecks, amongst others.
By the time you’ve completed this course you’ll be able to:

• Take raw data and import it into Tableau
• Analyze, blend and join data within Tableau
• Create revealing, interesting and even beautiful data visualizations
• Present your findings to key decision makers in a clear and effective way

No data analyst can afford to be without Tableau skills these days, as it is one of the most powerful ways to interpret and analyze all forms of business data.

2. Data Visualization with Excel

Microsoft Excel is a powerful analytical tool. Excel is a powerful resource that can be used to extract valuable business insights by visualizing raw datasets.
This course goes in-depth into the types of graphs and charts you can create, and you’ll soon be creating dynamic and exciting data visualizations such as:

• Bar and column charts, Histograms & Pareto charts 
• Line charts & trend lines, Area charts, Pies & Donuts
• Scatter plots & Bubble charts
• Box & Whisker charts
• Tree Maps & Sunbursts, Waterfall & Funnel charts
• Radar & Stock charts
• Heat maps, 3-D Surface & contour charts
• Choropleths & Geospatial maps
• Custom combo charts & graphs
• Sparklines, Plus, much, much more…

You’ll complete more than 6 workshops that will give you hands-on experience of working with real-life data and how to present it in ways that will maximize business performance.

3. Microsoft Power BI Hands on Training

Power BI is an important tool for data analysts as it is designed to provide data visualizations and insights for businesses. On this course you’ll master:

• How to connect datasets to Power BI
• Data calculations, trend analysis and forecasting
• Presenting data visualizations such as histograms and brick charts
• Data aggregation to provide incisive summaries
• Using granularity to ensure accuracy

By the end of the course you’ll be able to use Power BI to answer complex questions, visualize data clearly and provide decision-makers with exactly the level of information they need to make accurate decisions.

 Pre-requisite: N/A (This path is suitable for beginners) | Time Required: 8 Weeks | 3 hours per week | 3 hours of Assignments

Video recordings of each class will be provided after each lesson

Dive into the world of data analysis with this beginner-friendly path, designed to take you from novice to proficient Data Analyst in just two months. Starting with Tableau A-Z, you'll master the art of creating impactful visualizations and dashboards, learning to tell compelling stories with data. The journey continues with Data Science A-Z, where you'll delve into advanced data mining, master statistical models, and sharpen your communication skills for effective cross-departmental collaboration. Finally, SQL & Database Design A-Z will equip you with the essential skills to efficiently query and manage large datasets, ensuring you have a well-rounded foundation to tackle any data analysis challenge. This path prepares you to confidently drive decision-making processes and offer invaluable insights within any organization.

1. Tableau
Unlock the power of data storytelling with one of the most sought-after tools in the industry.

• Create impactful visualizations and dashboards.
• Learn advanced data preparation and explore the latest features of Tableau.
• Confidently use Tableau to turn complex data into compelling insights that drive decision-making.

2. Data Modeling & Statistical Analysis
This extensive course covers data preparation, modelling, analysis, visualization, and communication.

• Conduct advanced data mining with tools like Tableau.
• Master complex statistical models and logistic regressions.
• Handle data preparation, understand ETL, and utilize SQL for data science.
• Develop strong communication skills for cross-departmental work and presentations.
• Continue the path with a robust skill set that enables you to manage data science teams, oversee end-to-end data projects, and present insights to stakeholders effectively.

3. SQL using Postgre
Gain proficiency in SQL and database design, crucial for handling and querying large datasets.

• Design and normalize databases to ensure efficient data storage.
• Master SQL queries to extract, manipulate, and analyze data.
• Develop the ability to manage databases and perform complex data analysis with SQL.

 Pre-requisite: N/A  | Time Required: 12 Weeks | 3 hours per week | 3 hours of Assignments

Video recordings of each class will be provided after each lesson

Dive into a learner-first online experience of Data Analytics Boot Camp that combines a collaborative, hands-on training with real world data sets that gives you the tools to collect, analyze, and visualize big data - and to take your career to the next level.

The curriculum is delivered through high-quality coursework and live, online classes. Sessions are anchored by seasoned instructor with solid technical knowledge and industry experience plus a 1-on-1 support to learners during the program. 

Module 1. Excel & Statistical Analysis
Learn to do more with Microsoft Excel to conduct data and statistical analysis.

What you will learn includes:

• Pivot tables
• Data types
• Text analysis & Functions 
• Statistical modelling
• Forecasting & Trend analysis

Module 2: Tableau

Unlock the power of data analysis and visualization in one of the most in-demand business intelligence tool in the world.
What you will learn includes:

• Data cleansing
• Data visualization and dashboard creation
• Report Presentation
• Trend analysis and Forecasting

Module 3: Power BI

Gain mastery in one of the most well used data analysis and reporting tool to gain and present insight.

 What you will learn includes:

• Data analytics.
• Importing data.
• Manipulating data.
• Data modeling in the query editor.
• Table relationships and Data Analysis Expressions (DAX)
• Building data visualizations and reports

Module 4: Postgre SQL

 Learn how to organize data into well-structured data formats and gain proficiency in SQL and database design, crucial for handling and querying large datasets.
What you will learn includes:

• Design and normalize databases to ensure efficient data storage.
• Master SQL queries to extract, manipulate, and analyze data.
• Develop the ability to manage databases and perform complex data analysis with SQL.

Pre-requisite: NA | Time Required: 4 weeks | 4 hours per week | 3 hours of Assignments

Video recordings of each class will be provided after each lesson

Acquire solid understanding of Microsoft excel via an intensive hands-on LIVE online sessions.

What you will learn includes:

- Pivot Tables

- Power Query

- DAX

- Text Analysis

- Visualization in Excel

- Functions (VLOOKUPS, MATCH, INDEX, IF, NESTED IF etc.)

Pre-requisite: NA | Time Required: 4 weeks |3 hours per week | 2 hours of Assignments

Video recordings of each class will be provided after each lesson

Gain mastery of the principles and hands-on applications of Statistics using Microsoft Excel.

What you will learn includes:

• Descriptive Statistics
• Prescriptive Statistics
• Predictive Statistics