Business Intelligence Methods for Data Mining
You will gain knowledge on how to effectively use Microsoft’s Business Intelligence tools to mine, import and merge large amount of data. You will also learn how to present strategic data, provide better business insights, and empower informed decision-making.
Content
- Manipulating and Analyzing Data with the Data Analysis eXpressions (DAX) Language
- Presenting Information with Dashboards
- Articulating and analyzing data
- Drilling down into data using a hierarchy
- Managing data with perspectives
- Identifying patterns and trends in your Power Pivot data with Power View charts
- Classifying data into different geographical regions
- Designing effective dashboards
- Contextualizing measures with PivotTable slicers and Power View filters
- Documenting structures with Hierarchical Diagrams
- Visualizing and comparing performance matrices with Power View multipliers
- Globalizing location-based results to identify trends and patterns on a 3D scale with Power Map
- Role of Power Pivot in Business Intelligence
- Introducing Power Pivot
- Accessing the Power Pivot add-in
- Navigating the interface
- Loading a single data source
- Creating a dashboard
- Employing Power Pivot in the Business Intelligence process
- Extracting information from data with Power Pivot
- Uncovering data interpretation issues
- Presenting Information with Dashboard
- Drilling down into data using a hierarchy
- Managing data with perspectives
- Identifying patterns and trends in your Power Pivot data with Power
- View charts
- Classifying data into different geographical regions
- Contextualizing measures with PivotTable slicers and Power View filters
- Documenting structures with Hierarchical Diagrams
- Visualizing and comparing performance matrices with Power View multipliers
- Globalizing location-based results to identify trends and patterns on a 3D scale with Power Map
