IBM - Data Analytics with Excel and R Professional Certificate

Varighet

Varighet:

Bare 7 dager

Metode

Metode:

klasserommet / på nett / Hybrid

Neste dato

Neste dato:

24/6/2024 (Mandag)

Overview

This accelerated IBM: IBM Data Analytics with Excel and R Professional Certification, will prepare you for a career in data analytics. The topics covered within this certification enable you to:

  • Master the most up-to-date practical skills and knowledge data analysts use in their daily roles
  • Learn how to perform data analysis, including data preparation, statistical analysis, and predictive modeling using R, R Studio, and Jupyter
  • Utilize Excel spreadsheets to perform a variety of data analysis tasks like data wrangling, using pivot tables, data mining, & creating charts
  • Communicate your data findings using various data visualization techniques including, charts, plots & interactive dashboards with Cognos and R Shiny

This course will teach you the foundational data skills employers are seeking for entry level data analytics roles and will provide a portfolio of projects and a Professional Certificate from IBM to showcase your expertise to potential employers.

You’ll learn the latest skills and tools used by professional data analysts and upon successful completion of this program, you will be able to work with Excel spreadsheets, Jupyter Notebooks, and R Studio to analyze data and create visualizations. You will also use the R programming language to complete the entire data analysis process, including data preparation, statistical analysis, data visualization, predictive modeling and creating interactive dashboards. Lastly, you’ll learn how to communicate your data findings and prepare a summary report.

In just 7 days, you’ll also learn how to:

  • Describe the data ecosystem, tasks a Data Analyst performs, as well as skills and tools required to become a successful Data Analyst
  • Explain basic functionality of spreadsheets, and utilize Excel to perform a variety of data analysis tasks like data wrangling, using pivot tables, and data mining
  • Create various types of visualizations including charts, and dashboards using Excel and Cognos Analytics.
  • Perform basic R programming tasks such as using common data structures, data manipulation, using APIs, webscraping, and working with R Studio and Jupyter.
  • Create relational databases and query the data using SQL and R from JupyterLab
  • Complete the data analysis process, including data preparation, statistical analysis, and predictive modeling.
  • Communicate data findings using data visualization charts, plots, and dashboards using libraries such as ggplot, leaflet and R Shiny.

At the end of this course, you’ll sit the IBM exam, and achieve your IBM Data Analytics with Excel and R Professional Certification. Through Firebrand’s Lecture | Lab | Review methodology, you’ll get certified at twice the speed of the traditional training and get access to courseware, learn from certified instructors, and train in a distraction-free environment.

 

Audience

This course is ideal for:

  • Entry level roles in Data Analytics or Data Science.

Her er 8 grunner til hvorfor du skal gjennomføre ditt hos Firebrand Training:

  1. Du blir utdannet og sertifisert på bare 7 dager. Hos oss får du din utdanning og sertifisering på rekordtid, en sertifisering du også gjennomfører der og da som en integrert del av den intensive, akselererte utdanningen.
  2. Alt er inkludert. Et engangsbeløp dekker alt kursmaterial, eksamen, kost og losji og tilbyr den mest kostnadseffektive måten å gjennomføre ditt kurs og sertifisering på. Og dette uten noen uannonserte ytterligere kostnader.
  3. Du klarer sertifiseringen første gangen eller kan gå kurset om igjen kostnadsfritt. Det er vår garanti. Vi er sikre på at du vil klare din sertifisering første gangen. Men skulle du mot formodning ikke gjøre det kan du innen et år komme tilbake og kun betale for eventuelle overnattinger og din eksamen. Alt annet er gratis.
  4. Du lærer deg mer.Tradisjonelle utdanningsdager varer fra kl. 09.00 til 16.00 med lange lunsj- og kaffepauser. Hos Firebrand Training får du minst 12 timers effektiv og fokusert kvalitetsutdanning hver dag sammen med din instruktør, uten private eller arbeidsrelaterte, forstyrrende momenter.
  5. Du lærer deg raskere. Vi kombinerer de tre innlæringsmetodene (Presentasjon |Øving| Diskusjon) slik at vi gjennomfører kurset på en måte som sikrer at du lærer deg raskere og lettere.
  6. Du er i sikre hender.Vi har utdannet og sertifisert 134.561 personer, vi er partner med alle de store navn i bransjen og vi har vunnet atskillige utmerkelser, bla. a. "Årets Learning Partner 2010, 2011, 2012, 2013 og 2015” fra Microsoft Danmark og med en vekst på 1430 % siden 2009 er vi årets Gazelle prisvinner på Sjælland, Danmark.
  7. Du lærer deg ikke bare teorien. Vi har videreutviklet kursen og tilbyr flere praktiske øvelser og sikrer på den måten, at du kan bruke dine ferdigheter for å løse daglige praktiske problemstillinger.
  8. Du lærer av de beste. Våre instruktører på er de beste i bransjen og tilbyr en helt unik blanding av kunnskap, praktisk erfaring og pasjon for å lære bort.

