×

Power BI , Tableau, Excel, Google sheets and SQL

Power BI , Tableau, Excel, Google sheets and SQL

course-meta
Instructors
Mr.Kalyan and Mr. Jai

3x per week

45 sessions

session duration

60

Typical class size

10(Students)

Description

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.

What you'll learn

    ************************************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.
     

Requirements

    No Prior knowledge is required

Course Curriculum

image not found
15000.00
  • Level
    Basic to Advanced
  • Lectures
    45 Lectures
  • Duration
    45
  • Language
    English
  • Access
    limited
  • Certificate
    no

Enquiry Now

6+1 = ?