ViSIT
ViSIT
  • 254
  • 734 692
Looker Studio: Sort Rows, Columns, and Axis in any order you want #sort #lookerstudio #dashboarding
This tutorial explains how to sort data in Looker Studio in a custom order, beyond the standard alphabetical or numerical sorting. Using a hypothetical bank loan portfolio dataset from a Google Sheet (link in description), the tutorial walks through creating a Looker Studio report, connecting to the Google Sheet data source, and setting up the dashboard with a title, logo, and various charts (pivot table, bar charts). The core of the tutorial focuses on creating custom sort orders for loan categories and customer credit history. Since these fields can't be sorted alphabetically or numerically into the desired order, the tutorial demonstrates adding two new columns to the Google Sheet: "category order" and "history order." These columns use VLOOKUP or a similar method to assign a numerical sequence to each category and history item, reflecting the desired custom order. After reconnecting the Looker Studio report to the updated Google Sheet, the tutorial shows how to use these new "order" columns in the chart and pivot table sort settings, ensuring the data is displayed precisely as intended. The tutorial concludes by emphasizing the importance of this technique for non-standard sorting needs and encourages viewers to like, subscribe, and hit the notification bell for more content.
docs.google.com/spreadsheets/d/1djhAQXTVtnio-GO4nqLy_HlCIgzac3D_iwzUjKJE2G4/edit?usp=sharing
lookerstudio.google.com/reporting/8ad023a5-553e-4050-8cbc-325a61ba13e0
#lookerstudio #datastudio #googlelooker #datavisualization #dashboarddesign #customsorting #datasorting #googlesheets #spreadsheet #vlookup #tutorial #learndata #dataanalysis #businessintelligence #bi #dataanalytics #reportdesign #charting #pivot table #bar chart #diydata
Переглядів: 21

Відео

