Empire Data Systems

SQL Server BI (SSIS, SSRS, SSAS & Power BI) Training (Online)

By Sruthi, SQL Server BI Architect!!! (*****)

Course Description

Our Microsoft Business Intelligence (MSBI) training enables you to master MSBI tools like SSIS, SSRS, SSAS, and Power BI using SQL Server. As part of this training, you will learn data integration and creating reports, dashboards, and cubes for faster reports generation.

SSIS: In the SSIS part of the training, you gain the skills to improve business intelligence capabilities by automating complex migration tasks and auditing the success or failure of migration processes. You will learn to transform data among heterogeneous data sources — such as text files, Oracle, Access, XML, ODBC and OLE DB — and effectively and securely managing data migration across various platforms.

SSRS: In the SSSR part of the training, you learn how to implement a SQL Server Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

SSAS: In the SSAS part of the training, you learn how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups.

Power BI: In the Power BI part of the training, you access data from a wide range of data sources and create Reports using the in-built visuals. You will also learn to format those visuals for maximum effect and import custom M visuals to extend your reporting capability. You will gain expertise in DAX languages and then publish your masterpiece to a workspace in the Power BI Service, creating Dashboards, sharing Reports and Dashboards with colleagues, concluding with scheduling a data refresh.

For course details and registration, please get in touch with Daniel at +1 267 718 1533 (Mobile & Whatsapp). We are based in Philadelphia, USA, and host affordable and comprehensive SQL Server/Azure/AWS/DevOps training programs for students around the globe.

DOWNLOAD COURSE CONTENT

Student Demographic

Course Introduction Video

Course Information

Sruthi's Profile

Sruthi is a highly qualified consultant offering close to 16 years of rich & qualitative experience executing full-cycle Data Warehouse (DWH) & Business Intelligence Projects for companies within several industries. As a Senior Consultant, Sruthi is responsible for end-to-end MSBI solution architecture, delivery oversight, and quality assurance across client verticals. With close to 16 years of experience as a technical architect, she offers competencies across all functional data management components, including ETL processing, data persistence, data visualization, and information distribution. Sruthi has worked with some of the major Telecom, Manufacturing, and IT firms. Sruthi has worked with critical business units in areas such as quality, supply chain, reliability, finance, HR, and engineering. Aside from conducting activities as a technical architect, she has spent much of her career establishing and facilitating custom developer training programs and mentoring less experienced team members and consultants.


Talk to Sruthi

Live Training Videos

We believe in letting our prospective students to watch recorded videos of our live training classes and decide for themselves. If you would still like to attend a one-on-one live demo session, please give call Daniel @ 267 718 1533 and he can schedule one for you at your convenience.

Course Content

Part 1: Power BI - Data Visualization, Dashboard, and KPIs

Module 1: Introduction to Power BI
  • Introduction to business intelligence (BI)
  • Stages of business intelligence (BI)
  • Use cases of BI
  • Various BI tools
  • Overview of data warehouse and concepts
  • Introduction to Power BI
  • Why Power BI?
  • Power BI components
  • Power BI pricing structure
  • Building Blocks of Power BI
  • Architecture of Power BI
  • Power BI vs. Tableau vs. QlikView
  • Introduction to Power BI Desktop
  • Installation of Power BI Desktop
  • The key features of Power BI workflow
  • Process of creating reports in Power BI
Module 2: Data Extraction
  • Overview of Power BI Desktop
  • Data sources in Power BI
  • Using files (excel, pdf, csv, etc.) as a data source
  • Using SaaS connectors
  • Extracting data from folders and databases
  • Working with Azure SQL database and database sources
  • Connecting to Analysis Services
  • Other data sources (OData, web, SharePoint, etc.)
  • Python R script in Power BI
  • Introduction of power query editor
  • Advance editor
  • Query dependency editor
