We may earn an affiliate commission when you visit our partners.
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
Two deals to help you save
We found two deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Use code at checkout.
Valid for a limited time only
Bootcamp level quality
Complete hands-on projects and get personalized feedback with Udacity.
Take
40%
off
UDACITY40
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
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
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Data Preparation and Modeling with these
activities:
Review Data Modeling Concepts
Show steps
Reviewing data modeling concepts will provide a refresher of the underlying principles and ensure you have a solid foundation before delving into Power BI.
Browse courses on
Data Modeling
Show steps
-
Study notes or textbooks on data modeling.
-
Complete practice exercises to test your understanding.
Review Data Analysis with Power BI
Show steps
Reviewing this book will help refresh your understanding of key concepts from relational databases to DAX and quantitative analysis as it applies to Power BI.
View
Optimizing DAX
on Amazon
Show steps
-
Read the introduction and skim the table of contents to familiarize yourself with the book's structure and topics.
-
Review the chapter on relational data and table structure to solidify your understanding of how to work with multiple sources and tables.
-
Explore the chapter on Power Query and M Overview to get hands-on with data wrangling and manipulation.
-
Dive into the chapter on data cleaning and organization to practice managing complex data sets.
-
Finish by reviewing the chapter on DAX Language and Quantitative Analysis to strengthen your analytical skills with DAX.
Practice Data Cleaning
Show steps
Practicing data cleaning will improve your proficiency in managing and preparing data for analysis, ensuring you can effectively work with real-world data sets.
Browse courses on
Data Cleaning
Show steps
-
Find data sets with common data quality issues.
-
Apply data cleaning techniques to address issues such as missing values, outliers, and inconsistencies.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Explore Power BI Tutorials
Show steps
Following tutorials will allow you to expand your understanding of Power BI's capabilities and learn new techniques.
Browse courses on
Power BI
Show steps
-
Search for tutorials that cover specific topics or features you want to explore.
-
Follow the instructions and complete the exercises provided in the tutorials.
-
Experiment with the concepts learned and apply them to your own projects.
Solve Power BI Practice Problems
Show steps
Solving practice problems will reinforce your understanding of data preparation and modeling techniques and provide hands-on experience with Power BI.
Browse courses on
Power BI
Show steps
-
Find practice problems online or in textbooks.
-
Attempt to solve the problems independently.
-
Review your solutions against provided answers or ask for help from instructors or peers.
Attend a Power BI Workshop
Show steps
Attending a workshop will provide you with a structured learning environment tailored to enhancing your Power BI knowledge and skills.
Browse courses on
Power BI
Show steps
-
Identify and register for a relevant workshop.
-
Attend the workshop and actively participate in activities.
-
Network with other participants and industry professionals.
Create a Power BI Report
Show steps
Creating a report will allow you to demonstrate your ability to synthesize data, analyze it, and present insights effectively using Power BI.
Browse courses on
Power BI
Show steps
-
Gather data from relevant sources.
-
Clean and prepare the data in Power BI.
-
Develop visualizations and dashboards to illustrate your findings.
-
Write a report summarizing your analysis and insights.
-
Share your report with others for feedback and discussion.
Review Data Modeling Concepts
Show steps
Reviewing data modeling concepts will provide a refresher of the underlying principles and ensure you have a solid foundation before delving into Power BI.
Browse courses on
Data Modeling
Show steps
Show steps
Show steps
- Study notes or textbooks on data modeling.
- Complete practice exercises to test your understanding.
Review Data Analysis with Power BI
Show steps
Reviewing this book will help refresh your understanding of key concepts from relational databases to DAX and quantitative analysis as it applies to Power BI.
View
Optimizing DAX
on Amazon
Show steps
Show steps
Show steps
- Read the introduction and skim the table of contents to familiarize yourself with the book's structure and topics.
- Review the chapter on relational data and table structure to solidify your understanding of how to work with multiple sources and tables.
- Explore the chapter on Power Query and M Overview to get hands-on with data wrangling and manipulation.
- Dive into the chapter on data cleaning and organization to practice managing complex data sets.
- Finish by reviewing the chapter on DAX Language and Quantitative Analysis to strengthen your analytical skills with DAX.
Practice Data Cleaning
Show steps
Practicing data cleaning will improve your proficiency in managing and preparing data for analysis, ensuring you can effectively work with real-world data sets.
Browse courses on
Data Cleaning
Show steps
Show steps
Show steps
- Find data sets with common data quality issues.
- Apply data cleaning techniques to address issues such as missing values, outliers, and inconsistencies.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Explore Power BI Tutorials
Show steps
Following tutorials will allow you to expand your understanding of Power BI's capabilities and learn new techniques.
Browse courses on
Power BI
Show steps
Show steps
Show steps
- Search for tutorials that cover specific topics or features you want to explore.
- Follow the instructions and complete the exercises provided in the tutorials.
- Experiment with the concepts learned and apply them to your own projects.
Solve Power BI Practice Problems
Show steps
Solving practice problems will reinforce your understanding of data preparation and modeling techniques and provide hands-on experience with Power BI.
Browse courses on
Power BI
Show steps
Show steps
Show steps
- Find practice problems online or in textbooks.
- Attempt to solve the problems independently.
- Review your solutions against provided answers or ask for help from instructors or peers.
Attend a Power BI Workshop
Show steps
Attending a workshop will provide you with a structured learning environment tailored to enhancing your Power BI knowledge and skills.
Browse courses on
Power BI
Show steps
Show steps
Show steps
- Identify and register for a relevant workshop.
- Attend the workshop and actively participate in activities.
- Network with other participants and industry professionals.
Create a Power BI Report
Show steps
Creating a report will allow you to demonstrate your ability to synthesize data, analyze it, and present insights effectively using Power BI.
Browse courses on
Power BI
Show steps
Show steps
Show steps
- Gather data from relevant sources.
- Clean and prepare the data in Power BI.
- Develop visualizations and dashboards to illustrate your findings.
- Write a report summarizing your analysis and insights.
- Share your report with others for feedback and discussion.
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
Data Storytelling with Power BI
OpenCourser.com/course/6sro18/data
Data Storytelling with Power BI
Most relevant
Learn Data Storytelling: Power BI Techniques
OpenCourser.com/course/juy7vc/learn
Learn Data Storytelling: Power BI Techniques
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