Curriculum


• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources

• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships

• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations

• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report

• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions

• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features

• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters

• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

• Fundamentals of Data Warehousing
• Concepts of Dimensions, Measures, Metadata and Schemas
• Data Marts and Design approaches
• Normalization and Denormalization and Schema types
• Concepts of Online Analytical Processing and Transactional Processing
• OLAP Cube
• Explain ETL process and various tasks involved in it
• Slowly Changing Dimensions Types
• Business Intelligence Concepts
• Working of BI with data-warehouse

• Understanding of the MSBI Architecture
• Import and Export wizard
• Understand SSIS Architecture
• Control Flow and its Components (Tasks, Containers and Precedence Constraints)
• Data Flow and its Components (Source and Destination Connections and types of Transformations)
• System Variables and User-defined variables
• Scenarios by combining Control Flow and Data Flow components
• Hands On

• Data Conversion transformation
• Multicast transformation
• Union all transformation
• Conditional Split Transformation
• Merge and Merge Join Transformation
• Lookup transformation
• Cached Lookup transformation
• Foreach loop and use-cases
• Bulk-insert task
• Archival process using dynamic variables and FST
• Advancing Execute SQL Task with Object return type
• Types of Outputs usage
• Hands On

• Understanding data that slowly changes over time
• Learning the process of how new data is written over old data
• Detail explanation of three types of SCDs –Type1, Type2 and Type3, and their differences
• Hands On

• Concept of Fuzzy matching
• How Fuzzy Lookup Transformation varies from Lookup Transformation
• Hands On

• Learning about error rows configuration
• Package logging
• Defining package configuration
• Understanding constraints and event handlers
• Hands On

• Introduction to SSAS
• SSAS Architecture
• Features of SSAS
• Modelling in SSAS
• Tabular Model and Multidimensional Model
• Data Sources and Data Source Views
• Fact and Dimensions
• Designing Dimensions
• Dimension Hierarchies
• Designing Measure Groups
• Attribute Relationships

• Various operations on Cube
• Limitations of OLAP Cubes
• Cube and In-memory Analytics
• Architecture of In-memory analytics and its advantages
• Understanding How in-memory analytics works
• Deploying cube to get self-service business intelligence with existing data warehouse capabilities
• Hands On

• Overview of the Dimensions concept
• Describing the Attributes and Attributes Hierarchies
• Understanding Key and Value Pairs
• Metadata Reload, logical keys and role-based dimensions
• Hands On

• Measures of Cube and analyzing the Measures
• Exploring the relationship between Measure and the Measure Group
• Features of Cube and Dimension usage
• Deploying actions and drill-through actions on data
• Understanding the Key Performance Indicators
• Working with data partitions, aggregations, translations and perspectives
• Hands On

• SSAS Deployment
• Database deployment methods
• Aggregation, KPIs, Actions, Perspectives, Translations
• Named Calculations and Named queries
• Cube Processing
• Different Processing Options
• Explain MDX and DAX Queries
• Performance Optimization of cube and Dimension, Best Practices
• Loading Data into DW using SSIS, MDX queries and DAX Queries
• Schedule the Cube processing
• Hands On

• Understanding SSRS Architecture
• Learning the data flow in different components
• SSRS Report Building tool components

• Understanding the concepts of Matrix and Tablix
• Working with Text Box, learning about formatting, row and column grouping
• Understanding sorting and formatting
• Concepts of Header, Footer, Totals, Subtotals and Page Breaks
• Hands On

• Learning about Parameters, filter and visibility expression

• Reporting Services Architecture & Lifecycle
• Report Parameters and Multi-Valued
• Cascaded Parameters
• Types of Reports: Parameterized, Linked, Snapshot, Cached, Ad hoc, Clickthrough, Drillthrough, Subreports
• Creating Groups, Filters, Expressions Sort and Interactive Sort, Alternate Row Colors, Repeating Row

• Describe Mobile report publisher
• Exporting Reports to different formats
• Hands On

• Understanding Report Cache
• Authorization, Authentication and Report Snapshot
• Subscriptions and Site Security
• Hands On

Training Options

Self-Paced Learning

20,899.00 13,999.00
  • Learn at your convenient time and pace
  • Gain on-the-job kind of learning experience through high quality Videos built by industry experts.
  • Interactive Sessions as good as Classroom experience.
  • Learn end to end course content that is similar to instructor led virtual/classroom training.
  • Cost Effective as well as Convenient.

Blended Learning

  • Everything in Self-Paced Plus
  • Learn in an instructor-led online training class

Corporate Training

Customized to your team’s needs

  • Customized learning delivery model (self-paced and/or instructor-led)
  • Flexible pricing options
  • Enterprise grade learning management system (LMS)
  • Enterprise dashboards for individuals and teams
  • 24×7 learner assistance and support

Course Description

Power BI Training

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

What you will Learn in this Course?

  • Introduction to Microsoft Power BI
  • Key features of Power BI workflow
  • Power Query for Data Transformation
  • Filters and Drill Down Report
  • Power Pivot for Data Modelling
  • Data Analysis Expression – DAX Queries
  • Power BI Desktop & Administration
  • Introduction to Power Q & A
  • Preparing for Microsoft 70-778 Analyzing and Visualizing Data with Microsoft Power BI exam.