Module 3: Data Transformation – Shaping and Combining Data
  • Shaping data using Power Query Editor
  • Formatting data
  • Transformation of data
  • Understanding of Data types
  • Data profiling for data quality check
  • Naming conventions and best practices to consider
  • Identify and create appropriate keys for joins
  • Working with Parameters
  • Merge Query
  • Append Query
  • Group by of data (aggregation of data)
  • Applied steps (query settings)
  • Duplicate and reference tables
  • Transpose of data
  • Fill
  • Pivot & Un-pivot of data
  • Custom columns
  • Conditional columns
  • Replace data from the tables
  • Split columns values
  • Move columns and sorting of data
  • Detect data type, count rows, and reverse rows
  • Promote rows as column headers
  • Hierarchies in Power BI
  • M query
Module 4: Data Modelling and DAX
  • Introduction to relationships
  • Creating relationships
  • Cardinality
  • Cross-filter direction
  • Use of inactive relationships
  • Introduction of DAX
  • Why is DAX used?
  • DAX syntax
  • DAX functions
  • Context in DAX
  • Calculated columns using DAX
  • Measures using DAX
  • Calculated tables using DAX
  • Learning about tables, information, logic, text, iterator
  • Time intelligence functions (YTD, QTD, MTD)
  • Cumulative values, calculated tables, and ranking and rank over groups
  • Date and time functions
  • Identify poorly performing measures, relationships, and visuals
  • DAX advanced features
Module 5: Data Visualization with Analytics
  • Deep dive into Power BI data visualization
  • Understanding Power View and Power Map
  • Data visualization techniques
  • Page layout and formatting
  • Power BI Desktop visualization
  • Formatting and customizing visuals
  • Visualization interaction
  • Custom visualization in Power BI
  • Top-down and bottom-up analytics
  • Drill down
  • Drill through
  • Page navigations
  • Bookmarks
  • Selection pane to show/hide visuals
  • Comparing volume and value-based analytics
  • Combinations charts (dual axis charts)
  • Filter pane
  • Slicers
  • Use of Hierarchies in drill-down analysis
  • Theme for corporate standards
  • Power BI template for design reusability
  • Mastering the best practices
  • Performance analyzer in Power BI for monitoring the performance of the report
  • Power BI Q&A (Natural Language Query visual)
  • Sync slicers
  • Tooltips and custom tooltips
  • Tables and matrix
  • Conditional formatting on visuals
  • Waterfall chart, KPI, Donut chart, Scatter chart
  • Geographical data visualization using Maps
Module 6: Power BI Service (Cloud), Q & A, and Data Insights
  • Introduction to Power BI service
  • Introduction of workspaces
  • Dashboard
  • Creating and configuring dashboards
  • Dashboard theme
  • Reports vs Dashboards
  • Building workspace apps
  • Sharing reports and dashboards
  • configure subscriptions and data alerts
  • Paginated report
  • Introduction to Power Q & A
  • Ask questions about your data using natural query language
  • Getting answers in the form of charts, graphs, and data discovery methodologies
  • Configure custom questions for Q&A like FAQ
  • Ad-hoc analytics building
  • Power Q&A best practices
  • Quick Insights
  • Subscribe, alerts, usage statics, related content
  • Design reports on the Power BI service
  • Collaboration using Power BI service
  • Row-level security (RLS)
  • Introduction of paginated reports
  • Introduction of Power BI report server
Module 7: Power BI Settings, Administration, and Direct Connectivity
  • Understanding Power BI desktop settings
  • Aggregating data from multiple data sources
  • Power BI service settings
  • Power BI admin portal
  • Administration activities
  • Power BI usage analysis
  • Introduction of Office 365 admin activities
  • Introduction of Data Gateway
  • Installation and configuration of data gateways
  • Scheduling auto data refresh
  • Managing groups, row-level security, datasets, reports, and dashboards
  • Real-time data analysis using direct connectivity
  • Direct query vs import mode
Module 8: Embedded Power BI with API and Power BI Mobile
  • Introduction to embedded Power BI
  • Create embedded code
  • Manage embedded code
  • Integration of Power BI in SharePoint
  • Introduction of Power BI API
  • Power BI embedded playground
  • Introduction to Power BI Mobile
  • Creating mobile-based reports and dashboards
  • Optimizing report for Power BI mobile app
  • Features of Power BI mobile app
  • Introduction of integrating Power BI & Excel
  • Power BI Analyze in Excel
