Course:

Power BI with Microsoft Certification (PL-300)

Course Duration:

Class room training: 100 hours
Online training:         50 hours

Fee Details:

Course Fee: ₹ 10,000

  FREE Advanced Excel Course

  50% FEE Offer MYSQL RDBMS

  FREE Placement Registration

* Conditions Apply.

  Microsoft Certification
      Microsoft Power BI Data Analyst
      Exam Code: PL-300
      Cost: Rs 6000*

      * Exam Cost of Microsoft Certified: Power BI Data Analyst Associate may change.

  Sinet Certification
      ISO 9001 2015 logo embossed
      with Online reference.
      Cost: Free

      Show Model

  Business Intelligence Analyst
  Reporting Analyst
  Data Visualization Specialist
  Data Analyst

  Junior Business Analyst

For more information contact now

8086 800 700
8086 800 700
sinetlimited@gmail.com

+91 9946 668 186
+91 04933 227 816

info@sinet.in

Why and How Sinet's Microsoft Power BI Training Help you

Unlock your potential with our Microsoft Power BI training in Perinthalmanna, Malappuram, Kerala. Our comprehensive course, offered with the benefit of Malayalam language support, ensures seamless learning for local aspirants.

Gain expertise in data visualization, business intelligence, and analytics, and unlock the best job opportunities in the industry.
With Power BI certification, enhance your career prospects and take advantage of the growing demand for data-driven decision-making professionals.

Our training program, tailored to meet local needs, equips you with the skills to thrive in Kerala's thriving analytics landscape.

Join us and leapfrog your career in business intelligence, leveraging the power of Power BI with Malayalam language support.

What are the benefits
of Microsoft Certified Power BI Data Analyst Associate certification (PL-300)
from Sinet Perinthalmanna, Malappuram, Kerala?

The Microsoft Certified Power BI Data Analyst Associate certification offered at Sinet Perinthalmanna unlocks a plethora of benefits for aspiring data professionals.

This esteemed credential enhances job prospects, accelerates career advancement, and boosts earning potential by an average of 15-20%.

By mastering Power BI, data modeling, and visualization, certified individuals gain expertise in extracting valuable insights and creating interactive dashboards.

This globally recognized certification holds lifetime validity, demonstrating expertise to employers and clients worldwide.

Additionally, it fosters local recognition within Perinthalmanna's thriving analytics community, opening doors to new networking opportunities and access to valuable resources.

By achieving this certification, professionals can significantly elevate their careers in data analysis and business intelligence.

Microsoft Power BI Course Contents

1. Introducing Power BI

Power BI introduction, installing power BI, comparison power BI vs Tableau, uses of power BI, basic components of power BI.

2. More About Power BI

Features of Power BI, benefits and advantages, Power BI desktop, service, Mobile apps, explain the role of reports, data and model views.

3. Connecting To Data Sources

Identify and connect to data sources, data collected to different sources.

4. Integration With Other Tools And Data Sources

Using analyze in excel features, exporting power BI data to excel, connecting with advance data sources.

5. Modelling The Data – Creating Relationship

Build the relationships, creating more relationships.

6. Transforming Data in Power BI

Basic transform, combine data and add column from example, dashboard creation from pre-existing report.

7. Data Modelling And Relationship

Importance of data models, build relationships (one to many, many to one), primary and foreign keys.

8. Visualization Of Data in Power BI

Introduction to visualization data, create interactive reports using slicer for filter, tabular data, categorical data, data trends and other features, visualizing goal tracking.

9. Advance Visualization

creating report (digital story telling), using power BI Q&A and excel integration, manually typing data table.

10. Filters And Slicers

Different types of filters visual, page and report level, adding different slicers and filters to report.

11. Advanced Tooltips and Bookmark

Using bookmarks for navigation and storytelling, creating customized tooltips.

12. Creating And Customizing Visuals

Customizing theme, customizing visuals(labels, colors, title),formatting reports and visuals for readability, interactions between visuals.

13.Power Map in Power BI

Mapping geographical data, exploring visualization options, working with multiple scenes

14. Power BI Hierarchies and Filters

Creating hierarchies in power BI, drill-down options, drillThru options and report, type of filters, TOP N filters.

15. Introduction To Power Query

Power query introduction, query editor, row transformation, data type and adding column, replace column, move and replace column.

