Business Intelligence with PowerBI & Tableau:Complete Course
Business Intelligence with PowerBI & Tableau:Complete Course
Published 06/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 214 lectures (11h) | Size: 5.11 GB
Power Bi, Dax, Table, Excel, Statistics, Data visualization, BI, Business Intelligence, Statistical practices with Excel
What you'll learn
● The introduction and importance of Business Intelligence.
● Practical explanation and live implementation of all important functions of Bi and statistical concepts using Excel, Power BI, and tableau.
● Business Intelligence Applications.
● Basic concepts of Statistics required for understanding Business Intelligence
● Practical implementation of statistical concepts in Excel
● Complete guide and tutorial of Power BI from scratch to Publishing Dashboard
● Mini projects and Quizzes with Solutions to reinforce your learning skills of Power BI
● Complete guide and Tutorial of Tableau from Installation to Dashboard and Story
● Practical Exercises to enhance the learning of Tableau
● Mini Project of Regression Analysis using Excel
● Segregated modules to learn fundamental concepts of Statistics along with explanation and practical implementation using exercises
● Power BI Project: Sales Dashboard
● Tableau Project Customer Analysis
● Interview Preparations
Requirements
• Basic understanding of Microsoft Excel.
• An elementary understanding of data science.
• A willingness to learn and practice.
Description
Comprehensive Course Description
Business intelligence is an umbrella term covering different methods of collecting, storing, and analyzing data from business operations. We designed the course in the same pattern; started with an introduction and overview of Business Intelligence followed by the importance of Business Intelligence and its applications. Business Intelligence is incomplete without data analysis and visualization, so to firm your hands-on BI concepts, statistical terminologies are explained along with its practical explanation so that you should feel confident when using any particular statistical measure in your business.
Business Intelligence is implemented through its tools. These tools are technology-driven business intelligence solutions that are used for analyzing and visualizing raw data to present actionable information. It combines business analytics, data visualization, and best practices that help an organization make decisions. We selected two important, economical, use user-friendly and effective tools of Business Intelligence that are Power BI and Tableau.
Power BI is a product of Microsoft that is designed for analyzing and visualizing raw data to present actionable information. It combines business analytics, data visualization, and best practices that help an organization make data-driven decisions. This course provides a coma plate guide on power, Bi, from installation to Dashboard along with practical exercises, Quizzes, and a Project of Sales dashboard that will help business users to practice it side by side to become an export in Power BI.
Tableau is a visual analytics platform transforming the way we use data to solve problems empowering people and organizations to make the most of their data. The course has given a detailed insight into the software by illustrating various fields and attributes. Moreover, exercises and quizzes will engage the students to firm their analytical concepts. Additionally, the Customer Analysis dashboard is designed in the projects with a simple but comprehensive explanation to help the business users to by with practicing the same in their businesses.
We did not stop there; career development is addressed at the end to prepare the participants for their interviews if they appear for any BI role. Also, the market trend is introduced to them so that users will be fully prepared to go to the workplace with all essential BI concepts and practice it with confidence and encouragement. On whole, it's a MUST take the course for business and common users to enhance their careers empowering ring their skills.
How Is This Course Different?
In this Learning by Doing course, every theoretical explanation is followed by practical implementation.
Most of the courses that are available online are either overloaded with a lot of mathematics or just implementations without any theory. This course is a perfect balance between theory and practice. Our focus is to teach BI to a beginner so we tried our best to make things simple and implement everything using Python.
The course 'Business Intelligence' is crafted to reflect the most in-demand workplace skills. This course will help you understand all the essential concepts and methodologies of Business Intelligence.
The course is
• Easy to understand.
• Expressive.
• Exhaustive.
• Practical with live working on Excel, Power BI, and Tableau.
• Rich with the state of the art and latest knowledge of this field.
As this course is a detailed compilation of all the basics, it will motivate you to make quick progress and experience much more than what you have learned. At the end of each concept, you will be assigned Homework/tasks/activities/quizzes along with solutions. This is to evaluate and promote your learning based on the previous concepts and methods you have learned. Most of these activities will be practical-based, as the aim is to get you up and running with implementations.
High-quality video content, in-depth course material, evaluating questions, detailed course notes, and informative handouts are some of the perks of this course. You can approach our friendly team in case of any course-related queries, and we assure you of a fast response.
The course tutorials are divided into 200+ brief videos. You'll learn the concepts and methodologies of Reinforcement & Deep Reinforcement Learning along with a lot of practical implementation. The total runtime of the HD videos is 11+ hours.
Why Should You Learn Business Intelligence?
Businesses are moving at neck-breaking speeds and so is their competition. For these businesses to have an edge in the market, every decision they make must be informed. Irrespective of the industry, every business has access to a lot of data that they can leverage to their advantage. But unfortunately, very few do. Business Intelligence (BI) helps these businesses to use their data to their advantage by presenting the otherwise unusable pile of data in an understandable and interpretable form. BI enables you to combine the power of technology and business expertise to make fully informed decisions and stay ahead of the competition.
Course Content
The all-inclusive 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-timeime 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 & Histogram
2.5. Mode, Median, and Mean
2.6. Coefficient of variation, standard deviation & Variance
2.7. Skewness, Covariance & Correlation
3. Inferential Statistics
3.1. What is Inferential statistics?
3.2. Distribution, Normal Distribution & Standard Normal Distribution
3.3. What is a Standard Error?
3.4. Estimators & Estimates
3.5. What is the Central Limit Theorem?
4. Overview of Confidence Intervals
4.1. What are Confidence Intervals?
4.2. Clarifications & Margin of Error
4.3. Z-Score
4.4. T-Score & 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 & P-Value
5.4. Population Variance Known
5.5. Population Variance Unknown
5.6. Dependent & 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
Data Sources
2.1 Introduction to data sources
2.2 Query Editor
2.3 Importing files
2.4 Data Modelling
2.5 Lookup data tables
2.6 Active vs Inactive Relationships
2.7 Roles
2.8 Refreshing data and hierarchies
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
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 & 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. Treemape map chart
6.8. New Dashboard
7. Updated way of data preparation
7.1. Overview
7.2. Data Format & Data Interpreter
7.3. Pivot & 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 & Groups
8.2. Understanding of Highlighter & 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 successful completion of this course, you will be able to
● Relate the concepts and practices of data science and business intelligence techniques and implement them using data analytic BI software
● Apply for the jobs related to Business intelligence, data analytic, and data science roles.
● Can work as a freelancer for the 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
● People who are beginners and know absolutely nothing about 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.
● Who are interested in learning new tools
Who this course is for
● People who are beginners and know absolutely nothing about 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.
● Who are interested in learning new tools
Homepage
