Power BI in 10 Hours

Learn Power BI — Essential Training

About The Course

What you'll learn

  • Data Visualization Techniques
  • Data Analysis Skills
  • Data Connection and Preparation
  • Dashboard Creation
  • Advanced Features of Power BI
  • Sharing and Collaboration
  • Best Practices and Tips

This course includes:

  • 10 hours on-demand video
  • 10 articles
  • 10 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Why you should Join Us ?

Key Features of Our Industry Expert-Led Training:

- Hands-on sessions prioritized over theory

- Theoretical aspects covered as needed

- Instructor-led sessions with ample opportunity for doubts clarification

- Industry expert-led training

- Limited students per batch

What is Power BI?

Power BI, is a Microsoft product which helps businesses to analyze data from different sources. With it, users can create reports and dashboards, share insights, and make data-driven decisions.

The Course Curriculum

- What is Business Intelligence?

- Overview of Power BI

- Component of Power BI

- Power BI Setup

- Power BI Environment

- Understanding of Data - Sample Super Store

- Connecting to various data sources (Excel, databases, web sources, etc.)

- Cardinality & Relationship

- Data modeling concepts

- Star Schema

- Snowflake Schema

- What is Dimension & Fact Table?

- Creating different types of visualizations

- Charts

- Row Card & Multi-Row Card

- Table Vs Matrix

- Customizing visualizations

- Formatting Visuals

- Adding Labels

- Custom shape creation

- Implementing advanced visualizations

- Teemaps

- Gauges Chart

- Custom Visuals

- Ribbon Chart

- Conditional Formatting

- Slicers

- Focus Mode

- Spot Light

- Sorting

- Format Painter

- Tooltip & Small Multiples

- Drill Down

- Visual Level Filter

- Page Level Filter

- Report Level Filter

- Cross-visual Filters

- Slicer Filters

- Hierarchical Filters

- Univariate

- Bivariate

- Multivariate

- Categorical v/s Numerical

- Numerical V/s Numerical

- Categorical V/s Categorical data

- Co-Relation

- Predictive Analysis

- Trend Analysis

- Placing Objects in Page

- Alignment of Charts

- Adding Custome Shape to complete Story

- Designing a Dashboard

- Placing Objects in Page

- Alignment of Charts

- Adding Custome Shape to complete Story

- Designing a Dashboard

- Placing Objects in Page

- Alignment of Charts

- Adding Custome Shape to complete Story

- Designing a Dashboard

- Placing Objects in Page

- Alignment of Charts

- Adding Custome Shape to complete Story

- Designing a Dashboard

Instructor Image

SONU PANDAY

Microsoft Certified Trainer - 1 Million+ Students

4.6 Instructor Rating
579,498 Reviews
1,823,172 Students
26 Courses

Summary:

  • Over 16 years of extensive experience in Data Analysis, Data Visualization, MIS Reporting, and developing macro systems across multiple tools.
  • Certified Tableau Developer with more than 9 years of expertise in Tableau Desktop and Tableau Site Admin.
  • Coordination at various levels to ensure timely project delivery.
  • Proven track record of initiating and implementing process improvement initiatives to enhance related processes.
  • Possess strong critical thinking abilities and communication skills, with proficiency in quickly grasping and utilizing new concepts effectively.

Overall Career Overview:

Experienced Tableau specialist adept at converting business requirements into impactful visualizations. Skilled in Tableau Server administration, performance optimization, and report publishing. Proficient in SQL queries across MySQL, SQL Server, and Oracle. Expertise in creating Data Lakes to centralize offline data management. Strong ability to define data flows and templates in Excel and MySQL environments. Knowledgeable in implementing user filters for row-level security (RLS) and proposing suitable visualization views aligned with KPIs. Proficient in Tableau features like LOD, Parameter, Sets, and Actions. Experienced in end-to-end automation of data and dashboard processes. Well-versed in training team members on new technologies and BI tools. Expertise in converting excel-based reports to BI visualizations and writing VBA Macros/Python Script for data preparation. Analyzes data requirements and designs visualization solutions to meet client needs. Skilled in data analysis and preparing ad-hoc reports.

Additionally, proficient in Python for data manipulation and analysis, including feature engineering, data mapping, data cleaning, and aggregation. Skilled in creating online platforms using Python, HTML/CSS, and JQuery for data file management with LDAP Authentication. Experienced in Exploratory Data Analysis (EDA) and assisting team members with machine learning algorithms for predictions. Utilized Python libraries such as Pandas, NumPy, Sci-Kit, Scikit-learn, OpenPyXL, and ldap3.

Certificate of Recognition:

  • Received SPOT Recognition Award for exceptional performance in project delivery.
  • Recognized with Certificate of Recognition for demonstrating cooperative and collaborative behavior.
  • Received a Thank-You Letter from the Head of Department for dedication, technical expertise, and successful implementation of new initiatives.
  • Peer Recognition for Outstanding Teamwork Contributing to our success.
  • Recognized by Peers as a valuable colleague.
  • Appreciated for Developing Macro Systems to streamline processes and increase efficiency.
  • Consistently praised by higher management for achieving 100% accuracy in dashboards and ad-hoc reports.

Areas of Expertise:

Data Analytics MIS Data Visualization Excel Power Query Power Pivot VBA Macros Python Tableau Power BI SQL

Professional Experience:

  • ScatterPie Analytics Pvt. Ltd. – Delhi, India
  • Ericsson Global India Ltd. – Noida, India
  • OTSi Pvt. Ltd. – Noida, India
  • Future Retail Pvt. Ltd. – Gurgaon, India
  • Overseas Outsourcing Solutions Pvt. Ltd. – Gurgaon, India
  • Salient Business Solution Pvt. Ltd. – Gurgaon, India
  • Tech Mahindra – Noida, U.P.

Professional Experience in Diverse Industries:

Retail (Apparels/Food Chain/FMCG/Footwear), E-Commerce, NBFC, Electric Vehicle (EV) Industry, Manufacturing.

Academic Credentials:

The highest educational qualifications include a Master of Computer Application (MCA) and a Master's degree in English Literature (MA).

Student Reviews

5.0

Total 3 Ratings

  • 5
    3 Ratings
  • 4
    0 Rating
  • 3
    0 Rating
  • 2
    0 Rating
  • 1
    0 Rating

A
Anonymous
1 year ago

This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.

A
Anonymous
5 years ago

This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.


Leave a Comment

Course Information

₹ 10000
  • Course level:
    Beginner
  • Instructor:
    Sonu Pandey
  • Lesson: 10
  • Duration: 10 h
  • Last Updated:
    Oct 17, 2024

Material Includes

  • Videos
  • Articles
  • Downloadable Resources

Requirements

  • Basic computer skills
  • Interest in Power BI

Tags

  • Excel
  • Advance Excel
  • Power BI

Target Audience

  • Beginners in Power BI
2024 © All Rights Reserved | Designed and Developed by NewAceAnalytics