MicroStrategy for Business Intelligence

Dimensional modeling optimizes data warehousing by denormalizing data to reduce tables and joins, boosting query performance, and distinguishing dimensions and facts, with metrics aggregating sales data.

Explore star, snowflake, and galaxy schemas, showing how fact and dimension tables interact, and how normalization affects performance, data integrity, and storage, including multiple fact tables.

Design a dimensional model by identifying the business process, setting the level of information to store, and designing fact and dimension tables to answer monthly sales and revenue.

Learn how slowly changing dimensions capture changing customer data over time in a data warehouse, comparing type 1, type 2, and type 3 approaches for current versus historical records.

Explore MicroStrategy for business intelligence, covering data discovery, wrangling, data mining, predictive analytics, mobile platforms, and real-time dashboards, across three sections including data warehousing, dimensional modeling, and web visualizations.

Download and install Microsoft SQL Server 2017, set up SQL Server Management Studio, configure Windows authentication, create an instance, and restore the AdventureWorks database for MicroStrategy setup.

Learn to download and install MicroStrategy using a 30-day trial, apply the license key, and perform a custom installation on Windows, with metadata configuration to follow.

Configure MicroStrategy with a metadata database, create a Microsoft Access data source, and activate the product via the license manager.

Understand MicroStrategy architecture across two-tier, three-tier, and four-tier setups, detailing metadata and data warehouse connections, intelligence server roles, clustering, caching, and web and mobile reporting.

Learn to create a project source in MicroStrategy by configuring a DBC connection to Adventure Works DW 2016 and testing the connection.

Explore how to use MicroStrategy Architect to create attributes and facts, define relationships between dimension and fact tables, build a metric, and present results in a report.

Learn to create and organize attributes in folders, map them to dimension and fact tables with manual or automatic mapping, update the schema, and build a territory sales report.

In MicroStrategy, create compound keys by combining city id and country id to retrieve city names, and learn to define attributes, form groups, and save the compound key.

Explore system and user hierarchies in MicroStrategy and build a user hierarchy from territory group to country to region to enable easy drill-down in reports.

Create facts in MicroStrategy by selecting table, mapping fields like unit price and sales amount, saving facts as total product cost and freight amount, and applying sum and max functions.

Learn to create metrics in MicroStrategy, use functions such as sum, average, and max on facts, and configure metric components including formula, level, transformations, and conditions for reports.

Update MicroStrategy schema before creating objects, then create metrics like sales amount minus total product cost and a percentage metric, and build a report with time and territory region attributes.

Explore how to use different level metrics in MicroStrategy, switching between report level and attribute level dimensionality, and apply dynamic subtotal functions to summarize orders across dimensions.

Explore how to use condition in MicroStrategy by adding filters at the metric and report levels, compare merge options, and generate top 10 revenue insights.

Explore the transformation in a metric for time series analysis, comparing current and previous periods (year, month) using sales amount, and configuring joins in a report.

Create and apply attribute and metric qualifications in MicroStrategy to refine revenue reports by territory region and a revenue threshold, then build and execute reports.

Explore how relationship filtering links unrelated attributes like customer and region in MicroStrategy to identify customers who purchase in the same region as Aaron Diaz.

Create and apply report filters in MicroStrategy, including a filter within a filter that narrows data by territory region, customer name, and the sales amount metric.

Create and apply prompts in MicroStrategy to define runtime filters using attributes, hierarchies, and metrics. Learn to configure prompt restrictions and add prompts to report filters for interactive analysis.

Explore advanced prompt options in MicroStrategy, including qualifying on attributes, listing territory region and customer name elements, and building reports with prompts and runtime qualifications on sales amount.

Learn how object, value, and level prompts power runtime customization in MicroStrategy for business intelligence, enabling users to select attributes or metrics, set value filters, and choose metric level dimensionality.

Learn to create search objects in MicroStrategy to power prompts, simplify attribute selection, and save searches for quick lists of products, customers, and territory hierarchies.

Explore consolidation in MicroStrategy within a custom group to create derived elements from existing elements, such as Europe, North America, and Pacific, and summarize revenue by these new elements.

Discover how custom group differs from consolidation in MicroStrategy, learn to create derived elements on attributes and metrics, and analyze top and bottom revenue contributors.

Compare consolidation and custom group: derive elements from attributes (and metrics for custom group), display individual contributions, and use revenue reports like top five contributors between 5000 and 7000.

Discover how intelligent cubes in MicroStrategy optimize performance by caching data from the data warehouse, enabling faster report execution and reuse across users.

Learn to install MicroStrategy web on your computer using the installation wizard, modify features, and open the web administrator to create a project and explore the interface.

Learn to load data in MicroStrategy, import CSV files or databases, and perform data wrangling: fill blanks, uppercase names, rename fields, remove duplicates, and save scripts for dashboards.

Explore creating bar chart visualizations in MicroStrategy Dozier by configuring data sets, charts, color by region, break by, size by, and merging profit and sales information.

Create line and pie charts in MicroStrategy Dossier, mapping product subcategory and category to sales and profit, color by region and customer segment, then save the dashboard.

Create heat map visualizations in MicroStrategy by importing data from disk, grouping by region and year/quarter, and analyzing total profit and units sold with color by region.

Create KPI visualizations for total revenue, total profit, and total cost, customize styles and colors, and use break-by year to reveal year-over-year revenue changes and profit declines.

Create and customize a dashboard by adding KPI analysis, an area chart, and a box block, apply filters, and format total and average revenue in dollars by region.

Create a grid visualization in MicroStrategy to analyze total profit and total revenue by region and sales channel across years, with subtotals, currency formatting, and sorting.

Explore grid visualization formatting in microstrategy, adjusting colors, headers, lines, and fonts to craft a clear report. Learn to apply color-based and image-based thresholds to highlight profit performance.

Group countries into Asia, Europe, and North America by creating groups, choose consolidated or individual elements, and present results in reports, budgets, or charts.