Microsoft BI Course Training

Tecklearn’s Microsoft Business Intelligence Training makes you master Business intelligence and data mining tools. It will help you master MSBI concepts such as SSIS, SSRS and SSAS using SQL Server 2016 and SQL Server Data tools 2015. Microsoft BI Certification Course is designed to provide insights into different tools in Microsoft BI Suite like SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services. This MSBI training will also help you clear the MCSE: Business Intelligence Certification. As part of this training, you will learn data integration and creation of reports, dashboards, and cubes for faster reports generation.

What you will Learn in this Course?

  • Introduction to Microsoft Business Intelligence and Data Warehousing
  • Transformations and Use-Cases
  • Concepts of Logging & Configuration
  • Concepts of Multidimensional Modelling, ETL, and Transformations in SSIS
  • Cube: Operations and Limitations and Dimensions
  • SSIS, SSAS, and SSRS architecture and their components
  • Building and creating charts, reports, and dashboards with SSRS
  • Matrix and Tablix Overview, Parameters and Expression
  • SSRS Reporting
  • Preparing for MCSE: Business Intelligence Certification Exam

Key Features

Self-Paced Online Video

• Self-paced Videos: 52 Hrs
• Exercises & Project Work: 96 Hrs
• A 360-degree learning approach that you can adapt to your learning style

1 Year Unlimited Access

You get 1 Year unlimited access to LMS where presentations, quizzes, installation guide & class recordings are there.

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket-based tracking system

Certification

Successfully complete your course and Tecklearn will provide you Course Completion Certificate.

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various Microsoft BI and Power BI concepts.

Learn at your Convenience

• Certification and Job Assistance
• Flexible Schedule

Reviews

M

Mani M

Microsoft Business Intelligence Tools - Microsoft BI and Power BI Combo Training

Excellent curriculum and learning method online . Also appreciate for quick help and co-ordination with Tecklearn Team . Looking forward for better learning experience with latest technologies... Excellent curriculum and learning method online . Also appreciate for quick help and co-ordination with Tecklearn Team . Looking forward for better learning experience with latest technologies Read More
G

Govindaraj

Microsoft Business Intelligence Tools - Microsoft BI and Power BI Combo Training

It's one of the most decent options available for affordable professional courses which most of us look for improving our skill set in today's competitive world. I attended a BI course and the instructor was quiet knowledgeable and course was well paced and informative.... It's one of the most decent options available for affordable professional courses which most of us look for improving our skill set in today's competitive world. I attended a BI course and the instructor was quiet knowledgeable and course was well paced and informative. Read More
G

Gowry Sankar S

Microsoft Business Intelligence Tools - Microsoft BI and Power BI Combo Training

Excellent curriculum and learning method online . Also appreciate for quick help and co-ordination with Tecklearn Team . Looking forward for better learning experience with latest technologies... Excellent curriculum and learning method online . Also appreciate for quick help and co-ordination with Tecklearn Team . Looking forward for better learning experience with latest technologies Read More
A

Arun Krishna Murthy

Microsoft Business Intelligence Tools - Microsoft BI and Power BI Combo Training

Microsoft BI course was interactive and knowledgeable Sessions, Smart eBooks is really good and course content are well documented... Microsoft BI course was interactive and knowledgeable Sessions, Smart eBooks is really good and course content are well documented Read More
N

N Bhaskara

Microsoft Business Intelligence Tools - Microsoft BI and Power BI Combo Training

Tecklearn team is the best. I love the format and logistics of Tecklearn so much that I would chose them for future courses at any cost rather than take anything else. Awesome guys.... Tecklearn team is the best. I love the format and logistics of Tecklearn so much that I would chose them for future courses at any cost rather than take anything else. Awesome guys. Read More

Certification

This course is designed for clearing the following Certifications:

  • MCSE: Business Intelligence Certification exam.
  • Microsoft 70-778 Analysing and Visualizing Data with Microsoft Power BI exam.

As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly. Tecklearn’s Course Completion Certificate for the courses included in this combo course will be awarded upon the completion of the course.

Projects

  • To put your knowledge on into action, you will be required to work on various industry-based projects that discuss significant real-time use cases.
  • These projects are completely in-line with the modules mentioned in the curriculum and help you to clear the certification exam.

FAQ Content


You will never miss a lecture at Tecklearn. Tecklearn provides recordings of each class so you can review them as needed before the next session.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover, the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

All the instructors at Tecklearn are practitioners from the Industry with minimum 10-15 years of relevant IT experience. Each of them has gone through a rigorous selection process that includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating remain on our faculty.

Learning pedagogy has evolved with the advent of technology. Online training adds convenience and quality to the training module. With our 24x7 support system, our online learners will have someone to help them all the time even after the class ends. This is one of the driving factors to make sure that people achieve their end learning objective. We also provide life-time access of our updated course material to all our learners.

Tecklearn actively provides placement assistance to all learners who have successfully completed the training. We also help you with the job interview and resume preparation part as well.
ENROLL NOW
  • 20,899.00 13,999.00
  • 10 years, 1 month
  • Course Certificate
56 STUDENTS ENROLLED

Contact Us

Contact Us

Course Curriculum

No curriculum found !

Related Courses

TRENDING COURSES

X