Learn MSBI, SQL Server, Power BI and Tableau With Project Based Examples Step By Step
43 MSBI Labs, 21Sql Server Labs, Power BI 6 Labs and Tableau 10 Labs
What you'll learn :-
Learn MSBI in 4 days with Project
* Should be able to work on professional MSBI projects.
* Design database using star schema and snow flake ,Create ETL using SSIS ,
* Cubes using SSAS and display reports using SSRS.
* Learn SSIS Data flow , control flow, error handling, variables ,
* for loop containers, SCD ,Sort , merge , merge joins ,look up ,
* transactions and checkpoints.Displaying report in SSRS, Tabular reporting ,
* Matrix reporting , report parameters , sorting , interactive sorting,
* expressions, running total , cascading drop downs and importance of RDL files.
* In SSAS you will learn MDX , tabular , hierarchical dimension , KPI , Calculated members ,
* Aggregations , perspectives , translations , Many to many relationship ,
* reference relationship and processing SSAS cubes at background.
* tables , rows and columns. Covers fundamentals like primary key,
* foreign key , referential integrity , constraints , normalization ( first , second and third normal forms),
* Denormalization,OLTP , OLAP, StarSchema and SnowFlake design.
* Writing DML and DDL query like inner join,left join,right join, outer join,
* union , co-related queries, union all, alias,case statements,cartesian,
* ISNULL, aggregate( sum/count),wild card , top, order by, create , insert,
* bulk insert , update , backup , restore,ISNULL,Coalesce,Row_Number, Partition,
* Rank ,DenseRank , Pivot and Unpivot.Understanding importance of indexes ,
* how it makes our search faster , non-clustered indexes vs clustered indexes ,
* page splits in indexes and column store indexes.Triggers,Insteadof ,
* After trigger ,Inserted , deleted tables ,Stored Procedures,CDC,
* data fields , models , designer ,Visualization component :- Table ,
* bar chart , line chart , pie chart , map , card , stacked chart ,
* Gauge , KPI and Funnel graph.DAX basics , Cloning , Filter ,
* SUM , SUMX ,FilterContext , RowContext,All , AllExcept,
* Inner join , left join , right jon , cross join and Summarize.
* Covers Calculate columns , measures , slicer , sharing report online ,
* pages in power BI , power query editor, modelling relationships,
* Import vs Direct Query and Connecting to SQL Server.Fact , dimension tables,
* OLAP , OLTP Design , Star schema , Snow flake and Denormalizaed design
* Publishing/distributing report, various interface, Tableau file extensions.Datatypes,
* Managing Metadata & Extracts, Cross Database Joins,
* Data Blending.Cube and Relational Datasource with their difference,
* Data preparation in Tableau.Visual Analytics(Sorting, Grouping, Filters,
* Drill Down , Hierarchies,Parameters, Forecasting, Clustering & Trend)
* Dashboard , Maps and Charts of tableau.
Learn MSBI in 4 days with Project
==========================
Lab 1 :- MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house. (SSIS)
Lab 1.1 MSBI Installation in Details (Upgrade Lab)
Lab 2:- Conditional split, Data conversion and Error handling. (SSIS)
Lab 3:- For Loop, Variables, Parameters and Debugging. (SSIS)
Lab 4:- Packaging and Deployment, File component and running SSIS package as a task.(SSIS)
Lab 5: - For dimension, measures, star schema, snow flake, shared connection managers & packages tasks.(SSIS)
Lab 6:- SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(SSIS)
Lab 7:- Lookup, Data conversion optimization and updating SSIS package.(SSIS)
Lab 8:- Sort, Merge and Merge Joins.(SSIS)
Lab 9 :- Creating SSAS Cube. (SSAS)
Lab 10:- SSAS Time series and Excel display.(SSAS)
Lab11: - What are Transactions and CheckPoints in SSIS? (SSIS)
Lab12: - Simple SSRS report & implementing Matrix, Tabular, Parameters, Sorting, Expressions. (SSRS)
Lab 13:- Using Data Profiling task to check data quality. (SSIS)
Lab 14:- Hierarchical Dimensions. (SSAS)
Lab 15:- WebServices and XML Task. (SSIS)
Lab16:- DrillDown and Subreports. (SSRS)
Lab17 :- SSAS KPI (Key Performance Indicators). (SSAS)
Lab 18:- Pivot, UnPivot and Aggregation. (SSIS)
Lab 19 :- SSAS Calculation.(SSAS)
Lab 20:- SQL Execute Task. (SSIS)
Lab 21:- Reference and Many-to-Many Relationship. (SSAS)
Lab 22 :- Script Task and Send Mail Task. (SSIS)
Lab 23 :- Script component(SSIS)
Lab 24 :- Bar chart, Gauge and Indicators.(SSRS)
Lab 25:- Partitions in SSAS. (SSAS)
Lab 26 :- CDC(Changed Data Capture) in SSIS. (SSIS)
Lab 27:- Additive, Semiadditive and non-additive measures in SSAS.(SSAS)
Lab 28:- Buffer Size Tuning (SSIS)
Lab 29 :- How to implement Multithreading in SSIS?(SSIS)
Lab 30:- Processing SSAS cube in background.(SSAS)
Lab 31 :- Explain Asynchronous, Synchronous, Full, Semi and Non blocking Components. (SSIS)
Lab 32 :- SSRS Architecture and Deployment (SSRS)
Lab 33 :- DQS( Data Quality Services ) (SSIS)
Lab 34 :- Explain Tabular Model and Power Pivot (SSAS).
Lab 35 :- MDX (Multidimensional Expressions) Queries.(SSAS)
Lab 36 :- Data Mining (Fundamentals and Time Series Algorithm).(SSAS)
Lab 37 :- Page Split and Performance issues with SSIS.(SSIS)
Lab 38 :- Aggregations in SSAS.(SSAS)
Lab 39 :- ROLAP, MOLAP and HOLAP.(SSAS)
Lab 40 :- Instrumentation using Data Taps (SSIS).
Lab 41:- Lookup caching modes and Cache Transform.
Lab 42: - Perspectives & Translations. (SSAS)
Lab 43 :- Tabular Training 1 :- Installation, Xvelocity, Vertipaq, DAX,Creating cubes,measures, KPI, Partition and Translation.
Learn SQL Server Step by Step
=========================
Lab 1:- Basic Fundamentals Database, Tables, rows and columns.
Lab 2:- Primary key, foreign key, referential integrity and constraints.
Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).
Lab 4: - SQL basics(Select, Insert, Update and Delete)
Lab 5 :- DDL (Data definition language) Queries.
Lab 6: - Transactions, Locks and Isolation level in SQL Server.
Lab 7: - ISNULL and Coalesce functions.
Lab 8: - Row_Number, Partition, Rank and DenseRank
Lab 9: - Triggers, inserted and deleted tables
Lab 10: - Instead of and after triggers.
Lab 11: - Denormalization, OLTP and OLAP.
Lab 12: - Understanding Star schema and Snow flake design.
Lab 13: - SQL Server 8 kb pages.
Lab 14 :- Index and performances
Lab 15 :- Page Split and indexes
Lab 16 :- Clustered vs non-clustered
Lab 17: - Stored procedures and their importance.
Lab 18: - Change Data Capture.
Lab 19: - Explain Columnstore Indexes?
Lab 20: - SQL Server agent
Lab 21: - How can we implement Pivot & Unpivot in SQL Server?
Lab 2: - Publishing/distributing report, various interface, Tableau file extensions.
Lab 3: - Datatypes, Managing Metadata & Extracts, Cross Database Joins, Data Blending.
Lab 4: - Explaining Cube and Relational Datasource with their difference, Data preparation in Tableau.
Lab 5: - Visual Analytics(Sorting, Grouping, Filters, Drill Down & Hierarchies) - Part 1.
Lab 6: - Visual Analytics(Parameters, Forecasting, Clustering & Trend) - Part 2.
Lab 7: - Explaining and Creating Dashboards & Stories in Tableau.
Lab 8: - Understanding, using various options & services in creating, customizing Maps in Tableau.
Lab 9: - Explaining different Calculations and LOD(Level of Detail) expression in Tableau workbook.
Lab 10: - Exploring and working with different types of Charts available in Tableau.
World-class training and development programs developed by top teachers
Whats Included
- World-class training teacher
- Bench has zero learning curve
- We handle the rest.