Advanced Training with Real-Time Case study
- Understanding the concepts of SQL, Tableau, and use them in problem solving.
- Upgrade your Resume with skills which are in demand
- Understanding the process of Gathering the Data, Analyzing the Data and Visualizing the Data
- Using the Data in way which aids in better Business Decision Making
- Presenting useful insights in the form of metrics, KPIs, reports and Dashboards
- Performing Qualitative and Quantitative Business Analysis
- Understanding the importance of analyzing the Current and Historical Data
- Learning how to discover the market conditions, trends and understanding the competitor’s hold in the Market
- Understanding the Basics of Database theory
- Understanding the working of SQL and using it to create, design and manipulate the Databases
- Fetching required data from a Database.
- Creating insightful visualizations in Tableau
- Visualizing the Data using SQL and Tableau
- Understanding the use of SQL and Tableau in solving real time scenarios
Welcome to the course of Business Intelligence Analyst, which is specially designed for you. We have trainers who have experience of more than 12+ years of Industry and who specially took care to design this course in a way that will aid to the needs of all the fresher or the ones who already know about the tools and want to brush their skills.
Our program is different than the rest of the materials available online.
Our Course is designed into various modules that will help you in understanding the concepts in a way that makes it easy to grasp things easily
- Introduction to Data and Data Science
- Database theory
- SQL + Tableau
These are the basic needs of technical skills that are always required when one is applying for BI Analysts. Acquiring these skills set will add to more value to your resume and will help you in boosting your confidence in the field of Business Intelligence.
- Introduction to Data and Data Science – Intuition to terms like Business Intelligence, traditional and Big Data, understanding about how statistics work in real life and get to know about various other topics like Predictive analysis, Supervised Learning, Unsupervised Learning and many more.
- Database theory – In this course we focus on leaning about what are databases how they are created and how can we manipulate them according to our need. We will help you in understanding the concepts from the basics to the advanced level.
- SQL – Hands on practicing with managing database using real life examples and understanding deeply how the queries work in SQL.
- Tableau – Most powerful tool in the Business Intelligence is the Tableau, in this course we will help you to understand how to make beautiful and informative visualizations which we render in informing resourceful insights to the Business. We have created real life cases problem solving concept to help you understand the process of creating Visualizations in Tableau.
- Those who are new to Programming and to concepts of Data Science.
- Those who want to enhance their resume by acquiring knowledge about SQL, Tableau and Programming in real life scenarios of the Business.
- People interested in a Business Intelligence Analyst career
Lecture 1: Tableau Desktop – An Idea
Lecture 2: Tableau Desktop – An Introduction
Lecture 3: Map Chart in Tableau
Lecture 4: Scatter Plot in Tableau
Lecture 5: My First Dashboard
Lecture 6: Action Url in Tableau
Lecture 7: Donut chart in Tableau
Lecture 8: Histogram in Tableau
Lecture 9: How to make Histogram dynamic
Lecture 10: Box and Whisker plot – An Intuition
Lecture 11: Box and Whisker plot in Tableau
Lecture 12: Treemap in Tableau
Lecture 13: Dashboard and Story in Tableau
Lecture 14: Introduction to Join
Lecture 15: Data Blending in Tableau
Lecture 16: Data Blending in Tableau – Part 2
Lecture 17: Creating the static sets in Tableau
Lecture 18: Creating the Dynamic sets in Tableau
Lecture 19: Creating the Combined Sets in Tableau
Lecture 20: Adding reference Lines and beautifying the charts
Lecture 21: Finalizing the Dashboard
Lecture 22: Tableau Desktop – Table Calculations
Lecture 23: Tableau – Some more cool features
Lecture 24: Tableau Desktop – Animations and Background Images
Lecture 25: Tableau Desktop – Level of Details
Lecture 26: Tableau Desktop – Custom Charts
Lecture 27: Tableau Desktop – Dashboard Techniques
Lecture 28: Tableau Desktop – Database connectivity
Lecture 29: Tableau Desktop – Integration with R
Lecture 30: Tableau Desktop – How to integrate Tableau with web pageLecture 31: R & R studio Environment Installation
Lecture 32: Installing packages in R studio, Using libraries of R service, How to Start R Service,
Lecture 33: Connecting Tableau with R.
Lecture 34: Implementing the functions of tableau SCRIP_Int, SCRIPT_Real, SCRIPT_Bool, SCRIPT_Str
Lecture 35: What is Tableau Online & Server and difference between both?
Lecture 36: Environment Installations and signup functionalities
Lecture 37: User Interface, How to create project, Name the projects
Lecture 38: Content Management, Scheduling Refreshes, How to create users and groups
Lecture 39: Row level security, User permissions and roles, user filters
Lecture 40: How to publish separate worksheets and dashboards
Lecture 41: How to publish data sources separately and create workbooks and reports in tableau server or online
Lecture 42: How to subscribe the reports, alerts and account settings of site administrator
Lecture 43: How to create pdf and images of reports on tableau online or server
Lecture 44: Case Study 01 : SALES DASHBOARD
Lecture 45: Cases Study 02 |Sorting Multiple Column
Lecture 46: Cases Study 03
Lecture 47: Cases Study 04
Lecture 48: Interview preparation and guidelines
Lecture 49: Assignments will be given and also checked for respective topics.
Instructor-led training and 24 hours of self-paced video
Access to E-learning with Training Material .
Learn Tableau 10 for Data Science step-by-step. Real-Life Data Analytics Exercises & Quizzes Included. Learn by doing!
Average salary of a Tableau professional is $100,000 ( Indeed.com )
Lifetime Access and 24/7 Support.
Instructor-led live online classes
OFFER ! Pay an 'Early Bird' deposit now and save 10% on the final price!
Sat - Sun ( 5 Weeks )
7:30 AM - 8:30 AM(IST)
40% Off till 27-Jan
A much advanced, direct, precise and ordered way of viewing large volumes of data is called data visualization. It is the visual representation of data in the form of graphs and charts, especially when you can’t define it textually. You can show trends, patters and correlations through various data visualization software and tools; Tableau is one such data visualization software used by businesses and corporates
While Tableau desktop performs data visualization and workbook creation, Tableau server is used to distribute these interactive workbooks and/or reports to the right audience. Users can edit and update the workbooks and dashboards online or Server but cannot create new ones. However, there are limited editing options when compared to desktop.
Tableau Public is again a free tool consisting of Desktop and Server components accessible to anyone.
Tableau parameters are dynamic variables/values that replace the constant values in data calculations and filters. For instance, you can create a calculated field value returning true when the score is greater than 80, and otherwise false. Using parameters, one can replace the constant value of 80 and control it dynamically in the formula.
Facts are the numeric metrics or measurable quantities of the data, which can be analyzed by dimension table. Facts are stores in Fact table that contain foreign keys referring uniquely to the associated dimension tables. The fact table supports data storage at atomic level and thus, allows more number of records to be inserted at one time. For instance, a Sales Fact table can have product key, customer key, promotion key, items sold, referring to a specific event.
- Dimensions are the descriptive attribute values for multiple dimensions of each attribute, defining multiple characteristics. A dimension table ,having reference of a product key form the fact table, can consist of product name, product type, size, color, description, etc.
Global quick filters are a way to filter each worksheet on a dashboard until each of them contains a dimension. They are very useful for worksheets using the same data source, which sometimes proves to a disadvantage and generate slow results. Thus, parameters are more useful.
Parameters facilitate only four ways to represent data on a dashboard (which are seven in quick filters). Further, parameters do not allow multiple selections in a filter.
The concept of context filter in Tableau makes the process of filtering smooth and straightforward. It establishes a filtering hierarchy where all other filters present refer to the context filter for their subsequent operations. The other filters now process data that has been passed through the context filter.
Creating one or more context filters improves performance as users do not have to create extra filters on large data source, reducing the query-execution time.
You can create by dragging a filed into ‘Filters’ tab and then, Right-Click that field and select ‘’Add to Context”.
There are a number of file types and extensions in Tableau :
- Tableau Workbook (.twb).
- Tableau Packaged Workbook (.twbx).
- Tableau Datasource (.tds).
- Tableau Packaged Datasource (.tdsx).
- Tableau Data extract (.tde).
- Tableau Bookmark (.tdm).
- Tableau Map Source (.tms).
- Tableau Preferences (.tps)
.twb is the most common file extension used in Tableau, which presents an XML format file and comprises all the information present in each dashboard and sheet like what fields are used in the views, styles and formatting applied to a sheet and dashboard.But this workbook does not contain any data. The Packaged workbook merges the information in a Tableau workbook with the local data available (which is not on server). .twbx serves as a zip file, which will include custom images if any. Packaged Workbook allows users to share their workbook information with other Tableau Desktop users and let them open it in Tableau Reader.
Polymorphism is briefly described as “one interface, many implementations”. Polymorphism is a characteristic of being able to assign a different meaning or usage to something in different contexts – specifically, to allow an entity such as a variable, a function, or an object to have more than one form. There are two types of polymorphism:
- Compile time polymorphism
- Run time polymorphism
Association is a relationship where all object have their own lifecycle and there is no owner. Let’s take an example of Teacher and Student. Multiple students can associate with a single teacher and a single student can associate with multiple teachers but there is no ownership between the objects and both have their own lifecycle. These relationship can be one to one, One to many, many to one and many to many.
On-time scheduled virtual classes with limited trainer-student ratio.
Best industry experts with years of online training experience.
Based on your expertise and goals we design course for you.
Learn at your schedule , time zone and convenience.
Receive a certificate to confirm the level of your skills in a professional context.
Get A Quote
Please fill your details. Fields marked with mandatory are mandatory
Application Prog.BI and VisualizationBiz. Productivity ToolCloud ComputingData Science & Big DataData Warehousing & ETLDesign ToolsDevOpsDigital MarketingERP
[" SAP SD Advanced, ERP, 4, SAP-SD--Advanced "," SAP SD Basics, ERP, 4, SAP-SD-Basics "," SSIS, Data Warehousing & ETL, 2, SSIS "," Pentaho Data Integration, Data Warehousing & ETL, 2, Pentaho-Data-Integration "," Tableau Expert, BI and Visualization, 9, Tableau-Expert "," Excel Reporting - Basic, Biz. Productivity Tool, 16, Excel-Reporting---Basic "," Excel Reporting - Advanced, Biz. Productivity Tool, 16, Excel-Reporting---Advanced "," Microsoft Asp.Net Full Stack, Application Prog., 1, Microsoft-Asp.Net-Full-Stack "," Tableau Desktop Training, BI and Visualization, 9, Tableau-Desktop-Training "," Python, Data Science & Big Data, 18, Python "," DJANGO, Application Prog., 1, DJANGO "," Share Point Basic, Application Prog., 1, Share-Point-Basic "," AWS Sol. Architect Pro, Cloud Computing, 11, AWS-Sol.-Architect-Pro "," AWS Sol. Architect Ass., Cloud Computing, 11, AWS-Sol.-Architect-Ass. "," Talend Data Integration, Data Warehousing & ETL, 2, Talend-Data-Integration "," Hardware And Networking, Networking H\/W, 12, Hardware-And-Networking "," CCNA, Networking H\/W, 12, CCNA "," Angular Full Stack Training, Application Prog., 1, Angular-Full-Stack-Training "," MEAN Stack Training, Application Prog., 1, MEAN-Stack-Training "," Azure Dev Ops Training, DevOps, 13, Azure-Dev-Ops-Training "," Azure Certification Training, Cloud Computing, 11, Azure-Certification-Training "," MVC And Entity Framework, Application Prog., 1, MVC-And--Entity-Framework "," ASP Dot Net Csharp Basic, Application Prog., 1, ASP-Dot-Net-Csharp-Basic "," PENTAHO BI BA, BI and Visualization, 9, PENTAHO-BI-BA "," SQL, Data Warehousing & ETL, 2, SQL "," SSIS And SSRS, BI and Visualization, 9, SSIS-And-SSRS "," MSBI, BI and Visualization, 9, MSBI "," MCSA 70 740, Networking H\/W, 12, MCSA-70-740 "," MCSA 70 741, Networking H\/W, 12, MCSA-70-741 "," MCSA 70 742, Networking H\/W, 12, MCSA-70-742 "," VBA, Biz. Productivity Tool, 16, VBA "," Sales Force, Salesforce, 14, Sales-Force "," SQL Server 2016 DBA, Data Warehousing & ETL, 2, SQL-Server-2016-DBA "," C, Application Prog., 1, C "," C Plus Plus, Application Prog., 1, C-Plus-Plus "," iOS Development, Mobile Development, 15, iOS-Development "," PHP, Application Prog., 1, PHP "," SAP BI BW, BI and Visualization, 9, SAP-BI-BW "," QlikView QlikSense, BI and Visualization, 9, QlikView-QlikSense "," Digital Marketing Specialist, Digital Marketing, 17, Digital-Marketing-Specialist "," Programming in Java 7-With Project, Application Prog., 1, Programming-in-Java-7-With-Project "," Java Advanced, Application Prog., 1, Java-Advanced "," Android Training, Mobile Development, 15, Android-Training "," Python Data Science Ad, Data Science & Big Data, 18, Python-Data-Science-Ad "," Hadoop Bigdata, Data Science & Big Data, 18, Hadoop-Bigdata "," Informatica Powercenter, Data Warehousing & ETL, 2, Informatica-Powercenter "," Oracle DBA, Data Warehousing & ETL, 2, Oracle-DBA "," Oracle 11g, Data Warehousing & ETL, 2, Oracle-11g "," Power BI, BI and Visualization, 9, Power-BI "," Oracle 11g DBA, Data Warehousing & ETL, 2, Oracle-11g-DBA "," HTML Developer, Application Prog., 1, HTML-Developer "," Asp .Net Web API, Application Prog., 1, Asp-.Net-Web-API "," ASP Dot Net Csharp Advance, Application Prog., 1, ASP-Dot-Net-Csharp-Advance "," ASP Dot Net Csharp Full, Application Prog., 1, ASP-Dot-Net-Csharp--Full "," SAP HANA, BI and Visualization, 9, SAP-HANA "," SAP ABAP, BI and Visualization, 9, SAP-ABAP "," SAP BO, BI and Visualization, 9, SAP-BO "," Photoshop, Design Tools, 19, Photoshop "," Adobe Flash, Design Tools, 19, Adobe-Flash "," Illustrator, Design Tools, 19, Illustrator "," CorelDraw, Design Tools, 19, CorelDraw "," Google Sketchup, Design Tools, 19, Google-Sketchup "," Adobe Premiere Pro, Design Tools, 19, Adobe-Premiere-Pro "," Digital Marketing Internship, Internship, 20, Digital-Marketing-Internship "," AWS Dev. Ass. Certification, Cloud Computing, 11, AWS-Dev.-Ass.-Certification "," SEO Internship, Internship, 20, SEO-Internship "," Advanced Machine learning with R, Internship, 20, Advanced-Machine-learning-with-R "," Data Science Internship, Internship, 20, Data-Science-Internship "," AI with Python, Internship, 20, AI-with-Python "," Advance Python With ML, Data Science & Big Data, 18, Advance-Python-With-ML "," Master Python, Data Science & Big Data, 18, Master-Python "," Azure for .Net Developers, Cloud Computing, 11, Azure-for-.Net-Developers "," Workshop Excel Advance, Biz. Productivity Tool, 16, Workshop-Excel-Advance "," UI UX Design Specialization, Design Tools, 19, UI-UX-Design-Specialization "]