Python: Leveraging AI to Build a SARIMA Model for Sales Forecasting in Python
Переглядів 5014 годин тому
This tutorial guides viewers through the process of predicting future sales using the SARIMA model in Python. It showcases the power of AI by utilizing Google Colab's built-in AI capabilities to generate the necessary Python code. Starting with data import from Google Sheets, the tutorial progresses to statistical analysis, including stationarity tests and time series decomposition. Subsequentl...
Power BI: Sending Power BI Data through Emails Using Power Automate
Переглядів 28419 годин тому
This tutorial demonstrates how to create a Power BI dashboard to monitor sales and profit data, and then automate the delivery of this data to top management via email using Power Automate. Key steps covered: Data Loading & Dashboard Creation: Importing Excel data into Power BI. Creating visuals (cards, line and column chart) to display key metrics. Power Automate Integration: Adding a Power Au...
Looker Studio: Building a Comprehensive Multi-Page Organizational Performance Dashboard
Переглядів 31214 днів тому
This video tutorial demonstrates how to create a multi-page report in Looker Studio, focusing on organizational performance. It covers data preparation, including unpivoting data in Excel and importing it into Google Sheets. The tutorial then guides viewers through creating a cover page, adding various charts and visuals, utilizing advanced filters and formatting, and applying themes to maintai...
Python Lesson 003: Mastering the Python Syntax
Переглядів 10328 днів тому
This Python tutorial provides a foundational overview of key concepts, including comments, variables, data types (integers, floats, strings, booleans, lists, tuples, dictionaries), operators (arithmetic, comparison, logical), and control flow (if-else, for, while). It explains how to use comments to enhance code readability and temporarily disable code, and how to work with different data types...
Complete Guide to the Looker Studio: Sharing Looker Studio Reports
Переглядів 124Місяць тому
This tutorial provides a comprehensive overview of sharing Looker Studio reports. It covers various sharing methods, including sharing with individuals and groups, using share links with different access levels (restricted, unlisted, public), and scheduling automated report deliveries. The tutorial also discusses report access settings, which allow for granular control over viewer permissions, ...
The DAX Text Detective: Find and Search Functions
Переглядів 98Місяць тому
This video compares and contrasts the DAX functions FIND and SEARCH, both used to locate substrings within a larger text string. While both return the position of the first occurrence of the substring, FIND is case-sensitive, meaning it will only find an exact match, including capitalization. In contrast, SEARCH is case-insensitive, making it more flexible. The video demonstrates how to use the...
Creating Custom Functions in Excel without using VBA: A Deep Dive into LAMBDA
Переглядів 116Місяць тому
Traditionally, custom functions in Excel were created using VBA, a programming language. However, Microsoft introduced the LAMBDA function in 2020, allowing users to create custom functions without coding. Inspired by lambda calculus, LAMBDA functions are defined with a name, parameters, and a formula. They can be used directly or named for future reference. By using descriptive parameter names...
Python Lesson 002: Communicating with Python using Print() and Input() Functions
Переглядів 65Місяць тому
Python offers a straightforward way to interact with the user through the print() and input() functions. The print() function displays information on the console, taking one or more arguments like strings, numbers, or variables. It can also be used to format output, write to files, and display results in real time. The input() function prompts the user for input, capturing it as a string. This ...
Python Lesson 001: Introduction, Installation, and Other Options
Переглядів 1282 місяці тому
This video provides a comprehensive introduction to Python, covering various aspects from installation to online usage and integration with Excel and Power BI. It highlights the versatility of Python, its applications in diverse fields, and the multiple ways to access and utilize it. The video also demonstrates basic Python code examples, such as variable assignment, arithmetic operations, and ...
Power Pivot Advanced Concepts - A Complete Guide to Power Pivot
Переглядів 4442 місяці тому
This tutorial provides a comprehensive overview of Power Pivot in Excel, covering topics such as data modeling, creating relationships, working with measures and KPIs, using OLAP tools, calculated columns, perspectives, and synonyms. It also demonstrates how to enable Power Pivot, connect to external data sources, and create pivot tables and charts. Additionally, the tutorial explains how to us...
SQL: Pivot and Unpivot Data in SQL Server Database Including Multiple Columns - A Step-By-Step Guide
Переглядів 4352 місяці тому
This tutorial provides a comprehensive guide to pivoting and unpivoting data within SQL Server. We'll delve into the process of transforming data from a row-based to a column-based format, and vice versa. You'll learn how to pivot data based on single or multiple columns, as well as how to unpivot pivoted data to restore its original structure. Through practical examples and step-by-step explan...
Power BI: Creating Business Intelligence Dashboards from SQL Server Tables and Views
Переглядів 6343 місяці тому
This tutorial demonstrates how to create a comprehensive Power BI report using data from a SQL Server database. We'll delve into various analytical techniques, including geographic analysis, branch-wise performance, and deposit movement. The report will feature interactive dashboards with visualizations like maps, charts, and tables. By the end, you'll be able to create insightful reports that ...
Analysing Data in SQL Server Database Using Views - Bank Accounts Analysis Example
Переглядів 3363 місяці тому
This video tutorial introduces SQL views and demonstrates how to create and use them for data analysis. It begins by explaining what views are and their purpose, then proceeds to use a hypothetical bank database, Nexus Bank, as an example. The tutorial covers creating tables, importing data from CSV files, and building various views to combine and analyze data from different tables. Topics incl...
Time Intelligence in Power BI: A Visual Guide
Переглядів 7613 місяці тому
Time Intelligence in Power BI: A Visual Guide
SQL Magic: Auto-Generating HTML Reports (With Google Charts and JavaScript)
Переглядів 4344 місяці тому
SQL Magic: Auto-Generating HTML Reports (With Google Charts and JavaScript)
Using Gemini for SQL Data Analysis: Impress people without knowing SQL
Переглядів 5094 місяці тому
Using Gemini for SQL Data Analysis: Impress people without knowing SQL
Using Dropdown Lists Effectively to Summarize Data and Build Dashboards and Reports in MS Excel
Переглядів 4894 місяці тому
Using Dropdown Lists Effectively to Summarize Data and Build Dashboards and Reports in MS Excel
Build a Stunning Animated Olympics Javelin Dashboard with Power BI
Переглядів 3535 місяців тому
Build a Stunning Animated Olympics Javelin Dashboard with Power BI
Analyse and Visualize Google Forms Responses using Power BI by Integrating Forms with Power BI
Переглядів 1,4 тис.6 місяців тому
Analyse and Visualize Google Forms Responses using Power BI by Integrating Forms with Power BI
Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server
Переглядів 1,3 тис.6 місяців тому
Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server
Real time Monitoring with Power BI and SQL
Переглядів 1,4 тис.7 місяців тому
Real time Monitoring with Power BI and SQL
Creating and Using Flow Maps in Power BI with Free Dataset
Переглядів 2,1 тис.7 місяців тому
Creating and Using Flow Maps in Power BI with Free Dataset
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Переглядів 1,4 тис.7 місяців тому
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Переглядів 3467 місяців тому
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Переглядів 4318 місяців тому
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Переглядів 7 тис.8 місяців тому
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Diversity, Equity, and Inclusion (DEI) Initiative Tracker Using RAG Status - Project Management
Переглядів 8028 місяців тому
Diversity, Equity, and Inclusion (DEI) Initiative Tracker Using RAG Status - Project Management
Complete Guide to Using Drawing Tools in MS Excel #tutorial #drawingtools #excel #howto #learn
Переглядів 4578 місяців тому
Complete Guide to Using Drawing Tools in MS Excel #tutorial #drawingtools #excel #howto #learn
Gantt Chart in Power BI: Complete Guide #tutorial #ganttchart #powerbi #projectmanagement
Переглядів 14 тис.8 місяців тому
Gantt Chart in Power BI: Complete Guide #tutorial #ganttchart #powerbi #projectmanagement

