img

Crash Course - Microsoft Power BI

This specialized crash course is designed for individuals aiming to achieve expertise in self-service business intelligence using Power BI Desktop & Service. By pursuing these 6 weeks Power BI Internship, you'll gain proficiency in building Advanced DAX (Data Analysis Expressions) skills, and ultimately, excel in the Microsoft PL-300 exam.

Flexible Time

Select your prefer time

Expert instruction

Find the right instructor for you

Real-time projects

Practical & hands-on training

Course Highlights:

img

Live Online Classes

6 Weeks, 1 HR / Day (Mon - Fri)

img

Live Doubt Solving Session

Once in a Week

img

Access Anywhere

Access from Mobile, Laptop / Tablet

img

Lifetime Access of Recordings

Classes recordings to access anytime

img

2 Industry Level Projects

For Live Practice

img

WhatsApp Chat Support

For Communication

img

Industry Relevant Curriculum

For Career Building

img

Earn an Internship Certificate

From Datum Discovery

What You will learn?

  • End-to-End Power BI Project Process: From Scoping to Deployment
  • Effective Communication Techniques for Business Stakeholders
  • Fundamentals of Business Functions: Finance, Sales, Marketing, and Supply Chain
  • Domain Knowledge in the Consumer Goods Industry
  • Cultivating a Problem-Solving Mindset
  • Discover powerful AI tools and advanced techniques for data analysis and visualization.
  • Create professional-quality business intelligence reports from scratch.
  • Transform raw data into stunning, interactive visuals and dashboards.

Upcoming Classes:

Mastering Microsoft Power BI (15 Sep)

  • 1 hour/day
  • (Mon-Fri)
  • Nirmal Pant
Enroll Now

Mastering Microsoft Power BI (01 Oct)

  • 1 hour/day
  • (Mon-Fri)
  • Nirmal Pant
Enroll Now

Mastering Microsoft Power BI (15 Oct)

  • 1 hour/day
  • (Mon-Fri)
  • Nirmal Pant
Enroll Now
We are happy to help you 24/7 on whatsapp Get a Free Chat
img

What are the prerequisites for the course?

  • No Coding Knowledge Required
  • Beginner-Friendly Course
  • No Prerequisites Needed
  • Power BI Desktop, designed specifically for Windows/PC, is regrettably not yet available for Mac users. However, Mac users can still access Power BI through the Power BI Service, provided they have a work or school email address.
  • It's important to note that certain advanced features within the Power BI Service may necessitate a Pro license, which offers a 60-day trial period, following which a monthly subscription fee of $9.99 will apply.

Key Skills Covered:

Power Query

Data Modelling

Working with DAX

Visualizing Data

Power BI Desktop

Power BI Services

What do we offer:

Live learning

Learn live with top educators, chat with teachers and other attendees, and get your doubts cleared.

Structured learning

Our curriculum is designed by experts to make sure you get the best learning experience.

Community & Networking

Interact and network with like-minded folks from various backgrounds in exclusive chat groups.

Learn with the best

Stuck on something? Discuss it with your peers and the instructors in the inbuilt chat groups.

Practice tests

With the quizzes and live tests practice what you learned, and track your class performance.

Get certified

Flaunt your skills with course certificates. You can showcase the certificates on LinkedIn with a click.

Course Curriculum:

6 Modules   |   103 Sessions

  • Course Structure & Outline

  • Introduction

  • Power BI Desktop Installation

  • Data Sources & Visual Types

  • Canvas, Visualizations & Fields

  • Get Data & Memory Tables

  • Tables & Tree Map Visuals

  • Formatting (color, size, label)

  • Change data, background

  • Apply border, Working with data & Tooltip

  • Insert visual, Publish the report & Power Bi architecture

  • Format Button & Data Labels

  • Legend, Category & Grid

  • PBIX & PBIT File Formats

  • Visual Interaction & Data Points

  • Disabling Visual Interactions

  • Edit Interactions (Format Options)

  • CSV & PDF Exports

  • Power BI Ecosystem & Architecture

  • Date Hierarchy, Data Slicers & Table Visual

  • Matrix Visual & Structuring Data

  • Slicer Visual - Real Time Usage

  • Orientation, Selection Properties

  • Single & Multi Select, CTRL Options

  • Slicer – Number, Text & Date Data

  • Slicer List & Slicer Dropdowns

  • Limitations with Slicer

  • Disabling Slicer & Clear Selections

  • Joins – Left Outer & Right Outer Joins

  • Full Outer Joins

  • Grouping

  • Creating Hierarchies in Power BI

  • Drill Down & Drill Up

  • All Filters on Specific Visual

  • Filters: Types and Usage in Real Time

  • Visual Filter, Page Filter, Report Filter

  • Basic, Advanced & Top N Filters

  • Drill Thru Filters

  • Bookmarks: Real-Time Usage

  • Bookmarks for Page Navigations

  • Selection Pane with Bookmarks

  • Buttons, Images with Actions

  • Bookmarks View & Selection Pane

  • Stacked Charts & Clustered Charts

  • Line Charts, Area Charts, Bar Charts

  • Donut Charts & Pie Charts

  • 100% Stacked Bar & Column Charts

  • Map Visuals: Tree, Filled, Bubble

  • Cards, Funnel, Table, Matrix

  • Scatter Charts: Play Axis, Labels

  • Series Clusters & Selections

  • Waterfall Chart

  • Line Chart

  • Funnel Charts & Ribbon Charts

  • Shapes, Markers, Axis, Plot Area

  • Introduction

  • Getting external data into Power BI

  • Power Query Architecture and ETL

  • Data Types, Literals & Values

  • Power Query Transformation Types

  • Table & Column Transformations

  • Text & Number Transformations

  • Date, Time & Structured Data

  • Get Data, Table Creations & Edit

  • Merge & Append Transformations

  • Group BY

  • Transpose, Header Row Promotion

  • Reverse Rows and Row Count

  • Data Type Changes & Detection

  • Replace Columns: Text, Non-Text

  • Replace Nulls: Fill Up, Fill Down

  • PIVOT, UNPIVOT Transformations

  • Move Column and Split Column

  • Extract, Format, and Numbers

  • Date & Time Transformations

  • Deriving Year, Quarter, Month, Day

  • Add Column: Query Expressions

  • Removing Columns and Duplicates

  • Columns From Examples, Indexes

  • Conditional Columns, Expressions

  • Introduction

  • DAX: Importance in Real-time

  • DAX Architecture, Entity Sets

  • DAX Data Types, Syntax Rules

  • DAX Measures and Calculations

  • DAX Operators, Special Characters

  • DAX Functions, Types in Real Time

  • Aggregation functions

  • Date & Time Functions

  • Calendar, CalendarTable Functions

  • LookValue & Related Functions

  • If, AND, OR, NOT Functions

  • CALCULATE & ALL Member Scope

  • Date, Time & Text Functions

  • Introduction

  • Dashboard design

  • Dashboard design and implementation

  • Introduction

  • Connecting to Databases

  • Working with DAX

  • Creating Reports & Dashboards

  • Sharing & Collaboration