Module 9: Power BI Advance and Power BI Premium
  • Advance Power BI and Power BI Premium.

Part 2: SQL Server 2022 Reporting Service (SSRS)

Module 1: Introduction To SSRS & Usage
  • SSRS Architecture and Tools
  • Three-Phase Report Life Cycle
  • Reporting Services Configurations
  • Report Server Database and TempDB
  • SSRS 2012 and Web Service URLs
  • SSRS 2014 and Web Service URLs
  • Communication Ports & Encryptions
  • Execution Accounts and Usage
  • Report Designer Usage and Scope
  • Report Builder Usage and Scope
  • Report Manager and Options
  • RSCONFIG Tool and Limitations
Module 2: Report Planning and Design
  • SSRS Report Authoring Options
  • Data Sources (RDS) Connections
  • Credentials and Security Options
  • Toolbox Items and Dataset Options
  • Table Reports and Matrix Reports
  • Report Images, Textbox and Globals
  • Dynamic Expressions and Options
  • Reporting Functions and Formatting
  • Report Headers and Report Footers
  • Enterprise and Ad-hoc Reports
Module 3: Report DataSets and Joins
  • Working with Multiple DataSets
  • Joining Local and Shared Datasets
  • Configuring Dynamic DataSets
  • Working with Remote Datasets
  • Reusing XML and Shared Datasets
  • Dataset Import Options in RDL
  • LOOKUP Functions – Limitations
  • Sub-Reports and Report Actions
  • Joining Rectangle & List Reports
Module 4: Report Design and SubReports
  • Designing Wizard-based Reports
  • Custom Reports and Report Groups
  • Row Drilldown and Column Grouping
  • Advanced and Static Options in SSRS
  • Chart Reports and Images
  • Using SSRS Expressions & Globals
  • Accessing and Controlling Reports
Module 5: Report Parameters & Usage
  • Report Parameters & Properties
  • Dynamic Report Parameters and Filters
  • Dependent Parameters & Usage
  • Multi-Valued Nullable Parameters
  • Report Filters – Options and Types
  • Toolbox Filters and Limitations
  • Sub-Reports and Report Actions
  • Parent-Child Report Parameters
Module 6: Enterprise Reports In SSRS
  • Gauge Reports, Indicator Reports
  • Pie Charts, Bars and Spark Lines
  • Report Testing and Auto Refresh
  • Map Reports and Report Dashboards
  • Multiple Chart Areas in Dashboards
  • Report Dashboard & Limitations
  • Report Scorecards with SQL Queries
  • Exporting RDL Reports in SSRS
Module 7: Map Reports and Cube Reports
  • Map Reports and Stored Procedures
  • Indicators with Map Reports
  • Designing Reports using OLAP DBs
  • Identifying KPIs and Measures
  • MDX Queries with Cube Reports
  • MDX Filters with Sub-Reports
  • Scorecards with MDX and DAX
  • Sub-Reports versus Report Actions
  • Accessing and Controlling Reports
Module 8: Report Builder & Power View
  • Designing DataSets in Report Builder
  • Chart and Map Wizard in Report Builder
  • Report Parts and Web Services
  • Report Designer Vs Report Builder
  • Publishing Report Parts with RB
  • Stored Procedures with Report Builder
  • Report Downloads and Edit Options
  • Power Pivot & PowerView Addins
  • Power View for RDLX Reports
  • Understanding Data Models
  • Tables, Charts and Data Bars
  • SparkLines and Data-Mashup
  • Report Builder Vs PowerView
Module 9: Report Management Options
  • Report Manager Configurations
  • SSRS Report Builds and Deployment
  • Managing Data Source Security
  • Exporting and Importing Reports
  • Snapshot Management & Schedules
  • ReportServer Tempdb Usage & Tuning
  • Linked Reports & Null Parameters
  • Report Caching and Memory Refresh
  • Managing Reporting Engine & Tuning
  • Report Execution Audits & Events
  • Tuning SSRS Reports & Memory Options
