Open Academy / Data Science

Data Analysis & Business Intelligence Course

2,499 AED
1,999 AED Early Bird Price

Learn practical Data Analysis to Solve Business Problems

26 Apr 21 - 10 May 21 5 days left!
Online Live   

30-day money-back guarantee

Learn how to use data analysis to solve business problems

Leverage the Power of Data Analysis Without Needing to Learn to Code

Data Analysis and Business Intelligence are terms that we've all heard before, but what do they mean practically in a business setting?

In this one-of-a-kind course, we'll be going over ways that you can apply data analysis in a practical way to solve business problems.

We'll be covering:
- How to form questions that can be solved with data
- How to use cloud storage solutions for collecting data
- How to use connectors (3rd party API's) to gather data
- How to create a simple data warehouse with multiple data sources
- How to visualize data that answers business questions

We'll also be building 7 projects together, which will include:
- A Customer Data Report Dashboard
- A Business Plan P&L Dashboard
- A Social Media Marketing Dashboard
- A Performance Marketing Dashboard
- A Customer Lifetime Value Dashboard
- A Marketing Cost Performance Dashboard
- A Business Sales Dashboard

In order to teach you Data Analysis in a practical way from scratch, AstroLabs Academy has built an intensive 3 week part-time cohort-based Data Analysis & Business Intelligence Course, built by and for professional practitioners.

This data analysis and business intelligence course is designed for the working professional and student. All sessions and material will be delivered after hours, on weekends and remotely to work around your schedule!

By signing up to this practical program, you'll receive:
- Lifetime access to 30+ self-paced lessons on core Data Analysis topics
- 7 Projects to practically implement what you learn
- Twice a week check-ins and office hours to help you complete your projects
- Access to the AstroLabs online community hub
- Recruiter support from AstroLabs Talent to find your next role

This course will begin on the listed start date and will have a schedule to follow for the 3 weeks of the program. We'll be running this course once a month, so if you ever fall behind, you can catch up in the next cohort.

By the end of the program, you will have strong practical experience using Data Analysis & Business Intelligence to answer complex data related questions for your business and career.

Open To All Skill Levels

We assume no prior knowledge. This program is beginner friendly. As long as you want to Data Analysis, we can teach you Data Analysis!

Practical Data Analysis & Business Intelligence

No more fluff and buzzwords, this course is all practical. This is the best crash program to take you from a beginner to a proficient Data Analyst.

AstroLabs Certification

You'll get an official AstroLabs KHDA diploma, upon completion of this training.

Self Paced Cohort based

Sessions are delivered fully remotely online (through self paced lessons, office hours and projects). Participants will gain lifetime access to the AstroLabs online learning portal for regular content shared to help you on your coding learning journey.

Hands-on Practical Data Analysis

All projects chosen in this program are very practical in nature and can provide data insight for marketing, sales and management teams.

Career Opportunities

We'll connect you to our large network of job opportunities as well as recruiters in our network at AstroLabs Talent to help you advance in your career.

Tools

Platforms Covered

Content: Inside the Course

What you will learn

Module 1

Excel Basics to advanced

Module 1

Excel Basics to advanced

Learn the basics of using Excel 

 

 

Basics of Excel, columns and rows, how data is laid out
Data types (numbers, dates, text)
Basic functions (sum, avg etc.)
Concatenate
Removing Duplicates
Vlookup
Excel shortcuts
Pivot Tables (dimensions versus values) & Pivot Charts
Project 1: Customer Data Report Dashboard
Create a report that combines customer data across 2 tables (sales and customer data) into a unified dashboard - Remove duplicates - Combine data from two sheets using VLOOKUP - Create 2 charts for Revenue by customer city and most active customers

Module 2

Google Sheets

Module 2

Google Sheets

Learn how to use Google sheets

Basics of Google sheets, columns and rows, how data is laid out
Learn Differences between Google sheets and Excel (functions edge cases)
Pivot tables and charts in Google sheets
Conditional formatting
Project 2: Business Plan P&L Dashboard
Create a dashboard that allows you to project the profit and losses of your business - Build in fixed costs and variable costs - Make it clear which numbers are variable assumptions (that can be changed by the user) - Display total revenue, profit and costs in a dashboard and split by category of costs and revenue

Module 3

Databases and Data Storage

Module 3

Databases and Data Storage

Learn how data is stored

Basics of how data is stored in databases (Offline and Cloud databases)
Database structures SQL versus NOSQL
Smart table solutions
Airtable, Smart sheet, and Google sheets as a database
Storing internal data in spreadsheets and databases
How to map data through metrics and dimensions (common keys)
Creating combined tables and relationships
Common keys and parent tables

Module 4

Cloud Data warehouses / collectors

Module 4

Cloud Data warehouses / collectors

How data is stored in warehouses and collectors

What is a data warehouse and why do you need one?
Data collectors (Tableau, Power BI Cloud, Google Data Studio)
Industry specific cloud data (Segment, Hubspot, Mixpanel, Datadog)
Big data warehouses (Big Query, Azure Synapse , Amazon Redshift)
Building your own simple data warehouse
Using Google Data Studio as your cloud warehouse
Social Media Dashboard
Create a dashboard that displays social media peformance (followers, and post engagement) - Combining multiple tables -Displaying data in easy to read charts

Module 5

Getting data (internally and externally)

Module 5

Getting data (internally and externally)

How to import data locally and from the cloud

Importing existing internal data
External data with API's
How API's work
Why you need to work with API's in your business"
Zapier and Integromat
Macros in Google sheets
Add ons for Google sheets
Marketing data: FB, Google, LinkedIn
CRM data: Hubspot, Sales Force
Customer data: Backend systems, orders, revenue Email data: Mailchimp, Convertkit, Sendgrid
Performance marketing dashboard
Create a dashboard to track the performance of your marketing campaigns -Split by product line, channel and conversions - Display campaign, ad set and ads drilldown - Make the report update automatically via API + Macros

Module 6

Data Combining & Merging

Module 6

Data Combining & Merging

Learn to combine and merge data

Importing data into our cloud warehouse
Structuring our data into tables (sheets) and relating them together
Cleaning / sanitizing
Dealing with duplicates,irregularities and edge cases
Filters and Data Views
Calculated metrics and Measures (column functions)
CLV Dashboard
Create a dashboard to track your customer lifetime value - Combine customer, marketing and sales data - Use filters and calculated metrics for your formulas end data - Make the report update automatically via API + Macros

Module 7

Data Analysis, Visualization and Insights

Module 7

Data Analysis, Visualization and Insights

Answering questions with data
What do you want to know?
The data analysis framework: Question, gather, hypothesis, report
Tips on how to provide insights
Marketing performance
Create a dashboard to track the performance of your marketing campaigns with cost data -Split by product line, channel and conversions and cost - Display campaign, ad set and ads drilldown on a cost and revenue level - Make the report update automatically via API + Macros

Module 8

Visualizing data: Tables, Charts and Projections

Module 8

Visualizing data: Tables, Charts and Projections

“Create a sales dashboard to show sales pipeline data
– Integrate CRM data with marketing data
– Show pipeline performance across various products
– Display total revenue, profit and costs in a dashboard and split by category of costs and revenue
– Show sales pipeline lead data (MQL, SQL and Sales)
– Show sales team performance
– Have your data automatically refresh via API’s and macros”

Tables, charts and visuzalizations
Sorting and filtering tables and charts
Adding controllable elements to your reports (front end filters)
How to choose what to show (say it with charts)
Sales Dashboard
Create a sales dashboard to show sales pipeline data - Integrate CRM data with marketing data - Show pipeline performance across various products - Display total revenue, profit and costs in a dashboard and split by category of costs and revenue - Show sales pipeline lead data (MQL, SQL and Sales) - Show sales team performance - Have your data automatically refresh via API's and macros
CAREER STARTERS, SWITCHERS & Learners

Who is it for?

Career starters

Are you someone who is starting out your career and understands how many different career options open up if you have practical data analysis skills? Finance, marketing, design, data analytics, science and way more. Rocket-launch your early career by learning essential and transferable data analysis skills.

Career switchers

Are you someone that has come to the party a bit late in realizing the power of using data analysis in your career? Firstly it is never too late to change your career and secondly you’re not alone. Take ownership of the next phase of your career jungle gym and learn to leverage data.

Career learners

Are you a non-tech person who wants to “lift the hood” on actually understanding how data anaylsis works? Demystify the jargon and manage development work better by learning in-depth how data analysis works in practice

What is included?

Cohort based course, that mixes self paced lessons, projects and live office hours to make sure you don't get stuck

Office hours with instructors and mentors to progress your projects

Over 25 hours of instruction, mentorship and projects

Online community forum to troubleshoot, learn and chat with your classmates

Practical projects you can add to your portfolio that solve real world business problems

A vibrant alumni community with the largest number of digital enthusiasts in the region

instructors

Meet Your Practitioner Instructors

Expert practitioners that teach practical knowledge you can immediately implement.

7089

Ahmad Abugosh

Director of Marketing & Learning Programs at AstroLabs

Learn more

7969

Danial Entezari

Technology Director at Huephase

Learn more

Schedules

Upcoming Courses

April 26 - May 10

Online Live

April 26 - May 10
Online Live

Monday : 4:00-6:00pm
Wednesday: 8:00-10:00pm

If you can’t make a time listed, we may be able to schedule a time

Date
Timing
Orientation - Monday, April 26th
4:00pm-6:00pm
Optional Office Hours - Wednesday, April 28th
8:00pm-10:00pm
Optional Office Hours - Monday, May 3rd
4:00pm-6:00pm
Optional Office Hours - Wednesday, May 5th
8:00pm-10:00pm
Optional Office Hours - Monday, May 10th
4:00pm-6:00pm
Alumni

Our Graduates

Our graduates are from big companies, small companies, they are founders, career changers and lifelong learners. Join us and meet your tribe!

TESTIMONIALS

Alumni Reviews

The Astrolabs part-time Coding bootcamp is focused and current, teaching sought after skills around fullstack JavaScript. I never imagined that I’d be able to build a complete MERN stack application in 8 weeks, whilst still working full time. This bootcamp delivered beyond my expectations and cemented my desire to pursue web development.

Sajid Akhtar

Technology Director, Data Science Practice - Publicis Media MENA

For a beginner like me, the course was eye-opening and very interesting to learn. Instructors are helpful, knowledgeable, attentive to class needs and clear in explaining different types of codes and details. Very happy to be a part of this course and definitely need to keep learning.

Mustafa Aljuaidi

The environment was great. Instructors were super helpful and did everything in a timely manner, very flexible at all times. Everything I learned during this boot camp was very helpful to get me started on the process of learning web development and gave me just the right fundamentals and knowledge to move further and learn even more.

Aron Gabor

Abercrombie & Fitch Brand Representative

Troubleshooting our problems and walking us through them. Helping us every step of the way. Never leaving questions unanswered.

Mohamad Mahdi

CO Dulsco

The best thing was that I learned about coding and creating a website from scratch within 2 months. All the sessions conducted were informative and not only did I learn, I also applied what was taught in assignments and group projects.

Shreya Doshi

Vice President Public Relations

It feels good to be surrounded by like minded people who share the same passion, by mentors who guide you throughout the execution of your project, and other entrepreneurs who inspire and motivate you

Timothee Desurmont Van Leeuwen

Business Development Manager

John Bartlett

Coding Bootcamp Alumni

Lina El Husseini

Coding Bootcamp Alumni

Lajisha Latheef

Coding Bootcamp Alumni

Izzat Al Olwani Testimonial

Coding Bootcamp Alumni

Frequently asked questions

This program will be conducted fully online with a mix of self-paced lessons, office hours and practical projects

Yes, you will have lifetime access to videos as well as additional recorded material when signing up for our Data Analysis course. You will also receive any updates we may have in the future (to make sure your knowledge is always up to date)

Upon completion of this course, you will receive an AstroLabs Certification (certified by the Dubai Government KHDA authority). By the end of the course, you will also have your own data analysis portfolio, which helps immensely in your career.

Although we cannot guarantee employment, several of our graduates have gotten jobs immediately after graduation. By joining this bootcamp, you'll be joining an active alumni network with exclusive access to opportunities we come across in our network and job portal as well as recruitment and career support through AstroLabs Talent.

Yes, don't worry. As long as you have a passion for learning, beginners are welcome! Our Data Analysis course starts from the basics and assumes no prior knowledge.

One of the beauties of this program is that most of it is conducted via the browser (using Google Chrome), so as long as you have a laptop that was made in the last 5 years, you should be ok.

If you have any other questions, please reach out to us at [email protected]

Data Analysis & Business Intelligence Course

2,499 AED
1,999 AED Early Bird Price

Learn practical Data Analysis to Solve Business Problems

26 Apr 21 - 10 May 21
5 days left!
Online Live   

30-day money-back guarantee

Fill in your details below and we’ll get in touch with more info!



We may follow up with you via WhatsApp.

+97144541159