• Why Power BI?
• Why Industries use Power BI?
• How Industries use Power BI?
• Installation of Power BI Desktop
• Architecture, Components, and Flow 
• Date, Time and Complex Data Types

• Connecting to a data Sources
• Import, Direct Query, Live, and Composite mode
• Optimizing Data Models
• Modeling Data
• Manage Data Relationship
• The Power Query
• Introduction to Query Editor
• Data transformation –column formatting, transpose table, splitting, formatting data, Merge Join, relational operators, date, time calculations, and all the remaining functions available in Power Query.
• Query Editor in Power BI
• Combining Data – Merging and Appending
• Cleaning irregularly formatted data

• DAX Syntax
• Data Types in DAX
• DAX Functions
• DAX in Measures
• DAX in Calculated Fields
• How to use the CALCULATE() function
• Date and time DAX functions
• DAX Operators
• DAX tables and filtering
• DAX queries
• DAX Parameters

• Visuals in Power BI:-

• Area Charts
• Line Charts
• Bar Charts
• Column Charts
• Combo Charts
• Pie Charts 
• Doughnut Charts
• Gauge Charts
• Funnel Charts
• Scatter Charts
• Bubble Charts
• Tree Maps

• Matrixes and tables
• Slicers
• Map Visualizations
• Card Visuals
• Modifying colors in charts and visuals
• Shapes, text boxes, and images
• KPI Visuals
• Visualization interaction
• Drill down Visuals
• Hierarchies in Visualizations
• Power Q & A Visual - How to import? How to use it? When to use? Working

• Filter on Specific Visuals
• Filter on the full report
• Filter on all the reports
• Filters showing Top and Botton values on the visuals
• Customize filtrations
• Date and time filters
• Row-level security (RLS), static and dynamic
  
• Manage Roles 

• Reports in Power BI
• Customized reports with KPI, visuals, slicers, filters, cards.
• Buttons and Logos on Reports
• Reports Publish online
• Introduction to app.powerbi.com - How to use? When to use? Working?
• Pin visuals and reports for making Dashboard
• Customized dashboards
• Convert then into presentation, pdf, and on the web.   

• Connect data from the server
• Import in Power BI
• Visualize
• Dynamic Report
• Full Power BI Live project cycle
• Making Dashboards
• Work on Real-life Scenario

27 Hrs Week Days Training.

18 Sessions 1hr 30 min each. 

Open mic - At the end of the sessions learners can unmute and discuss anything regarding the Sessions, Data Analytics, BI, and more.

Screen Sharing - At the end of the sessions learners can take permission to share screens if they are facing major technical and installing issues. 

We believe in constant training with no breaks till the training will over for better concentration and learning.

The sessions will be held during the Week Days then you will get assignments to complete during weekends. 

You will get Trainers official WhatsApp Number and Mail id for constant support after the sessions, during Weekends, while doing assignments and working on Projects.

This training will be going to be full industry-oriented, you will get knowledge regarding the current market scenario and actual requirements.

How you can use the Data Analytics and Business Intelligence concepts in your current job profile, how you will get better opportunities by learning the latest technologies and tools. You will get the answers to all your questions.

Recordings of the sessions will be available after every live session. If you can't able to take sessions on the time you can access recordings.

In case of doubts, you are free to communicate with the trainer as per your time flexibility. 

No theoretical lectures.

We believe in full practical training where you will learn and execute learning at the same time. 

Join our live sessions will guide you on how you can do that.

You will get data of an E-Commerce Platform, on the top of that you have to analyze:-

• The overall Sales, Profit, Shipping cost, Returned order, No of customers, No of quantities sold
• Apply slicers and filers
• Map visuals
• Analyze top and bottom 5 countries giving the maximum sales
• Analyze why the orders are returned
• Analyze data as per the specific date, month, and year
• Design a dynamic report
• Publish it online

During this project, you will work on the data of your job profile and interest. Use all the data analytics and visualization on top of that data and make a presentation, after publishing the project online. 

You have to use the outcomes of 1st and 2nd project in the dashboard. 

You have to make a video explaining all the visualizations and data that you have used so far, which will help you to gain confidence and industry-ready.