Module 10: Power View With SSRS
  • Managing RDL and RDLX Reports
  • Comparing PowerView and Report Builder
  • Drillthrough Report Management Options

Part 3: SQL Server 2022 Integration Service (SSIS)

Module 1: Dimension Modeling and Data Warehousing
  • Dimension Modeling & Data Ware Housing
  • Basic concepts of Business Intelligence
  • Basic concepts of Data Warehousing
  • Designing facts and dimensions
  • Employing key performance indicators
  • Dimensional modeling process to design Data Warehouse
Module 2: Introduction to SSIS
  • SSIS Basics
  • SSDT Introduction
  • Connection Managers
  • Basic SSIS Package
Module 3: SSIS Control Flow
  • Control Flow Basics
  • Tasks
  • Precedence Constraint
  • Containers
Module 4: SSIS Containers
  • Four types of container
  • Basic FOR loops
  • Foreach loops
  • Looping over files
  • Looping over records
  • Other for each loop
Module 5: SSIS Data Flow – I
  • Data Flow Basics
  • Data Sources - I
Module 6: SSIS Data Flow – II
  • Excel, Raw File
  • Data Destinations
  • OLEDB, Excel, Flat File
  • Data Flow – II
  • Data Flow Transformation – Introduction
  • Row Transformation
  • Character Map, Copy Column
  • Aggregate, Sort
  • Split and Join Transformations
  • Conditional Split, Multicast, Union All, Merge Join
Module 7: Data viewers
  • Attaching data viewers
  • Using dead-end destinations
Module 8: SSIS Package Maintenance
  • Handling errors and managing exception rows
  • SSIS Package Performance Tuning & Best Practices
  • Deploy packages to an SSIS server
  • Administering the storage, security, and execution of packages

Part 4: SQL Server 2022 Analysis Service (SSAS)

Module 1: What Is Microsoft Business Intelligence?
  • Define Business Intelligence
  • Understand the Cube Structure
  • Deploy and View a Sample Cube
  • View a Cube by using Excel
  • View a Cube by using SQL Reporting Services
Module 2: OLAP Modeling
  • Understand Basic OLAP Modeling (star schema)
  • Understand Dimensional Modeling (stars and snowflakes)
  • Understand Measure (fact) and Cube Modeling
Module 3: Introduction to SQL Server Data Tools (SSDT)
  • Create Data Sources
  • Create Data Source Views
  • Create Cubes by using the Cube Wizard
  • Understand the Development Environment
Module 4: Intermediate SSAS
  • Learn how to Create Key Performance Indicators (KPIs)
  • Discover how to Create Perspectives
  • See how to Create Translations for Cubes and Dimensions
  • Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
Module 5: Advanced SSAS
  • Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
  • Explore Advanced Dimension Types
  • Learn how to use the Business Intelligence Wizard
  • Understand Writeback in Dimensions
  • Review Semi-Additive Measures in OLAP Cubes
Module 6: Cube Storage and Aggregation
  • View Aggregation Designs
  • Customize Aggregation Designs
  • Implement Proactive Caching
  • Use Relational and SSAS Partitions
  • Customize Cube and Dimension Processing
Module 7: Introduction to MDX Queries
  • Understand Basic MDX Syntax
  • Use the MDX Query Editor in SSMS
  • Understand Common MDX Functions and Tasks
  • Review MDX Functions New to SSAS 2012
Module 8: MDX Expressions
  • Understand the Calculation Subtab
  • Learn how to add Calculated Members
  • Explore how to add MDX Script Commands
  • Discover how to add .NET Assemblies
Module 9: Introduction to Data Mining
  • Understand Data Mining Concepts
  • Review the Algorithms that SSAS Includes
  • Consider Data Mining Clients
  • Understand Mining Structure Processing
