Typical class size
10(Students)Tableau is a data visualization and business intelligence tool that helps people see and understand data. It provides an interactive and intuitive interface for creating powerful visualizations that are easy to understand and share. It is used by businesses and organizations of all sizes, from startups to Fortune 500 companies.
Power BI is a business analytics service provided by Microsoft that helps in creating interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any other technology. Power BI is used by hundreds of organizations around the world, including IBM, Visa, Microsoft, Netflix, Unilever, Salesforce, Adobe, Walmart, and Dell Technologies, among many others.
************************************SQL ****************************************************
1. What Is Database And Evaluation Of DBMS
2. Types Of Database And Life Of DB
3. SQL Server Intro And Versions Of SQl Server
4. About SSMS(SQl Server Management Studio)
5. Creating Database
6. Creating Table In DB (Create)
7. Data Types
8. Types Of Commands In SQL
9. [(DDL (Data Defination Language), DML (Data Manuplation Language),DCL (Data Control
10. Language), TCL (Transaction Control Language), DQL (Data Query Language)]
11. Insert Data Into Table ( Insert)
12. Display Data From Table (Select)
13. Where Clause
14. Between , IN , Like
15. Identity Command / auto Increment
16. Orderby Clause
17. Types Of Functions [ Aggrigate functions / Group Functions , Date Functions, Character
18. Functions/String Functions, Mathematical Functions / Numerical Functions]
19. Having Clause
20. Difference Between Where And Having Clause
21. Rollup And Cube Commands
22. Constraints [Primarykey, Foreignkey, Not Null, Unique, Check, Default]
23. Joins
24. Set Operators
25. Subqueries And Types
Project 1
****************************************** Power BI******************************************************
1. Day 1: Introduction to Power BI
- Overview of Power BI Desktop
- Understanding Power BI components: Desktop, Service, Mobile
- Installation and setup
2. Day 2: Data Loading and Transformation
- Importing data from various sources (Excel, CSV, databases)
- Transforming data using Power Query Editor
- Combining and shaping data
3. Day 3: Data Modeling in Power BI
- Introduction to data modeling concepts (relationships, cardinality)
- Creating relationships between tables
- Introduction to star schema
4. Day 4: Introduction to DAX (Data Analysis Expressions)
- Understanding DAX syntax and functions
- Creating calculated columns and measures
- Basic DAX functions: CALCULATE, SUM, AVERAGE
Project : Create calculated columns and measures to calculate total sales, average sales, and profit margin based on the sales data imported earlier.
5. Day 5: Advanced DAX Functions
- Working with time intelligence functions (DATESYTD, DATEADD, etc.)
- Using CALCULATE with filters
- Introduction to iterators (SUMX, FILTER, etc.)
6. Day 6: Visualization Basics
- Creating basic visualizations (bar charts, line charts, etc.)
- Formatting visuals and applying themes
- Working with slicers and filters
Project : Create visualizations to analyze sales trends over time, compare performance across regions, and identify top-selling products.
7. Day 7: Advanced Visualization Techniques
- Creating advanced visuals (maps, scatter plots, etc.)
- Using custom visuals from AppSource
- Applying conditional formatting
8. Day 8: Dashboard Design Principles
- Designing effective dashboards for user engagement
- Adding interactivity with drill-through and bookmarks
- Best practices for layout and storytelling
Project : Design an interactive sales dashboard with multiple visualizations showing sales performance by region, product category, and customer segment.
9. Day 9: Advanced Data Analysis
- Using advanced DAX patterns (ranking, segmentation, etc.)
- Implementing advanced calculations and KPIs
10. Day 10: Advanced Insights and Reporting
- Analyzing data trends and patterns
- Creating insightful reports with actionable insights
Project : Perform in-depth analysis of sales data to identify key trends, outliers, and opportunities for improvement. Present findings in a comprehensive report.
11. Day 11: Collaboration and Sharing
- Collaborating with colleagues using Power BI Service
- Publishing reports to Power BI Service
- Sharing reports and dashboards with stakeholders
12. Day 12: Project Deployment and Presentation
- Finalizing project implementation
- Presenting projects to peers for feedback
- Tips for ongoing learning and community engagement
Project : Publish the completed projects to Power BI Service, share them with peers or stakeholders, and present them in a showcase presentation.
**************************** Excel and Googlesheets ****************************
WHAT IS EXCEL AND GOOGLE SHEETS?
EXCEL & GOOGLE SHEETS OVERVIEW.
EXCEL FILL, ADD, DELETE, UNDO, REDO
EXCEL FORMULAS, RELATIVE & ABSOLUTE REFERENCE
ARTHIMETIC OPERATIONS
EXCEL FUNCTIONS
EXCEL FORMATTING
EXCEL DATA ANALYSIS
PIVOT TABLE
FUZZY LOGIC
POWER QUERY
BASIC MARCOS
-------------------- Tableu----------------------------------------------
1. Day 1: Introduction to Tableau
- Overview of Tableau Desktop
- Understanding Tableau workspace
- Installation and setup
2. Day 2: Data Connection and Loading
- Importing data from various sources (Excel, CSV, databases)
- Understanding data connection options in Tableau
- Basic data preparation and cleaning
Project : Import sales data from an Excel spreadsheet into Tableau, and perform basic data cleaning tasks such as removing duplicates and handling missing values.
3. Day 3: Basic Visualization Techniques
- Creating basic visualizations (bar charts, line charts, etc.)
- Formatting visuals and applying colors
- Adding labels and tooltips
4. Day 4: Intermediate Visualization Techniques
- Working with different chart types (scatter plots, histograms, etc.)
- Using dual-axis and combination charts
- Customizing axes and reference lines
Project : Create visualizations to analyze sales trends over time, compare performance across regions, and identify top-selling products.
5. Day 5: Advanced Visualization Techniques
- Creating advanced visuals (maps, heatmaps, etc.)
- Using parameters and sets for dynamic visualizations
- Applying trend lines and forecasting
6. Day 6: Dashboard Design Principles
- Designing effective dashboards for user engagement
- Adding interactivity with actions and filters
- Best practices for layout and storytelling
Project : Design an interactive sales dashboard with multiple visualizations showing sales performance by region, product category, and customer segment.
7. Day 7: Introduction to Calculations
- Understanding Tableau calculations (calculated fields, calculated measures)
- Using basic calculations for analysis
8. Day 8: Advanced Analytics and Collaboration
- Performing advanced analytics with LOD (Level of Detail) expressions
- Collaboration and sharing using Tableau Server or Tableau Public
- Finalizing projects and presentation skills
Project : Perform in-depth analysis of sales data to identify key trends, outliers, and opportunities for improvement. Present findings in a comprehensive report.
No Prior knowledge is required
