Reporting in SQL
Learn how to build your own SQL reports and dashboards, plus hone your data exploration, cleaning, and validation skills.
Comece O Curso Gratuitamente4 horas15 vídeos54 exercícios32.609 aprendizesDeclaração de Realização
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.Treinar 2 ou mais pessoas?
Tentar DataCamp for BusinessAmado por alunos de milhares de empresas
Descrição do Curso
Master SQL Reporting
Build clear and valuable SQL reports and dashboards, and hone your skills in data cleaning and validation.In this course, you will apply all the SQL concepts and functions you have learned in previous courses to build your very own dashboard. You will work on an Olympics database to learn about data exploration, data manipulation, data cleaning and validation, and performing complex calculations.
The first chapter aims to get you familiar with the dataset you’ll use, covering some of the essentials you'll need to explore the data properly. Here you will learn how to use ER diagrams and data exploration techniques to get a solid understanding of the data.
Practice Building SQL Reports Using Real Datasets
Next, you’ll learn to build more complex SQL queries to help you explore the data in more detail. The step-by-step approach helps you understand why complex queries require more thought and how they can help you build reports.Once you get a hang of reporting in SQL, you will learn how to clean and validate SQL data, ensuring our reports are accurate and interpretable.
Develop Your SQL Database Skills
Learn to perform complex calculations using window functions and layered calculations in the final chapter. You will gain hands-on experience building two advanced calculations in particular: the percent of a total calculation and the performance index calculation.This SQL course is perfect for anyone who will be commonly pulling data from databases and is a great complement for those who use R or Python for data science. This course is part of the SQL for Business Analysts Track and is essential for those who are planning to complete a Data Science or Data Analysis certification with DataCamp.
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL para analistas de negócios
Ir para a trilha- 1
Exploring the Olympics Dataset
GratuitoBefore you can start building out reports to answer specific questions, you should get familiar with the data. In this chapter, you will learn how to use E:R diagrams and data exploration techniques to get a solid understanding of the data to better answer business-related questions.
Case study50 xpIdentifying the base report50 xpBuilding the base report100 xpAthletes vs events by sport100 xpThe Olympics dataset50 xpPlanning queries with an E:R diagram50 xpAge of oldest athlete by region100 xpNumber of events in each sport100 xpExploring our data50 xpExploring summer_games100 xpValidating our query100 xpReport 1: Most decorated summer athletes100 xp - 2
Creating Reports
Queries can get large, fast. It's important to take a logical approach when building more complicated queries. In this chapter, you will take a step-by-step approach to plan and build a complex query that requires you to combine tables in multiple ways and create different types of fields.
Planning the query50 xpPlanning the SELECT statement50 xpPlanning the filter100 xpCombining tables50 xpJOIN then UNION query100 xpUNION then JOIN query100 xpCreating custom fields50 xpCASE statement refresher100 xpBMI bucket by sport100 xpTroubleshooting CASE statements100 xpFiltering and finishing touches50 xpFiltering with a JOIN100 xpFiltering with a subquery100 xpReport 2: Top athletes in nobel-prized countries100 xp - 3
Cleaning & Validation
Although it would be nice, data in the real-world is rarely stored in an ideal way. Simply put: data can get messy. In chapter 3, you will learn how to deal with this messy data by fixing data type issues, cleaning messy strings, handling nulls, and removing duplication.
Converting data types50 xpIdentifying data types100 xpInterpreting error messages100 xpUsing date functions on strings100 xpCleaning strings50 xpString functions100 xpReplacing and removing substrings100 xpFixing incorrect groupings100 xpDealing with nulls50 xpFiltering out nulls100 xpFixing calculations with coalesce100 xpReport duplication50 xpIdentifying duplication100 xpFixing duplication through a JOIN100 xpReport 3: Countries with high medal rates100 xp - 4
Complex Calculations
The value of reporting really shows when presenting not-so-obvious insights through complex calculations. In this chapter, you will learn how to build more complicated fields by leveraging window functions and layered calculations. You will gain hands-on experience building two advanced calculations in particular: the percent of a total calculation and the performance index calculation.
Building complex calculations50 xpTesting out window functions100 xpAverage total country medals by region100 xpMost decorated athlete per region100 xpComparing groups50 xpVolume vs efficiency metrics50 xpPercent of gdp per country100 xpGDP per capita performance index100 xpComparing dates50 xpMonth-over-month comparison100 xpWeek-over-week comparison100 xpReport 4: Tallest athletes and % GDP by region100 xpCourse summary50 xp
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL para analistas de negócios
Ir para a trilhaconjuntos de dados
Course Database Entity Relationship DiagramCourse Database Creation CodeAthletesCountriesCountry StatsSummer GamesWinter Gamescolaboradores
pré-requisitos
Data Manipulation in SQLTyler Pernes
Ver MaisLearning & Development Consultant
O que os outros alunos têm a dizer?
Junte-se a mais de 15 milhões de alunos e comece Reporting in SQL hoje mesmo!
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.