> > > MIC-MCSABI

Microsoft MCSA: BI Reporting (MIC-MCSABI)

Course Description Schedule Course Outline
 

Prerequisites

Before attending this course, students must have:

  • Excellent knowledge of relational databases and reporting.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
  • Basic knowledge of data analytics.

Do you have what it takes? We´ll help you decide – Call us to discuss your technical background, experience and qualifications to determine how we can help you succeed in this Readynez programme.

Just call us and speak to one of our enrolment consultants. 

Course Objectives

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. Also this course gives 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.

<p style="font-style: inherit; font-weight: inherit;">After completing this course, students will be able to:

<ul style="font-style: inherit; font-weight: inherit;"> <li style="font-style: inherit; font-weight: inherit;">Perform Power BI desktop data transformation.

<li style="font-style: inherit; font-weight: inherit;">Describe Power BI desktop modelling.

<li style="font-style: inherit; font-weight: inherit;">Create a Power BI desktop visualization.

<li style="font-style: inherit; font-weight: inherit;">Implement the Power BI service.

<li style="font-style: inherit; font-weight: inherit;">Describe how to connect to Excel data.

<li style="font-style: inherit; font-weight: inherit;">Describe how to collaborate with Power BI data.

<li style="font-style: inherit; font-weight: inherit;">Connect directly to data stores.

<li style="font-style: inherit; font-weight: inherit;">Describe the Power BI developer API.

<li style="font-style: inherit; font-weight: inherit;">Describe the Power BI mobile app.

<li style="font-style: inherit; font-weight: inherit;">Explore and extend a classic Excel dashboard.

<li style="font-style: inherit; font-weight: inherit;">Explore and extend an Excel data model.

<li style="font-style: inherit; font-weight: inherit;">Pre-format and import a .CSV file.

<li style="font-style: inherit; font-weight: inherit;">Import data from a SQL Server database

<li style="font-style: inherit; font-weight: inherit;">Import data from a report.

<li style="font-style: inherit; font-weight: inherit;">Create measures using advanced DAX functions.

<li style="font-style: inherit; font-weight: inherit;">Create data visualizations in Excel.

<li style="font-style: inherit; font-weight: inherit;">Create a Power BI dashboard with Excel. [/list]

At Readynez, we know your time is valuable. Thats why we give you the opportunity to gain your Microsoft MCSA: BI Reporting training and certification in just 4 days. We provide the best conditions for you to learn.

With us by your side, encouraging and guiding you along the way, you can enjoy 4 intense, focused days of quality learning in a distraction free environment. Your expert instructor will be working with Readynezs unique accelerated learning methods, which include our exclusive lecture/lab/review methodology with real life cases putting you in the best possible position to learn and retain knowledge.

Sitting your Microsoft MCSA: BI Reporting course with Readynez means: 

  • Youll get more hours of training per day, allowing you to get trained and certified faster and more cost-effectively than with any other training provider.
  • You will be trained by one of the most expert instructors in the world. 
  • You can focus purely on learning in our distraction free environment.
  • Dedicated onsite support and access to your classroom at all hours.
  • The price you pay is all-inclusive and covers all course materials, exam, accommodation, meals and transportation service.
  • The Certification Guarantee allows you to train again for free, if you do not pass first time. You only pay for any exams and labs, and accommodation.

You can also choose to split up the course:

Part 1: Analyzing Data with Excel

Part 2: Analyzing Data with Power BI

 

Classroom Training

Duration 4 days

Price (excl. VAT)
  • Sweden: 32,900 Kr
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date

 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!