Key Highlights
Skill Covered
Program Details
Tools Covered
Business Intelligence With Tableau
Start your career journey by getting in-depth insights into what is Business Intelligence along with Tableau. It is developed by industry experts and aligned with the latest practices. You will master Business Intelligence concepts with Tableau through this module.
Business Intelligence is the process of converting raw data into usable insights. The module of "Introduction to Business Intelligence" will help you to understand how BI works, how to create a strategy, and various BI platforms.
A tableau is a powerful tool used for data analysis and visualization; using it, you will be able to create an amazing and interactive visualization, and that too without coding. This module of "Introduction to Tableau" will help you with the installation of Tableau, its user interface, different usage of Tableau in industry, several real-time use cases from various Business Domains, and the main differences between the Tableau Desktop and Tableau Public.
This lesson will help you learn to connect various data sources from different locations. Also, you will learn about different types of connections and how to connect those connections into a text file, excel file, and databases.
Tableau is the software that allows the user to represent the data in a visual format. To utilize Tableau, this module will cover the installation of Tableau and other basic features for the same.
The Tableau software provides the user with an amazing metadata system that is known as DataSource. The module will cover learnings that are introduction and working of metadata, understanding fields, values, etc.
In this session, you will learn about how to create a join and then how you can combine those joins by using different types of joins such as Inner Join, Right Join, Left Join, etc. This module will also cover the differences between relationships and joins.
Data Blending is a method for combining data from different sources as it brings additional information from a secondary data source; you will also understand about primary and secondary data sources, blend relationships for blending, how to establish a link, multiple links, and major differences between joins, relationships and blending, with knowledge about some limitations of blending.
Visual representation in chart and graph form helps to get detailed information on the data. To understand data in easy form, this module will cover creating charts in Tableau with all the basic and advanced charts.
When you're finished with this lesson, you'll have the skills and knowledge to apply analytics to a worksheet needed to communicate insights effectively to your users. Here you will learn marks card, highlighting, sorting, grouping, constant sets, bins, hierarchies, and much more.
This Data Science with BI course will establish your mastery of filters in Tableau. You'll learn the essential concepts of Filters and gain in-depth knowledge of dimension filters, date filters, visual filters, context filters, and more. Filters is a required skill for many Data Science positions, so jump-start your career with this interactive, hands-on course.
Tableau offers a variety of data analysis tools to easily explore the data and produce effective visualizations converting simple figures into advanced charts. In this lesson, you'll learn how to use Box and whisker's plot, and different types of charts like Bullet, Bar In Bar, Gantt, Waterfall, Funnel, etc. Also, there will be a brief understanding of Step and Jump Lines, World Cloud, and Donut chart.
Start with some basic calculations, different types of calculations, and some Built-In functions. Also learn, Level of detail (Lod), Nested Lod expression with aggregation and replication, KPI table, table calculations, and helper functions.
This lesson will help you with creating parameters, charts, and column selection parameters, dashboard formatting, tooltips visualization, and layout to create interactive and actionable dashboards for mobile, also creating and updating story points.
In this lesson, you will briefly learn about sharing options in Tableau and the best ways to represent export and print your reports easily.
This module helps you understand how to use dashboards in Tableau to empower more meaningful business decisions. You'll be exposed to the concepts of building interactive dashboards with actions, designing dashboards for devices, and story points.
Level of detail expressions (LOD) expressions allows you to compute values at the data source level and the visualization level. This lesson gives you the information you need to successfully start working with LODS, expression syntax, aggregation, and replication with LOD expressions and Nested LOD expressions.
Data Visualization With Power BI
At this stage, you will learn about live data dashboards, interactive reports, charts, graphs, and other visual representations. You will also learn Power BI tool, which will enable you to visualize and analyze data speedily and efficiently.
This module will help you understand what Power BI is and understands its features and phases. Here you will know the components, architecture, and building blocks of Power BI.
This module gives you the information you need to start working with the Power BI desktop successfully. From Learning the concepts of Overview of Power BI Desktop, Connecting to a Data Sources, Query Editor, Ribbon to Report, data, and model, this module covers all.
Data transformation is converting the data from one format to another, and the process is part of data management tasks. You'll learn to clean, transform, and manage the data in the module.
Data modeling is the process of creating a simplified diagram of a software system. In this module; you will learn various data modeling concepts from the fundamentals to managing data relationships, cross-filter direction, and many-to-many.
Data Analysis Expressions (DAX) is a programming language used throughout Microsoft Power BI to create calculated columns, measures, and custom tables. Hence, it is one of the most essential modules wherein you will learn the importance of DAX, DAX syntax, Data types, operators, DAX functions, queries, tables, and filtering.
The lesson will cover data visualization with Power BI. Concepts like bookmarks, And selection pane, KPI visuals, Z-Order, and much more are covered in the session.
This lesson will begin with the introduction of the Power BI dashboard. Then it'll design the dashboard and make it interactive for the end-users.
Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs. Here you will learn report server basics, web portal, paginated reports, data gateways, and the concept of a scheduled refresh.
During this lesson, you will get in-depth insights into what dashboard is, hands-on training on building a dashboard, layouts, and formatting, interactive dashboards with actions, and designing dashboards for devices along with story points.
Direct connectivity with Power BI helps in importing data and working on large datasets. The lesson will help you to learn live connections To Different Data Sources, Connection To SQL Azure, and much more.
R and Python are both programming languages that can be used in Power BI. This lesson covers Python and R integration with Power BI and using its features in Power BI.
This session will focus on advanced analytics of Power BI. Cluster Analysis, Outlier Detection, Creating Data Flow, introduction To Smart Narrative, and introduction To Sensitivity Labels In Power BI are covered in the lesson.
Data Analytics With Advanced Excel
Enhance your analytical skills with Advanced Excel. You will learn to use different functions to explore the data for better insights at this stage. Plus, it includes hands-on exercises designed by an award-winning excel instructor.
Excel helps you perform complex calculations, data analysis, and much more. In this module, you will know the application of excel and the different industry requirements of Excel.
In this lesson, you will learn how Excel Custom Number Format works, why it is important, and how to apply font, alignment, and number formatting.
The advanced sorting function is used to apply sorts on multiple columns in a report. You will learn how to sort by numbers, text, cell color, font color, cell icon, and custom list at this stage.
Excel can store, maintain, and analyze data into useful information. And this is possible due to Excel's exceptional collection of advanced excel formulas and functions. In this lesson, you will master all of them, including math functions, text functions, conditional logical functions, and more.
This module aims at making you learn the advanced data validation techniques that can help you when you are modeling a complex worksheet. You will learn number, date, and time validation, formula-based validation, error message, circle invalid data, and more.
Learn all about Excel's lookup & reference functions, such as VLOOKUP, HLOOKUP, VLOOKUP & HLOOKUP with exact match and approx match.
INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. Our experts will teach you Index functions, match functions, index with match, and how index match is different from Vlookup.
Pivot tables enable data analysts to summarize large datasets into a concise and meaningful table. You will learn why Pivot Tables for Data Analysis, how to create, and navigate field lists, explore design options, and update them.
Sorting, filtering, and grouping are important functions in Ms. Excel. Get Hands-On experience by learning the working of these elements with pivot tables in Excel.
The lesson will start with the introduction of various charts in Excel and will proceed with different types of charts. Charts like Line charts, Pie & Donut Charts, Clustered Bar charts, and much more will be covered.
After going through the concepts of data analysis, learners will come across the case study of data analysis to understand the concept more clearly.
Get hands-on training on how to create and use Macros, record them, run a macro with a button, edit Macro and learn practical uses of Excel Macro.
Learn VBA concepts, VBA variables, and creating functions in VBA, add Code To A VBA Procedure, understand Excel VBA Variables, building Logic With An IF Statement.
Self-Paced Learning
Get access to high-quality self-paced content curated by top industry experts. Here you will be exposed to a variety of concepts of Data Science that you can learn at your own pace - anytime, anywhere.
Business Problem Solving, Data Visualization, And Insights
Improve your abilities by developing a strong skillset in Business problem solving along with Data Visualization and Insights by covering descriptive statistics, predictive modeling, and probability distributions. Plus, it also includes real-time working on time series forecasting, Different Data Architecture strategies, Business Analytics, and many more skills to master.
In this lesson, you will learn about various business domains for analyzing a company's business domain and its structure. Also, you will learn about the main differences between various business domains. It also includes the four main types of business domains to explore.
Data Analysis is a process of firstly examining and understanding the data and then extracting useful insights from that data. In this lesson, you will learn about two methods, i.e., graphical analysis and non-graphical analysis, for extracting actionable insights.
By learning from this lesson, you can easily create world-class data stories that will show you engaging and beautiful data visualization and narratives, thus converting your data into a reliable source of format.
During this lesson, you will get in-depth knowledge on how you can easily develop insights from raw unstructured data. Also, there will be hands-on learning on many real-world data sets, projects, and many more
Data Visualization With R
Data visualization is the process of converting textual data into graphical form to gain insightful knowledge faster. The whole module will help you to get an understanding of charts, and histograms, with the help of the programming language R.
Understanding data without graphics is difficult, and thus this module introduces you to the concept of data visualization. The module also covers ggplot 2 usage, bar charts, histograms, and plotting pie charts.
After understanding the basic concepts, it's time to move to the next level of data visualization. You'll then be able to use different types of advanced charts, including geographical features like maps.
Creating charts and graphs is as much important as displaying them. The module will help you to understand why dashboards are important and how to build one. Finally, you'll learn to generate reports from R.
Data Analysis with R
R is the programming language that is used by introductory-level analyst jobs. The language helps in finding solutions for the given problems. The lessons below in the module will help you to learn important techniques of wrangling.
Data analysis comes into the picture when there's a problem that is required to be solved. R programming language comes with all the required tools to solve that problem.
Data wrangling, also known as pre-processing of data is the processing of converting raw, unstructured data into an easily accessible format. The lesson will provide inside all the concepts of data wrangling with tools in R.
Exploratory data analysis or EDA is the process of understanding and then summarizing the data to gain better insights. The module will help you to learn techniques for exploratory data analysis.
After managing your data, it is time to develop the model for your main analysis part. The learners will learn the techniques to understand and evaluate the results in the module.
Industry Projects
In this certificate program, you would also get real-life exposure through Industry Projects along with the mentorship from E&ICT Academy IIT Guwahati Faculty. These projects will be a part of your Certification in Data Science & Business Intelligence to enhance your knowledge. You will be working on real-world datasets under the guidance of world-class industry experts.
Receive an Advanced Certification in Data Science and BI from E&ICT Academy IIT Guwahati.
Career Assistance
Why Fingertips?
2x Faster Career Growth
We have a participative and activity-based learning mechanism to help you master the most in-demand skills that most of the top companies are looking for.
Real-World Projects
You get hands-on exposure to industry-relevant live projects related to Data Science and Business Intelligence.
Doubt-Solving Sessions
There is distinctive support for Non-Technical learners with regular doubt-solving sessions by industry experts.
Dedicated Program Manager
A separate instructor i.e., a Dedicated Program manager will be with you to guide you during the entire certificate program.
Our Alumni Work At
We have partnered with the following financing companies to provide no-cost EMI and competitive finance options with no hidden costs.
- 6 Months Program
- Certification from E&ICT Academy IIT Guwahati
- Certification from E&ICT Academy IIT Guwahati
- 100% Job Assistance
We have partnered with the following financing companies to provide no-cost EMI and competitive finance options with no hidden costs.
Frequently Asked Questions