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

Our 70-hour Power BI certification training is designed for both freshers and working professionals to familiarize themselves with the most versatile data visualization tool, Microsoft Power BI. The course curriculum is diligently prepared by top-notch faculties who would also be guiding you through your journey towards mastering the essential aspects of Power BI. A few areas that our modules deal with include modeling with Power BI, creating hierarchies, DAX expressions, publishing and sharing, and so on. The post-training support that we offer is our forte. We are sure that the detailed curriculum and other features of the course included in this brochure would elucidate why you should go for a course with us!

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


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