Our Business Intelligence & Data Analytics program is a 3 in 1 package that includes Advanced Excel, Power BI and SQL trainings.

 In this course, you’ll learn the capabilities of Microsoft Excel like you have never seen before. Functionalities such as dynamic filtering, VlookUp/Xlookup, pivot tables, Power Pivot, Power Query, and more will be covered. We will also cover data modelling and create powerful dynamic dashboards within Power BI in great detail before advancing to SQL, where We’ll cover all the basic SQL commands and learn how to combine and stack data from different tables. We’ll also learn how to expand the power of our queries using operators and handle additional complexity using subqueries.

 The course is sandwiched with a lot of in-class practice and homework and will be capped off with a comprehensive project that will require students to apply all 3 modules taught in creating a dynamic dashboard to answer stakeholder questions and drive business insights backed by facts and data.

 Our Business Intelligence & Data Analytics course introduces the practical uses of statistical and computer applications in determining and analyzing data. What you learn in this course will give you a strong foundation in all the areas that support analytics and will help you better position yourself for success within your organization. You’ll develop skills and a perspective that will make you more productive and allow you to become a valuable asset to your organization.

 This course also provides a basis for going deeper into advanced investigative and computational methods, which you will have the opportunity to explore in future courses of the Data Analytics for Business specialization.

 On completion of the training, you will be awarded with a certificate of completion in “Business Intelligence & Data Analytics”. You will also have validated work experience in Data analysis with work samples and relevant credentials to back it up based on the project you’ll undertake during the training. This allows you to self-declare that you are a Data/Business Intelligence Analyst even if your employer haven’t officially given you the title and you will have the credentials to add to your LinkedIn profile.

Course Benefits

  Ι  Solid hands-on training on Business Intelligence & Data Analytics

  Ι  Work on live projects

  Ι  Resume assistance and critiquing

  Ι  Interview prep sessions

  Ι  Earn professional training from IT experts who have years of experience in the industry.

Who is This Course Suitable For?

  Ι   Anyone working, or intending to work, in an organizational role which requires projects to be successfully carried out.

  Ι   The course is equally suitable for recent graduates or professionals who wants to build a career in Business Analysis, Data Analysis or Business Intelligence Analysis

  Ι A recent graduate looking to switch career path to Data Analysis or Business Intelligence Analysis

  Ι   Anyone working or intending to work in an organisational role which involves writing SQL queries.

Pre-Requisite:

At least a High School Diploma or a University Degree in any profession or relevant work experience and Beginners level proficiency in MS Excel at the minimum

Material Includes

  Ι    SQL Course Handout

  Ι    Installation of PostgreSQL on laptop

   Ι    Installation of Microsoft SQL on laptop

   Ι    Installation of Power BI on laptop

   Ι    Installation of ODBC connector on laptop (needed to connect PowerBI to SQL)

   Ι    Lifetime Access to our PostgreSQL database hosted on the cloud (Amazon RDS)

   Ι    Access to all class recording after each class.

   Ι    Midweek office Hours dedicated to assist with any questions/support.

Course Duration:

7 weeks (for the first 4 weeks, classes will be held Monday and Friday from 6:30 PM EST to 9 PM EST and for the remaining 3 weeks, classes will be held Fridays only from 6:30 PM to 9:30 PM)