ExcelR Jumbo PassExcelR Jumbo Pass Video   You May Have Heard About Offers, But Have You Heard Of ExcelR's JUMBO PASS? Well, Here's Your Chance To Avail The JUMBO PASS!! Watch The video

 
 

Course Description

ExcelR DevOPs training

Assignments & Case Studies

ExcelR DevOPs training

Real-life PowerBI Project

ExcelR DevOPs training

Job Readiness Program

ExcelR DevOPs training

Lifetime access to LMS

 

Skills Covered

Data Preparation

Charts

 

DAX

Dashboard

Story Telling

 

Why ExcelR

ExcelR DevOPs training

Industry-Based Course Curriculum

ExcelR DevOPs training

Seven Value Added Courses

ExcelR DevOPs training

Work Hands-on with 100+ Hours of Internship and 10+ Bootcamps

 

ExcelR DevOPs training

Guaranteed Job Interview Calls with our 2000+ partner companies

ExcelR DevOPs training

Support through WhatsApp, Calls, & Emails

ExcelR DevOPs training

Lifetime eLearning Access

 

Projects

  • Build a dashboard which demonstrates the patients summary under dialysis, hospital summary with rating and performance scores, filtered with respect to the chain organizations and hospitals over the period of time.as GitHub or with your own custom plugin. With AWS CodePipeline, you only pay for what you use. There are no upfront fees or long-term commitment
  • Build a dashboard which represents the loan amount status of the employees working under different sectors with a drill down approach to see the employee details across various regions and payment schedules.
  • Narrate a story using a dashboard that demystifies the employees' attrition rate working under the varied companies under different roles and departments with more details such as promotion, salary, job satisfaction etc.

 

Salary Comparison Data

Placement Process - ExcelR

 

Course Curriculum

  • Introduction to Power BI Desktop
  • Getting data (Excel and RDBMS, Web, SharePoint)
  • Naming for Q&A
  • Direct Query vs Import data
  • Introduction to Modelling
  • Set up and Manager relationships
  • Cardinality and cross filtering
  • Creating hierarchy in the model
  • Default summarization and sort by
  • Creating calculated columns
  • Creating measures and quick measures
  • Creating visuals
  • Colour and conditional formatting
  • Setting sort order
  • Scatter and bubble charts and play axis
  • Tool tips
  • Slicers, timeline Slicers and sync Slicers
  • cross filtering and highlighting
  • Visual, Page and Report level filters
  • Drill down/up
  • Hierarchies
  • Constant Lines
  • Tables, Matrix and Table conditional formatting
  • KPI’s, Cards and Gauges
  • Map Visualizations
  • Custom visuals
  • Managing and Arranging
  • Drill Through
  • Custom Report themes
  • Grouping and binning
  • Bookmark and buttons
  • Introduction to Dax (how to write Dax and basic functions in Power BI)
  • Important Dax used in Power BI along with its applications.
  • how to create calculated columns and measures in Power BI and difference in its application
  • Scenarios with Questions on Dax & explanation
  • Creating date dimension in Power BI using calendar functions and its importance
  • Sharing options
  • Publish from Power BI Desktop
  • Publish reports to Web
  • Sharing reports and Dashboards
  • Workspaces
  • Apps
  • Printing, PDF’s and exports
  • Row level Security
  • Exporting data from Visualizations Refreshing Datasets
  • Understanding data refresh
  • Gateways

Contact Our Team of Experts

FAQs

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence

Call Us