Curriculum

Module 1: Introduction to Data Analytics

  • Explain what Data Analytics is and the key steps in the Data Analytics process
  • Differentiate between different data roles such as Data Engineer, Data Analyst, Data Scientist, Business Analyst, and Business Intelligence Analyst
  • Describe the different types of data structures, file formats, and sources of data
  • Describe the data analysis process involving collecting, wrangling, mining, and visualizing data

Module 2: Excel Basics for Data Analysis

  • Display working knowledge of Excel for Data Analysis.
  • Perform basic spreadsheet tasks including navigation, data entry, and using formulas.
  • Employ data quality techniques to import and clean data in Excel.
  • Analyze data in spreadsheets by using filter, sort, look-up functions, as well as pivot tables.

 

Module 3: Data Visualization and Dashboards with Excel and Cognos

  • Create basic visualizations such as line graphs, bar graphs, and pie charts using Excel spreadsheets.
  • Explain the important role charts play in telling a data-driven story.
  • Construct advanced charts and visualizations such as Treemaps, Sparklines, Histogram, Scatter Plots, and Filled Map Charts.
  • Build and share interactive dashboards using Excel and Cognos Analytics.

 

Module 4: Assessment for Data Analysis and Visualization Foundations

  • Demonstrate readiness for performing foundational data analysis and data visualization tasks and key steps in the Data Analytics process.
  • Differentiate between the roles different data professionals play in a modern data ecosystem.
  • Perform basic Excel tasks for Data Analysis including data quality and data preparation skills.
  • Exhibit abilities in visualizing data using Excel and proficiency in creating dashboards using Excel and Cognos Analytics.

 

 

Module 5: Introduction to R Programming for Data Science

  • Manipulate primitive data types in the R programming language using RStudio or Jupyter Notebooks.
  • Control program flow with conditions and loops, write functions, perform character string operations, write regular expressions, handle errors.
  • Construct and manipulate R data structures, including vectors, factors, lists, and data frames.
  • Read, write, and save data files and scrape web pages using R.

 

Module 6: SQL for Data Science with R

  • Create and access a database instance on the cloud
  • Compose and execute basic SQL statements - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
  • Construct SQL statements to filter, sort, group results, use built-in functions, compose nested queries, access multiple tables
  • Analyze data from Jupyter using R and SQL by combining SQL and R skills to query real-world datasets

 

Module 7: Data Analysis with R

  • Prepare data for analysis by handling missing values, formatting and normalizing data, binning, and turning categorical values into numeric values.
  • Compare and contrast predictive models using simple linear, multiple linear, and polynomial regression methods.
  • Examine data using descriptive statistics, data grouping, analysis of variance (ANOVA), and correlation statistics.
  • Evaluate a model for overfitting and underfitting conditions and tune its performance using regularization and grid search.

 

Module 8: Data Visualization with R

  • Create bar charts, histograms, pie charts, scatter plots, line graphs, box plots, and maps using R and related packages.
  • Design customized charts and plots using annotations, axis titles, text labels, themes, and faceting.
  • Create maps using the Leaflet package for R.
  • Create interactive dashboards using the Shiny package for R.

 

