Swapnil Savaratkar Data analyst
No reviews yet

Step-by-step guide to get started with learning Excel, Power BI, and SQL:

**Excel:**
1. **Basic Functions:** Begin by learning basic functions like SUM, AVERAGE, COUNT, and IF statements.
2. **Formatting:** Understand cell formatting, number formats, and styles to enhance readability.
3. **Charts and Graphs:** Learn to create various charts and graphs to visualize data.
4. **Data Analysis:** Explore features like Sorting, Filtering, and Pivot Tables for data analysis.
5. **Formulas:** Dive deeper into complex formulas like VLOOKUP, HLOOKUP, and INDEX-MATCH.
6. **Conditional Formatting:** Master conditional formatting to highlight data based on conditions.
7. **Data Validation:** Learn to set up data validation rules to ensure data accuracy.
8. **Macros (Optional):** If interested, delve into VBA programming for automating tasks.

**Power BI:**
1. **Introduction:** Understand the Power BI interface and components like visuals, fields, and filters.
2. **Data Import:** Learn to connect Power BI to various data sources like Excel, databases, and online services.
3. **Data Transformation:** Explore Power Query Editor to clean, transform, and shape your data.
4. **Data Modeling:** Create relationships between tables and build a data model for analysis.
5. **Data Visualization:** Design interactive and insightful dashboards using various visuals.
6. **DAX (Data Analysis Expressions):** Gain proficiency in DAX functions for calculations and aggregations.
7. **Filters and Slicers:** Implement filters and slicers for dynamic data exploration.
8. **Publishing and Sharing:** Learn to publish your reports to Power BI Service and share them securely.

**SQL:**
1. **Introduction:** Understand what databases and SQL are, and the importance of relational databases.
2. **Basic Queries:** Learn to write SELECT statements to retrieve data from a single table.
3. **Sorting and Filtering:** Add ORDER BY and WHERE clauses to your queries.
4. **Joins:** Understand different types of joins (INNER, LEFT, RIGHT, FULL) to combine data from multiple tables.
5. **Aggregations:** Use functions like COUNT, SUM, AVG, and GROUP BY for data summarization.
6. **Subqueries:** Explore subqueries to retrieve data from nested queries.
7. **Database Design:** Learn about creating tables, defining relationships, and ensuring data integrity.
8. **Indexes and Optimization:** Understand indexing and optimization techniques for efficient querying.
9. **Views and Stored Procedures:** Dive into creating views and stored procedures for better organization.
10. **Normalization (Advanced):** If desired, study database normalization to optimize data structure.

Subjects

  • Power BI Expert

  • VBA & Macro Expert

  • SQL Queries Expert

  • Excel & Research Data Analysis Expert

Experience

  • SENIOR MIS EXECUTIVE (Sep, 2020–Present) at Ziff Davis Performance Marketing
    Working on Excel, Power Bi,SQL, and VBA.

Education

  • BSC (Jun, 2014–Jun, 2016) from Shivaji University, Kolhapur

Fee details

    ₹8,000–12,000/month (US$92.56–138.84/month)

    Excel beginner to advanced 8000
    Excel Advanced(INCLUDE VBA ) 10000
    POWER BI 12000
    SQL 8000

Reviews

No reviews yet. Be the first one to review this tutor.