CONTENTS BookOverviewandAdditionalResources vi 1. MicroStrategy Intelligent Enterprise™ Platform Help. Obj. Every request sent to MicroStrategy Web calls a central controller. The word, Apache, has been taken from the name of the Native American tribe ‘ Apache’, famous for its skills in warfare and strategy making. It is a. To Create a New Database Connection. Expand the Public Objects folder, then expand the Reports folder. For steps, see Starting MicroStrategy Developer. Open MicroStrategy Web in a Web browser. 3. This is easily done using the &hiddensections URL parameter that can be obtained from the folder browsing page. For JSP: <install directory>MicroStrategyWSprojectsources. mstrc) in Workstation. The custom log-in page should be displayed. Interestingly, it also shows the icons of data sources for quicker identification of data. After setting up and configuring the Web Customization Editor in Eclipse, you'll have access to the Java Web APIs provided through the MicroStrategy Web SDK. Use the Objects section to search for the desired metrics and attributes and drag them into the Editor panel. The MicroStrategy REST API Explorer serves as the REST API reference guide. INTERVAL allows either YEAR and MONTH to be mixed together or DAY, HOUR, MINUTE and SECOND. 2. import. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. The reflection layer wraps the actual exception thrown by the method with the InvocationTargetException. As a Business User, you are consistently focused on evaluating, understanding, and optimizing the operations of your area of ownership, which could be a retail store, a hospital, a scrum team, or any other structured area of an enterprise. Published: Dec 28, 2017. To start the Express installation. MicroStrategy Web communicates with Intelligence Server through the API. Parameters are appended to Main. MicroStrategy courses can be tailored to developers, analysts, and. xml file. MicroStrategy Tutorial data model. For example, the YR_CATEGORY_SLS table includes the attributes Year and Category, along with facts such as Revenue, Cost, Profit, and so on. Parameters are appended to Main. The Java XML API log will record all the XML communications between Intelligence Server and Web. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. AngularJS Routing with Parameters — Single Page Application Example. Use the appropriate procedure below to view a report’s filtering information in MicroStrategy Desktop or MicroStrategy Web. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. In the Object Browser on the left, click Schema Objects to open the Schema Objects folder. Workstation is the only space for analysts and app architects to build and manage content of all types. Pathways. This Microstrategy 10 training video explains the basics of Microstrategy, what is Microstrategy along with a hands-on Microstrategy session. Exploring the MicroStrategy Tutorial schema. 3. Click within the Dataset Objects area to add datasets for the document. Setting. For a complete introduction to documents, with images, examples, and tutorials, see the Document Creation Help. The current version of MicroStrategy Tutorial is designed using the MicroStrategy URL API with JSP framework, therefore MicroStrategy ASP is not supported for the redesigned Tutorial project. From the Categories list, expand Database Instances, and then select SQL Data Warehouses. PHP MVC Framework Tutorial — CodeIgniter Example. Browsers are programs that you run on your computer. Here data display in Grid visualization format. The course introduces the many features that enable you to create sophisticated, boardroom-quality documents. . The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Follow the steps described below: ACTION . 4 the connection mapping of the u… Number of Views 1. Read MoreHigh Level Design (HLD) is a general system design and includes the description of the System architecture and design. AngularJS Events — ng-click, ng-show, ng-hide Directive [Example] 👉 Lesson 3. 2048001 - executeRWDocument. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. Tutorials Choose your MicroStrategy version: New in MicroStrategy 2021 HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. Log in to the MicroStrategy Tutorial sample project. Step 5) Select if it’s an outgoing or incoming call. . MicroStrategy online help and PDF manuals (available both online and in. 1 Developer and Web when non-administrative users try to execute a prompted document. NET) programming. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. WWW can be defined as the collection of different websites around the world, containing different information shared via local servers (or computers). To prevent users from navigating out of the document, they might want to hide some sections from the page. The Rename/Edit Objects dialog box (DHTML) or panel (HTML) is displayed. mstr file below and deploy it in MicroStrategy Desktop or MicroStrategy Web. xml file located in the WEB-INF folder of the MicroStrategy Web installation directory. Dossiers. The username and password for all three are the same. Connect to your data instantly Pull live data from the cloud, files, and databases into one secure place — without installing anything, ever. CONTENTS 1. Click Add to Chrome and Add Extension. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Click on “New Data” to add data from your available sources. In MicroStrategy Web, log in to the MicroStrategy Tutorial project, click the MicroStrategy icon and select New Report. 99. xml. This standalone server has been deprecated, but the “JSON Data API” and “Data Push API” are now part of the MicroStrategy REST Server, which is shipped inside the MicroStrategyLibrary. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and. When prompted for a user name and password, use the same values you specified in the tomcat-users. 4196 views · September 04, 2020. •Command Manager - Performs various administrative and application development tasks by using text commands that can be save as script. 02:13. Transformations are schema objects and therefore only a project designer with Create schema object privileges can create them. Our experts will explore popular use cases that streamline and automate your workflows—with minimal coding experience required. Choose File > New > Intelligent Cube. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. MicroStrategy provides numerous prebuilt transformations, although you can create your own as needed. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. In the Project Source Name field, type a name for the project source. Your Story. It includes a detailed demonstration of various MicroStrategy reporting features including how to filter the report documents, print the documents, view the source data and export to Excel, use. Log in with valid MicroStrategy user credentials. Learn how to create a simple Visual Insight Dashboard in MicroStrategy Web. 36K subscribers Subscribe 15K views 6 years ago MicroStrategy. Power Pivot: It is used for data modeling for in-memory analytics. This audio-visual tutorial provides an overview of MicroStrategy and how to use the new Finance “web reports”. The programming tools provided by the MicroStrategy SDK— including programming. For example, if you take the case of a web shopping application, data such as the price of an item would be stored in the database. This is an no question simple means to specifically get guide by on-line. All articles. MicroStrategy Tutorial. With the diverse range of courses, Training M. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more. Use your logical model and structure of business data to construct a project. 👉 Lesson 1. MicroStrategy Administration •With system Manager – Combine multiple processes for MSTR environment into single work flow that can be deployed at a scheduled time or on Demand. Using the URL API, there are three ways for MicroStrategy Web to obtain the information needed to authenticate a user. . MicroStrategy Tutorial PDF Version Quick Guide MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. 3. Bitcoin Strategy. In MicroStrategy Developer, from the File menu, select New, and then choose Report. 6. To build an Intelligent Cube. Standard (user name & password) LDAP Authentication. . The fuel for business dashboards is data, so each one needs to have one or more data sources. Reports. It mainly occurs when we work with the reflection layer and try to invoke a method or constructor that throws an underlying exception itself. aspx or mstrWeb (in a . From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a User Name and Password. User nameAngularJS Fundamentals Step by Step. Your First PHP project! 👉 Lesson 1. Use. For this, it uses a relational OLAP architecture. Options to create reports from MicroStrategy Web or Developer focusing on a particular analysis area, such as Customer, Inventory. Accordingly, this topic focuses on how to use transformations in metrics and reports, and provides only an overview. exe. One of the most popular MicroStrategy courses on Udemy is this Business Intelligence with MicroStrategy 10 Analytics course. Once data flows into the interface, the dashboard will come to life. com : Donate if my videos helps. A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. It wraps MicroStrategy REST APIs into simple workflows, allowing users to connect to their MicroStrategy environment, fetch data. 👉 Lesson 3. Types of Computer Networks — LAN, MAN, WAN, VPN. To see sample dashboards in Developer. For this, it uses a relational OLAP architecture. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making. Notice that Windows Authentication is now enabled for login to the MicroStrategy Tutorial project. blogspot. Jobs and TasksSpecifying Warehouse Connection Information. 2. The Allow navigation above the search root check box is available for: Object prompts with the Shopping Cart. 3. MicroStrategy Creating Filters - Filtering data is a very important part of data analysis and visualization. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy. In MicroStrategy Web, a user clicks an object to drill to the next level. 2. aspx or mstrWeb (in a . Setting MicroStrategy Web to use SSL encryption between MicroStrategy Web and the MicroStrategy Intelligence Server. Introduction to Dossiers. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (- runReport Executes the report specified by either the reportID or reportName argument. A logical data model graphically depicts the flow and structure of data in a business environment. Windows: On your desktop, from the Start menu, select Programs (or All Programs ), then MicroStrategy Tools, then Web. The following diagram shows an overall architecture of MicroStrategy platform describing how it accesses data from various sources using the metadata. x, on Web Administrator page, it is possible to specify the Path to MicroStrategy Office Installation, as shown below: In certain situation, when user tries to clear this text box or set "Lang_xxxx/officeinstall. 2) The Total is added to the top of the grid. exe. In MicroStrategy Web, log in to the Tutorial project. There are Power BI components are 5 main components released in the market. In Part 2, our product specialists will demonstrate how to successfully set up and configure URL APIs for MicroStrategy Web, and address tips and tricks for avoiding pitfalls and troubleshooting common issues. You are focused on making sure these data sources are available in MicroStrategy, as well as defining their data structures and relationships for advanced data queries. Experience how MicroStrategy empowers users via HyperIntelligence, Mobile Analytics, Dashboards & Dossiers, Visualizations, Geospatial Analytics, and Enterprise Reporting. CSS Tutorial. A sales team might use a business dashboard to connect. Note that the option to Create a Document in MicroStrategy Web from an iCube it is also available. Our free software testing tutorial & syllabus for beginners covers from basics to advanced automation or manual testing concepts. Parsing Cross-Tabbed Data (Importing) Using Free-Form Layout in Dossier Authoring. After the card has been created, steps are included to certify the card, allowing it to be shared with other users. 👉 Lesson 2. If you are deploying MicroStrategy Web (JSP), the MicroStrategy Web Administrator page appears. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Type the Name for the object and click OK to save your changes. Hugh's dedication to MicroStrategy has helped enhance both the user experience of and cross-integration between MicroStrategy Education and MicroStrategy Community. These fixes address performance (2), security (3), and stability (12), among other issues. 2. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. Download the PDF manual and get started with MicroStrategy Office today. Alternatively, you can locate and run Setup. In general, this means that users should have the Execute permission for any reports they are subscribed to, and for any objects contained in those reports. In this free ethical hacking course, you will learn all about Ethical hacking lessons with loads of live hacking examples to make the subject matter clear. How to Access the Web Administrator Page. Type the following and hit enter: microstrategy. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. x - 9. Websites are a bunch of files stored on computers called servers. Open MicroStrategy Web in a Web browser and click the link for MicroStrategy Tutorial. MicroStrategy Web can be considered as most websites, composed of the following: HTML, giving each page structure. The Embedding SDK allows you to quickly integrate a MicroStrategy dossier into a web application in a responsive manner. To use MicroStrategy for data visualization, you must first sign up for an account and select a cloud service provider, such as Amazon Web Services (AWS) or Microsoft Azure. 2. LOGIN? x. KB31601: How to bypass login page after configuring Single Sign On with Windows Authentication in MicroStrategy Web 10. The evt parameter in the URL ( evt is short for “event”) specifies that event. x for MicroStrategy Web, Mobile or Office 9. As a suite of. KB288847: How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platfo…. Mobile Platform The existing visualizations, reports, and dashboards are. 👉 Lesson 4. pageName. In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you learn this top Business Intelligence tool. The World Wide Web is abbreviated as WWW and is commonly known as the web. MicroStrategy interfaces include desktop (for developers), web, Microsoft Office integration as well as Mobile Applications. Exporting to Microsoft Excel 20xx with formatting from MicroStrategy Web. Open the googleConfig. MicroStrategy is a global leader in business intelligence technology. The examples are based on data from the MicroStrategy Tutorial. Learn more. 2. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Because the ID of the event associated with the "RW Fast Export PDF" page is "3069", the evt parameter in the URL is set to "3069". To start MicroStrategy Web: 1 In a browser, enter the URL of your company’s MicroStrategy Web site. LOGIN? User name. Our tutorial videos are uniquely crafted to help you learn the ins and outs of MicroStrategy based on your role and tips and tricks to help grow your Intelligent Enterprise. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. For example, a simple logical data model for a retail company can organize all necessary facts by store. MicroStrategy Architect provides an intuitive way to explore the MicroStrategy Tutorial schema. x can be set in two different locations: Access the MicroStrategy Web Admin page > Default properties > Login, like shown below: Log into a project through MicroStrategy Web > Preferences > Project defaults > Security, like shown below. x** Web manage document datasets: add datasets to and remove datasets from a Report Services document (Note: User must have Web document design privilege as well. 1 : If you are not already using the MicroStrategy Tutorial,. On the Customer Information page, complete the following fields: Tutorials Choose your MicroStrategy version: New in MicroStrategy 2021 HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications. It can connect to data warehouses, relational systems, flat files, web. The table below shows the URL parameters used to execute a document using the URL API. documentation for integrating MicroStrategy Web with other enterprise portals. This enterprise analytics tool works seamlessly across web-based content, mobile devices, and Microsoft Outlook to bring answers to people through relevant, context-based analytics. Reports and documents are the objects that. You could not unaccompanied going as soon as books amassing or library or borrowing from your connections to door them. Password. The MicroStrategy Project Design Guide provides comprehensive information on planning, creating, and modifying a project in MicroStrategy and covers a wide range of project-related topics, including the following: BI Architecture and the MicroStrategy Platform, provides an introduction to business intelligence architecture and some of the. Right-click the newly added selector in the list and click "New Property". to open the Shared Reports folder of theMicroStrategy Office is a comprehensive guide that covers how to use the MicroStrategy platform with Microsoft Office applications. To access the cards, connect to the proper. In this tutorial, you'll learn how to execute standalone Java using the MicroStrategy Web SDK. Video Tutorial - Installing the Web Customization Editor plugin for the MicroStrategy Web SDK. app’ to. Workstation is the only space for analysts and app architects to build and manage content of all types. Software Testing Tutorial - Software testing helps to identify errors, gaps or missing requirements. Detailed instructions for deploying MicroStrategy Web with the JSP front-end are included in the Installation and Configuration Help. MicroStrategy Desktop provides a variety of options to filter data in a report. . For the purpose of this example, the Microstrategy Tutorial Data Warehouse that resides in. A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. Playlist:1) Add totals to your grid by clicking the context menu in the attribute header, choosing Show Totals, checking the Total box and clicking OK. The same configuration can also be applied for shapes and images. The MicroStrategy Tutorial is an interactive product demonstration designed to showcase the rich functionality of MicroStrategy ONE. Build your best work with D3 on Observable. It is used to define the functionality or a design of a system. React is a JavaScript library for building user interfaces. Using Access Control Lists. css and click "New Selector". In the Navigation pane, click , next to Datasets. Bypassing the login page by providing the session state in the URL. Typically a tutorial has several sections, each of which has a sequence of steps. This tutorial demonstrates two methods for obtaining this. For many page-specific customizations, it's essential to determine the internal name of a page within the architecture of MicroStrategy Web. Published: Dec 28, 2017. Step 4) Open the Rev Call Recorder app and tap the “Record” button. This tutorial covers every version of JavaScript: The Original JavaScript ES1 ES2 ES3 (1997-1999)MicroStrategy Web. msgID. KB43905: New Web feature - Add buttons to dashboards to facilitate different actions and boost visual appeal in MicroStrat… Number of Views 747 KB30140: How to enable the minimize and maximize buttons for a grid or graph on a dashboard in MicroStrategy Web 10. A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. TOPICS. Select Blank Report. To start the Report Wizard. W3. HTML to define the content of web pages. Learn web development. For example, click the link for MicroStrategy Tutorial. You want to learn more — and your MicroStrategy Education team is here to teach you. Make sure to subscribe. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. Thanks to MicroStrategy Semantic Graph it is possible to analyze parent-child relations between objects. Different parts of MicroStrategy Web are architecturally organised into pages: MicroStrategy Tutorial schema. By default, this file is located under: For ASP: C:Program FilesMicroStrategyWeb Servicesprojectsources. Users can click on the 'Get Projects' button to access. war, which is located by default in the C:Program Files (x86)MicrostrategyWeb JSP folder. Free tutorials, courses, and guided pathways for mastering real-time 3D development skills to make video games, VR, AR, and more. Open developer tools in the browser. Before you begin exploring the Tutorial schema using Architect, there are a few conventions and fact information that can help you understand the overall Tutorial schema. Explore the folders and double-click any report or dashboard to run it and see the sample data results. 2. Dossiers. 1Stand out in a crowd. MicroStrategy Web. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. For example, click the link for MicroStrategy Tutorial. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Follow these steps to enable drilling on metrics: In MicroStrategy Developer. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. . IIS (Internet Information Services) is Microsoft’s web server offering, playing second fiddle to market leader Apache. Our experts will explore popular use cases that streamline and automate your workflows—with minimal coding experience required. 3. BI Learning: Creating a Dynamic Enterprise Dashboard. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other. 8-2. Opening the login page to gather user for credentials. Our step-by-step guide teaches you the basics of HTML and how to build your first website. This is often a useful method for simplifying and testing issues involving usage of. This section of the Kubernetes documentation contains tutorials. Learn how to use the REST API Explorer to build and test sample REST requests. Accept the license agreement and continue. The instructions below apply to Dossiers created using MicroStrategy Web, Desktop and Workstation: 1) Add totals to your grid by clicking the context menu in the attribute header, choosing Show Totals, checking the Total box and clicking OK. INTERVAL '1-2' YEAR TO MONTH. Download. Watch how you can customize and extend the impact of your intelligence applications using the MicroStrategy Web SDK. Can configure environment variables (e. You want to learn more — and your MicroStrategy Education team is here to teach you. 1. By default, the configuration file. Setting Intelligence Server properties for the Web Administration page. Get Started MicroStrategy Workstation Become a More Intelligent Enterprise See full list on It provides a detailed description of the MicroStrategy Web architecture, discusses the various layers of functionality, and includes a large number of typical customization scenarios with easy-to-understand steps that illustrate the wide range of tasks possible using this SDK. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. Although the MicroStrategy Tutorial data model is displayed in the previous pages, you can also view it directly using MicroStrategy Architect. Log in with valid MicroStrategy user credentials. )Create and Configure. Data can be connected through an API, flat file, or database. Step 3) Import Selenium library and Testng inside that new project. Browsers automatically handle cookies, but if you are using your own client, you need to maintain the cookie and include it in further. Click the MicroStrategy icon, and select Create Document. Cards. Explore MicroStrategyPostgreSQL JDBC driver. It gives you an opportunity to familiarize yourself with the Web interface and learn some basic functionality. Building HyperIntelligence Cards. 2. To that end, we’ve designed a program. Open MicroStrategy Web in a Web browser and click the link for MicroStrategy Tutorial. x Number of Views 1. javac, jikes, etc. Mobile QuickStrike, Transaction Services QuickStrike, Retail Vendor Portal, Perennial Education Pass, MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in. . Platform: LinkedIn Learning. MicroStrategy i About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. In addition to the list of SQL commands, the tutorial presents flashcards with SQL functions, such as AVG (), COUNT (), and MAX (). mstr file. MicroStrategy Web by default use either Anonymous Authentication or Windows Authentication in IIS. For those coming from. VBA Controls — VBA Form Control & ActiveX Controls in Excel. Navigate to the document. Cloudera CDH Hadoop Gateway System. What is MicroStrategy? MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. This is not the same as creating visual insight dashboards; this is equivalent to creating dashboards the the developer desktop. The threshold can be selected from list of built-in colors or configured manually. How to build and manage Intelligent Cubes. 3 or higherThis tutorial steps through the various capabilities and pages within the Administration portion of a MicroStrategy Project Source. Learn Software Testing in 13 Days !!! Join our FREE Course. Read also: Sisense vs. MICROSTRATEGY AKTIE und aktueller Aktienkurs. In the above diagram Data in a dossier is displayed. Tutorials. That means how to layout an HTML page, how to add text and images, how. Creating Users and Using User Groups. To create a Freeform SQL report. Your Story. exe. En esta primera lección del curso veremos como importar un conjunto de datos a la herramienta. Right click on the metric in Editor tab and select Edit Threshold. Learn More. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The user is not prompted for login information before displaying the report since the login credentials (shown in bold. Data warehousing involves data cleaning, data integration, and data consolidations. This file is the same for both versions. Browse through a variety of embedding capabilities of the MicroStrategy Analytics and Mobility Platform. Download operating system-specific drivers for Windows and Linux that allow you to connect to a wide range of data sources. UML diagram is a model that describes a part of a system. In the MicroStrategy Library Configuration box, enter. The admin pages are protected by the admin role by default. Open the googleConfig. Learn the steps taken to delete the caches that Apache Tomcat keeps for the MicroStrategy Web application. 3. MicroStrategy for Jupyter is contained within mstrio-py package and is available after. Our absolute beginner tutorial will turn you from wannabe to webmaster in just a few hours. Accept the license agreement and continue. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. CakePHP Tutorial for Beginners — What is, Why Use & Features. x. Power Query: It can be used to search, access, and transform public and/ or internal data sources.