MCSA BI Reporting Kursus, Certificering & Uddannelse

Overview

Your 4-day accelerated MCSA: BI Reporting certification course will develop the skills you need to create and manage enterprise business intelligence solutions as well as gain an expert understanding of data analysis using Power BI.

You'll be immersed in Microsoft Official Curriculum (MOC) using Firebrand's Lecture | Lab | Review technique. Your expert Microsoft Certified Trainer (MCT) will get you hands-on with the technology - helping you develop real-world practical skills. You'll develop and retain knowledge faster by combining theory and practical labs, reinforced by review sessions to help you cover the more complex topics.

You'll cover a range of exciting topics including:

Performing Power BI desktop data transformation
Creating a Power BI desktop visualisation
Implementing the Power BI service
Connecting directly to data stores
Explore and extend a classic Excel dashboard and data model.
Import data from a SQL Server database and reports
Create measures using advanced DAX functions
Create data visualisations in Excel and a Power BI dashboard with Excel

You will be prepared for exams 70-778: Analysing Data with Power BI and 70-779: Analysing and Visualising Data with Microsoft Excel. You'll sit both these exams at Firebrand's training centre during the course. This is covered by your Certification Guarantee.

If you're a database professional needing to create enterprise BI solutions and alternative methods of presenting data the MCSA BI Reporting certification is ideal. Earning the certifcation will act as your first step towards achieving the MCSE: Data Management and Analytics credential.

Det tager kun et øjeblik at se hvor billigt dit kursus er...

Se priser

Benefits

Er du klar til kurset? Tag en GRATIS test som hjælper dig med at bedømme din nuværende viden.

Gratis Test

Curriculum

Course 20778C: Analysing Data with Power BI

Module 1: Introduction to Self-Service BI Solutions
Module 2: Introducing Power BI
Module 3: Power BI
Module 4: Shaping and Combining Data
Module 5: Modeling data
Module 6: Interactive Data Visualisations
Module 7: Direct Connectivity
Module 8: The Developer API
Module 9: Power BI mobile app

Course 20779C: Analysing Data with Excel

Module 1: Data Analysis in Excel
Module 2: The Excel Data Model
Module 3: Importing Data from Files
Module 4: Importing Data from Databases
Module 5: Importing Data from Excel Reports
Module 6: Creating and Formatting Measures
Module 7: Visualising Data in Excel
Module 8: Using Excel with Power BI

Exam Track

You'll sit the following exams at the Firebrand training centre during the course, covered by your Certification Guarantee:

Exam 70-779: Analysing and Visualising Data with Microsoft Excel

Languages: English

Technology: Microsoft Excel, Power BI

You'll be tested on the following skills and knowledge:

Consume and Transform Data by Using Microsoft Excel (30-35%)
Model Data (35-40%)
Visualise Data (30-35%)

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

Languages: English
Technology: Microsoft Excel

You'll be tested on the following skills and knowledge:

Consume and Transform Data By Using Power BI Desktop (20-25%)
Model and Visualise Data (45-50%)
Configure Dashboards in the Power BI Service (25-30%)

What's Included

Microsoft Official Curriculum

MOC 20778C: Analysing Data with Power BI
MOC 20779C: Analysing Data with Excel

Det hele er inkluderet! Du får en alt-inklusiv kursuspakke, som er målrettet til dine behov. Vi tager os af enhver detalje, så det eneste du skal fokusere på er dine lærings- og certificeringsmål.

Transport til/fra specifikke afhentningssteder
Overnatninger, samtlige måltider samt adgang til forfriskninger, snacks, kaffe og the.
Intensiv Hands-on uddannelse med vores unikke (Lecture | Lab | Review)TM metode
Omfattende kursusmaterialer og labmanualer
Et helt igennem instruktørstyret program
24 timers adgang til både undervisningslokale og instruktøren
Samtlige måltider samt adgang til forfriskninger, snacks, kaffe og the.
Certificeringsgaranti

Prerequisites

Before attending this course, you must meet the following prerequisite knowledge and skills:

Experience of querying data using Transact-SQL
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.
Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Basic knowledge of data analytics

Er du klar til dit Firebrand Kursus?

Vi interviewer alle potentielle deltagere angående deres baggrund, uddannelser, certificeringer og personlig indstilling. Hvis du kommer igennem denne screeningsprocedure, betyder det, at du har rigtig gode chancer for at bestå.

Firebrand Training tilbyder et ambitiøst uddannelsesmiljø, som forudsætter at du dedikerer dig til kurset. Ovenstående forkundskaber er vejledende; mange deltagere med mindre erfaring, men med en anden baggrund eller færdigheder, har haft succes med accelereret uddannelse hos Firebrand Training.

Hvis du funderer på hvorvidt du opfylder de anbefalede forkundskaber, er du meget velkommen til at ringe til os på 89 88 66 05 og tale med en af vores uddannelsesrådgivere, som kan hjælpe dig.

Kundereferencer

Her er Firebrand Training review afsnit. Siden 2001 har vi trænet præcist 134.561 studerende og professionelle og bedt dem alle om at gennemgå vores Accelerated Learning. Lige nu har 95,54% sagt, at Firebrand har overgået deres forventninger.

Læs anmeldelser fra de seneste accelererede kurser nedenfor, eller besøg Firebrand Stories for skriftlige og videointerviews med vores alumner.

"Not very complimentary about this course."
Krishna Kumar. (18/11/2019 (Mandag) til 21/11/2019 (Torsdag))

"Enjoyed visit to Wyboston lakes. Staff and facilities were exceptional - Highly recommended for those who want to learn in accelerated mode !"
S.R.. (5/8/2019 (Mandag) til 8/8/2019 (Torsdag))

"Very friendly atmosphere and everyone is very helpful."
Thomas Stephens. (5/8/2019 (Mandag) til 8/8/2019 (Torsdag))

"Very informative and helpful with questions enabling me to get my certification."
Michael Howard. (5/8/2019 (Mandag) til 8/8/2019 (Torsdag))

"Intense.. but good!"
K.P.. (5/8/2019 (Mandag) til 8/8/2019 (Torsdag))

Kursusdatoer

Microsoft 365 - MCSA: BI Reporting
Starter	Slutter	Tilgængelighed	Tilmelding
28/8/2024 (Onsdag)	31/8/2024 (Lørdag)	Afsluttet - Giv feedback
13/11/2024 (Onsdag)	16/11/2024 (Lørdag)	Tilgængelige pladser	Tilmelding
10/2/2025 (Mandag)	13/2/2025 (Torsdag)	Tilgængelige pladser	Tilmelding
12/5/2025 (Mandag)	15/5/2025 (Torsdag)	Tilgængelige pladser	Tilmelding
27/8/2025 (Onsdag)	30/8/2025 (Lørdag)	Tilgængelige pladser	Tilmelding

Microsoft 365 - MCSA: BI Reporting