--- title: "Create queries on your data" description: "The Analytics Manager allows you, thanks to a low-code approach, to prepare and centralize the queries matching your business KPIs" url: https://docs.ovhcloud.com/pl/guides/public-cloud/data-platform/getting-started-create-queries lang: pl lastUpdated: 2026-09-14 --- > For AI agents: the complete documentation index is available at https://docs.ovhcloud.com/pl/llms.txt, the full documentation bundle is available at https://docs.ovhcloud.com/pl/llms-full.txt. # Create queries on your data ## Objective The [Analytics Manager](https://docs.ovhcloud.com/pl/guides/public-cloud/data-platform/landing-page-analytics-manager.md) allows you, thanks to a **low-code approach**, to prepare and centralize the queries matching your business KPIs. This component constitutes the interface between your data scientist team and your application developer team. ## Pre-requisites Beforehand, you need to make sure all the previous steps of the Project are up and running. Your Lakehouse Manager schema was built properly and your workflow ran smoothly. In this tutorial, you will build your first queries. ![Pre-requisites — Homepage Analytics Manager](/images/public-cloud/data-platform/getting-started/app-init/picts/homepage-am.png) ## Build your first queries Now, you will create your first queries in order to make data ready for visualization: - _rides\_per\_month_ to understand the average number of rides each month. You'll use it to build your first graph. - _rides\_per\_cat\_temperature_ to understand the average number of rides depending on temperature. ### Create the first query Open **Queries** in the sidebar and then click on **New Query**. This will open the Query window where you can give your query a name, parametrize the data as well the scale, order the results and add filters. In this screen, you can also view the results of your queries with tables or charts. ![analytics manager](/images/public-cloud/data-platform/getting-started/app-init/picts/new-query.png) To begin with, name your query `rides_per_month`. Then start typing 'avg\_' in the **Data search bar** and click on the _avg\_rides\_per\_day\_per\_station_ attribute. ![Create the first query — New query2](/images/public-cloud/data-platform/getting-started/app-init/picts/new-query2.png) The compute mode is **select** by default, you can change it by clicking on the arrow and changing the selected options. For the purpose of this tutorial, leave it as it is by default here. ![Create the first query — New query3](/images/public-cloud/data-platform/getting-started/app-init/picts/new-query3.png) Then, click on the **Scale search bar**. Here, you want to display the average number of rides **each month** per date. Select _yearmonth_ as a scale. ![Create the first query — New query4](/images/public-cloud/data-platform/getting-started/app-init/picts/new-query4.png) Then, click on the green button **Run** to run the query. You'll see the result of the query at the bottom panel, by default it is on table view. You can change the display format: table, line chart, bar chart, area chart or pie chart. Choose by clicking on the buttons of the bottom panel (as indicated in the image below). ![Create the first query — New query5](/images/public-cloud/data-platform/getting-started/app-init/picts/new-query5.png) :::info When you build a query in the Analytics Manager, you don't have to specify the table names. The Platform will **automatically choose the most suitable table**. But you can still force a specific table by clicking the table icon next to _Data_. ::: [ Learn more about how the Analytics Manager works.](https://docs.ovhcloud.com/pl/guides/public-cloud/data-platform/analytics-manager-queries-visual-builder.md#choice-of-table) ### Create a second query Queries aren't meant to be used in a dashboard only, they also provide an easy environment to explore your data using an array of data visualization options. Create a new query: - Name it `rides_per_cat_temperature`. - Select _avg\_rides\_per\_day\_per\_station_ with compute mode **select**. - Select _cat\_temperature_ as your scale. - Select _avg\_rides\_per\_day\_per\_station_ as the **Order** (ascending order by default). :::warning If you remember, _avg\_rides\_per\_day\_per\_station_ is a virtual attribute you have set in a previous step of the tutorial (Collect data). You cannot use any other compute mode than **Select** with this virtual attribute as it contains an SQL aggregate function. Adding **Sum** as compute mode would end up imbricating two SQL aggregate functions, resulting in an error. ::: Just like the screenshot below, click on **bar chart icon** to automatically display the data as a bar chart. ![Create a second query — New query6](/images/public-cloud/data-platform/getting-started/app-init/picts/new-query6.png) You have created two queries in the Analytics Manager. The next step is to expose that data through an API, which you will create and deploy for use in your application. [Expose your data by deploying an API](https://docs.ovhcloud.com/pl/guides/public-cloud/data-platform/getting-started-expose-api.md) ## Go further If you need training or technical assistance to implement our solutions, contact your sales representative or click on [this link](https://www.ovhcloud.com/pl/professional-services/) to get a quote and ask our Professional Services experts for a custom analysis of your project. Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated [Discord channel](https://discord.gg/ovhcloud). If you need support with your OVHcloud services, create a request in our [Help Centre](https://help.ovhcloud.com/csm?id=csm_get_help). Join our [community of users](https://community.ovhcloud.com/).