16. Advanced Power Query

Advanced features in power query, Text & number transformations, date, time& structures data, merge and append transformation

17. Pivot Table in Power BI

Building pivot table on top of power pivot, using pivot chart

18. Introduction To Power DAX

Introduction to DAX, importance of DAX, step to create calculated column.

19. Authoring Power View Report

Create tables & metrics, from table to chart, interactive sorting, filtering & highlighting, working with bubbled chart, slicers, card and multiples, adding map with multi view reports.

20. Publishing And Sharing Reports

Step to publish reports, different between dashboards and reports, pinning visuals to dash boards, sharing reports and dashboards with others.

Microsoft Advance Excel Course Contents

1. Introduction and Formatting of Excel work book

Introduction to Excel interface, Understanding rows and columns, Naming Cells, Working with Excel workbook and sheets, New, Open, Close, Save, Save As, Formatting Text: Font Size, Font Style, Font Color, Use the Bold, Italic, and Underline, Wrap text, Merge and Centre, Currency, Accounting and other formats, Modifying Columns, Rows & Cells

2. Introduction to Excel Calculations

Creating simple formulas, Setting up your own formula, Date and Time Functions, Financial Function

3. Perform Calculations with Excel Functions

Logical Functions, Lookup and Reference Functions Mathematical Functions, Statistical Functions, Text Functions.

4. Sort and Filter Data in Excel

Sort and filtering data, Using number filter, Text filter, Custom filtering, Removing filters from columns, Conditional formatting

5. Create Effective Excel Charts to Present Data Visually

Inserting Column, Pie chart etc., Create an effective chart with Chart Tool Design, Format, and Layout options , Adding chart title , Changing layouts, Chart styles, Editing chart data range, Editing data series, Changing chart

6. Analyse Data Using Excel PivotTables and Pivot Charts

Understand PivotTables, Create a PivotTable Framework Using the PivotTable and PivotChart Create Pivot Chart from pivot Table. , Inserting slicer, Creating Calculated fields

7. Use Excel Scenarios

Use What-If Analysis Tools , Create Scenarios , Merge Scenarios , Create Scenario Summaries , Use Data Tables , Create Advanced Charts , Basic Excel Charts , Use Area, Scatter & Stock Charts , Use Surface, Radar & Combination Charts , Create Custom Chart Templates , Work with Sparkline’s

8. Protecting and Sharing the Excel Work Book

Protecting a workbook with a password, Allow user to edit ranges, Track changes, Working with Comments, Insert Excel Objects and Charts in Word Document and Power point Presentation

9. Advance Formulae and Functions in Excel

Create advanced formulae , Functions , Apply functions in formulae , Mathematical Functions , Financial functions , Useful Data Functions , Some Other Useful Functions , Look up data by using functions , Apply advanced date and time functions , Functions for Manipulating Text , Arrays

10. Apply Custom Formats and Layouts to Excel Work Sheets

Apply Custom Data Formats , Use Advanced Fill Options , Apply Advanced Conditional Formatting and Filtering , Apply Custom Styles and Templates , Use Form Controls , Prepare Workbooks for Internationalization , Use Outlines , Use Custom Views

11. Advance features in Microsoft Excel

Creating and Recording Macros, Assigning Macros to the work sheets, Saving Macro enabled workbook, Page setup, Setting print area, Print titles Inserting custom Header and Footer , Inserting objects in the header and footer, Page Setup, Setting margins, Print Preview, Print, Enable back ground error checking , Setting AutoCorrect Options

12. Advanced Excel Function implementation Project

Two-Way Lookup, Using Dropdown Lists as Lookup Values, Three-way Lookup, Getting the Last Value from a List, Partial Lookup using Wildcard Characters and VLOOKUP, VLOOKUP Returning an Error despite a Match in Lookup Value, Doing a Case Sensitive Lookup, Using VLOOKUP with Multiple Criteria, Handling Errors while Using the VLOOKUP Function

13. Manage and Share Excel Workbooks

Manage Workbook Versions, Copy Styles within Workbooks, Copy Macros within Workbooks, Use Track Changes and Comments, Merge Workbooks, Protect Workbooks for Sharing, Connect To External Data

* Each Session include: Faculty training, Lab Practice, Lab Exercises and Portal based assignments.
* Sinet Education reserved the right to alter the course contents, offers, price, certificates etc.