Hello Welcome to This Reporting in Sequel Course

My name is Tyler, and I'll be your instructor for this course. This course aims to strengthen your Seigle skills specifically for reporting. But what do I mean when I say "reporting" for? Putting it simply, the act of presenting data in any shape or form can be in the form of a table, a visualization, or simply a number. So, who actually uses reporting well? Reporting is used by a wide array of individuals in business settings. For example, you may be a data scientist who must polar ports to answer business questions, or perhaps you are a data visualization specialist looking to build robust visualizations using your tool of choice, whether that is Python, Excel, or Tableau, or maybe you are a software developer looking to add dynamic values to a page on your website, regardless of the situation. Reporting always starts with gathering the data. If that data is stored in a database, you're likely be using Secor to pull it.

This course aims to provide you with the ins and outs of using Postgres to pull reports in a variety of ways. By the end of this course, you will know how to create real-world reports using real-world data by overcoming real-world obstacles. To give you this taste of reality, this course is centered around a case study. You just got hired as a data scientist for the up-incoming sports marketing company, Data Bollocks. The company has recently been asked to market perhaps the largest global sports event in the world, to the Olympics. This is clearly a huge opportunity for the company. However, beer company has never been involved in global events and is unsure about how to move forward. Luckily, the stakeholders have already put together a mock-up of a dashboard, they are looking for you to create a dashboard, which is a collection of reports or visualizations aimed at answering specific questions.

Here's an example dashboard in this case related to a soccer tournament. Each element in the dashboard is derived from what we call a base report. A base report is the underlying report that sources a visualization. We use a sequel statement to build this base report, for example, the bar on the right is our visualization which shows winds by country, ordered by winds and only keeps three rows. This visualization references the data from the base report shown on the Left, which we can get using this sequel statement. The query "poisoned country in winds from the game wrong table" outputs a country that wins in descending order and keeps only the top three rows. Here is the dashboard your executive team has asked you to build during this course. Each chapter will revolve around building one of these elements, since this course is focused purely on reporting and not visualization, we will only focus on building the base report for each element.

Enough talking! Let's get to it and start

"WEBVTTKind: captionsLanguage: enhello welcome to this reporting in sequel course my name is Tyler and I'll be your instructor this course aims to strengthen your Seigle skills specifically for reporting but what do I mean when I say reporting for putting is the act of presenting data in any shape or form this can be in the form of a table a visualization or simply a number so who actually uses reporting well reporting is used by a ride array of individuals in business settings for example you may be a data scientist who must polar ports to answer business questions or perhaps you are a data visualization specialist looking to build robust visualizations using your tool of choice whether that is our Python Excel or tableau or maybe you are a software developer looking to add dynamic values to a page on your website regardless of the situation reporting always starts the same way by gathering the data if that data is stored in a database you're likely be using Secor to pull it this course aims to provide you the ins and outs of using Postgres to pull reports in a variety of ways by the end of this course you will know how to create real world reports using real world data by overcoming real-world obstacles to give you this taste of reality this course is centered around a case study here's the case study you'll be working on you just got hired as a data scientist for the up incoming sports marketing company data bollocks the company has recently been asked to market perhaps the largest global sports event in the world to the Olympics this is clearly a huge opportunity for the company beer company has never been involved in global events unsure about how to move forward the executive team has asked you for guidance luckily the stakeholders already put together a mock-up of a dashboard they are looking for you to create a dashboard is a collection of reports or visualizations aimed to answer specific questions here's an example dashboard in this case related to a soccer tournament each element in the dashboard is derived from what we call a base report a base report is the underlying report that sources a visualization we use a sequel statement to build this base report for example the bar on the right is our visualization which shows winds by country is ordered by winds and only keeps three rows this visualization references the data from the base report shown on the Left which we can get using this sequel statement this query poisoned country in winds from the game wrong table the output is ordered by winds in descending order and keeps only the top three rows here is the dashboard your executive team has asked you to build during this course each chapter will revolve around building one of these elements since this course is focused purely on reporting and not visualization we will only focus on building the base report for each element enough talking let's get to it and starthello welcome to this reporting in sequel course my name is Tyler and I'll be your instructor this course aims to strengthen your Seigle skills specifically for reporting but what do I mean when I say reporting for putting is the act of presenting data in any shape or form this can be in the form of a table a visualization or simply a number so who actually uses reporting well reporting is used by a ride array of individuals in business settings for example you may be a data scientist who must polar ports to answer business questions or perhaps you are a data visualization specialist looking to build robust visualizations using your tool of choice whether that is our Python Excel or tableau or maybe you are a software developer looking to add dynamic values to a page on your website regardless of the situation reporting always starts the same way by gathering the data if that data is stored in a database you're likely be using Secor to pull it this course aims to provide you the ins and outs of using Postgres to pull reports in a variety of ways by the end of this course you will know how to create real world reports using real world data by overcoming real-world obstacles to give you this taste of reality this course is centered around a case study here's the case study you'll be working on you just got hired as a data scientist for the up incoming sports marketing company data bollocks the company has recently been asked to market perhaps the largest global sports event in the world to the Olympics this is clearly a huge opportunity for the company beer company has never been involved in global events unsure about how to move forward the executive team has asked you for guidance luckily the stakeholders already put together a mock-up of a dashboard they are looking for you to create a dashboard is a collection of reports or visualizations aimed to answer specific questions here's an example dashboard in this case related to a soccer tournament each element in the dashboard is derived from what we call a base report a base report is the underlying report that sources a visualization we use a sequel statement to build this base report for example the bar on the right is our visualization which shows winds by country is ordered by winds and only keeps three rows this visualization references the data from the base report shown on the Left which we can get using this sequel statement this query poisoned country in winds from the game wrong table the output is ordered by winds in descending order and keeps only the top three rows here is the dashboard your executive team has asked you to build during this course each chapter will revolve around building one of these elements since this course is focused purely on reporting and not visualization we will only focus on building the base report for each element enough talking let's get to it and start\n"