Module 9: Data Science with R - Capstone Project

  • Write a web scraping program to extract data from an HTML file using HTTP requests and convert the data to a data frame.
  • Prepare data for modelling by handling missing values, formatting and normalizing data, binning, and turning categorical values into numeric values.
  • Interpret datawithexploratory data analysis techniques by calculating descriptive statistics, graphing data, and generating correlation statistics.
  • Build a Shiny app containing a Leaflet map and an interactive dashboard then create a presentation on the project to share with your peers.

Exam Track

At the end of this accelerated course, you’ll sit the following exam at the Firebrand Training centre, covered Certification Guarantee:

IBM: IBM Data Analytics with Excel and R Professional Certification Exam

You will complete hands-on labs to build your portfolio and gain practical experience with Excel, Cognos Analytics, SQL, and the R programing language and related libraries for data science, including Tidyverse, Tidymodels, R Shiny, ggplot2, Leaflet, and rvest.

Projects include:

  • Analyzing fleet vehicle inventory data using pivot tables.
  • Using key performance indicator (KPI) data from car sales to create an interactive dashboard.
  • Identifying patterns in countries’ COVID-19 testing data rates using R.
  • Using SQL with the RODBC R package to analyze foreign grain markets.
  • Creating linear and polynomial regression models and comparing them with weather station data to predict precipitation.
  • Using the R Shiny package to create a dashboard that examines trends in census data.
  • Using hypothesis testing and predictive modeling skills to build an interactive dashboard with the R Shiny package and a dynamic Leaflet map widget to investigate how weather affects bike-sharing demand.
  • Submitting this idea will trigger a series of actions for various teams. The product team will review the initial idea and progress it through the life cycle

What's Included

Prerequisites

Before attending this accelerated course, you should have:

  • No prior experience required, but statistical or programming knowledge is necessary.

Anmeldelser

Vi har lært opp 134.561 personer på 12 år. Vi ba dem om å anmelde vår akselererte opplæring. Akkurat nå har 96,41% angitt at Firebrand overgikk forventningene:

"I had a great time. The instructor is very knowledgeable and his training is on point. Two exams in 2 days is a lot. But he makes it doable."
Juan van Gom, Ministry of Defense Netherlands. (19/1/2024 (Fredag) til 21/1/2024 (Søndag))

"Detailed and thorough training in a great environment."
Anonymous, SYP. (8/1/2024 (Mandag) til 12/1/2024 (Fredag))

"I attended the Cyber Crime Foundation course with very little knowledge.. The instructor was fantastic, explained subjects in depth and allowed a good amount of time for questions. I came away with lots of knowledge ready to use what I''ve learnt in my day-to-day role."
JS. (8/1/2024 (Mandag) til 12/1/2024 (Fredag))

"I very much enjoyed the training! It is a must for police officers new to Cyber Crime Units and is delivered at a good pace. Very good trainer with exceptional knowledge and enthusiasm."
Steve Lloyd, West Mercia Police. (8/1/2024 (Mandag) til 12/1/2024 (Fredag))

"I have really enjoyed the course, although I have been a self-professed nerd for many years, there was still some knowledge I took from this course. The tutorials on practical applications is something I will take away and use."
Joseph Ingram-Gettins, West Midlands Police. (8/1/2024 (Mandag) til 12/1/2024 (Fredag))

Kursdatoer

Start

Slutt

Kapasitet

Plass

Registrer deg

19/2/2024 (Mandag)

25/2/2024 (Søndag)

Ferdig - Gi tilbakemelding

-

 

24/6/2024 (Mandag)

30/6/2024 (Søndag)

Venteliste

Landsdekkende

 

5/8/2024 (Mandag)

11/8/2024 (Søndag)

Begrenset kapasitet

Landsdekkende

 

16/9/2024 (Mandag)

22/9/2024 (Søndag)

Ledige plasser

Landsdekkende

 

28/10/2024 (Mandag)

3/11/2024 (Søndag)

Ledige plasser

Landsdekkende

 

9/12/2024 (Mandag)

15/12/2024 (Søndag)

Ledige plasser

Landsdekkende

 

Siste anmeldelser fra studenten vår