SQL Server, Power BI, MSBI (SSIS, SSRS), Data Warehouse, and Advanced Excel for Data Analytics}{Video-Only

Khondaker R Islam
Khondaker R Islam
Last Update March 18, 2024
0 already enrolled

About This Course

“THIS COURSE WILL BE ENTIRELY RECORDED AND AVAILABLE EXCLUSIVELY THROUGH THE
‘VIDEO-ONLY COURSE’ FEATURE. LEARNERS SIMPLY NEED TO WATCH THE VIDEOS TO GRASP ALL
THE CONTENT OF THE 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 R Islam

5.0/5
5 Courses
2 Reviews
7 Students

Mr. Khondaker R Islam, a Microsoft-certified data science instructor with over 20 years of extensive experience in top-ranked pharmaceutical companies across the USA and Canada. With a distinguished background as a scientist and advisor in research and development, Mr. Islam has made significant contributions to numerous patents and drug discoveries, solidifying his reputation as a leading expert in the field.

Throughout his illustrious career, Mr. Islam has not only excelled in research and development but has also showcased his versatility by serving as a database administrator, software testing expert, and data analytics trainer. His expertise extends beyond theoretical knowledge, as he emphasizes real-world applications and industry-relevant curriculum design to empower learners and students for successful employment opportunities.

Currently serving as the President and CEO of KSI Data Research, Mr. Islam continues to drive innovation and excellence in the field of data science. Prior to this role, he held positions at esteemed organizations such as California Inc, Sallie Mae, Pfizer, WR Grace Com. Purdue Pharma, and Pharmacopeia Inc., among others. His tenure at these world-renowned companies speaks volumes about his exceptional skills and contributions to the industry.

Mr. Islam's academic journey is equally impressive, with degrees from prestigious institutions including the University of Notre Dame, Dhaka University, and Howard University. Additionally, he holds certifications from CBC, Canada in Database Diploma and is recognized as an Oracle and 
With his wealth of knowledge, hands-on experience, and commitment to excellence, Mr. Khondaker R Islam continues to be a driving force in the field of data science, shaping industry solutions and empowering the next generation of professionals

As the President and CEO of KSI Data Research,  thrilled to welcome you to our dynamic digital space. At KSI, we believe in the transformative power of knowledge and technology, and it is our mission to unlock limitless possibilities for individuals and businesses worldwide.

See more

$1,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 ?