MicroStrategy Data Analytics & Business Intelligence Course

Explore MicroStrategy's business intelligence platform with in-memory analytics, broad data source compatibility, and enterprise dashboards and reporting accessible via browser, mobile, and collaboration.

Create a MicroStrategy dashboard project by organizing folders for order data, setting a data source, managing offline sources, and configuring panels, filters, and sheets for order-focused analytics.

connect to a flat file database to extract data from excel and cloud sources, join customer, product, and transaction tables, and prepare the data by establishing relationships for analysis.

Explore how MicroStrategy classifies data types, identifies geographic attributes, and defines measures and metrics, enabling effective data modeling and chart creation.

Explore how to build a bar chart in MicroStrategy by selecting dimensions and metrics, setting vertical and horizontal axes, applying color by product, and turning data into a dashboard-ready visualization.

Learn how to enhance a bar chart in MicroStrategy by applying color by quantity, adjusting color density, and arranging multiple visualizations on dashboards for product and revenue analysis.

Learn to design bar charts in MicroStrategy with conditional formatting, using dimensions and measures like revenue, quantity, and color to enhance dashboards and reveal product, customer, and geographic insights.

Master bar chart conditional formatting in MicroStrategy by building a report with city, country, customer name, and product name, using quantity and revenue to enhance visualization.

Learn to build a MicroStrategy grid report with threshold coloring to highlight top customers and stock levels, using color scales from red to green for quick decision making.

Explore how MicroStrategy heat maps visualize data across single and multi dimension contexts, using conditional formatting, dashboard, and data modeling to reveal insights.

Learn to build a stacked bar chart in MicroStrategy by selecting customer and product attributes, displaying revenues, and applying colors by product.

Explore how to build single and multi dimensional line charts in MicroStrategy by plotting metrics and attributes, visualizing procurement, stock, revenue, and margins across months with color and markers.

Explore MicroStrategy area chart analysis by mapping weekly sales to a time dimension, adjusting colors, and adding reference lines for maximum, minimum, and average to reveal data patterns.

Learn to build a MicroStrategy area chart with multi‑measure analysis, organize panels, compare sales, procurement, revenue, and stock over time, and fine‑tune references and colors for clarity.

Construct a MicroStrategy area chart with multi-dimensional analysis, using two dimensions and one major to visualize revenue by month, customer, and product with color by product.

Explore MicroStrategy bubble chart analysis, building interactive bubble plots with a dimension, attribute, and metrics; learn color, size by quantity or revenue, and single-dashboard visual consolidation.

Master MicroStrategy pie chart analysis to examine monthly sales, adjust slices by angle, color by revenue, and use legends, thresholds, and hover data for actionable insights.

Master pie chart analysis with multi dimensional analysis, using time dimension and quarterly breakdowns; customize captions and colors, compare revenue by product, and explore dual axis dashboard visuals.

Explore building and customizing MicroStrategy combo charts to compare stock and sales on shared axes, adjust colors, labels, and trend line, and switch dimensions like month, week, or state.

Create a polished landing page for a MicroStrategy dashboard by adding a banner, logo, and title, and embed images in the project folder with proper aspect and links.

Prepare geographic analytics by structuring a database with latitude and longitude fields, extracting coordinates from location data, and using geopositioning to map countries and cities for MicroStrategy.

Learn to visualize geographical data using the MicroStrategy map object, plotting countries on a world map with latitude and longitude, bubble sizes reflecting population, and handling overlapping regions.

Explore MicroStrategy geographical analysis with filled color and density effects on maps, using longitude and latitude to visualize population patterns and regional differences across countries, including offline map capabilities.

Explore how to build and analyze complex relationships with a MicroStrategy network chart, choosing live or in-memory connections, and visualizing doctor-patient and product-customer networks for fast insight.

Create grid-based reports for tabular analysis, using rows, columns, and filters, apply color density and calculations (sum, price, quantity) to reveal customer transactions and product patterns.

Apply basic report filters in MicroStrategy to refine data by country, product, and customer, using dropdowns, sliders, and include/exclude rules to control results.

Create a MicroStrategy derived matrix, configure dynamic columns and calculated fields to model revenue growth and subtotals, and apply discount calculations with price including discounts.

Create MicroStrategy attributes and map product naming and capitalization considerations within a data analytics workflow, as illustrated through discussions of naming, capitalization, and system processes.

Explore building a microstrategy asset management dashboard by connecting sql server databases, selecting tables like category and make, and creating relationships with inner and outer joins to support visualizations.

Master advanced data modeling and schema design in MicroStrategy by joining category, make, and model data, configuring relationships, and validating the resulting analytics.

Apply data cleansing with MSTR Data Wrangler to transform offline data, split first and last names, remove commas and dots, and standardize fields for clean datasets without altering the database.

Explore MicroStrategy trend analysis and forecasting to model six-month demand, using past data, multiple models, and interactive panels to analyze sales by month, product, and customer.

Learn to create consolidated and custom groups in MicroStrategy by grouping countries into continents, building dynamic groups, and applying group choices to enrich analytics.

Create a drill-down analysis using time dimensions—year, quarter, month, week, and day—within MicroStrategy to explore transactions by year and slice by customer, country, and city.

Learn to use MicroStrategy reference lines and trend lines to analyze large data sets, identify maximum, minimum, median, and average values, and make better business decisions.

Learn to create and import custom objects from the MicroStrategy gallery, and use them in dashboards to build visuals like bullet charts and box plots for sales, revenue, and trends.

Explore MicroStrategy architect and development basics, including the semantic layer, logical and physical data models, dimensions and facts, and dashboards, with administration topics and hands-on installation.

Explore MicroStrategy architecture, linking source systems through edl into a data warehouse, with interactive dashboards and reports powered by a metadata repository and semantic layer.

Explore two object types in MicroStrategy: schema objects mapped to tables and public objects built on them to power reports and dashboards via developer interface and end user web access.

Connect to MicroStrategy web to access dashboards and reports, use the visualization editor to drag and drop visualizations, and design dashboards while understanding semantic layer and schema object limits.