SQL Server Reporting Services (SSRS)Training in
Auckland,New Zealand

Learn about implementation of Data conversions, transformations (SSIS), Data ware house creation (SSAS) and analysing the data ware house with MDX/DAX and automation of Reports with SSRS

SSRS Training in Auckland,New Zealand @ 0091 9704077815
Power BI Guru E solutions provides best Power BI Training in Auckland with 100% Real time Live projects , Job Placements , Certification classroom,online,corporate training’s in Auckland,New Zealand.

Key Features

25 hours of Instructor-led training classes
Create dashboards with Quick Insights
Transform data for analysis and create effective data views
Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
Creating calculated columns and measures and build relationships between different tables
How to create a report with different interactive visualization types
Learn how to use Power BI service to create dashboards and to share and publish your results
How to access your results from multiple devices using Power BI Mobile


Power BI Training

Visualization of data is key to deriving useful insights from a business perspective. While there are many tools for this purpose, Power BI has been gaining popularity for offering cutting edge tools that help transform an organisation’s data into rich visuals and offer a panoramic view of the business to users helping them gauge updates in real time. The Power BI dashboard can run on multiple devices and helps organise data into trans formative visuals.

Zeolearn Academy brings you a comprehensive Power BI training course that is a perfect introduction for you into the world of BI. You will learn the basics of Power BI such as the Power BI desktop, and how to connect to data using Power BI desktop. Our expert trainers will then familiarize you with the rich components that drive this tool such as Modelling, Visualizations, exploring data with the dashboard, working with Excel, publishing and sharing data and the DAX functionality. Enrol for the Power BI course now and master the powerful capabilities of BI. Moreover, you will get access to the reference materials after registering.

What you will learn from our workshop:

  • About BI and how it will transform data and business
  • About the Power BI desktop and managing and utilizing data with it
  • Connecting data from different sources and data modelling with Power BI desktop
  • How to custom create data visualizations and style reports for lucid data representation
  • The working of Power BI and Excel
  • How to share and collaborate with data with Power BI
  • Power BI Data Analysis Expression(DAX), and its functions

Is this course right for you?

This Power BI certification course is ideal for people who have to work with data and also developers, Business analysts, project managers and other IT professionals.


Participants are expected to have an understanding of how data works and how it can contribute to building a business to attend the Power BI training classes.

Training Highlights:

Understand Complete SSRS Life cycle
SSRS Report Server Installation and Configuration
Design, develop, format and manage reports
Create reports using Wizard, Report Designer, Report builder
Knowledge of Table, Matrix, List, Image, Textbox, Line, Chart, Gauge, Data bar
Enhance report with formatting, grouping, summarizing data, expressions
Sub-reports, Drill down reports
Deploy, publish the reports to Report Server URL and Report Server database.
Configuring Data source, Data Set properties
Build your own real-world applications using this SQL Server Reporting services

Pre-requisite: Student should have minimum knowledge on SQL database.

Module 1:- SSRS Introduction

What is SSRS
Advantages of SSRS
SSRS Life Cycle
Report Server Database
Report Designer and How to design Report
Report Server Configuration
Report Builder Vs Report Designer

Module 2:- Creating Reports

Steps for Creating Report Project
What is Data Source
How to give Connection to the Data base
What is Data Set and Data Set Fields
How to Create Reports using Wizards
How to generate Table and Matrix Report

Module 3:- Working with Tablix

What is Tablix and its usage
What is Table and Matrix
How to Add Image and taking action on image click in Table
How to Add Rectangle, Line in Table
What is Expression and How to use Expression
How to Add Table, Footer row
How Add textbox, Align text in textbox
What is Grouping and Drill Down in Table
How to Create Row Groups and Column Groups in Matrix
How to add subtotal for Column and Row Groups
What is List and its usage
Difference Between List, Table and Matrix

Module 4:-Working with Parameter

Parameters in SSRS and its usages
How to use Dataset for Report parameter values
How to sort the data by using parameter
How to filter the data by using parameter
What is Drill through Report and sub Report?
Difference between Drill through Report and sub Report

Module 5:- Data Visualization

Chart Visualization and its usage
Data Bar Visualization and its usage
Gauge Visualization and its usage
Sparkline Visualization and its usage

Module 6:- Report Configuration and Deployment

Reports Deployment
Configuring the Data Source and Data set
Deploying report using report manager
Linked Report, Parameters in Reports and Queries
Different types of Subscription

Upcoming Events

Power BI Job Support(SQL Serevr/MSBI/Power BI)SrinivasTBDTBD22 days/Pm1000 USDOnlineEnquire
Power BI For Business users /excel usersSrinivas12 july 198 AM8600 USDOnline/1-1/weekendEnquire
Power BI For Business users /excel usersSrinivas19 july 198 AM8600 USDOnline/1-1/weekendEnquire
Power BI For developersSrinivas10 july 198 Pm151000 USDOnline/1-1/weekendEnquire
Power BI For developersSrinivas13 july 198 AM151000 USDOnline/1-1/weekendEnquire
Power BI For Job seekers Srinivas10 july 198 Pm251300 USDOnline/1-1/weekendEnquire
Power BI For Job seekers Srinivas13 july 198 Pm251300 USDOnline/1-1/weekendEnquire

What are the differenyt sources that you worked on ?

SQL Server 
Tabular SSAS

What is the differeces b/w direct query/importing/live connection?

Import: we will load the data & craete a model in power Bi 
Direct query:we will load the structure of the tables & create a relation ships in power Bi file by keeping the data at database.we always access the data directly from source
Live connection: we will keep the data & model away from power Bi service,this can be reusable in mul

What is the difference b/w calculated column/measure?

calculated column/computed/derived column which is created based on existing column
with the help of operators & functions .
-->whenever we perform the data refresh automatically this column gets the data
-->It will store the data in the model
--->it will occupy the emory 
--->It is faster 
-->it is static
-->it is unique at table level
-->for text/date related data types we can use
-->numeric columns for intermediate calculations we can use it 

--->It is a formula stored in a model
--->Whenever we used a measure at that time 
it wil get calculated
--->It will not store any data,it will not occupy any memory 
-->It will impact the performance 
--->It is unique at model level
-->It is dynamic

What are the different types of filters?

Page level
Visual level
Report level