Home Microsoft Training Microsoft BI Business Intelligence

MCSA - BI Reporting Training Course

This is an industry-designed combo online training course that includes some of the best BI reporting tools used in the corporate world today. BI reporting is involved with helping the end-users visualize data, analyze it, gain new insights to make informed and data-driven business decisions.

  • 35000
  • 40000
Download Brochure
  • Course Includes
  • Live Class Practical Oriented Training
  • 100 + Hrs Instructor LED Training
  • 80 + Hrs Practical Exercise
  • 60 + Hrs Project Work & Assignment
  • Timely Doubt Resolution
  • Dedicated Student Success Mentor
  • Certification & Job Assistance
  • Free Access to Workshop & Webinar
  • No Cost EMI Option
Report

Have Query ?

What you will learn

  • Understand primary features of a self-service Power BI solution. Utilize Power BI and its data sources. Combine, analyze...
  • Report data using rich dashboards. Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model. Pre-format and import a .CSV file.
  • Import data from a SQL Server database. Import data from a report.
  • Create measures using advanced DAX functions. Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel

Requirements

  • Basic Knowledge of Ms-Excel and SQL querying.

Description

|| About MCSA - BI Reporting Training Course

Our BI Reporting certification master’s online training program lets you gain proficiency in the top BI Reporting tools. This training includes the BI Reporting tools like QlikView, Spotfire, Tableau, Cognos, Cognos Insight, Pentaho, Jaspersoft, MicroStrategy, Hyperion, and SSRS. You will work on projects in data visualization, deploy dashboards, analytics, reports for deriving business insights, etc. Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI.  It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE). During this training, students will learn to analyze data with Power BI and Excel.

Candidates for this exam should have a good understanding of how to use Power BI to perform data analysis. Candidates should be proficient in connecting to data sources and performing data transformations, modeling and visualizing data by using Microsoft Power BI Desktop and configuring dashboards by using the Power BI service. Candidates should also be proficient in implementing direct connectivity to Microsoft SQL Azure and SQL Server Analysis Services (SSAS), and implementing data analysis in Microsoft Excel. Candidates may include BI professionals, data analysts, and other roles responsible for creating reports by using Power BI.

Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and Pivot Charts. Candidates may include BI professionals, data analysts, and other roles responsible for analyzing data with Excel.

This Information provided from Microsoft Certification Website.*

This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page. Any certifications you earn prior to their retirement dates will continue to appear on your transcript in the Certification Dashboard

·         Exam 70-778: Analyzing & Visualizing Data with Microsoft Power BI

·         Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel

Course Content

Live Lecture

This Part provides students with the knowledge and skills to analyze data with Power BI.
Live Lecture

·      Lessons

·      Introduction to Business Intelligence

·      Introduction to Data Analysis

·      Introduction to Data Visualization

·      Overview of Self-Service BI

·      Considerations for Self-Service BI

·      Microsoft Tools for Self-Service BI

·      Lab: Exploring an Enterprise BI Solution

·      Viewing Reports

·      Creating a Power BI Report

·      Creating a Power BI Dashboard

·      After completing this module, students will be able to:

·      Describe the trends in BI.

·      Describe the process of data analysis in Power BI.

·      Use the key visualizations in Power BI.

·      Describe the rationale for self-service BI.

·      Describe considerations for self-service BI.

·      Understand how you can use Microsoft products to implement a BI solution.
Live Lecture

·      Lessons

·      Power BI

·      The Power BI Service

·      Lab: Creating a Power BI Dashboard

·      Connecting to Power BI Data

·      Create a Power BI Dashboard

·      After completing this module, students will be able to:

·      Develop reports using the Power BI Desktop app.

·      Use report items to create dashboards on the Power BI portal.

·      Understand the components of the Power BI service, including licensing and tenant management.
Live Lecture

·      Lessons

·      Using Excel as a Data Source for Power BI

·      The Power BI Data Model

·      Using Databases as a Data Source for Power BI

·      The Power BI Service

·      Lab: Importing Data into Power BI

·      Importing Excel files into Power BI

·      Viewing Reports from Excel Files

·      After completing this module, students will be able to:

·      Describe the data model and know how to optimize your data within the model.

·      Connect to Excel files and import data.

·      Use on-premises & cloud SQL Server databases as data sources, with the R script data connector.

·      Take advantage of the features of the Power BI service.

·      Use Q&A to ask questions in natural query language and create apps.
Live Lecture

·      Lessons

·      Power BI Desktop Queries

·      Shaping Data

·      Combining Data

·      Lab: Shaping and Combining Data

·      Shape Power BI Data

·      Combine Power BI Data

·      After completing this module, students will be able to:

·      Perform a range of query editing tasks in Power BI.

·      Shape data, using formatting and transformations.

·      Combine data together from tables in your dataset.