BI Reporting Tools Training

Reporting is an activity which consists of 3 major part, collection of data, processing data to derived at information and displaying the data in a presentable format which is ready to be analyzed. Business Intelligence refers to a set of software application tools which carry out this very specific activity. It collects data from multiple data sources, processes and transforms the data into meaning format and generates reports.

Quality Thought offers the best BI reporting Training program with emphasis on practical application on case studies. Our course curriculum has been prepared by trainers with real-time industry experience with emphasis on multiple tools related to BI reporting and the various functions and functionalities available for effective reporting. The primary objective of the BI reporting training is to help students to learn and master all the tools perfectly and get market ready and achieve their career goals.

Tableau reporting tool is a commonly and most widely used tool for BI reporting. The program helps students master the usage of this tool to carry out ETL activities and develop multiple analytical reports. Real-time case studies are worked on as assignment to enhance the learning.

Power BI is another reporting tool again used for BI reporting. The training ensures the students are comfortable using this tool. Multiple analytical reports and case studies are worked on this tool also.

Quick View is the 3rd reporting tool that is discussed and learned during the program. This again is a very effective reporting tool. The program help student get master at multiple reporting tools to enhance their overall learning experience and have a wider BI reporting skill set.

BI reporting program can be picked up by anyone having good understanding of any programming, knowledge of business application and business process is a added advantage. The course is applicable to:

Graduates/Post Graduates/Fresher
Working IT professional from programming, web development and DBA fields
Software programmers
Business analyst

BI reporting is one of the primary hot skill areas and there is a constant demand for skilled BI report developers. As data warehousing application are increasing across industry domains with more and more organization depending on analytical reports using these kind of tools, the need for BI report developers is on a upward swing.

BI reporting is for people from any background having sound business function knowledge. People from non-programming background exposed to database management and data warehouse can also pick up this program and boost their career prospect.

• Importance of Data
• Why Visual Analysis?
• Why Tableau?
• Tableau Extensions
• Understanding Navigation

• Tableau Desktop
• Tableau Prep
• Tableau Students Edition
• Tableau Server
• Tableau Public
• Tableau Reader
• Tableau Online

• Dimensions
• Measures
• Shelves
• Pills
• Show me
• Data Pane
• Groups
• Sets
• Dashboard
• Worksheet
• Workbook
• Stories

• Types of Data Connections
• Live Connection
• Extract Connection
• What is Extract File

• Data Types
• Data Values
• What is Data Source?
• Connecting to Data Source

• When to use Joins
• Data Blending
• When to use Data Blending
• Joins vs Data Blending
• Custom SQL in Tableau
• Data refresh
• Filtering
• Sorting
• Hierarchies
• Drill down & Roll ups
• Grouping
• Creating Sets
• Working with Sets
• Parameters
• Creating Parameter
• Parameter Controls
• Aggregation

• Charting
• Line Graphs
• Blended Axis
• Dual vs Blended axis
• Horizontal Bar chart
• Vertical Bar Chart
• Stacked Bar Chart
• Pie Charts
• Gantt Charts
• Mapping
• Heat Maps
• Filed Maps
• Geo-Coding
• Formatting
• Advanced Charting
• Water Fall Charts
• Donut Charts
• Funnel Charts
• Lollipops Charts
• Whisker plots
• Scatter plots

• String Calculations
• Date Calculations
• Boolean Calculations
• Functions

• Linear Model
• Logarithmic Model
• Exponential Model
• Polynomial Model

• What is Dashboard?
• Basic Dash boarding
• Advanced Dash boarding
• Formatting
• Actions
• Creating a Story

• Sharing Options
• Tableau Reader
• Tableau Public
• Tableau Server
• Tableau Online

• What is Power BI?
• Power BI Desktop
• Download & Installation
• Power BI in Web Browser

• Power Query
• Power Pivot
• Power View
• Power Map
• Power Q&A

• What is Power Query
• What is Data Mash-up
• Data Mash-Up Engine of Power BI
• Getting Data From Excel
• Power BI Personal Gateway
• Data Sources
• File Sources
• Folder as a Source
• Database as a Source
• Analysis Services Connection
• Get Data From Azure SQL Database
• Azure SQL Data Warehouse Source
• Software as A Source
• Web Source

• Configuration & Installation
• Power Query Versions
• 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
• Tables
• Built-in functions
• Writing Custom Functions
• Generators
• Error handling

• Modelling Data
• Manage Data Relationship
• Optimize Data Models
• What is DAX?
• Data Types in DAX
• Calculation Types
• DAX Functions
• Date and Time
• Time Intelligence
• Mathematical
• Statistical
• Text and Aggregate

• Visualizations using Power BI Desktop
• Custom Visuals
• Formatting Visuals
• Power View for Excel
• Charts, Scorecards using Power View
• Sorting, Filtering, and categorization using Power View
• 3D geo-spatial visualization using Power Map
• Different versions of Power Map

• Why Dashboard?
• Dashboard vs Reports
• Creating Dashboards
• Configuring a Dashboard
• Dashboard Tiles
• Pinning Tiles
• Power BI Q&A
• Insights in Power BI

• What is QlickView?
• Business Intelligence vs ETL tools
• QlickView vs Excel vs SQL
• Download & Installation

• QlikView Sheets
• Logical connections between QlikView sheets
• Adding a QlikView sheet
• Moving a QlikView sheet
• Adding new sheet objects
• Saving, closing and exiting in QlikView

• Loading a CSV File
• Connecting to External Database
• Installing MySQL
• Loading Database Tables
• Associations
• Synthetic Keys
• Resident Loads

• List Boxes and Tables
• Selection and Drill-down
• Locking and unlocking Selections
• Slider/ Calendar Object
• Bookmark object
• Text objects
• Guages
• Charts
• Pie Charts
• Bar Charts
• Line Charts
• Straight Tables
• Pivot Tables
• Table Box
• Expressions
• Calculated Fields
• Joins
• Joins and Keep
• Statistics

• Buttons
• Actions
• Drill-down Field Groups
• Cyclic Field Groups
• Conditional Formatting
• Smart Totals
• Mapping loads
• Columnar Data stores
• Generic Loads
• Exporting from Qlikview

• What is Dashboard?
• implementing Dashboard layouts
• Layout principles

Students can benefit from our State of the art lab infrastructure facilities at all our training centers across the city. Our lab facilities are available through the day on all working days. For our online students, they can connect to our servers and other lab facilities over the internet and practice. These facilities are available 24X7.

If the student misses out of attending any session, he or she can re-attend the session by:
1. Attending the same session in another batch if student is attending classroom based session.
2. For online sessions, recording of the classes can be accessed by the student at all time to help revisit and listen the sessions missed out.

All our trainer are real-time industry experts with minimum of 10+ years of experience. Complete profiles of our trainers are available for review at our center and students are free to come interact with them and know more about them, before enrolling for programs.

All training programs conducted by Quality Thought are available in 3 modes, instructor based classroom programs, instructor based live online training and self-paced video based training. Students can choose

All discounts are subject to case-to-case basis. Please feel free to meet our administration staff to have a better discussion on the same. We do offer a variety of discounts and concession to our students coming in from different backgrounds.

For all corporate training requirements please feel free to get in touch with our administration staff managing corporate marketing and interaction. We have of the finest programs and offer to corporate with best-in-class programs.