SQL Server, Power BI, MSBI (SSIS, SSRS), Data Warehouse, and Advanced Excel for Data Analytics

khondaker Islam
Last Update February 8, 2024
0 already enrolled

About This Course

Business intelligent (BI) is an umbrella term for the 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) prepare data to make it ready to consumption in the business
intelligence world. So understanding of 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

Material Includes

  • Yes Materials Included

Requirements

  • No Programming experience required.
  • A Laptop or Pc with access to the internet.

Target Audience

  • University Student
  • College Student
  • School Student

Curriculum

31 Lessons

Week 01 : SQL Server Introduction, Configuration, Familiarization, and data Import export.

Module 0100:00
Module 0200:00

Week 02 : SQL Basic Queries, Data Types, Restore, and Schema for tables

Week 03 : Understanding Aggregation functions, different key constraints, and different types of join.

Week 04 : Understanding ERD, Different types of join, diagram design, and join multiples tables.

Week 05 : Learn SQL Command category, what is a view, temporary tables, and Union of tables.

Week 06 : Understanding Subqueries, window functions, Calculated columns, and functions like Cast(), Convert(), isnull(), concate() so on.

Week 07 : Understanding Dynamic Queries, table variables, table index, constraints, and Date and Time Functions

Week 08 : Learn Stored Procedure with Parameter, loop, conditional statement, and review of classes

Week 09 : Understanding OLTP and OLAP process, Data warehouse concept, Star schema, and Snowflake schema, introduction to Power BI.

Week 10 : Learn Transformation data such as pivoting & Un-pivoting, Modifying, Merging & Append Queries

Week 11 : Understanding table's relationship in Power BI and how it works, different types of Schema.

Week 12 : Understanding Data Analysis Expressions (DAX) such as Row Context and Filter Context, DAX syntax and Operators.

Week 13 : Understanding Aggregation functions, iterator functions, and Time intelligence functions and Start dashboard Projects

Week 14 : Create dashboard projects with Editing Report interactions and different types of filters and Maps

Week 15 : Understanding Advance Excel with Aggregation, conditional, Text, date and time functions.

Week 16 : Develop reports using SQL Queries and design reports using SSRS (SQL server reporting service)

Week 17 : Data transfer from one source to another source, ETL (Extraction, Transformation, Load) Process using SSIS tools.

Your Instructors

khondaker Islam

0/5
1 Course
0 Reviews
0 Students
See more

$15,000

Level
Intermediate
Lectures
31 lectures

Material Includes

  • Yes Materials Included
Enrollment validity: Lifetime

Want to receive push notifications for all major on-site activities?

Don't have an account yet? Sign up for free

Need Help ?