We may earn an affiliate commission when you visit our partners.
Data Preparation and Modeling
Ivan Vega,
Joseph Lozada,
and
Daniel Roca
Ivan Vega,
Joseph Lozada,
and
Daniel Roca
Take your understanding of Data Modeling & Preparation to the next level with Udacity's online training course. Develop the skills you need to grow your career.
Prerequisite details
Read more
Take your understanding of Data Modeling & Preparation to the next level with Udacity's online training course. Develop the skills you need to grow your career.
Prerequisite details
Read more
Take your understanding of Data Modeling & Preparation to the next level with Udacity's online training course. Develop the skills you need to grow your career.
Prerequisite details
To optimize your success in this program, we've created a list of prerequisites and recommendations to help you prepare for the curriculum. Prior to enrolling, you should have the following knowledge:
- Data quality control
- Chart types
- Data analysis process
- Excel
- Exploratory data analysis
- Data visualization
You will also need to be able to communicate fluently and professionally in written and spoken English.
Register for this course and see more details by visiting:
OpenCourser.com/course/9o4r5e/data
What's inside
Syllabus
Introduction to Data Preparation & Modeling lesson introduces students to the topics, highlights, and prerequisites of the course. And requirements to successfully complete the course are explained.
Read more
Syllabus
Introduction to Data Preparation & Modeling lesson introduces students to the topics, highlights, and prerequisites of the course. And requirements to successfully complete the course are explained.
Read more
Relational Data & Table Structure lesson teaches the core concepts around working with data from multiple sources and tables. It explains what relational data is and how it works.
Power Query & M Overview lesson highlights the Power Query data wrangling system that is used within Power BI. Specific cleaning and organization tools and techniques are explored.
Data Cleaning & Organization lesson takes a practical deep dive into Power Query. Here more complex data cleaning and organization strategies are practiced, and the M language is explained.
DAX Language & Quantitative Analysis lesson dives into DAX, which is the primary analytical language of Power BI. Different foundational concepts around DAX calculations are covered.
The project asks students to gather data about the US economy to understand better the makeup of the economy and how it’s changing. Students will submit a PowerBI report at the end.
In this lesson, you'll learn how to set up a Windows desktop workspace to use Power BI
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Explores in-demand skills in data preparation and modeling, improving career prospects
Focuses on data cleaning, organization, and analytical calculations using Power BI, fostering practical data handling abilities
Emphasizes foundational data analytics concepts and techniques, building a solid knowledge base for beginners
Taught by industry professionals, ensuring real-world relevance and expertise in data modeling and preparation
Leverages Power Query, a widely used data wrangling system, enhancing practical application and industry relevance
Requires prior knowledge in data quality control, chart types, and data analysis, indicating a suitable fit for learners with some foundational understanding in data handling
Save this course
Save Data Preparation and Modeling to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Data Preparation and Modeling.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Data Preparation and Modeling will develop knowledge and skills
that may be useful to these careers:
Data Scientist
Data Scientist
Data Scientists use data to solve business problems and develop new products and services. This course provides a strong foundation in data preparation and modeling, which are essential skills for Data Scientists. The skills and knowledge you'll gain in this course will help you prepare for a career as a Data Scientist.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers build and deploy machine learning models to solve real-world problems. This course provides a strong foundation in data preparation and modeling, which are essential skills for Machine Learning Engineers. The skills and knowledge you'll gain in this course will help you prepare for a career as a Machine Learning Engineer.
Business Analyst
Business Analyst
Business Analysts help businesses improve their operations by analyzing data and identifying inefficiencies. This course provides a strong foundation in data preparation and modeling, which are essential skills for Business Analysts. The skills and knowledge you'll gain in this course will help you prepare for a career as a Business Analyst.
Data Analyst
Data Analyst
Data Analysts are responsible for collecting, cleaning, and analyzing data to help businesses make informed decisions. This course provides a strong foundation in data preparation and modeling, which are essential skills for Data Analysts. The skills and knowledge you'll gain in this course will help you prepare for a career as a Data Analyst.
Data Engineer
Data Engineer
Data Engineers design and build the systems that store and process data. This course provides a strong foundation in data preparation and modeling, which are essential skills for Data Engineers. The skills and knowledge you'll gain in this course will help you prepare for a career as a Data Engineer.
Statistician
Statistician
Statisticians collect, analyze, and interpret data to help businesses make informed decisions. This course provides a strong foundation in data preparation and modeling, which are essential skills for Statisticians. The skills and knowledge you'll gain in this course will help you prepare for a career as a Statistician.
Financial Analyst
Financial Analyst
Financial Analysts use data to analyze financial markets and make investment recommendations. This course provides a strong foundation in data preparation and modeling, which are essential skills for Financial Analysts. The skills and knowledge you'll gain in this course will help you prepare for a career as a Financial Analyst.
Marketing Analyst
Marketing Analyst
Marketing Analysts use data to analyze marketing campaigns and make recommendations for improvement. This course provides a strong foundation in data preparation and modeling, which are essential skills for Marketing Analysts. The skills and knowledge you'll gain in this course will help you prepare for a career as a Marketing Analyst.
Risk Analyst
Risk Analyst
Risk Analysts use data to identify and manage risks. This course provides a strong foundation in data preparation and modeling, which are essential skills for Risk Analysts. The skills and knowledge you'll gain in this course will help you prepare for a career as a Risk Analyst.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use data to analyze and optimize business operations. This course provides a strong foundation in data preparation and modeling, which are essential skills for Operations Research Analysts. The skills and knowledge you'll gain in this course will help you prepare for a career as an Operations Research Analyst.
Data Architect
Data Architect
Data Architects design and manage data systems. This course provides a strong foundation in data preparation and modeling, which are essential skills for Data Architects. The skills and knowledge you'll gain in this course will help you prepare for a career as a Data Architect.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software systems. This course provides a strong foundation in data preparation and modeling, which are essential skills for Software Engineers. The skills and knowledge you'll gain in this course will help you prepare for a career as a Software Engineer.
Computer Scientist
Computer Scientist
Computer Scientists research and develop new computing technologies. This course provides a strong foundation in data preparation and modeling, which are essential skills for Computer Scientists. The skills and knowledge you'll gain in this course will help you prepare for a career as a Computer Scientist.
Database Administrator
Database Administrator
Database Administrators manage and maintain databases. This course provides a strong foundation in data preparation and modeling, which are essential skills for Database Administrators. The skills and knowledge you'll gain in this course will help you prepare for a career as a Database Administrator.
Information Security Analyst
Information Security Analyst
Information Security Analysts protect computer systems and networks from unauthorized access. This course provides a strong foundation in data preparation and modeling, which are essential skills for Information Security Analysts. The skills and knowledge you'll gain in this course will help you prepare for a career as an Information Security Analyst.
For more career information including salaries, visit:
OpenCourser.com/course/9o4r5e/data
Reading list
We've selected 15 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Data Preparation and Modeling.
Classic in the field of data modeling and provides a comprehensive overview of the subject. It is particularly valuable for its coverage of data modeling concepts and techniques.
Practical guide to dimensional modeling, which key technique for data warehousing. It provides step-by-step instructions on how to design and implement a data warehouse.
Provides a comprehensive guide to using Power BI for data modeling and business intelligence. It is particularly valuable for its coverage of Power BI's data modeling capabilities and DAX language.
Provides a comprehensive guide to statistical learning. It is helpful for learners who want to gain a deeper understanding of the concepts and techniques used in statistical learning.
Provides a comprehensive guide to data warehousing. It is helpful for learners who want to gain a deeper understanding of the concepts and techniques used in data warehousing.
Save
Provides a comprehensive guide to deep learning. It is helpful for learners who want to gain a deeper understanding of the concepts and techniques used in deep learning.
Provides a collection of recipes for solving common DAX problems. It is helpful for learners who want to quickly find solutions to specific problems.
Provides a comprehensive overview of data quality best practices and techniques. It is particularly valuable for its coverage of data quality metrics and data cleansing methods.
Save
Provides a practical approach to data modeling for beginners. It is helpful for learners who want to gain a foundational understanding of data modeling concepts.
Provides a simplified approach to machine learning. It is helpful for learners who want to gain a basic understanding of machine learning concepts without getting bogged down in technical details.
Save
Provides a simplified approach to data modeling. It is helpful for learners who want to gain a basic understanding of data modeling concepts without getting bogged down in technical details.
Provides a simplified approach to artificial intelligence. It is helpful for learners who want to gain a basic understanding of artificial intelligence concepts without getting bogged down in technical details.
Provides a simplified approach to natural language processing. It is helpful for learners who want to gain a basic understanding of natural language processing concepts without getting bogged down in technical details.
Provides a simplified approach to computer vision. It is helpful for learners who want to gain a basic understanding of computer vision concepts without getting bogged down in technical details.
Provides a simplified approach to data mining. It is helpful for learners who want to gain a basic understanding of data mining concepts without getting bogged down in technical details.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/9o4r5e/data
Share
Similar courses
Here are nine courses similar to
Data Preparation and Modeling.
Extract, Transform and Load Data in Power BI
OpenCourser.com/course/usomlh/extract
Extract, Transform and Load Data in Power BI
Most relevant
Financial Reporting with Power BI: Basic Financial Analysis
OpenCourser.com/course/mbbxwn/financial
Financial Reporting with Power BI: Basic Financial...
Most relevant
Learn Data Storytelling: Power BI Techniques
OpenCourser.com/course/juy7vc/learn
Learn Data Storytelling: Power BI Techniques
Most relevant
Data Storytelling with Power BI
OpenCourser.com/course/6sro18/data
Data Storytelling with Power BI
Most relevant
Ingest and Transform Data by Using Power BI - DP-500
OpenCourser.com/course/i8asa7/ingest
Ingest and Transform Data by Using Power BI - DP-500
Most relevant
Power BI Fundamentals
OpenCourser.com/course/63sou1/power
Power BI Fundamentals
Most relevant
Clean, Transform, and Load Data with Power BI
OpenCourser.com/course/l7v8m4/clean
Clean, Transform, and Load Data with Power BI
Most relevant
Preparing and Modeling Data with Power BI
OpenCourser.com/course/2uxt30/preparing
Preparing and Modeling Data with Power BI
Most relevant
Excel Power Tools for Data Analysis
OpenCourser.com/course/v9j1qq/excel
Excel Power Tools for Data Analysis
Most relevant
Effort
4 weeks
Level
Introductory
Via
Udacity
Instructors
Ivan Vega
Joseph Lozada
Daniel Roca
Language
English
Good to know
Explores in-demand skills in data preparation and modeling, improving career prospects
Focuses on data cleaning, organization, and analytical calculations using Power BI, fostering practical data handling abilities
Emphasizes foundational data analytics concepts and techniques, building a solid knowledge base for beginners
Taught by industry professionals, ensuring real-world relevance and expertise in data modeling and preparation
Leverages Power Query, a widely used data wrangling system, enhancing practical application and industry relevance
Requires prior knowledge in data quality control, chart types, and data analysis, indicating a suitable fit for learners with some foundational understanding in data handling
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser