Menara Q Sentral, Kuala Lumpur Sentral.+603 9212 0203enquiry@bsacrescent.com

Data Wrangling with MongoDB (Udacity)

Data Wrangling With MongoDB Course

MongoDB Advanced Partner

In this course, we will explore how to wrangle data from diverse sources and shape it to enable data-driven applications. Some data scientists spend the bulk of their time doing this!

[qode_advanced_tabs title_tag=”h3″][qode_advanced_tab tab_title=”About”]
ABOUT THIS COURSE

Students will learn how to gather and extract data from widely used data formats. They will learn how to assess the quality of data and explore best practices for data cleaning. We will also introduce students to MongoDB, covering the essentials of storing data and the MongoDB query language together with exploratory analysis using the MongoDB aggregation framework.

AUDIENCE PROFILE

This is a great course for those interested in entry-level data science positions as well as current business/data analysts looking to add big data to their repertoire, and managers working with data professionals or looking to leverage big data.

AT COURSE COMPLETION

At the end of the class, students should be able to:

  • Programmatically extract data stored in common formats such as csv, Microsoft Excel, JSON, XML and scrape web sites to parse data from HTML.
  • Audit data for quality (validity, accuracy, completeness, consistency, and uniformity) and critically assess options for cleaning data in different contexts.
  • Store, retrieve, and analyze data using MongoDB.
[/qode_advanced_tab][qode_advanced_tab tab_title=”Topics”]
  • LESSON 1: DATA EXTRACTION FUNDAMENTALS
    • Assessing the Quality of Data
    • Intro to Tabular Formats
    • Parsing CSV
    • Parsing XLS with XLRD
    • Intro to JSON
    • Using Web APIs
    LESSON 2: DATA IN MORE COMPLEX FORMATS
    • Intro to XML
    • XML Design Principles
    • Parsing XML
    • Web Scraping
    • Parsing HTML
    LESSON 3: DATA QUALITY
    • What is Data Cleaning?
    • Sources of Dirty Data
    • Measuring Data Quality
    • A Blueprint for Cleaning
    • Auditing Validity
    • Auditing Accuracy
    • Auditing Completeness
    • Auditing Consistency
    • Auditing Uniformity
    LESSON 4: WORKING WITH MONGODB
    • Data Modelling in MongoDB
    • Introduction to PyMongo
    • Field Queries
    • Projection Queries
    • Getting Data into MongoDB
    • Using mongoimport
    • Operators like $gt, $lt, $exists, $regex
    • Querying Arrays and using $in and $all Operators
    • Changing entries: $update, $set, $unset
    LESSON 5: ANALYZING DATA
    • Examples of Aggregation Framework
    • The Aggregation Pipeline
    • Aggregation Operators: $match, $project, $unwind, $group
    • Multiple Stages Using a Given Operator
    LESSON 6: CASE STUDY – OPENSTREETMAP DATA
    • Using iterative parsing for large datafiles
    • Open Street Map XML Overview
    • Exercises around OpenStreetMap data
    • Final Project Instructions
[/qode_advanced_tab][qode_advanced_tab tab_title=”Prerequisites”]

The ideal student should have the following skills:

  • Programming experience in Python or a willingness to read a little documentation to understand examples and exercises throughout the course.
  • The ability to perform rudimentary system administration on Windows or Unix

At least some experience using a unix shell or Windows PowerShell will be helpful, but is not required.

No prior experience with databases is needed.

[/qode_advanced_tab][qode_advanced_tab tab_title=”Calendar”]

Calendar coming soon. Enquire today to reserve your spot.

[/qode_advanced_tab][/qode_advanced_tabs]

Enquire for this course

  • This field is for validation purposes and should be left unchanged.

Learn digital skills and get certified with our training programs

All BSA Crescent Training Programs are HRDF claimable!

[image_with_text title_tag="h3" title_color="#182d58" title="Leadership Courses" image="1326"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="883" title="Blockchain Academy courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="1055" title="Management courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" title="Soft Skill Development" image="1262"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="445" title="Digital Marketing courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="438" title="Cisco courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="435" title="Adobe courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="434" title="Microsoft courses"] [/image_with_text]
[image_with_text title_tag="h3" title_color="#182d58" image="436" title="Autodesk courses"] [/image_with_text]

Upcoming course dates

All BSA Crescent Training Programs are HRDF claimable!

[qode_info_card title_tag="h2" enable_button="yes" image="1332" title="Winning Communication course" text="13 October | Q Sentral | HRDF Claimable | Knowing your audience, that’s the most important tip for Winning Communication" button_link="//bsacrescent.com/courses/soft-skills-development/winning-communication-course/" button_text="View details"]
[qode_info_card title_tag="h2" enable_button="yes" image="1298" title="Customer Service Excellence course" text="22 November | Q Sentral | HRDF Claimable | Customer expectations are extremely high and you may encounter some very challenging and demanding people " button_link="//bsacrescent.com/courses/soft-skills-development/customer-service-excellence/" button_text="View details"]
[qode_info_card title_tag="h2" enable_button="yes" image="1320" title="Problem Solving & Decision Making skills" text="23 November | Q Sentral | HRDF Claimable | Correct and timely decision-making can be done using specific techniques and enhanced knowledge of the self and situations" button_link="//bsacrescent.com/courses/leadership/problem-solving-decision-making-skills/" button_text="View details"]

Training Centre Location

Unit 30-2
Menara Q Sentral
2A Jalan Stesen Sentral 2
KL Sentral
50470 Kuala Lumpur
Malaysia

Training Centre Accessibility

BSA Crescent Academy Training Centre is conveniently located at KL Sentral.

Our Training Centre is connected by mayor highways, LRT, MRT, Monorail, KTM Komuter and ERL.

Ample parking space is available in the building.

Why BSA Crescent?

[icon_text box_type="normal" icon="fa-building" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="State of the art facilities" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-user" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Experienced and certified trainers" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-desktop" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Stay up-to-date with new and relevant technologies" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-info" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Training and mentorship combined" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-thumbs-up" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Fully HRDF Claimable" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-certificate" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Internationally Recognized Certification" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-globe" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="Placement Opportunities" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]
[icon_text box_type="normal" icon="fa-book" icon_type="circle" icon_position="top" icon_size="fa-3x" use_custom_icon_size="no" title="High Quality Courseware" title_tag="h3" separator="no" icon_border_color="#ffffff" icon_color="#ffffff" icon_hover_color="#ffffff" title_color="#ffffff"]

Course Partners

BSA Crescent is an authorised testing center for...

Translate »