Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




Microsoft Business intelligence

This web-based training course on Microsoft Business intelligence functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.

With the world moving towards data driven, factual decision making processes, it has become increasingly essential that data manipulation and storage is done in an extremely smart manner for creating outputs. Data warehousing and business intelligence technologies do this job to provide such methodologies and decision making processes. Microsoft Business Intelligence comprises of a number of tools integrated in the Microsoft suit such as SQL server integration services, SQL server analysis, SQL server reporting services and others. These tools are used to develop and create extremely robust and effective end-to-end business intelligence solutions.


The training program provides comprehensive understanding in various MSBI concepts such as ETL, SSIS , SSAS, SSRS with SQL server 2014 and SQL server data tools 2013 as the tool of implementation. There is no pre-requisite for the course but a basic understanding of relational database management systems will be highly beneficial for students to keep pace with the course.


Introduction to Power BI

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You'll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View , Power Map, and Power Q&A

Getting Data

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data From Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data From Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

Power Query for Data Transformation

  • Installation, Requirements, and Configuration
  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Trans formations with M

Power Pivot for Data Modelling

  • Power Pivot x Velocity engine basics and concepts
  • Different versions of Power Pivot
  • Relationships in Power Pivot
  • Best practices
  • Introduction to DAX
  • Calculated Members
  • Row Context vs Set Context
  • Advanced calculation s using Calculate functions
  • Time Functions
  • DAX Advanced
  • Power Pivot embedded in Power BI Desktop

Data Visualization wit h Power BI Desktop, Power View and Power Map

  • Data Visualization Best Practices
  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Power View for SharePoint
  • Power View for Excel
  • Charts, scorecards, and other visualization items in Power View
  • Sorting, Filtering, and categorization with Power View
  • Best Practices to work with Power View
  • 3D geo-spatial visualization wit h Power Map
  • Different versions of Power Map
  • Best Practices to work with Power Map

Designing the best solution with Power Q&A

  • Power Q&A introduction
  • Design best practices for Power Q&A

Power BI Desktop; combination of three tools

  • Power BI Desktop Introduction
  • Getting data from different data sources
  • Differences of Power Query stand-alone with Power Query in Power BI Desktop
  • Modelling data, and relationships
  • Creating calculated measures
  • Power Pivot difference in Power BI Desktop
  • Visualizing data in Power BI Desktop
  • P overview difference in Power BI Desktop
  • Best practices of designing solutions with Power BI
  • Custom Visuals for Power BI Desktop

Administration

  • Power View for SharePoint Administration
  • Office 365 Administration
  • Deployment of files in to Power BI website
  • Building dashboards in Power BI website
  • Mobile app s for Power BI on Apple, Android, and Windows Phone
  • Configuration and administration on Power BI website

Microsoft BI is currently the leader in providing smart Business Intelligence solutions using its user friendly and cost effective MSBI suit. It helps the organizations to get a wider view of their businesses thus implementing smart business models. Consequently, MSBI expertise has high potential in terms of career and job prospects. The course comes highly recommended for software and analytics professionals who have a background of RDBMS, ETL, OLAP, etc. The course will go a long way in safe guarding your career and pushing it to the levels you deserve.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright© 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.