Designing Self-Service Business Intelligence and Big Data Solutions (Course 20467C)
nanforiberica
Acerca de este Curso
Perfil de audiencia
Al finalizar el curso
- Describe key features and benefits of self-service BI.
- Use SQL Server Reporting Services to implement a self-service reporting solution.
- Use PowerPivot in Microsoft Excel to create analytical data models.
- Use Power Query in Microsoft Excel to import data into a data model.
- Use Power View in Microsoft Excel to create interactive data visualizations.
- Use Power Map in Microsoft Excel to create geographic data visualizations.
- Use Microsoft SharePoint Server to implement collaborative self-service BI solutions.
- Provision and use a Windows Azure HDInsight cluster for Big Data analysis.
- Use Pig and Hive to analyze big data in Windows Azure HDInsight.
- Design and implement Big Data processes to support self-service BI.
Pre-requisitos
- A basic understanding of dimensional modeling (star schema) for data warehouses
- Basic server hardware knowledge
- The ability to create Integration Services packages that include control flows and data flows
- The ability to create a basic multidimensional cube with Analysis Services
- The ability to create a basic tabular model with PowerPivot and Analysis Services
- The ability to create Reporting Services reports with Report Designer
- The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
- Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel
Detalles del curso
Module 1: Introduction to Self-Service Business Intelligence
Lessons
- Extending Enterprise BI
- Microsoft Self-Service BI and Big Data Technologies
Lab : Exploring an Enterprise BI Solution
- Viewing Reports
- Analyzing Data in a Data Model
- Analyzing Data from Multiple Sources
- Describe ways in which an enterprise BI solution can be extended.
- Identify Microsoft technologies for self-service BI and Big Data analysis.
Module 2: Self-Service Reporting
Lessons
- Introduction to Self-Service Reporting
- Shared Data Sources and Datasets
- Report Parts
Lab : Implementing Self-Service Reporting
- Using Report Builder
- Simplifying Data Access for Business Users
- Using Report Parts
- Support self-service reporting with Report Builder.
- Create shared data sources and datasets for self-service reporting scenarios.
- Use report parts as reusable report elements.
Module 3: Self-Service Data Modeling with PowerPivot
Lessons
- Creating Data Models in Excel with PowerPivot
- Using DAX in a PowerPivot Data Model
Lab : Self-Service Data Modeling with PowerPivot
- Creating a Data Model with PowerPivot
- Enhancing a Data Model
- Extending a Data Model
- Use PowerPivot to create tabular data models in Excel.
- Enhance data models with custom DAX expressions.
Module 4: Importing Data with Power Query
Lessons
- Introduction to Power Query
- Using Power Query to Import Data
Lab : Using Power Query
- Importing data with Power Query
- Merging Queries
- Adding a Query to a Data Model
- Enable Power Query and use it to search for data online
- Use Power Query to import data from multiple data sources into an Excel data model
Module 5: Visualizing Data with Power View in Microsoft Excel
Lessons
- Introduction to Power View
- Creating Dynamic Data Visualizations
Lab : Visualizing Data with Power View
- Using Power View
- Describe the features of Power View
- Use Power View to create interactive data visualizations in Excel
Module 6: Visualizing Geographic Data with Power Map
Lessons
- Introduction to Power Map
- Using Power Map
Lab : Visualizing Geographic Data with Power Map
- Creating a Power Map Tour
- Visualizing Data Over Time
- Describe the features and usage scenarios of Power Map
- Use Power Map to create visualizations of geographic data
Module 7: Collaborative BI with Microsoft SharePoint Server
This module describes how to use Microsoft SharePoint Server in an enterprise environment to enable users to share PowerPivot workbooks and Power View reports.Lessons
- Sharing PowerPivot Workbooks
- Managing PowerPivot Services in SharePoint Server
- Using Power View in SharePoint Server
Lab : Using SharePoint Server for BI Collaboration
- Sharing a PowerPivot Workbook
- Managing PowerPivot Data Refresh
- Using Power View in SharePoint Server
- Share a PowerPivot workbooks in SharePoint Server
- Manage PowerPivot services in SharePoint Server
- Use Power View to create interactive data visualizations in SharePoint Server
Module 8: Introduction to Big Data and Microsoft Azure HDInsight
Lessons
- Introduction to Big Data
- Windows Azure HDInsight
Lab : Using Windows Azure HDInsight
- Provisioning a Windows Azure HDInsight Cluster
- Processing Data with HDInsight
- Analyzing Big Data in Microsoft Excel
- Describe key features of Big Data.
- Use Windows Azure HDInsight to process Map/Reduce jobs
Module 9: Processing Big Data with Pig and Hive
Lessons
- Processing Big Data with Pig
- Processing Big Data with Hive
Lab : Processing Big Data with Pig and Hive
- Processing Big Data with Pig
- Processing Big Data with Hive
- Use Pig to process Big Data
- Use Hive to process Big Data
Module 10: Implementing Big Data Processing Solutions with Microsoft Azure HDInsight
Lessons
- Automating Big Data Processing Tasks
- Integrating Windows Azure HDInsight with Enterprise Data
Lab : Creating a Big Data Solution
- Using HCatalog to Abstract Storage Locations
- Using Oozie to Coordinate a Workflow
- Using Sqoop to Export Data
- Design and implement an automated Big Data processing solution
- Integrate Windows Azure HDInsight with Self-Service BI Solutions
Lessons
- Overview of BI Operations
- ETL Operations
- Data Warehouse Operations
- Analysis Services Operations
- Reporting Services Operations
After completing this module, you will be able to:
- Describe the components to be managed in a BI Solution.
- Be able to manage the components of a BI solution.