Why Choose Datum Discovery as Power BI Provider?

icon

Expertise in Power BI

Datum Discovery specializes in Power BI and has extensive knowledge and experience in using the tool effectively. Their trainers are likely to be well-versed in all aspects of Power BI, including data modeling, visualizations, DAX (Data Analysis Expressions), and data integration.

icon

Customized Training

Datum Discovery is known for providing customized training solutions tailored to the specific needs and skill levels of their clients. They can assess your organization's requirements and design training programs that address your unique business challenges and objectives.

icon

Hands-on Approach

Effective Power BI training should involve practical, hands-on exercises to reinforce the concepts learned. Datum Discovery's training programs are likely to include interactive exercises, real-world examples, and case studies that allow participants to apply their knowledge and gain practical experience in using Power BI.

icon

Comprehensive Curriculum

Datum Discovery's training programs are likely to cover a wide range of topics related to Power BI, ensuring that participants gain a comprehensive understanding of the tool. This may include data preparation, data visualization best practices, advanced analytics, and report sharing and collaboration.

icon

Flexibility in Delivery

Datum Discovery may offer flexible training options, including on-site training, virtual classrooms, or a combination of both. This flexibility allows participants to choose the most convenient and cost-effective training delivery method based on their preferences and organizational requirements.

icon

Ongoing Support

It's always beneficial to research and consider the reputation and reviews of a training provider before making a decision. Look for feedback from previous clients or participants to get a sense of the quality of training and customer satisfaction. Datum Discovery's reputation and positive reviews can provide confidence in their ability to deliver high-quality Power BI training.

This course is designed for individuals in the following categories:

Power BI users who are assigned with the challenge of tackling distinctive and analytical scenarios.

Professionals proficient in Excel aiming to enhance their skill set and transition into a role focused on Business Intelligence (BI).

Power BI users aspiring to excel in the PL-300 Exam and achieve certification as a Microsoft Certified Data Analyst.

Individuals with a background in analytics or data science seeking to acquire skills in designing, constructing, and disseminating professional-grade reports and dashboards using Microsoft Power BI.

Our Testimonials:

Frequently Asked Question:

The Power BI Course is a comprehensive, recorded training program designed to teach users how to effectively use Power BI for data analysis and visualization.

This course is intended for business professionals, data analysts, and anyone interested in learning how to use Power BI to analyze data and create interactive dashboards.

No prior experience with Power BI is required. However, basic knowledge of data analysis and familiarity with Excel can be helpful.

Once purchased, you will have lifetime access to the course materials, including any future updates.

The course covers a wide range of topics including data import and transformation, data modeling, creating and customizing visuals, DAX (Data Analysis Expressions), and sharing reports and dashboards.

Yes, the course can be accessed on multiple devices including desktops, laptops, tablets, and smartphones.

Yes, you can reach out to the course instructors or join the community forum for support and to ask questions.

Yes, the course includes practical, hands-on projects and assignments to help you apply what you’ve learned and gain real-world experience.

Yes, upon successful completion of the course, you will receive a certificate of completion.

Typically, the course videos are not available for download to ensure content protection, but you can access them online anytime through the course platform.

The course is self-paced, allowing you to complete it at your own speed. On average, it takes about 20-30 hours to go through all the materials and complete the hands-on projects.

Absolutely! The skills and knowledge gained from this course will help you prepare for Microsoft Power BI certification exams, such as the PL-300: Microsoft Power BI Data Analyst.

Absolutely! The skills and knowledge gained from this course will help you prepare for Microsoft Power BI certification exams, such as the PL-300: Microsoft Power BI Data Analyst.

You will need a computer with internet access, Power BI Desktop (which is free to download from the Microsoft website), and optionally, Excel for some of the exercises.

Yes, the course covers both Power BI Desktop for creating reports and the Power BI Service for sharing and collaborating on dashboards.

The lessons are structured into modules, each containing video lectures, practical exercises, quizzes, and projects. This ensures a balanced approach to learning both theoretical concepts and practical skills.

If you experience any technical issues, you can contact the course provider’s technical support team for assistance. They are typically available via email or live chat.