КОМЕНТАРІ

  • @Copolie
    @Copolie 13 годин тому

    how do you do this on linux? i been searching for 2 hours on how to conenct workbench to looker..

    • @virtual_school
      @virtual_school 7 годин тому

      I am sorry. We dont use Linux here. Only Windows.

  • @Yz40000
    @Yz40000 День тому

    Hi, how to show multiple assignees

  • @andres777video
    @andres777video 2 дні тому

    Good easy to follow video - Thanks! On mine I will add an option to refresh or not refresh, in case people want to print or take screenshots. I assume this readings are for the server where the python code is running from (I personally would compile it with py2exe to run a Exe on the server and be immune to changes on python libraries in the future) Also will add code in python to only keep 2-3 days worth of data to keep the database lean, and an option in PBI to select if user wants to see data back in time!, options like these can be a parameters in a file outside the python but that it can read, plus users can modify those parameters directly if they are scared of python :) been a Power BI Admin ( for 6 years) - All your comments are great!

  • @kareemgates1895
    @kareemgates1895 3 дні тому

    XPath has always confused me, but this walkthrough makes it seem doable. Anyone else prefer using HasData for scraping on different platforms?

  • @emerson_mora
    @emerson_mora 3 дні тому

    Thank you for this video. The best I have watched so far regarding data blends.

  • @virtual_school
    @virtual_school 6 днів тому

    Google Sheets: docs.google.com/spreadsheets/d/1Vphx5JGhDGR9YP4Zh69r4Hb3fHAY2_fG4loylzCVhBs/edit?usp=sharing Google Colab Notebook: colab.research.google.com/drive/1ba4Ef0fUeiP5UI0mRsyQo-PhMjn4l7_H?usp=sharing

  • @satorugojo4894
    @satorugojo4894 10 днів тому

    thanks

  • @seyiabayomi
    @seyiabayomi 13 днів тому

    Why was direct query used instead of import?

    • @virtual_school
      @virtual_school 13 днів тому

      Because this let's you automatically update the dashboard as per defined interval. Ecommerce based reports are not annual or monthly reports. You may want to observe changes several time a day, and with direct query you can do that. Otherwise you can select import as well. It is just matter of choice and requirement.

  • @mnir007
    @mnir007 14 днів тому

    you can skip the first 3 minutes. they are very unnecessary

    • @virtual_school
      @virtual_school 8 днів тому

      So, if someone does not know how to cennect to a data source, and get data into the report, how would they do it without watching the first three minutes?

  • @alielsheikh8091
    @alielsheikh8091 15 днів тому

    More than perfect, just please show your mouse cursor for upcoming videos, keep this good work up. Thanks

  • @virtual_school
    @virtual_school 15 днів тому

    Link to the report/dashboard and dataset: virtual-school.org/looker-studio-building-a-comprehensive-multi-page-organizational-performance-dashboard/

  • @nandasetiawan3562
    @nandasetiawan3562 17 днів тому

    Amazing video What algorithm that used for the forecasting?

    • @virtual_school
      @virtual_school 16 днів тому

      Power BI primarily uses Exponential Smoothing (ETS) algorithms for forecasting when drawing a forecast line (ETS AAA/AAN). These algorithms work by creating a weighted average of past observations, giving more weight to recent data points. The weights are determined by smoothing parameters that are automatically optimized by Power BI to minimize forecasting errors within the training data. Seasonality is ignored when it has no or very little impact on future prediction of data.

    • @nandasetiawan3562
      @nandasetiawan3562 16 днів тому

      Woah thanks a lot❤ Its really help

  • @sairajesh9936
    @sairajesh9936 17 днів тому

    But its getting like butter&eggs&apple is there any way to show the grouping values vertically like single valued

  • @everywwswe
    @everywwswe 18 днів тому

    Once i click the web portal url, they ask me to put in username and password to sign in. I followed everything same as your video using Express version. How to fix that?

    • @virtual_school
      @virtual_school 18 днів тому

      Create user name and password in lusrmgr.msc and then add that user name to yout report server.

    • @everywwswe
      @everywwswe 18 днів тому

      @@virtual_school how to add to report server? also is this related to some office AD restriction since i installed in local office laptop.

    • @virtual_school
      @virtual_school 18 днів тому

      @everywwswe goto start run and enter lusrmgr.msc. if local users and groups window appears and lets you add users and groups, then ok, otherwise you nay be restricted.

    • @virtual_school
      @virtual_school 18 днів тому

      Once you have created user, click on manage folder on top right corner of report server and then click on add group or user button.

  • @ishaqafghan2093
    @ishaqafghan2093 20 днів тому

    Great Video but where is the link

  • @azadazmi7810
    @azadazmi7810 21 день тому

    my status is not showed up complete and not complete

  • @HJ-yb1rg
    @HJ-yb1rg 27 днів тому

    thank you very much... i am using power bi pro version.. i have created a dashboard using APIs of SAP. Now i want to share it on my local intranet of organisation. Is it possible.

    • @virtual_school
      @virtual_school 24 дні тому

      Yes you can. You can embed it on any page of your organization. I am assuming it is on BI service right?

    • @HJ-yb1rg
      @HJ-yb1rg 23 дні тому

      @virtual_school is there any way that I can contact you i need help in this project

  • @birdywen8608
    @birdywen8608 29 днів тому

    Your videos are always great and they are my must-sees

    • @virtual_school
      @virtual_school 28 днів тому

      That is very kind of you. I try my best.

  • @virtual_school
    @virtual_school Місяць тому

    View the embedded report here: virtual-school.org/complete-guide-to-the-looker-studio-sharing-looker-studio-reports/

  • @virtual_school
    @virtual_school Місяць тому

    Official Page: virtual-school.org/topics/data-analysis-expression-dax/the-dax-text-detective-find-and-search-functions/

  • @lascaduBR
    @lascaduBR Місяць тому

    you can't train and test with the same data... this results in data leakage and spurious results.

  • @reggieledoux7983
    @reggieledoux7983 Місяць тому

    Hello, how to expand Parent and Task column?

  • @RajarshiKallaagunta
    @RajarshiKallaagunta Місяць тому

    with out autorefresh is that we can schedule refresh in the direct query mode

    • @virtual_school
      @virtual_school Місяць тому

      Microsoft has removed support for various real time methods for power bi. And in power bi desktop, autorefresh is the best method their is. Alternate methods require other applications, and they are not as simple and efficient.

  • @mujibulhaque4914
    @mujibulhaque4914 2 місяці тому

    I am from Bangladesh and a 70 years old retired designer as well as an artist And thinking to start learning animation video. Its a very helpful tutorial for the beginner. I generally use hand drawing, illustrator, Photoshop, krita etc. for my design & painting. Thank you very much for your nice tutorial.

  • @Albert_Taban
    @Albert_Taban 2 місяці тому

    Why the auto refresh is not displaying?

    • @virtual_school
      @virtual_school 2 місяці тому

      Are you sure you chose DirectQuery and not Import?

    • @Albert_Taban
      @Albert_Taban 2 місяці тому

      I created a template.xlam path directory Microsoft>AddIns, the template.xlam is already have vba code. And I already check the template

    • @Albert_Taban
      @Albert_Taban 2 місяці тому

      I tried to add the realtime_updater from you google drive and copied into the AddIns folder, when I add as an addins it says "This file type is not supported in Protected Vie"

    • @virtual_school
      @virtual_school 2 місяці тому

      @@Albert_Taban Sorry, plz ignore my previous reply, let me look into it.

    • @Albert_Taban
      @Albert_Taban 2 місяці тому

      @@virtual_school okay sir/ma'am thank you for your guidance.

  • @Wild_Creations
    @Wild_Creations 2 місяці тому

    My power Bi formate not understanding the comman "Timestamp".

  • @virtual_school
    @virtual_school 2 місяці тому

    As identified by @sapelko80, discount (at ua-cam.com/video/GivV2lBkXYA/v-deo.html) is in percentage but wrongly formatted as currency. Please treat it as percentage. The formatting has no affect on the calculation. Answer will be same in any case.

  • @sapelko80
    @sapelko80 2 місяці тому

    Great video. At 11.00 it's slightly confusing that Discount has been formatted as Currency but then treated as a Percentage.

    • @virtual_school
      @virtual_school 2 місяці тому

      Thanks for your worthy feedback. And good catch by the way. Discount is actually in percentage, but I wrongly formatted the column as currency. Although has no affect on end result.

  • @carltonseymour869
    @carltonseymour869 2 місяці тому

    How does one show percent complete at the parent level?

    • @virtual_school
      @virtual_school 2 місяці тому

      By parent you mean group (which in this tutorial is project name)? when you collapse children, the percentage of group is created. It is derived from children.

    • @carltonseymour869
      @carltonseymour869 2 місяці тому

      @@virtual_school yes, but the % is not showing up in the parent level in Power BI using the Microsoft Gantt Chart

    • @virtual_school
      @virtual_school 2 місяці тому

      @@carltonseymour869 Unfortunately this visual does not have that option for parent. Parent is meant for grouping and organizing only in this visual.

  • @virtual_school
    @virtual_school 2 місяці тому

    Link to the excel file: docs.google.com/spreadsheets/d/1Tx0AFbIfbp2EI0mdfKfxRIeOG1xH6hNp/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true

  • @KADAPADHANUNJAY
    @KADAPADHANUNJAY 2 місяці тому

    can u plz send me the data what which you are applied

    • @virtual_school
      @virtual_school 2 місяці тому

      Data is available in online sql server as mentioned here: ua-cam.com/video/1OxFtV-SKKo/v-deo.html

  • @benpienaar2310
    @benpienaar2310 2 місяці тому

    I am having some serious issues with the date format that is in your spreadsheet. It keeps transforming in the completely wrong format in BI. Please advise

  • @Ola-iu6zc
    @Ola-iu6zc 2 місяці тому

    Thanks for this. Please how can I find my username and password to access the report from another device?

  • @jamesm.sumojr8486
    @jamesm.sumojr8486 2 місяці тому

    Your Video hub is of knowledge and it take my experience to another level.

  • @ck2610
    @ck2610 2 місяці тому

    does it needs a seperate time table in the model ?

    • @virtual_school
      @virtual_school 2 місяці тому

      You have to tell the chart when a task is starting and when it is ending.

  • @bharaths5906
    @bharaths5906 2 місяці тому

    Hey, hope you are doing well. I am building a report in power bi for which my source is from SQL. I had joined two tables and did some transformations in SQL itself. Now i am having a derived table from the exiting tables. I need to connect this cleaned table to power bi. Can i create a view for the transformed table and connect to power bi. If yes, will the views table get updated if the underlying tables are being updated. Kindly help I created a view and connected it to power bi, but want to know if there are any other ways.

    • @virtual_school
      @virtual_school 2 місяці тому

      Views work just as tables. Any data updated in tables, will automatically be updated in views, and subsiquently in your power bi dashboard. (You have to refresh if using import, otherwise it will update automatically if using direct query).

    • @bharaths5906
      @bharaths5906 2 місяці тому

      @virtual_school That's great. Thanks for the reply

  • @1ndin414
    @1ndin414 2 місяці тому

    Thank you so much

  • @virtual_school
    @virtual_school 3 місяці тому

    Link to the dataset: docs.google.com/spreadsheets/d/1lzMWDdQNZq9WREZSRjxiXRHaxFpeItvE/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true

  • @akhtarjavaid6183
    @akhtarjavaid6183 3 місяці тому

    Where is the data file (excel ) that u import to power Bi..?

    • @virtual_school
      @virtual_school 3 місяці тому

      ua-cam.com/users/redirect?event=video_description&redir_token=QUFFLUhqa25GVGdldlU5VlhvNTBuN08xNGNmRE5lVkxtUXxBQ3Jtc0ttUGd5ai1hZkY5aVRrdGEySTVWdGhnMWZ5OEE3TzE5YmRONFpZNjhVMXhvQ2Z0aVpsTjRLX3BQOE1IUFA4emJvY09uUHNPVDNnVk9ZTEhQRTUwbHgzVURMNEFFd1IwVTNJODg5b25CUDZ6V1M3SVU2VQ&q=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1RnC45-pz-R-oRV3AjVyNU11bPlZwqj5g%2Fedit%3Fusp%3Dshare_link%26ouid%3D110287700425339553017%26rtpof%3Dtrue%26sd%3Dtrue&v=duvQJEH1Als

  • @arsalraza3997
    @arsalraza3997 3 місяці тому

    Thanks for the detailed video.

  • @virtual_school
    @virtual_school 3 місяці тому

    Link to the SQL server database, Power BI file, and Custom Visual used in the tutorial: drive.google.com/file/d/1Ewxf714AsZzeIhK9AZsCVEPLaSS8skmX/view?usp=sharing Previous Video related to this one: ua-cam.com/video/7O9dHPGd_CM/v-deo.html

  • @betagav
    @betagav 3 місяці тому

    Just what've spent the last 2 days trying to find! Thank you.

  • @productreviews-q7p
    @productreviews-q7p 3 місяці тому

    Python code is not working please help me out

  • @anisnajwa1640
    @anisnajwa1640 3 місяці тому

    Hi sir. I am not understand at minute 7:15, what do you mean for "but you can get one from online store as well" ?

    • @virtual_school
      @virtual_school 3 місяці тому

      You can get all Power BI custom visuals from Microsoft Store which is online.

    • @jerrygault6860
      @jerrygault6860 3 місяці тому

      @@anisnajwa1640 There is a free Microsoft Gantt chart available, or you can buy one of many.

  • @aghanawazan
    @aghanawazan 3 місяці тому

    Thanks but It works with only desktop, what about after publishing the report. we need to connect with gateway and schedule to refresh the data.

    • @virtual_school
      @virtual_school 2 місяці тому

      Power BI is going through major changes. They have removed realtime support on power bi service. It was expected, therefore I never used one of those in my tutorials. powerbi.microsoft.com/en-us/blog/announcing-the-retirement-of-real-time-streaming-in-power-bi/

  • @sumitbhadrecha8211
    @sumitbhadrecha8211 3 місяці тому

    it is not working. Can you help me.

    • @virtual_school
      @virtual_school 2 місяці тому

      Do you have the latest version of excel? 365?

  • @Naruto-td7oo
    @Naruto-td7oo 3 місяці тому

    For those that are wondering why they just can't find the 3D map button, Microsoft moved it to another location: It is now in Data -> Data tools (Sub-category) -> Manage Data Model (Little green icon) -> 3D maps.

    • @virtual_school
      @virtual_school 3 місяці тому

      Good catch. Data -> Data Tools -> Data Model -> 3D Maps