Launch your career as a Power BI analyst
Learn the in-demand business intelligence skills that will have you job-ready in less than 3 months.
No prior experience required to get started.
GET EDUCATED
INTRODUCING
Microsoft Power BI Data Analyst
Professional Certificate
with mentoring sessions
- Learn to use Power BI to connect to data sources and transform them into meaningful insights.
- Prepare Excel data for analysis in Power BI using the most common formulas and functions in a worksheet.
- Learn to use the visualization and report capabilities of Power BI to create compelling reports and dashboards.
- Demonstrate your new skills with a capstone project and prepare for the industry-recognized Microsoft PL-300 Certification exam.
Prepare for a career in Business Intelligence
- Receive professional-level training from Microsoft and sessions with experienced professionals
- Demonstrate your proficiency in portfolio-ready projects
- Earn an employer-recognized certificate from Microsoft
- Qualify for in-demand job titles: Business Intelligence Analyst, Business Data Analyst, Power BI Analyst
COURSE STRUCTURE
This program includes over 250 hours of instruction and hundreds of practice-based assessments, which will help you simulate real-world scenarios that are critical for success in the workplace. Our skilled mentors are here to guide you through it, offering insights and support every step of the way.
COURSE 1
Preparing Data for Analysis with Microsoft Excel
In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis.
- Create data in Microsoft Excel and prepare it for data analysis.
- Make use of common formulas and functions in a worksheet.
- Prepare Excel data for analysis in Power BI using functions.
COURSE 2
Harnessing the Power of Data with Power BI
You’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus on applying them using Microsoft Power BI.
- How to recognize and use the key data analysis components of Microsoft Power BI.
- Understand a Power BI data analyst's skills, tasks, and tools.
- Describe the different stages in the data analysis process that result in data-driven decisions.
COURSE 3
Extract, Transform and Load Data in Power BI
You will identify how to collect data from and configure multiple sources in Power BI and prepare and clean data using Power Query. You’ll also have the opportunity to inspect and analyze ingested data to ensure data integrity.
- Identify, explain and configure multiple data sources in Power BI.
- Clean and transform data using Power Query.
- Inspect and analyze ingested data to ensure data integrity.
COURSE 4
Data Modeling in Power BI
In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model using multiple Schemas.
- How to form a model using a Star Schema.
- How to write calculations DAX to create elements and analysis in Power BI.
- How to optimize performance in a Power BI model.
COURSE 5
Data Analysis and Visualization with Power BI
You will learn report design and formatting in Power BI, which offers extraordinary visuals for building reports and dashboards. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI.
- How to add visualizations to reports and dashboards.
- How to design accessible reports and dashboards.
- How to use visualizations to perform data analysis.
COURSE 6
Creative Designing in Power BI
You will learn how to creatively design dashboards, reports and charts that are easier for the audience to use. You will learn how to create cohesive business intelligence reports and dashboards, as well as what common problems to avoid.
- How to create compelling and cohesive reports and dashboards.
- How to work in detail with specialist chart visualizations.
- How to add elements such as videos, streaming data and QR codes to dashboards.
COURSE 7
Deploy and Maintain Power BI Assets and Capstone project
You’ll learn how to deploy and maintain assets in Power BI. Through hands-on exercises, you’ll explore the process of creating, implementing, and managing Power BI workspaces.You’ll also implement security and monitoring to protect data in organizations.
- How to create and publish an app in Power BI.
- How to implement dynamic reports in Power BI.
- How to implement security measures and alerting in a Power BI report or dashboard.
COURSE 8
Microsoft PL-300 Exam Preparation and Practice
This course will help you prepare for the Microsoft PL-300 exam. In this course, you’ll refresh your knowledge of all the key areas assessed in the Microsoft-certified Exam PL-300: Microsoft Power BI Data Analyst.
- How to prepare the data with Power BI.
- How to Model the data in Power BI.
- How to visualize and analyze the data with Power BI.
- How to deploy and maintain Power BI assets.
This Bootcamp Is For You If...
- You are interested in a career in data analytics and want to master Microsoft Power BI, one of the leading tools in this field.
- You are seeking practical experience and in-depth knowledge in business analytics, data visualization, and report creation.
- You aim to learn how to prepare data in Excel for analysis in Power BI, using the most common formulas and functions.
- You desire to gain real-world experience through projects that mirror data analysis scenarios in actual business conditions.
- You are determined to obtain a professional certificate from Microsoft and aspire to pass the PL-300: Microsoft Power BI Data Analyst exam.
- You are ready to apply your acquired skills to real-world challenges, preparing yourself for a role as a data analyst in the modern business environment.
NICE TO MEET YOU
LEARN FROM EXPERIENCED DATA PROFESSIONALS
I'm Indrek Andema
PROGRAM MANAGER
He has over 7 years of experience in the field of continuing education and 15 years in the IT field.
He started organising computer training at Gensi Koolitus in 1997, initially as a sales representative and later as a managing director. After that, he continued as a sales manager for computer software training at USEsoft.
Worked in training companies: Mercuri International, MetaProfit. In the latter, he also served as an assistant trainer.
Experience in IT companies: Kungla Dialoog, Business Software Partners, BCS Itera, Konica Minolta, Andmevara AS.
He became more closely involved with data analytics topics at Andmevara AS (Novian Systems), where he led Microsoft PowerPlatform development activities in Estonia.
He obtained his higher education at Tallinn University of Technology in the field of business administration. In addition, he furthered his education in the prerequisites program for a psychology master's degree at the University of Tartu from 2012 to 2015.
In 2017, he completed the Experience advisor Specialist training and has been a member of the Experience advisor Association since 2020.
In 2023, he completed the "Tripod Test Training for HR Managers and Recruiters" and tests and counsels those interested in IT courses.
Excellent course. I was familiar with a good amount of the content, but there was enough that was new that the course was really engaging and interesting. Well structured.
- Steven J. K., Jan 2024
The plain language video teaching examples combined with the exercises, quizzes, and assessments helps to re-enforce the knowledge gained.
To all of the people that make this possible: thank you. I feel that I am on the way to change.
To all of the learners: your courage is calling you and your discipline will be your destiny.
- Derrick W., Sept 2023
If you are an experienced analyst, then this course will be relatively easy to do. If you are new to data analysis, then this course is an excellent place to start learning about the types of visualizations that can be created and how to make those visualizations inclusive to a vast audience.
- Nate F., Nov 2023
Course
2500 €
including VAT
GET STARTED TODAY!
Microsoft Power BI Data Analyst
Professional Certificate
with mentoring sessions
Learning format
Total Training Volume: 280 Academic Hours
Independent Work: 154 hours
This includes time spent on homework and tests.
Mentor Sessions: 26 hours
Interactive sessions with a mentor for guidance and support.
The training is designed for 3 months.
Payment by invoice
Kindly provide your billing information in the comment field during registration. An invoice will be issued within 3 business days after registration for the training.
Before registering for the training, we kindly ask you to familiarize yourself with the curriculum of and terms of the training organization.
By registering for the course, you acknowledge and agree to the terms of use regarding the personal data provided to the Entrepreneurship Center (Ettevõtluskeskus OÜ).
Join us, and transform your enthusiasm for data into a rewarding and successful career.
The world of data awaits, and with the Microsoft Power BI Data Analyst Professional Certificate, you'll be well-equipped to make your mark!