Prashansha Bajpai DATA ANALYST, EXCEL, POWER BI
No reviews yet

To be honest, I do not support all these classifications of teaching styles and methodologies. It is a lot of theory, but it has little to do with the real environment of a classroom, where always different personalities meet, and one has to work with students of all levels of abilities. I simply try my best with each student - that's the definition of my teaching style. It may mean one thing in one lesson and a completely different one in another. I may give complete freedom to some students, but lead others with an iron fist. But I prefer not to use some empty classifications that have nothing to do with the actual challenges we face in classes.

Subjects

Power BI Expert
Power BI dashboard Intermediate-Expert
Excel (Basic) Beginner-Intermediate
Excel for Analysis Beginner-Expert

Experience

Data Analyst Intern (Nov, 2022–May, 2023) at Sales Point Inc. Nagpur

Analyzed and visualized data using Microsoft Power BI and Excel to provide actionable insights.
Conducted real-time troubleshooting and problem resolution, ensuring data accuracy and integrity.
Collaborated with cross-functional teams to streamline data processes and enhance reporting efficiency.
Data Analyst Intern (Oct, 2022–Jun, 2023) at 1 year work in data analytics

Executed data analysis using Microsoft Excel, Power BI, Tableau, and SQL in a dynamic work environment.
Applied statistical models to solve complex problems and presented findings to stakeholders.
Contributed to three significant projects:
Insurance Analysis: Conducted in-depth analysis, identified trends, and provided recommendations for risk management.
Zomato Analysis: Analyzed user behavior, preferences, and trends to enhance marketing strategies.
Sales Analysis: Developed comprehensive reports to optimize sales strategies and improve overall performance.

Education

DATA ANALYSIS (Oct, 2022–Jun, 2023) from Others
MASTERS OF SOCIAL WORK (Jul, 2017–Jun, 2019) from Guru ghasidas University, Koni Bilaspur

Fee details

₹200–600/hour (US$2.38–7.14/hour)

Courses offered

Power Bi
- ₹500
- Duration: 10days
- Delivery mode: Online
- Group size: 6 - 10
- Instruction language: Hindi, English
- Certificate provided: No
Power BI is a powerful business analytics tool developed by Microsoft. It allows users to connect to various data sources, transform the data, and create interactive visualizations and reports. Here are some expert tips and knowledge for using Power BI effectively:
1. Data Modeling:
- Understand and utilize the star schema or snowflake schema for your data model.
- Use relationships wisely and create relationships based on appropriate keys.
- Implement row-level security (RLS) to control access to data based on user roles.

2. Data Transformation:
- Leverage Power Query Editor for data cleaning, transformation, and shaping.
- Master the M language for advanced data transformation tasks.
- Use the query folding feature to push transformations back to the data source for better performance.

3. DAX (Data Analysis Expressions):
- Develop a strong understanding of DAX functions for creating calculated columns, measures, and calculated tables.
- Optimize DAX formulas for better performance by avoiding complex or redundant calculations.
- Use DAX variables to simplify and optimize your formulas.

4. Data Visualization:
- Design visually appealing and effective reports and dashboards.
- Utilize custom visuals and explore the Power BI marketplace for additional visualizations.
- Implement drill-through, drill-down, and drill-up functionalities for interactive reporting.

5. Performance Optimization:
- Optimize data models for better performance by removing unnecessary columns, tables, and relationships.
- Use incremental refresh and partitioning to handle large datasets efficiently.
- Monitor and optimize the performance of DAX calculations.

6. Power BI Service:
- Publish reports to the Power BI service for sharing and collaboration.
- Implement scheduled refresh and keep data up-to-date in the Power BI service.
- Explore Power BI apps for content distribution and management.

7. Advanced Analytics:
- Integrate machine learning models using Power BI's integration with Azure Machine Learning or other platforms.
- Use the Analytics pane for quick insights and trend analysis.
- Leverage advanced statistical functions available in DAX.

8. Customization and Extensibility:
- Customize themes, colors, and formatting to match your organization's branding.
- Explore and implement custom visuals and integrate them into your reports.
- Use Power BI REST API for automation and programmatic interactions.

9. Security and Compliance:
- Implement role-based access control (RBAC) in the Power BI service.
- Understand and comply with data governance and compliance features.
- Stay informed about Power BI security best practices and updates.