Business Intelligence with Microstrategy 10 Analytics

Load data from diverse sources into MicroStrategy, transform and profile it, define datasets with attributes and metrics, and prepare an example Excel file to build dashboards.

Load a sales overview Excel into a new MicroStrategy dossier, wrangle data with the data wrangling editor by renaming columns and removing rows, then update the dataset and examine relationships.

Build and customize dashboards in MicroStrategy 10 Analytics by assembling chapters and pages, adding data sets, and configuring panels, filters, and visualizations with attributes and metrics.

Build a multi-chapter sales dashboard with an executive summary KPI page, marketing segmentation, logistics, shipments, customer segment sales, and orders and returns.

Create the orders overview page with a grid displaying order id, order date, shipment date, status, quantity, and unit price, plus kpis for total, delivered, and returned orders.

Build stacked visualizations in MicroStrategy to display shipment orders by mode (delivery truck, express air, regular air), and add a timeline of order duration plus KPIs for shipping costs.

Create a product category sales dashboard by grid and pie charts showing sales by category and subcategory, with three KPI metrics and dollar formatting for a quick overview.

Build a heatmap grouping sales by customer segment and region, with size by sales and color by region. Add a grid and a bubble chart for regional sales across provinces.

Create a KPI dashboard for sales orders, featuring KPIs for total profit, total sales revenue, and total orders, plus two combo charts with order month and color by orders.

Design best practices for building dashboards in MicroStrategy, focusing on chapters and pages, audience-driven layouts, concise visualizations, and responsive, color-smart design.

Learn to present and export basic and advanced MicroStrategy reports, using basic and range filters, totals, drill down, roll up, and slice and dice, with CSV or PDF exports.

Learn to manage MicroStrategy dashboards with include/exclude filters, advanced sorting, drill down on dimensions like customer segment, and visualization filters to export to PDF.