Module 10: SSAS Administration
  • Implement SSAS Security
  • Implement XMLA Scripts in SSMS
  • Deploy and Synchronize Databases
  • Understand SSAS Database Backup and Restore
Module 11: Advanced Administration and Optimization
  • Implement SSIS to Manage SSAS Databases
  • Explore Clustering
  • Explore Scalability Options
  • Understand Performance Tuning and Optimization
Module 12: Introduction to SSAS Clients
  • Design Reports using Reporting Services
  • Design Reports by using Report Builder
  • Implement Excel Pivot Tables and Charts
  • Use Excel as a Data Mining Client
  • Review Microsoft Office SharePoint Server
DOWNLOAD COURSE CONTENT

Course Statistics

16

Years of Experience

3671

Gratified Students

112

Training Batches

9634

Training Hours

Gratified Student Feedback - From Year 2000

  • Trainer: Abhisek

    Thank you so much for the training . I enjoyed this training and learned a lot about SQL server BI. It was very organized, and Mr. Abhisek was a great teacher!
    Genet Desta
    Lorton, US

  • Trainer: Abhisek

    Abhi is really very good trainer and willing to go the extra mile to explain & bring the class to the same understanding level. He also shares his own work experience to give exposure to the real-time scenario. He is the best trainer for this course, and I recommend anyone who would like to take SQL BI courses to join Abhi's class.
    Meskerem Endris
    Highland, US

  • Trainer: Mr.Abhi

    The SQL Server BI course was an enlightening experience. The content was well-structured and delivered in a clear, concise manner... The live lesson was super fun to take. I appreciated the practical hands-on exercises, which helped me gain a deep understanding of SQL and Power BI integration. I now feel confident in my ability to manipulate data using SQL and create compelling visualizations in Power BI. Mr Abhi is an excellent teacher. I don't believe there is a single thing he did not explain. I highly recommend it to anyone looking to harness the power of SQL and Power BI for data analysis. Also, thank you Daniel for Organizing this course.
    Jordan Wanji
    St. Catharines, CA

  • Trainer: Abhisek

    I had a great learning experience taking this course with Mr. Abhisek. Thank you for taking time and explain the course the way we can understand.
    Muluken Wendmagegnehu
    Reynoldsburg, US

  • Trainer: Abhishek

    Abhishek explained very well the entire course of MSBI and patiently answered even small doubts . Thankyou Abhishek.
    Sridurga Vuppu
    Monmouth Junction, US

  • Trainer: Abishiek

    This is the second course I have completed with Empire Data System, and I am equally satisfied with the content and delivery of this course. Abishek fully understood that students' computer knowledge is at different levels hence his patient pace and style of delivery to ensure all students are carried along as much as possible. I benefited greatly from this course, and my reporting and data analytical skills have soared. I totally recommend it.
    Chinedu Emeanuwa
    Houston, US

  • Trainer: Abhishek V.

    Abhishek is very knowledgeable and an excellent trainer. I learned a lot from this MSBI training.
    Aman Singh
    Silver Spring, US

  • Trainer: Abishek

    Abishek was very knowledgeable in MSBI and was an excellent instructor willing to go above and beyond for the students.
    Yeneneh Ali Yimer
    Las Vegas, US

  • Trainer: Abhisek

    Abhisek was a very knowledgeable trainer. I have acquired so much from his class. He was so generous to share his knowledge with us and encourages students to participate in and ask questions. I recommend any future students to join his class. Thank you Abe, and Keep up your good work!
    Tes, Messele
    Fairfax, US

  • Trainer: Abhisek Vibhuti

    I had the pleasure of receiving MSBI training from Abhishek, and I must say that he is an exceptional tutor. He has an in-depth knowledge of MSBI tools like SSIS, SSRS, SSAS, and Power BI, and his expertise in SQL Server is remarkable. Abhisek's teaching style is very engaging, and he makes complex concepts easy to understand with his clear explanations and real-world examples. One of the things that impressed me the most about Abhisek was his patience and willingness to answer all my questions. He always ensured I understood a topic before moving on to the next one, which gave me the confidence to apply what I learned in real-world scenarios. Abhisek's dedication to his students is evident in how he prepares for each class and tailors his approach to suit individual learning styles. He creates a positive learning environment and encourages active participation, which makes the lessons enjoyable and productive. Overall, I highly recommend Abhisek as a tutor for anyone looking to master MSBI tools. His teaching skills, subject matter expertise, and passion for teaching make him an outstanding choice for anyone seeking to enhance their knowledge of Microsoft Business Intelligence.
    Uday Karna
    Chicago, US

  • Trainer: Abhisek

    Abhisek was detailed oriented Trainer. He has been giving us real-time examples and scenarios throughout the course. Well done Abe! I, absolutely recommend him to any one who has a plan to take BI classes.
    Tes, Messele
    Fairfax, US

  • Trainer: Abhisek

    Mr. Abhisek is a good teacher, he is very detail oriented about course material. I do recommend him who like to learn MSBI in detail.
    Sheikh Hoque
    New York City, US

  • Trainer: Abhisek

    Good training in Power BI, SSIS, SSRS, and SSAS. Abhishek explained everything in detail.
    Tangina yeasin
    Bayonne, US

  • Trainer: Abhisek

    Abhisek was a great Tutor who taught great things in a simple way. He was so patient to answer all the questions we raised. Really love to have his class.
    GIJI KURIAN
    Coral Springs, US

  • Trainer: Abhishek

    This course has definitely improved my confidence in MSBI. Abhishek is a great instructor, he really took his time to elaborate in the subjects and used great examples when answering questions. I highly recommend him as a mentor.
    Anali Rivera
    Newark, US

  • Trainer: Abhisek

    Abishek Knows the subject very well, is practically experienced, and good materials are provided on time.
    Tewodros Deressa
    Baltimore, US

  • Trainer: Abhisek

    Had a great experience during the training session. The patience and understanding of the Trainer to answer any question that was asked was unmatched. Struggled to join the live sessions due to my schedule but the recorded sessions were good enough to help me follow. Really grateful for this opportunity.
    Joshua Owusu
    Lakewood, US

  • Trainer: Abishek

    He is the right fit for the power BI Training, and he has outstanding knowledge about it. I am advice to anyone who needs to learn Power BI in short period of time, this is the right Training for you if you need.
    Gebremedhin A.Reda
    Rosemount, US

  • Trainer: Abhisek Gupta

    Amazing MSBI training and instructor! Abhisek is very knowledgeable, good at performance tuning and always there for help.
    Ishrat Mostafi
    Centreville, US

  • Trainer: Abhisek Gupta

    Excellent MSBI training. Topics covered in detail.
    NJONG DENIS NJONG
    Oakton, US

  • Trainer: Mr. Abishek

    Mr Abishek was extremely Knowledgeable and experienced in MSBI . This training helped me identify clear, do-able next steps toward resolving my own workplace conflict.
    Youvendra Dhaker
    Jabalpur, IN

  • Trainer: Abhisek

    This webinar class has been fantastic. Mr. Abhishek is incredibly knowledgeable and articulate. Although this type of learning format is new for me, I am delighted with it and look forward to coming back to other related classes in the ahead. I love the fact that even though I am in a class with other people, the actual physical space is private and quiet and very conducive to learning! Thank you!
    Solomon Assefa
    Overland, US

  • Trainer: Abhisek Gupta

    The course content is well organized and the trainer also good and he tried to answer questions that were raised from the students.
    Mersha Wubie
    University City, US

  • Trainer: Abishek

    The MSBI course was great. Can’t wait for the next one.
    Sheikh Cham
    Fayetteville, US

  • Trainer: Mr. Abhishek

    MSBI course was very helpful to enhance skills and it helped to apply them in real time scenarios. Abhi demonstrated in depth knowledge in the subject matter and was always ready to clarify all the questions. Thank you Abhi and Daniel.
    Roopa Guduru
    Gainesville, US

Empire Data Systems

Social Links