QA Tek Solutions Inc.

Data Analysis with Power BI

Prepare yourself as a professional in cutting-edge business analytics services and tools with Microsoft Power BI, SQL Server, Data Warehousing, ERD, SSIS, SSRS, SSAS, T-SQL.

Next Batch Starts on
Weekend: January 22, 2022
Weekdays: January 24, 2022

Course Overview

Business intelligence (BI) is an umbrella term for technology. Theoretically, the use of high class software or business applications of the use of values to make better decisions for the company, Technical and Practical business Intelligence are tools for collecting, processing, and analyzing data. This way the company can evaluate the results and interpret them. 

BI systems enable effective risk management, advancing a company’s position within the marketplace,  enabling decision-makers to recognize performance gaps, market trends, or new revenue opportunities more quickly. 

SQL (structure Query Language) prepares data to make it ready to consumption in the business intelligence world. So understanding traditional SQL is essential before investigating into business intelligence(BI).  SQL still remains an essential tool in the hands of data engineers and business intelligence. 

Businesses without a data warehouse were messy and unstructured data, from which end users on the business side of the organization struggled to get anything useful out of it.  A data warehouse takes all that scattered data and lays it out nice and tidy in a huge relational database, through a process of Extract-Transform-Load (ETL).

This data warehouse practice involves transforming data that is optimized for a heavily transactional system and moving it to one that is more suited for analytic querying.

Power BI one of the best and secure business intelligence software tools. Power BI transforms your company’s data into rich visuals for you to collect and organize so you can focus on what matters to you. Stay in the know, spot trends as they happen, and push your business further.

With Power BI Service, setup automatic data refresh so everyone has the latest information. You can access your data and reports from anywhere with the power BI Mobile apps, which update automatically with any changes to your data. 

Power BI highlight :

  • whole business on one dashboard      
  • Create stunning interactive reports            
  • Consistent analysis across your organization                                  
  • Easily embed BI and analytics in your app

Course Outline

  • What is Data
  • What is big Data
  • What is Database
  • What is Power BI
  • History of Database and Power BI
  • Importance of Power BI and Database
  • Difference Branch of Database
  • Current Job Market. 
  • Power BI Pro, Power BI Premium
  • Comparison tools in power BI
  • Comparison tools in SQL server and cloud computing

  • Installation of SQL Server 2014.
  • Installation of Power BI Desktop 2.78.
  • Familiar and understanding SSMS.
  • Understand different connection.
  • Create Database graphically, using code.
  • Create table graphically, using code.
  • Insert data into the table.

  • Write SELECT Statement
  • Fetching Data from the Table.
  • Where Clause ( Operators, in , Between, Like, And, or , not, <, >,  <> )
  • TOP function and OFFSET–FETCH functions.
  • Table aliases. 
  • DISTINCT function.
  • Working with Unknown values.
  • Order by
  • Logical order of operation.
  • Exam will be taken.

  • Understand database tables relationship (ERD) process
  • Primary key , Foreign key, unique key
  • Left Join, right join, inner join
  • Self-join , Cross join
  • Union  and Union All
  • Querying from two tables
  • Querying from multiple tables
  • SQL Server  data type
  • Exam will be taken. 

  • Understand Data Warehouse  
  • Star Schema
  • Snowflake Schema
  • Understanding SQL server integration service (SSIS)
  • Understanding SQL server Reporting Service (SSRS )
  • Understanding SQL server Analysis  Service (SSAS)

  • About Power BI
  • Helpful Resource
  • Interface and work-flow
  • Adjusting and Regional Settings
  • Power BI Ribbon
  • Types of data Connections
  • Query Editor and Table transformations.
  • Grouping and Aggregating records
  • Merging and Appending Queries. 
  • Pivoting and Un-pivoting queries. 
  • Power BI Data type
  • Data source setting
  • Appending Queries and Files. 
  • Understanding hierarchies in Power BI

  • Working with Text Tools
  • Working with Numerical values.
  • Working with Date and Times
  • Index and conditional columns
  • Edit rows and columns
  • Splitting columns
  • Duplicating columns
  • Improving performance
  • Understanding the Mobile app
  • Exam will be taken

  • What is Data Model
  • Understanding Dimension table
  • Fact table ( Data table)
  • Table relationship using Snowflake Schema
  • Table relationship using Star schema
  • Understanding Cardinality
  • Implementing two way filters in Power BI
  • Importance of Filter Flow

  • Introduction DAX
  • Syntax of DAX
  • Naming in DAX
  • Data types in power BI Model
  • Logical Operator and Variable
  • When to use DAX or M
  • Calculated column ( row by row)
  • Measure ( Single Output)
  • Calculated table (Derived table)
  • Time Intelligence Functions

  • Dynamic DAX Parameter
  • DAX Function
  • Other type of Parameters
  • Parameters table
  • SWITCH
  • Related Functions
  • Related Table
  • Row  and Filter Context
  • Calculated Function
  • Conditional SUM
  • Aggregation and Iterator Functions.
  • Implicit and Explicit Measure
  • Iterator Function
  • Difference between SUM and SUMX
  • Filter Function and ALL
  • ALLExcept

  • Report View
  • Inserting Basic Charts
  • Report formatting
  • Conditional Formatting
  • Filtering Options
  • Filtering with Date Slicers
  • Matrix Visuals
  • Key Metrics and KPI 
  • Different Trend Lines
  • Drill through Filters
  • Tree view and Bookmarks
  • Gauge and viewing roles

  • Power BI Service. What is Gateway
  • Installation and Configuration of Gateway
  • Live connection
  • Power BI Integration with different tools
  • Row level Security and Manager level access
  • Dynamic row level Security
  • Basic Dashboard and Report Sharing
  • Publish to Web
  • Workspace in Power BI.

  • Design and Implement End to End Project.
  • Exam and review.

  • Resume Preparation
  • Job Interview Guideline
  • Mock interview

