+91 888 2233 777 
training@mercury.co.in 
MODES
Classroom
Skilled instructors, extensive hands-on lab exercises & state-of- the-art training centers create a powerful learning environment. Rooms are equipped with Dell projectors, large Promethean interactive whiteboards. Every student is provided with individual PC.
Live Online
Attend from the convenience of your office or home. Online courses feature all the benefits of live instructor interaction without requiring travel. All online courses include hands-on lab exercises – only a personal computer is required.
On Demand
On Demand is a robust, self-paced learning solution delivering modular training combined with hands-on practice labs, giving you a powerful alternative to traditional classroom training.
View Demo Video
CERTIFICATIONS
Want to be more efficient and get actionable business insights?
Don’t miss our Microsoft Power BI Training.
Join us for Microsoft Power BI Certification Training courses, see helpful demos, and learn from the experts on how to apply these practical tips and tools to your day-to-day data tasks. Explore the modules and features from Microsoft and transform your company's data into rich visuals.
Being a Silver Partner, Mercury Solutions excels in delivering worthwhile training solutions conducted by Microsoft Certified Trainers, who direct you to achieve the right expertise to necessary applications and technology that distinguish your competencies in a challenging business environment. Out prestigious learning partnership with Microsoft helps us become the most proficient partner in imparting the fundamental to most advanced knowledge with dexterity.
Learn how to work efficiently with your data and get actionable business insights.
ROADMAP
MCSA: BI Reporting
Overview
Earning an MCSA: BI Reporting validates a professional’s knowledge and skills relevant to data analysis, modeling, data visualization, dashboards, and direct connectivity to data sources in Excel and Power BI. This is the primary step to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE). During this training Students learn to analyze data with Power BI and Excel.
Prerequisites
- Basic Knowledge of Ms-Excel and SQL querying.
| Course Code # | Course Name | Exam Code # | Days |
|---|---|---|---|
| 20778B | Analyzing Data with Power BI | 70-778 | 3 Days |
| 20779B | Analyzing Data with Excel | 70-779 | 3 Days |
Overview
Analyzing Data with Power BI training and certification program from Mercury Solutions imparts skills, understanding and knowledge to analyze, visualize and report data using Microsoft Power BI. Power BI is a suite of tools for Business Analytics from Microsoft which enable professionals and corporates users to analyze data and get insights that can help in making proper business decisions.
This Power BI training covers latest tools to monitor business development and streamline functions to quickly get answers on any device through dynamic, interactive and rich reporting features and dashboards.
With Microsoft Power BI training course you can learn to connect and import your data, author reports, publish reports, create dashboards, and share with business users to utilize the business intelligence through the web as well as mobile devices.
Who Should Attend?
- Business Analysts
- Business intelligence developers
- SQL Professionals
- BI Professionals
- Data Analysts
Microsoft Power BI Benefits
Upon Completion of this Course, you will accomplish following:
- Understanding primary features of a self-service Power BI solution.
- Creating a Power BI desktop visualization.
- Implementing the Power BI service.
- Performing Power BI desktop data transformation.
- Describing Power BI desktop modelling.
- Describing how to connect to Excel data.
- Describing how to collaborate with Power BI data.
- Describing the Power BI mobile app.
- Utilizing Power BI and its data sources.
- Connecting directly to data stores.
- Describing the Power BI developer API.
- Combining, analyze, model, shape, and visualize data.
- Reporting data using rich dashboards.
Overview
This Training programs is meant to equip students with the ability to add BI techniques to Excel data analysis. The course goes beyond the abilities of creating tables, charts and using Pivot charts, the excel model and Power BI.
Audience:
- Students experienced with analyzing data with Excel and wish to add BI techniques.
- SQL Server report creators who are interested in alternative methods of presenting data.
Pre-requisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
- Knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
Analyzing Data with Excel: Benefits
- Explore and extend a classic Excel dashboard.
- Import data from a SQL Server database.
- Import data from a report.
- Explore and extend an Excel data model.
- Pre-format and import a .CSV file.
- Create measures using advanced DAX functions.
- Create a Power BI dashboard with Excel.
- Create data visualizations in Excel.