| Published | 2022-06-03 |
| Platform | Udemy |
| Subjects |
Power Bi, Dax, Table, Excel, Statistics, Data visualization, BI, Business Intelligence, Statistical practices with Excel
Comprehensive Course Description:
Do you want to master Business Intelligence (BI) tools? And gain in-depth knowledge of advanced techniques such as formatting the dashboard and publishing the dashboard to workspace? Or interested in just getting some hands-on experience in using Power BI and Tableau?
Then this course is for you!
Business intelligence, an umbrella term, covers different methods of gathering, storing, and analyzing data from business operations. This course has been designed in the same pattern. It starts with an introduction and overview of Business Intelligence. Then, you learn about the importance of Business Intelligence and its applications.
But without data analysis and visualization, Business Intelligence is incomplete. Hence, to become familiar with hands-on BI concepts, you learn statistical terminologies along with their practical explanation. This knowledge will give you the needed confidence when using any particular statistical measure in the workplace.
You implement Business Intelligence through its tools. These technology-driven business intelligence solutions are used for analyzing and visualizing raw data to present actionable information. BI combines business analytics, data visualization, and best practices that help you make decisions. You will learn two important, economical, user-friendly, and effective BI tools, Power BI and Tableau.
Power BI, a Microsoft product, analyzes and visualizes raw data and presents actionable information. This course provides you guidance from installation to Dashboard along with practical exercises, quizzes, and a project on Sales Dashboard that will help you practice it side by side to become an expert in Power BI.
Tableau, a visual analytics platform, transforms the way data is used to solve problems, empowering businesses to make the most of their data. In the course project, you design the Customer Analysis Dashboard with the help of our simple but comprehensive explanation.
You will not stop here. You will also receive invaluable guidance on career development in the last section. This will help you prepare for interviews for any BI role. Also, you learn about the market trend and will be fully prepared to go to the workplace. You will know all the essential BI concepts and practice them with confidence. On the whole, this is a MUST take course if you want to enhance your career prospects.
How Is This Course Different?
This Learning by Doing course is a fine mix of theoretical and practical components. The two real-time projects in Power BI and Tableau are well-structured and help you get valuable practice.
Since this course is a perfect blend of theory and practice, you are compelled to complete the exercises. The interactive nature of the course means you don't sit idly, watching the videos. Your learning is also dependent on the initiative you take to solve the quizzes and exercises.
Even if you are a beginner, you will gain a lot of BI skills in this course. We have simplified the concepts and eased the learning curve.
The course is:
• Easy to understand.
• Expressive.
• Exhaustive.
• Practical with live working on Excel, Power BI, and Tableau.
• Up-to-date covering the latest developments in the BI field.
This course is an in-depth compilation of all the elementary concepts. You will be motivated to make fast progress. You will gain more BI understanding than what you have learned. Periodic evaluation of your learning in the form of homework/exercises/quizzes has been included to reinforce your learning.
Detailed course material, high-quality video content, exercise questions, explanatory course notes, and informative handouts are some of the features of this course. You can also approach our friendly team if you have any course-related queries.
The tutorials are divided into 200+ short, engaging videos. The essential concepts and methodologies of Business Intelligence are covered in the eight sections of the course. You will find ample opportunities for practical implementation of what you learn. The total runtime of the course videos is 11+ hours.
Why Should You Learn Business Intelligence?
In today's age of technological progression, businesses aim to gain new customer insights and achieve efficiency improvements all the time. The latest data-driven tools are the lifeblood of businesses, as they enable them to gather more information about their customers than ever before.
BI systems provide C-suite executives and decision-makers with access to vital data in real-time through different means, such as scheduled emails, visual dashboards, and spreadsheets. When you master the use of BI tools, you can leverage them to assimilate, interpret, and distribute enormous amounts of data accurately and fast. You can also transform complex, unrelated, and confusing data into understandable and actionable insights.
Course Content:
This all-encompassing course consists of the following topics:
Section 1: Introduction of BI:
1. Why BI?
2. Applications of BI
3. Introduction to the Course Instructor
4. Introduction to the Course and Mini-Projects
5. BI Project Overview
Section 2: Types of Business Intelligence Tools and Applications:
1. Ad hoc analysis
2. Online Analytical processing
3. Mobile BI
4. Real-time BI
5. Operation Intelligence
6. Open-Source BI
7. Embedded BI
8. Collaborative BI
9. Location Intelligence
10. Business intelligence vendors and market
Section 3: Statistics Overview
1. Welcome to the Statistics Course
1.1. What Course Is It About?
1.2. Sample
1.3. Population
2. Descriptive Statistics
2.1. Data Types
2.2. Level of Measurement
2.3. Numerical and Categorical Variables
2.4. Scatter Plot, Cross Table, and Histogram
2.5. Mode, Median, and Mean
2.6. Coefficient of Variation, Standard Deviation, and Variance
2.7. Skewness, Covariance, and Correlation
3. Inferential Statistics
3.1. What Is Inferential Statistics?
3.2. Distribution, Normal Distribution, and Standard Normal Distribution
3.3. What Is a Standard Error?
3.4. Estimators and Estimates
3.5. What Is the Central Limit Theorem?
4. Overview of Confidence Intervals
4.1. What Are Confidence Intervals?
4.2. Clarifications and Margin of Error
4.3. Z-Score
4.4. T-Score and Student’s T Distribution
4.5. Dependent Samples, Two Mean Test
4.6. Independent Samples, Two Mean Test
5. Hypothesis Testing
5.1. Null vs. Alternative Hypothesis
5.2. Error Types
5.3. Rejection Region, Significance Level, and P-Value
5.4. Population Variance Known
5.5. Population Variance Unknown
5.6. Dependent and Independent Samples for Mean Test
Section 4: Statistical Practices Using Excel
1. Descriptive Statistics
2. Measures of Central Tendency
3. Data Spread
4. Data Visualization
5. Correlation
6. Paired Sample T-Test
7. T-Test for Equal and Unequal Variances
8. Confidence Interval
9. Hypothesis Testing
10. Example Project: Regression Analysis
Section 5: Power BI
1. Introduction to Power BI
1.1 Power BI Overview
1.2 Installation
2. Data Sources
2.1 Introduction to Data Sources
2.2 Query Editor
2.3 Importing Files
2.4 Data Modeling
2.5 Lookup Data Tables
2.6 Active vs. Inactive Relationships
2.7 Roles
2.8 Refreshing Data and Hierarchies
3. Data Modeling
3.1 Introduction
3.2 DAX
3.3 Calculated Columns
3.4 Measures
3.5 Complex Functions
3.6 Hybrid Measures
3.7 Star Schema
3.8 Snowflake Schema
3.9 Filter flow
3.10 Bi-directional Cross-filtering
3.11 Time Intelligence
3.12 Defining Day and Date Function
3.12 Making Your Date Table
4. Design and Interactive Reports
4.1 Adding Visuals
4.2 Adding Measures to Reports
4.3 Applying Basic Filtering
4.4 Slice and Dice
4.5 Apply Formatting
5. Dashboard
5.1 Add Data to the Dashboard
5.2 Format the Dashboard
5.3 Publish Dashboard to Workspace
6. Career Opportunities with Power BI
Section 6 Tableau
1. Introduction to Tableau
1.1. Tableau Overview
1.2. Installation
2. Tableau Fundamentals: Data Sources, First Bar Chart Graph
2.1. Exciting Challenge
2.2. Excel / CSV File Connection with Tableau
2.3. Tableau Navigation Overview
2.4. Establish Fields
2.5. Addition of Colors, Labels, and Formatting
2.6. Final Worksheet Exportation
3. Overview of Different Terms
3.1. Overview
3.2. Understand the Extracted Data
3.3. Knowledge of Aggregation, Granularity, and Time-Series
3.4. Level of Detail
3.5. Working with Charts and Filter
4. Overview of First Dashboard, Maps, and Scatter Plots
4.1. Overview
4.2. Joins and Relationship
4.3. Data Joining
4.4. Map Creation
4.5. Scatter Plot Creation
4.6. First Dashboard Creation with Highlighting and Filters
5. Overview of Dual-axis Chart, Joining, Relationship, and Blending
5.1. Overview
5.2. Working with Joins
5.3. Joining with Different Conditions, i.e., Multiple Fields and Duplicate Values
5.4. Difference Between Blending and Joining Data
5.5. Working on Blending Data
5.6. Creation of Dual Axis Chart
5.7. Understanding of Calculated Fields
5.8. Another Exciting Challenge with a Data Set
5.9. Model Dataset
5.10. Understanding of Relationship Data
6. Overview of New Dashboard
6.1. Overview
6.2. Dataset
6.3. Understanding of Mapping
6.4. Table Calculations: For Age
6.5. Table Calculations of Bins and Distribution
6.6. Power Parameters
6.7. Treemap map chart
6.8. New Dashboard
7. Updated Way of Data Preparation
7.1. Overview
7.2. Data Format and Data Interpreter
7.3. Pivot and Multi Data Grid
7.4. Conversion of One Column into Multiple Columns
7.5. Solutions to Fix the Data Errors
8. Overview of New Design Feature and Many More
8.1. Difference of Custom Territories from Geographic Roles and Groups
8.2. Understanding of Highlighter and Clustering
8.3. Understanding of Cross-Database Joining
8.4. Clusters Modeling and Saving Overview
8.5. New features: Of Design
8.6. New features: Of Mobile
9. Advancement in Tableau
9.1. Overview
9.2. Data Extraction from a Text File
9.3. Connection and Joining to Spatial Files
9.4. Tooltip: New feature
9.5. Understanding of Jump and Step Line Chart
Section 7: Real-Time Projects
1. Sales Dashboard Using Power BI (Dashboard)
2. Customer Analysis Using Tableau (Dashboard)
Section 8: Career Development
1. Preparing for the Interview
2. Roles in Business Intelligence
3. Market Value of Various BI Roles Worldwide
After the satisfactory completion of this course, you will be able to:
● Relate the concepts and practices of business intelligence techniques and implement them using data analytic BI software.
● Apply for the jobs related to business intelligence, data analytics, and data science roles.
● Work as a freelancer for jobs related to BI such as Business analyst and Data modeler.
● Implement any project that requires BI knowledge of Power BI and Tableau from scratch.
● Extend or improve the implementation of any other project for performance improvement.
● Know the theory and practical aspects of BI, Power BI, and Tableau.
Who this course is for:
● Beginners in Business Intelligence, Power BI, and Tableau.
● People who want to extend their business as well as their career through intelligent BI techniques.
● People who love to make themselves ready for BI roles
● People who want to learn BI along with its implementation in realistic projects.
● Statistical, Power BI, data analytics, and Tableau lovers.
● Anyone interested in learning new tools.