- Personalized 1 to 1 Interactive Program – 99 $ / Hour
- Classroom training - Online Interactive with the batch size of 15 to 20 People
Instructor with over 20 years of experience and prior training.
25-hour Power Bi course with simple case studies and examples.
The Power BI certification program from TEAM Academy can help you develop Business Analytics expertise.
You'll learn about Power BI Desktop, Structure, DAX, Services, Mobile Applications, Reports, and Q&A using real-world applications.
This live Power BI training ensures that you get hands-on experience working on real-world projects.
Individualized help is provided by the Trainer.
Microsoft is recognized as a leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 12 consecutive years.
Easily generate business information reports from the ground up.
Blend and convert raw data to create appealing interactive dashboards.
Create and implement artificial intelligence approaches similar to those used by professional analysts and data scientists.
You will be able to exhibit your expertise through two full-scale course projects (with step-by-step solutions).
Recognize the complete business intelligence process.
Module 1 : Introduction to POWER BI Desktop ( Class 1 )
1.1 Introduction to Power BI DETAILS
1.2 POWER BI – tools & connecting with other apps
1.3 Downloading Power BI & Adjusting Settings
1.4 Exploring the Power BI Desktop Interface & Workflow
1.5 New Power BI Ribbon & other helpful resources
Module 2 : Data Transformation ( Class 2 )
2.1 Types of Data Connectors in Power BI Desktop
2.2 The Power BI Query Editor
2.3 Basic Table Transformations in Power BI
2.4 Power BI Demo: Working with Text Tools
2.5 Power BI Demo: Working with Numerical Values
2.6 Power BI Demo: Working with Date & Time Tools
2.7 Creating a Rolling Calendar in Power BI Desktop
2.8 Generating Index & Conditional Columns
2.9 Grouping & Aggregating Records
2.10 Pivoting & Unpivoting Data
2.11 Appending Queries in Power BI Desktop
2.12 Configuring Power BI Data Source Settings
2.13 Configuring Power BI Query Refresh Settings
2.14 Data Types & Categories in Power BI
2.15 Defining Hierarchies in Power BI Desktop
2.16 Importing Models from Excel to Power BI
2.17 Power BI Data Connection Best Practices
Module 3 : Creating Table Relationships & Data Models in Power BI ( Class 3 )
3.1 What is a “Data Model”?
3.2 Principles of Database Normalization
3.3 Understanding Data Tables vs. Lookup Tables
3.4 Understanding Table Relationships vs. Merged Tables
3.5 Creating Table Relationships in Power BI Desktop
3.6 Managing & Editing Table Relationships in Power BI Desktop
3.7 Managing Active vs. Inactive Relationships
3.8 Understanding Relationship Cardinality
3.9 Connecting Multiple Data Tables in Power BI Desktop
3.10 Understanding Filter Flow
3.11 Hiding Fields from the Power BI Report View
3.12 Power BI Desktop “Model” View
Module 4 : Analyzing Data with DAX Calculations in Power BI ( Class 4 )
4.1 Intro to DAX Calculated Columns
4.2 Intro to DAX Measures
4.3 Calculated Columns vs. DAX Measures
4.4 Adding Columns & DAX Measures in Power BI Desktop
4,5 Filter Context Examples in Power BI
4.6 Understanding DAX Syntax & Operators
4.7 Common DAX Function Categories
4.8 DAX Demo: Basic Date & Time Functions
4.9 DAX Demo: Conditional & Logical Functions (IF/AND/OR)
4.10 DAX Demo: Common Text Functions
4.11 DAX Demo: Other Useful Functions
Module 5 : Visualizing Data with Power BI Reports ( Class 5 )
5.1 Exploring the “Report” View in Power BI Desktop
5.2Adding Simple Objects to the Power BI Report Canvas
5.3 Inserting Basic Charts & Visuals in Power BI
5.4 Power BI Report Formatting Options
5.5 Power BI Report Filtering Options
5.6 Power BI Demo: Exploring Data with Matrix Visuals
5.7 Power BI Demo: Filtering with Date Slicers
5.8 Power BI Demo: Showing Key Metrics with Cards & KPI Visuals
5.9 Power BI Demo: Inserting Text Cards
5.10 Power BI Demo: Visualizing Geospatial Data with Maps
5.11 Power BI Demo: Visualizing Data with Treemaps
5.12 Power BI Demo: Showing Trends with Line & Area Charts
5.13 Power BI Demo: Adding Trend Lines & Forecasts
5.14 Power BI Demo: Goal Pacing with Gauge Charts
5.15 Editing Power BI Report Interactions
5.16 Power BI Demo: Adding Drill through Filters
5.17 Testing Scenarios with “What-If” Parameters
Module 6 : POWER BI Desktop - Administrative settings ( Class 6 )
6.1 Managing & Viewing Roles in Power BI Desktop
6.2 Custom Power BI Visuals (Log-in Required)
6.3 Designing for Phone vs. Desktop Report Viewers
6.4 Publishing to Power BI Service
6.5 Power BI Data Visualization Best Practices
Q : When does the workshop start and what are the timings?
A : You can get all the details related to the timings and dates of the workshop at the top of the page , by clicking View Schedule
Q : Will this be live or pre-recorded?
A : It's going to be a completely live interactive session with options to clarify any doubts or questions that you may have , However just to support your continued learning , we also grant access to the recorded video lectures in our LMS portal.
Q : I made the payment but didn't receive any confirmation email.
A : Write to firstname.lastname@example.org and our awesome support team will solve your queries in the fastest time possible.
Q : Since the workshop is live, will you be sharing recordings?
A : Yes , we will be sharing recordings. Since it's a live workshop, it's expected that each participant will attend the workshop live. Also, recordings of a live session are just boring.
Q : Can I get a refund?
A : No. We don't provide refunds in any case. If you are not sure about the workshop, check out the testimonials, read more about the trainer and take an informed decision. In case you miss out on attending the live workshop, we can move you to the next batch only ONCE.
Q : When can I receive the bonuses?
A : After the workshop is done, you will receive all the bonuses within 48 hours.
Q : Will I get a certificate after completion?
A : Yes, you will receive a certificate of completion if you finish the entire workshop , This certificate carries the PMI logo and it is pre-approved by PMI for applying your PMP Exam.
Q : Can I take this course online?
A : Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available in class and live online.
Q : I’m a project manager. How can I benefit from this class?
A : This course can help both new and experienced project managers use Microsoft PowerBi to successfully implement project management best practices, including developing business critical dashboards for executives, management and working group to understand the logic and sense behind the data.