Microsoft Power BI Intermediate Course

Intensive practice-based learning, assignments and individual projects will allow you to master the world’s leading analytical platform Microsoft Power BI in just 5 weeks.

5 Weeks

The full duration of the course is 5 weeks, 10 lessons, 2 times a week, 20 hours in total.

No BI Knowledge Required

Participants are not required to have any prior knowledge in BI.

e-Certificate

You will get an e-Certificate upon successful completion.

Our Trainer

The course will be conducted by Microsoft Certified specialist

Mariam Nadiradze

Microsoft Certified BI Specialist

With over four years of experience in the field of Business Intelligence, Mariam brings a wealth of knowledge and practical insights to our courses. Having worked on projects with prominent organizations across various industries, including Central banks, Financial institutions, Retailers, and the Food & Beverage and hospitality sectors, Mariam understands the unique challenges and requirements of each industry.

Money- Back Guarantee

If for any reason you are not satisfied with the course within the first 2 weeks, we will gladly refund your investment.

e-Certificate

Elevate your credentials with our e-certificates upon successful completion of our Power BI certification courses.

Funding Microsoft Certification

Complete both courses and Become one of the TOP 3 students and get funded for the official Microsoft Power BI Data Analyst Exam.

Our Successful Graduates

Why Microsoft Power BI?

Microsoft Power BI is the world’s leading analytics platform among other Business Intelligence tools. Microsoft Power BI is used to find insights within an organization’s data. Power BI can help connect disparate data sets, transform and clean the data into a data model and create charts or graphs to provide visuals of the data. All of this can be shared with other Power BI users within the organization. Power BI can be used to manage all facets of a company, including logistics, human resources, customer relations, financial transactions, sales, market analysis, manufacturing processes, and so on.

what will you study?

  • Power BI basics
  • Power Query
  • Assembling data models
  • Dax programming language
  • Data visualization
See Syllabus

At the end of the course you will be able to:

  • Connect MS Power BI to various data sources
  • Transform data in Power Query
  • Build effective data models
  • Use basic Dax formulas for reports
  • Create interactive reports and dashboards
  • Take the Power BI Advanced Course

syllabus

Meeting Topic
Meeting I – Introduction
  1. Introduction to Power BI as an analytical tool and its interface
  2. Getting to know the structure (data import, modelling, visualisation). 
  3. Introduction, connection and import of data sources (XLSX, CSV, Folders, SQL…). 
  4. Integrating Python and R programming languages ​​into the BI system
  5. Data quality check (Column Quality, Column Distribution, Column Perofile)
Meeting II – Power Query  
  1. Tabular Model 
  2. Data Type Detection/ Using Local
  3. Actions on columns and rows (delete, add, delete errors and blanks, etc.).
  4. Combining columns and data. 
  5. Data transformation tools (Unpivot, Split, Format, Headers and others).
  6. Monitoring changes 
  7. Advanced Editor. 
  8. Add new columns.
Meeting III – Power Query & Model  
  1. Append & Merge data tables. 
  2. Integrating data through a Python script.
  3. Modelling, connection types and their management.
  4.  Star Schema.
  5.  Model View.
Meeting IV – DAX & Measures: Part I
  1. Getting to know the formulas and functions integrated in the system 
  2. Basic elements of the system programming language DAX
  3. Calculated Table VS Calculated Column VS Measure (Quick Measure). 
  4. Aggregation, text and mathematical functions.
Meeting V – DAX & Measures: Part II
  1. Logical operators and functions.
  2. Calculate & Filter functions. 
  3. Date and time functions.
  4. Create/edit custom formulas
Meeting VI – DAX & Measures: Part III
  1. Quick Measures; 
  2. Creating a table of measures
  3. Optimisation of calculations
  4. Hierarchy
  5. grouping
  6. Variable (VAR & RETURN), 
  7. SWITCH function.
  8. Table Calculations
 Meeting VII – Visualization: Part I
  1. Create and add new reports
  2. Creating visuals, and combining them into one page/report.
  3. Overview, construction, and formatting of different types of visuals.
Meeting VIII – Visualization: Part II  
  1. Adding new visuals from Appsource. 
  2. Managing connections between visuals, filtering,
  3. Overview of Sync Slicer, Tooltip, Bookmark, Settings and Drill Through. 
  4. Adding a Navigation Panel.
  5. Change reports
  6. System diagnostics/optimization
Meeting IX – Power BI Service 
  1. Manage and share reports
    • Export data from reports
  2. Introducing the Power BI Service.
  3. Adding individual working environment – Workspace.
  4. Defining a security protocol
    • Differentiate between user roles in Workspace
    • Allocation of rights and access.
    • Database protection and management (Row Level Security). 
  5. Overview of the Report Panel.
    • Share/Embedded Link
    • Bookmark the filtered view 
    • Bookmark sharing 
    • export
    • Write a comment on the visual/report
    • Change view types
  6. Creating a Dashboard.
  7. Adding alerts and subscriptions
  8. Automatic data update (Autorefresh & Data Gateway).
X meeting – summary
  1. Analysis of practical cases
  2. Go through the complete process of creating a report
  3. Best practices for using visualizations in data processing and reporting.
  4. Configuring the function of exporting data from publicly published reports to Excel or CSV format by an unauthenticated user
  5. Administration panel management
  6. Configure the timer for Power BI Service – Month. 

Get up to 15% Discount

Two-part payment available

Standard

GEL 900 GEL 810

For Students

GEL 900 GEL 765

For Organizations

Contact Us

All it takes is your will to level up your skills!

Register

Learn

Take Exam

Certify