$149

Data Modelling: No PlayDoh Required

Event Information

Share this event

Date and Time

Location

Location

UCSD Extension

6256 Greenwich Drive

San Diego, CA 92122

View Map

Refund Policy

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Event description

Description

While Data Scientists may be the hottest buzz word, having a data model that is easy for consumption by those people is the hidden secret of data analysis. Learn the secret of data modelling in this full-day, hands-on course so that you can be the hero of your analysts by providing data in an easy to use format.

After a brief introduction to the third normal form and dimensional models, we will work through converting a paper form into a third normal form model for data collection and creating a dimensional model to report from that collection. Finally, we will create a Power BI Model and create some visualizations.

Intended Audience:
• Database and Application Developers looking to expand their knowledge of database models.
• Data Analysts who want an introduction to the modelling that will make analysis easier.
• Anyone who wants to learn more about database design and modelling

Contents:
• Part 1 - The Data Model: A Perfect Ten (introductory presentation)
• Part 2 - New Mexico UCR Form conversion to 3NF (hands-on lab)
• Part 3 - New Mexico UCR Form conversion to Dimensional Model (hands-on lab)
• Part 4 - Power BI Modelling Tool (introductory presentation)
• Part 5 - Modelling the data with Power BI (hands-on lab)
• Part 6 - Data Exploration (hands-on lab)

Class Format:
• Slides - 10%
• Demos - 10%
• Hands-on Labs - 80%

Note that as this is a hands-on pre-con, participants will be required to bring a laptop with a working Power BI installation and a data modelling tool. Full details on this will be provided prior to the session.


FAQs
What is the refund policy?
Once purchased, tickets are refundable up to the day prior of the event. Tickets are transferrable.

What does the ticket include?
The ticket for the event includes the following:

  • Access to Session Material for the Pre-Conference Workshop
  • Continental Breakfast, Lunch and Snacks are included. If you have any dietary restrictions please let us know at sqlsaturday909@sqlsaturday.com

Where on campus is the event located?
Detailed instructions on the exact location of the classroom for your event will be sent closer to the day of the event in addition to information on parking.

Does this register me for the SQL Saturday event the next day?
No. If you are planning on attending the main SQL Saturday event the next day, please be sure to register on the main SQL Saturday site: https://www.sqlsaturday.com/909/register.aspx.

What if I have Questions?
Please email us at sqlsaturday909@sqlsaturday.com.


Share with friends

Date and Time

Location

UCSD Extension

6256 Greenwich Drive

San Diego, CA 92122

View Map

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved