A Complete Course on Microstrategy 10.1x BI tool

Explore MicroStrategy, a business intelligence tool offering data analytics, advanced analytics, and data visualization, with relational sources, automated report distribution, and scalable business intelligence reports.

Explore MicroStrategy's capabilities to connect to any data source and blend data from relational sources, social media, and cloud systems, with data mining, automated recommendations, and dashboards on mobile platforms.

Explore the basics of MicroStrategy Desktop, navigate the desktop environment, connect data sets, apply metrics and visualizations, and filter data for analysis.

Explore MicroStrategy architecture, detailing a central repository for objects, building blocks like schema objects, and a unified, relational OLAP approach that integrates data from diverse sources via the engine.

Import data into MicroStrategy by selecting new data sources, browsing files such as Excel, and prepping datasets to create visualizations like matrices and charts.

Import public data from URLs to build country lists by donations, maps, and metrics in MicroStrategy 10.1x, selecting data types and formatting for web-sourced information.

Import data from Twitter into MicroStrategy by selecting the data source, granting access, and configuring a search string and time range to retrieve tweets for analysis.

Explore olap services in MicroStrategy 10.1x, featuring in-memory business intelligence for fast analyses and reporting with table grids, attribute and metric name consolidation, and sorting.

Explore slicing in MicroStrategy 10.1x by computing each selected item separately, visualize salary by department with grids and charts, and understand how source attributes influence the results.

Explore dicing in MicroStrategy by selecting subsets across multiple dimensions to isolate salary values for employees within departments.

Pivoting in MicroStrategy demonstrates how arranging data by columns and rows yields different summaries and perspectives, using employee data with department, salary, and ID to reveal insights.

Master drill down in MicroStrategy 10.1x to reveal granular measure values across linked dimensions, using employee data, starting at department and drilling into job title to see how values aggregate.

Rollup consolidates data by moving up the hierarchy, reducing granularity and producing more summarized values from area to region to country, as shown in the hands-on example.

Create a metric for the department average salary using the average function in MicroStrategy 10.1x. Save the metric and drag it onto the dashboard to view department salaries.

Explore nested metrics in MicroStrategy 10.1x, defining subcategories and formulas to build metrics across categories. Learn to create and compare measures within dashboards for sales and related data.

Create derived metrics by combining existing metrics such as shipping cost and unit price, using proxies when data is missing, and save them to the dashboard for enhanced sales analysis.

Learn how to compare two metrics with functions and calculations in MicroStrategy, using an example dataset of unit price and shipping cost to show how values change.

Explore creating filters in MicroStrategy 10.1x by applying non-numeric value filters to a column, enabling data-based selections and basic report customization.

Explore advanced filters in MicroStrategy 10.1x, moving beyond check boxes to use additional options and search capabilities. Apply these filters to tables, lists, and other views for targeted data analysis.

Intelligent cubes provide a single in-memory data copy from the data warehouse to power multiple reports, reducing repeated calculations and enabling dynamic aggregation and faster dashboards.

Create a dashboard in microstrategy using proxy data sources to compare shipping cost metrics and unit price, and visualize the relationships with charts.

Format a dashboard in MicroStrategy by adjusting colors, borders, alignment, and layout to improve visualization and presentation.

Explore graph visualizations in MicroStrategy desktop, from bar, line, and heat map charts to bubble charts and interactive maps, guided by a gallery of options for understanding data variations.

Explore grid visualizations in microstrategy, focusing on arranging data with rows and columns, dragging attributes to columns, and applying sorting options in ascending or descending order.

Explore heat map visualization in microstrategy 10.1x, including grouping data by attributes and measures and using color shading to reveal high and low values.

Explore network visualization to quickly identify relationships among items by displaying nodes and edges, adjusting node size and color to reveal connections and trends in data such as sales.

Combine attributes and metrics from multiple data sources to create a unified visualization in MicroStrategy, and follow steps to add datasets and display data from all sources on a dashboard.

Learn how to add web content in MicroStrategy 10.1x by following steps to retrieve online content and display it within your project.

Learn how report cache flows in MicroStrategy 10.1x, including in-memory pre-calculated caches, project-level and report-level caching, and forced refresh with admin privileges to delete or purge.

Discover how to build predictive models with MicroStrategy, leveraging its data mining services, neural networks, and clustering to forecast outcomes, generate predictive intervals, and scale across datasets.

Learn to clean and transform data in MicroStrategy 10.1x by applying transformations, removing duplicates, extracting values, and handling whitespace, using the data wrangler interface and the step tree.