Khondaker Islam

Khondaker R Islam is the data specialist in the field of Business Intelligence. With over 18 years of extensive U.S. and Canadian experience in the field of IT and Science, He has conducted R & D and database development work for companies such as California Innovations, Brookfield (BGRS), SallieMae, Pfizer Inc, Apotex Inc, Purdue Pharma, Pharmacopeia Inc. and W R Grace & Co . He has MS degree from Howard University in Washington DC and also advance database diploma with Oracle and Microsoft certification from CBC in Canada. He is currently working as a Instructors in the field of Business Intelligence.

Course Instructor

Course Fee

$3000

Discount

$ 2500

Course Schedule

  • Regular Class: Saturday & Sunday, 10am – 1pm, New York Time 
  • Review Class: Thursday, 9pm-10pm, New York Time

Time

Week 1 (6 Hours)

Week 2 (6 Hours)

Week 3 (6 Hours)

Week 4 (6 Hours)

Week 5 (6 Hours)

Week 6 (6 Hours)

Week 7 (6 Hours)

Week 8 (6 Hours)

Week 9 (6 Hours)

Week 10 (6 Hours)

Week 11 (6 Hours)

Week 12 (6 Hours)

Date

09/18/2021 (Sat)
09/19/2021 (Sun)

09/25/2021 (Sat)
09/26/2021 (Sun)

10/02/2021 (Sat)
10/03/2021 (Sun)

10/09/2021 (Sat)
10/10/2021 (Sun)

10/16/2021 (Sat)
10/17/2021 (Sun)

10/23/2021 (Sat)
10/24/2021 (Sun)

10/30/2021 (Sat)
10/31/2021 (Sun)

11/06/2021 (Sat)
11/07/2021 (Sun)

11/13/2021 (Sat)
11/14/2021 (Sun)

11/20/2021 (Sat)
11/21/2021 (Sun)

11/27/2021 (Sat)
11/28/2021 (Sun)

12/04/2021 (Sat)
12/05/2021 (Sun)

Modules

Tools

Microsoft BI Desktop – 2.78

Microsoft SQL Server– 2014, 2016, 2019

Open chat