0800 699 0033 ~ info@jrny.org.uk

Microsoft MCSA: BI Reporting - jrny-training

Microsoft MCSA: BI Reporting

Regular price
£1,194.00
Sale price
£995.00
Tax included.

Earn a Microsoft certification and build your professional career in BI Reporting

Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modelling, 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).

Our MCSA Courses include all of the training and exams required to achieve your MCSA certification.

Whats included:

Exam 70-778 - Analyzing and Visualizing Data with Power BI

About this course
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Audience profile
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

At course completion
After completing this course, students will be able to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.

 

Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel

About this course
The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.


Audience profile
This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

At course completion
After completing this course, students will be able to:

  • 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.